Amazon Ads

Creating the data source

Required permissions

  • Kondado only reads your data: the access requested from Amazon (advertising::campaign_management) is used only to list registries and generate reports. Nothing is changed in your advertising account.
  • The data Kondado sees is exactly what the authorizing Amazon user sees, at that user's permission level.
  • That user must have access, in the Amazon Ads console (advertising.amazon.com → user management), to each advertising account you want to integrate.
  • For Amazon DSP, the user must have access to the DSP agency and advertisers. DSP advertisers are listed as "Agency / Advertiser (country) | Id".
  • Seller and vendor accounts are listed per marketplace: one account ("profile") per country.

How to connect

  1. In Kondado, add a new Amazon Ads data source.
  2. First choose the region of your advertising account:
    • Americas: Brazil, US, Canada and Mexico;
    • Europe, Middle East, Africa and India;
    • Asia-Pacific: Japan, Australia and Singapore.
  3. Click Authorize. You will be redirected to Amazon (Login with Amazon).
  4. Sign in with the Amazon user that has access to the desired advertising accounts in the Amazon Ads console.
  5. The consent screen says Kondado would like access to: ... Access to advertiser account(s) with your user permission level. Click Allow.
  6. Back in Kondado, the data source is created. Now create the integrations you need.

Accounts advertising in more than one region need one data source per region.

The authorization expires after 365 days. The expiration date is shown on the data source: re-authorize before it so your integrations keep running.

If an account chosen in an integration stops being visible to the authorizing user, the integration fails with a message naming that account (it never delivers partial data). In that case, reconnect with a user that has access to the account or remove the account from the integration.

Pipelines

Summary

Relationship chart

Click to expand

Amazon DSP report

Replication type: Incremental with update window

Parameters:

  • Level: Grain of each report row.
  • Update window: How many days back on each run. Amazon revises conversions for weeks after the click. Days older than what Amazon keeps for the level are not requested.
  • Breakdown: Additional split of each row (audience, product, geography or technology).
  • Grouping period: Day, week or month. Week and month are totalled by Amazon itself, which keeps unique-people metrics such as reach correct.
  • Read start date: Amazon only keeps the last 60 to 95 days, depending on the report type; the screen only accepts dates within that limit. Some levels keep less (search term: 65 days), and the saved date is adjusted to what Amazon has.
  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon DSP report: one row per advertising account, chosen level and day, week or month (grouping period), with Amazon Ads metrics. The update window re-reads the last days on every run. Available levels: Order (campaign); Line item; Creative; Flight (budget period). Breakdowns (order and line item): Audience; Product; Country; Region; City; Postal code; DMA (US market area); Operating system; Browser; Browser version; Device; Environment (app / web). The field list gathers the columns of every level; each integration brings only those of the chosen level (e.g. the country breakdown adds country). How to read the metrics: ROAS = sales ÷ cost; ACOS = cost ÷ sales (the inverse of ROAS). TACOS (cost ÷ total store sales, organic included) does not come from Amazon Ads: it needs the total sales from Seller or Vendor Central. The number at the end of the name (1d, 7d, 14d, 30d) is the attribution window in days. Clicks = conversions attributed to a click; Views = attributed to a view without a click. BrandHalo = other products of the same brand; SameSku/OtherSku = the advertised SKU itself or others; total = advertised product + brand halo; NewToBrand = customers with no purchase from the brand in the last 12 months; eCP = effective cost per event; offAmazon = conversions on the advertiser site, measured by the conversion tag. Reach counts unique people and does not add up across days. In Amazon DSP almost every conversion comes in three versions: total, click-attributed (Clicks) and view-attributed (Views). Order, line item and creative are DSP's names for campaign, ad group and ad. Amazon states that API numbers may differ from the console by up to about 5%.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

advertiser_id

text

[en] DSP advertiser id of the report.

    Metadata: Amazon DSP - advertisers > > advertiser_id

date

date

[en] Row day; for week/month, the first day of the period (account time zone).

profile_name

text

[en] Advertising account (profile) name.

country_code

text

[en] Account marketplace country (e.g. BR, US).

currency_code

text

[en] Currency in which the row's cost and sales are expressed.

third_party_fees

float

[en] Sum of third-party fees (verification, measurement, data). Amazon column: 3PFees.

third_party_pre_bid_fee

float

[en] Third-party pre-bid filtering fee (brand safety). Amazon column: 3PPreBidFee.

third_party_pre_bid_fee_double_verify

float

[en] Third-party pre-bid filtering fee (Double Verify). Amazon column: 3PPreBidFeeDoubleVerify.

third_party_pre_bid_fee_integral_ad_science

float

[en] Third-party pre-bid filtering fee (Integral Ad Science). Amazon column: 3PPreBidFeeIntegralAdScience.

third_party_pre_bid_fee_oracle_data_cloud

float

[en] Third-party pre-bid filtering fee (Oracle Data Cloud). Amazon column: 3PPreBidFeeOracleDataCloud.

third_party_pre_bid_fee_pixalate

float

[en] Third-party pre-bid filtering fee (Pixalate). Amazon column: 3PPreBidFeePixalate.

third_party_fee_automotive

float

[en] Third-party fee (Automotive). Amazon column: 3pFeeAutomotive.

third_party_fee_automotive_absorbed

float

[en] Third-party fee (Automotive), absorbed by Amazon (not charged). Amazon column: 3pFeeAutomotiveAbsorbed.

third_party_fee_cpm1

float

[en] Third-party fee (CPM1). Amazon column: 3pFeeCPM1.

third_party_fee_cpm1_absorbed

float

[en] Third-party fee (CPM1), absorbed by Amazon (not charged). Amazon column: 3pFeeCPM1Absorbed.

third_party_fee_cpm2

float

[en] Third-party fee (CPM2). Amazon column: 3pFeeCPM2.

third_party_fee_cpm2_absorbed

float

[en] Third-party fee (CPM2), absorbed by Amazon (not charged). Amazon column: 3pFeeCPM2Absorbed.

third_party_fee_cpm3

float

[en] Third-party fee (CPM3). Amazon column: 3pFeeCPM3.

third_party_fee_cpm3_absorbed

float

[en] Third-party fee (CPM3), absorbed by Amazon (not charged). Amazon column: 3pFeeCPM3Absorbed.

third_party_fee_com_score

float

[en] Third-party fee (Com Score). Amazon column: 3pFeeComScore.

third_party_fee_com_score_absorbed

float

[en] Third-party fee (Com Score), absorbed by Amazon (not charged). Amazon column: 3pFeeComScoreAbsorbed.

third_party_fee_double_verify

float

[en] Third-party fee (Double Verify). Amazon column: 3pFeeDoubleVerify.

third_party_fee_double_verify_absorbed

float

[en] Third-party fee (Double Verify), absorbed by Amazon (not charged). Amazon column: 3pFeeDoubleVerifyAbsorbed.

third_party_fee_doubleclick_campaign_manager

float

[en] Third-party fee (Doubleclick Campaign Manager). Amazon column: 3pFeeDoubleclickCampaignManager.

third_party_fee_doubleclick_campaign_manager_absorbed

float

[en] Third-party fee (Doubleclick Campaign Manager), absorbed by Amazon (not charged). Amazon column: 3pFeeDoubleclickCampaignManagerAbsorbed.

third_party_fee_integral_ad_science

float

[en] Third-party fee (Integral Ad Science). Amazon column: 3pFeeIntegralAdScience.

third_party_fee_integral_ad_science_absorbed

float

[en] Third-party fee (Integral Ad Science), absorbed by Amazon (not charged). Amazon column: 3pFeeIntegralAdScienceAbsorbed.

new_to_brand_ecpp

float

[en] Effective cost: cost ÷ purchases from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: NewToBrandECPP.

roas

float

[en] ROAS: attributed sales ÷ cost. Amazon column: ROAS.

add_to_cart

int

[en] Add-to-cart events. Amazon column: addToCart.

add_to_cart_brand_halo

int

[en] Add-to-cart events of other products of the same brand, halo effect, not the advertised one. Amazon column: addToCartBrandHalo.

add_to_cart_brand_halo_clicks

int

[en] Add-to-cart events of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: addToCartBrandHaloClicks.

add_to_cart_brand_halo_views

int

[en] Add-to-cart events of other products of the same brand, halo effect, not the advertised one (view attribution: ad seen, not clicked). Amazon column: addToCartBrandHaloViews.

add_to_cart_clicks

int

[en] Add-to-cart events (click attribution). Amazon column: addToCartClicks.

add_to_cart_rate

float

[en] Add-to-cart events ÷ impressions (rate). Amazon column: addToCartRate.

add_to_cart_views

int

[en] Add-to-cart events (view attribution: ad seen, not clicked). Amazon column: addToCartViews.

add_to_list

int

[en] Add-to-list events. Amazon column: addToList.

add_to_list_brand_halo

int

[en] Add-to-list events of other products of the same brand, halo effect, not the advertised one. Amazon column: addToListBrandHalo.

add_to_list_brand_halo_clicks

int

[en] Add-to-list events of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: addToListBrandHaloClicks.

add_to_list_brand_halo_views

int

[en] Add-to-list events of other products of the same brand, halo effect, not the advertised one (view attribution: ad seen, not clicked). Amazon column: addToListBrandHaloViews.

add_to_list_clicks

int

[en] Add-to-list events (click attribution). Amazon column: addToListClicks.

add_to_list_rate

float

[en] Add-to-list events ÷ impressions (rate). Amazon column: addToListRate.

add_to_list_views

int

[en] Add-to-list events (view attribution: ad seen, not clicked). Amazon column: addToListViews.

add_to_shopping_cart

float

[en] Add-to-cart events on the advertiser site. Amazon column: addToShoppingCart.

add_to_shopping_cart_cpa

text

[en] Cost ÷ add-to-cart events on the advertiser site (cost per acquisition, CPA). Amazon column: addToShoppingCartCPA.

add_to_shopping_cart_cvr

float

[en] Add-to-cart events on the advertiser site ÷ clicks (conversion rate). Amazon column: addToShoppingCartCVR.

add_to_shopping_cart_clicks

int

[en] Add-to-cart events on the advertiser site (click attribution). Amazon column: addToShoppingCartClicks.

add_to_shopping_cart_value_average

text

[en] Average value reported on add-to-cart events on the advertiser site. Amazon column: addToShoppingCartValueAverage.

add_to_shopping_cart_value_sum

float

[en] Sum of the value reported on add-to-cart events on the advertiser site. Amazon column: addToShoppingCartValueSum.

add_to_shopping_cart_views

int

[en] Add-to-cart events on the advertiser site (view attribution: ad seen, not clicked). Amazon column: addToShoppingCartViews.

add_to_watchlist

int

[en] Add-to-watchlist events (Prime Video). Amazon column: addToWatchlist.

add_to_watchlist_clicks

int

[en] Add-to-watchlist events (Prime Video) (click attribution). Amazon column: addToWatchlistClicks.

add_to_watchlist_rate

float

[en] Add-to-watchlist events (Prime Video) ÷ impressions (rate). Amazon column: addToWatchlistRate.

add_to_watchlist_views

int

[en] Add-to-watchlist events (Prime Video) (view attribution: ad seen, not clicked). Amazon column: addToWatchlistViews.

advertiser_country

text

[en] DSP advertiser country. Amazon column: advertiserCountry.

advertiser_name

text

[en] Name of the DSP advertiser. Amazon column: advertiserName.

advertiser_timezone

text

[en] DSP advertiser time zone. Amazon column: advertiserTimezone.

agency_fee

float

[en] Agency fee charged in DSP. Amazon column: agencyFee.

alexa_skill_enable

int

[en] Alexa skill enables. Amazon column: alexaSkillEnable.

alexa_skill_enable_clicks

int

[en] Alexa skill enables (click attribution). Amazon column: alexaSkillEnableClicks.

alexa_skill_enable_rate

float

[en] Alexa skill enables ÷ impressions (rate). Amazon column: alexaSkillEnableRate.

alexa_skill_enable_views

int

[en] Alexa skill enables (view attribution: ad seen, not clicked). Amazon column: alexaSkillEnableViews.

amazon_dsp_audience_fee

float

[en] Amazon DSP audience fee. Amazon column: amazonDSPAudienceFee.

amazon_dsp_console_fee

float

[en] Amazon DSP console (platform) fee. Amazon column: amazonDSPConsoleFee.

app_store_first_opens

int

[en] First app opens (Amazon Appstore). Amazon column: appStoreFirstOpens.

app_store_first_opens_clicks

int

[en] First app opens (Amazon Appstore) (click attribution). Amazon column: appStoreFirstOpensClicks.

app_store_first_opens_rate

float

[en] First app opens (Amazon Appstore) ÷ impressions (rate). Amazon column: appStoreFirstOpensRate.

app_store_first_opens_views

int

[en] First app opens (Amazon Appstore) (view attribution: ad seen, not clicked). Amazon column: appStoreFirstOpensViews.

app_store_first_session_hours

float

[en] First-session hours in the app (Amazon Appstore). Amazon column: appStoreFirstSessionHours.

app_store_first_session_hours_clicks

float

[en] First-session hours in the app (Amazon Appstore) (click attribution). Amazon column: appStoreFirstSessionHoursClicks.

app_store_first_session_hours_views

float

[en] First-session hours in the app (Amazon Appstore) (view attribution: ad seen, not clicked). Amazon column: appStoreFirstSessionHoursViews.

app_store_opens

int

[en] App opens (Amazon Appstore). Amazon column: appStoreOpens.

app_store_opens_clicks

int

[en] App opens (Amazon Appstore) (click attribution). Amazon column: appStoreOpensClicks.

app_store_opens_rate

float

[en] App opens (Amazon Appstore) ÷ impressions (rate). Amazon column: appStoreOpensRate.

app_store_opens_views

int

[en] App opens (Amazon Appstore) (view attribution: ad seen, not clicked). Amazon column: appStoreOpensViews.

app_store_usage_hours

float

[en] App usage hours (Amazon Appstore). Amazon column: appStoreUsageHours.

app_store_usage_hours_clicks

float

[en] App usage hours (Amazon Appstore) (click attribution). Amazon column: appStoreUsageHoursClicks.

app_store_usage_hours_views

float

[en] App usage hours (Amazon Appstore) (view attribution: ad seen, not clicked). Amazon column: appStoreUsageHoursViews.

app_subscription_cost

text

[en] Cost per app subscription. Amazon column: appSubscriptionCost.

app_subscription_free_trial_cost

text

[en] Cost per app free-trial subscription. Amazon column: appSubscriptionFreeTrialCost.

app_subscription_sign_up

int

[en] App subscription sign-ups. Amazon column: appSubscriptionSignUp.

app_subscription_sign_up_clicks

int

[en] App subscription sign-ups (click attribution). Amazon column: appSubscriptionSignUpClicks.

app_subscription_sign_up_free_trial

int

[en] App free-trial subscription sign-ups. Amazon column: appSubscriptionSignUpFreeTrial.

app_subscription_sign_up_free_trial_clicks

int

[en] App free-trial subscription sign-ups (click attribution). Amazon column: appSubscriptionSignUpFreeTrialClicks.

app_subscription_sign_up_free_trial_rate

float

[en] App free-trial subscription sign-ups ÷ impressions (rate). Amazon column: appSubscriptionSignUpFreeTrialRate.

app_subscription_sign_up_free_trial_views

int

[en] App free-trial subscription sign-ups (view attribution: ad seen, not clicked). Amazon column: appSubscriptionSignUpFreeTrialViews.

app_subscription_sign_up_paid

int

[en] Paid app subscription sign-ups. Amazon column: appSubscriptionSignUpPaid.

app_subscription_sign_up_paid_clicks

int

[en] Paid app subscription sign-ups (click attribution). Amazon column: appSubscriptionSignUpPaidClicks.

app_subscription_sign_up_paid_cost

text

[en] Cost per paid app subscription. Amazon column: appSubscriptionSignUpPaidCost.

app_subscription_sign_up_paid_rate

float

[en] Paid app subscription sign-ups ÷ impressions (rate). Amazon column: appSubscriptionSignUpPaidRate.

app_subscription_sign_up_paid_views

int

[en] Paid app subscription sign-ups (view attribution: ad seen, not clicked). Amazon column: appSubscriptionSignUpPaidViews.

app_subscription_sign_up_rate

float

[en] App subscription sign-ups ÷ impressions (rate). Amazon column: appSubscriptionSignUpRate.

app_subscription_sign_up_views

int

[en] App subscription sign-ups (view attribution: ad seen, not clicked). Amazon column: appSubscriptionSignUpViews.

application

int

[en] Application conversions. Amazon column: application.

application_cpa

text

[en] Cost ÷ application conversions (cost per acquisition, CPA). Amazon column: applicationCPA.

application_cvr

float

[en] Application conversions ÷ clicks (conversion rate). Amazon column: applicationCVR.

application_clicks

int

[en] Application conversions (click attribution). Amazon column: applicationClicks.

application_value_average

text

[en] Average value reported on application conversions. Amazon column: applicationValueAverage.

application_value_sum

float

[en] Sum of the value reported on application conversions. Amazon column: applicationValueSum.

application_views

int

[en] Application conversions (view attribution: ad seen, not clicked). Amazon column: applicationViews.

asin

text

[en] Product ASIN. Amazon column: asin.

audio_ad_companion_banner_clicks

int

[en] Audio ad: companion banner clicks. Amazon column: audioAdCompanionBannerClicks.

audio_ad_companion_banner_views

int

[en] Audio ad: companion banner views. Amazon column: audioAdCompanionBannerViews.

audio_ad_completion_rate

float

[en] Audio ad: completion rate (complete ÷ starts). Amazon column: audioAdCompletionRate.

audio_ad_completions

int

[en] Audio ad: complete plays. Amazon column: audioAdCompletions.

audio_ad_first_quartile

int

[en] Audio ad: plays to 25%. Amazon column: audioAdFirstQuartile.

audio_ad_midpoint

int

[en] Audio ad: plays to 50%. Amazon column: audioAdMidpoint.

audio_ad_mute

int

[en] Audio ad: mutes. Amazon column: audioAdMute.

audio_ad_pause

int

[en] Audio ad: pauses. Amazon column: audioAdPause.

audio_ad_progression

int

[en] Audio ad: progression events. Amazon column: audioAdProgression.

audio_ad_resume

float

[en] Audio ad: resumes. Amazon column: audioAdResume.

audio_ad_rewind

int

[en] Audio ad: rewinds. Amazon column: audioAdRewind.

audio_ad_skip

int

[en] Audio ad: skips. Amazon column: audioAdSkip.

audio_ad_start

int

[en] Audio ad: starts. Amazon column: audioAdStart.

audio_ad_third_quartile

int

[en] Audio ad: plays to 75%. Amazon column: audioAdThirdQuartile.

audio_ad_unmute

