Setting up a Google Ads report
Learn how to build a Google Ads report in Rows
In 1998, Google was founded and a revolutionary way to search the web came to life: at the time, conventional search engines used to rank results by counting how many times the search terms appeared on the page. Google theorized about a better system that analyzed the relationships among websites: needless to say, in a booming market, better results to users meant an incredible opportunity to deliver the right message to the right audience.
One year after the foundation, Google launched Adword the first attempt to convert the search revolution into an advertising revolution. Today, Google Ads is the first source of revenue for Alphabet Inc, contributing US$168.6 billion in 2020.
In this short guide, we’ll walk you through everything you need to build a dynamic Google Ads report, that pulls data directly from your Google Ads account into your spreadsheet.
Here’s a sneak peek at what you will get:
As the world’s top search engine, it’s no surprise that many marketers promote their businesses with the help of Google Ads.
To help you handle Rows
ANALYTICS_GOOGLE() functions, let's go through some key definitions about Google Ads.
There are 3 main layers in every Google Ads structure: the account, campaign, and ad group.
- The account. This is associated with email and password and used to set up billing details
- The campaign. At this level, you set up the budget and determine where your ads appear. Each campaign will contain ad groups, which in turn contain keywords that tie to your text ads and direct to your landing page
- The ad group. It contains a set of similar ads and keywords, words, or phrases describing your product or service that determine when and where your ad can appear.
To understand how we’re going to build it, let’s go step by step.
To start, you need to enable the Google Analytics integration that will allow Rows to pull data from your Google Ads account.
Click on the Connect button and follow the instructions. The Google Auth page will open: enter your Google credentials and authorize Rows to retrieve your data.
Now you are ready to build your report. Click on the Create spreadsheet button at the top of your dashboard.
Once you land on your spreadsheet, first of all, rename it: click on its title in the top left corner and type the new name. Use it also as a title for the first page, by pasting it on the page title. It'll be easier to find it later on.
Rows allows you to have multiple tables on the same page, giving you a neat view of your data. Select cell A1, and hit Actions in the toolbar. Look for our
ANALYTICS_GOOGLE() functions: many are available, depending on your ultimate goal, such as:
For the purpose of this guide, we will choose to retrieve data from campaigns and use Rows'
AD_CAMPAIGNS_ANALYTICS_GOOGLE() function. On the right-hand side of your display, the function wizard will show up. At the top, you can see the name of the integration you turned on in the first steps of this guide.
Let's go through the wizard together:
- Id. Pick your profile Id from the drop down list
- Date range. Use it to filter your data within the specified timeframe
- Set campaign. Use it to display campaign-specific data
- Set metrics. These are the key metrics you want to display in your report, such as pageViews, session, Average time on page, etc. To know more, please have a look at Google metrics and dimensions explorer
Clicking on the button Next step, Rows will guides you through the creation of the output table, to display all data retrieved from the integration. Choose the table headers from the first dropdown, i.e. 'campaign name', 'impressions', 'clicks', 'CTR', 'CPM', 'CPC', and hit Create Data Table.
You can rename the table's columns by simply double-clicking on the column titles and following the instructions in the pop-up. In case you need to reorder or remove some of the table's columns, just click on the ... icon in the table's top right corner and drag and drop the headers in the right-hand side wizard.
To make your report shine, add a bar chart to compare the main cost metrics across different campaigns, such as CPM and CPC. Select the whole Campaigns data table, then use the Insert menu and hit Chart. A chart will be displayed below the last table: using the usual ... icon, you can customize it - adding or removing series, titles, and colors
If you followed all the above points, you now have a summary table showing aggregated metrics for each campaign run in the selected time frame. You might also be interested in having a focus on how single keywords performed in the same time span. Let's build it together!
Select a cell in the first table, then hit the Actions menu and select our
AD_KEYWORDS_ANALYTICS_GOOGLE() function. To configure it, as we did before, pick your ID and the time range. As we want to have an aggregate overview of the keyword performance, we should not filter for any specific campaign, ad group, or keyword.
We follow the same procedure described above, and what we obtain is a list of keywords with their respective KPIs: CPM, CPC, and CTR.
Finally, if you are using Notion or any other internal tools that support iframes to build a report, you can embed any table or chart of this spreadsheet in your document. Just click on the ... icon in the top right corner of the table and pick Embed. A modal will open, as follows:
Before embedding any table or chart of a spreadsheet, you need to grant access to it. Follow the yellow message, and toggle on the Share privately option in the Share tab, as follows:
Once the spreadsheet's sharing option has been enabled, you just need to hit Copy URL from the Embed tab and paste the link into your document.
This is how Rows embed looks on Notion: