Below are some of the most common errors you might come across when using GAQL Fetcher, along with solutions to help you fix them.
1. Request Failed
If you see a request failure error, try these steps:
Make sure you can access the Google Ads account(s) you’ve entered and that you can get data from them.
Use the Google Validator to check for any problems with your query format.
3. Test your query using gaql.app, a tool by TrueClicks, to make sure it gives you the right results.
An example of what the GAQL.app output might look like for your Google Ads data.
2. Enter a Valid Customer ID
Make sure you’re entering Google account IDs in the correct fields and that they’re formatted correctly:
Here's a quick guide:
Incorrect formatting: ❌
Correct formatting: ✅
3. Time-out Error
The Google Sheet add-on has a hard execution limit of 45 seconds.
Unfortunately, the error message won’t say it's because of a timeout. However, if you get an error after 45 seconds and none of the other issues apply, it's likely a timeout.
To fix this:
If you have multiple columns enabled, run them one by one by clicking the run button next to each. Wait for the query to finish before running the next one.
If you have only one column but many Google Ads accounts listed in row 4 and beyond, reduce the number of accounts so they can all run within 45 seconds.