Open a new sheet & activate the add-on
To use the GAQL Fetcher template, open a new Google spreadsheet and click the TrueClicks icon on the right (assuming you have installed the add-on):
โ
Then, click on "New Template" to generate the required columns in the current sheet:
The new template sheet has two columns (B and C) as placeholders for two reports. You're free to edit these as explained below.
Leave column C empty if you only need one report.
Rows 2-4 (and beyond) are necessary for successful report creation. Please ensure the information is correct to avoid errors when running the query. Where it says "Enter your Google Ads account," you should enter the Google Ads customer ID(s) using numbers only.
Create your first query
When you open your new template sheet, you'll see default queries in cells B2 and C2.
You also notice placeholders in rows 3-6. Let's go through them one by one.
Row 1: ENABLED
The add-on will only run for columns that say "ENABLED" in row 1. So if you're not ready yet to run the query for the account(s) in a specific row, please remove the word "ENABLED."
Row 2: GAQL query
Row 2 contains the GAQL query that retrieves data from your Google Ads account(s). You can learn more about Google Ads Query language here.
After understanding the GAQL query structure, you can use Google's query builder to create your query.
Row 3: Report name
The report name in row 3 is the sheet name created after running the GAQL query (in the same document). We recommend choosing a name related to the corresponding GAQL query.
Row 4 (and below): accounts
In rows 4 and below, you can enter the Google Ads account IDs from which you want to retrieve data. Please enter the IDs without the "-". So 1234567890 instead of 123-456-7890
Use cases with multiple account IDs
Entering multiple account IDs for the same query allows you to combine data from multiple accounts.
Note: once you import the data, each row includes a column with the account's Customer ID, making it simple to identify which data belongs to which account.
This is useful for the following use cases:
Agency Reporting: combining data from multiple client accounts can help agencies generate comprehensive reports that showcase the performance of all clients in one place.
Cross-Account Analysis: combining data from multiple Google Ads accounts can help you identify patterns and insights you may have missed by looking at each account separately.
Budget Allocation: combining data from multiple accounts that share a budget can help optimize the budget allocation based on their performance.
Competitive Analysis: combining data from your accounts with data from your competitors' accounts can help you better understand the market and identify growth opportunities (assuming you have access to competing accounts).
โLarge-Scale Analysis: If you have many accounts, combining the data can help you identify trends and insights that may need to be apparent when looking at individual accounts.