int

[en] Audio ad: unmutes. Amazon column: audioAdUnmute.

audio_ad_views

int

[en] Audio ad: views. Amazon column: audioAdViews.

average_cost_per_click_to_apply

text

[en] Average cost per click-to-apply. Amazon column: averageCostPerClickToApply.

average_cost_per_kindle_detail_page_view

text

[en] Average cost per Kindle detail page view. Amazon column: averageCostPerKindleDetailPageView.

brand_name

text

[en] Brand name. Amazon column: brandName.

brand_search_rate

float

[en] Brand searches ÷ impressions. Amazon column: brandSearchRate.

brand_searches

int

[en] Brand searches on Amazon. Amazon column: brandSearches.

brand_searches_clicks

int

[en] Brand searches on Amazon (click attribution). Amazon column: brandSearchesClicks.

brand_searches_views

int

[en] Brand searches on Amazon (view attribution: ad seen, not clicked). Amazon column: brandSearchesViews.

browser_name

text

[en] Browser. Amazon column: browserName.

browser_version

text

[en] Browser version. Amazon column: browserVersion.

checkout

int

[en] Checkout conversions. Amazon column: checkout.

checkout_cpa

float

[en] Cost ÷ checkout conversions (cost per acquisition, CPA). Amazon column: checkoutCPA.

checkout_cvr

float

[en] Checkout conversions ÷ clicks (conversion rate). Amazon column: checkoutCVR.

checkout_clicks

int

[en] Checkout conversions (click attribution). Amazon column: checkoutClicks.

checkout_value_average

text

[en] Average value reported on checkout conversions. Amazon column: checkoutValueAverage.

checkout_value_sum

float

[en] Sum of the value reported on checkout conversions. Amazon column: checkoutValueSum.

checkout_views

int

[en] Checkout conversions (view attribution: ad seen, not clicked). Amazon column: checkoutViews.

city

text

[en] City (geo breakdown). Amazon column: city.

click_through_rate

float

[en] Click-through rate (CTR = clicks ÷ impressions). Amazon column: clickThroughRate.

click_to_apply

int

[en] Click-to-apply events. Amazon column: clickToApply.

click_to_apply_brand_halo

int

[en] Click-to-apply events of other products of the same brand, halo effect, not the advertised one. Amazon column: clickToApplyBrandHalo.

click_to_apply_brand_halo_clicks

int

[en] Click-to-apply events of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: clickToApplyBrandHaloClicks.

click_to_apply_brand_halo_views

int

[en] Click-to-apply events of other products of the same brand, halo effect, not the advertised one (view attribution: ad seen, not clicked). Amazon column: clickToApplyBrandHaloViews.

click_to_apply_clicks

int

[en] Click-to-apply events (click attribution). Amazon column: clickToApplyClicks.

click_to_apply_conversion_rate

float

[en] Click-to-apply ÷ clicks. Amazon column: clickToApplyConversionRate.

click_to_apply_views

int

[en] Click-to-apply events (view attribution: ad seen, not clicked). Amazon column: clickToApplyViews.

clicks

int

[en] Clicks on the ad. Amazon column: clicks.

combined_ecpp

float

[en] Effective cost: cost ÷ purchases on Amazon + off Amazon. Amazon column: combinedECPP.

combined_erpm

float

[en] Effective revenue per thousand impressions: sales (on Amazon + off Amazon) ÷ impressions × 1000. Amazon column: combinedERPM.

combined_product_sales

float

[en] Sales (value, in the account currency) on Amazon + off Amazon. Amazon column: combinedProductSales.

combined_purchase_rate

float

[en] Purchases (on Amazon + off Amazon) ÷ impressions (rate). Amazon column: combinedPurchaseRate.

combined_purchases

int

[en] Purchases on Amazon + off Amazon. Amazon column: combinedPurchases.

combined_purchases_clicks

int

[en] Purchases on Amazon + off Amazon (click attribution). Amazon column: combinedPurchasesClicks.

combined_purchases_views

int

[en] Purchases on Amazon + off Amazon (view attribution: ad seen, not clicked). Amazon column: combinedPurchasesViews.

combined_roas

float

[en] ROAS: sales (on Amazon + off Amazon) ÷ cost. Amazon column: combinedROAS.

combined_units_sold

int

[en] Units sold on Amazon + off Amazon. Amazon column: combinedUnitsSold.

contact

int

[en] Contact conversions. Amazon column: contact.

contact_cpa

float

[en] Cost ÷ contact conversions (cost per acquisition, CPA). Amazon column: contactCPA.

contact_cvr

float

[en] Contact conversions ÷ clicks (conversion rate). Amazon column: contactCVR.

contact_clicks

int

[en] Contact conversions (click attribution). Amazon column: contactClicks.

contact_value_average

text

[en] Average value reported on contact conversions. Amazon column: contactValueAverage.

contact_value_sum

float

[en] Sum of the value reported on contact conversions. Amazon column: contactValueSum.

contact_views

int

[en] Contact conversions (view attribution: ad seen, not clicked). Amazon column: contactViews.

conversion_type

text

[en] Row conversion type. Amazon column: conversionType.

country

text

[en] Country (geo breakdown). Amazon column: country.

creative_ad_id

text

[en] Id of the creative ad (text). Amazon column: creativeAdId.

creative_id

text

[en] Id of the creative (text). Amazon column: creativeId.

creative_language

text

[en] Creative language. Amazon column: creativeLanguage.

creative_name

text

[en] Name of the creative. Amazon column: creativeName.

creative_size

text

[en] Creative size. Amazon column: creativeSize.

creative_type

text

[en] Creative type. Amazon column: creativeType.

creative_weight

text

[en] Creative rotation weight. Amazon column: creativeWeight.

detail_page_view_brand_halo

int

[en] Product detail page views of other products of the same brand, halo effect, not the advertised one. Amazon column: detailPageViewBrandHalo.

detail_page_view_brand_halo_clicks

int

[en] Product detail page views of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: detailPageViewBrandHaloClicks.

detail_page_view_brand_halo_views

int

[en] Product detail page views of other products of the same brand, halo effect, not the advertised one (view attribution: ad seen, not clicked). Amazon column: detailPageViewBrandHaloViews.

detail_page_view_clicks

int

[en] Product detail page views (click attribution). Amazon column: detailPageViewClicks.

detail_page_view_rate

float

[en] Product detail page views ÷ impressions (rate). Amazon column: detailPageViewRate.

detail_page_view_rate_promoted_clicks

float

[en] Click-attributed detail page views of the promoted product ÷ clicks. Amazon column: detailPageViewRatePromotedClicks.

detail_page_view_views

int

[en] Product detail page views (view attribution: ad seen, not clicked). Amazon column: detailPageViewViews.

detail_page_views

int

[en] Product detail page views. Amazon column: detailPageViews.

device_name

text

[en] Device type. Amazon column: deviceName.

dma_code

text

[en] DMA (US market area) code. Amazon column: dmaCode.

dma_name

text

[en] DMA (US market area) name. Amazon column: dmaName.

downloaded_video_play_rate

float

[en] Downloaded video plays (Prime Video) ÷ impressions (rate). Amazon column: downloadedVideoPlayRate.

downloaded_video_plays

int

[en] Downloaded video plays (Prime Video). Amazon column: downloadedVideoPlays.

downloaded_video_plays_clicks

int

[en] Downloaded video plays (Prime Video) (click attribution). Amazon column: downloadedVideoPlaysClicks.

downloaded_video_plays_views

int

[en] Downloaded video plays (Prime Video) (view attribution: ad seen, not clicked). Amazon column: downloadedVideoPlaysViews.

e_cp_add_to_cart

float

[en] Effective cost: cost ÷ add-to-cart events. Amazon column: eCPAddToCart.

e_cp_add_to_list

float

[en] Effective cost: cost ÷ add-to-list events. Amazon column: eCPAddToList.

e_cp_add_to_watchlist

text

[en] Effective cost: cost ÷ add-to-watchlist events (Prime Video). Amazon column: eCPAddToWatchlist.

e_cp_alexa_skill_enable

text

[en] Effective cost: cost ÷ Alexa skill enables. Amazon column: eCPAlexaSkillEnable.

e_cp_app_store_first_opens

text

[en] Effective cost: cost ÷ first app opens (Amazon Appstore). Amazon column: eCPAppStoreFirstOpens.

e_cp_app_store_opens

text

[en] Effective cost: cost ÷ app opens (Amazon Appstore). Amazon column: eCPAppStoreOpens.

e_cp_audio_ad_completion

text

[en] Effective cost: cost ÷ audio ad completions. Amazon column: eCPAudioAdCompletion.

e_cp_brand_search

float

[en] Effective cost: cost ÷ brand searches on Amazon. Amazon column: eCPBrandSearch.

e_cpc

float

[en] Effective cost per click (total cost ÷ clicks). Amazon column: eCPC.

e_cp_detail_page_view

float

[en] Effective cost: cost ÷ product detail page views. Amazon column: eCPDetailPageView.

e_cp_downloaded_video_plays

text

[en] Effective cost: cost ÷ downloaded video plays (Prime Video). Amazon column: eCPDownloadedVideoPlays.

e_cp_free_trial_subscription_signup

text

[en] Effective cost: cost ÷ free-trial subscription sign-ups. Amazon column: eCPFreeTrialSubscriptionSignup.

e_cpm

float

[en] Effective cost per thousand impressions (total cost ÷ impressions × 1000). Amazon column: eCPM.

e_cpp

float

[en] Effective cost: cost ÷ purchases. Amazon column: eCPP.

e_cp_paid_subscription_signup

text

[en] Effective cost: cost ÷ paid subscription sign-ups. Amazon column: eCPPaidSubscriptionSignup.

e_cp_play_trailer

text

[en] Effective cost: cost ÷ trailer plays (Prime Video). Amazon column: eCPPlayTrailer.

e_cp_product_review_page_visit

float

[en] Effective cost: cost ÷ product review page visits. Amazon column: eCPProductReviewPageVisit.

e_cp_rental

text

[en] Effective cost: cost ÷ video rentals (Prime Video). Amazon column: eCPRental.

e_cp_skill_invocation

text

[en] Effective cost: cost ÷ Alexa skill invocations. Amazon column: eCPSkillInvocation.

e_cp_subscription_signup

text

[en] Effective cost: cost ÷ subscription sign-ups. Amazon column: eCPSubscriptionSignup.

e_cp_video_ad_completion

text

[en] Effective cost: cost ÷ video ad completions. Amazon column: eCPVideoAdCompletion.

e_cp_video_download

text

[en] Effective cost: cost ÷ video downloads (Prime Video). Amazon column: eCPVideoDownload.

e_cp_video_stream

text

[en] Effective cost: cost ÷ video streams (Prime Video). Amazon column: eCPVideoStream.

e_c_pnew_subscribe_and_save

float

[en] Effective cost: cost ÷ new Subscribe & Save subscriptions. Amazon column: eCPnewSubscribeAndSave.

e_rpm

float

[en] Effective revenue per thousand impressions (sales ÷ impressions × 1000). Amazon column: eRPM.

effective_cost_per_detail_page_view_promoted_clicks

float

[en] Effective cost per click-attributed detail page view of the promoted product. Amazon column: effectiveCostPerDetailPageViewPromotedClicks.

effective_cost_per_purchase_promoted_clicks

float

[en] Effective cost per click-attributed purchase of the promoted product. Amazon column: effectiveCostPerPurchasePromotedClicks.

effective_cost_per_skill_invocation

text

[en] Effective cost per Alexa skill invocation. Amazon column: effectiveCostPerSkillInvocation.

eink_detail_page_view

int

[en] Kindle e-ink detail page views. Amazon column: einkDetailPageView.

eink_detail_page_view_brand_halo

int

[en] Kindle e-ink detail page views of other products of the same brand, halo effect, not the advertised one. Amazon column: einkDetailPageViewBrandHalo.

eink_detail_page_view_brand_halo_clicks

int

[en] Kindle e-ink detail page views of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: einkDetailPageViewBrandHaloClicks.

eink_detail_page_view_brand_halo_views

int

[en] Kindle e-ink detail page views of other products of the same brand, halo effect, not the advertised one (view attribution: ad seen, not clicked). Amazon column: einkDetailPageViewBrandHaloViews.

eink_detail_page_view_clicks

int

[en] Kindle e-ink detail page views (click attribution). Amazon column: einkDetailPageViewClicks.

eink_detail_page_view_views

int

[en] Kindle e-ink detail page views (view attribution: ad seen, not clicked). Amazon column: einkDetailPageViewViews.

entity_id

text

[en] Entity (DSP account) id. Amazon column: entityId.

environment_name

text

[en] Environment (web, app). Amazon column: environmentName.

featured_asin

text

[en] ASIN featured in the creative. Amazon column: featuredAsin.

flight_budget

float

[en] Flight (delivery period) budget. Amazon column: flightBudget.

flight_end_date

text

[en] Flight end. Amazon column: flightEndDate.

flight_id

text

[en] Id of the flight (DSP delivery period) (text). Amazon column: flightId.

flight_name

text

[en] Name of the flight (DSP delivery period). Amazon column: flightName.

flight_start_date

text

[en] Flight start. Amazon column: flightStartDate.

free_trial_subscription_signup_clicks

int

[en] Free-trial subscription sign-ups (click attribution). Amazon column: freeTrialSubscriptionSignupClicks.

free_trial_subscription_signup_rate

float

[en] Free-trial subscription sign-ups ÷ impressions (rate). Amazon column: freeTrialSubscriptionSignupRate.

free_trial_subscription_signup_views

int

[en] Free-trial subscription sign-ups (view attribution: ad seen, not clicked). Amazon column: freeTrialSubscriptionSignupViews.

free_trial_subscription_signups

int

[en] Free-trial subscription sign-ups. Amazon column: freeTrialSubscriptionSignups.

frequency_average

float

[en] Average frequency: impressions ÷ reach. Amazon column: frequencyAverage.

gross_click_throughs

int

[en] Gross clicks, before filtering invalid traffic. Amazon column: grossClickThroughs.

gross_impressions

int

[en] Gross impressions, before filtering invalid traffic. Amazon column: grossImpressions.

household_frequency_average

float

[en] Average frequency per household. Amazon column: householdFrequencyAverage.

household_reach

int

[en] Unique households reached. Amazon column: householdReach.

impression_frequency_average

float

[en] Average frequency: impressions ÷ reach. Amazon column: impressionFrequencyAverage.

impressions

int

[en] Impressions: times the ad was shown. Amazon column: impressions.

interactive_impressions

int

[en] Interactive creative impressions. Amazon column: interactiveImpressions.

interval_end

text

[en] End of the interval Amazon split the period into (DSP week/month). Amazon column: intervalEnd.

interval_start

text

[en] Start of the interval Amazon split the period into (DSP week/month). Amazon column: intervalStart.

invalid_click_through_rate

float

[en] Invalid clicks ÷ gross clicks. Amazon column: invalidClickThroughRate.

invalid_click_throughs

int

[en] Clicks discarded as invalid traffic (not billed). Amazon column: invalidClickThroughs.

invalid_impression_rate

float

[en] Invalid impressions ÷ gross impressions. Amazon column: invalidImpressionRate.

invalid_impressions

int

[en] Impressions discarded as invalid traffic (not billed). Amazon column: invalidImpressions.

kindle_detail_page_view

int

[en] Kindle detail page views. Amazon column: kindleDetailPageView.

kindle_detail_page_view_clicks

int

[en] Kindle detail page views (click attribution). Amazon column: kindleDetailPageViewClicks.

kindle_detail_page_view_rate

float

[en] Kindle detail page views ÷ impressions (rate). Amazon column: kindleDetailPageViewRate.

kindle_detail_page_view_views

int

[en] Kindle detail page views (view attribution: ad seen, not clicked). Amazon column: kindleDetailPageViewViews.

kindle_edition_normalized_pages_read

int

[en] Kindle Unlimited pages read (KENP). Amazon column: kindleEditionNormalizedPagesRead.

kindle_edition_normalized_pages_read_from_clicks

int

[en] Kindle Unlimited pages read (KENP) (click attribution). Amazon column: kindleEditionNormalizedPagesReadFromClicks.

kindle_edition_normalized_pages_read_from_views

int

[en] Kindle Unlimited pages read (KENP) (view attribution: ad seen, not clicked). Amazon column: kindleEditionNormalizedPagesReadFromViews.

lead

int

[en] Leads. Amazon column: lead.

lead_cpa

float

[en] Cost ÷ leads (cost per acquisition, CPA). Amazon column: leadCPA.

lead_cvr

float

[en] Leads ÷ clicks (conversion rate). Amazon column: leadCVR.

lead_clicks

int

[en] Leads (click attribution). Amazon column: leadClicks.

lead_value_average

text

[en] Average value reported on leads. Amazon column: leadValueAverage.

lead_value_sum

float

[en] Sum of the value reported on leads. Amazon column: leadValueSum.

lead_views

int

[en] Leads (view attribution: ad seen, not clicked). Amazon column: leadViews.

line_item_approval_status

text

[en] Line item approval status. Amazon column: lineItemApprovalStatus.

line_item_budget

float

[en] Line item budget. Amazon column: lineItemBudget.

line_item_budget_cap

text

[en] Line item budget cap. Amazon column: lineItemBudgetCap.

line_item_comment

text

[en] Line item comment. Amazon column: lineItemComment.

line_item_comments

text

[en] Line item comments. Amazon column: lineItemComments.

line_item_end_date

text

[en] Line item end. Amazon column: lineItemEndDate.

line_item_external_id

text

[en] Line item external id. Amazon column: lineItemExternalId.

line_item_id

text

[en] Id of the line item (DSP) (text). Amazon column: lineItemId.

line_item_language_targeting

text

[en] Languages targeted by the line item. Amazon column: lineItemLanguageTargeting.

line_item_name

text

[en] Name of the line item (DSP). Amazon column: lineItemName.

line_item_start_date

text

[en] Line item start. Amazon column: lineItemStartDate.

line_item_status

text

[en] Status of the line item (DSP). Amazon column: lineItemStatus.

line_item_type

text

[en] Line item type (display, video, audio...). Amazon column: lineItemType.

long_term_roas

float

[en] Long-term ROAS: long-term sales ÷ cost. Amazon column: longTermROAS.

long_term_sales

float

[en] Long-term sales: sales attributed within 12 months (Sponsored Brands). Amazon column: longTermSales.

managed_service_fee

float

[en] Amazon managed service fee. Amazon column: managedServiceFee.

marketplace

text

[en] Amazon marketplace. Amazon column: marketplace.

master_clicks

int

[en] Clicks on the master creative. Amazon column: masterClicks.

master_impressions

int

[en] Impressions of the master creative in an ad with companions. Amazon column: masterImpressions.

measurable_impressions

int

[en] Impressions where viewability could be measured. Amazon column: measurableImpressions.

