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: Put client data together to show total results
Cross-Account Analysis: Combine account data to find patterns you’d miss alone
Budget Allocation: Use combined data to split shared budgets better
Competitive Analysis: Compare your accounts to competitors (if you can) to find opportunities
Large-Scale Analysis: Combine lots of account data to find big trends