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.
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/
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.
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.
@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?
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.
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:
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.
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.