measurable_rate

float

[en] Measurable impressions ÷ impressions. Amazon column: measurableRate.

mobile_app_first_start_average

text

[en] Average value of mobile app first starts. Amazon column: mobileAppFirstStartAverage.

mobile_app_first_start_cpa

text

[en] Cost ÷ mobile app first starts (cost per acquisition, CPA). Amazon column: mobileAppFirstStartCPA.

mobile_app_first_start_cvr

float

[en] Mobile app first starts ÷ clicks (conversion rate). Amazon column: mobileAppFirstStartCVR.

mobile_app_first_start_clicks

int

[en] Mobile app first starts (click attribution). Amazon column: mobileAppFirstStartClicks.

mobile_app_first_start_sum

float

[en] Sum of the value of mobile app first starts. Amazon column: mobileAppFirstStartSum.

mobile_app_first_start_views

int

[en] Mobile app first starts (view attribution: ad seen, not clicked). Amazon column: mobileAppFirstStartViews.

mobile_app_first_starts

int

[en] Mobile app first starts. Amazon column: mobileAppFirstStarts.

multi_touch_purchases

int

[en] Purchases with multi-touch attribution, credit split across the ads on the path to purchase. Amazon column: multiTouchPurchases.

multi_touch_purchases_clicks

int

[en] Purchases with multi-touch attribution, credit split across the ads on the path to purchase (click attribution). Amazon column: multiTouchPurchasesClicks.

multi_touch_purchases_views

int

[en] Purchases with multi-touch attribution, credit split across the ads on the path to purchase (view attribution: ad seen, not clicked). Amazon column: multiTouchPurchasesViews.

multi_touch_sales

float

[en] Sales (value, in the account currency) with multi-touch attribution, credit split across the ads on the path to purchase. Amazon column: multiTouchSales.

multi_touch_total_purchase_rate

float

