Adverso
Browse all topics

All fields

Every field an answer can contain, with its meaning and the tool that returns it.

This is the complete list. Nothing is held back: each row carries every figure Amazon reports for it, and your AI decides what to show.

Field names inside more and details are Amazon's own, so they match the Amazon Ads documentation and exports you already know. The other names are Adverso's and are the same for every ad type.

Accounts

Returned by list_accounts

One entry per marketplace on your plan.

FieldMeaningWhere
marketplace_idThe id to pass as marketplace_id to every other tool.all
accountThe account's name on Amazon.all
account_typeseller or vendor. It decides the attribution window of Sponsored Products figures.all
countryCountry code as Amazon writes it, for example DE or UK.all
storeThe storefront, for example Amazon.de.all
currencyThe currency of the marketplace's money figures.all
accessread or read_write, as set in the dashboard.all
performance_data_fromThe first day with performance data.all
performance_data_toThe last day with performance data.all
structure_updated_atWhen the account structure was last downloaded.all

Overview

Returned by get_account_overview

Three views of the same period: total, by_ad_type (one entry for SP, SB and SD) and by_day.

FieldMeaningWhere
impressionsTimes an ad was shown.all
clicksClicks on ads.all
costAd spend.all
ordersOrders attributed to ads.all
salesSales attributed to ads.all
unitsUnits sold through ads.total, by_ad_type
acos_percentCost ÷ sales × 100.total, by_ad_type
roasSales ÷ cost.total, by_ad_type
ad_typeSP, SB or SD.by_ad_type
dateThe day.by_day

What a row is about

Returned by get_campaigns, get_ad_groups, get_keywords, get_search_terms, get_placements, get_products

Names and settings come from the account structure, so they show the current name, state and bid. A field is present only where it applies.

FieldMeaningWhere
campaign_idAmazon's id of the campaign.all except get_products
campaignThe campaign's name.all except get_products
campaign_stateENABLED, PAUSED or ARCHIVED.all except get_products
ad_group_idAmazon's id of the ad group.get_ad_groups, get_keywords, get_search_terms
ad_groupThe ad group's name.get_ad_groups, get_keywords, get_search_terms
target_idAmazon's id of the keyword or target.get_keywords, get_search_terms
target_kindkeyword, target or theme_target.get_keywords, get_search_terms
keywordThe keyword text.get_keywords, get_search_terms
match_typeEXACT, PHRASE or BROAD.get_keywords, get_search_terms
targetingThe expression of a product or automatic target, for example a product, a category or "close match".get_keywords, get_search_terms
bidThe current bid.get_keywords, get_search_terms
target_stateENABLED, PAUSED or ARCHIVED.get_keywords, get_search_terms
search_termWhat the shopper typed, or the ASIN of the product page the ad showed on.get_search_terms
placementWhere the ad appeared: top of search, product pages, rest of search, off Amazon.get_placements
asinThe advertised product.get_products

Main figures and ratios

Returned by every performance tool

The six main figures are added up over the period. The ratios are worked out from those sums. Orders, sales and units use the standard attribution window (see How figures are calculated).

FieldMeaningWhere
impressionsTimes the ad was shown.all
clicksClicks.all
costAd spend.all
ordersOrders attributed to the ad.all
salesSales attributed to the ad.all
unitsUnits sold.all
ctr_percentClicks ÷ impressions × 100.all
cpcCost ÷ clicks.all
conversion_percentOrders ÷ clicks × 100.all
acos_percentCost ÷ sales × 100.all
roasSales ÷ cost.all

more: Sponsored Products

Returned by performance tools with ad_type SP

Everything else in Amazon's Sponsored Products reports. The window used for the main figures is not repeated here: on a seller account sales7d is already sales, on a vendor account sales14d is.

