Blending data with Ad Data + Google Analytics

This guide will walk you through how to use the Ad Data + Google Analytics connector for Google Data Studio, to combine and compare your data across your advertising channels.


If you haven't authenticated the connector yet, please see this guide:

How to Authenticate/Re-authenticate Ad Data + Google Analytics »



Data sources & fields

Find a list of all available dimensions and metrics for the connector in our documentation:

Ad Data + Google Analytics Field Reference »


The Ad data + Google Analytics connector was custom built to report on a selection of comparable KPIs over a set of the most common data sources. Therefore it doesn't have all the fields that are available in the single connectors of these data sources. 

In our documentation, the available fields are categorized based on the data source:


Ad network

  • The data from these fields comes from your advertising accounts. Use these dimensions and metrics to get ad campaign data from different advertising platforms.

Google Analytics & Google Analytics Goals

  • These metrics get data from your Google Analytics account. They contain key metrics for analyzing your website traffic and goals.

Ad Network + Ga Joins

  • These join dimensions combine data from your ad network and Google Analytics. Using UTM and demographics data, combine and analyze data from ads and website analytics.


Split metrics by data source

To easily compare your advertising data, use the dimension Data source and select dimensions or metrics from the Ad network fields.


Blending data with UTMs

With the join fields available in the connector, you can easily combine your Ad network and Google Analytics data by using UTM codes.

When you create your ad campaign, set the UTM attributes to track where your website data is coming from. This is an example UTM tracking code with values set for utm_source, utm_medium, utm_campaign and utm_content, all of which can be used with the Ad Data + Google Analytics connector:

utm_source=facebook&utm_medium=cpc&utm_campaign=tofu-2020&utm_content=missing-out
  • Note – the Ad Data + Google Analytics connector only takes into account traffic from utm_medium=cpc when blending ad data with Google Analytics. This is due to the connector combining PPC ad data from multiple platforms, to make sure the website data is accurately comparable. Data from other mediums such as social or email are not taken into account.


In this example, the Source (utm) join field is used to simultaneously look at ad network and website data.


Clicks

All click-related metrics in the Ad Data + GA connector only take into account link clicks. This is to make sure clicks and costs across PPC campaigns on different ad platforms are accurately comparable.


Conversions

With the Ad Data + Google Analytics connector, you can directly compare your ad platforms conversions with the Website conversions metricThe connector only takes into account website conversions to make sure conversions are comparable – conversions defined as specific actions within the ad platform, e.g. getting a new follower from your Tweet, will not be calculated.

  • For example, In Facebook Ads Website conversions includes all Standard Events conversions which happened on your website – e.g. Website Leads and Website Checkouts initiated. In addition all Custom Conversions you have set up to be tracked on your website with your Pixel will be calculated to the total Website conversions.

Costs and currency

All cost-related metrics use the same currency you have selected in the advertising platform.

Changing the currency of an existing ad account is not possible in any of the advertising platforms supported in this connector. If you use different currencies in your ad platforms, you will need to create new ad accounts with the same currency selection to be able to compare cost metrics.






 

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.