Google is building a great ecosystem of free and paid connectors for Data Studio. As of this writing in September 2020 there are more than 240 data studio connectors available. We’ve reviewed them and want to provide an overview of the data studio best connectors available. We’re focusing on the non Google connectors here as the Google connectors already with great documentation and are in general very reliable .
To make the navigation easy we split them into sections:
This connector pulls all information you need from the Facebook Ads API into Google Data Studio. Inside Google Data Studio the data can then be blended with your analytics or CRM data.
Bing Ads / Microsoft Ads
Similar to the Google Ads connector provided by Google this connector allows to pull performance data from your Microsoft Ads (formerly known as Bing Ads) account and visualise it in Google Data Studio.
This connector connects to your LinkedIn Campaign Manager account and extracts all metrics and dimensions to Google Data Studio. Similar as with the other connectors the data can either be shown in an own dashboard or it can be blended with Analytics data sets.
This connector connects your Salesforce CRM data to Data Studio. Unfortunately it does not allow blending of data between Salesforce and your CRM platform but it provides the basics you’ll need to visualise Salesforce data in Data Studio.
Similar to the Salesforce connector, this connector helps you visualise your Hubspot data in Data Studio. It does however not provide matching of customer journeys between analytics and CRM data.
Connects your Shopify data to Data Studio. As with the Magento connector, an additional added value of having this data present in Data Studio can be for data blending purposes. So instead of simply visualising the Shopify data on it’s own you can use Data Studios built in data blending feature to blend your Google Analytics e-commerce data together with your Shopify data and have a cancellation adjusted dashboard providing you useful insights.
In the above connectors I mention the data blending feature of Google Data Studio quite frequently. In certain instances when working with many different channels it can get to its limits. We built this Attribution connector which helps you to connect you all the marketing data you might have before they enter Data Studio. This could be analytics (Google Analytics, Adobe Analytics), media (Google Ads, Facebook Ads, Bing Ads, …), CRM (Salesforce, Hubspot, Marketo, …) or offline conversions data.
Build your own
If you need a data set available in Google Data Studio which does not have a connector you can develop one yourself (https://developers.google.com/datastudio). There is also an active community of developers on GitHub (https://github.com/googledatastudio/community-connectors) where you can find code examples to get started. If you don’t have the time or don’t know how just drop us a line here and we’re happy to help.
If you are an agency or an in-house media buyer chances are high that you will need at least one of the connectors mentioned above to get the Data Studio reports you want. In case you decided to go for one of the connectors above, you can get much deeper insights when you start connecting the data sets and blend the data. On their own they can be useful but blending the data is where the magic happens. In case you have a connector and would like to have it listed here, just drop us a note on the chat and we’ll be happy to add it.