FieldMeaningWhere
purchases1dOrders, counted within 1 day of the click.all
purchases7dOrders, counted within 7 days of the click.all
purchases14dOrders, counted within 14 days of the click.all
purchases30dOrders, counted within 30 days of the click.all
sales1dSales, counted within 1 day of the click.all
sales7dSales, counted within 7 days of the click.all
sales14dSales, counted within 14 days of the click.all
sales30dSales, counted within 30 days of the click.all
unitsSoldClicks1dUnits sold, counted within 1 day of the click.all
unitsSoldClicks7dUnits sold, counted within 7 days of the click.all
unitsSoldClicks14dUnits sold, counted within 14 days of the click.all
unitsSoldClicks30dUnits sold, counted within 30 days of the click.all
purchasesSameSku1dOrders of the advertised product itself, counted within 1 day of the click.all
purchasesSameSku7dOrders of the advertised product itself, counted within 7 days of the click.all
purchasesSameSku14dOrders of the advertised product itself, counted within 14 days of the click.all
purchasesSameSku30dOrders of the advertised product itself, counted within 30 days of the click.all
attributedSalesSameSku1dSales of the advertised product itself, counted within 1 day of the click.all
attributedSalesSameSku7dSales of the advertised product itself, counted within 7 days of the click.all
attributedSalesSameSku14dSales of the advertised product itself, counted within 14 days of the click.all
attributedSalesSameSku30dSales of the advertised product itself, counted within 30 days of the click.all
unitsSoldSameSku1dUnits of the advertised product itself, counted within 1 day of the click.all
unitsSoldSameSku7dUnits of the advertised product itself, counted within 7 days of the click.all
unitsSoldSameSku14dUnits of the advertised product itself, counted within 14 days of the click.all
unitsSoldSameSku30dUnits of the advertised product itself, counted within 30 days of the click.all
salesOtherSku7dSales of your other products after a click on this ad, within 7 days.get_keywords, get_search_terms, get_products
unitsSoldOtherSku7dUnits of your other products after a click on this ad, within 7 days.get_keywords, get_search_terms, get_products
addToListTimes a shopper added the product to a list after the ad.all
topOfSearchImpressionShareShare of top-of-search impressions you won, in percent.latest valueget_campaigns, get_keywords
keywordBidThe bid at the time of the report.latest valueget_keywords
campaignBudgetAmountThe campaign's budget at the time of the report.latest valueget_campaigns
campaignBiddingStrategyThe bidding strategy at the time of the report.latest valueget_campaigns
advertisedSkuThe SKU of the advertised product.latest valueget_products

more: Sponsored Brands

Returned by performance tools with ad_type SB

Everything else in Amazon's Sponsored Brands reports. get_search_terms has fewer figures than the other tools, because Amazon's search-term report has fewer.

FieldMeaningWhere
purchasesClicksOrders after a click (as opposed to after only seeing the ad).all
purchasesPromotedOrders of the products shown in the ad.all except get_search_terms
salesClicksSales after a click.all
salesPromotedSales of the products shown in the ad.all except get_search_terms
unitsSoldClicksUnits sold after a click.get_campaigns, get_ad_groups, get_placements
addToCartTimes a product was added to the basket.all except get_search_terms
addToCartClicksAdd-to-basket events after a click.all except get_search_terms
addToListTimes a shopper added a product to a list.all
addToListFromClicksAdd-to-list events after a click.all
brandedSearchesSearches for your brand name after the ad was seen.all except get_search_terms
brandedSearchesClicksBranded searches after a click.all except get_search_terms
detailPageViewsViews of your product pages after the ad.all except get_search_terms
detailPageViewsClicksProduct page views after a click.all except get_search_terms
newToBrandPurchasesOrders from shoppers who had not bought from your brand in the past year.all except get_search_terms
newToBrandPurchasesClicksNew-to-brand orders after a click.all except get_search_terms
newToBrandSalesSales to new-to-brand shoppers.all except get_search_terms
newToBrandSalesClicksNew-to-brand sales after a click.all except get_search_terms
newToBrandUnitsSoldUnits sold to new-to-brand shoppers.all except get_search_terms
newToBrandUnitsSoldClicksNew-to-brand units after a click.all except get_search_terms
newToBrandDetailPageViewsProduct page views by new-to-brand shoppers.all except get_search_terms
newToBrandDetailPageViewsClicksNew-to-brand product page views after a click.all except get_search_terms
viewableImpressionsImpressions that met the standard for being seen.all
video5SecondViewsVideo ads watched for at least 5 seconds.all
videoFirstQuartileViewsVideo ads watched to 25%.all
videoMidpointViewsVideo ads watched to 50%.all
videoThirdQuartileViewsVideo ads watched to 75%.all
videoCompleteViewsVideo ads watched to the end.all
videoUnmutesTimes a shopper switched the sound on.all
topOfSearchImpressionShareShare of top-of-search impressions you won, in percent.latest valueget_campaigns, get_keywords
keywordBidThe bid at the time of the report.latest valueget_keywords
campaignBudgetAmountThe campaign's budget at the time of the report.latest valueget_campaigns
costTypeHow the campaign is charged: per click or per thousand viewable impressions.latest valueget_campaigns

