Amazon Report Mismatch Checker

Why don’t my Amazon sales reports match?

Compare Amazon Ads and Business Report sales on the same basis. Check dates, currencies, product coverage and attribution definitions to see whether the totals describe comparable activity.

Amazon Ads
Import Amazon Ads report

CSV, TSV or XLSX · up to 10 MB and 100,000 rows · read only in this tab.

Business Report
Import Business Report

CSV, TSV or XLSX · up to 10 MB and 100,000 rows · read only in this tab.

What do the reports count?

A click on Monday that leads to a purchase on Thursday can appear under Monday in an ad interaction report and Thursday in a Business Report. Check the date definition of your export.

Check that both reports cover the same marketplace, accounts and products. For example, a report for your US catalog will not match one for a single product or a different country.

Purchases can count several days after an ad click. Wait until the full window shown in your report has passed for the latest date, then allow for Amazon’s reporting updates. For a 7-day window, a click on Monday can still gain purchases through the following Monday.

Method and limits

This is a comparison-basis checker. It subtracts attributed sales minus Ordered Product Sales only when both currency codes match. It does not join order IDs or reconcile refunds, and it cannot quantify every reason for the gap.

Can ad-attributed sales be higher than Business Report sales?

Yes, the reporting bases can differ. Sponsored ad campaign sales are reported on the ad interaction date; the purchase may occur later inside the attribution window. Depending on the campaign, attributed sales can also cover products beyond those advertised. Different dates or scopes can produce a higher attributed-sales total.

Is total sales minus ad sales my organic revenue?

It is not an exact organic-sales calculation. First check dates, product coverage, merchant coverage, discounts, tax and adjustments. Even when the dates and currency match, the reports may count different sets of orders.

Amazon DSP reports attribution on the conversion date. Check the exact report, ad product and account settings rather than applying one rule to every Ads export.

Sources: Amazon’s ad campaign attribution guide and Amazon’s conversion attribution guide. Reporting definitions can change; verify the column definitions in your current exports.

Same math, for developers: free JSON API · API specification. Calling the API sends the values you provide to the server. This page never calls it.

Explore all free tools