Floodlight variable queries can take longer to process. Use these steps to keep them running smoothly. They also help if you see one of these messages:
Query is stuck and progress bar halts
Timeout errors
Query failed: Results not ready yet
These happen when an account has a large number of advertisers attached to it.
To fix this in Google Sheets or Excel, create a filter that filters for Advertiser, using either the Equals or Contains operator. For example, “Advertiser EQUALS ExampleName” would return data for only that advertiser.
Date range errors
Queries that include Floodlight fields can pull up to a maximum of the last 60 days of data. Longer date ranges will result in errors.
To fix this, adjust your date range to 60 days or less.