Introduction
Use the GAQL Fetcher add-on to run GAQL queries and fetch data for Google Ads accounts quickly. Follow these steps to get it done.
Using the Add-On
Open the add-on
Fill in the template with your GAQL queries and the account(s) you want to run it for
Open the GAQL Fetcher to access the "Run" buttons
If multiple columns are enabled, choose between "Run all" (dark blue arrow) or running columns one by one (light blue arrows)
Start with "Run all" for faster execution
If the 45-second timeout limit is exceeded (see troubleshooting), run the columns one by one
View results
If everything works as expected, new sheets will be created using the name(s) from row 3, containing the data fetched for the account(s) in row 4 (and beyond) and the GAQL query in row 2
Important: Existing sheets with the same name will be overwritten.
The Refresh button
Use the Refresh button to update the list of reports on the right side of the menu.
Press it whenever you add or remove reports in the sheet to make sure an up-to-date view of all available reports.