Adverso
Browse all topics

How figures are calculated

Attribution windows, sums over a period, ratios, currency and dates.

Sums over a period

Amazon reports one row per item per day. When you ask for a period, the server adds those days up at the moment you ask. Nothing is summed ahead of time, so any period of up to 90 days gives exact figures, not a rounded-up preset such as "last 30 days".

Attribution

Amazon credits a sale to an ad when it follows a click within a window of days, and it reports several windows at once. The main figures (orders, sales, units) use the window Amazon's own console uses:

Ad typeAccountWindow used for the main figures
Sponsored Productsseller7 days
Sponsored Productsvendor14 days
Sponsored BrandsanyAmazon's single figure, 14 days
Sponsored DisplayanyAmazon's single figure, 14 days

For Sponsored Products, the other windows are always in more: sales1d, sales7d, sales14d, sales30d, and the same for purchases and unitsSoldClicks. If you want to compare against a tool that uses a different window, read it from there.

Ratios

Ratios are worked out from the summed figures, never averaged across days or rows.

FieldFormula
ctr_percentclicks ÷ impressions × 100
cpccost ÷ clicks
conversion_percentorders ÷ clicks × 100
acos_percentcost ÷ sales × 100
roassales ÷ cost

A ratio is left out when its divisor is zero. A row with cost and no sales has no acos_percent: that is not zero, it is undefined.

What cannot be added up

A share or a setting has no meaningful sum. topOfSearchImpressionShare, keywordBid and campaignBudgetAmount in more show the most recent value in the period instead.

Why search terms add up to slightly less

Amazon leaves search terms with very little activity out of its search-term report. The total of get_search_terms is therefore a little lower than the total of get_keywords or get_campaigns for the same period. The campaign, ad group, keyword, placement and product totals match each other exactly.

Currency

Money is in the currency of the marketplace, as Amazon reports it. Every answer says which in currency. Nothing is converted.

Dates

A day is a day in the marketplace's own time zone, as Amazon reports it. The default period ends yesterday, because today is not complete.