[en] Purchases (with multi-touch attribution, credit split across the ads on the path to purchase; in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: multiTouchTotalPurchaseRate.

multi_touch_total_purchases

int

[en] Purchases with multi-touch attribution, credit split across the ads on the path to purchase, in total: advertised product + other products of the same brand. Amazon column: multiTouchTotalPurchases.

multi_touch_total_purchases_clicks

int

[en] Purchases with multi-touch attribution, credit split across the ads on the path to purchase, in total: advertised product + other products of the same brand (click attribution). Amazon column: multiTouchTotalPurchasesClicks.

multi_touch_total_purchases_views

int

[en] Purchases with multi-touch attribution, credit split across the ads on the path to purchase, in total: advertised product + other products of the same brand (view attribution: ad seen, not clicked). Amazon column: multiTouchTotalPurchasesViews.

multi_touch_total_sales

float

[en] Sales (value, in the account currency) with multi-touch attribution, credit split across the ads on the path to purchase, in total: advertised product + other products of the same brand. Amazon column: multiTouchTotalSales.

multi_touch_total_units_sold

int

[en] Units sold with multi-touch attribution, credit split across the ads on the path to purchase, in total: advertised product + other products of the same brand. Amazon column: multiTouchTotalUnitsSold.

multi_touch_units_sold

int

[en] Units sold with multi-touch attribution, credit split across the ads on the path to purchase. Amazon column: multiTouchUnitsSold.

new_subscribe_and_save

int

[en] New Subscribe & Save subscriptions. Amazon column: newSubscribeAndSave.

new_subscribe_and_save_brand_halo

int

[en] New Subscribe & Save subscriptions of other products of the same brand, halo effect, not the advertised one. Amazon column: newSubscribeAndSaveBrandHalo.

new_subscribe_and_save_brand_halo_clicks

int

[en] New Subscribe & Save subscriptions of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: newSubscribeAndSaveBrandHaloClicks.

new_subscribe_and_save_brand_halo_views

int

[en] New Subscribe & Save subscriptions of other products of the same brand, halo effect, not the advertised one (view attribution: ad seen, not clicked). Amazon column: newSubscribeAndSaveBrandHaloViews.

new_subscribe_and_save_clicks

int

[en] New Subscribe & Save subscriptions (click attribution). Amazon column: newSubscribeAndSaveClicks.

new_subscribe_and_save_rate

float

[en] New Subscribe & Save subscriptions ÷ impressions (rate). Amazon column: newSubscribeAndSaveRate.

new_subscribe_and_save_views

int

[en] New Subscribe & Save subscriptions (view attribution: ad seen, not clicked). Amazon column: newSubscribeAndSaveViews.

new_to_brand_detail_page_view_clicks

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandDetailPageViewClicks.

new_to_brand_detail_page_view_rate

float

[en] Product detail page views (from new-to-brand customers, with no purchase from the brand in the last 12 months) ÷ impressions (rate). Amazon column: newToBrandDetailPageViewRate.

new_to_brand_detail_page_view_views

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months (view attribution: ad seen, not clicked). Amazon column: newToBrandDetailPageViewViews.

new_to_brand_detail_page_views

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandDetailPageViews.

new_to_brand_ecp_detail_page_view

float

[en] Effective cost: cost ÷ product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandECPDetailPageView.

new_to_brand_erpm

float

[en] Effective revenue per thousand impressions: sales (from new-to-brand customers, with no purchase from the brand in the last 12 months) ÷ impressions × 1000. Amazon column: newToBrandERPM.

new_to_brand_product_sales

float

[en] Sales (value, in the account currency) from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandProductSales.

new_to_brand_purchase_percentage_brand_halo

float

[en] Share of brand-halo purchases made by new-to-brand customers. Amazon column: newToBrandPurchasePercentageBrandHalo.

new_to_brand_purchase_rate

float

[en] Purchases (from new-to-brand customers, with no purchase from the brand in the last 12 months) ÷ impressions (rate). Amazon column: newToBrandPurchaseRate.

new_to_brand_purchases

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandPurchases.

new_to_brand_purchases_brand_halo

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months, of other products of the same brand, halo effect, not the advertised one. Amazon column: newToBrandPurchasesBrandHalo.

new_to_brand_purchases_brand_halo_clicks

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months, of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: newToBrandPurchasesBrandHaloClicks.

new_to_brand_purchases_brand_halo_views

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months, of other products of the same brand, halo effect, not the advertised one (view attribution: ad seen, not clicked). Amazon column: newToBrandPurchasesBrandHaloViews.

new_to_brand_purchases_clicks

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandPurchasesClicks.

new_to_brand_purchases_percentage

float

[en] Share of purchases that came from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandPurchasesPercentage.

new_to_brand_purchases_views

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months (view attribution: ad seen, not clicked). Amazon column: newToBrandPurchasesViews.

new_to_brand_roas

float

[en] ROAS: sales (from new-to-brand customers, with no purchase from the brand in the last 12 months) ÷ cost. Amazon column: newToBrandROAS.

new_to_brand_sales_brand_halo

float

[en] Sales (value, in the account currency) from new-to-brand customers, with no purchase from the brand in the last 12 months, of other products of the same brand, halo effect, not the advertised one. Amazon column: newToBrandSalesBrandHalo.

new_to_brand_units_sold

int

[en] Units sold from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandUnitsSold.

new_to_brand_units_sold_brand_halo

int

[en] Units sold from new-to-brand customers, with no purchase from the brand in the last 12 months, of other products of the same brand, halo effect, not the advertised one. Amazon column: newToBrandUnitsSoldBrandHalo.

notification_clicks

int

[en] Notification clicks. Amazon column: notificationClicks.

notification_opens

int

[en] Notification opens. Amazon column: notificationOpens.

off_amazon_cpa

text

[en] Cost per off-Amazon conversion (cost ÷ off-Amazon conversions). Amazon column: offAmazonCPA.

off_amazon_cvr

float

[en] Off-Amazon conversion rate (off-Amazon conversions ÷ clicks). Amazon column: offAmazonCVR.

off_amazon_clicks

int

[en] Off-Amazon conversions attributed to clicks. Amazon column: offAmazonClicks.

off_amazon_conversions

int

[en] Conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonConversions.

off_amazon_ecpp

text

[en] Effective cost: cost ÷ purchases off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonECPP.

off_amazon_erpm

float

[en] Effective revenue per thousand impressions: sales (off Amazon, on the advertiser site/app, measured by the conversion tag) ÷ impressions × 1000. Amazon column: offAmazonERPM.

off_amazon_product_sales

float

[en] Sales (value, in the account currency) off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonProductSales.

off_amazon_purchase_rate

float

[en] Purchases (off Amazon, on the advertiser site/app, measured by the conversion tag) ÷ impressions (rate). Amazon column: offAmazonPurchaseRate.

off_amazon_purchases

int

[en] Purchases off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonPurchases.

off_amazon_purchases_clicks

int

[en] Purchases off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonPurchasesClicks.

off_amazon_purchases_views

int

[en] Purchases off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonPurchasesViews.

off_amazon_roas

float

[en] ROAS: sales (off Amazon, on the advertiser site/app, measured by the conversion tag) ÷ cost. Amazon column: offAmazonROAS.

off_amazon_units_sold

int

[en] Units sold off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonUnitsSold.

off_amazon_views

int

[en] Off-Amazon conversions attributed to views (ad seen, not clicked). Amazon column: offAmazonViews.

omnichannel_metrics_fee

float

[en] Omnichannel metrics fee. Amazon column: omnichannelMetricsFee.

oms_line_item_id

text

[en] Line item id in the order management system (OMS). Amazon column: omsLineItemId.

oms_proposal_id

text

[en] Proposal id in the order management system (OMS). Amazon column: omsProposalId.

on_target_cpm

text

[en] Cost per thousand on-target impressions. Amazon column: onTargetCPM.

on_target_impression_cost

float

[en] Cost of on-target impressions. Amazon column: onTargetImpressionCost.

on_target_impressions

int

[en] Impressions delivered to the demographic target (third-party measurement, e.g. Nielsen). Amazon column: onTargetImpressions.

operating_system_name

text

[en] Operating system. Amazon column: operatingSystemName.

order_budget

float

[en] Order (DSP campaign) budget. Amazon column: orderBudget.

order_currency

text

[en] Order currency. Amazon column: orderCurrency.

order_end_date

text

[en] Order end. Amazon column: orderEndDate.

order_external_id

text

[en] Order external id, set by the advertiser. Amazon column: orderExternalId.

order_id

text

[en] Id of the order (DSP campaign) (text). Amazon column: orderId.

order_name

text

[en] Name of the order (DSP campaign). Amazon column: orderName.

order_start_date

text

[en] Order start. Amazon column: orderStartDate.

other

float

[en] "other" conversions. Amazon column: other.

other_cpa

float

[en] Cost ÷ "other" conversions (cost per acquisition, CPA). Amazon column: otherCPA.

other_cvr

float

[en] "other" conversions ÷ clicks (conversion rate). Amazon column: otherCVR.

other_clicks

int

[en] "other" conversions (click attribution). Amazon column: otherClicks.

other_value_average

text

[en] Average value reported on "other" conversions. Amazon column: otherValueAverage.

other_value_sum

float

[en] Sum of the value reported on "other" conversions. Amazon column: otherValueSum.

other_views

int

[en] "other" conversions (view attribution: ad seen, not clicked). Amazon column: otherViews.

page_view_cpa

float

[en] Cost ÷ page views (cost per acquisition, CPA). Amazon column: pageViewCPA.

page_view_cvr

float

[en] Page views ÷ clicks (conversion rate). Amazon column: pageViewCVR.

page_view_clicks

int

[en] Page views (click attribution). Amazon column: pageViewClicks.

page_view_value_average

text

[en] Average value reported on page views. Amazon column: pageViewValueAverage.

page_view_value_sum

float

[en] Sum of the value reported on page views. Amazon column: pageViewValueSum.

page_view_views

int

[en] Page views (view attribution: ad seen, not clicked). Amazon column: pageViewViews.

page_views

int

[en] Page views. Amazon column: pageViews.

paid_subscription_signup_clicks

int

[en] Paid subscription sign-ups (click attribution). Amazon column: paidSubscriptionSignupClicks.

paid_subscription_signup_rate

float

[en] Paid subscription sign-ups ÷ impressions (rate). Amazon column: paidSubscriptionSignupRate.

paid_subscription_signup_views

int

[en] Paid subscription sign-ups (view attribution: ad seen, not clicked). Amazon column: paidSubscriptionSignupViews.

paid_subscription_signups

int

[en] Paid subscription sign-ups. Amazon column: paidSubscriptionSignups.

parent_asin

text

[en] Parent ASIN (groups variations). Amazon column: parentAsin.

play_trailer_rate

float

[en] Trailer plays (Prime Video) ÷ impressions (rate). Amazon column: playTrailerRate.

play_trailers

int

[en] Trailer plays (Prime Video). Amazon column: playTrailers.

play_trailers_clicks

int

[en] Trailer plays (Prime Video) (click attribution). Amazon column: playTrailersClicks.

play_trailers_views

int

[en] Trailer plays (Prime Video) (view attribution: ad seen, not clicked). Amazon column: playTrailersViews.

postal_code

text

[en] Postal code (geo breakdown). Amazon column: postalCode.

product_category

text

[en] Product category. Amazon column: productCategory.

product_group

text

[en] Product group. Amazon column: productGroup.

product_name

text

[en] Product name. Amazon column: productName.

product_review_page_view_brand_halo

float

[en] Product review page visits of other products of the same brand, halo effect, not the advertised one. Amazon column: productReviewPageViewBrandHalo.

product_review_page_view_brand_halo_clicks

float

[en] Product review page visits of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: productReviewPageViewBrandHaloClicks.

product_review_page_view_brand_halo_views

float

[en] Product review page visits of other products of the same brand, halo effect, not the advertised one (view attribution: ad seen, not clicked). Amazon column: productReviewPageViewBrandHaloViews.

product_review_page_visit_rate

float

[en] Product review page visits ÷ impressions (rate). Amazon column: productReviewPageVisitRate.

product_review_page_visits

float

[en] Product review page visits. Amazon column: productReviewPageVisits.

product_review_page_visits_clicks

float

[en] Product review page visits (click attribution). Amazon column: productReviewPageVisitsClicks.

product_review_page_visits_views

float

[en] Product review page visits (view attribution: ad seen, not clicked). Amazon column: productReviewPageVisitsViews.

product_sub_category

text

[en] Product subcategory. Amazon column: productSubCategory.

proposal_id

text

[en] Proposal id. Amazon column: proposalId.

purchase_rate

float

[en] Purchases ÷ impressions. Amazon column: purchaseRate.

purchases

int

[en] Purchases. Amazon column: purchases.

purchases_brand_halo

int

[en] Purchases of other products of the same brand, halo effect, not the advertised one. Amazon column: purchasesBrandHalo.

purchases_brand_halo_clicks

int

[en] Purchases of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: purchasesBrandHaloClicks.

purchases_brand_halo_views

int

[en] Purchases of other products of the same brand, halo effect, not the advertised one (view attribution: ad seen, not clicked). Amazon column: purchasesBrandHaloViews.

purchases_clicks

int

[en] Purchases (click attribution). Amazon column: purchasesClicks.

purchases_clicks_rate

float

[en] Click-attributed purchases ÷ clicks. Amazon column: purchasesClicksRate.

purchases_views

int

[en] Purchases (view attribution: ad seen, not clicked). Amazon column: purchasesViews.

qualified_borrows

int

[en] Qualified e-book borrows. Amazon column: qualifiedBorrows.

qualified_borrows_from_clicks

int

[en] Qualified e-book borrows (click attribution). Amazon column: qualifiedBorrowsFromClicks.

qualified_borrows_from_views

int

[en] Qualified e-book borrows (view attribution: ad seen, not clicked). Amazon column: qualifiedBorrowsFromViews.

reach

int

[en] Reach: unique people who saw the ad in the period (not additive across days). Amazon column: reach.

region

text

[en] Region/state (geo breakdown). Amazon column: region.

rental_rate

float

[en] Video rentals (Prime Video) ÷ impressions (rate). Amazon column: rentalRate.

rentals

int

[en] Video rentals (Prime Video). Amazon column: rentals.

rentals_clicks

int

[en] Video rentals (Prime Video) (click attribution). Amazon column: rentalsClicks.

rentals_views

int

[en] Video rentals (Prime Video) (view attribution: ad seen, not clicked). Amazon column: rentalsViews.

report_granularity

text

[en] Report granularity reported by Amazon. Amazon column: reportGranularity.

royalty_qualified_borrows

float

[en] Royalty-qualified e-book borrows. Amazon column: royaltyQualifiedBorrows.

royalty_qualified_borrows_from_clicks

float

[en] Royalty-qualified e-book borrows (click attribution). Amazon column: royaltyQualifiedBorrowsFromClicks.

royalty_qualified_borrows_from_views

float

[en] Royalty-qualified e-book borrows (view attribution: ad seen, not clicked). Amazon column: royaltyQualifiedBorrowsFromViews.

sales

float

[en] Sales (value, in the account currency). Amazon column: sales.

sales_brand_halo

float

[en] Sales (value, in the account currency) of other products of the same brand, halo effect, not the advertised one. Amazon column: salesBrandHalo.

sales_clicks

float

[en] Sales (value, in the account currency) (click attribution). Amazon column: salesClicks.

sales_promoted

float

[en] Sales (value, in the account currency) of the advertised product. Amazon column: salesPromoted.

sales_promoted_clicks

float

[en] Sales (value, in the account currency) of the advertised product (click attribution). Amazon column: salesPromotedClicks.

search

int

[en] Search conversions. Amazon column: search.

search_cpa

float

[en] Cost ÷ search conversions (cost per acquisition, CPA). Amazon column: searchCPA.

search_cvr

float

[en] Search conversions ÷ clicks (conversion rate). Amazon column: searchCVR.

search_clicks

int

[en] Search conversions (click attribution). Amazon column: searchClicks.

search_value_average

text

[en] Average value reported on search conversions. Amazon column: searchValueAverage.

search_value_sum

float

[en] Sum of the value reported on search conversions. Amazon column: searchValueSum.

search_views

int

[en] Search conversions (view attribution: ad seen, not clicked). Amazon column: searchViews.

segment_class_code

text

[en] Audience class. Amazon column: segmentClassCode.

segment_id

text

[en] Id of the audience (segment) (text). Amazon column: segmentId.

segment_marketplace_id

text

[en] Audience marketplace. Amazon column: segmentMarketplaceId.

segment_name

text

[en] Audience (segment) name. Amazon column: segmentName.

segment_source

text

[en] Audience source (Amazon, third party, advertiser). Amazon column: segmentSource.

segment_type

text

[en] Audience type. Amazon column: segmentType.

sign_up

int

[en] Sign-ups. Amazon column: signUp.

sign_up_cpa

float

[en] Cost ÷ sign-ups (cost per acquisition, CPA). Amazon column: signUpCPA.

sign_up_cvr

float

[en] Sign-ups ÷ clicks (conversion rate). Amazon column: signUpCVR.

sign_up_clicks

int

[en] Sign-ups (click attribution). Amazon column: signUpClicks.

sign_up_value_average

text

[en] Average value reported on sign-ups. Amazon column: signUpValueAverage.

sign_up_value_sum

float

[en] Sum of the value reported on sign-ups. Amazon column: signUpValueSum.

sign_up_views

int

[en] Sign-ups (view attribution: ad seen, not clicked). Amazon column: signUpViews.

skill_invocation

int

[en] Alexa skill invocations. Amazon column: skillInvocation.

skill_invocation_clicks

int

[en] Alexa skill invocations (click attribution). Amazon column: skillInvocationClicks.

skill_invocation_rate

float

[en] Alexa skill invocations ÷ impressions (rate). Amazon column: skillInvocationRate.

skill_invocation_views

int

[en] Alexa skill invocations (view attribution: ad seen, not clicked). Amazon column: skillInvocationViews.

subscribe

int

[en] Subscribe conversions. Amazon column: subscribe.

subscribe_cpa

text

[en] Cost ÷ subscribe conversions (cost per acquisition, CPA). Amazon column: subscribeCPA.

subscribe_cvr

float

[en] Subscribe conversions ÷ clicks (conversion rate). Amazon column: subscribeCVR.

subscribe_clicks

int

[en] Subscribe conversions (click attribution). Amazon column: subscribeClicks.

subscribe_value_average

text

[en] Average value reported on subscribe conversions. Amazon column: subscribeValueAverage.

subscribe_value_sum

float

[en] Sum of the value reported on subscribe conversions. Amazon column: subscribeValueSum.

subscribe_views

int

[en] Subscribe conversions (view attribution: ad seen, not clicked). Amazon column: subscribeViews.

subscription_signup_clicks

int

[en] Subscription sign-ups (click attribution). Amazon column: subscriptionSignupClicks.

subscription_signup_rate

float

[en] Subscription sign-ups ÷ impressions (rate). Amazon column: subscriptionSignupRate.

subscription_signup_views

int

[en] Subscription sign-ups (view attribution: ad seen, not clicked). Amazon column: subscriptionSignupViews.

subscription_signups

int

[en] Subscription sign-ups. Amazon column: subscriptionSignups.

supply_cost

float

[en] DSP media (inventory) cost, without fees. Amazon column: supplyCost.

target_demographic

text

[en] Demographic target of the on-target measurement. Amazon column: targetDemographic.

targeting_method

text

[en] Targeting method. Amazon column: targetingMethod.

total_add_to_cart

int

[en] Add-to-cart events in total: advertised product + other products of the same brand. Amazon column: totalAddToCart.

total_add_to_cart_clicks

int

[en] Add-to-cart events in total: advertised product + other products of the same brand (click attribution). Amazon column: totalAddToCartClicks.

total_add_to_cart_rate

float

[en] Add-to-cart events (in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalAddToCartRate.

total_add_to_cart_views

int

[en] Add-to-cart events in total: advertised product + other products of the same brand (view attribution: ad seen, not clicked). Amazon column: totalAddToCartViews.

total_add_to_list

int

[en] Add-to-list events in total: advertised product + other products of the same brand. Amazon column: totalAddToList.

total_add_to_list_clicks

int

[en] Add-to-list events in total: advertised product + other products of the same brand (click attribution). Amazon column: totalAddToListClicks.

total_add_to_list_rate

float

[en] Add-to-list events (in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalAddToListRate.

total_add_to_list_views

int

[en] Add-to-list events in total: advertised product + other products of the same brand (view attribution: ad seen, not clicked). Amazon column: totalAddToListViews.

total_cost

float

[en] DSP total cost: media + Amazon and third-party fees, in the order currency. Amazon column: totalCost.

total_detail_page_view

int

[en] Product detail page views in total: advertised product + other products of the same brand. Amazon column: totalDetailPageView.

total_detail_page_view_clicks

int

[en] Product detail page views in total: advertised product + other products of the same brand (click attribution). Amazon column: totalDetailPageViewClicks.

total_detail_page_view_rate

float

[en] Product detail page views (in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalDetailPageViewRate.

total_detail_page_view_views

int

[en] Product detail page views in total: advertised product + other products of the same brand (view attribution: ad seen, not clicked). Amazon column: totalDetailPageViewViews.

total_ecp_add_to_cart

float

[en] Effective cost: cost ÷ add-to-cart events in total: advertised product + other products of the same brand. Amazon column: totalECPAddToCart.

total_ecp_add_to_list

float

[en] Effective cost: cost ÷ add-to-list events in total: advertised product + other products of the same brand. Amazon column: totalECPAddToList.

total_ecp_detail_page_view

float

[en] Effective cost: cost ÷ product detail page views in total: advertised product + other products of the same brand. Amazon column: totalECPDetailPageView.

total_ecpp

float

[en] Effective cost: cost ÷ purchases in total: advertised product + other products of the same brand. Amazon column: totalECPP.

total_ecp_product_review_page_visit

float

[en] Effective cost: cost ÷ product review page visits in total: advertised product + other products of the same brand. Amazon column: totalECPProductReviewPageVisit.

total_ecp_subscribe_and_save

float

[en] Effective cost: cost ÷ new Subscribe & Save subscriptions in total: advertised product + other products of the same brand. Amazon column: totalECPSubscribeAndSave.

total_erpm

float

[en] Effective revenue per thousand impressions: sales (in total: advertised product + other products of the same brand) ÷ impressions × 1000. Amazon column: totalERPM.

total_fee

float

[en] Sum of all DSP fees. Amazon column: totalFee.

total_new_to_brand_dpv_clicks

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months, in total: advertised product + other products of the same brand (click attribution). Amazon column: totalNewToBrandDPVClicks.

total_new_to_brand_dpv_rate

float

[en] Product detail page views (from new-to-brand customers, with no purchase from the brand in the last 12 months; in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalNewToBrandDPVRate.

total_new_to_brand_dpv_views

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months, in total: advertised product + other products of the same brand (view attribution: ad seen, not clicked). Amazon column: totalNewToBrandDPVViews.

total_new_to_brand_dp_vs

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months, in total: advertised product + other products of the same brand. Amazon column: totalNewToBrandDPVs.

total_new_to_brand_ecp_detail_page_view

float

[en] Effective cost: cost ÷ product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months, in total: advertised product + other products of the same brand. Amazon column: totalNewToBrandECPDetailPageView.

total_new_to_brand_ecpp

float

[en] Effective cost: cost ÷ purchases from new-to-brand customers, with no purchase from the brand in the last 12 months, in total: advertised product + other products of the same brand. Amazon column: totalNewToBrandECPP.

total_new_to_brand_erpm

float

[en] Effective revenue per thousand impressions: sales (from new-to-brand customers, with no purchase from the brand in the last 12 months; in total: advertised product + other products of the same brand) ÷ impressions × 1000. Amazon column: totalNewToBrandERPM.

total_new_to_brand_purchase_rate

float

[en] Purchases (from new-to-brand customers, with no purchase from the brand in the last 12 months; in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalNewToBrandPurchaseRate.

total_new_to_brand_purchases

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months, in total: advertised product + other products of the same brand. Amazon column: totalNewToBrandPurchases.

total_new_to_brand_purchases_clicks

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months, in total: advertised product + other products of the same brand (click attribution). Amazon column: totalNewToBrandPurchasesClicks.

total_new_to_brand_purchases_percentage

float

[en] Share of purchases (in total: advertised product + other products of the same brand) that came from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: totalNewToBrandPurchasesPercentage.

total_new_to_brand_purchases_views

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months, in total: advertised product + other products of the same brand (view attribution: ad seen, not clicked). Amazon column: totalNewToBrandPurchasesViews.

total_new_to_brand_roas

float

[en] ROAS: sales (from new-to-brand customers, with no purchase from the brand in the last 12 months; in total: advertised product + other products of the same brand) ÷ cost. Amazon column: totalNewToBrandROAS.

total_new_to_brand_sales

float

[en] Sales (value, in the account currency) from new-to-brand customers, with no purchase from the brand in the last 12 months, in total: advertised product + other products of the same brand. Amazon column: totalNewToBrandSales.

total_new_to_brand_units_sold

int

[en] Units sold from new-to-brand customers, with no purchase from the brand in the last 12 months, in total: advertised product + other products of the same brand. Amazon column: totalNewToBrandUnitsSold.

total_product_review_page_visit_rate

float

[en] Product review page visits (in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalProductReviewPageVisitRate.

total_product_review_page_visits

float

[en] Product review page visits in total: advertised product + other products of the same brand. Amazon column: totalProductReviewPageVisits.

total_product_review_page_visits_clicks

float

[en] Product review page visits in total: advertised product + other products of the same brand (click attribution). Amazon column: totalProductReviewPageVisitsClicks.

total_product_review_page_visits_views

float

[en] Product review page visits in total: advertised product + other products of the same brand (view attribution: ad seen, not clicked). Amazon column: totalProductReviewPageVisitsViews.

total_purchase_rate

float

[en] Purchases (in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalPurchaseRate.

total_purchases

int

[en] Purchases in total: advertised product + other products of the same brand. Amazon column: totalPurchases.

total_purchases_clicks

int

[en] Purchases in total: advertised product + other products of the same brand (click attribution). Amazon column: totalPurchasesClicks.

total_purchases_views

int

[en] Purchases in total: advertised product + other products of the same brand (view attribution: ad seen, not clicked). Amazon column: totalPurchasesViews.

total_roas

float

[en] ROAS: sales (in total: advertised product + other products of the same brand) ÷ cost. Amazon column: totalROAS.

total_sales

float

[en] Sales (value, in the account currency) in total: advertised product + other products of the same brand. Amazon column: totalSales.

total_subscribe_and_save

int

[en] New Subscribe & Save subscriptions in total: advertised product + other products of the same brand. Amazon column: totalSubscribeAndSave.

total_subscribe_and_save_clicks

int

[en] New Subscribe & Save subscriptions in total: advertised product + other products of the same brand (click attribution). Amazon column: totalSubscribeAndSaveClicks.

total_subscribe_and_save_rate

float

[en] New Subscribe & Save subscriptions (in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalSubscribeAndSaveRate.

total_subscribe_and_save_views

int

[en] New Subscribe & Save subscriptions in total: advertised product + other products of the same brand (view attribution: ad seen, not clicked). Amazon column: totalSubscribeAndSaveViews.

total_units_sold

int

[en] Units sold in total: advertised product + other products of the same brand. Amazon column: totalUnitsSold.

units_sold

int

[en] Units sold. Amazon column: unitsSold.

units_sold_brand_halo

int

[en] Units sold of other products of the same brand, halo effect, not the advertised one. Amazon column: unitsSoldBrandHalo.

units_sold_clicks

int

[en] Units sold (click attribution). Amazon column: unitsSoldClicks.

units_sold_promoted_clicks

int

[en] Units sold of the advertised product (click attribution). Amazon column: unitsSoldPromotedClicks.

video_ad_clicks

int

[en] Video ad: clicks. Amazon column: videoAdClicks.

video_ad_complete

float

[en] Video ad: complete plays. Amazon column: videoAdComplete.

video_ad_completion_rate

float

[en] Video ad: completion rate (complete ÷ starts). Amazon column: videoAdCompletionRate.

video_ad_creative_views

int

[en] Video ad: creative views. Amazon column: videoAdCreativeViews.

video_ad_end_state_clicks

int

[en] Video ad: end-card clicks. Amazon column: videoAdEndStateClicks.

video_ad_first_quartile

int

[en] Video ad: plays to 25%. Amazon column: videoAdFirstQuartile.

video_ad_impressions

int

[en] Video ad: impressions. Amazon column: videoAdImpressions.

video_ad_midpoint

int

[en] Video ad: plays to 50%. Amazon column: videoAdMidpoint.

video_ad_mute

int

[en] Video ad: mutes. Amazon column: videoAdMute.

video_ad_pause

int

[en] Video ad: pauses. Amazon column: videoAdPause.

video_ad_replays

int

[en] Video ad: replays. Amazon column: videoAdReplays.

video_ad_resume

float

[en] Video ad: resumes. Amazon column: videoAdResume.

video_ad_skip_backs

int

[en] Video ad: skip-backs. Amazon column: videoAdSkipBacks.

video_ad_skip_forwards

int

[en] Video ad: skip-forwards. Amazon column: videoAdSkipForwards.

video_ad_start

int

[en] Video ad: starts. Amazon column: videoAdStart.

video_ad_third_quartile

int

[en] Video ad: plays to 75%. Amazon column: videoAdThirdQuartile.

video_ad_unmute

int

[en] Video ad: unmutes. Amazon column: videoAdUnmute.

video_download_rate

float

[en] Video downloads (Prime Video) ÷ impressions (rate). Amazon column: videoDownloadRate.

video_downloads

int

[en] Video downloads (Prime Video). Amazon column: videoDownloads.

video_downloads_clicks

int

[en] Video downloads (Prime Video) (click attribution). Amazon column: videoDownloadsClicks.

video_downloads_views

int

[en] Video downloads (Prime Video) (view attribution: ad seen, not clicked). Amazon column: videoDownloadsViews.

video_streams

float

[en] Video streams (Prime Video). Amazon column: videoStreams.

video_streams_clicks

int

[en] Video streams (Prime Video) (click attribution). Amazon column: videoStreamsClicks.

video_streams_rate

float

[en] Video streams (Prime Video) ÷ impressions (rate). Amazon column: videoStreamsRate.

video_streams_views

int

[en] Video streams (Prime Video) (view attribution: ad seen, not clicked). Amazon column: videoStreamsViews.

viewability_rate

float

[en] Viewability rate (viewable impressions ÷ measurable impressions). Amazon column: viewabilityRate.

viewable_impressions

int

[en] Viewable impressions under the MRC standard (≥50% of pixels for ≥1 s; video 2 s). Amazon column: viewableImpressions.

Metadata: Advertising accounts (profiles)

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Amazon Ads metadata (listing). One row per advertising account (profile) visible to the login: seller, vendor or DSP agency, one per country/marketplace.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

account_info_id

text

[en] Account (advertiser) id on Amazon. Amazon field: accountInfo__id.

account_info_marketplace_string_id

text

[en] Account marketplace id. Amazon field: accountInfo__marketplaceStringId.

account_info_name

text

[en] Account name. Amazon field: accountInfo__name.

account_info_sub_type

text

[en] Account subtype. Amazon field: accountInfo__subType.

account_info_type

text

[en] Account type: seller, vendor or agency (DSP). Amazon field: accountInfo__type.

account_info_valid_payment_method

boolean

[en] true = the account has a valid payment method. Amazon field: accountInfo__validPaymentMethod.

country_code

text

[en] Marketplace country (e.g. BR, US). Amazon field: countryCode.

currency_code

text

[en] Currency. Amazon field: currencyCode.

daily_budget

float

[en] Daily budget. Amazon field: dailyBudget.

timezone

text

[en] Account time zone. Amazon field: timezone.

Metadata: Amazon DSP - ad groups (line items)

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Amazon DSP ad group (line item), with its campaign.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

ad_group_id

text

[en] Id of the ad group (text). Amazon field: adGroupId.

advertiser_id

text

[en] Id of the DSP advertiser the row came from.

    Metadata: Amazon DSP - advertisers > > advertiser_id

advertised_product_category_ids

text

[en] Categories of the advertised products. Amazon field: advertisedProductCategoryIds. List/object stored as JSON.

bid_base_bid

float

[en] Base bid. Amazon field: bid__baseBid.

bid_currency_code

text

[en] Bid currency. Amazon field: bid__currencyCode.

bid_max_average_cpm

float

[en] Bid maximum average CPM. Amazon field: bid__maxAverageCPM.

budget_amount

float

[en] Budget amount. Amazon field: budgetAmount.

budget_caps

text

[en] Budget caps. Amazon field: budgetCaps. List/object stored as JSON.

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Amazon DSP - campaigns (orders) > > campaign_id

creation_date_time

text

[en] Creation date. Amazon field: creationDateTime.

creative_rotation_type

text

[en] Creative rotation type. Amazon field: creativeRotationType.

delivery_status

text

[en] Delivery status. Amazon field: deliveryStatus.

end_date_time

text

[en] End date and time. Amazon field: endDateTime.

fees

text

[en] Fees. Amazon field: fees. List/object stored as JSON.

frequencies

text

[en] Frequency caps. Amazon field: frequencies. List/object stored as JSON.

inventory_type

text

[en] Inventory type. Amazon field: inventoryType.

last_updated_date_time

text

[en] Last update date. Amazon field: lastUpdatedDateTime.

name

text

[en] Name. Amazon field: name.

optimization_automate_budget_allocation

boolean

[en] Optimization: true = Amazon allocates the budget automatically. Amazon field: optimization__automateBudgetAllocation.

optimization_bid_strategy

text

[en] Optimization: bid strategy. Amazon field: optimization__bidStrategy.

optimization_daily_min_spend_amount

float

[en] Optimization: daily minimum spend. Amazon field: optimization__dailyMinSpendAmount.

pacing_catch_up_boost_percentage

int

[en] Pacing: catch-up boost percentage. Amazon field: pacing__catchUpBoostPercentage.

pacing_delivery_profile

text

[en] Pacing: delivery profile (even, accelerated). Amazon field: pacing__deliveryProfile.

start_date_time

text

[en] Start date and time. Amazon field: startDateTime.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

targeting_settings_amazon_viewability_include_unmeasurable_i

boolean

[en] Targeting: true = include impressions whose viewability cannot be measured. Amazon field: targetingSettings__amazonViewability__includeUnmeasurableImpressions.

targeting_settings_amazon_viewability_viewability_tier

text

[en] Targeting: minimum viewability tier. Amazon field: targetingSettings__amazonViewability__viewabilityTier.

targeting_settings_automated_targeting_tactic

text

[en] Targeting: automated targeting tactic. Amazon field: targetingSettings__automatedTargetingTactic.

targeting_settings_default_audience_targeting_match_type

text

[en] Targeting: default audience match type. Amazon field: targetingSettings__defaultAudienceTargetingMatchType.

targeting_settings_enable_language_targeting

boolean

[en] Targeting: true = language targeting on. Amazon field: targetingSettings__enableLanguageTargeting.

targeting_settings_site_language

text

[en] Targeting: site language. Amazon field: targetingSettings__siteLanguage.

targeting_settings_tactics_converters_exclusion_type

text

[en] Targeting: converters exclusion type. Amazon field: targetingSettings__tacticsConvertersExclusionType.

targeting_settings_targeted_pg_deal_id

text

[en] Targeting: programmatic guaranteed deal id. Amazon field: targetingSettings__targetedPGDealId.

targeting_settings_time_zone_type

text

[en] Targeting: time zone used for scheduling. Amazon field: targetingSettings__timeZoneType.

targeting_settings_user_location

text

[en] Targeting: user location. Amazon field: targetingSettings__userLocation.

targeting_settings_user_location_signal

text

[en] Targeting: signal used for the user location. Amazon field: targetingSettings__userLocationSignal.

targeting_settings_video_completion_tier

text

[en] Targeting: minimum video completion tier. Amazon field: targetingSettings__videoCompletionTier.

Metadata: Amazon DSP - advertisers

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Amazon DSP advertiser of each agency.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

advertiser_id

text

[en] Id of the DSP advertiser (text). Amazon field: advertiserId.

country

text

[en] Country. Amazon field: country.

currency

text

[en] Currency. Amazon field: currency.

is_regional

boolean

[en] true = regional account. Amazon field: isRegional.

name

text

[en] Name. Amazon field: name.

timezone

text

[en] Account time zone. Amazon field: timezone.

url

text

[en] URL. Amazon field: url.

Metadata: Amazon DSP - campaigns (orders)

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Amazon DSP campaign (order), per advertiser.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

adomains

text

[en] Advertiser domains (DSP). Amazon field: adomains. List/object stored as JSON.

advertiser_id

text

[en] Id of the DSP advertiser (text). Amazon field: advertiserId.

    Metadata: Amazon DSP - advertisers > > advertiser_id

brand_id

text

[en] Brand id. Amazon field: brandId.

budget_caps

text

[en] Budget caps. Amazon field: budgetCaps. List/object stored as JSON.

country

text

[en] Country. Amazon field: country.

creation_date_time

text

[en] Creation date. Amazon field: creationDateTime.

delivery_status

text

[en] Delivery status. Amazon field: deliveryStatus.

end_date_time

text

[en] End date and time. Amazon field: endDateTime.

fees

text

[en] Fees. Amazon field: fees. List/object stored as JSON.

flights

text

[en] Flights (delivery periods). Amazon field: flights. List/object stored as JSON.

frequencies

text

[en] Frequency caps. Amazon field: frequencies. List/object stored as JSON.

last_updated_date_time

text

[en] Last update date. Amazon field: lastUpdatedDateTime.

marketplace_id

text

[en] Marketplace id. Amazon field: marketplaceId.

name

text

[en] Name. Amazon field: name.

optimization_automate_bid_allocation

boolean

[en] Optimization: true = Amazon allocates the bid automatically. Amazon field: optimization__automateBidAllocation.

optimization_automate_budget_allocation

boolean

[en] Optimization: true = Amazon allocates the budget automatically. Amazon field: optimization__automateBudgetAllocation.

optimization_bid_strategy

text

[en] Optimization: bid strategy. Amazon field: optimization__bidStrategy.

optimization_flight_budget_rollover_setting_rollover_strateg

text

[en] Optimization: how unspent flight budget rolls over. Amazon field: optimization__flightBudgetRolloverSetting__rolloverStrategy.

optimization_goal_setting_currency_code

text

[en] Optimization: goal currency. Amazon field: optimization__goalSetting__currencyCode.

optimization_goal_setting_goal

text

[en] Optimization: campaign goal. Amazon field: optimization__goalSetting__goal.

optimization_goal_setting_kpi

text

[en] Optimization: goal KPI (e.g. ROAS, CPA). Amazon field: optimization__goalSetting__kpi.

optimization_primary_inventory_types

text

[en] Optimization: primary inventory types. Amazon field: optimization__primaryInventoryTypes. List/object stored as JSON.

start_date_time

text

[en] Start date and time. Amazon field: startDateTime.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

targets_amazon_deal

boolean

[en] true = targets an Amazon deal. Amazon field: targetsAmazonDeal.

Metadata: Portfolios

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per portfolio (campaign grouping with a shared budget) of each account.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

portfolio_id

text

[en] Id of the portfolio (text). Amazon field: portfolioId.

budget_controls_campaign_unspent_budget_sharing_feature_stat

text

[en] Unspent budget sharing between campaigns (on/off). Amazon field: budgetControls__campaignUnspentBudgetSharing__featureState.

budget_amount

float

[en] Budget amount. Amazon field: budget__amount.

budget_currency_code

text

[en] Budget currency. Amazon field: budget__currencyCode.

budget_end_date

text

[en] Budget end. Amazon field: budget__endDate.

budget_policy

text

[en] Budget policy. Amazon field: budget__policy.

budget_start_date

text

[en] Budget start. Amazon field: budget__startDate.

in_budget

boolean

[en] true = the campaign still has budget. Amazon field: inBudget.

name

text

[en] Name. Amazon field: name.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored Brands - ad groups

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Brands ad group.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

ad_group_id

text

[en] Id of the ad group (text). Amazon field: adGroupId.

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Sponsored Brands - campaigns > > campaign_id

name

text

[en] Name. Amazon field: name.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored Brands - ads

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Brands ad; legacy ads without adId are identified by their ad group (ad_key).

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

ad_key

text

[en] Ad key: the adId, or 'ad_group:<ad group id>' for the legacy ads Amazon returns without adId (at most one of those per ad group).

ad_group_id

text

[en] Id of the ad group (text). Amazon field: adGroupId.

    Metadata: Sponsored Brands - ad groups > > ad_group_id

ad_id

text

[en] Id of the ad (text). Amazon field: adId.

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Sponsored Brands - campaigns > > campaign_id

creative_asins

text

[en] Creative: ASINs shown in the ad. Amazon field: creative__asins. List/object stored as JSON.

creative_brand_logo_asset_id

text

[en] Creative: brand logo asset id. Amazon field: creative__brandLogoAssetID.

creative_brand_logo_crop_height

int

[en] Creative: brand logo crop, height. Amazon field: creative__brandLogoCrop__height.

creative_brand_logo_crop_left

int

[en] Creative: brand logo crop, left offset. Amazon field: creative__brandLogoCrop__left.

creative_brand_logo_crop_top

int

[en] Creative: brand logo crop, top offset. Amazon field: creative__brandLogoCrop__top.

creative_brand_logo_crop_width

int

[en] Creative: brand logo crop, width. Amazon field: creative__brandLogoCrop__width.

creative_brand_logo_url

text

[en] Creative: brand logo URL. Amazon field: creative__brandLogoUrl.

creative_brand_name

text

[en] Creative: brand name shown. Amazon field: creative__brandName.

creative_collection_type

text

[en] Creative: product collection type. Amazon field: creative__collectionType.

creative_consent_to_translate

boolean

[en] Creative: true = Amazon may translate the text. Amazon field: creative__consentToTranslate.

creative_creative_properties_to_optimize

text

[en] Creative: properties Amazon may optimize. Amazon field: creative__creativePropertiesToOptimize. List/object stored as JSON.

creative_creative_status

text

[en] Creative: moderation status. Amazon field: creative__creativeStatus.

creative_creative_version

text

[en] Creative: version. Amazon field: creative__creativeVersion.

creative_custom_image_asset_id

text

[en] Creative: custom image asset id. Amazon field: creative__customImageAssetId.

creative_custom_image_crop_height

int

[en] Creative: custom image crop, height. Amazon field: creative__customImageCrop__height.

creative_custom_image_crop_left

int

[en] Creative: custom image crop, left offset. Amazon field: creative__customImageCrop__left.

creative_custom_image_crop_top

int

[en] Creative: custom image crop, top offset. Amazon field: creative__customImageCrop__top.

creative_custom_image_crop_width

int

[en] Creative: custom image crop, width. Amazon field: creative__customImageCrop__width.

creative_custom_image_url

text

[en] Creative: custom image URL. Amazon field: creative__customImageUrl.

creative_custom_images

text

[en] Creative: custom images. Amazon field: creative__customImages. List/object stored as JSON.

creative_headline

text

[en] Creative: ad headline. Amazon field: creative__headline.

creative_headlines

text

[en] Creative: ad headlines. Amazon field: creative__headlines. List/object stored as JSON.

creative_original_headline

text

[en] Creative: original headline, before translation. Amazon field: creative__originalHeadline.

creative_original_headlines

text

[en] Creative: original headlines, before translation. Amazon field: creative__originalHeadlines. List/object stored as JSON.

creative_original_video_asset_ids

text

[en] Creative: original video asset ids. Amazon field: creative__originalVideoAssetIds. List/object stored as JSON.

creative_subpages

text

[en] Creative: Brand Store subpages. Amazon field: creative__subpages. List/object stored as JSON.

creative_type

text

[en] Creative: format (product collection, store spotlight, video). Amazon field: creative__type.

creative_video_asset_ids

text

[en] Creative: video asset ids. Amazon field: creative__videoAssetIds. List/object stored as JSON.

extended_data_creation_date

int

[en] Creation date. Amazon field: extendedData__creationDate.

extended_data_last_update_date

int

[en] Last update date. Amazon field: extendedData__lastUpdateDate.

extended_data_serving_status

text

[en] Serving status. Amazon field: extendedData__servingStatus.

extended_data_serving_status_details

text

[en] Serving status details. Amazon field: extendedData__servingStatusDetails. List/object stored as JSON.

landing_page_page_type

text

[en] Landing page type. Amazon field: landingPage__pageType.

landing_page_url

text

[en] Landing page URL. Amazon field: landingPage__url.

name

text

[en] Name. Amazon field: name.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored Brands - campaigns

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Brands campaign.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

bidding_bid_adjustments_by_placement

text

[en] Bid adjustments by placement (top of search, product page). Amazon field: bidding__bidAdjustmentsByPlacement. List/object stored as JSON.

bidding_bid_optimization

boolean

[en] Bid optimization. Amazon field: bidding__bidOptimization.

bidding_bid_optimization_strategy

text

[en] Bid optimization strategy. Amazon field: bidding__bidOptimizationStrategy.

bidding_shopper_cohort_bid_adjustments

text

[en] Bid adjustments by shopper cohort. Amazon field: bidding__shopperCohortBidAdjustments. List/object stored as JSON.

budget

float

[en] Budget. Amazon field: budget.

budget_type

text

[en] Budget type (daily, lifetime). Amazon field: budgetType.

cost_type

text

[en] Billing model (e.g. CPC, vCPM). Amazon field: costType.

end_date

text

[en] End date. Amazon field: endDate.

goal

text

[en] Campaign goal. Amazon field: goal.

is_multi_ad_groups_enabled

boolean

[en] true = campaign with multiple ad groups. Amazon field: isMultiAdGroupsEnabled.

kpi

text

[en] Goal key performance indicator. Amazon field: kpi.

name

text

[en] Name. Amazon field: name.

portfolio_id

text

[en] Id of the portfolio (text). Amazon field: portfolioId.

    Metadata: Portfolios > > portfolio_id

product_location

text

[en] Where the products are sold. Amazon field: productLocation.

smart_default

text

[en] Default automatic targets. Amazon field: smartDefault. List/object stored as JSON.

start_date

text

[en] Start date. Amazon field: startDate.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored Brands - keywords

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Brands keyword.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

keyword_id

text

[en] Id of the keyword (text). Amazon field: keywordId.

ad_group_id

text

[en] Id of the ad group (text). Amazon field: adGroupId.

    Metadata: Sponsored Brands - ad groups > > ad_group_id

bid

float

[en] Bid. Amazon field: bid.

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Sponsored Brands - campaigns > > campaign_id

keyword_text

text

[en] Keyword text. Amazon field: keywordText.

match_type

text

[en] Match type (exact, phrase, broad). Amazon field: matchType.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored Display - ad groups

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Display ad group.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

ad_group_id

text

[en] Id of the ad group (text). Amazon field: adGroupId.

bid_optimization

text

[en] Automatic bid optimization. Amazon field: bidOptimization.

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Sponsored Display - campaigns > > campaign_id

creative_type

text

[en] Creative type. Amazon field: creativeType.

default_bid

float

[en] Ad group default bid. Amazon field: defaultBid.

name

text

[en] Name. Amazon field: name.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

tactic

text

[en] Targeting tactic (Sponsored Display). Amazon field: tactic.

Metadata: Sponsored Display - campaigns

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Display campaign.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

budget

float

[en] Budget. Amazon field: budget.

budget_type

text

[en] Budget type (daily, lifetime). Amazon field: budgetType.

cost_type

text

[en] Billing model (e.g. CPC, vCPM). Amazon field: costType.

delivery_profile

text

[en] Delivery profile (pacing). Amazon field: deliveryProfile.

end_date

text

[en] End date. Amazon field: endDate.

name

text

[en] Name. Amazon field: name.

portfolio_id

text

[en] Id of the portfolio (text). Amazon field: portfolioId.

    Metadata: Portfolios > > portfolio_id

rule_based_budget_is_processing

boolean

[en] true = budget rule being processed. Amazon field: ruleBasedBudget__isProcessing.

start_date

text

[en] Start date. Amazon field: startDate.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

tactic

text

[en] Targeting tactic (Sponsored Display). Amazon field: tactic.

Metadata: Sponsored Display - product ads

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Display product ad.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

ad_id

text

[en] Id of the ad (text). Amazon field: adId.

ad_group_id

text

[en] Id of the ad group (text). Amazon field: adGroupId.

    Metadata: Sponsored Display - ad groups > > ad_group_id

asin

text

[en] Advertised product ASIN. Amazon field: asin.

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Sponsored Display - campaigns > > campaign_id

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored Display - targets

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Display target (audience/product/contextual).

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

target_id

text

[en] Id of the target (text). Amazon field: targetId.

ad_group_id

text

[en] Id of the ad group (text). Amazon field: adGroupId.

    Metadata: Sponsored Display - ad groups > > ad_group_id

bid

float

[en] Bid. Amazon field: bid.

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Sponsored Display - campaigns > > campaign_id

expression

text

[en] Targeting expression. Amazon field: expression. List/object stored as JSON.

expression_type

text

[en] Expression type (manual or auto). Amazon field: expressionType.

resolved_expression

text

[en] Targeting expression as resolved by Amazon. Amazon field: resolvedExpression. List/object stored as JSON.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored Products - ad groups

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Products ad group, with its campaign and default bid.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

ad_group_id

text

[en] Id of the ad group (text). Amazon field: adGroupId.

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Sponsored Products - campaigns > > campaign_id

default_bid

float

[en] Ad group default bid. Amazon field: defaultBid.

name

text

[en] Name. Amazon field: name.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored Products - campaign negative keywords

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Products campaign negative keyword.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

keyword_id

text

[en] Id of the keyword (text). Amazon field: keywordId.

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Sponsored Products - campaigns > > campaign_id

keyword_text

text

[en] Keyword text. Amazon field: keywordText.

match_type

text

[en] Match type (exact, phrase, broad). Amazon field: matchType.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored Products - campaigns

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Products campaign: name, state, budget, bidding strategy, dates.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

budget_budget

float

[en] Budget amount. Amazon field: budget__budget.

budget_budget_type

text

[en] Budget type (daily, lifetime). Amazon field: budget__budgetType.

dynamic_bidding_placement_bidding

text

[en] Bid adjustments by placement. Amazon field: dynamicBidding__placementBidding. List/object stored as JSON.

dynamic_bidding_shopper_cohort_bidding

text

[en] Bid adjustments by shopper cohort. Amazon field: dynamicBidding__shopperCohortBidding. List/object stored as JSON.

dynamic_bidding_strategy

text

[en] Dynamic bidding strategy (down only, up and down, fixed). Amazon field: dynamicBidding__strategy.

end_date

text

[en] End date. Amazon field: endDate.

marketplace_budget_allocation

text

[en] Budget allocation across marketplaces. Amazon field: marketplaceBudgetAllocation.

name

text

[en] Name. Amazon field: name.

off_amazon_settings

text

[en] Off-Amazon delivery settings. Amazon field: offAmazonSettings. List/object stored as JSON.

portfolio_id

text

[en] Id of the portfolio (text). Amazon field: portfolioId.

    Metadata: Portfolios > > portfolio_id

start_date

text

[en] Start date. Amazon field: startDate.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

tags

text

[en] Tags. Amazon field: tags. List/object stored as JSON.

targeting_type

text

[en] Targeting type (manual or auto). Amazon field: targetingType.

Metadata: Sponsored Products - keywords

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Products keyword: text, match type, bid, state.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

keyword_id

text

[en] Id of the keyword (text). Amazon field: keywordId.

ad_group_id

text

[en] Id of the ad group (text). Amazon field: adGroupId.

    Metadata: Sponsored Products - ad groups > > ad_group_id

bid

float

[en] Bid. Amazon field: bid.

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Sponsored Products - campaigns > > campaign_id

keyword_text

text

[en] Keyword text. Amazon field: keywordText.

match_type

text

[en] Match type (exact, phrase, broad). Amazon field: matchType.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored Products - negative keywords

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Products ad-group negative keyword.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

keyword_id

text

[en] Id of the keyword (text). Amazon field: keywordId.

ad_group_id

text

[en] Id of the ad group (text). Amazon field: adGroupId.

    Metadata: Sponsored Products - ad groups > > ad_group_id

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Sponsored Products - campaigns > > campaign_id

keyword_text

text

[en] Keyword text. Amazon field: keywordText.

match_type

text

[en] Match type (exact, phrase, broad). Amazon field: matchType.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored Products - negative targets

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Products negative target.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

target_id

text

[en] Id of the target (text). Amazon field: targetId.

ad_group_id

text

[en] Id of the ad group (text). Amazon field: adGroupId.

    Metadata: Sponsored Products - ad groups > > ad_group_id

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Sponsored Products - campaigns > > campaign_id

expression

text

[en] Targeting expression. Amazon field: expression. List/object stored as JSON.

resolved_expression

text

[en] Targeting expression as resolved by Amazon. Amazon field: resolvedExpression. List/object stored as JSON.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored Products - product ads

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Products product ad (advertised ASIN/SKU).

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

ad_id

text

[en] Id of the ad (text). Amazon field: adId.

ad_group_id

text

[en] Id of the ad group (text). Amazon field: adGroupId.

    Metadata: Sponsored Products - ad groups > > ad_group_id

asin

text

[en] Advertised product ASIN. Amazon field: asin.

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Sponsored Products - campaigns > > campaign_id

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored Products - targets

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored Products target (product/category/auto), with expression and bid.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

target_id

text

[en] Id of the target (text). Amazon field: targetId.

ad_group_id

text

[en] Id of the ad group (text). Amazon field: adGroupId.

    Metadata: Sponsored Products - ad groups > > ad_group_id

bid

float

[en] Bid. Amazon field: bid.

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

    Metadata: Sponsored Products - campaigns > > campaign_id

expression

text

[en] Targeting expression. Amazon field: expression. List/object stored as JSON.

expression_type

text

[en] Expression type (manual or auto). Amazon field: expressionType.

resolved_expression

text

[en] Targeting expression as resolved by Amazon. Amazon field: resolvedExpression. List/object stored as JSON.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Metadata: Sponsored TV - campaigns

This pipeline is free

Replication type: Full

Parameters:

  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.

Relationships:

Amazon Ads metadata (listing). One row per Sponsored TV campaign.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

campaign_id

text

[en] Id of the campaign (text). Amazon field: campaignId.

budget_budget

float

[en] Budget amount. Amazon field: budget__budget.

budget_budget_type

text

[en] Budget type (daily, lifetime). Amazon field: budget__budgetType.

country_code

text

[en] Marketplace country (e.g. BR, US). Amazon field: countryCode.

end_date

text

[en] End date. Amazon field: endDate.

name

text

[en] Name. Amazon field: name.

portfolio_id

text

[en] Id of the portfolio (text). Amazon field: portfolioId.

    Metadata: Portfolios > > portfolio_id

start_date

text

[en] Start date. Amazon field: startDate.

state

text

[en] State set by the advertiser (enabled, paused, archived). Amazon field: state.

Sponsored Brands report

Replication type: Incremental with update window

Parameters:

  • Read start date: Amazon only keeps the last 60 to 95 days, depending on the report type; the screen only accepts dates within that limit. Some levels keep less (search term: 65 days), and the saved date is adjusted to what Amazon has.
  • Level: Grain of each report row.
  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.
  • Update window: How many days back on each run. Amazon revises conversions for weeks after the click. Days older than what Amazon keeps for the level are not requested.
  • Grouping period: Day, week or month. Week and month are totalled by Amazon itself, which keeps unique-people metrics such as reach correct.

Relationships:

Sponsored Brands report: one row per advertising account, chosen level and day, week or month (grouping period), with Amazon Ads metrics. The update window re-reads the last days on every run. Available levels: Campaign; Campaign x placement; Ad group; Ad; Targeting (keyword / target); Search term; Purchased product; Gross and invalid traffic. The field list gathers the columns of every level; each integration brings only those of the chosen level (e.g. the search term level adds search_term). How to read the metrics: ROAS = sales ÷ cost; ACOS = cost ÷ sales (the inverse of ROAS). TACOS (cost ÷ total store sales, organic included) does not come from Amazon Ads: it needs the total sales from Seller or Vendor Central. The number at the end of the name (1d, 7d, 14d, 30d) is the attribution window in days. Clicks = conversions attributed to a click; Views = attributed to a view without a click. BrandHalo = other products of the same brand; SameSku/OtherSku = the advertised SKU itself or others; total = advertised product + brand halo; NewToBrand = customers with no purchase from the brand in the last 12 months; eCP = effective cost per event; offAmazon = conversions on the advertiser site, measured by the conversion tag. Reach counts unique people and does not add up across days. Sponsored Brands has new-to-brand and viewability metrics; the console default window is 14 days. Amazon states that API numbers may differ from the console by up to about 5%.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

date

date

[en] Row day; for week/month, the first day of the period (account time zone).

profile_name

text

[en] Advertising account (profile) name.

country_code

text

[en] Account marketplace country (e.g. BR, US).

currency_code

text

[en] Currency in which the row's cost and sales are expressed.

ad_group_id

text

[en] Id of the ad group (text). Amazon column: adGroupId.

    Metadata: Sponsored Brands - ad groups > > ad_group_id

ad_group_name

text

[en] Name of the ad group. Amazon column: adGroupName.

ad_id

text

[en] Id of the ad (text). Amazon column: adId.

    Metadata: Sponsored Brands - ads > > ad_id

ad_keyword_status

text

[en] Keyword/ad status. Amazon column: adKeywordStatus.

ad_status

text

[en] Status of the ad. Amazon column: adStatus.

add_to_cart

int

[en] Add-to-cart events. Amazon column: addToCart.

add_to_cart_clicks

int

[en] Add-to-cart events (click attribution). Amazon column: addToCartClicks.

add_to_cart_rate

float

[en] Add-to-cart events ÷ impressions (rate). Amazon column: addToCartRate.

add_to_list

int

[en] Add-to-list events. Amazon column: addToList.

add_to_list_from_clicks

int

[en] Add-to-list events (click attribution). Amazon column: addToListFromClicks.

attribution_type

text

[en] Row attribution type (e.g. promoted vs brand halo). Amazon column: attributionType.

brand_store_page_view

int

[en] Brand Store page views. Amazon column: brandStorePageView.

branded_searches

int

[en] Branded searches on Amazon. Amazon column: brandedSearches.

branded_searches_clicks

int

[en] Branded searches on Amazon (click attribution). Amazon column: brandedSearchesClicks.

budget_currency

text

[en] Budget currency. Amazon column: budgetCurrency.

campaign_budget_amount

float

[en] Campaign budget. Amazon column: campaignBudgetAmount.

campaign_budget_currency_code

text

[en] Campaign budget currency. Amazon column: campaignBudgetCurrencyCode.

campaign_budget_type

text

[en] Campaign budget type (daily, lifetime). Amazon column: campaignBudgetType.

campaign_id

text

[en] Id of the campaign (text). Amazon column: campaignId.

    Metadata: Sponsored Brands - campaigns > > campaign_id

campaign_name

text

[en] Name of the campaign. Amazon column: campaignName.

campaign_price_type_code

text

[en] Campaign price type. Amazon column: campaignPriceTypeCode.

campaign_rule_based_budget_amount

text

[en] Budget resulting from the budget rule. Amazon column: campaignRuleBasedBudgetAmount.

campaign_status

text

[en] Status of the campaign. Amazon column: campaignStatus.

clicks

int

[en] Clicks on the ad. Amazon column: clicks.

cost

float

[en] Cost (spend) in the period, in the account currency. Amazon column: cost.

cost_type

text

[en] Billing model (e.g. CPC, vCPM). Amazon column: costType.

detail_page_views

int

[en] Product detail page views. Amazon column: detailPageViews.

detail_page_views_clicks

int

[en] Product detail page views (click attribution). Amazon column: detailPageViewsClicks.

e_cp_add_to_cart

float

[en] Effective cost: cost ÷ add-to-cart events. Amazon column: eCPAddToCart.

gross_click_throughs

int

[en] Gross clicks, before filtering invalid traffic. Amazon column: grossClickThroughs.

gross_impressions

int

[en] Gross impressions, before filtering invalid traffic. Amazon column: grossImpressions.

impressions

int

[en] Impressions: times the ad was shown. Amazon column: impressions.

invalid_click_through_rate

float

[en] Invalid clicks ÷ gross clicks. Amazon column: invalidClickThroughRate.

invalid_click_throughs

int

[en] Clicks discarded as invalid traffic (not billed). Amazon column: invalidClickThroughs.

invalid_impression_rate

float

[en] Invalid impressions ÷ gross impressions. Amazon column: invalidImpressionRate.

invalid_impressions

int

[en] Impressions discarded as invalid traffic (not billed). Amazon column: invalidImpressions.

keyword_bid

float

[en] Keyword bid. Amazon column: keywordBid.

keyword_id

text

[en] Id of the keyword (text). Amazon column: keywordId.

keyword_text

text

[en] Keyword text. Amazon column: keywordText.

keyword_type

text

[en] Targeting type (keyword or product). Amazon column: keywordType.

kindle_edition_normalized_pages_read14d

int

[en] Kindle Unlimited pages read (KENP) (14-day attribution window). Amazon column: kindleEditionNormalizedPagesRead14d.

kindle_edition_normalized_pages_royalties14d

float

[en] Estimated royalties of Kindle Unlimited pages read (KENP) (14-day attribution window). Amazon column: kindleEditionNormalizedPagesRoyalties14d.

long_term_roas

float

[en] Long-term ROAS: long-term sales ÷ cost. Amazon column: longTermROAS.

long_term_sales

float

[en] Long-term sales: sales attributed within 12 months (Sponsored Brands). Amazon column: longTermSales.

match_type

text

[en] Match type (exact, phrase, broad; or product). Amazon column: matchType.

new_to_brand_detail_page_view_rate

float

[en] Product detail page views (from new-to-brand customers, with no purchase from the brand in the last 12 months) ÷ impressions (rate). Amazon column: newToBrandDetailPageViewRate.

new_to_brand_detail_page_views

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandDetailPageViews.

new_to_brand_detail_page_views_clicks

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandDetailPageViewsClicks.

new_to_brand_ecp_detail_page_view

float

[en] Effective cost: cost ÷ product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandECPDetailPageView.

new_to_brand_orders14d

int

[en] Orders from new-to-brand customers, with no purchase from the brand in the last 12 months (14-day attribution window). Amazon column: newToBrandOrders14d.

new_to_brand_orders_percentage14d

float

[en] Share of orders that came from new-to-brand customers, with no purchase from the brand in the last 12 months (14-day attribution window). Amazon column: newToBrandOrdersPercentage14d.

new_to_brand_purchases

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandPurchases.

new_to_brand_purchases14d

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months (14-day attribution window). Amazon column: newToBrandPurchases14d.

new_to_brand_purchases_clicks

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandPurchasesClicks.

new_to_brand_purchases_percentage

float

[en] Share of purchases that came from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandPurchasesPercentage.

new_to_brand_purchases_percentage14d

float

[en] Share of purchases that came from new-to-brand customers, with no purchase from the brand in the last 12 months (14-day attribution window). Amazon column: newToBrandPurchasesPercentage14d.

new_to_brand_purchases_rate

float

[en] Purchases (from new-to-brand customers, with no purchase from the brand in the last 12 months) ÷ impressions (rate). Amazon column: newToBrandPurchasesRate.

new_to_brand_sales

float

[en] Sales (value, in the account currency) from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandSales.

new_to_brand_sales14d

float

[en] Sales (value, in the account currency) from new-to-brand customers, with no purchase from the brand in the last 12 months (14-day attribution window). Amazon column: newToBrandSales14d.

new_to_brand_sales_clicks

float

[en] Sales (value, in the account currency) from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandSalesClicks.

new_to_brand_sales_percentage

float

[en] Share of sales (value, in the account currency) that came from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandSalesPercentage.

new_to_brand_sales_percentage14d

float

[en] Share of sales (value, in the account currency) that came from new-to-brand customers, with no purchase from the brand in the last 12 months (14-day attribution window). Amazon column: newToBrandSalesPercentage14d.

new_to_brand_units_sold

int

[en] Units sold from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandUnitsSold.

new_to_brand_units_sold14d

int

[en] Units sold from new-to-brand customers, with no purchase from the brand in the last 12 months (14-day attribution window). Amazon column: newToBrandUnitsSold14d.

new_to_brand_units_sold_clicks

int

[en] Units sold from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandUnitsSoldClicks.

new_to_brand_units_sold_percentage

float

[en] Share of units sold that came from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandUnitsSoldPercentage.

new_to_brand_units_sold_percentage14d

float

[en] Share of units sold that came from new-to-brand customers, with no purchase from the brand in the last 12 months (14-day attribution window). Amazon column: newToBrandUnitsSoldPercentage14d.

orders14d

int

[en] Orders (14-day attribution window). Amazon column: orders14d.

orders_clicks14d

int

[en] Orders (click attribution) (14-day attribution window). Amazon column: ordersClicks14d.

placement_classification

text

[en] Ad placement (top of search, rest of search, product page). Amazon column: placementClassification.

product_category

text

[en] Product category. Amazon column: productCategory.

product_name

text

[en] Product name. Amazon column: productName.

purchased_asin

text

[en] ASIN of the purchased product (may differ from the advertised one). Amazon column: purchasedAsin.

purchases

int

[en] Purchases. Amazon column: purchases.

purchases_clicks

int

[en] Purchases (click attribution). Amazon column: purchasesClicks.

purchases_promoted

int

[en] Purchases of the advertised product. Amazon column: purchasesPromoted.

qualified_borrows

int

[en] Qualified e-book borrows. Amazon column: qualifiedBorrows.

qualified_borrows_from_clicks

int

[en] Qualified e-book borrows (click attribution). Amazon column: qualifiedBorrowsFromClicks.

royalty_qualified_borrows

float

[en] Royalty-qualified e-book borrows. Amazon column: royaltyQualifiedBorrows.

royalty_qualified_borrows_from_clicks

float

[en] Royalty-qualified e-book borrows (click attribution). Amazon column: royaltyQualifiedBorrowsFromClicks.

sales

float

[en] Sales (value, in the account currency). Amazon column: sales.

sales14d

float

[en] Sales (value, in the account currency) (14-day attribution window). Amazon column: sales14d.

sales_clicks

float

[en] Sales (value, in the account currency) (click attribution). Amazon column: salesClicks.

sales_clicks14d

float

[en] Sales (value, in the account currency) (click attribution) (14-day attribution window). Amazon column: salesClicks14d.

sales_promoted

float

[en] Sales (value, in the account currency) of the advertised product. Amazon column: salesPromoted.

search_term

text

[en] Term the shopper searched on Amazon that showed the ad. Amazon column: searchTerm.

targeting_expression

text

[en] Targeting expression. Amazon column: targetingExpression.

targeting_id

text

[en] Id of the targeting (text). Amazon column: targetingId.

targeting_text

text

[en] Targeting text. Amazon column: targetingText.

targeting_type

text

[en] Targeting type. Amazon column: targetingType.

top_of_search_impression_share

float

[en] Share of the possible top-of-search impressions the ad won. Amazon column: topOfSearchImpressionShare.

units_sold

int

[en] Units sold. Amazon column: unitsSold.

units_sold14d

int

[en] Units sold (14-day attribution window). Amazon column: unitsSold14d.

units_sold_clicks

int

[en] Units sold (click attribution). Amazon column: unitsSoldClicks.

units_sold_clicks14d

int

[en] Units sold (click attribution) (14-day attribution window). Amazon column: unitsSoldClicks14d.

video5_second_view_rate

float

[en] 5-second views ÷ impressions. Amazon column: video5SecondViewRate.

video5_second_views

int

[en] Video views of at least 5 seconds. Amazon column: video5SecondViews.

video_complete_views

int

[en] Video ad: complete plays. Amazon column: videoCompleteViews.

video_first_quartile_views

int

[en] Video ad: plays to 25%. Amazon column: videoFirstQuartileViews.

video_midpoint_views

int

[en] Video ad: plays to 50%. Amazon column: videoMidpointViews.

video_third_quartile_views

int

[en] Video ad: plays to 75%. Amazon column: videoThirdQuartileViews.

video_unmutes

int

[en] Video ad: unmutes. Amazon column: videoUnmutes.

view_click_through_rate

float

[en] Clicks ÷ viewable impressions. Amazon column: viewClickThroughRate.

viewability_rate

float

[en] Viewability rate (viewable impressions ÷ measurable impressions). Amazon column: viewabilityRate.

viewable_impressions

int

[en] Viewable impressions under the MRC standard (≥50% of pixels for ≥1 s; video 2 s). Amazon column: viewableImpressions.

Sponsored Display report

Replication type: Incremental with update window

Parameters:

  • Read start date: Amazon only keeps the last 60 to 95 days, depending on the report type; the screen only accepts dates within that limit. Some levels keep less (search term: 65 days), and the saved date is adjusted to what Amazon has.
  • Level: Grain of each report row.
  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.
  • Update window: How many days back on each run. Amazon revises conversions for weeks after the click. Days older than what Amazon keeps for the level are not requested.
  • Grouping period: Day, week or month. Week and month are totalled by Amazon itself, which keeps unique-people metrics such as reach correct.

Relationships:

Sponsored Display report: one row per advertising account, chosen level and day, week or month (grouping period), with Amazon Ads metrics. The update window re-reads the last days on every run. Available levels: Campaign; Campaign x matched target; Ad group; Targeting (keyword / target); Advertised product; Purchased product; Gross and invalid traffic. The field list gathers the columns of every level; each integration brings only those of the chosen level (e.g. the search term level adds search_term). How to read the metrics: ROAS = sales ÷ cost; ACOS = cost ÷ sales (the inverse of ROAS). TACOS (cost ÷ total store sales, organic included) does not come from Amazon Ads: it needs the total sales from Seller or Vendor Central. The number at the end of the name (1d, 7d, 14d, 30d) is the attribution window in days. Clicks = conversions attributed to a click; Views = attributed to a view without a click. BrandHalo = other products of the same brand; SameSku/OtherSku = the advertised SKU itself or others; total = advertised product + brand halo; NewToBrand = customers with no purchase from the brand in the last 12 months; eCP = effective cost per event; offAmazon = conversions on the advertiser site, measured by the conversion tag. Reach counts unique people and does not add up across days. Sponsored Display has click- and view-attributed conversions, new-to-brand and viewability; it has no search term level. The console default window is 14 days. Amazon states that API numbers may differ from the console by up to about 5%.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

date

date

[en] Row day; for week/month, the first day of the period (account time zone).

profile_name

text

[en] Advertising account (profile) name.

country_code

text

[en] Account marketplace country (e.g. BR, US).

currency_code

text

[en] Currency in which the row's cost and sales are expressed.

ad_group_id

text

[en] Id of the ad group (text). Amazon column: adGroupId.

    Metadata: Sponsored Display - ad groups > > ad_group_id

ad_group_name

text

[en] Name of the ad group. Amazon column: adGroupName.

ad_id

text

[en] Id of the ad (text). Amazon column: adId.

    Metadata: Sponsored Display - product ads > > ad_id

ad_keyword_status

text

[en] Keyword/ad status. Amazon column: adKeywordStatus.

ad_name

text

[en] Name of the ad. Amazon column: adName.

add_to_cart

int

[en] Add-to-cart events. Amazon column: addToCart.

add_to_cart_clicks

int

[en] Add-to-cart events (click attribution). Amazon column: addToCartClicks.

add_to_cart_rate

float

[en] Add-to-cart events ÷ impressions (rate). Amazon column: addToCartRate.

add_to_cart_views

int

[en] Add-to-cart events (view attribution: ad seen, not clicked). Amazon column: addToCartViews.

add_to_list

int

[en] Add-to-list events. Amazon column: addToList.

add_to_list_from_clicks

int

[en] Add-to-list events (click attribution). Amazon column: addToListFromClicks.

add_to_list_from_views

text

[en] Add-to-list events (view attribution: ad seen, not clicked). Amazon column: addToListFromViews.

asin_brand_halo

text

[en] ASIN of another product of the same brand (halo). Amazon column: asinBrandHalo.

bid_optimization

text

[en] Bid optimization. Amazon column: bidOptimization.

branded_search_rate

text

[en] Branded searches ÷ impressions. Amazon column: brandedSearchRate.

branded_searches

int

[en] Branded searches on Amazon. Amazon column: brandedSearches.

branded_searches_clicks

int

[en] Branded searches on Amazon (click attribution). Amazon column: brandedSearchesClicks.

branded_searches_views

text

[en] Branded searches on Amazon (view attribution: ad seen, not clicked). Amazon column: brandedSearchesViews.

campaign_budget_amount

float

[en] Campaign budget. Amazon column: campaignBudgetAmount.

campaign_budget_currency_code

text

[en] Campaign budget currency. Amazon column: campaignBudgetCurrencyCode.

campaign_id

text

[en] Id of the campaign (text). Amazon column: campaignId.

    Metadata: Sponsored Display - campaigns > > campaign_id

campaign_name

text

[en] Name of the campaign. Amazon column: campaignName.

campaign_status

text

[en] Status of the campaign. Amazon column: campaignStatus.

clicks

int

[en] Clicks on the ad. Amazon column: clicks.

conversions_brand_halo

text

[en] Conversions of other products of the same brand, halo effect, not the advertised one. Amazon column: conversionsBrandHalo.

conversions_brand_halo_clicks

text

[en] Conversions of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: conversionsBrandHaloClicks.

cost

float

[en] Cost (spend) in the period, in the account currency. Amazon column: cost.

cost_type

text

[en] Billing model (e.g. CPC, vCPM). Amazon column: costType.

cumulative_reach

text

[en] Cumulative reach since the start of the order/line item. Amazon column: cumulativeReach.

detail_page_views

int

[en] Product detail page views. Amazon column: detailPageViews.

detail_page_views_clicks

int

[en] Product detail page views (click attribution). Amazon column: detailPageViewsClicks.

e_cp_add_to_cart

float

[en] Effective cost: cost ÷ add-to-cart events. Amazon column: eCPAddToCart.

e_cp_brand_search

float

[en] Effective cost: cost ÷ brand searches on Amazon. Amazon column: eCPBrandSearch.

gross_click_throughs

int

[en] Gross clicks, before filtering invalid traffic. Amazon column: grossClickThroughs.

gross_impressions

int

[en] Gross impressions, before filtering invalid traffic. Amazon column: grossImpressions.

impressions

int

[en] Impressions: times the ad was shown. Amazon column: impressions.

impressions_frequency_average

text

[en] Average frequency: impressions ÷ reach. Amazon column: impressionsFrequencyAverage.

impressions_views

text

[en] Viewable impressions. Amazon column: impressionsViews.

invalid_click_through_rate

float

[en] Invalid clicks ÷ gross clicks. Amazon column: invalidClickThroughRate.

invalid_click_throughs

int

[en] Clicks discarded as invalid traffic (not billed). Amazon column: invalidClickThroughs.

invalid_impression_rate

float

[en] Invalid impressions ÷ gross impressions. Amazon column: invalidImpressionRate.

invalid_impressions

int

[en] Impressions discarded as invalid traffic (not billed). Amazon column: invalidImpressions.

kindle_edition_normalized_pages_read

int

[en] Kindle Unlimited pages read (KENP). Amazon column: kindleEditionNormalizedPagesRead.

kindle_edition_normalized_pages_read_from_clicks

int

[en] Kindle Unlimited pages read (KENP) (click attribution). Amazon column: kindleEditionNormalizedPagesReadFromClicks.

kindle_edition_normalized_pages_read_from_views

int

[en] Kindle Unlimited pages read (KENP) (view attribution: ad seen, not clicked). Amazon column: kindleEditionNormalizedPagesReadFromViews.

kindle_edition_normalized_pages_royalties

text

[en] Estimated royalties of Kindle Unlimited pages read (KENP). Amazon column: kindleEditionNormalizedPagesRoyalties.

kindle_edition_normalized_pages_royalties_from_clicks

text

[en] Estimated royalties of Kindle Unlimited pages read (KENP) (click attribution). Amazon column: kindleEditionNormalizedPagesRoyaltiesFromClicks.

kindle_edition_normalized_pages_royalties_from_views

text

[en] Estimated royalties of Kindle Unlimited pages read (KENP) (view attribution: ad seen, not clicked). Amazon column: kindleEditionNormalizedPagesRoyaltiesFromViews.

landing_page_url

text

[en] Ad landing page URL. Amazon column: landingPageURL.

lead_form_opens

text

[en] Lead form opens. Amazon column: leadFormOpens.

leads

text

[en] Leads. Amazon column: leads.

link_outs

text

[en] Link-outs (clicks leaving Amazon). Amazon column: linkOuts.

long_term_roas

float

[en] Long-term ROAS: long-term sales ÷ cost. Amazon column: longTermROAS.

long_term_sales

float

[en] Long-term sales: sales attributed within 12 months (Sponsored Brands). Amazon column: longTermSales.

matched_target_asin

text

[en] ASIN of the target product the ad appeared on. Amazon column: matchedTargetAsin.

new_to_brand_detail_page_view_clicks

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandDetailPageViewClicks.

new_to_brand_detail_page_view_rate

float

[en] Product detail page views (from new-to-brand customers, with no purchase from the brand in the last 12 months) ÷ impressions (rate). Amazon column: newToBrandDetailPageViewRate.

new_to_brand_detail_page_view_views

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months (view attribution: ad seen, not clicked). Amazon column: newToBrandDetailPageViewViews.

new_to_brand_detail_page_views

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandDetailPageViews.

new_to_brand_ecp_detail_page_view

float

[en] Effective cost: cost ÷ product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandECPDetailPageView.

new_to_brand_purchases

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandPurchases.

new_to_brand_purchases_clicks

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandPurchasesClicks.

new_to_brand_sales

float

[en] Sales (value, in the account currency) from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandSales.

new_to_brand_sales_clicks

float

[en] Sales (value, in the account currency) from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandSalesClicks.

new_to_brand_units_sold

int

[en] Units sold from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandUnitsSold.

new_to_brand_units_sold_clicks

int

[en] Units sold from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandUnitsSoldClicks.

promoted_asin

text

[en] Promoted product ASIN. Amazon column: promotedAsin.

promoted_sku

text

[en] Promoted product SKU. Amazon column: promotedSku.

purchases

int

[en] Purchases. Amazon column: purchases.

purchases_clicks

int

[en] Purchases (click attribution). Amazon column: purchasesClicks.

purchases_promoted_clicks

text

[en] Purchases of the advertised product (click attribution). Amazon column: purchasesPromotedClicks.

qualified_borrows

int

[en] Qualified e-book borrows. Amazon column: qualifiedBorrows.

qualified_borrows_from_clicks

int

[en] Qualified e-book borrows (click attribution). Amazon column: qualifiedBorrowsFromClicks.

qualified_borrows_from_views

int

[en] Qualified e-book borrows (view attribution: ad seen, not clicked). Amazon column: qualifiedBorrowsFromViews.

royalty_qualified_borrows

float

[en] Royalty-qualified e-book borrows. Amazon column: royaltyQualifiedBorrows.

royalty_qualified_borrows_from_clicks

float

[en] Royalty-qualified e-book borrows (click attribution). Amazon column: royaltyQualifiedBorrowsFromClicks.

royalty_qualified_borrows_from_views

float

[en] Royalty-qualified e-book borrows (view attribution: ad seen, not clicked). Amazon column: royaltyQualifiedBorrowsFromViews.

sales

float

[en] Sales (value, in the account currency). Amazon column: sales.

sales_brand_halo

float

[en] Sales (value, in the account currency) of other products of the same brand, halo effect, not the advertised one. Amazon column: salesBrandHalo.

sales_brand_halo_clicks

text

[en] Sales (value, in the account currency) of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: salesBrandHaloClicks.

sales_clicks

float

[en] Sales (value, in the account currency) (click attribution). Amazon column: salesClicks.

sales_promoted_clicks

float

[en] Sales (value, in the account currency) of the advertised product (click attribution). Amazon column: salesPromotedClicks.

targeting_expression

text

[en] Targeting expression. Amazon column: targetingExpression.

targeting_id

text

[en] Id of the targeting (text). Amazon column: targetingId.

    Metadata: Sponsored Display - targets > > target_id

targeting_text

text

[en] Targeting text. Amazon column: targetingText.

units_sold

int

[en] Units sold. Amazon column: unitsSold.

units_sold_brand_halo

int

[en] Units sold of other products of the same brand, halo effect, not the advertised one. Amazon column: unitsSoldBrandHalo.

units_sold_brand_halo_clicks

text

[en] Units sold of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: unitsSoldBrandHaloClicks.

units_sold_clicks

int

[en] Units sold (click attribution). Amazon column: unitsSoldClicks.

video_complete_views

int

[en] Video ad: complete plays. Amazon column: videoCompleteViews.

video_first_quartile_views

int

[en] Video ad: plays to 25%. Amazon column: videoFirstQuartileViews.

video_midpoint_views

int

[en] Video ad: plays to 50%. Amazon column: videoMidpointViews.

video_third_quartile_views

int

[en] Video ad: plays to 75%. Amazon column: videoThirdQuartileViews.

video_unmutes

int

[en] Video ad: unmutes. Amazon column: videoUnmutes.

view_click_through_rate

float

[en] Clicks ÷ viewable impressions. Amazon column: viewClickThroughRate.

viewability_rate

float

[en] Viewability rate (viewable impressions ÷ measurable impressions). Amazon column: viewabilityRate.

Sponsored Products report

Replication type: Incremental with update window

Parameters:

  • Read start date: Amazon only keeps the last 60 to 95 days, depending on the report type; the screen only accepts dates within that limit. Some levels keep less (search term: 65 days), and the saved date is adjusted to what Amazon has.
  • Level: Grain of each report row.
  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.
  • Update window: How many days back on each run. Amazon revises conversions for weeks after the click. Days older than what Amazon keeps for the level are not requested.
  • Grouping period: Day, week or month. Week and month are totalled by Amazon itself, which keeps unique-people metrics such as reach correct.

Relationships:

Sponsored Products report: one row per advertising account, chosen level and day, week or month (grouping period), with Amazon Ads metrics. The update window re-reads the last days on every run. Available levels: Campaign; Campaign x placement; Ad group; Targeting (keyword / target); Search term; Advertised product; Purchased product; Gross and invalid traffic. The field list gathers the columns of every level; each integration brings only those of the chosen level (e.g. the search term level adds search_term). How to read the metrics: ROAS = sales ÷ cost; ACOS = cost ÷ sales (the inverse of ROAS). TACOS (cost ÷ total store sales, organic included) does not come from Amazon Ads: it needs the total sales from Seller or Vendor Central. The number at the end of the name (1d, 7d, 14d, 30d) is the attribution window in days. Clicks = conversions attributed to a click; Views = attributed to a view without a click. BrandHalo = other products of the same brand; SameSku/OtherSku = the advertised SKU itself or others; total = advertised product + brand halo; NewToBrand = customers with no purchase from the brand in the last 12 months; eCP = effective cost per event; offAmazon = conversions on the advertiser site, measured by the conversion tag. Reach counts unique people and does not add up across days. Sponsored Products only has click-attributed conversions (no view attribution) and no new-to-brand metrics. The Amazon console shows the 7-day window by default for sellers and 14 days for vendors; here every window comes (1, 7, 14 and 30 days). Amazon states that API numbers may differ from the console by up to about 5%.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

date

date

[en] Row day; for week/month, the first day of the period (account time zone).

profile_name

text

[en] Advertising account (profile) name.

country_code

text

[en] Account marketplace country (e.g. BR, US).

currency_code

text

[en] Currency in which the row's cost and sales are expressed.

acos_clicks14d

float

[en] ACOS: cost ÷ sales attributed to clicks within 14 days (the inverse of ROAS). Amazon column: acosClicks14d.

acos_clicks7d

float

[en] ACOS: cost ÷ sales attributed to clicks within 7 days (the inverse of ROAS). Amazon column: acosClicks7d.

ad_group_id

text

[en] Id of the ad group (text). Amazon column: adGroupId.

    Metadata: Sponsored Products - ad groups > > ad_group_id

ad_group_name

text

[en] Name of the ad group. Amazon column: adGroupName.

ad_id

text

[en] Id of the ad (text). Amazon column: adId.

    Metadata: Sponsored Products - product ads > > ad_id

ad_keyword_status

text

[en] Keyword/ad status. Amazon column: adKeywordStatus.

ad_status

text

[en] Status of the ad. Amazon column: adStatus.

add_to_list

int

[en] Add-to-list events. Amazon column: addToList.

advertised_asin

text

[en] ASIN of the advertised product. Amazon column: advertisedAsin.

advertised_sku

text

[en] SKU of the advertised product. Amazon column: advertisedSku.

attributed_sales_same_sku14d

float

[en] Sales (value, in the account currency) of the advertised SKU itself (14-day attribution window). Amazon column: attributedSalesSameSku14d.

attributed_sales_same_sku1d

float

[en] Sales (value, in the account currency) of the advertised SKU itself (1-day attribution window). Amazon column: attributedSalesSameSku1d.

attributed_sales_same_sku30d

float

[en] Sales (value, in the account currency) of the advertised SKU itself (30-day attribution window). Amazon column: attributedSalesSameSku30d.

attributed_sales_same_sku7d

float

[en] Sales (value, in the account currency) of the advertised SKU itself (7-day attribution window). Amazon column: attributedSalesSameSku7d.

campaign_applicable_budget_rule_id

text

[en] Applied budget rule id. Amazon column: campaignApplicableBudgetRuleId.

campaign_applicable_budget_rule_name

text

[en] Applied budget rule name. Amazon column: campaignApplicableBudgetRuleName.

campaign_bidding_strategy

text

[en] Campaign bidding strategy. Amazon column: campaignBiddingStrategy.

campaign_budget_amount

float

[en] Campaign budget. Amazon column: campaignBudgetAmount.

campaign_budget_currency_code

text

[en] Campaign budget currency. Amazon column: campaignBudgetCurrencyCode.

campaign_budget_type

text

[en] Campaign budget type (daily, lifetime). Amazon column: campaignBudgetType.

campaign_id

text

[en] Id of the campaign (text). Amazon column: campaignId.

    Metadata: Sponsored Products - campaigns > > campaign_id

campaign_name

text

[en] Name of the campaign. Amazon column: campaignName.

campaign_rule_based_budget_amount

text

[en] Budget resulting from the budget rule. Amazon column: campaignRuleBasedBudgetAmount.

campaign_status

text

[en] Status of the campaign. Amazon column: campaignStatus.

click_through_rate

float

[en] Click-through rate (CTR = clicks ÷ impressions). Amazon column: clickThroughRate.

clicks

int

[en] Clicks on the ad. Amazon column: clicks.

cost

float

[en] Cost (spend) in the period, in the account currency. Amazon column: cost.

cost_per_click

float

[en] Cost per click (CPC = cost ÷ clicks). Amazon column: costPerClick.

gross_click_throughs

int

[en] Gross clicks, before filtering invalid traffic. Amazon column: grossClickThroughs.

gross_impressions

int

[en] Gross impressions, before filtering invalid traffic. Amazon column: grossImpressions.

impressions

int

[en] Impressions: times the ad was shown. Amazon column: impressions.

invalid_click_through_rate

float

[en] Invalid clicks ÷ gross clicks. Amazon column: invalidClickThroughRate.

invalid_click_throughs

int

[en] Clicks discarded as invalid traffic (not billed). Amazon column: invalidClickThroughs.

invalid_impression_rate

float

[en] Invalid impressions ÷ gross impressions. Amazon column: invalidImpressionRate.

invalid_impressions

int

[en] Impressions discarded as invalid traffic (not billed). Amazon column: invalidImpressions.

keyword

text

[en] Keyword or targeting expression. Amazon column: keyword.

keyword_bid

float

[en] Keyword bid. Amazon column: keywordBid.

keyword_id

text

[en] Id of the keyword (text). Amazon column: keywordId.

    Metadata: Sponsored Products - keywords > > keyword_id

keyword_type

text

[en] Targeting type (keyword or product). Amazon column: keywordType.

kindle_edition_normalized_pages_read14d

int

[en] Kindle Unlimited pages read (KENP) (14-day attribution window). Amazon column: kindleEditionNormalizedPagesRead14d.

kindle_edition_normalized_pages_royalties14d

float

[en] Estimated royalties of Kindle Unlimited pages read (KENP) (14-day attribution window). Amazon column: kindleEditionNormalizedPagesRoyalties14d.

marketplace_id

text

[en] Marketplace id. Amazon column: marketplaceId.

match_type

text

[en] Match type (exact, phrase, broad; or product). Amazon column: matchType.

placement_classification

text

[en] Ad placement (top of search, rest of search, product page). Amazon column: placementClassification.

portfolio_id

text

[en] Id of the portfolio (text). Amazon column: portfolioId.

    Metadata: Portfolios > > portfolio_id

purchase_click_rate14d

float

[en] Purchases within 14 days ÷ clicks (conversion rate). Amazon column: purchaseClickRate14d.

purchased_asin

text

[en] ASIN of the purchased product (may differ from the advertised one). Amazon column: purchasedAsin.

purchases14d

int

[en] Purchases (14-day attribution window). Amazon column: purchases14d.

purchases1d

int

[en] Purchases (1-day attribution window). Amazon column: purchases1d.

purchases30d

int

[en] Purchases (30-day attribution window). Amazon column: purchases30d.

purchases7d

int

[en] Purchases (7-day attribution window). Amazon column: purchases7d.

purchases_other_sku14d

int

[en] Purchases of other SKUs, not the advertised one (14-day attribution window). Amazon column: purchasesOtherSku14d.

purchases_other_sku1d

int

[en] Purchases of other SKUs, not the advertised one (1-day attribution window). Amazon column: purchasesOtherSku1d.

purchases_other_sku30d

int

[en] Purchases of other SKUs, not the advertised one (30-day attribution window). Amazon column: purchasesOtherSku30d.

purchases_other_sku7d

int

[en] Purchases of other SKUs, not the advertised one (7-day attribution window). Amazon column: purchasesOtherSku7d.

purchases_same_sku14d

int

[en] Purchases of the advertised SKU itself (14-day attribution window). Amazon column: purchasesSameSku14d.

purchases_same_sku1d

int

[en] Purchases of the advertised SKU itself (1-day attribution window). Amazon column: purchasesSameSku1d.

purchases_same_sku30d

int

[en] Purchases of the advertised SKU itself (30-day attribution window). Amazon column: purchasesSameSku30d.

purchases_same_sku7d

int

[en] Purchases of the advertised SKU itself (7-day attribution window). Amazon column: purchasesSameSku7d.

qualified_borrows

int

[en] Qualified e-book borrows. Amazon column: qualifiedBorrows.

retailer

text

[en] Retailer. Amazon column: retailer.

roas_clicks14d

float

[en] ROAS: sales attributed to clicks within 14 days ÷ cost. Amazon column: roasClicks14d.

roas_clicks7d

float

[en] ROAS: sales attributed to clicks within 7 days ÷ cost. Amazon column: roasClicks7d.

royalty_qualified_borrows

float

[en] Royalty-qualified e-book borrows. Amazon column: royaltyQualifiedBorrows.

sales14d

float

[en] Sales (value, in the account currency) (14-day attribution window). Amazon column: sales14d.

sales1d

float

[en] Sales (value, in the account currency) (1-day attribution window). Amazon column: sales1d.

sales30d

float

[en] Sales (value, in the account currency) (30-day attribution window). Amazon column: sales30d.

sales7d

float

[en] Sales (value, in the account currency) (7-day attribution window). Amazon column: sales7d.

sales_other_sku14d

float

[en] Sales (value, in the account currency) of other SKUs, not the advertised one (14-day attribution window). Amazon column: salesOtherSku14d.

sales_other_sku1d

float

[en] Sales (value, in the account currency) of other SKUs, not the advertised one (1-day attribution window). Amazon column: salesOtherSku1d.

sales_other_sku30d

float

[en] Sales (value, in the account currency) of other SKUs, not the advertised one (30-day attribution window). Amazon column: salesOtherSku30d.

sales_other_sku7d

float

[en] Sales (value, in the account currency) of other SKUs, not the advertised one (7-day attribution window). Amazon column: salesOtherSku7d.

search_term

text

[en] Term the shopper searched on Amazon that showed the ad. Amazon column: searchTerm.

spend

float

[en] Cost (spend) in the period, in the account currency. Amazon column: spend.

target_id

text

[en] Id of the target (text). Amazon column: targetId.

targeting

text

[en] Targeting expression (keyword, product or audience). Amazon column: targeting.

targeting_expression

text

[en] Targeting expression. Amazon column: targetingExpression.

top_of_search_impression_share

float

[en] Share of the possible top-of-search impressions the ad won. Amazon column: topOfSearchImpressionShare.

units_sold_clicks14d

int

[en] Units sold (click attribution) (14-day attribution window). Amazon column: unitsSoldClicks14d.

units_sold_clicks1d

int

[en] Units sold (click attribution) (1-day attribution window). Amazon column: unitsSoldClicks1d.

units_sold_clicks30d

int

[en] Units sold (click attribution) (30-day attribution window). Amazon column: unitsSoldClicks30d.

units_sold_clicks7d

int

[en] Units sold (click attribution) (7-day attribution window). Amazon column: unitsSoldClicks7d.

units_sold_other_sku14d

int

[en] Units sold of other SKUs, not the advertised one (14-day attribution window). Amazon column: unitsSoldOtherSku14d.

units_sold_other_sku1d

int

[en] Units sold of other SKUs, not the advertised one (1-day attribution window). Amazon column: unitsSoldOtherSku1d.

units_sold_other_sku30d

int

[en] Units sold of other SKUs, not the advertised one (30-day attribution window). Amazon column: unitsSoldOtherSku30d.

units_sold_other_sku7d

int

[en] Units sold of other SKUs, not the advertised one (7-day attribution window). Amazon column: unitsSoldOtherSku7d.

units_sold_same_sku14d

int

[en] Units sold of the advertised SKU itself (14-day attribution window). Amazon column: unitsSoldSameSku14d.

units_sold_same_sku1d

int

[en] Units sold of the advertised SKU itself (1-day attribution window). Amazon column: unitsSoldSameSku1d.

units_sold_same_sku30d

int

[en] Units sold of the advertised SKU itself (30-day attribution window). Amazon column: unitsSoldSameSku30d.

units_sold_same_sku7d

int

[en] Units sold of the advertised SKU itself (7-day attribution window). Amazon column: unitsSoldSameSku7d.

Sponsored TV report

Replication type: Incremental with update window

Parameters:

  • Read start date: Amazon only keeps the last 60 to 95 days, depending on the report type; the screen only accepts dates within that limit. Some levels keep less (search term: 65 days), and the saved date is adjusted to what Amazon has.
  • Level: Grain of each report row.
  • Accounts: Advertising accounts (profiles) to read. Leave empty to read all of them, including those added later.
  • Update window: How many days back on each run. Amazon revises conversions for weeks after the click. Days older than what Amazon keeps for the level are not requested.
  • Grouping period: Day, week or month. Week and month are totalled by Amazon itself, which keeps unique-people metrics such as reach correct.

Relationships:

Sponsored TV report: one row per advertising account, chosen level and day, week or month (grouping period), with Amazon Ads metrics. The update window re-reads the last days on every run. Available levels: Campaign; Ad group; Targeting (keyword / target). The field list gathers the columns of every level; each integration brings only those of the chosen level (e.g. the search term level adds search_term). How to read the metrics: ROAS = sales ÷ cost; ACOS = cost ÷ sales (the inverse of ROAS). TACOS (cost ÷ total store sales, organic included) does not come from Amazon Ads: it needs the total sales from Seller or Vendor Central. The number at the end of the name (1d, 7d, 14d, 30d) is the attribution window in days. Clicks = conversions attributed to a click; Views = attributed to a view without a click. BrandHalo = other products of the same brand; SameSku/OtherSku = the advertised SKU itself or others; total = advertised product + brand halo; NewToBrand = customers with no purchase from the brand in the last 12 months; eCP = effective cost per event; offAmazon = conversions on the advertiser site, measured by the conversion tag. Reach counts unique people and does not add up across days. Sponsored TV has click- and view-attributed conversions and new-to-brand; cost per thousand impressions comes in costPerThousandImpressions. The console default window is 14 days. Amazon states that API numbers may differ from the console by up to about 5%.

Field Type

profile_id

text

[en] Id of the advertising account (profile) the row came from.

    Metadata: Advertising accounts (profiles) > > profile_id

date

date

[en] Row day; for week/month, the first day of the period (account time zone).

profile_name

text

[en] Advertising account (profile) name.

country_code

text

[en] Account marketplace country (e.g. BR, US).

currency_code

text

[en] Currency in which the row's cost and sales are expressed.

ad_group_id

text

[en] Id of the ad group (text). Amazon column: adGroupId.

ad_group_name

text

[en] Name of the ad group. Amazon column: adGroupName.

ad_keyword_status

text

[en] Keyword/ad status. Amazon column: adKeywordStatus.

ad_status

text

[en] Status of the ad. Amazon column: adStatus.

add_to_cart

int

[en] Add-to-cart events. Amazon column: addToCart.

add_to_cart_clicks

int

[en] Add-to-cart events (click attribution). Amazon column: addToCartClicks.

add_to_cart_views

int

[en] Add-to-cart events (view attribution: ad seen, not clicked). Amazon column: addToCartViews.

branded_searches

int

[en] Branded searches on Amazon. Amazon column: brandedSearches.

branded_searches_clicks

int

[en] Branded searches on Amazon (click attribution). Amazon column: brandedSearchesClicks.

branded_searches_views

text

[en] Branded searches on Amazon (view attribution: ad seen, not clicked). Amazon column: brandedSearchesViews.

campaign_budget_amount

float

[en] Campaign budget. Amazon column: campaignBudgetAmount.

campaign_budget_currency_code

text

[en] Campaign budget currency. Amazon column: campaignBudgetCurrencyCode.

campaign_budget_type

text

[en] Campaign budget type (daily, lifetime). Amazon column: campaignBudgetType.

campaign_id

text

[en] Id of the campaign (text). Amazon column: campaignId.

    Metadata: Sponsored TV - campaigns > > campaign_id

campaign_name

text

[en] Name of the campaign. Amazon column: campaignName.

campaign_status

text

[en] Status of the campaign. Amazon column: campaignStatus.

click_through_rate

float

[en] Click-through rate (CTR = clicks ÷ impressions). Amazon column: clickThroughRate.

clicks

int

[en] Clicks on the ad. Amazon column: clicks.

cost

float

[en] Cost (spend) in the period, in the account currency. Amazon column: cost.

cost_per_thousand_impressions

text

[en] Cost per thousand impressions (CPM = cost ÷ impressions × 1000). Amazon column: costPerThousandImpressions.

detail_page_views

int

[en] Product detail page views. Amazon column: detailPageViews.

detail_page_views_clicks

int

[en] Product detail page views (click attribution). Amazon column: detailPageViewsClicks.

detail_page_views_views

text

[en] Product detail page views (view attribution: ad seen, not clicked). Amazon column: detailPageViewsViews.

frequency_average

float

[en] Average frequency: impressions ÷ reach. Amazon column: frequencyAverage.

household_frequency_average

float

[en] Average frequency per household. Amazon column: householdFrequencyAverage.

household_reach

int

[en] Unique households reached. Amazon column: householdReach.

impressions

int

[en] Impressions: times the ad was shown. Amazon column: impressions.

keyword

text

[en] Keyword or targeting expression. Amazon column: keyword.

keyword_bid

float

[en] Keyword bid. Amazon column: keywordBid.

keyword_id

text

[en] Id of the keyword (text). Amazon column: keywordId.

keyword_type

text

[en] Targeting type (keyword or product). Amazon column: keywordType.

long_term_roas

float

[en] Long-term ROAS: long-term sales ÷ cost. Amazon column: longTermROAS.

long_term_sales

float

[en] Long-term sales: sales attributed within 12 months (Sponsored Brands). Amazon column: longTermSales.

match_type

text

[en] Match type (exact, phrase, broad; or product). Amazon column: matchType.

new_to_brand_detail_page_view_clicks

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandDetailPageViewClicks.

new_to_brand_detail_page_view_views

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months (view attribution: ad seen, not clicked). Amazon column: newToBrandDetailPageViewViews.

new_to_brand_detail_page_views

int

[en] Product detail page views from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandDetailPageViews.

new_to_brand_purchases

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandPurchases.

new_to_brand_purchases_clicks

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandPurchasesClicks.

new_to_brand_purchases_views

int

[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months (view attribution: ad seen, not clicked). Amazon column: newToBrandPurchasesViews.

new_to_brand_sales

float

[en] Sales (value, in the account currency) from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandSales.

new_to_brand_sales_clicks

float

[en] Sales (value, in the account currency) from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandSalesClicks.

new_to_brand_sales_views

text

[en] Sales (value, in the account currency) from new-to-brand customers, with no purchase from the brand in the last 12 months (view attribution: ad seen, not clicked). Amazon column: newToBrandSalesViews.

off_amazon_add_to_cart

text

[en] Add-to-cart events off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonAddToCart.

off_amazon_add_to_cart_clicks

text

[en] Add-to-cart events off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonAddToCartClicks.

off_amazon_add_to_cart_value_average

text

[en] Average value reported on add-to-cart events (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonAddToCartValueAverage.

off_amazon_add_to_cart_value_sum

text

[en] Sum of the value reported on add-to-cart events (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonAddToCartValueSum.

off_amazon_add_to_cart_views

text

[en] Add-to-cart events off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonAddToCartViews.

off_amazon_application_value_average

text

[en] Average value reported on application conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonApplicationValueAverage.

off_amazon_application_value_sum

text

[en] Sum of the value reported on application conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonApplicationValueSum.

off_amazon_applications

text

[en] Application conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonApplications.

off_amazon_applications_clicks

text

[en] Application conversions off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonApplicationsClicks.

off_amazon_applications_views

text

[en] Application conversions off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonApplicationsViews.

off_amazon_checkout_clicks

text

[en] Checkout conversions off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonCheckoutClicks.

off_amazon_checkout_value_average

text

[en] Average value reported on checkout conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonCheckoutValueAverage.

off_amazon_checkout_value_sum

text

[en] Sum of the value reported on checkout conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonCheckoutValueSum.

off_amazon_checkout_views

text

[en] Checkout conversions off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonCheckoutViews.

off_amazon_checkouts

text

[en] Checkout conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonCheckouts.

off_amazon_clicks

int

[en] Off-Amazon conversions attributed to clicks. Amazon column: offAmazonClicks.

off_amazon_contact_clicks

text

[en] Contact conversions off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonContactClicks.

off_amazon_contact_value_average

text

[en] Average value reported on contact conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonContactValueAverage.

off_amazon_contact_value_sum

text

[en] Sum of the value reported on contact conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonContactValueSum.

off_amazon_contact_views

text

[en] Contact conversions off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonContactViews.

off_amazon_contacts

text

[en] Contact conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonContacts.

off_amazon_conversions

int

[en] Conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonConversions.

off_amazon_erpm

float

[en] Effective revenue per thousand impressions: sales (off Amazon, on the advertiser site/app, measured by the conversion tag) ÷ impressions × 1000. Amazon column: offAmazonERPM.

off_amazon_lead_value_average

text

[en] Average value reported on leads (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonLeadValueAverage.

off_amazon_lead_value_sum

text

[en] Sum of the value reported on leads (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonLeadValueSum.

off_amazon_leads

text

[en] Leads off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonLeads.

off_amazon_leads_clicks

text

[en] Leads off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonLeadsClicks.

off_amazon_leads_views

text

[en] Leads off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonLeadsViews.

off_amazon_other

text

[en] "other" conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonOther.

off_amazon_other_clicks

text

[en] "other" conversions off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonOtherClicks.

off_amazon_other_value_average

text

[en] Average value reported on "other" conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonOtherValueAverage.

off_amazon_other_value_sum

text

[en] Sum of the value reported on "other" conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonOtherValueSum.

off_amazon_other_views

text

[en] "other" conversions off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonOtherViews.

off_amazon_page_view_clicks

text

[en] Page views off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonPageViewClicks.

off_amazon_page_view_value_average

text

[en] Average value reported on page views (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonPageViewValueAverage.

off_amazon_page_view_value_sum

text

[en] Sum of the value reported on page views (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonPageViewValueSum.

off_amazon_page_view_views

text

[en] Page views off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonPageViewViews.

off_amazon_page_views

text

[en] Page views off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonPageViews.

off_amazon_product_sales

float

[en] Sales (value, in the account currency) off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonProductSales.

off_amazon_purchases

int

[en] Purchases off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonPurchases.

off_amazon_purchases_clicks

int

[en] Purchases off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonPurchasesClicks.

off_amazon_purchases_views

int

[en] Purchases off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonPurchasesViews.

off_amazon_roas

float

[en] ROAS: sales (off Amazon, on the advertiser site/app, measured by the conversion tag) ÷ cost. Amazon column: offAmazonROAS.

off_amazon_search

text

[en] Search conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonSearch.

off_amazon_search_clicks

text

[en] Search conversions off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonSearchClicks.

off_amazon_search_value_average

text

[en] Average value reported on search conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonSearchValueAverage.

off_amazon_search_value_sum

text

[en] Sum of the value reported on search conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonSearchValueSum.

off_amazon_search_views

text

[en] Search conversions off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonSearchViews.

off_amazon_sign_up

text

[en] Sign-ups off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonSignUp.

off_amazon_sign_up_clicks

text

[en] Sign-ups off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonSignUpClicks.

off_amazon_sign_up_value_average

text

[en] Average value reported on sign-ups (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonSignUpValueAverage.

off_amazon_sign_up_value_sum

text

[en] Sum of the value reported on sign-ups (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonSignUpValueSum.

off_amazon_sign_up_views

text

[en] Sign-ups off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonSignUpViews.

off_amazon_subscribe

text

[en] Subscribe conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonSubscribe.

off_amazon_subscribe_clicks

text

[en] Subscribe conversions off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonSubscribeClicks.

off_amazon_subscribe_value_average

text

[en] Average value reported on subscribe conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonSubscribeValueAverage.

off_amazon_subscribe_value_sum

text

[en] Sum of the value reported on subscribe conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonSubscribeValueSum.

off_amazon_subscribe_views

text

[en] Subscribe conversions off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonSubscribeViews.

off_amazon_units_sold

int

[en] Units sold off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonUnitsSold.

off_amazon_views

int

[en] Off-Amazon conversions attributed to views (ad seen, not clicked). Amazon column: offAmazonViews.

portfolio_id

text

[en] Id of the portfolio (text). Amazon column: portfolioId.

    Metadata: Portfolios > > portfolio_id

purchases

int

[en] Purchases. Amazon column: purchases.

purchases_clicks

int

[en] Purchases (click attribution). Amazon column: purchasesClicks.

purchases_views

int

[en] Purchases (view attribution: ad seen, not clicked). Amazon column: purchasesViews.

reach

int

[en] Reach: unique people who saw the ad in the period (not additive across days). Amazon column: reach.

roas

text

[en] ROAS: attributed sales ÷ cost. Amazon column: roas.

sales

float

[en] Sales (value, in the account currency). Amazon column: sales.

sales_clicks

float

[en] Sales (value, in the account currency) (click attribution). Amazon column: salesClicks.

sales_views

text

[en] Sales (value, in the account currency) (view attribution: ad seen, not clicked). Amazon column: salesViews.

targeting_text

text

[en] Targeting text. Amazon column: targetingText.

units_sold

int

[en] Units sold. Amazon column: unitsSold.

units_sold_clicks

int

[en] Units sold (click attribution). Amazon column: unitsSoldClicks.

units_sold_views

text

[en] Units sold (view attribution: ad seen, not clicked). Amazon column: unitsSoldViews.

video_complete_views

int

[en] Video ad: complete plays. Amazon column: videoCompleteViews.

video_first_quartile_views

int

[en] Video ad: plays to 25%. Amazon column: videoFirstQuartileViews.

video_midpoint_views

int

[en] Video ad: plays to 50%. Amazon column: videoMidpointViews.

video_third_quartile_views

int

[en] Video ad: plays to 75%. Amazon column: videoThirdQuartileViews.

Notes

Important notes about Amazon Ads data:

  • There are 5 reports (Sponsored Products, Sponsored Brands, Sponsored Display, Sponsored TV and Amazon DSP) and 22 registry integrations ("Metadata: ..." — accounts, portfolios, campaigns, ad groups, keywords, targets, ads, and DSP advertisers, campaigns and line items). Metadata integrations are not billed.
  • Report parameters: Accounts (empty = all, including future ones); Level; Breakdown (Amazon DSP only); Grouping period (day, week or month); Update window (days), default 30; Read start date. The report brings every column Amazon offers for the level and period; to leave one out, uncheck it on the fields screen.
  • Week and month groupings are totals computed by Amazon for the period — for example, DSP reach is the number of unique people in the period, not the sum of the days.
  • Every run, the reports re-read the last N days (the update window), because Amazon revises attributed conversions after the ad day.
  • Amazon data retention — limits how far back the first load and the update window can go (older days are not requested): Sponsored Products 95 days (search term 65); Sponsored Brands 60 days (purchased product 731); Sponsored Display 65 days; Sponsored TV 95 days; Amazon DSP 95 days; gross and invalid traffic 365 days.
  • Reports are generated asynchronously by Amazon and can take tens of minutes. The connector waits and retries when Amazon rate-limits requests, without losing data. A run either reads everything or fails without writing anything.
  • The replication key of the reports is account + date (on Amazon DSP, account + advertiser + date): on every run, each account's days in the update window are replaced by the new data. An account with no data on a day has nothing written or deleted for that day.
  • Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

Written by·Published 2026-10-02·Updated 2026-10-07