more: Sponsored Display

Returned by performance tools with ad_type SD

Everything else in Amazon's Sponsored Display reports. Display counts what happened after a click and after only seeing the ad separately.

FieldMeaningWhere
purchasesClicksOrders after a click (as opposed to after only seeing the ad).all
purchasesPromotedClicksOrders of the advertised products after a click.all
salesClicksSales after a click.all
salesPromotedClicksSales of the advertised products after a click.all
unitsSoldClicksUnits sold after a click.all
addToCartTimes a product was added to the basket.all
addToCartClicksAdd-to-basket events after a click.all
addToCartViewsAdd-to-basket events after only seeing the ad.all
addToListTimes a shopper added a product to a list.all
addToListFromClicksAdd-to-list events after a click.all
addToListFromViewsAdd-to-list events after only seeing the ad.all
brandedSearchesSearches for your brand name after the ad was seen.all
brandedSearchesClicksBranded searches after a click.all
brandedSearchesViewsBranded searches after only seeing the ad.all
detailPageViewsViews of your product pages after the ad.all
detailPageViewsClicksProduct page views after a click.all
impressionsViewsViewable impressions.all
newToBrandPurchasesOrders from shoppers who had not bought from your brand in the past year.all
newToBrandPurchasesClicksNew-to-brand orders after a click.all
newToBrandSalesSales to new-to-brand shoppers.all
newToBrandSalesClicksNew-to-brand sales after a click.all
newToBrandUnitsSoldUnits sold to new-to-brand shoppers.all
newToBrandUnitsSoldClicksNew-to-brand units after a click.all
videoFirstQuartileViewsVideo ads watched to 25%.all
videoMidpointViewsVideo ads watched to 50%.all
videoThirdQuartileViewsVideo ads watched to 75%.all
videoCompleteViewsVideo ads watched to the end.all
videoUnmutesTimes a shopper switched the sound on.all
campaignBudgetAmountThe campaign's budget at the time of the report.latest valueget_campaigns
costTypeHow the campaign is charged: per click or per thousand viewable impressions.latest valueget_campaigns
promotedSkuThe SKU of the advertised product.latest valueget_products

product

Returned by get_products, get_search_terms (when the term is a product), get_structure (product ads)

What the Amazon Ads API knows about a product.

FieldMeaningWhere
asinThe product's ASIN.all
skuYour SKU, when Amazon returns it.all
titleThe product title.all
image_urlThe main image as a 60-pixel thumbnail, served by Amazon.all
image_url_largeThe same image at 500 pixels.all
brandThe brand.all
categoryThe product's category on Amazon.all
best_seller_rankIts rank in that category.all
priceThe price a shopper pays. Amazon does not provide it for every product.all
price_currencyThe currency of the price.all
list_priceThe list price, when there is one.all
availabilityFor example IN_STOCK, IN_STOCK_SCARCE, LEADTIME, OUT_OF_STOCK.all
eligibilityELIGIBLE or INELIGIBLE for advertising.all
ineligibility_reasonsWhy the product cannot be advertised, when it cannot.all
variationsThe ASINs of the product's variations.all
createdWhen the product was created on Amazon.all

Sponsored Brands ads

Returned by get_ads

