Skip to content
Knowledge Base

Why Is My Amazon Ads Report Showing $0 or Missing Dates?

Last updated

Note: If your Amazon Ads report shows $0 values or skips some dates, it usually means your campaigns had no spend or had ended during that period. Amazon reports $0 for days when an active campaign had no spend, and it sends no data at all for days when a campaign was ended, so those dates can look empty. This article explains what you are seeing and what to do about it.

What You Are Seeing

  • Some dates in your Amazon Ads report show $0 for spend and other metrics.
  • Some dates are missing entirely (the report skips from one date to the next).
  • The zeros or gaps remain even after you run a manual backfill.

The Most Common Cause: No Campaign Activity

Amazon only sends performance data for days when your campaigns were active. How an inactive day appears in your report depends on the campaign's status on that day:

  • Enabled campaigns with no spend: Amazon returns rows with zero values, so those days appear as $0 in your report.
  • Ended campaigns: Amazon sends no data at all for days when a campaign was ended, so those days appear as gaps (missing dates) rather than as $0.

Because Amazon has no data to send for ended-campaign days, running another backfill will not fill those gaps. This is expected Amazon behavior; it does not mean your connection is broken. Your Amazon Ads data source is still syncing normally.

Note: A campaign that ended on June 1 will show no data (a gap) for any date after that. If an account had no active, spending campaigns for a stretch of days, the report can show $0 or skipped dates for that period even though the connection is healthy.

Other Things to Check

If you believe the missing dates should contain real activity, check the following:

  • Confirm the dates in question: Set exact start and end dates in both the source and your report rather than relative ranges like "last 7 days." See Basic Troubleshooting.
  • Very recent dates may still be settling: PMA automatically re-checks about the last 14 days of Amazon data each day, because Amazon can revise recent values. It is normal for the most recent days to adjust slightly from one day to the next.
  • A date range with real activity is missing: A temporary interruption in Amazon's API can leave a gap in a range that did have activity. A manual backfill of that specific range usually resolves it. See Backfill Connection Data.
  • Today's data has not appeared yet: PMA syncs once daily, at the data source's sync time (3 AM in the time zone configured for the data source, unless you change it). See What Time Does My Data Refresh?
  • Yesterday is missing from a scheduled report: PMA stores yesterday's Amazon data at your data source's next sync time. A Google Sheets refresh or export that runs at or soon after the sync time can start before that data is stored, so the report ends one day short, while a refresh later in the day includes it. Schedule the refresh at least 2 hours after the data source's sync time. See Configure Data Source Sync Time and Google Sheets Refresh for the Latest Data.
  • Your data source and Amazon Ads account use different time zones: Amazon ends each reporting day at midnight in your Amazon Ads account's time zone. If your data source's sync time is in a time zone ahead of the account's (for example, a data source on Central European Time for an account on Pacific Time), the sync can run before Amazon's day has ended. Use Edit sync time to give the data source the Amazon Ads account's time zone, or choose an hour that falls after midnight in the account's time zone.
  • The whole account has never shown data: If an Amazon source connected successfully but has never returned any data, you may have connected an Amazon DSP account rather than an Amazon Ads account. The Amazon DSP connector is still in development. See Troubleshooting Amazon Ads.

When to Contact Support or Amazon

  • If a date range where you know campaigns were active and spending is still missing after a backfill, or recent data appears delayed by several days, the delay may be on Amazon's side. Because each Amazon Ads connection uses your own Amazon app, you can ask Amazon why the API results for your account appear delayed.
  • If you have confirmed there was real activity and the data still is not appearing, submit a ticket and our team will be happy to investigate.

Related Articles