Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.ioAmazon Ads “Report Is Still Being Prepared” Error: Troubleshooting Guide
If you request Amazon Ads data through Windsor.ai, in Claude, ChatGPT, Looker Studio, Google Sheets or the API, and the request comes back with a message like this:
Your sponsored_products_campaign report is still being prepared by Amazon, please try again later.
Amazon has not finished building the report yet. Nothing is wrong with your connection or your account. Wait, then run the same request again. In most cases the data is ready within an hour.
Why it happens
Amazon Ads does not return report data straight away. A request starts a report, Amazon builds it in the background, and the data can be downloaded only after Amazon marks the report as completed. While Amazon still shows the report as pending or processing, Windsor.ai returns this message.
The report name in the message changes with the data you asked for, for example sponsored_products_campaign, sponsored_brands_campaign_video, sponsored_display_campaign or sponsored_products_search_term. The fix is the same for all of them.
How to fix it
Wait, then send the same request again. Where you do that depends on where the request comes from:
- Looker Studio or the Google Sheets add-on: refresh the report or run the query again after about 30 minutes.
- Scheduled destination task (BigQuery, Google Sheets and other destinations): the next scheduled run requests the data again. Check that run before you change anything in the task.
- API or connector URL: repeat the request after a few minutes, and wait longer between each attempt.
- Claude, ChatGPT or another AI assistant: ask again later in the same chat, for example “try the Amazon Ads request again”.
Still stuck?
If the same report still shows this message after several hours, reach out to support with:
- The full error message, verbatim, including the report name.
- The date range you requested, and where the request came from (report, destination task, API, AI assistant).
- The Amazon Ads account (profile) you requested data for.
Related reading
FAQs
How long does Amazon take to prepare a report?
Usually from a few minutes to an hour, and sometimes a few hours. Amazon does not publish a maximum time.
Does sending the request many times make the report ready sooner?
No. Amazon builds the report at its own pace. Space your attempts out and wait longer between each one.
Tired of juggling fragmented data? Get started with Windsor.ai today to create a single source of truth
