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

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

Info
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.

Notes
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 midnight in the time zone configured for the data source. See What Time Does My Data Refresh?
  • 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

    • Troubleshooting Amazon Ads

      Most errors that occur in Amazon Ads reports can be fixed easily without the need to wait for a response from our support team. This article will help you find everything you need to troubleshoot your Amazon Ads reports. If you have questions about ...
    • Amazon Ads October 2024 Deprecated and New Fields

      Amazon has recently made significant updates to their Ads API, which impacts the data available through Power My Analytics. This guide will walk you through the important changes to Amazon Ads reporting, including deprecated fields and new metrics ...
    • Error: Missing Google Ads Scopes

      When creating a report using your Google Ads account in Power My Analytics, you may encounter an error message stating "Missing Google Ads Scopes." This guide will help you understand the cause of this error and provide step-by-step instructions to ...
    • How to Connect to Amazon Ads

      Connecting to Amazon Ads is a complex process that can take several days. You will need a login, API access, a client ID, and a client secret. This article will show you how to acquire everything you need. Step 1: Create Your Login with Amazon (LwA) ...
    • Amazon Ads Data Connector User Guide

      Amazon Ads is a powerful advertising platform that allows sellers and brands to promote their products on Amazon. This guide will walk you through how to connect Amazon Ads to Power My Analytics, create reports in Data Studio, and understand key ...