Adverso
Browse all topics

Reading the answers

What a row holds: the main figures, everything else Amazon reports, and the product.

Every performance tool returns the same shape. The data below is invented.

Example
{
  "level": "target",
  "ad_type": "SP",
  "from": "2026-11-11",
  "to": "2026-11-17",
  "currency": "EUR",
  "sorted_by": "cost",
  "total_rows": 1533,
  "offset": 0,
  "totals": { "impressions": 277157, "clicks": 1766, "cost": 783.19, "orders": 285, "sales": 2277.19, "units": 304, "acos_percent": 34.4 },
  "rows": [
    {
      "campaign_id": "123456789012345",
      "campaign": "SP | Hiking boots | Exact",
      "campaign_state": "ENABLED",
      "ad_group_id": "234567890123456",
      "ad_group": "Boots",
      "target_id": "345678901234567",
      "target_kind": "keyword",
      "keyword": "waterproof hiking boots",
      "match_type": "EXACT",
      "bid": 0.85,
      "target_state": "ENABLED",
      "impressions": 6976,
      "clicks": 76,
      "cost": 87.6,
      "orders": 33,
      "sales": 256.96,
      "units": 35,
      "ctr_percent": 1.09,
      "cpc": 1.15,
      "conversion_percent": 43.4,
      "acos_percent": 34.1,
      "roas": 2.93,
      "more": { "sales7d": 256.96, "sales14d": 271.4, "purchasesSameSku7d": 31, "topOfSearchImpressionShare": 82.78, "keywordBid": 0.85 }
    }
  ]
}

The envelope

FieldMeaning
level, ad_type, from, towhat was asked, with the defaults filled in
currencythe currency of every money figure in the answer
total_rowsrows that match, before limit and offset
totalsthe sums over every matching row
rowsthe page you asked for
notepresent when there is nothing to return for a stated reason

A row

A field is left out when it does not apply or has no value. A campaign row has no keyword; a row without sales has no acos_percent.

FieldsMeaning
campaign_id, campaign, campaign_statethe campaign
ad_group_id, ad_groupthe ad group
target_id, target_kind, keyword, match_type, targeting, bid, target_statethe keyword or target. targeting holds the expression of a product or automatic target.
search_term, placement, asinwhat the row is about, depending on the tool
impressions, clicks, cost, orders, sales, unitsthe six main figures, added up over the period
ctr_percent, cpc, conversion_percent, acos_percent, roasworked out from those sums
moreevery other figure Amazon reports for the row
productthe product, when the row is about one

more

more holds everything else in Amazon's report, under Amazon's own names, added up over the period.

  • Sponsored Products: sales, orders and units in all four attribution windows (sales1d, sales7d, sales14d, sales30d and so on), same-SKU and other-SKU figures, add-to-list counts.
  • Sponsored Brands and Display: new-to-brand, detail page views, branded searches and video figures.

The complete list is in All fields.

Three figures are not added up, because they describe a state, not an amount. They show their most recent value in the period: keywordBid, campaignBudgetAmount and topOfSearchImpressionShare.

A figure that is zero for the whole period is left out.

product

get_products rows, product ads in get_structure, and search terms that are a product page carry the product:

Example
{
  "asin": "B0EXAMPLE01",
  "title": "Waterproof hiking boots, leather, brown",
  "brand": "Nebula Outdoor",
  "category": "Hiking boots",
  "best_seller_rank": "12",
  "price": 89.9,
  "price_currency": "EUR",
  "availability": "IN_STOCK",
  "eligibility": "ELIGIBLE",
  "image_url": "https://m.media-amazon.com/images/I/EXAMPLE._SS60_.jpg",
  "image_url_large": "https://m.media-amazon.com/images/I/EXAMPLE._SL500_.jpg"
}

image_url is the 60-pixel thumbnail Amazon provides. image_url_large is the same picture at 500 pixels. Both are served by Amazon, so they can be shown directly. Amazon does not provide a price for every product.

Structure rows

get_structure returns the items of the account, not figures. Each row has the common fields (id, type, ad_type, name, state, bid, budget, keyword, match_type, asin, sku) and details: the complete record as Amazon returned it.

For a campaign, details is where the bidding strategy and the bid adjustments per placement are:

Example
{
  "dynamicBidding": {
    "strategy": "AUTO_FOR_SALES",
    "placementBidding": [{ "placement": "PLACEMENT_TOP", "percentage": 50 }]
  },
  "budget": { "budget": 25, "budgetType": "DAILY" },
  "targetingType": "MANUAL",
  "startDate": "2025-03-01"
}