A common hurdle in data retrieval is ensuring that the data you're seeking is actually available and accessible within the specified parameters. Avian's capability to return accurate data is contingent upon the presence of data that matches your query criteria.
If you request data during a time period that had none or for a campaign that doesn't exist, Avian will likely return an error.
Note: The APIs we use to retrieve your data do not always distinguish between "no data available" and an "error" in the information they return. That means that, in some cases, Avian may not be able to definitively tell whether the absence of data is due to it genuinely not existing for the given parameters or an underlying issue with the data retrieval process.
Unfortunately, this limitation is beyond our control, as the differentiation is not provided by the data sources themselves.
Confirm Data Exists
If you initiate a query that returns an error or zero data, it's important to verify the existence of data for the requested date ranges, campaigns, or metrics.
Checking Data Directly: For assurance, log in to the platform you're trying to query to confirm that data exists for your specified parameters. This step can help clarify whether the issue is with data availability or another aspect of the data retrieval process.
Adjusting Query Parameters: If initial queries do not yield the expected data, consider adjusting your query parameters. Broadening the date range, modifying the targeted metrics, or altering the campaigns/accounts queried can sometimes uncover the data you're seeking.
Troubleshooting Tip: An easy way to diagnose data issues is to ask Avian to return a common metric for a large date range. Campaigns can be turned on and off throughout the year, so using a query like, "How much did we spend on Google Ads last year" or "How many users visited our website in 2023" can help isolate the issue.
If you've ensured that data is available and are still encountering issues, check out this article: Prompting Issues.