For many marketers it’s very difficult to measure the performance of their advertising campaigns. It’s even more difficult for marketers or owners of ‘non E-commerce websites’. For example: in most social analytics you can’t see how many quotations (or any other Google Analytics conversion) a specific campaign has generated. With the help of a special Google Data Studio connector of Supermetrics it’s easy to make this kind of data insightful.
The Ad data + Google Analytics connector
This special connector is called: Ad data + Google Analytics connector. You can try this connector for free with the 14 days trial of Supermetrics. With this connector we are going to create a table with campaign data of Google Ads, Facebook Ads and Google Analytics combined. Just follow the steps below to create this powerful tool in your dashboard.
Advertising campaigns combined with Google Analytics data in one table.
Step 1: Choose the right connector
The first thing you need to do is selecting the right connector. Start with clicking on ‘Add data’ in the menu of Google Data Studio. Search for the following connector: Ad data + Google Analytics. You can find this connector at the section ‘Partner connectors. There are two requirements to enable the connector:
- You need to have a Supermetrics license
- You need to have a Google account
And of course to make use of the benefits, you need to have a Google Analytics property and at least one advertising account (like Google Ads, Facebook Ads, LinkedIn Ads etcetera).
Step 2: Select Google Analytics and advertising accounts
The next step is to select the right data sources in the options of the Ad data + Google Analytics connector. In total you can choose between six advertising sources:
- Google Ads
- Facebook Ads
- LinkedIn Ads
- Microsoft Advertising
- Twitter Ads
- Pinterest Ads
An example of selecting a Google Ads account in the Ad + Google Analytics connector.
Step 3: Create beautiful graphs and tables with this connector
In this blog we’re making the table which is shown in the first image of this blog. Of course this is an example, you can be creative and create your very own graphs and tables. To create the table we need to use the dimensions and metric below:
- Source (utm)
- Medium (utm)
- The goal you want to show in the table. In the example we used the metric: Goal 1 completions.
The needed dimensions and metris to create the table in the first image of this blog. Important: the metric ‘Quotations’ is not the real name of the metric. In our example it’s called ‘Goal 1 completions’.
That’s all to create a table which combines advertising campaigns from different sources with Google Analytics statistics. It can give you complex data in one eyesight.
Do you have many campaigns? Use filters to raise the ease of use!