Google’s free tool for creating visual reporting dashboards, Google Data Studio, natively connects to other Google products, like AdWords, Analytics and Google Sheets.But importing data from other sources using Google Sheets isn’t always elegant, or a comprehensive solution. On Wednesday, Google introduced a beta for third-party connectors. Supermetrics is among the launch partners.
Users can find the new options in the Data Studio Community Connectors Gallery.
Ginny Marvin was able to demo the Supermetrics connectors last month. The native connection allows data from the 20-plus marketing platforms Supermetrics connects with, like Bing Ads, DoubleClick, Facebook Ads, LinkedIn Ads, Twitter Ads and Yahoo Gemini, to be brought into Data Studio seamlessly.
Users will be able to connect multiple accounts in a channel and set a default conversion window when connecting to other channels. The following image looks at the Facebook Ads connector from Supermetrics, which is a paid service and requires a license.
With this connection, reports will be able to blend paid and organic reporting from social channels, as an example, with data from Google Analytics to get a fuller picture of campaign performance. Or make it easier to show paid search performance from AdWords and Bing Ads side-by-side. Supermetrics’ own Google Analytics connector also has an option to avoid sampling.
The following image is a sample of one of the Supermetrics templates for Google Data Studio that shows campaign data from AdWords, Facebook, Twitter and Bing Ads.
After the third-party connection is made, the process for creating reports is the same as when using Google data sources.
Along with this new beta, Google has added the ability for users to embed interactive Data Studio reports on their websites. Select Report > File > Embed report, then put the HTML code snippet into an iframe. Here are some other recent updates:
- The ability to export chart data directly to Google Sheets
- A new Google Cloud Storage connector
- SSL support for the MySQL connector Ability to see the totals in the table visualization