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
- In Kondado, add a new Amazon Ads data source.
- 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.
- Click Authorize. You will be redirected to Amazon (Login with Amazon).
- Sign in with the Amazon user that has access to the desired advertising accounts in the Amazon Ads console.
- The consent screen says Kondado would like access to: ... Access to advertiser account(s) with your user permission level. Click Allow.
- 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
- Amazon DSP report
- Metadata: Advertising accounts (profiles)
- Metadata: Amazon DSP - ad groups (line items)
- Metadata: Amazon DSP - advertisers
- Metadata: Amazon DSP - campaigns (orders)
- Metadata: Portfolios
- Metadata: Sponsored Brands - ad groups
- Metadata: Sponsored Brands - ads
- Metadata: Sponsored Brands - campaigns
- Metadata: Sponsored Brands - keywords
- Metadata: Sponsored Display - ad groups
- Metadata: Sponsored Display - campaigns
- Metadata: Sponsored Display - product ads
- Metadata: Sponsored Display - targets
- Metadata: Sponsored Products - ad groups
- Metadata: Sponsored Products - campaign negative keywords
- Metadata: Sponsored Products - campaigns
- Metadata: Sponsored Products - keywords
- Metadata: Sponsored Products - negative keywords
- Metadata: Sponsored Products - negative targets
- Metadata: Sponsored Products - product ads
- Metadata: Sponsored Products - targets
- Metadata: Sponsored TV - campaigns
- Sponsored Brands report
- Sponsored Display report
- Sponsored Products report
- Sponsored TV report
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] DSP advertiser id of the report. |
|
|
date |
[en] Row day; for week/month, the first day of the period (account time zone). |
|
|
text |
[en] Advertising account (profile) name. |
|
|
text |
[en] Account marketplace country (e.g. BR, US). |
|
|
text |
[en] Currency in which the row's cost and sales are expressed. |
|
|
float |
[en] Sum of third-party fees (verification, measurement, data). Amazon column: 3PFees. |
|
|
float |
[en] Third-party pre-bid filtering fee (brand safety). Amazon column: 3PPreBidFee. |
|
|
float |
[en] Third-party pre-bid filtering fee (Double Verify). Amazon column: 3PPreBidFeeDoubleVerify. |
|
|
float |
[en] Third-party pre-bid filtering fee (Integral Ad Science). Amazon column: 3PPreBidFeeIntegralAdScience. |
|
|
float |
[en] Third-party pre-bid filtering fee (Oracle Data Cloud). Amazon column: 3PPreBidFeeOracleDataCloud. |
|
|
float |
[en] Third-party pre-bid filtering fee (Pixalate). Amazon column: 3PPreBidFeePixalate. |
|
|
float |
[en] Third-party fee (Automotive). Amazon column: 3pFeeAutomotive. |
|
|
float |
[en] Third-party fee (Automotive), absorbed by Amazon (not charged). Amazon column: 3pFeeAutomotiveAbsorbed. |
|
|
float |
[en] Third-party fee (CPM1). Amazon column: 3pFeeCPM1. |
|
|
float |
[en] Third-party fee (CPM1), absorbed by Amazon (not charged). Amazon column: 3pFeeCPM1Absorbed. |
|
|
float |
[en] Third-party fee (CPM2). Amazon column: 3pFeeCPM2. |
|
|
float |
[en] Third-party fee (CPM2), absorbed by Amazon (not charged). Amazon column: 3pFeeCPM2Absorbed. |
|
|
float |
[en] Third-party fee (CPM3). Amazon column: 3pFeeCPM3. |
|
|
float |
[en] Third-party fee (CPM3), absorbed by Amazon (not charged). Amazon column: 3pFeeCPM3Absorbed. |
|
|
float |
[en] Third-party fee (Com Score). Amazon column: 3pFeeComScore. |
|
|
float |
[en] Third-party fee (Com Score), absorbed by Amazon (not charged). Amazon column: 3pFeeComScoreAbsorbed. |
|
|
float |
[en] Third-party fee (Double Verify). Amazon column: 3pFeeDoubleVerify. |
|
|
float |
[en] Third-party fee (Double Verify), absorbed by Amazon (not charged). Amazon column: 3pFeeDoubleVerifyAbsorbed. |
|
|
float |
[en] Third-party fee (Doubleclick Campaign Manager). Amazon column: 3pFeeDoubleclickCampaignManager. |
|
|
float |
[en] Third-party fee (Doubleclick Campaign Manager), absorbed by Amazon (not charged). Amazon column: 3pFeeDoubleclickCampaignManagerAbsorbed. |
|
|
float |
[en] Third-party fee (Integral Ad Science). Amazon column: 3pFeeIntegralAdScience. |
|
|
float |
[en] Third-party fee (Integral Ad Science), absorbed by Amazon (not charged). Amazon column: 3pFeeIntegralAdScienceAbsorbed. |
|
|
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. |
|
|
float |
[en] ROAS: attributed sales ÷ cost. Amazon column: ROAS. |
|
|
int |
[en] Add-to-cart events. Amazon column: addToCart. |
|
|
int |
[en] Add-to-cart events of other products of the same brand, halo effect, not the advertised one. Amazon column: addToCartBrandHalo. |
|
|
int |
[en] Add-to-cart events of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: addToCartBrandHaloClicks. |
|
|
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. |
|
|
int |
[en] Add-to-cart events (click attribution). Amazon column: addToCartClicks. |
|
|
float |
[en] Add-to-cart events ÷ impressions (rate). Amazon column: addToCartRate. |
|
|
int |
[en] Add-to-cart events (view attribution: ad seen, not clicked). Amazon column: addToCartViews. |
|
|
int |
[en] Add-to-list events. Amazon column: addToList. |
|
|
int |
[en] Add-to-list events of other products of the same brand, halo effect, not the advertised one. Amazon column: addToListBrandHalo. |
|
|
int |
[en] Add-to-list events of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: addToListBrandHaloClicks. |
|
|
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. |
|
|
int |
[en] Add-to-list events (click attribution). Amazon column: addToListClicks. |
|
|
float |
[en] Add-to-list events ÷ impressions (rate). Amazon column: addToListRate. |
|
|
int |
[en] Add-to-list events (view attribution: ad seen, not clicked). Amazon column: addToListViews. |
|
|
float |
[en] Add-to-cart events on the advertiser site. Amazon column: addToShoppingCart. |
|
|
text |
[en] Cost ÷ add-to-cart events on the advertiser site (cost per acquisition, CPA). Amazon column: addToShoppingCartCPA. |
|
|
float |
[en] Add-to-cart events on the advertiser site ÷ clicks (conversion rate). Amazon column: addToShoppingCartCVR. |
|
|
int |
[en] Add-to-cart events on the advertiser site (click attribution). Amazon column: addToShoppingCartClicks. |
|
|
text |
[en] Average value reported on add-to-cart events on the advertiser site. Amazon column: addToShoppingCartValueAverage. |
|
|
float |
[en] Sum of the value reported on add-to-cart events on the advertiser site. Amazon column: addToShoppingCartValueSum. |
|
|
int |
[en] Add-to-cart events on the advertiser site (view attribution: ad seen, not clicked). Amazon column: addToShoppingCartViews. |
|
|
int |
[en] Add-to-watchlist events (Prime Video). Amazon column: addToWatchlist. |
|
|
int |
[en] Add-to-watchlist events (Prime Video) (click attribution). Amazon column: addToWatchlistClicks. |
|
|
float |
[en] Add-to-watchlist events (Prime Video) ÷ impressions (rate). Amazon column: addToWatchlistRate. |
|
|
int |
[en] Add-to-watchlist events (Prime Video) (view attribution: ad seen, not clicked). Amazon column: addToWatchlistViews. |
|
|
text |
[en] DSP advertiser country. Amazon column: advertiserCountry. |
|
|
text |
[en] Name of the DSP advertiser. Amazon column: advertiserName. |
|
|
text |
[en] DSP advertiser time zone. Amazon column: advertiserTimezone. |
|
|
float |
[en] Agency fee charged in DSP. Amazon column: agencyFee. |
|
|
int |
[en] Alexa skill enables. Amazon column: alexaSkillEnable. |
|
|
int |
[en] Alexa skill enables (click attribution). Amazon column: alexaSkillEnableClicks. |
|
|
float |
[en] Alexa skill enables ÷ impressions (rate). Amazon column: alexaSkillEnableRate. |
|
|
int |
[en] Alexa skill enables (view attribution: ad seen, not clicked). Amazon column: alexaSkillEnableViews. |
|
|
float |
[en] Amazon DSP audience fee. Amazon column: amazonDSPAudienceFee. |
|
|
float |
[en] Amazon DSP console (platform) fee. Amazon column: amazonDSPConsoleFee. |
|
|
int |
[en] First app opens (Amazon Appstore). Amazon column: appStoreFirstOpens. |
|
|
int |
[en] First app opens (Amazon Appstore) (click attribution). Amazon column: appStoreFirstOpensClicks. |
|
|
float |
[en] First app opens (Amazon Appstore) ÷ impressions (rate). Amazon column: appStoreFirstOpensRate. |
|
|
int |
[en] First app opens (Amazon Appstore) (view attribution: ad seen, not clicked). Amazon column: appStoreFirstOpensViews. |
|
|
float |
[en] First-session hours in the app (Amazon Appstore). Amazon column: appStoreFirstSessionHours. |
|
|
float |
[en] First-session hours in the app (Amazon Appstore) (click attribution). Amazon column: appStoreFirstSessionHoursClicks. |
|
|
float |
[en] First-session hours in the app (Amazon Appstore) (view attribution: ad seen, not clicked). Amazon column: appStoreFirstSessionHoursViews. |
|
|
int |
[en] App opens (Amazon Appstore). Amazon column: appStoreOpens. |
|
|
int |
[en] App opens (Amazon Appstore) (click attribution). Amazon column: appStoreOpensClicks. |
|
|
float |
[en] App opens (Amazon Appstore) ÷ impressions (rate). Amazon column: appStoreOpensRate. |
|
|
int |
[en] App opens (Amazon Appstore) (view attribution: ad seen, not clicked). Amazon column: appStoreOpensViews. |
|
|
float |
[en] App usage hours (Amazon Appstore). Amazon column: appStoreUsageHours. |
|
|
float |
[en] App usage hours (Amazon Appstore) (click attribution). Amazon column: appStoreUsageHoursClicks. |
|
|
float |
[en] App usage hours (Amazon Appstore) (view attribution: ad seen, not clicked). Amazon column: appStoreUsageHoursViews. |
|
|
text |
[en] Cost per app subscription. Amazon column: appSubscriptionCost. |
|
|
text |
[en] Cost per app free-trial subscription. Amazon column: appSubscriptionFreeTrialCost. |
|
|
int |
[en] App subscription sign-ups. Amazon column: appSubscriptionSignUp. |
|
|
int |
[en] App subscription sign-ups (click attribution). Amazon column: appSubscriptionSignUpClicks. |
|
|
int |
[en] App free-trial subscription sign-ups. Amazon column: appSubscriptionSignUpFreeTrial. |
|
|
int |
[en] App free-trial subscription sign-ups (click attribution). Amazon column: appSubscriptionSignUpFreeTrialClicks. |
|
|
float |
[en] App free-trial subscription sign-ups ÷ impressions (rate). Amazon column: appSubscriptionSignUpFreeTrialRate. |
|
|
int |
[en] App free-trial subscription sign-ups (view attribution: ad seen, not clicked). Amazon column: appSubscriptionSignUpFreeTrialViews. |
|
|
int |
[en] Paid app subscription sign-ups. Amazon column: appSubscriptionSignUpPaid. |
|
|
int |
[en] Paid app subscription sign-ups (click attribution). Amazon column: appSubscriptionSignUpPaidClicks. |
|
|
text |
[en] Cost per paid app subscription. Amazon column: appSubscriptionSignUpPaidCost. |
|
|
float |
[en] Paid app subscription sign-ups ÷ impressions (rate). Amazon column: appSubscriptionSignUpPaidRate. |
|
|
int |
[en] Paid app subscription sign-ups (view attribution: ad seen, not clicked). Amazon column: appSubscriptionSignUpPaidViews. |
|
|
float |
[en] App subscription sign-ups ÷ impressions (rate). Amazon column: appSubscriptionSignUpRate. |
|
|
int |
[en] App subscription sign-ups (view attribution: ad seen, not clicked). Amazon column: appSubscriptionSignUpViews. |
|
|
int |
[en] Application conversions. Amazon column: application. |
|
|
text |
[en] Cost ÷ application conversions (cost per acquisition, CPA). Amazon column: applicationCPA. |
|
|
float |
[en] Application conversions ÷ clicks (conversion rate). Amazon column: applicationCVR. |
|
|
int |
[en] Application conversions (click attribution). Amazon column: applicationClicks. |
|
|
text |
[en] Average value reported on application conversions. Amazon column: applicationValueAverage. |
|
|
float |
[en] Sum of the value reported on application conversions. Amazon column: applicationValueSum. |
|
|
int |
[en] Application conversions (view attribution: ad seen, not clicked). Amazon column: applicationViews. |
|
|
text |
[en] Product ASIN. Amazon column: asin. |
|
|
int |
[en] Audio ad: companion banner clicks. Amazon column: audioAdCompanionBannerClicks. |
|
|
int |
[en] Audio ad: companion banner views. Amazon column: audioAdCompanionBannerViews. |
|
|
float |
[en] Audio ad: completion rate (complete ÷ starts). Amazon column: audioAdCompletionRate. |
|
|
int |
[en] Audio ad: complete plays. Amazon column: audioAdCompletions. |
|
|
int |
[en] Audio ad: plays to 25%. Amazon column: audioAdFirstQuartile. |
|
|
int |
[en] Audio ad: plays to 50%. Amazon column: audioAdMidpoint. |
|
|
int |
[en] Audio ad: mutes. Amazon column: audioAdMute. |
|
|
int |
[en] Audio ad: pauses. Amazon column: audioAdPause. |
|
|
int |
[en] Audio ad: progression events. Amazon column: audioAdProgression. |
|
|
float |
[en] Audio ad: resumes. Amazon column: audioAdResume. |
|
|
int |
[en] Audio ad: rewinds. Amazon column: audioAdRewind. |
|
|
int |
[en] Audio ad: skips. Amazon column: audioAdSkip. |
|
|
int |
[en] Audio ad: starts. Amazon column: audioAdStart. |
|
|
int |
[en] Audio ad: plays to 75%. Amazon column: audioAdThirdQuartile. |
|
|
int |
[en] Audio ad: unmutes. Amazon column: audioAdUnmute. |
|
|
int |
[en] Audio ad: views. Amazon column: audioAdViews. |
|
|
text |
[en] Average cost per click-to-apply. Amazon column: averageCostPerClickToApply. |
|
|
text |
[en] Average cost per Kindle detail page view. Amazon column: averageCostPerKindleDetailPageView. |
|
|
text |
[en] Brand name. Amazon column: brandName. |
|
|
float |
[en] Brand searches ÷ impressions. Amazon column: brandSearchRate. |
|
|
int |
[en] Brand searches on Amazon. Amazon column: brandSearches. |
|
|
int |
[en] Brand searches on Amazon (click attribution). Amazon column: brandSearchesClicks. |
|
|
int |
[en] Brand searches on Amazon (view attribution: ad seen, not clicked). Amazon column: brandSearchesViews. |
|
|
text |
[en] Browser. Amazon column: browserName. |
|
|
text |
[en] Browser version. Amazon column: browserVersion. |
|
|
int |
[en] Checkout conversions. Amazon column: checkout. |
|
|
float |
[en] Cost ÷ checkout conversions (cost per acquisition, CPA). Amazon column: checkoutCPA. |
|
|
float |
[en] Checkout conversions ÷ clicks (conversion rate). Amazon column: checkoutCVR. |
|
|
int |
[en] Checkout conversions (click attribution). Amazon column: checkoutClicks. |
|
|
text |
[en] Average value reported on checkout conversions. Amazon column: checkoutValueAverage. |
|
|
float |
[en] Sum of the value reported on checkout conversions. Amazon column: checkoutValueSum. |
|
|
int |
[en] Checkout conversions (view attribution: ad seen, not clicked). Amazon column: checkoutViews. |
|
|
text |
[en] City (geo breakdown). Amazon column: city. |
|
|
float |
[en] Click-through rate (CTR = clicks ÷ impressions). Amazon column: clickThroughRate. |
|
|
int |
[en] Click-to-apply events. Amazon column: clickToApply. |
|
|
int |
[en] Click-to-apply events of other products of the same brand, halo effect, not the advertised one. Amazon column: clickToApplyBrandHalo. |
|
|
int |
[en] Click-to-apply events of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: clickToApplyBrandHaloClicks. |
|
|
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. |
|
|
int |
[en] Click-to-apply events (click attribution). Amazon column: clickToApplyClicks. |
|
|
float |
[en] Click-to-apply ÷ clicks. Amazon column: clickToApplyConversionRate. |
|
|
int |
[en] Click-to-apply events (view attribution: ad seen, not clicked). Amazon column: clickToApplyViews. |
|
|
int |
[en] Clicks on the ad. Amazon column: clicks. |
|
|
float |
[en] Effective cost: cost ÷ purchases on Amazon + off Amazon. Amazon column: combinedECPP. |
|
|
float |
[en] Effective revenue per thousand impressions: sales (on Amazon + off Amazon) ÷ impressions × 1000. Amazon column: combinedERPM. |
|
|
float |
[en] Sales (value, in the account currency) on Amazon + off Amazon. Amazon column: combinedProductSales. |
|
|
float |
[en] Purchases (on Amazon + off Amazon) ÷ impressions (rate). Amazon column: combinedPurchaseRate. |
|
|
int |
[en] Purchases on Amazon + off Amazon. Amazon column: combinedPurchases. |
|
|
int |
[en] Purchases on Amazon + off Amazon (click attribution). Amazon column: combinedPurchasesClicks. |
|
|
int |
[en] Purchases on Amazon + off Amazon (view attribution: ad seen, not clicked). Amazon column: combinedPurchasesViews. |
|
|
float |
[en] ROAS: sales (on Amazon + off Amazon) ÷ cost. Amazon column: combinedROAS. |
|
|
int |
[en] Units sold on Amazon + off Amazon. Amazon column: combinedUnitsSold. |
|
|
int |
[en] Contact conversions. Amazon column: contact. |
|
|
float |
[en] Cost ÷ contact conversions (cost per acquisition, CPA). Amazon column: contactCPA. |
|
|
float |
[en] Contact conversions ÷ clicks (conversion rate). Amazon column: contactCVR. |
|
|
int |
[en] Contact conversions (click attribution). Amazon column: contactClicks. |
|
|
text |
[en] Average value reported on contact conversions. Amazon column: contactValueAverage. |
|
|
float |
[en] Sum of the value reported on contact conversions. Amazon column: contactValueSum. |
|
|
int |
[en] Contact conversions (view attribution: ad seen, not clicked). Amazon column: contactViews. |
|
|
text |
[en] Row conversion type. Amazon column: conversionType. |
|
|
text |
[en] Country (geo breakdown). Amazon column: country. |
|
|
text |
[en] Id of the creative ad (text). Amazon column: creativeAdId. |
|
|
text |
[en] Id of the creative (text). Amazon column: creativeId. |
|
|
text |
[en] Creative language. Amazon column: creativeLanguage. |
|
|
text |
[en] Name of the creative. Amazon column: creativeName. |
|
|
text |
[en] Creative size. Amazon column: creativeSize. |
|
|
text |
[en] Creative type. Amazon column: creativeType. |
|
|
text |
[en] Creative rotation weight. Amazon column: creativeWeight. |
|
|
int |
[en] Product detail page views of other products of the same brand, halo effect, not the advertised one. Amazon column: detailPageViewBrandHalo. |
|
|
int |
[en] Product detail page views of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: detailPageViewBrandHaloClicks. |
|
|
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. |
|
|
int |
[en] Product detail page views (click attribution). Amazon column: detailPageViewClicks. |
|
|
float |
[en] Product detail page views ÷ impressions (rate). Amazon column: detailPageViewRate. |
|
|
float |
[en] Click-attributed detail page views of the promoted product ÷ clicks. Amazon column: detailPageViewRatePromotedClicks. |
|
|
int |
[en] Product detail page views (view attribution: ad seen, not clicked). Amazon column: detailPageViewViews. |
|
|
int |
[en] Product detail page views. Amazon column: detailPageViews. |
|
|
text |
[en] Device type. Amazon column: deviceName. |
|
|
text |
[en] DMA (US market area) code. Amazon column: dmaCode. |
|
|
text |
[en] DMA (US market area) name. Amazon column: dmaName. |
|
|
float |
[en] Downloaded video plays (Prime Video) ÷ impressions (rate). Amazon column: downloadedVideoPlayRate. |
|
|
int |
[en] Downloaded video plays (Prime Video). Amazon column: downloadedVideoPlays. |
|
|
int |
[en] Downloaded video plays (Prime Video) (click attribution). Amazon column: downloadedVideoPlaysClicks. |
|
|
int |
[en] Downloaded video plays (Prime Video) (view attribution: ad seen, not clicked). Amazon column: downloadedVideoPlaysViews. |
|
|
float |
[en] Effective cost: cost ÷ add-to-cart events. Amazon column: eCPAddToCart. |
|
|
float |
[en] Effective cost: cost ÷ add-to-list events. Amazon column: eCPAddToList. |
|
|
text |
[en] Effective cost: cost ÷ add-to-watchlist events (Prime Video). Amazon column: eCPAddToWatchlist. |
|
|
text |
[en] Effective cost: cost ÷ Alexa skill enables. Amazon column: eCPAlexaSkillEnable. |
|
|
text |
[en] Effective cost: cost ÷ first app opens (Amazon Appstore). Amazon column: eCPAppStoreFirstOpens. |
|
|
text |
[en] Effective cost: cost ÷ app opens (Amazon Appstore). Amazon column: eCPAppStoreOpens. |
|
|
text |
[en] Effective cost: cost ÷ audio ad completions. Amazon column: eCPAudioAdCompletion. |
|
|
float |
[en] Effective cost: cost ÷ brand searches on Amazon. Amazon column: eCPBrandSearch. |
|
|
float |
[en] Effective cost per click (total cost ÷ clicks). Amazon column: eCPC. |
|
|
float |
[en] Effective cost: cost ÷ product detail page views. Amazon column: eCPDetailPageView. |
|
|
text |
[en] Effective cost: cost ÷ downloaded video plays (Prime Video). Amazon column: eCPDownloadedVideoPlays. |
|
|
text |
[en] Effective cost: cost ÷ free-trial subscription sign-ups. Amazon column: eCPFreeTrialSubscriptionSignup. |
|
|
float |
[en] Effective cost per thousand impressions (total cost ÷ impressions × 1000). Amazon column: eCPM. |
|
|
float |
[en] Effective cost: cost ÷ purchases. Amazon column: eCPP. |
|
|
text |
[en] Effective cost: cost ÷ paid subscription sign-ups. Amazon column: eCPPaidSubscriptionSignup. |
|
|
text |
[en] Effective cost: cost ÷ trailer plays (Prime Video). Amazon column: eCPPlayTrailer. |
|
|
float |
[en] Effective cost: cost ÷ product review page visits. Amazon column: eCPProductReviewPageVisit. |
|
|
text |
[en] Effective cost: cost ÷ video rentals (Prime Video). Amazon column: eCPRental. |
|
|
text |
[en] Effective cost: cost ÷ Alexa skill invocations. Amazon column: eCPSkillInvocation. |
|
|
text |
[en] Effective cost: cost ÷ subscription sign-ups. Amazon column: eCPSubscriptionSignup. |
|
|
text |
[en] Effective cost: cost ÷ video ad completions. Amazon column: eCPVideoAdCompletion. |
|
|
text |
[en] Effective cost: cost ÷ video downloads (Prime Video). Amazon column: eCPVideoDownload. |
|
|
text |
[en] Effective cost: cost ÷ video streams (Prime Video). Amazon column: eCPVideoStream. |
|
|
float |
[en] Effective cost: cost ÷ new Subscribe & Save subscriptions. Amazon column: eCPnewSubscribeAndSave. |
|
|
float |
[en] Effective revenue per thousand impressions (sales ÷ impressions × 1000). Amazon column: eRPM. |
|
|
float |
[en] Effective cost per click-attributed detail page view of the promoted product. Amazon column: effectiveCostPerDetailPageViewPromotedClicks. |
|
|
float |
[en] Effective cost per click-attributed purchase of the promoted product. Amazon column: effectiveCostPerPurchasePromotedClicks. |
|
|
text |
[en] Effective cost per Alexa skill invocation. Amazon column: effectiveCostPerSkillInvocation. |
|
|
int |
[en] Kindle e-ink detail page views. Amazon column: einkDetailPageView. |
|
|
int |
[en] Kindle e-ink detail page views of other products of the same brand, halo effect, not the advertised one. Amazon column: einkDetailPageViewBrandHalo. |
|
|
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. |
|
|
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. |
|
|
int |
[en] Kindle e-ink detail page views (click attribution). Amazon column: einkDetailPageViewClicks. |
|
|
int |
[en] Kindle e-ink detail page views (view attribution: ad seen, not clicked). Amazon column: einkDetailPageViewViews. |
|
|
text |
[en] Entity (DSP account) id. Amazon column: entityId. |
|
|
text |
[en] Environment (web, app). Amazon column: environmentName. |
|
|
text |
[en] ASIN featured in the creative. Amazon column: featuredAsin. |
|
|
float |
[en] Flight (delivery period) budget. Amazon column: flightBudget. |
|
|
text |
[en] Flight end. Amazon column: flightEndDate. |
|
|
text |
[en] Id of the flight (DSP delivery period) (text). Amazon column: flightId. |
|
|
text |
[en] Name of the flight (DSP delivery period). Amazon column: flightName. |
|
|
text |
[en] Flight start. Amazon column: flightStartDate. |
|
|
int |
[en] Free-trial subscription sign-ups (click attribution). Amazon column: freeTrialSubscriptionSignupClicks. |
|
|
float |
[en] Free-trial subscription sign-ups ÷ impressions (rate). Amazon column: freeTrialSubscriptionSignupRate. |
|
|
int |
[en] Free-trial subscription sign-ups (view attribution: ad seen, not clicked). Amazon column: freeTrialSubscriptionSignupViews. |
|
|
int |
[en] Free-trial subscription sign-ups. Amazon column: freeTrialSubscriptionSignups. |
|
|
float |
[en] Average frequency: impressions ÷ reach. Amazon column: frequencyAverage. |
|
|
int |
[en] Gross clicks, before filtering invalid traffic. Amazon column: grossClickThroughs. |
|
|
int |
[en] Gross impressions, before filtering invalid traffic. Amazon column: grossImpressions. |
|
|
float |
[en] Average frequency per household. Amazon column: householdFrequencyAverage. |
|
|
int |
[en] Unique households reached. Amazon column: householdReach. |
|
|
float |
[en] Average frequency: impressions ÷ reach. Amazon column: impressionFrequencyAverage. |
|
|
int |
[en] Impressions: times the ad was shown. Amazon column: impressions. |
|
|
int |
[en] Interactive creative impressions. Amazon column: interactiveImpressions. |
|
|
text |
[en] End of the interval Amazon split the period into (DSP week/month). Amazon column: intervalEnd. |
|
|
text |
[en] Start of the interval Amazon split the period into (DSP week/month). Amazon column: intervalStart. |
|
|
float |
[en] Invalid clicks ÷ gross clicks. Amazon column: invalidClickThroughRate. |
|
|
int |
[en] Clicks discarded as invalid traffic (not billed). Amazon column: invalidClickThroughs. |
|
|
float |
[en] Invalid impressions ÷ gross impressions. Amazon column: invalidImpressionRate. |
|
|
int |
[en] Impressions discarded as invalid traffic (not billed). Amazon column: invalidImpressions. |
|
|
int |
[en] Kindle detail page views. Amazon column: kindleDetailPageView. |
|
|
int |
[en] Kindle detail page views (click attribution). Amazon column: kindleDetailPageViewClicks. |
|
|
float |
[en] Kindle detail page views ÷ impressions (rate). Amazon column: kindleDetailPageViewRate. |
|
|
int |
[en] Kindle detail page views (view attribution: ad seen, not clicked). Amazon column: kindleDetailPageViewViews. |
|
|
int |
[en] Kindle Unlimited pages read (KENP). Amazon column: kindleEditionNormalizedPagesRead. |
|
|
int |
[en] Kindle Unlimited pages read (KENP) (click attribution). Amazon column: kindleEditionNormalizedPagesReadFromClicks. |
|
|
int |
[en] Kindle Unlimited pages read (KENP) (view attribution: ad seen, not clicked). Amazon column: kindleEditionNormalizedPagesReadFromViews. |
|
|
int |
[en] Leads. Amazon column: lead. |
|
|
float |
[en] Cost ÷ leads (cost per acquisition, CPA). Amazon column: leadCPA. |
|
|
float |
[en] Leads ÷ clicks (conversion rate). Amazon column: leadCVR. |
|
|
int |
[en] Leads (click attribution). Amazon column: leadClicks. |
|
|
text |
[en] Average value reported on leads. Amazon column: leadValueAverage. |
|
|
float |
[en] Sum of the value reported on leads. Amazon column: leadValueSum. |
|
|
int |
[en] Leads (view attribution: ad seen, not clicked). Amazon column: leadViews. |
|
|
text |
[en] Line item approval status. Amazon column: lineItemApprovalStatus. |
|
|
float |
[en] Line item budget. Amazon column: lineItemBudget. |
|
|
text |
[en] Line item budget cap. Amazon column: lineItemBudgetCap. |
|
|
text |
[en] Line item comment. Amazon column: lineItemComment. |
|
|
text |
[en] Line item comments. Amazon column: lineItemComments. |
|
|
text |
[en] Line item end. Amazon column: lineItemEndDate. |
|
|
text |
[en] Line item external id. Amazon column: lineItemExternalId. |
|
|
text |
[en] Id of the line item (DSP) (text). Amazon column: lineItemId. |
|
|
text |
[en] Languages targeted by the line item. Amazon column: lineItemLanguageTargeting. |
|
|
text |
[en] Name of the line item (DSP). Amazon column: lineItemName. |
|
|
text |
[en] Line item start. Amazon column: lineItemStartDate. |
|
|
text |
[en] Status of the line item (DSP). Amazon column: lineItemStatus. |
|
|
text |
[en] Line item type (display, video, audio...). Amazon column: lineItemType. |
|
|
float |
[en] Long-term ROAS: long-term sales ÷ cost. Amazon column: longTermROAS. |
|
|
float |
[en] Long-term sales: sales attributed within 12 months (Sponsored Brands). Amazon column: longTermSales. |
|
|
float |
[en] Amazon managed service fee. Amazon column: managedServiceFee. |
|
|
text |
[en] Amazon marketplace. Amazon column: marketplace. |
|
|
int |
[en] Clicks on the master creative. Amazon column: masterClicks. |
|
|
int |
[en] Impressions of the master creative in an ad with companions. Amazon column: masterImpressions. |
|
|
int |
[en] Impressions where viewability could be measured. Amazon column: measurableImpressions. |
|
|
float |
[en] Measurable impressions ÷ impressions. Amazon column: measurableRate. |
|
|
text |
[en] Average value of mobile app first starts. Amazon column: mobileAppFirstStartAverage. |
|
|
text |
[en] Cost ÷ mobile app first starts (cost per acquisition, CPA). Amazon column: mobileAppFirstStartCPA. |
|
|
float |
[en] Mobile app first starts ÷ clicks (conversion rate). Amazon column: mobileAppFirstStartCVR. |
|
|
int |
[en] Mobile app first starts (click attribution). Amazon column: mobileAppFirstStartClicks. |
|
|
float |
[en] Sum of the value of mobile app first starts. Amazon column: mobileAppFirstStartSum. |
|
|
int |
[en] Mobile app first starts (view attribution: ad seen, not clicked). Amazon column: mobileAppFirstStartViews. |
|
|
int |
[en] Mobile app first starts. Amazon column: mobileAppFirstStarts. |
|
|
int |
[en] Purchases with multi-touch attribution, credit split across the ads on the path to purchase. Amazon column: multiTouchPurchases. |
|
|
int |
[en] Purchases with multi-touch attribution, credit split across the ads on the path to purchase (click attribution). Amazon column: multiTouchPurchasesClicks. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
int |
[en] Units sold with multi-touch attribution, credit split across the ads on the path to purchase. Amazon column: multiTouchUnitsSold. |
|
|
int |
[en] New Subscribe & Save subscriptions. Amazon column: newSubscribeAndSave. |
|
|
int |
[en] New Subscribe & Save subscriptions of other products of the same brand, halo effect, not the advertised one. Amazon column: newSubscribeAndSaveBrandHalo. |
|
|
int |
[en] New Subscribe & Save subscriptions of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: newSubscribeAndSaveBrandHaloClicks. |
|
|
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. |
|
|
int |
[en] New Subscribe & Save subscriptions (click attribution). Amazon column: newSubscribeAndSaveClicks. |
|
|
float |
[en] New Subscribe & Save subscriptions ÷ impressions (rate). Amazon column: newSubscribeAndSaveRate. |
|
|
int |
[en] New Subscribe & Save subscriptions (view attribution: ad seen, not clicked). Amazon column: newSubscribeAndSaveViews. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
float |
[en] Share of brand-halo purchases made by new-to-brand customers. Amazon column: newToBrandPurchasePercentageBrandHalo. |
|
|
float |
[en] Purchases (from new-to-brand customers, with no purchase from the brand in the last 12 months) ÷ impressions (rate). Amazon column: newToBrandPurchaseRate. |
|
|
int |
[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandPurchases. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
int |
[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandPurchasesClicks. |
|
|
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. |
|
|
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. |
|
|
float |
[en] ROAS: sales (from new-to-brand customers, with no purchase from the brand in the last 12 months) ÷ cost. Amazon column: newToBrandROAS. |
|
|
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. |
|
|
int |
[en] Units sold from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandUnitsSold. |
|
|
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. |
|
|
int |
[en] Notification clicks. Amazon column: notificationClicks. |
|
|
int |
[en] Notification opens. Amazon column: notificationOpens. |
|
|
text |
[en] Cost per off-Amazon conversion (cost ÷ off-Amazon conversions). Amazon column: offAmazonCPA. |
|
|
float |
[en] Off-Amazon conversion rate (off-Amazon conversions ÷ clicks). Amazon column: offAmazonCVR. |
|
|
int |
[en] Off-Amazon conversions attributed to clicks. Amazon column: offAmazonClicks. |
|
|
int |
[en] Conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonConversions. |
|
|
text |
[en] Effective cost: cost ÷ purchases off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonECPP. |
|
|
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. |
|
|
float |
[en] Sales (value, in the account currency) off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonProductSales. |
|
|
float |
[en] Purchases (off Amazon, on the advertiser site/app, measured by the conversion tag) ÷ impressions (rate). Amazon column: offAmazonPurchaseRate. |
|
|
int |
[en] Purchases off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonPurchases. |
|
|
int |
[en] Purchases off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonPurchasesClicks. |
|
|
int |
[en] Purchases off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonPurchasesViews. |
|
|
float |
[en] ROAS: sales (off Amazon, on the advertiser site/app, measured by the conversion tag) ÷ cost. Amazon column: offAmazonROAS. |
|
|
int |
[en] Units sold off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonUnitsSold. |
|
|
int |
[en] Off-Amazon conversions attributed to views (ad seen, not clicked). Amazon column: offAmazonViews. |
|
|
float |
[en] Omnichannel metrics fee. Amazon column: omnichannelMetricsFee. |
|
|
text |
[en] Line item id in the order management system (OMS). Amazon column: omsLineItemId. |
|
|
text |
[en] Proposal id in the order management system (OMS). Amazon column: omsProposalId. |
|
|
text |
[en] Cost per thousand on-target impressions. Amazon column: onTargetCPM. |
|
|
float |
[en] Cost of on-target impressions. Amazon column: onTargetImpressionCost. |
|
|
int |
[en] Impressions delivered to the demographic target (third-party measurement, e.g. Nielsen). Amazon column: onTargetImpressions. |
|
|
text |
[en] Operating system. Amazon column: operatingSystemName. |
|
|
float |
[en] Order (DSP campaign) budget. Amazon column: orderBudget. |
|
|
text |
[en] Order currency. Amazon column: orderCurrency. |
|
|
text |
[en] Order end. Amazon column: orderEndDate. |
|
|
text |
[en] Order external id, set by the advertiser. Amazon column: orderExternalId. |
|
|
text |
[en] Id of the order (DSP campaign) (text). Amazon column: orderId. |
|
|
text |
[en] Name of the order (DSP campaign). Amazon column: orderName. |
|
|
text |
[en] Order start. Amazon column: orderStartDate. |
|
|
float |
[en] "other" conversions. Amazon column: other. |
|
|
float |
[en] Cost ÷ "other" conversions (cost per acquisition, CPA). Amazon column: otherCPA. |
|
|
float |
[en] "other" conversions ÷ clicks (conversion rate). Amazon column: otherCVR. |
|
|
int |
[en] "other" conversions (click attribution). Amazon column: otherClicks. |
|
|
text |
[en] Average value reported on "other" conversions. Amazon column: otherValueAverage. |
|
|
float |
[en] Sum of the value reported on "other" conversions. Amazon column: otherValueSum. |
|
|
int |
[en] "other" conversions (view attribution: ad seen, not clicked). Amazon column: otherViews. |
|
|
float |
[en] Cost ÷ page views (cost per acquisition, CPA). Amazon column: pageViewCPA. |
|
|
float |
[en] Page views ÷ clicks (conversion rate). Amazon column: pageViewCVR. |
|
|
int |
[en] Page views (click attribution). Amazon column: pageViewClicks. |
|
|
text |
[en] Average value reported on page views. Amazon column: pageViewValueAverage. |
|
|
float |
[en] Sum of the value reported on page views. Amazon column: pageViewValueSum. |
|
|
int |
[en] Page views (view attribution: ad seen, not clicked). Amazon column: pageViewViews. |
|
|
int |
[en] Page views. Amazon column: pageViews. |
|
|
int |
[en] Paid subscription sign-ups (click attribution). Amazon column: paidSubscriptionSignupClicks. |
|
|
float |
[en] Paid subscription sign-ups ÷ impressions (rate). Amazon column: paidSubscriptionSignupRate. |
|
|
int |
[en] Paid subscription sign-ups (view attribution: ad seen, not clicked). Amazon column: paidSubscriptionSignupViews. |
|
|
int |
[en] Paid subscription sign-ups. Amazon column: paidSubscriptionSignups. |
|
|
text |
[en] Parent ASIN (groups variations). Amazon column: parentAsin. |
|
|
float |
[en] Trailer plays (Prime Video) ÷ impressions (rate). Amazon column: playTrailerRate. |
|
|
int |
[en] Trailer plays (Prime Video). Amazon column: playTrailers. |
|
|
int |
[en] Trailer plays (Prime Video) (click attribution). Amazon column: playTrailersClicks. |
|
|
int |
[en] Trailer plays (Prime Video) (view attribution: ad seen, not clicked). Amazon column: playTrailersViews. |
|
|
text |
[en] Postal code (geo breakdown). Amazon column: postalCode. |
|
|
text |
[en] Product category. Amazon column: productCategory. |
|
|
text |
[en] Product group. Amazon column: productGroup. |
|
|
text |
[en] Product name. Amazon column: productName. |
|
|
float |
[en] Product review page visits of other products of the same brand, halo effect, not the advertised one. Amazon column: productReviewPageViewBrandHalo. |
|
|
float |
[en] Product review page visits of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: productReviewPageViewBrandHaloClicks. |
|
|
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. |
|
|
float |
[en] Product review page visits ÷ impressions (rate). Amazon column: productReviewPageVisitRate. |
|
|
float |
[en] Product review page visits. Amazon column: productReviewPageVisits. |
|
|
float |
[en] Product review page visits (click attribution). Amazon column: productReviewPageVisitsClicks. |
|
|
float |
[en] Product review page visits (view attribution: ad seen, not clicked). Amazon column: productReviewPageVisitsViews. |
|
|
text |
[en] Product subcategory. Amazon column: productSubCategory. |
|
|
text |
[en] Proposal id. Amazon column: proposalId. |
|
|
float |
[en] Purchases ÷ impressions. Amazon column: purchaseRate. |
|
|
int |
[en] Purchases. Amazon column: purchases. |
|
|
int |
[en] Purchases of other products of the same brand, halo effect, not the advertised one. Amazon column: purchasesBrandHalo. |
|
|
int |
[en] Purchases of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: purchasesBrandHaloClicks. |
|
|
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. |
|
|
int |
[en] Purchases (click attribution). Amazon column: purchasesClicks. |
|
|
float |
[en] Click-attributed purchases ÷ clicks. Amazon column: purchasesClicksRate. |
|
|
int |
[en] Purchases (view attribution: ad seen, not clicked). Amazon column: purchasesViews. |
|
|
int |
[en] Qualified e-book borrows. Amazon column: qualifiedBorrows. |
|
|
int |
[en] Qualified e-book borrows (click attribution). Amazon column: qualifiedBorrowsFromClicks. |
|
|
int |
[en] Qualified e-book borrows (view attribution: ad seen, not clicked). Amazon column: qualifiedBorrowsFromViews. |
|
|
int |
[en] Reach: unique people who saw the ad in the period (not additive across days). Amazon column: reach. |
|
|
text |
[en] Region/state (geo breakdown). Amazon column: region. |
|
|
float |
[en] Video rentals (Prime Video) ÷ impressions (rate). Amazon column: rentalRate. |
|
|
int |
[en] Video rentals (Prime Video). Amazon column: rentals. |
|
|
int |
[en] Video rentals (Prime Video) (click attribution). Amazon column: rentalsClicks. |
|
|
int |
[en] Video rentals (Prime Video) (view attribution: ad seen, not clicked). Amazon column: rentalsViews. |
|
|
text |
[en] Report granularity reported by Amazon. Amazon column: reportGranularity. |
|
|
float |
[en] Royalty-qualified e-book borrows. Amazon column: royaltyQualifiedBorrows. |
|
|
float |
[en] Royalty-qualified e-book borrows (click attribution). Amazon column: royaltyQualifiedBorrowsFromClicks. |
|
|
float |
[en] Royalty-qualified e-book borrows (view attribution: ad seen, not clicked). Amazon column: royaltyQualifiedBorrowsFromViews. |
|
|
float |
[en] Sales (value, in the account currency). Amazon column: sales. |
|
|
float |
[en] Sales (value, in the account currency) of other products of the same brand, halo effect, not the advertised one. Amazon column: salesBrandHalo. |
|
|
float |
[en] Sales (value, in the account currency) (click attribution). Amazon column: salesClicks. |
|
|
float |
[en] Sales (value, in the account currency) of the advertised product. Amazon column: salesPromoted. |
|
|
float |
[en] Sales (value, in the account currency) of the advertised product (click attribution). Amazon column: salesPromotedClicks. |
|
|
int |
[en] Search conversions. Amazon column: search. |
|
|
float |
[en] Cost ÷ search conversions (cost per acquisition, CPA). Amazon column: searchCPA. |
|
|
float |
[en] Search conversions ÷ clicks (conversion rate). Amazon column: searchCVR. |
|
|
int |
[en] Search conversions (click attribution). Amazon column: searchClicks. |
|
|
text |
[en] Average value reported on search conversions. Amazon column: searchValueAverage. |
|
|
float |
[en] Sum of the value reported on search conversions. Amazon column: searchValueSum. |
|
|
int |
[en] Search conversions (view attribution: ad seen, not clicked). Amazon column: searchViews. |
|
|
text |
[en] Audience class. Amazon column: segmentClassCode. |
|
|
text |
[en] Id of the audience (segment) (text). Amazon column: segmentId. |
|
|
text |
[en] Audience marketplace. Amazon column: segmentMarketplaceId. |
|
|
text |
[en] Audience (segment) name. Amazon column: segmentName. |
|
|
text |
[en] Audience source (Amazon, third party, advertiser). Amazon column: segmentSource. |
|
|
text |
[en] Audience type. Amazon column: segmentType. |
|
|
int |
[en] Sign-ups. Amazon column: signUp. |
|
|
float |
[en] Cost ÷ sign-ups (cost per acquisition, CPA). Amazon column: signUpCPA. |
|
|
float |
[en] Sign-ups ÷ clicks (conversion rate). Amazon column: signUpCVR. |
|
|
int |
[en] Sign-ups (click attribution). Amazon column: signUpClicks. |
|
|
text |
[en] Average value reported on sign-ups. Amazon column: signUpValueAverage. |
|
|
float |
[en] Sum of the value reported on sign-ups. Amazon column: signUpValueSum. |
|
|
int |
[en] Sign-ups (view attribution: ad seen, not clicked). Amazon column: signUpViews. |
|
|
int |
[en] Alexa skill invocations. Amazon column: skillInvocation. |
|
|
int |
[en] Alexa skill invocations (click attribution). Amazon column: skillInvocationClicks. |
|
|
float |
[en] Alexa skill invocations ÷ impressions (rate). Amazon column: skillInvocationRate. |
|
|
int |
[en] Alexa skill invocations (view attribution: ad seen, not clicked). Amazon column: skillInvocationViews. |
|
|
int |
[en] Subscribe conversions. Amazon column: subscribe. |
|
|
text |
[en] Cost ÷ subscribe conversions (cost per acquisition, CPA). Amazon column: subscribeCPA. |
|
|
float |
[en] Subscribe conversions ÷ clicks (conversion rate). Amazon column: subscribeCVR. |
|
|
int |
[en] Subscribe conversions (click attribution). Amazon column: subscribeClicks. |
|
|
text |
[en] Average value reported on subscribe conversions. Amazon column: subscribeValueAverage. |
|
|
float |
[en] Sum of the value reported on subscribe conversions. Amazon column: subscribeValueSum. |
|
|
int |
[en] Subscribe conversions (view attribution: ad seen, not clicked). Amazon column: subscribeViews. |
|
|
int |
[en] Subscription sign-ups (click attribution). Amazon column: subscriptionSignupClicks. |
|
|
float |
[en] Subscription sign-ups ÷ impressions (rate). Amazon column: subscriptionSignupRate. |
|
|
int |
[en] Subscription sign-ups (view attribution: ad seen, not clicked). Amazon column: subscriptionSignupViews. |
|
|
int |
[en] Subscription sign-ups. Amazon column: subscriptionSignups. |
|
|
float |
[en] DSP media (inventory) cost, without fees. Amazon column: supplyCost. |
|
|
text |
[en] Demographic target of the on-target measurement. Amazon column: targetDemographic. |
|
|
text |
[en] Targeting method. Amazon column: targetingMethod. |
|
|
int |
[en] Add-to-cart events in total: advertised product + other products of the same brand. Amazon column: totalAddToCart. |
|
|
int |
[en] Add-to-cart events in total: advertised product + other products of the same brand (click attribution). Amazon column: totalAddToCartClicks. |
|
|
float |
[en] Add-to-cart events (in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalAddToCartRate. |
|
|
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. |
|
|
int |
[en] Add-to-list events in total: advertised product + other products of the same brand. Amazon column: totalAddToList. |
|
|
int |
[en] Add-to-list events in total: advertised product + other products of the same brand (click attribution). Amazon column: totalAddToListClicks. |
|
|
float |
[en] Add-to-list events (in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalAddToListRate. |
|
|
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. |
|
|
float |
[en] DSP total cost: media + Amazon and third-party fees, in the order currency. Amazon column: totalCost. |
|
|
int |
[en] Product detail page views in total: advertised product + other products of the same brand. Amazon column: totalDetailPageView. |
|
|
int |
[en] Product detail page views in total: advertised product + other products of the same brand (click attribution). Amazon column: totalDetailPageViewClicks. |
|
|
float |
[en] Product detail page views (in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalDetailPageViewRate. |
|
|
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. |
|
|
float |
[en] Effective cost: cost ÷ add-to-cart events in total: advertised product + other products of the same brand. Amazon column: totalECPAddToCart. |
|
|
float |
[en] Effective cost: cost ÷ add-to-list events in total: advertised product + other products of the same brand. Amazon column: totalECPAddToList. |
|
|
float |
[en] Effective cost: cost ÷ product detail page views in total: advertised product + other products of the same brand. Amazon column: totalECPDetailPageView. |
|
|
float |
[en] Effective cost: cost ÷ purchases in total: advertised product + other products of the same brand. Amazon column: totalECPP. |
|
|
float |
[en] Effective cost: cost ÷ product review page visits in total: advertised product + other products of the same brand. Amazon column: totalECPProductReviewPageVisit. |
|
|
float |
[en] Effective cost: cost ÷ new Subscribe & Save subscriptions in total: advertised product + other products of the same brand. Amazon column: totalECPSubscribeAndSave. |
|
|
float |
[en] Effective revenue per thousand impressions: sales (in total: advertised product + other products of the same brand) ÷ impressions × 1000. Amazon column: totalERPM. |
|
|
float |
[en] Sum of all DSP fees. Amazon column: totalFee. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
float |
[en] Product review page visits (in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalProductReviewPageVisitRate. |
|
|
float |
[en] Product review page visits in total: advertised product + other products of the same brand. Amazon column: totalProductReviewPageVisits. |
|
|
float |
[en] Product review page visits in total: advertised product + other products of the same brand (click attribution). Amazon column: totalProductReviewPageVisitsClicks. |
|
|
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. |
|
|
float |
[en] Purchases (in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalPurchaseRate. |
|
|
int |
[en] Purchases in total: advertised product + other products of the same brand. Amazon column: totalPurchases. |
|
|
int |
[en] Purchases in total: advertised product + other products of the same brand (click attribution). Amazon column: totalPurchasesClicks. |
|
|
int |
[en] Purchases in total: advertised product + other products of the same brand (view attribution: ad seen, not clicked). Amazon column: totalPurchasesViews. |
|
|
float |
[en] ROAS: sales (in total: advertised product + other products of the same brand) ÷ cost. Amazon column: totalROAS. |
|
|
float |
[en] Sales (value, in the account currency) in total: advertised product + other products of the same brand. Amazon column: totalSales. |
|
|
int |
[en] New Subscribe & Save subscriptions in total: advertised product + other products of the same brand. Amazon column: totalSubscribeAndSave. |
|
|
int |
[en] New Subscribe & Save subscriptions in total: advertised product + other products of the same brand (click attribution). Amazon column: totalSubscribeAndSaveClicks. |
|
|
float |
[en] New Subscribe & Save subscriptions (in total: advertised product + other products of the same brand) ÷ impressions (rate). Amazon column: totalSubscribeAndSaveRate. |
|
|
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. |
|
|
int |
[en] Units sold in total: advertised product + other products of the same brand. Amazon column: totalUnitsSold. |
|
|
int |
[en] Units sold. Amazon column: unitsSold. |
|
|
int |
[en] Units sold of other products of the same brand, halo effect, not the advertised one. Amazon column: unitsSoldBrandHalo. |
|
|
int |
[en] Units sold (click attribution). Amazon column: unitsSoldClicks. |
|
|
int |
[en] Units sold of the advertised product (click attribution). Amazon column: unitsSoldPromotedClicks. |
|
|
int |
[en] Video ad: clicks. Amazon column: videoAdClicks. |
|
|
float |
[en] Video ad: complete plays. Amazon column: videoAdComplete. |
|
|
float |
[en] Video ad: completion rate (complete ÷ starts). Amazon column: videoAdCompletionRate. |
|
|
int |
[en] Video ad: creative views. Amazon column: videoAdCreativeViews. |
|
|
int |
[en] Video ad: end-card clicks. Amazon column: videoAdEndStateClicks. |
|
|
int |
[en] Video ad: plays to 25%. Amazon column: videoAdFirstQuartile. |
|
|
int |
[en] Video ad: impressions. Amazon column: videoAdImpressions. |
|
|
int |
[en] Video ad: plays to 50%. Amazon column: videoAdMidpoint. |
|
|
int |
[en] Video ad: mutes. Amazon column: videoAdMute. |
|
|
int |
[en] Video ad: pauses. Amazon column: videoAdPause. |
|
|
int |
[en] Video ad: replays. Amazon column: videoAdReplays. |
|
|
float |
[en] Video ad: resumes. Amazon column: videoAdResume. |
|
|
int |
[en] Video ad: skip-backs. Amazon column: videoAdSkipBacks. |
|
|
int |
[en] Video ad: skip-forwards. Amazon column: videoAdSkipForwards. |
|
|
int |
[en] Video ad: starts. Amazon column: videoAdStart. |
|
|
int |
[en] Video ad: plays to 75%. Amazon column: videoAdThirdQuartile. |
|
|
int |
[en] Video ad: unmutes. Amazon column: videoAdUnmute. |
|
|
float |
[en] Video downloads (Prime Video) ÷ impressions (rate). Amazon column: videoDownloadRate. |
|
|
int |
[en] Video downloads (Prime Video). Amazon column: videoDownloads. |
|
|
int |
[en] Video downloads (Prime Video) (click attribution). Amazon column: videoDownloadsClicks. |
|
|
int |
[en] Video downloads (Prime Video) (view attribution: ad seen, not clicked). Amazon column: videoDownloadsViews. |
|
|
float |
[en] Video streams (Prime Video). Amazon column: videoStreams. |
|
|
int |
[en] Video streams (Prime Video) (click attribution). Amazon column: videoStreamsClicks. |
|
|
float |
[en] Video streams (Prime Video) ÷ impressions (rate). Amazon column: videoStreamsRate. |
|
|
int |
[en] Video streams (Prime Video) (view attribution: ad seen, not clicked). Amazon column: videoStreamsViews. |
|
|
float |
[en] Viewability rate (viewable impressions ÷ measurable impressions). Amazon column: viewabilityRate. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Account (advertiser) id on Amazon. Amazon field: accountInfo__id. |
|
|
text |
[en] Account marketplace id. Amazon field: accountInfo__marketplaceStringId. |
|
|
text |
[en] Account name. Amazon field: accountInfo__name. |
|
|
text |
[en] Account subtype. Amazon field: accountInfo__subType. |
|
|
text |
[en] Account type: seller, vendor or agency (DSP). Amazon field: accountInfo__type. |
|
|
boolean |
[en] true = the account has a valid payment method. Amazon field: accountInfo__validPaymentMethod. |
|
|
text |
[en] Marketplace country (e.g. BR, US). Amazon field: countryCode. |
|
|
text |
[en] Currency. Amazon field: currencyCode. |
|
|
float |
[en] Daily budget. Amazon field: dailyBudget. |
|
|
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.
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the DSP advertiser (text). Amazon field: advertiserId. |
|
|
text |
[en] Country. Amazon field: country. |
|
|
text |
[en] Currency. Amazon field: currency. |
|
|
boolean |
[en] true = regional account. Amazon field: isRegional. |
|
|
text |
[en] Name. Amazon field: name. |
|
|
text |
[en] Account time zone. Amazon field: timezone. |
|
|
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.
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.
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the ad group (text). Amazon field: adGroupId. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
text |
[en] Name. Amazon field: name. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
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). |
|
|
text |
[en] Id of the ad group (text). Amazon field: adGroupId. |
|
|
text |
[en] Id of the ad (text). Amazon field: adId. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
text |
[en] Creative: ASINs shown in the ad. Amazon field: creative__asins. List/object stored as JSON. |
|
|
text |
[en] Creative: brand logo asset id. Amazon field: creative__brandLogoAssetID. |
|
|
int |
[en] Creative: brand logo crop, height. Amazon field: creative__brandLogoCrop__height. |
|
|
int |
[en] Creative: brand logo crop, left offset. Amazon field: creative__brandLogoCrop__left. |
|
|
int |
[en] Creative: brand logo crop, top offset. Amazon field: creative__brandLogoCrop__top. |
|
|
int |
[en] Creative: brand logo crop, width. Amazon field: creative__brandLogoCrop__width. |
|
|
text |
[en] Creative: brand logo URL. Amazon field: creative__brandLogoUrl. |
|
|
text |
[en] Creative: brand name shown. Amazon field: creative__brandName. |
|
|
text |
[en] Creative: product collection type. Amazon field: creative__collectionType. |
|
|
boolean |
[en] Creative: true = Amazon may translate the text. Amazon field: creative__consentToTranslate. |
|
|
text |
[en] Creative: properties Amazon may optimize. Amazon field: creative__creativePropertiesToOptimize. List/object stored as JSON. |
|
|
text |
[en] Creative: moderation status. Amazon field: creative__creativeStatus. |
|
|
text |
[en] Creative: version. Amazon field: creative__creativeVersion. |
|
|
text |
[en] Creative: custom image asset id. Amazon field: creative__customImageAssetId. |
|
|
int |
[en] Creative: custom image crop, height. Amazon field: creative__customImageCrop__height. |
|
|
int |
[en] Creative: custom image crop, left offset. Amazon field: creative__customImageCrop__left. |
|
|
int |
[en] Creative: custom image crop, top offset. Amazon field: creative__customImageCrop__top. |
|
|
int |
[en] Creative: custom image crop, width. Amazon field: creative__customImageCrop__width. |
|
|
text |
[en] Creative: custom image URL. Amazon field: creative__customImageUrl. |
|
|
text |
[en] Creative: custom images. Amazon field: creative__customImages. List/object stored as JSON. |
|
|
text |
[en] Creative: ad headline. Amazon field: creative__headline. |
|
|
text |
[en] Creative: ad headlines. Amazon field: creative__headlines. List/object stored as JSON. |
|
|
text |
[en] Creative: original headline, before translation. Amazon field: creative__originalHeadline. |
|
|
text |
[en] Creative: original headlines, before translation. Amazon field: creative__originalHeadlines. List/object stored as JSON. |
|
|
text |
[en] Creative: original video asset ids. Amazon field: creative__originalVideoAssetIds. List/object stored as JSON. |
|
|
text |
[en] Creative: Brand Store subpages. Amazon field: creative__subpages. List/object stored as JSON. |
|
|
text |
[en] Creative: format (product collection, store spotlight, video). Amazon field: creative__type. |
|
|
text |
[en] Creative: video asset ids. Amazon field: creative__videoAssetIds. List/object stored as JSON. |
|
|
int |
[en] Creation date. Amazon field: extendedData__creationDate. |
|
|
int |
[en] Last update date. Amazon field: extendedData__lastUpdateDate. |
|
|
text |
[en] Serving status. Amazon field: extendedData__servingStatus. |
|
|
text |
[en] Serving status details. Amazon field: extendedData__servingStatusDetails. List/object stored as JSON. |
|
|
text |
[en] Landing page type. Amazon field: landingPage__pageType. |
|
|
text |
[en] Landing page URL. Amazon field: landingPage__url. |
|
|
text |
[en] Name. Amazon field: name. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
text |
[en] Bid adjustments by placement (top of search, product page). Amazon field: bidding__bidAdjustmentsByPlacement. List/object stored as JSON. |
|
|
boolean |
[en] Bid optimization. Amazon field: bidding__bidOptimization. |
|
|
text |
[en] Bid optimization strategy. Amazon field: bidding__bidOptimizationStrategy. |
|
|
text |
[en] Bid adjustments by shopper cohort. Amazon field: bidding__shopperCohortBidAdjustments. List/object stored as JSON. |
|
|
float |
[en] Budget. Amazon field: budget. |
|
|
text |
[en] Budget type (daily, lifetime). Amazon field: budgetType. |
|
|
text |
[en] Billing model (e.g. CPC, vCPM). Amazon field: costType. |
|
|
text |
[en] End date. Amazon field: endDate. |
|
|
text |
[en] Campaign goal. Amazon field: goal. |
|
|
boolean |
[en] true = campaign with multiple ad groups. Amazon field: isMultiAdGroupsEnabled. |
|
|
text |
[en] Goal key performance indicator. Amazon field: kpi. |
|
|
text |
[en] Name. Amazon field: name. |
|
|
text |
[en] Id of the portfolio (text). Amazon field: portfolioId. |
|
|
text |
[en] Where the products are sold. Amazon field: productLocation. |
|
|
text |
[en] Default automatic targets. Amazon field: smartDefault. List/object stored as JSON. |
|
|
text |
[en] Start date. Amazon field: startDate. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the keyword (text). Amazon field: keywordId. |
|
|
text |
[en] Id of the ad group (text). Amazon field: adGroupId. |
|
|
float |
[en] Bid. Amazon field: bid. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
text |
[en] Keyword text. Amazon field: keywordText. |
|
|
text |
[en] Match type (exact, phrase, broad). Amazon field: matchType. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the ad group (text). Amazon field: adGroupId. |
|
|
text |
[en] Automatic bid optimization. Amazon field: bidOptimization. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
text |
[en] Creative type. Amazon field: creativeType. |
|
|
float |
[en] Ad group default bid. Amazon field: defaultBid. |
|
|
text |
[en] Name. Amazon field: name. |
|
|
text |
[en] State set by the advertiser (enabled, paused, archived). Amazon field: state. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
float |
[en] Budget. Amazon field: budget. |
|
|
text |
[en] Budget type (daily, lifetime). Amazon field: budgetType. |
|
|
text |
[en] Billing model (e.g. CPC, vCPM). Amazon field: costType. |
|
|
text |
[en] Delivery profile (pacing). Amazon field: deliveryProfile. |
|
|
text |
[en] End date. Amazon field: endDate. |
|
|
text |
[en] Name. Amazon field: name. |
|
|
text |
[en] Id of the portfolio (text). Amazon field: portfolioId. |
|
|
boolean |
[en] true = budget rule being processed. Amazon field: ruleBasedBudget__isProcessing. |
|
|
text |
[en] Start date. Amazon field: startDate. |
|
|
text |
[en] State set by the advertiser (enabled, paused, archived). Amazon field: state. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the ad (text). Amazon field: adId. |
|
|
text |
[en] Id of the ad group (text). Amazon field: adGroupId. |
|
|
text |
[en] Advertised product ASIN. Amazon field: asin. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the target (text). Amazon field: targetId. |
|
|
text |
[en] Id of the ad group (text). Amazon field: adGroupId. |
|
|
float |
[en] Bid. Amazon field: bid. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
text |
[en] Targeting expression. Amazon field: expression. List/object stored as JSON. |
|
|
text |
[en] Expression type (manual or auto). Amazon field: expressionType. |
|
|
text |
[en] Targeting expression as resolved by Amazon. Amazon field: resolvedExpression. List/object stored as JSON. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the ad group (text). Amazon field: adGroupId. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
float |
[en] Ad group default bid. Amazon field: defaultBid. |
|
|
text |
[en] Name. Amazon field: name. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the keyword (text). Amazon field: keywordId. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
text |
[en] Keyword text. Amazon field: keywordText. |
|
|
text |
[en] Match type (exact, phrase, broad). Amazon field: matchType. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
float |
[en] Budget amount. Amazon field: budget__budget. |
|
|
text |
[en] Budget type (daily, lifetime). Amazon field: budget__budgetType. |
|
|
text |
[en] Bid adjustments by placement. Amazon field: dynamicBidding__placementBidding. List/object stored as JSON. |
|
|
text |
[en] Bid adjustments by shopper cohort. Amazon field: dynamicBidding__shopperCohortBidding. List/object stored as JSON. |
|
|
text |
[en] Dynamic bidding strategy (down only, up and down, fixed). Amazon field: dynamicBidding__strategy. |
|
|
text |
[en] End date. Amazon field: endDate. |
|
|
text |
[en] Budget allocation across marketplaces. Amazon field: marketplaceBudgetAllocation. |
|
|
text |
[en] Name. Amazon field: name. |
|
|
text |
[en] Off-Amazon delivery settings. Amazon field: offAmazonSettings. List/object stored as JSON. |
|
|
text |
[en] Id of the portfolio (text). Amazon field: portfolioId. |
|
|
text |
[en] Start date. Amazon field: startDate. |
|
|
text |
[en] State set by the advertiser (enabled, paused, archived). Amazon field: state. |
|
|
text |
[en] Tags. Amazon field: tags. List/object stored as JSON. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the keyword (text). Amazon field: keywordId. |
|
|
text |
[en] Id of the ad group (text). Amazon field: adGroupId. |
|
|
float |
[en] Bid. Amazon field: bid. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
text |
[en] Keyword text. Amazon field: keywordText. |
|
|
text |
[en] Match type (exact, phrase, broad). Amazon field: matchType. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the keyword (text). Amazon field: keywordId. |
|
|
text |
[en] Id of the ad group (text). Amazon field: adGroupId. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
text |
[en] Keyword text. Amazon field: keywordText. |
|
|
text |
[en] Match type (exact, phrase, broad). Amazon field: matchType. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the target (text). Amazon field: targetId. |
|
|
text |
[en] Id of the ad group (text). Amazon field: adGroupId. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
text |
[en] Targeting expression. Amazon field: expression. List/object stored as JSON. |
|
|
text |
[en] Targeting expression as resolved by Amazon. Amazon field: resolvedExpression. List/object stored as JSON. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the ad (text). Amazon field: adId. |
|
|
text |
[en] Id of the ad group (text). Amazon field: adGroupId. |
|
|
text |
[en] Advertised product ASIN. Amazon field: asin. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the target (text). Amazon field: targetId. |
|
|
text |
[en] Id of the ad group (text). Amazon field: adGroupId. |
|
|
float |
[en] Bid. Amazon field: bid. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
text |
[en] Targeting expression. Amazon field: expression. List/object stored as JSON. |
|
|
text |
[en] Expression type (manual or auto). Amazon field: expressionType. |
|
|
text |
[en] Targeting expression as resolved by Amazon. Amazon field: resolvedExpression. List/object stored as JSON. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
text |
[en] Id of the campaign (text). Amazon field: campaignId. |
|
|
float |
[en] Budget amount. Amazon field: budget__budget. |
|
|
text |
[en] Budget type (daily, lifetime). Amazon field: budget__budgetType. |
|
|
text |
[en] Marketplace country (e.g. BR, US). Amazon field: countryCode. |
|
|
text |
[en] End date. Amazon field: endDate. |
|
|
text |
[en] Name. Amazon field: name. |
|
|
text |
[en] Id of the portfolio (text). Amazon field: portfolioId. |
|
|
text |
[en] Start date. Amazon field: startDate. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
date |
[en] Row day; for week/month, the first day of the period (account time zone). |
|
|
text |
[en] Advertising account (profile) name. |
|
|
text |
[en] Account marketplace country (e.g. BR, US). |
|
|
text |
[en] Currency in which the row's cost and sales are expressed. |
|
|
text |
[en] Id of the ad group (text). Amazon column: adGroupId. |
|
|
text |
[en] Name of the ad group. Amazon column: adGroupName. |
|
|
text |
[en] Id of the ad (text). Amazon column: adId. |
|
|
text |
[en] Keyword/ad status. Amazon column: adKeywordStatus. |
|
|
text |
[en] Status of the ad. Amazon column: adStatus. |
|
|
int |
[en] Add-to-cart events. Amazon column: addToCart. |
|
|
int |
[en] Add-to-cart events (click attribution). Amazon column: addToCartClicks. |
|
|
float |
[en] Add-to-cart events ÷ impressions (rate). Amazon column: addToCartRate. |
|
|
int |
[en] Add-to-list events. Amazon column: addToList. |
|
|
int |
[en] Add-to-list events (click attribution). Amazon column: addToListFromClicks. |
|
|
text |
[en] Row attribution type (e.g. promoted vs brand halo). Amazon column: attributionType. |
|
|
int |
[en] Brand Store page views. Amazon column: brandStorePageView. |
|
|
int |
[en] Branded searches on Amazon. Amazon column: brandedSearches. |
|
|
int |
[en] Branded searches on Amazon (click attribution). Amazon column: brandedSearchesClicks. |
|
|
text |
[en] Budget currency. Amazon column: budgetCurrency. |
|
|
float |
[en] Campaign budget. Amazon column: campaignBudgetAmount. |
|
|
text |
[en] Campaign budget currency. Amazon column: campaignBudgetCurrencyCode. |
|
|
text |
[en] Campaign budget type (daily, lifetime). Amazon column: campaignBudgetType. |
|
|
text |
[en] Id of the campaign (text). Amazon column: campaignId. |
|
|
text |
[en] Name of the campaign. Amazon column: campaignName. |
|
|
text |
[en] Campaign price type. Amazon column: campaignPriceTypeCode. |
|
|
text |
[en] Budget resulting from the budget rule. Amazon column: campaignRuleBasedBudgetAmount. |
|
|
text |
[en] Status of the campaign. Amazon column: campaignStatus. |
|
|
int |
[en] Clicks on the ad. Amazon column: clicks. |
|
|
float |
[en] Cost (spend) in the period, in the account currency. Amazon column: cost. |
|
|
text |
[en] Billing model (e.g. CPC, vCPM). Amazon column: costType. |
|
|
int |
[en] Product detail page views. Amazon column: detailPageViews. |
|
|
int |
[en] Product detail page views (click attribution). Amazon column: detailPageViewsClicks. |
|
|
float |
[en] Effective cost: cost ÷ add-to-cart events. Amazon column: eCPAddToCart. |
|
|
int |
[en] Gross clicks, before filtering invalid traffic. Amazon column: grossClickThroughs. |
|
|
int |
[en] Gross impressions, before filtering invalid traffic. Amazon column: grossImpressions. |
|
|
int |
[en] Impressions: times the ad was shown. Amazon column: impressions. |
|
|
float |
[en] Invalid clicks ÷ gross clicks. Amazon column: invalidClickThroughRate. |
|
|
int |
[en] Clicks discarded as invalid traffic (not billed). Amazon column: invalidClickThroughs. |
|
|
float |
[en] Invalid impressions ÷ gross impressions. Amazon column: invalidImpressionRate. |
|
|
int |
[en] Impressions discarded as invalid traffic (not billed). Amazon column: invalidImpressions. |
|
|
float |
[en] Keyword bid. Amazon column: keywordBid. |
|
|
text |
[en] Id of the keyword (text). Amazon column: keywordId. |
|
|
text |
[en] Keyword text. Amazon column: keywordText. |
|
|
text |
[en] Targeting type (keyword or product). Amazon column: keywordType. |
|
|
int |
[en] Kindle Unlimited pages read (KENP) (14-day attribution window). Amazon column: kindleEditionNormalizedPagesRead14d. |
|
|
float |
[en] Estimated royalties of Kindle Unlimited pages read (KENP) (14-day attribution window). Amazon column: kindleEditionNormalizedPagesRoyalties14d. |
|
|
float |
[en] Long-term ROAS: long-term sales ÷ cost. Amazon column: longTermROAS. |
|
|
float |
[en] Long-term sales: sales attributed within 12 months (Sponsored Brands). Amazon column: longTermSales. |
|
|
text |
[en] Match type (exact, phrase, broad; or product). Amazon column: matchType. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
int |
[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandPurchases. |
|
|
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. |
|
|
int |
[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandPurchasesClicks. |
|
|
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. |
|
|
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. |
|
|
float |
[en] Purchases (from new-to-brand customers, with no purchase from the brand in the last 12 months) ÷ impressions (rate). Amazon column: newToBrandPurchasesRate. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
int |
[en] Units sold from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandUnitsSold. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
int |
[en] Orders (14-day attribution window). Amazon column: orders14d. |
|
|
int |
[en] Orders (click attribution) (14-day attribution window). Amazon column: ordersClicks14d. |
|
|
text |
[en] Ad placement (top of search, rest of search, product page). Amazon column: placementClassification. |
|
|
text |
[en] Product category. Amazon column: productCategory. |
|
|
text |
[en] Product name. Amazon column: productName. |
|
|
text |
[en] ASIN of the purchased product (may differ from the advertised one). Amazon column: purchasedAsin. |
|
|
int |
[en] Purchases. Amazon column: purchases. |
|
|
int |
[en] Purchases (click attribution). Amazon column: purchasesClicks. |
|
|
int |
[en] Purchases of the advertised product. Amazon column: purchasesPromoted. |
|
|
int |
[en] Qualified e-book borrows. Amazon column: qualifiedBorrows. |
|
|
int |
[en] Qualified e-book borrows (click attribution). Amazon column: qualifiedBorrowsFromClicks. |
|
|
float |
[en] Royalty-qualified e-book borrows. Amazon column: royaltyQualifiedBorrows. |
|
|
float |
[en] Royalty-qualified e-book borrows (click attribution). Amazon column: royaltyQualifiedBorrowsFromClicks. |
|
|
float |
[en] Sales (value, in the account currency). Amazon column: sales. |
|
|
float |
[en] Sales (value, in the account currency) (14-day attribution window). Amazon column: sales14d. |
|
|
float |
[en] Sales (value, in the account currency) (click attribution). Amazon column: salesClicks. |
|
|
float |
[en] Sales (value, in the account currency) (click attribution) (14-day attribution window). Amazon column: salesClicks14d. |
|
|
float |
[en] Sales (value, in the account currency) of the advertised product. Amazon column: salesPromoted. |
|
|
text |
[en] Term the shopper searched on Amazon that showed the ad. Amazon column: searchTerm. |
|
|
text |
[en] Targeting expression. Amazon column: targetingExpression. |
|
|
text |
[en] Id of the targeting (text). Amazon column: targetingId. |
|
|
text |
[en] Targeting text. Amazon column: targetingText. |
|
|
text |
[en] Targeting type. Amazon column: targetingType. |
|
|
float |
[en] Share of the possible top-of-search impressions the ad won. Amazon column: topOfSearchImpressionShare. |
|
|
int |
[en] Units sold. Amazon column: unitsSold. |
|
|
int |
[en] Units sold (14-day attribution window). Amazon column: unitsSold14d. |
|
|
int |
[en] Units sold (click attribution). Amazon column: unitsSoldClicks. |
|
|
int |
[en] Units sold (click attribution) (14-day attribution window). Amazon column: unitsSoldClicks14d. |
|
|
float |
[en] 5-second views ÷ impressions. Amazon column: video5SecondViewRate. |
|
|
int |
[en] Video views of at least 5 seconds. Amazon column: video5SecondViews. |
|
|
int |
[en] Video ad: complete plays. Amazon column: videoCompleteViews. |
|
|
int |
[en] Video ad: plays to 25%. Amazon column: videoFirstQuartileViews. |
|
|
int |
[en] Video ad: plays to 50%. Amazon column: videoMidpointViews. |
|
|
int |
[en] Video ad: plays to 75%. Amazon column: videoThirdQuartileViews. |
|
|
int |
[en] Video ad: unmutes. Amazon column: videoUnmutes. |
|
|
float |
[en] Clicks ÷ viewable impressions. Amazon column: viewClickThroughRate. |
|
|
float |
[en] Viewability rate (viewable impressions ÷ measurable impressions). Amazon column: viewabilityRate. |
|
|
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:
- profile_id → Metadata: Advertising accounts (profiles) > profile_id
- ad_group_id → Metadata: Sponsored Display - ad groups > ad_group_id
- ad_id → Metadata: Sponsored Display - product ads > ad_id
- campaign_id → Metadata: Sponsored Display - campaigns > campaign_id
- targeting_id → Metadata: Sponsored Display - targets > target_id
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
date |
[en] Row day; for week/month, the first day of the period (account time zone). |
|
|
text |
[en] Advertising account (profile) name. |
|
|
text |
[en] Account marketplace country (e.g. BR, US). |
|
|
text |
[en] Currency in which the row's cost and sales are expressed. |
|
|
text |
[en] Id of the ad group (text). Amazon column: adGroupId. |
|
|
text |
[en] Name of the ad group. Amazon column: adGroupName. |
|
|
text |
[en] Id of the ad (text). Amazon column: adId. |
|
|
text |
[en] Keyword/ad status. Amazon column: adKeywordStatus. |
|
|
text |
[en] Name of the ad. Amazon column: adName. |
|
|
int |
[en] Add-to-cart events. Amazon column: addToCart. |
|
|
int |
[en] Add-to-cart events (click attribution). Amazon column: addToCartClicks. |
|
|
float |
[en] Add-to-cart events ÷ impressions (rate). Amazon column: addToCartRate. |
|
|
int |
[en] Add-to-cart events (view attribution: ad seen, not clicked). Amazon column: addToCartViews. |
|
|
int |
[en] Add-to-list events. Amazon column: addToList. |
|
|
int |
[en] Add-to-list events (click attribution). Amazon column: addToListFromClicks. |
|
|
text |
[en] Add-to-list events (view attribution: ad seen, not clicked). Amazon column: addToListFromViews. |
|
|
text |
[en] ASIN of another product of the same brand (halo). Amazon column: asinBrandHalo. |
|
|
text |
[en] Bid optimization. Amazon column: bidOptimization. |
|
|
text |
[en] Branded searches ÷ impressions. Amazon column: brandedSearchRate. |
|
|
int |
[en] Branded searches on Amazon. Amazon column: brandedSearches. |
|
|
int |
[en] Branded searches on Amazon (click attribution). Amazon column: brandedSearchesClicks. |
|
|
text |
[en] Branded searches on Amazon (view attribution: ad seen, not clicked). Amazon column: brandedSearchesViews. |
|
|
float |
[en] Campaign budget. Amazon column: campaignBudgetAmount. |
|
|
text |
[en] Campaign budget currency. Amazon column: campaignBudgetCurrencyCode. |
|
|
text |
[en] Id of the campaign (text). Amazon column: campaignId. |
|
|
text |
[en] Name of the campaign. Amazon column: campaignName. |
|
|
text |
[en] Status of the campaign. Amazon column: campaignStatus. |
|
|
int |
[en] Clicks on the ad. Amazon column: clicks. |
|
|
text |
[en] Conversions of other products of the same brand, halo effect, not the advertised one. Amazon column: conversionsBrandHalo. |
|
|
text |
[en] Conversions of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: conversionsBrandHaloClicks. |
|
|
float |
[en] Cost (spend) in the period, in the account currency. Amazon column: cost. |
|
|
text |
[en] Billing model (e.g. CPC, vCPM). Amazon column: costType. |
|
|
text |
[en] Cumulative reach since the start of the order/line item. Amazon column: cumulativeReach. |
|
|
int |
[en] Product detail page views. Amazon column: detailPageViews. |
|
|
int |
[en] Product detail page views (click attribution). Amazon column: detailPageViewsClicks. |
|
|
float |
[en] Effective cost: cost ÷ add-to-cart events. Amazon column: eCPAddToCart. |
|
|
float |
[en] Effective cost: cost ÷ brand searches on Amazon. Amazon column: eCPBrandSearch. |
|
|
int |
[en] Gross clicks, before filtering invalid traffic. Amazon column: grossClickThroughs. |
|
|
int |
[en] Gross impressions, before filtering invalid traffic. Amazon column: grossImpressions. |
|
|
int |
[en] Impressions: times the ad was shown. Amazon column: impressions. |
|
|
text |
[en] Average frequency: impressions ÷ reach. Amazon column: impressionsFrequencyAverage. |
|
|
text |
[en] Viewable impressions. Amazon column: impressionsViews. |
|
|
float |
[en] Invalid clicks ÷ gross clicks. Amazon column: invalidClickThroughRate. |
|
|
int |
[en] Clicks discarded as invalid traffic (not billed). Amazon column: invalidClickThroughs. |
|
|
float |
[en] Invalid impressions ÷ gross impressions. Amazon column: invalidImpressionRate. |
|
|
int |
[en] Impressions discarded as invalid traffic (not billed). Amazon column: invalidImpressions. |
|
|
int |
[en] Kindle Unlimited pages read (KENP). Amazon column: kindleEditionNormalizedPagesRead. |
|
|
int |
[en] Kindle Unlimited pages read (KENP) (click attribution). Amazon column: kindleEditionNormalizedPagesReadFromClicks. |
|
|
int |
[en] Kindle Unlimited pages read (KENP) (view attribution: ad seen, not clicked). Amazon column: kindleEditionNormalizedPagesReadFromViews. |
|
|
text |
[en] Estimated royalties of Kindle Unlimited pages read (KENP). Amazon column: kindleEditionNormalizedPagesRoyalties. |
|
|
text |
[en] Estimated royalties of Kindle Unlimited pages read (KENP) (click attribution). Amazon column: kindleEditionNormalizedPagesRoyaltiesFromClicks. |
|
|
text |
[en] Estimated royalties of Kindle Unlimited pages read (KENP) (view attribution: ad seen, not clicked). Amazon column: kindleEditionNormalizedPagesRoyaltiesFromViews. |
|
|
text |
[en] Ad landing page URL. Amazon column: landingPageURL. |
|
|
text |
[en] Lead form opens. Amazon column: leadFormOpens. |
|
|
text |
[en] Leads. Amazon column: leads. |
|
|
text |
[en] Link-outs (clicks leaving Amazon). Amazon column: linkOuts. |
|
|
float |
[en] Long-term ROAS: long-term sales ÷ cost. Amazon column: longTermROAS. |
|
|
float |
[en] Long-term sales: sales attributed within 12 months (Sponsored Brands). Amazon column: longTermSales. |
|
|
text |
[en] ASIN of the target product the ad appeared on. Amazon column: matchedTargetAsin. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
int |
[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandPurchases. |
|
|
int |
[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandPurchasesClicks. |
|
|
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. |
|
|
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. |
|
|
int |
[en] Units sold from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandUnitsSold. |
|
|
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. |
|
|
text |
[en] Promoted product ASIN. Amazon column: promotedAsin. |
|
|
text |
[en] Promoted product SKU. Amazon column: promotedSku. |
|
|
int |
[en] Purchases. Amazon column: purchases. |
|
|
int |
[en] Purchases (click attribution). Amazon column: purchasesClicks. |
|
|
text |
[en] Purchases of the advertised product (click attribution). Amazon column: purchasesPromotedClicks. |
|
|
int |
[en] Qualified e-book borrows. Amazon column: qualifiedBorrows. |
|
|
int |
[en] Qualified e-book borrows (click attribution). Amazon column: qualifiedBorrowsFromClicks. |
|
|
int |
[en] Qualified e-book borrows (view attribution: ad seen, not clicked). Amazon column: qualifiedBorrowsFromViews. |
|
|
float |
[en] Royalty-qualified e-book borrows. Amazon column: royaltyQualifiedBorrows. |
|
|
float |
[en] Royalty-qualified e-book borrows (click attribution). Amazon column: royaltyQualifiedBorrowsFromClicks. |
|
|
float |
[en] Royalty-qualified e-book borrows (view attribution: ad seen, not clicked). Amazon column: royaltyQualifiedBorrowsFromViews. |
|
|
float |
[en] Sales (value, in the account currency). Amazon column: sales. |
|
|
float |
[en] Sales (value, in the account currency) of other products of the same brand, halo effect, not the advertised one. Amazon column: salesBrandHalo. |
|
|
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. |
|
|
float |
[en] Sales (value, in the account currency) (click attribution). Amazon column: salesClicks. |
|
|
float |
[en] Sales (value, in the account currency) of the advertised product (click attribution). Amazon column: salesPromotedClicks. |
|
|
text |
[en] Targeting expression. Amazon column: targetingExpression. |
|
|
text |
[en] Id of the targeting (text). Amazon column: targetingId. |
|
|
text |
[en] Targeting text. Amazon column: targetingText. |
|
|
int |
[en] Units sold. Amazon column: unitsSold. |
|
|
int |
[en] Units sold of other products of the same brand, halo effect, not the advertised one. Amazon column: unitsSoldBrandHalo. |
|
|
text |
[en] Units sold of other products of the same brand, halo effect, not the advertised one (click attribution). Amazon column: unitsSoldBrandHaloClicks. |
|
|
int |
[en] Units sold (click attribution). Amazon column: unitsSoldClicks. |
|
|
int |
[en] Video ad: complete plays. Amazon column: videoCompleteViews. |
|
|
int |
[en] Video ad: plays to 25%. Amazon column: videoFirstQuartileViews. |
|
|
int |
[en] Video ad: plays to 50%. Amazon column: videoMidpointViews. |
|
|
int |
[en] Video ad: plays to 75%. Amazon column: videoThirdQuartileViews. |
|
|
int |
[en] Video ad: unmutes. Amazon column: videoUnmutes. |
|
|
float |
[en] Clicks ÷ viewable impressions. Amazon column: viewClickThroughRate. |
|
|
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:
- profile_id → Metadata: Advertising accounts (profiles) > profile_id
- ad_group_id → Metadata: Sponsored Products - ad groups > ad_group_id
- ad_id → Metadata: Sponsored Products - product ads > ad_id
- campaign_id → Metadata: Sponsored Products - campaigns > campaign_id
- keyword_id → Metadata: Sponsored Products - keywords > keyword_id
- portfolio_id → Metadata: Portfolios > portfolio_id
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
date |
[en] Row day; for week/month, the first day of the period (account time zone). |
|
|
text |
[en] Advertising account (profile) name. |
|
|
text |
[en] Account marketplace country (e.g. BR, US). |
|
|
text |
[en] Currency in which the row's cost and sales are expressed. |
|
|
float |
[en] ACOS: cost ÷ sales attributed to clicks within 14 days (the inverse of ROAS). Amazon column: acosClicks14d. |
|
|
float |
[en] ACOS: cost ÷ sales attributed to clicks within 7 days (the inverse of ROAS). Amazon column: acosClicks7d. |
|
|
text |
[en] Id of the ad group (text). Amazon column: adGroupId. |
|
|
text |
[en] Name of the ad group. Amazon column: adGroupName. |
|
|
text |
[en] Id of the ad (text). Amazon column: adId. |
|
|
text |
[en] Keyword/ad status. Amazon column: adKeywordStatus. |
|
|
text |
[en] Status of the ad. Amazon column: adStatus. |
|
|
int |
[en] Add-to-list events. Amazon column: addToList. |
|
|
text |
[en] ASIN of the advertised product. Amazon column: advertisedAsin. |
|
|
text |
[en] SKU of the advertised product. Amazon column: advertisedSku. |
|
|
float |
[en] Sales (value, in the account currency) of the advertised SKU itself (14-day attribution window). Amazon column: attributedSalesSameSku14d. |
|
|
float |
[en] Sales (value, in the account currency) of the advertised SKU itself (1-day attribution window). Amazon column: attributedSalesSameSku1d. |
|
|
float |
[en] Sales (value, in the account currency) of the advertised SKU itself (30-day attribution window). Amazon column: attributedSalesSameSku30d. |
|
|
float |
[en] Sales (value, in the account currency) of the advertised SKU itself (7-day attribution window). Amazon column: attributedSalesSameSku7d. |
|
|
text |
[en] Applied budget rule id. Amazon column: campaignApplicableBudgetRuleId. |
|
|
text |
[en] Applied budget rule name. Amazon column: campaignApplicableBudgetRuleName. |
|
|
text |
[en] Campaign bidding strategy. Amazon column: campaignBiddingStrategy. |
|
|
float |
[en] Campaign budget. Amazon column: campaignBudgetAmount. |
|
|
text |
[en] Campaign budget currency. Amazon column: campaignBudgetCurrencyCode. |
|
|
text |
[en] Campaign budget type (daily, lifetime). Amazon column: campaignBudgetType. |
|
|
text |
[en] Id of the campaign (text). Amazon column: campaignId. |
|
|
text |
[en] Name of the campaign. Amazon column: campaignName. |
|
|
text |
[en] Budget resulting from the budget rule. Amazon column: campaignRuleBasedBudgetAmount. |
|
|
text |
[en] Status of the campaign. Amazon column: campaignStatus. |
|
|
float |
[en] Click-through rate (CTR = clicks ÷ impressions). Amazon column: clickThroughRate. |
|
|
int |
[en] Clicks on the ad. Amazon column: clicks. |
|
|
float |
[en] Cost (spend) in the period, in the account currency. Amazon column: cost. |
|
|
float |
[en] Cost per click (CPC = cost ÷ clicks). Amazon column: costPerClick. |
|
|
int |
[en] Gross clicks, before filtering invalid traffic. Amazon column: grossClickThroughs. |
|
|
int |
[en] Gross impressions, before filtering invalid traffic. Amazon column: grossImpressions. |
|
|
int |
[en] Impressions: times the ad was shown. Amazon column: impressions. |
|
|
float |
[en] Invalid clicks ÷ gross clicks. Amazon column: invalidClickThroughRate. |
|
|
int |
[en] Clicks discarded as invalid traffic (not billed). Amazon column: invalidClickThroughs. |
|
|
float |
[en] Invalid impressions ÷ gross impressions. Amazon column: invalidImpressionRate. |
|
|
int |
[en] Impressions discarded as invalid traffic (not billed). Amazon column: invalidImpressions. |
|
|
text |
[en] Keyword or targeting expression. Amazon column: keyword. |
|
|
float |
[en] Keyword bid. Amazon column: keywordBid. |
|
|
text |
[en] Id of the keyword (text). Amazon column: keywordId. |
|
|
text |
[en] Targeting type (keyword or product). Amazon column: keywordType. |
|
|
int |
[en] Kindle Unlimited pages read (KENP) (14-day attribution window). Amazon column: kindleEditionNormalizedPagesRead14d. |
|
|
float |
[en] Estimated royalties of Kindle Unlimited pages read (KENP) (14-day attribution window). Amazon column: kindleEditionNormalizedPagesRoyalties14d. |
|
|
text |
[en] Marketplace id. Amazon column: marketplaceId. |
|
|
text |
[en] Match type (exact, phrase, broad; or product). Amazon column: matchType. |
|
|
text |
[en] Ad placement (top of search, rest of search, product page). Amazon column: placementClassification. |
|
|
text |
[en] Id of the portfolio (text). Amazon column: portfolioId. |
|
|
float |
[en] Purchases within 14 days ÷ clicks (conversion rate). Amazon column: purchaseClickRate14d. |
|
|
text |
[en] ASIN of the purchased product (may differ from the advertised one). Amazon column: purchasedAsin. |
|
|
int |
[en] Purchases (14-day attribution window). Amazon column: purchases14d. |
|
|
int |
[en] Purchases (1-day attribution window). Amazon column: purchases1d. |
|
|
int |
[en] Purchases (30-day attribution window). Amazon column: purchases30d. |
|
|
int |
[en] Purchases (7-day attribution window). Amazon column: purchases7d. |
|
|
int |
[en] Purchases of other SKUs, not the advertised one (14-day attribution window). Amazon column: purchasesOtherSku14d. |
|
|
int |
[en] Purchases of other SKUs, not the advertised one (1-day attribution window). Amazon column: purchasesOtherSku1d. |
|
|
int |
[en] Purchases of other SKUs, not the advertised one (30-day attribution window). Amazon column: purchasesOtherSku30d. |
|
|
int |
[en] Purchases of other SKUs, not the advertised one (7-day attribution window). Amazon column: purchasesOtherSku7d. |
|
|
int |
[en] Purchases of the advertised SKU itself (14-day attribution window). Amazon column: purchasesSameSku14d. |
|
|
int |
[en] Purchases of the advertised SKU itself (1-day attribution window). Amazon column: purchasesSameSku1d. |
|
|
int |
[en] Purchases of the advertised SKU itself (30-day attribution window). Amazon column: purchasesSameSku30d. |
|
|
int |
[en] Purchases of the advertised SKU itself (7-day attribution window). Amazon column: purchasesSameSku7d. |
|
|
int |
[en] Qualified e-book borrows. Amazon column: qualifiedBorrows. |
|
|
text |
[en] Retailer. Amazon column: retailer. |
|
|
float |
[en] ROAS: sales attributed to clicks within 14 days ÷ cost. Amazon column: roasClicks14d. |
|
|
float |
[en] ROAS: sales attributed to clicks within 7 days ÷ cost. Amazon column: roasClicks7d. |
|
|
float |
[en] Royalty-qualified e-book borrows. Amazon column: royaltyQualifiedBorrows. |
|
|
float |
[en] Sales (value, in the account currency) (14-day attribution window). Amazon column: sales14d. |
|
|
float |
[en] Sales (value, in the account currency) (1-day attribution window). Amazon column: sales1d. |
|
|
float |
[en] Sales (value, in the account currency) (30-day attribution window). Amazon column: sales30d. |
|
|
float |
[en] Sales (value, in the account currency) (7-day attribution window). Amazon column: sales7d. |
|
|
float |
[en] Sales (value, in the account currency) of other SKUs, not the advertised one (14-day attribution window). Amazon column: salesOtherSku14d. |
|
|
float |
[en] Sales (value, in the account currency) of other SKUs, not the advertised one (1-day attribution window). Amazon column: salesOtherSku1d. |
|
|
float |
[en] Sales (value, in the account currency) of other SKUs, not the advertised one (30-day attribution window). Amazon column: salesOtherSku30d. |
|
|
float |
[en] Sales (value, in the account currency) of other SKUs, not the advertised one (7-day attribution window). Amazon column: salesOtherSku7d. |
|
|
text |
[en] Term the shopper searched on Amazon that showed the ad. Amazon column: searchTerm. |
|
|
float |
[en] Cost (spend) in the period, in the account currency. Amazon column: spend. |
|
|
text |
[en] Id of the target (text). Amazon column: targetId. |
|
|
text |
[en] Targeting expression (keyword, product or audience). Amazon column: targeting. |
|
|
text |
[en] Targeting expression. Amazon column: targetingExpression. |
|
|
float |
[en] Share of the possible top-of-search impressions the ad won. Amazon column: topOfSearchImpressionShare. |
|
|
int |
[en] Units sold (click attribution) (14-day attribution window). Amazon column: unitsSoldClicks14d. |
|
|
int |
[en] Units sold (click attribution) (1-day attribution window). Amazon column: unitsSoldClicks1d. |
|
|
int |
[en] Units sold (click attribution) (30-day attribution window). Amazon column: unitsSoldClicks30d. |
|
|
int |
[en] Units sold (click attribution) (7-day attribution window). Amazon column: unitsSoldClicks7d. |
|
|
int |
[en] Units sold of other SKUs, not the advertised one (14-day attribution window). Amazon column: unitsSoldOtherSku14d. |
|
|
int |
[en] Units sold of other SKUs, not the advertised one (1-day attribution window). Amazon column: unitsSoldOtherSku1d. |
|
|
int |
[en] Units sold of other SKUs, not the advertised one (30-day attribution window). Amazon column: unitsSoldOtherSku30d. |
|
|
int |
[en] Units sold of other SKUs, not the advertised one (7-day attribution window). Amazon column: unitsSoldOtherSku7d. |
|
|
int |
[en] Units sold of the advertised SKU itself (14-day attribution window). Amazon column: unitsSoldSameSku14d. |
|
|
int |
[en] Units sold of the advertised SKU itself (1-day attribution window). Amazon column: unitsSoldSameSku1d. |
|
|
int |
[en] Units sold of the advertised SKU itself (30-day attribution window). Amazon column: unitsSoldSameSku30d. |
|
|
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 | |
|---|---|---|
|
text |
[en] Id of the advertising account (profile) the row came from. |
|
|
date |
[en] Row day; for week/month, the first day of the period (account time zone). |
|
|
text |
[en] Advertising account (profile) name. |
|
|
text |
[en] Account marketplace country (e.g. BR, US). |
|
|
text |
[en] Currency in which the row's cost and sales are expressed. |
|
|
text |
[en] Id of the ad group (text). Amazon column: adGroupId. |
|
|
text |
[en] Name of the ad group. Amazon column: adGroupName. |
|
|
text |
[en] Keyword/ad status. Amazon column: adKeywordStatus. |
|
|
text |
[en] Status of the ad. Amazon column: adStatus. |
|
|
int |
[en] Add-to-cart events. Amazon column: addToCart. |
|
|
int |
[en] Add-to-cart events (click attribution). Amazon column: addToCartClicks. |
|
|
int |
[en] Add-to-cart events (view attribution: ad seen, not clicked). Amazon column: addToCartViews. |
|
|
int |
[en] Branded searches on Amazon. Amazon column: brandedSearches. |
|
|
int |
[en] Branded searches on Amazon (click attribution). Amazon column: brandedSearchesClicks. |
|
|
text |
[en] Branded searches on Amazon (view attribution: ad seen, not clicked). Amazon column: brandedSearchesViews. |
|
|
float |
[en] Campaign budget. Amazon column: campaignBudgetAmount. |
|
|
text |
[en] Campaign budget currency. Amazon column: campaignBudgetCurrencyCode. |
|
|
text |
[en] Campaign budget type (daily, lifetime). Amazon column: campaignBudgetType. |
|
|
text |
[en] Id of the campaign (text). Amazon column: campaignId. |
|
|
text |
[en] Name of the campaign. Amazon column: campaignName. |
|
|
text |
[en] Status of the campaign. Amazon column: campaignStatus. |
|
|
float |
[en] Click-through rate (CTR = clicks ÷ impressions). Amazon column: clickThroughRate. |
|
|
int |
[en] Clicks on the ad. Amazon column: clicks. |
|
|
float |
[en] Cost (spend) in the period, in the account currency. Amazon column: cost. |
|
|
text |
[en] Cost per thousand impressions (CPM = cost ÷ impressions × 1000). Amazon column: costPerThousandImpressions. |
|
|
int |
[en] Product detail page views. Amazon column: detailPageViews. |
|
|
int |
[en] Product detail page views (click attribution). Amazon column: detailPageViewsClicks. |
|
|
text |
[en] Product detail page views (view attribution: ad seen, not clicked). Amazon column: detailPageViewsViews. |
|
|
float |
[en] Average frequency: impressions ÷ reach. Amazon column: frequencyAverage. |
|
|
float |
[en] Average frequency per household. Amazon column: householdFrequencyAverage. |
|
|
int |
[en] Unique households reached. Amazon column: householdReach. |
|
|
int |
[en] Impressions: times the ad was shown. Amazon column: impressions. |
|
|
text |
[en] Keyword or targeting expression. Amazon column: keyword. |
|
|
float |
[en] Keyword bid. Amazon column: keywordBid. |
|
|
text |
[en] Id of the keyword (text). Amazon column: keywordId. |
|
|
text |
[en] Targeting type (keyword or product). Amazon column: keywordType. |
|
|
float |
[en] Long-term ROAS: long-term sales ÷ cost. Amazon column: longTermROAS. |
|
|
float |
[en] Long-term sales: sales attributed within 12 months (Sponsored Brands). Amazon column: longTermSales. |
|
|
text |
[en] Match type (exact, phrase, broad; or product). Amazon column: matchType. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
int |
[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months. Amazon column: newToBrandPurchases. |
|
|
int |
[en] Purchases from new-to-brand customers, with no purchase from the brand in the last 12 months (click attribution). Amazon column: newToBrandPurchasesClicks. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
text |
[en] Add-to-cart events off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonAddToCart. |
|
|
text |
[en] Add-to-cart events off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonAddToCartClicks. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
text |
[en] Average value reported on application conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonApplicationValueAverage. |
|
|
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. |
|
|
text |
[en] Application conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonApplications. |
|
|
text |
[en] Application conversions off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonApplicationsClicks. |
|
|
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. |
|
|
text |
[en] Checkout conversions off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonCheckoutClicks. |
|
|
text |
[en] Average value reported on checkout conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonCheckoutValueAverage. |
|
|
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. |
|
|
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. |
|
|
text |
[en] Checkout conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonCheckouts. |
|
|
int |
[en] Off-Amazon conversions attributed to clicks. Amazon column: offAmazonClicks. |
|
|
text |
[en] Contact conversions off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonContactClicks. |
|
|
text |
[en] Average value reported on contact conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonContactValueAverage. |
|
|
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. |
|
|
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. |
|
|
text |
[en] Contact conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonContacts. |
|
|
int |
[en] Conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonConversions. |
|
|
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. |
|
|
text |
[en] Average value reported on leads (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonLeadValueAverage. |
|
|
text |
[en] Sum of the value reported on leads (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonLeadValueSum. |
|
|
text |
[en] Leads off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonLeads. |
|
|
text |
[en] Leads off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonLeadsClicks. |
|
|
text |
[en] Leads off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonLeadsViews. |
|
|
text |
[en] "other" conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonOther. |
|
|
text |
[en] "other" conversions off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonOtherClicks. |
|
|
text |
[en] Average value reported on "other" conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonOtherValueAverage. |
|
|
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. |
|
|
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. |
|
|
text |
[en] Page views off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonPageViewClicks. |
|
|
text |
[en] Average value reported on page views (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonPageViewValueAverage. |
|
|
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. |
|
|
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. |
|
|
text |
[en] Page views off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonPageViews. |
|
|
float |
[en] Sales (value, in the account currency) off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonProductSales. |
|
|
int |
[en] Purchases off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonPurchases. |
|
|
int |
[en] Purchases off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonPurchasesClicks. |
|
|
int |
[en] Purchases off Amazon, on the advertiser site/app, measured by the conversion tag (view attribution: ad seen, not clicked). Amazon column: offAmazonPurchasesViews. |
|
|
float |
[en] ROAS: sales (off Amazon, on the advertiser site/app, measured by the conversion tag) ÷ cost. Amazon column: offAmazonROAS. |
|
|
text |
[en] Search conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonSearch. |
|
|
text |
[en] Search conversions off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonSearchClicks. |
|
|
text |
[en] Average value reported on search conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonSearchValueAverage. |
|
|
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. |
|
|
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. |
|
|
text |
[en] Sign-ups off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonSignUp. |
|
|
text |
[en] Sign-ups off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonSignUpClicks. |
|
|
text |
[en] Average value reported on sign-ups (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonSignUpValueAverage. |
|
|
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. |
|
|
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. |
|
|
text |
[en] Subscribe conversions off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonSubscribe. |
|
|
text |
[en] Subscribe conversions off Amazon, on the advertiser site/app, measured by the conversion tag (click attribution). Amazon column: offAmazonSubscribeClicks. |
|
|
text |
[en] Average value reported on subscribe conversions (off Amazon, on the advertiser site/app, measured by the conversion tag). Amazon column: offAmazonSubscribeValueAverage. |
|
|
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. |
|
|
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. |
|
|
int |
[en] Units sold off Amazon, on the advertiser site/app, measured by the conversion tag. Amazon column: offAmazonUnitsSold. |
|
|
int |
[en] Off-Amazon conversions attributed to views (ad seen, not clicked). Amazon column: offAmazonViews. |
|
|
text |
[en] Id of the portfolio (text). Amazon column: portfolioId. |
|
|
int |
[en] Purchases. Amazon column: purchases. |
|
|
int |
[en] Purchases (click attribution). Amazon column: purchasesClicks. |
|
|
int |
[en] Purchases (view attribution: ad seen, not clicked). Amazon column: purchasesViews. |
|
|
int |
[en] Reach: unique people who saw the ad in the period (not additive across days). Amazon column: reach. |
|
|
text |
[en] ROAS: attributed sales ÷ cost. Amazon column: roas. |
|
|
float |
[en] Sales (value, in the account currency). Amazon column: sales. |
|
|
float |
[en] Sales (value, in the account currency) (click attribution). Amazon column: salesClicks. |
|
|
text |
[en] Sales (value, in the account currency) (view attribution: ad seen, not clicked). Amazon column: salesViews. |
|
|
text |
[en] Targeting text. Amazon column: targetingText. |
|
|
int |
[en] Units sold. Amazon column: unitsSold. |
|
|
int |
[en] Units sold (click attribution). Amazon column: unitsSoldClicks. |
|
|
text |
[en] Units sold (view attribution: ad seen, not clicked). Amazon column: unitsSoldViews. |
|
|
int |
[en] Video ad: complete plays. Amazon column: videoCompleteViews. |
|
|
int |
[en] Video ad: plays to 25%. Amazon column: videoFirstQuartileViews. |
|
|
int |
[en] Video ad: plays to 50%. Amazon column: videoMidpointViews. |
|
|
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