Using Google Ads, you can market your brand to potential customers around the corner or across the globe. The Google Ads/Grow integration gives you a platform to monitor all of your Google Ads data and make effective marketing decisions.
How to Connect
Before starting, please collect your Dropbox username (email address) and password.
- Log in to your Grow account and click Add Metric. Select Google Ads from your list of data sources, then click the blue Connect button.
- It will ask you to sign in with your Google account.
- Once you have signed in with your account, you will need to grant Grow permission to access your Google Ads account.
- Go ahead and press the blue Allow button.
And that's it! You are good to go.
Building a Metric
To help get you started in using Google Ads, here's a quick tutorial for building a metric that measures the cost per click in the last 7 days.
Here is another example that shows how to build a metric showing conversions and the average cost per conversion from one of our dataset playbooks:
Google Ads offers two main report types in Grow: Adwords Reports and Custom AWQL. If you want to use AWQL to query your data, choose the second option. You can reference the help doc on AWQL from Google Ads for help writing it.
The report Adwords Reports returns a lot of reports. You can find a complete list of the available reports here. The most frequently-used reports are Account Performance, Campaign Performance, Ad Group Performance, and Ad Performance. A description of these is given below.
- Account Performance: returns statistics at the account level.
- Campaign Performance: returns statistics aggregated at the campaign level.
- Ad Group Performance: all statistics aggregated at the ad group level.
- Ad Performance: returns the data aggregated at the ad level.
When building a custom metric, there is a Columns selection that lets you segment the data that comes in for any of the reports. The columns available are different segments that are also available within Adwords. You will need to select the columns you want to have the data for before Grow will pull data.
If you want to see a description of the available segments for a specific report, first go to the list of reports, then select your report. In the table, click the title of the report in the left-hand column. This will bring up a list of all of the segments available. To see the description of a particular segment, click on it from one of the lists on this page.
FAQs + Tips and Tricks
Divide Cost by 1 Million
Google Ads API data gives monetary amounts in micro cents. This means that for any money values, it will need to be divided by 1 million to get the value in dollars and cents. Fortunately, Grow has added a column that automatically converts the most common currency fields to standard dollars for you.
Can I See Which Ads Are on the Display or Search Networks?
If you add the
Network column to your data, you can see the data separated by the
Display Network, or
Segmenting your data
For pre-built metrics, it allows you to segment what data comes through by campaign, by Ad group, and then by keyword. You must select a campaign to select a group, and similarly select a group in order to choose a keyword to segment on. If you leave these fields blank, the pre-built metrics will return data for all of your campaigns and groups.
How do I use AWQL?
If you know AWQL, this can be a great option for combining data and fields from different reports. Google provides more information at this article here for writing AWQL.
Error: Invalid field selected
Google Ads can be very particular, especially in selecting columns. Certain fields don't work with other fields, and oftentimes this is very specific.
For example, if you get this error in Grow: Error: Invalid field selected. Please review your query and try again., it probably means you are trying to use two fields or columns together that Google Ads doesn't support.
The best way to check this is to read the documentation Google provides here. To find a specific field, you can either use the finder in your browser, or there is a list of the fields on the right side of the page.
How do I include the current day using AWQL?
The AWQL syntax for
DURING+LAST_30_DAYS+ does not include the current day.
To include the current day you can use the Date Interpolator and do
Using the Geo_Performance_Report
The Geo_Performance_Report does give you the location data, but the Google Ads API doesn't include the location names, just a code. You can download a CSV from Google that that you can join to the Geo_Performance_Report to get the names.
- Go to https://developers.google.com/adwords/api/docs/appendix/geotargeting and download the CSV shown at the top left (i.e., "
LATEST .CSV (2019-08-14)").
- Then add a new report in your Grow metric using "Excel/CS Upload" and upload the CSV file.
- Add a Joined Report using the
Regionif you just want the state) from Google Ads and the
Criteria IDfrom the CSV you uploaded. This will give you the city name, and country code for each location. (See screenshot below)
- You can then remove the columns with the numerical codes that you don't need anymore (e.g.,