Create a connector for Google DataStudio

AJLaPorte_diagr

You should create a connector for use with Google's DataStudio Application. This would help us create a more robust report for our users and we can leverage the statistics that HubSpot provides. Currently, other services like Databox can connect to HubSpot to pull statistics from a portal to create dashboards. I think opening this up to DataStudio will really help marketers and agencies with providing all the data they need. 

HubSpot updates
Status updated to: Not Currently Planned
Sep 30, 2020

Hi everyone,

I’m Collette, one of the product managers for HubSpot’s Strategic Integrations teams. After looking into Google Data Studio earlier this year, we decided not to go ahead with it right now.  This is not to say that this idea will never be developed, just that there are no plans to do so at this time. Please check the apps in our marketplace that do integrate with Google Data Studio right now https://ecosystem.hubspot.com/marketplace/apps/all-categories?eco_integrations=Google%20Data%20Studio&eco_search=data%20studio

May 29, 2020

Sorry about that! You should be all set now. 

Status updated to: Being Reviewed
May 28, 2020

Hi! We're considering a potential integration between HubSpot and Google Data Studio.  Please fill out this form so we can learn more about what you'd like to see from this integration. 

Status updated to: Not Currently Planned
May 4, 2020

Hi everyone! 

Thank you so much for sharing your feedback and use cases! Unfortunatley, there aren't any plans to add a native integration between HubSpot and Google Data Studio right now. We really appreciate the feedback and encourage you to keep sharing your use cases in case our roadmap changes. 

Status updated to: Not Currently Planned
Apr 13, 2020

Hi everyone,
I’m Davis, the product manager for HubSpot’s attribuiton and marketing reporting tools.
At this time there are no plans to develop this Idea.
This is not to say that this idea will never be developed, just that there are no plans to do so at this time.
Sincere regards,

Davis

83 Replies
lucasfmsarmento
Participant

Please! Make this happen!

ondukwe
Participant

Great idea. GDS would definitely help with the reporting on our end. 

chris_molloy
Participant

Great idea. I'm not sure if it will happen because Google also needs to be willing to maintain the connection from my understanding and they don't even do this for the major social media networks except for YouTube which they own. A workaround we are looking at currently is to use an ETL integration like Adverity. It's a ncie solution and their core business is connecting data so it's always improving and being maintainted. Here's a link if you're interested - https://www.adverity.com/data-connectors/other/hubspot-api/ 

Uthoocha
Member

We use a solution that uses free code on the internet to pull data out of Hubspot via the api into multiple gsheet workbooks. We then connect Data Studio to the gsheets. It was a bit tricky to set up, but we really like it. You need to have some scripting skills to use the Google app script and then edit it to your requirments. But once it's done you can set it to update ever 15 minutes and it runs our company dash board perfectly, with other KPI's from Adwords, Google Analytics all on the same page.

zpines
Member

Hi All - Great thread here. I wanted to also let you know Bedrock Data has a product (Fusion) that allows you to automatically feed your HubSpot data into an on-demand data warehouse, that can serve as an automated data source for Google Data Studio.

It's a paid product, but we have a free trial account you can set up if you want to try it out for free.

To try it out:
1. Sign up for a free account at https://fusion.bedrockdata.com/app-user/sign-up

2. Authenticate your HubSpot to feed in your HubSpot tables

3. Follow these steps to feed into Google Data Studio https://help.bedrockdata.com/article/836-connect-google-data-studio

AJLaPorte_diagr
Key Advisor

@zpines from the info on the Bedrock site, it looks like this is more for customer data to be transferred between places. Does bedrock pull analytic data like views, top posts, top blogs, and that kind of information?

zpines
Member

@AJLaPorte_diagr Thanks for checking it out! These are the specific tables we're pulling out of HubSpot today. They are listed here: https://help.bedrockdata.com/article/789-hubspot-connector-api-usage-overview

It includes Contacts, Lists, Companies, Deals, Deal Pipelines, Engagements, Content, Broadcast Messages. So some of the use cases are building reports around lead volume, status & outcome; pipeline; and sales activities.  

We will be adding support for the HubSpot Analytics API tables soon, which will open up a lot more data as well. 

Wannes_BBC
Member | Gold Partner

This would be great! I would already be happy with the possibility to schedule automated data exports of custom reports to Google datasheets...

namujg
Member

yes Please! this would be amazing!

RichardBondDT
Participant

 Very useful, especially for other departments or SLT who don't dwell in HS daily.


R

 

AJLaPorte_diagr
Key Advisor

Just wanted to give a heads up to people on this thread. Supermetrics is developing an HS connector. What the details are I am not 100% sure but just got this from the today when tweeting them:

 

supermetrics-connector.jpg

 

https://twitter.com/Supermetrics/status/1090634952948047873

 

 

AlexHutson
Participant | Partner

Awesome news @AJLaPorte_diagr !

 

Thanks for the heads-up 🙂

Vannesa
Member | Diamond Partner

Yes, please! I would be great and make reporting easier. 

Concept
Member

Absolutely love this idea.  It would take away alot of manual labor

henrietta
Member

This would be amazing! I've used the API to get contact and deal information into data studio but I really want to be able to pull activity data too and it's starting to get silly with development costs (I am not a developer so must outsource)

 

A connector would save me both time and money as I have to keep waiting for work to be completed when I have something new I want to bring into data studio.

 

Would be awesome if I could bring campaign stats into data studio too.

pdavis
Participant

Yes PLEASE!

JDUnymira
Participant

Another vote for having a data studio connector

jadakiss
Member

For the love of God, it's 2019, please do this!

RichardBondDT
Participant

Super useful for more customised reporting, find the reporting dashboards potentially problematic in showing granular or specific, easily manageable data for multiple users.

 

Having raw data to display and chop us and digest as we like in ways which work for all SLT would be great.

 

Kauri
Participant

Hey HubSpot, is anyone working on this?