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 type | Account | Window used for the main figures |
|---|---|---|
| Sponsored Products | seller | 7 days |
| Sponsored Products | vendor | 14 days |
| Sponsored Brands | any | Amazon's single figure, 14 days |
| Sponsored Display | any | Amazon'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.
| Field | Formula |
|---|---|
ctr_percent | clicks ÷ impressions × 100 |
cpc | cost ÷ clicks |
conversion_percent | orders ÷ clicks × 100 |
acos_percent | cost ÷ sales × 100 |
roas | sales ÷ 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.