The campaign and ad group fields, the main figures, the ratios and more: Sponsored Brands as in the other performance tools, plus these.

FieldMeaningWhere
ad_idAmazon's id of the ad.all
adThe ad's name.all
ad_stateENABLED, PAUSED or ARCHIVED.all
creativeThe ad as Amazon holds it: type, headline, brand name, logo, custom images, the advertised ASINs and its review status.all
landing_pageWhere a click leads: a Store page, a product list or a custom address.all

Purchased products

Returned by get_purchased_products

What was bought after a click when it was not the advertised product. The envelope also has attribution_window: the window the three figures use.

FieldMeaningWhere
advertised_asinThe product in the ad that was clicked.SP, SD
advertised_productIts details. See the product group.SP, SD
purchased_asinThe product that was bought.all
purchased_productIts details. See the product group.all
ordersOrders of the purchased product after a click on the ad.all
salesSales of the purchased product.all
unitsUnits of the purchased product.all
campaignsIn how many campaigns this pair occurred.all
moreAmazon's own columns for the pair: every attribution window for Sponsored Products (salesOtherSku1d to 30d and so on), new-to-brand figures for Sponsored Brands.all

Display matched targets

Returned by get_matched_targets

The campaign, ad group and target fields, the main figures, the ratios and more: Sponsored Display as in the other performance tools, plus these.

FieldMeaningWhere
matched_asinThe product whose page the ad showed on.all
productThat product's details. See the product group.all

Invalid traffic

Returned by get_invalid_traffic

Per campaign. impressions and clicks are the valid ones, the same figures the other tools return.

FieldMeaningWhere
campaignThe campaign's name. Amazon gives no id in this report.all
campaign_stateENABLED, PAUSED or ARCHIVED, on the last day of the period.latest valueall
gross_impressionsEvery impression Amazon counted, before removing invalid ones.all
invalid_impressionsImpressions Amazon removed as invalid.all
impressionsGross minus invalid.all
gross_clicksEvery click Amazon counted, before removing invalid ones.all
invalid_clicksClicks Amazon removed as invalid. You are not charged for them.all
clicksGross minus invalid.all
invalid_impressions_percentInvalid impressions ÷ gross impressions × 100.all
invalid_clicks_percentInvalid clicks ÷ gross clicks × 100.all

Product history

Returned by get_product_history

Recorded once a day. The envelope has history_starts: the first day that exists for the marketplace.

FieldMeaningWhere
asinThe product.all
categoryThe category the rank is in.all
rankBest-seller rank on the last recorded day of the period. 1 is the best.latest valueall
rank_at_startRank on the first recorded day of the period.all
rank_changerank minus rank_at_start. A negative number means the product climbed.all
best_rankThe lowest rank number in the period.all
worst_rankThe highest rank number in the period.all
days_recordedHow many days of the period have a record.all
historyOne entry per day: date, rank, price, availability.all
productThe product's current details. See the product group.all

Structure: every item

Returned by get_structure

The same columns for every kind of item. Below them, details holds Amazon's complete record, which differs per kind.

FieldMeaningWhere
idAmazon's id of the item.all
typeThe kind of item, for example campaign or negative_keyword.all
ad_typeSP, SB, SD, or ALL for a portfolio.all
campaign_idThe campaign it belongs to.all
ad_group_idThe ad group it belongs to.all
portfolio_idThe portfolio of a campaign.all
nameIts name.all
stateENABLED, PAUSED or ARCHIVED.all
bidThe bid of a keyword or target, or the default bid of an ad group.all
budgetThe budget of a campaign or portfolio.all
keywordThe text of a keyword or negative keyword.all
match_typeThe match type of a keyword or negative keyword.all
asinThe product of a product ad.all
skuThe SKU of a product ad.all
productThe product, for a product ad. See the product group.all
detailsAmazon's complete record. See the groups below.all

details: campaigns

Returned by get_structure with type campaign

Each ad type has its own record. The field names are Amazon's.

