Welcome to your guide on integrating Google Ads data into Looker Studio (formerly Google Data Studio). Upon completing this tutorial, you will have mastered the essential steps to visualize and analyze your Google Ads marketing data using Looker Studio's dynamic dashboards.
If you're new to Looker Studio, the first step is to set up an account. Simply use your existing Google account to sign in and get started.
Let's begin the process of syncing your Google Ads data with Looker Studio.
If it's your first time connecting to this connector, you’ll need to grant the necessary permissions.
Next, you'll integrate Catchr with your Google Ads:
You've successfully connected your Google Ads account to Looker Studio!
With Catchr's integration to Looker Studio, you now have access to a wide range of metrics from your Google Ads account. For an in-depth look at the available metrics, explore the detailed listing provided by Catchr here.
Imagine visualizing the percentage of ad impressions ranking at the absolute top of searches with the "Impr. (Abs. Top) %" metric or analyzing demographic insights with "Age" and "Gender" metrics. The opportunities are endless, whether you're gauging the performance of keywords, scrutinizing the average cost for viewable impressions, or understanding user interactions across networks.
Take, for example, the "Active View avg. CPM" measure; you can interpret the average cost of your visible advertisements and better optimize your spend efficiency. Or perhaps the "All conv. rate," a crucial KPI indicating click-to-conversion success rate, which is pivotal in measuring campaign effectiveness.
Using Looker Studio's varied chart types, from time series to bar graphs, you can bring these metrics to life. Customize and correlate data based on particular campaigns, ad groups, or specific keywords. Track trends, compare performance metrics over time, and generate actionable insights to optimize your marketing strategies.
The compatibility of Google Ads with Looker Studio offers you a reliable and insightful means to steer your campaigns towards desirable outcomes.
From your data source page, click on Create Report at the top right.
You created a report with your data source attached. You can find the data source fields list in the far right panel.
This is your canvas. It's here that you will place charts and create your dashboard! You can have a detailed explanation of this interface in this article.
The first thing to do is to choose which KPIs we want to use:
And we will breakdown with some dimensions:
Now we can start creating our report.
Add a Scorecard:
We can start adding elements to the report. We'll begin by displaying a Scorecard for each chosen metric:
Copy and paste this Scorecard and repeat the operation for each metric.
Once every Scorecard is displayed, align them all:
Add a table:
We will create two tables to display our performance by Campaign and AdGroup:
Once all the metrics are added, copy and paste this table and change the dimension to the Ad group name.
Add a GeoChart:
Adding a map to our report is a great way to visualize the repartition of your ads performance :
Geo Charts can only display one metric at a time, but you can use the Optional metrics option to quickly change metrics in view mode.
Change dimension and metrics for your GEO Chart
Add bar chart:
For the Gender and Age breakdown, we will use a bar chart. It's a great way to analyze your audiences quickly:
For example, you can explore the style options to modify your bar chart to display horizontally.
Add control fields:
To finish the data part of this report, we need to add some control fields. Control fields will allow viewers to modify the selected date range and apply filters on dimensions like the Campaign Name, etc.
Now we will add a dropdown list to select only the wanted campaign. Once active, all the pages will automatically adapt to match the filter.
Try to click on it to check how it works! And explore the other control fields. For example, you can find filters via text, fixed size select box, etc.
Color and size
Now that everything is displayed, we can modify the style of this report.
First things, you might feel that this report is too small:
Then go back to Theme. Here you can choose a pre-made theme to change the color of your report's components quickly.
Title and text:
You can use a text box easily to add some titles and informative text about your performance:
Explore the Style options. You can change the font color and size, add borders and shadows, and create the perfect text box for every situation.
Add an image:
You can add some images to your report. For example, try to add your logo or your client's logo.
You are the owner of this report now. You can share it easily with the Share button at the top right and manage which role everyone has:
You'll find a detailed article on how to share your report here.
To save some time, you can use a template report. You can copy it with one of your data sources and have an already-styled report where you only need to adapt the KPIs.