Google Data Studio
Hello Pipedrive Community!
I am Menna from the Pipedrive team and trying to understand some of the main struggles you have when building reports using:
- Deal and contact data
- Product Data
- Filter by custom fields (Contacts. products. ..etc)
We are considering building a connector with Google Data Studio to satisfy some of those needs as our internal Insights solutions continue to evolve.
Does this resonate with you? Any thoughts you’d like to share? 😊📈
Comments
-
would be a nice Idea
1 -
Would definitely help to have the functionality and this would be a decent workaround. However, I'd much rather have it within Pipedrive rather than having to learn a new data analytics software. But better than nothing!
1 -
It's great idea for someone like me who is already experienced using data studio. I do agree that Pipedrive is lacking in the report building section. There is no reporting for the leads folder as far as I know.
2 -
Perfect news for a friday!
1 -
We are literally crying out for better reporting in Pipedrive so this would help massively!
3 -
Yes yes yes!!
Please reach out if you need beta testers
2 -
We struggle a lot with reporting on Pipedrive
lt should be easy to report retention, churn, conversion rate per period but it’s not.
we use google data studio and Google sheets so if exporting the data can be easy or visualizing it on pipedrive can be easy we would appreciate it
2 -
Pipedrive is missing the reporting capability big time, this will solve that problem. Really looking forward for this.
0 -
Hi Menna,
Great initiative. I am sure a connector with Google Data Studio would help visualize our numbers and performance better.
Some struggles we have with your reports today:
- I recall that conversion and deal velocity from one sales stage to the other can only be accurately reported for closed deals. Assume you work with long sales cycles, and deals may not be closed in the next 12-18 months. Any initiatives to improve the above two metrics will have an impact close to today. Yet, it will only be shown in the reports when the deal gets closed. Maybe 12-18 months from today.
- I also remember that Pipedrive does not allow proper reporting/filter of revenue from specific products assigned to a deal. Hence, it is not possible to get a good overview of the sales performance of certain products.
- We cannot build filters to list all participants assigned to a specific deal. Whenever we select a deal property in filters, it will output the primary contacts only. It is a major obstacle to building effective mailing campaigns with Pipedrive.
- Finally, it'd be good to be able to report the then-current value of certain key results or fields on a specific day. I.e., to answer questions like the sum of the value of all deals in a certain stage on a particular day and which deals were included?
I hope this helps.
Cheers,1 -
This would be fantastic! Product data would be the main thing - hard to review anything without this.
1 -
YES YES YES. This would be very beneficial and would fit in nicely with my other dashboards that I have with Data Studio.
1 -
Yes please! Very much like to echo everyone else's comments in that this would be a great asset for Pipedrive (along with custom reports and forecasting for advanced members). As an SME reporting and forecasting is so important to help us grow into the MME space. Unfortunately, we are caught between the memberships as the next upgrade from Advanced to Professional is a significant step. Having access to these features at advanced would help support a decision to move onto the next plan proactively because the budget allows as opposed to 'we are unable to get full benefits'. Currently, Pipedrive does not grow with a company because it prevents full access to features which encourages and makes it easier for alternative systems to be sourced. Providing full access to features makes it harder to leave a system when you know it provides everything you need. Thanks PD!
1 -
We use integromat, google sheets & GDS to get the analytics we need. To have GDS integrated with Pipedrive would be highly beneficial for us.
Throwing this out there as well - we use integromat to send data from Pipedrive to AirTable, our database, and now with the new AirTable Interfaces feature (game-changer if you haven't seen it yet), we have dashboard/data vis with all our AirTable data that includes Pipedrive data.
If Pipedrive was to have integration with AirTable that would be pretty powerful no doubt for Pipedrivers using this stack/combo, or even provide a great option for Pipedrive users who aren't yet using a database yet.. or for those who find GDS too complicated and don't have in-house data-vis experts.
0 -
Adding contacts as a property to report on would help a lot!
0 -
This would be good, but there are some challenges:
I personally use ETL (Keboola) to extract data from pipedrive, transfrom them, and then put them into google data studio.
I think the most important thing is to give users the ability to choose and group/merge data (since you have multiple data sets - persons, deals, organizations, leads, activities..) based on IDs before sending it to the google data studio, where it is not so user-friendly to merge the data before visualization.
1 -
A GDS connector would be very useful!
1 -
Martin Pecha said:
This would be good, but there are some challenges:
I personally use ETL (Keboola) to extract data from pipedrive, transfrom them, and then put them into google data studio.
I think the most important thing is to give users the ability to choose and group/merge data (since you have multiple data sets - persons, deals, organizations, leads, activities..) based on IDs before sending it to the google data studio, where it is not so user-friendly to merge the data before visualization.
Hi Martin,
Are you open to an interview call to learn more about your needs on this topic?
If that is ok I'll send you an email.
Cheers,
0 -
Martin Pecha said:
This would be good, but there are some challenges:
I personally use ETL (Keboola) to extract data from pipedrive, transfrom them, and then put them into google data studio.
I think the most important thing is to give users the ability to choose and group/merge data (since you have multiple data sets - persons, deals, organizations, leads, activities..) based on IDs before sending it to the google data studio, where it is not so user-friendly to merge the data before visualization.
Hi Martin,
Are you open to an interview call to learn more about your needs on this topic?
If that is ok I'll send you an email.
Cheers,
0 -
Martin Pecha said:
This would be good, but there are some challenges:
I personally use ETL (Keboola) to extract data from pipedrive, transfrom them, and then put them into google data studio.
I think the most important thing is to give users the ability to choose and group/merge data (since you have multiple data sets - persons, deals, organizations, leads, activities..) based on IDs before sending it to the google data studio, where it is not so user-friendly to merge the data before visualization.
Hi Martin,
Are you open to an interview call to learn more about your needs on this topic?
If that is ok I'll send you an email.
Cheers,
0 -
Martin Pecha said:
This would be good, but there are some challenges:
I personally use ETL (Keboola) to extract data from pipedrive, transfrom them, and then put them into google data studio.
I think the most important thing is to give users the ability to choose and group/merge data (since you have multiple data sets - persons, deals, organizations, leads, activities..) based on IDs before sending it to the google data studio, where it is not so user-friendly to merge the data before visualization.
Hi Martin
Would you be OK if we had a call to learn more about this needs? We'd send you an email with the details if you agree.
Maria0 -
Yes, I'd definitely like a GDS integration please. It would be incredibly useful for reporting purposes.
1 -
@Menna Hanafy any updates on this?
1 -
Prasad Lingawar said:
@Menna Hanafy any updates on this?
Hi Prasad,
Unfortunately, we won't have our native GDS connector this year but you still can use other 3rd party connectors right now.
1 -
Graham Cox said:
Yes, I'd definitely like a GDS integration please. It would be incredibly useful for reporting purposes.
Hi Prasad,
Unfortunately, we won't have our native GDS connector this year but you still can use other 3rd party connectors right now.
1 -
Prasad Lingawar said:
@Menna Hanafy any updates on this?
Hi Prasad,
Unfortunately, we won't have our native GDS connector this year but you still can use other 3rd party connectors right now.
1 -
Prasad Lingawar said:
@Menna Hanafy any updates on this?
Hi Prasad,
Unfortunately, we won't have our native GDS connector this year but you still can use other 3rd party connectors right now.1 -
100% agree with what others are saying. I would love any connection point to get to the data directly instead of just exporting. I like the idea of connecting to Google Data Studio as this is a free software I already have. I have two other data sources & I am trying to get them all to map to any dashboarding software. Any help from others in this thread would be helpful. I like the insights but you can't do this on all data such as contacts/companies. I have some big plans for how else to use pipedrive besides a CRM.
1 -
Hi, any update on this topic?
1 -
Such a great idea straight from Pipedrive! Oh, great. That's what I call the right line of thinking. Make a free connector to something that already works. Don't try to make a second Google Data Studio and focus on the "Red Routes" of your CRM software.
Is there anything new after almost 70 weeks?
Or is there some sort of collusion between all those "paid connectors" (Zapier, Make etc.) and Pipedrive? Does Pipedrive prefer its partners to its own users? I can totally hear them: please Pipedrive, don't make a free connector for your users, then they won't need us and won't be forced to pay us regularly anymore.
0 -
I'm interesting also are any updates on this topic?
0