FieldMeaningWhere
budgetSponsored Products: an object with budget and budgetType. Brands and Display: the amount.all
budgetTypeDAILY or LIFETIME.SB, SD
dynamicBidding.strategyThe bidding strategy: down only, up and down, or fixed bids.SP
dynamicBidding.placementBiddingThe bid adjustment per placement, in percent: top of search, product pages, rest of search.SP
biddingBid optimisation and the bid adjustments per placement.SB
targetingTypeAUTO or MANUAL.SP
startDateThe first day the campaign runs.all
endDateThe last day, when one is set.all
portfolioIdThe portfolio the campaign is in.all
costTypeCharged per click or per thousand viewable impressions.SB, SD
goalThe campaign's goal.SB
kpiThe figure the goal is measured by.SB
isMultiAdGroupsEnabledWhether the campaign can hold several ad groups.SB
smartDefaultAmazon's default targeting settings.SB
tacticThe targeting tactic: products and categories, or audiences.SD
deliveryProfileHow the budget is spread over the day.SD
servingStatusWhether Amazon is serving the campaign, and if not, why.SD
creationDateWhen the campaign was created.SD
lastUpdatedDateWhen it was last changed.SD
tagsYour own labels on the campaign.SP
offAmazonSettingsSettings for showing the ads outside Amazon.SP
marketplaceBudgetAllocationHow a shared budget is split across marketplaces.SP
extendedData.creationDateTimeWhen the item was created.SP, SB
extendedData.lastUpdateDateTimeWhen it was last changed.SP, SB
extendedData.servingStatusWhether Amazon is currently serving it, and if not, why.SP, SB
extendedData.servingStatusDetailsThe reasons behind the serving status.SP, SB

details: ad groups, keywords, targets, ads

Returned by get_structure with type ad_group, keyword, target, negatives, product_ad, ad

The field names are Amazon's. Sponsored Products and Brands carry creation date and serving status in extendedData; Display has them at the top level.

FieldMeaningWhere
defaultBidThe bid used when a keyword or target has none.ad groups, SP and SD
bidOptimizationWhat Amazon optimises the ad group's bids for.ad groups, SD
creativeTypeImage or video.ad groups, SD
keywordTextThe keyword.keywords, negative keywords
matchTypeThe match type.keywords, negative keywords
bidThe bid.keywords, targets
expressionWhat the target is aimed at, as you set it: a product, a category with filters, an audience, or an automatic group.targets, negative targets
resolvedExpressionThe same expression with names filled in, for example the category's name.targets, negative targets
expressionTypeAUTO or MANUAL.targets, SP and SD
creativeThe headline, logo, images, video and products of the ad.ads, SB
landingPageWhere a click leads: a Store page, a product list or a custom address.ads, SB
asinThe advertised product.product ads
servingStatusWhether Amazon is serving the item, and if not, why.all
creationDateWhen the item was created.SD
lastUpdatedDateWhen it was last changed.SD
extendedData.creationDateTimeWhen the item was created.SP, SB
extendedData.lastUpdateDateTimeWhen it was last changed.SP, SB
extendedData.servingStatusWhether Amazon is currently serving it, and if not, why.SP, SB
extendedData.servingStatusDetailsThe reasons behind the serving status.SP, SB

details: portfolios

Returned by get_structure with type portfolio

A portfolio groups campaigns of any ad type.

FieldMeaningWhere
budgetThe portfolio's budget cap, when it has one.all
budgetControlsHow the cap applies: monthly, a date range, or none.all
inBudgetWhether the portfolio is still inside its budget.all
extendedData.creationDateTimeWhen the item was created.all
extendedData.lastUpdateDateTimeWhen it was last changed.all
extendedData.servingStatusWhether Amazon is currently serving it, and if not, why.all
extendedData.servingStatusDetailsThe reasons behind the serving status.all

How to read the list

  • all in the last column means the field is in every answer of that group.
  • latest value marks a value that describes a state, such as a bid or a budget. It is not added up over the days of the period; you get the most recent one.
  • A field is left out of an answer when it has no value or is zero for the whole period. A missing figure reads as zero.
  • Sponsored Products figures come in four attribution windows: 1d, 7d, 14d and 30d. See How figures are calculated.