Introduction
Datasources and destinations
- Find all the data sources available at www.catchr.io/connectors
- Find all the destinations available at www.catchr.io/destinations
Sponsored Product Acos Clicks 14d Advertising cost of sales based on purchases made within 14 days of an ad click. |
| ||||||
Sponsored Product Acos Clicks 7d Advertising cost of sales based on purchases made within 7 days of an ad click. |
| ||||||
Add To Cart Number of times shoppers added a brand's products to their cart, attributed to an ad view or click. |
| ||||||
Add To Cart Clicks Number of times shoppers added a brand's products to their cart, attributed to an ad click. |
| ||||||
Add To Cart Rate Calculated by divididing addToCart by impressions. |
| ||||||
Add To Cart Views Number of times shoppers added the brands' products to their cart, attributed to an ad view. |
| ||||||
Ad Group Id Unique numerical ID of the ad group. |
| ||||||
Ad Group Name The name of the ad group as entered by the advertiser. |
| ||||||
Ad Id Unique numerical ID of the ad. |
| ||||||
Ad Keyword Status Current status of a keyword. |
| ||||||
Ad Status Status of the ad group. |
| ||||||
Sponsored Product Advertised Asin The ASIN associated to an advertised product. |
| ||||||
Sponsored Product Advertised Sku The SKU being advertised. Not available for vendors. |
| ||||||
Sponsored Display Asin Brand Halo Represents a product that was purchased after an ad click but has a different SKU/ASIN that what was advertised. |
| ||||||
Sponsored Product Attributed Sales Same Sku14d Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised. Sponsored Products only. |
| ||||||
Sponsored Product Attributed Sales Same Sku1d Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised. |
| ||||||
Sponsored Product Attributed Sales Same Sku30d Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised. |
| ||||||
Sponsored Product Attributed Sales Same Sku7d Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised. |
| ||||||
Sponsored Brand Attribution Type Describes whether a purchase is attributed to a promoted product or brand-halo effect. |
| ||||||
Sponsored Brand Bid Optimization Bid optimization for Sponsored Display ad groups. For vCPM campaigns, the value is always reach. For CPC campaigns, value is either clicks or conversions. |
| ||||||
Branded Searches The number of searches that included the name of your brand occurring within 14 days of an ad click or view. |
| ||||||
Branded Searches Clicks The number of searches that included the name of your brand occurring within 14 days of an ad click. |
| ||||||
Branded Searches Views The number of times a branded keyword was searched on Amazon based on the brands associated to the featured ASINs in your campaign, attributed to an ad view. |
| ||||||
Sponsored Display Branded Search Rate Rate of Branded Searches relative to the number of impressions. (BS/Impressions) |
| ||||||
Sponsored Product Campaign Applicable Budget Rule Id The ID associated to the active budget rule for a campaign. |
| ||||||
Sponsored Product Campaign Applicable Budget Rule Name The name associated to the active budget rule for a campaign. |
| ||||||
Sponsored Product Campaign Bidding Strategy The bidding strategy associated with a campaign. |
| ||||||
Campaign Budget Amount Total budget allocated to the campaign. |
| ||||||
Campaign Budget Currency Code The currency code associated with the campaign. |
| ||||||
Campaign Budget Type One of daily or lifetime. |
| ||||||
Campaign Id The ID associated with a campaign. |
| ||||||
Campaign Name The name associated with a campaign. |
| ||||||
Sponsored Product Campaign Rule Based Budget Amount The value of the rule-based budget for a campaign. |
| ||||||
Campaign Status The status of a campaign. |
| ||||||
Clicks Total number of clicks on an ad. |
| ||||||
Click Through Rate Clicks divided by impressions. |
| ||||||
Sponsored Display Conversions Brand Halo For Sponsored Display vCPM campaigns, the total number of attributed conversion events occurring within 14 days of an ad click or view where the purchased SKU was different from the SKU advertised. |
| ||||||
Sponsored Display Conversions Brand Halo Clicks For Sponsored Display vCPM campaigns, the total number of attributed conversion events occurring within 14 days of an ad click or view where the purchased SKU was different from the SKU advertised. |
| ||||||
Cost Total cost of ad clicks. |
| ||||||
Sponsored Product Cost Per Click Total cost divided by total number of clicks. |
| ||||||
Sponsored Targeting Cost Per Thousand Impressions The cost per thousand impressions. |
| ||||||
Cost Type Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click). |
| ||||||
Sponsored Display Cumulative Reach Total number of unique users exposed to an ad from either a campaign, ad group, or product ad over the lifetime of the campaign or the past six months, whichever is shorter. This metric is updated daily. |
| ||||||
Date Reported By Amazon Report Date when the ad activity ocurred in the format YYYY-MM-DD. |
| ||||||
Detail Page Views Number of detail page views occurring within 14 days of an ad click or view. |
| ||||||
Detail Page Views Clicks Number of detail page views occurring within 14 days of an ad click. |
| ||||||
Sponsored Targeting Detail Page Views Views The number of times a product detail page was viewed attributed to an ad view. |
| ||||||
ECP Add To Cart Effect cost per add to cart, calculated by cost divided by add-to-cart. |
| ||||||
Sponsored Display ECP Brand Search Effective (average) cost to acquire a Branded Search. |
| ||||||
End Date of report End date of summary period for a report in the format YYYY-MM-DD. |
| ||||||
Gross Click Throughs The total number of times the ad was clicked. This includes valid, potentially fraudulent, non-human, and other illegitimate clicks. |
| ||||||
Gross Impressions The total number of times the ad was displayed. This includes valid and invalid impressions such as potentially fraudulent, non-human, and other illegitimate impressions. |
| ||||||
Impressions Total number of ad impressions. |
| ||||||
Sponsored Display Impressions Frequency Average Average number of times unique users were exposed to an ad over the lifetime of the campaign. |
| ||||||
Sponsored Display Impressions Views The total number of viewable impressions. Only relevant for Sponsored Display vCPM campaigns. |
| ||||||
Invalid Click Through Rate The percentage of gross click-throughs that were removed by the traffic quality filter. (Invalid click-throughs rate = invalid click-throughs / gross click-throughs) |
| ||||||
Invalid Click Throughs Clicks that were removed by the traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic. |
| ||||||
Invalid Impression Rate The percentage of gross impressions that were removed by the traffic quality filter. (Invalid impression rate = invalid impressions / gross impressions) |
| ||||||
Invalid Impressions The number of impressions removed by a traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic. |
| ||||||
Keyword Text of the keyword or a representation of the targeting expression (for Sponsored Products). For Sponsored Products targeting reports, the same value is returned in the targeting metric. |
| ||||||
Keyword Bid Bid associated with a keyword or targeting expression. |
| ||||||
Keyword Id ID associated with a keyword or targeting expression. |
| ||||||
Sponsored Branding Keyword Text Text of the keyword. |
| ||||||
Keyword Type Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For Sponsored Products reports, keywordType can also contain the type of targeting expressions, one of: TARGETINGEXPRESSION or TARGETINGEXPRESSION_PREDEFINED. |
| ||||||
Sponsored Product Kindle Edition Normalized Pages Read14d Number of attributed Kindle edition normalized pages read within 14 days of ad click. |
| ||||||
Sponsored Product Kindle Edition Normalized Pages Royalties14d The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click. |
| ||||||
Sponsored Display Matched Target Asin The ASIN associated with the product page where a Sponsored Display ad appeared. |
| ||||||
Match Type Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For Sponsored Products reports, keywordType can also contain the type of targeting expressions, one of: TARGETINGEXPRESSION or TARGETINGEXPRESSION_PREDEFINED. |
| ||||||
New To Brand Detail Page View Clicks Number of new-to-brand detail page views for all the brands' products, attributed to an ad click. |
| ||||||
New To Brand Detail Page View Rate Calculated by dividing newToBrandDetailPageViews / impressions. |
| ||||||
New To Brand Detail Page Views The number of new detail page views from shoppers who have not previously viewed a detail page with an ASIN of the same brand in past 365 days and who either clicked or viewed an ad. |
| ||||||
Sponsored Branding New To Brand Detail Page Views Clicks The number of new detail page views from shoppers who have not previously viewed a detail page with an ASIN of the same brand in past 365 days and who clicked an ad. |
| ||||||
New To Brand Detail Page View Views Number of new-to-brand detail page views for all the brands' products, attributed to an ad view |
| ||||||
New To Brand ECP Detail Page View Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view. |
| ||||||
New To Brand Purchases The number of first-time orders for brand products over a one-year lookback window resulting from an ad click or view. Not available for book vendors. |
| ||||||
Sponsored Branding New To Brand Purchases14d The number of first-time orders for brand products over a one-year lookback window. Not available for book vendors. |
| ||||||
New To Brand Purchases Clicks The number of first-time orders for brand products over a one-year lookback window resulting from an ad click. Not available for book vendors. |
| ||||||
Sponsored Branding New To Brand Purchases Percentage The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors. |
| ||||||
Sponsored Branding New To Brand Purchases Percentage14d The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors. |
| ||||||
Sponsored Branding New To Brand Purchases Rate The percentage of total orders that are new-to-brand orders. Not available for book vendors. |
| ||||||
Sponsored Targeting New To Brand Purchases Views The number of new to branch purchases attributed to an ad view. |
| ||||||
New To Brand Sales Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors. |
| ||||||
Sponsored Branding New To Brand Sales14d Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors. |
| ||||||
New To Brand Sales Clicks Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors. |
| ||||||
Sponsored Branding New To Brand Sales Percentage Percentage of total sales made up of new-to-brand purchases within 14 days of an ad click. Not available for book vendors. Same as newToBrandSalesPercentage14d. |
| ||||||
Sponsored Branding New To Brand Sales Percentage14d Percentage of total sales made up of new-to-brand purchases within 14 days of an ad click. Not available for book vendors. Same as newToBrandSalesPercentage. |
| ||||||
Sponsored Targeting New To Brand Sales Views Total value of sales by new to brand customers occurring within 14 days of an ad view. |
| ||||||
New To Brand Units Sold Total number of attributed units ordered as part of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors. |
| ||||||
Sponsored Branding New To Brand Units Sold14d Total number of attributed units ordered as part of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors. |
| ||||||
New To Brand Units Sold Clicks Total number of attributed units ordered as part of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors. |
| ||||||
Sponsored Branding New To Brand Units Sold Percentage Percentage of total attributed units ordered within 14 days of an ad click that are part of a new-to-brand purchase. Not available for book vendors. Same as newToBrandUnitsSoldPercentage14d. |
| ||||||
Sponsored Branding New To Brand Units Sold Percentage14d Percentage of total attributed units ordered within 14 days of an ad click that are part of a new-to-brand purchase. Not available for book vendors. Same as newToBrandUnitsSoldPercentage. |
| ||||||
Sponsored Branding Orders14d Number of orders within the last 14 days. |
| ||||||
Placement Classification The page location where an ad appeared. |
| ||||||
Portfolio Id The portfolio the campaign is associated with. |
| ||||||
Sponsored Branding Product Category The category the product is associated with on Amazon. |
| ||||||
Sponsored Branding Product Name The name of the product. |
| ||||||
Sponsored Display Promoted Asin The ASIN associated to an advertised product. |
| ||||||
Sponsored Display Promoted Sku The SKU being advertised. Not available for vendors. |
| ||||||
Purchased Asin The ASIN of the product that was purchased. |
| ||||||
Purchases Number of attributed conversion events occurring within 14 days of an ad click or view. |
| ||||||
Sponsored Product Purchases14d Number of attributed conversion events occurring within 14 days of an ad click. Sponsored Products only. |
| ||||||
Sponsored Product Purchases1d Number of attributed conversion events occurring within 1 day of an ad click. |
| ||||||
Sponsored Product Purchases30d Number of attributed conversion events occurring within 30 days of an ad click. |
| ||||||
Sponsored Product Purchases7d Number of attributed conversion events occurring within 7 days of an ad click. |
| ||||||
Purchases Clicks Number of attributed conversion events occurring within 14 days of an ad click. |
| ||||||
Sponsored Product Purchases Other Sku14d Number of attributed conversion events occurring within 14 days of an ad click where the SKU purchased was different that the advertised SKU. |
| ||||||
Sponsored Product Purchases Other Sku1d Number of attributed conversion events occurring within 1 day of an ad click where the SKU purchased was different that the advertised SKU. |
| ||||||
Sponsored Product Purchases Other Sku30d Number of attributed conversion events occurring within 30 days of an ad click where the SKU purchased was different that the advertised SKU. |
| ||||||
Sponsored Product Purchases Other Sku7d Number of attributed conversion events occurring within 7 days of an ad click where the SKU purchased was different that the advertised SKU. |
| ||||||
Sponsored Branding Purchases Promoted Number of attributed conversion events occurring within 14 days of ad click or view where the purchased SKU was the same as the SKU advertised. Same as purchasesSameSku14d. |
| ||||||
Sponsored Display Purchases Promoted Clicks Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised. |
| ||||||
Sponsored Product Purchases Same Sku14d Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised. Sponsored Products only. Same as puchasesPromoted. |
| ||||||
Sponsored Product Purchases Same Sku1d Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised. |
| ||||||
Sponsored Product Purchases Same Sku30d Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised. |
| ||||||
Sponsored Product Purchases Same Sku7d Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised. |
| ||||||
Sponsored Targeting Purchases Views Number of attributed conversion events occurring within 14 days of an ad view. |
| ||||||
Sponsored Targeting ROAS Return on ad spend. |
| ||||||
Sponsored Product ROAS Clicks 14d Return on ad spend based on purchases made within 14 days of an ad click. |
| ||||||
Sponsored Product ROAS Clicks 7d Return on ad spend based on purchases made within 7 days of an ad click. |
| ||||||
Sales Total value of sales occurring within 14 days of an ad click or view. |
| ||||||
Sponsored Product Sales 14d Total value of sales occurring within 14 days of an ad click. Sponsored Products only. |
| ||||||
Sponsored Product Sales 1d Total value of sales occurring within 1 day of an ad click. |
| ||||||
Sponsored Product Sales 30d Total value of sales occurring within 30 days of an ad click. |
| ||||||
Sponsored Product Sales7d Total value of sales occurring within 7 days of an ad click. |
| ||||||
Sponsored Display Sales Brand Halo For Sponsored Display vCPM campaigns, the total value of sales occurring within 14 days of an ad click or view where the purchased SKU was different from the SKU advertised. |
| ||||||
Sponsored Display Sales Brand Halo Clicks Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised. |
| ||||||
Sales Clicks Total value of sales occurring within 14 days of an ad click. |
| ||||||
Sponsored Product Sales Other Sku14d Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised. |
| ||||||
Sponsored Product Sales Other SKU 1d Total value of sales occurring within 1 day of an ad click where the purchased SKU was different from the SKU advertised. |
| ||||||
Sponsored Product Sales Other SKU 30d Total value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised. |
| ||||||
Sponsored Product Sales Other SKU 7d Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised. |
| ||||||
Sponsored Branding Sales Promoted Total value of sales occurring within 14 days of ad click or view where the purchased SKU was the same as the SKU advertised. Same as attributedSales14dSameSKU. |
| ||||||
Sponsored Display Sales Promoted Clicks Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised. |
| ||||||
Sponsored Targeting Sales Views Total value of sales occurring within 14 days of an ad view. |
| ||||||
Search Term The search term used by the customer. Same as query. |
| ||||||
Sponsored Product Spend Total cost of ad clicks. |
| ||||||
Start Date of report Start date of summary period for a report in the format YYYY-MM-DD. |
| ||||||
Sponsored Product Targeting A string representation of the expression object used in the targeting clause. |
| ||||||
Targeting Expression A string representation of the expression object used in the targeting clause. |
| ||||||
Targeting Id The identifier of the targeting expression. |
| ||||||
Targeting Text The text used in the targeting expression. |
| ||||||
Sponsored Brand Targeting Type The type of targeting used in the expression. |
| ||||||
Top Of Search Impression Share The percentage of top-of-search impressions earned out of all the top-of-search impressions that were eligible for a given date range. Various factors determine the eligibility for an impression including campaign status and targeting status. |
| ||||||
Units Sold Number of attributed units sold within 14 days of an ad click or view. |
| ||||||
Sponsored Branding Units Sold14d Number of attributed units sold within 14 days of click on an ad. Same as unitsSoldClicks14d. Only valid for Sponsored Brands version 3 campaigns, not Sponsored Brands video or multi-ad group (version 4) campaigns. |
| ||||||
Sponsored Display Units Sold Brand Halo For Sponsored Display vCPM campaigns, the total number of units ordered within 14 days of an ad click or view where the purchased SKU was different from the SKU advertised. For CPC campaigns, this value is equal to attributedUnitsOrdered14dOtherSKU. |
| ||||||
Sponsored Display Units Sold Brand Halo Clicks Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised. |
| ||||||
Units Sold Clicks Number of attributed units sold within 14 days of an ad click. |
| ||||||
Sponsored Product Units Sold Clicks 14d Total number of units ordered within 14 days of an ad click. Same as unitsSold14d |
| ||||||
Sponsored Product Units Sold Clicks 1d Total number of units ordered within 1 day of an ad click. |
| ||||||
Sponsored Product Units Sold Clicks 30d Total number of units ordered within 30 days of an ad click. |
| ||||||
Sponsored Product Units Sold Clicks 7d Total number of units ordered within 7 days of an ad click. |
| ||||||
Sponsored Product Units Sold Other Sku 14d Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised. |
| ||||||
Sponsored Product Units Sold Other Sku 1d Total number of units ordered within 1 day of an ad click where the purchased SKU was different from the SKU advertised. |
| ||||||
Sponsored Product Units Sold Other Sku 30d Total number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised. |
| ||||||
Sponsored Product Units Sold Other Sku 7d Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised. |
| ||||||
Sponsored Product Units Sold Same Sku 14d Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised. |
| ||||||
Sponsored Product Units Sold Same Sku 1d Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised. |
| ||||||
Sponsored Product Units Sold Same Sku 30d Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised. |
| ||||||
Sponsored Product Units Sold Same Sku 7d Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised. |
| ||||||
Sponsored Targeting Units Sold Views Number of attributed units sold within 14 days of an ad view. |
| ||||||
Sponsored Brand Video5 Second View Rate The percentage of impressions where the customer watched the complete video or 5 seconds of the video (whichever is shorter). Sponsored Brands video-only metric. |
| ||||||
Sponsored Brand Video5 Second Views The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands video-only metric. |
| ||||||
Video Complete Views The number of impressions where the video was viewed to 100%. |
| ||||||
Video First Quartile Views The number of impressions where the video was viewed to 25%. |
| ||||||
Video Midpoint Views The number of impressions where the video was viewed to 50%. |
| ||||||
Video Third Quartile Views The number of impressions where the video was viewed to 75%. |
| ||||||
Video Unmutes The number of impressions where a customer unmuted the video. |
| ||||||
Viewability Rate View-through rate (vtr). Views divided by impressions. |
| ||||||
Sponsored Brand Viewable Impressions Number of impressions that met the Media Ratings Council (MRC) viewability standard (50 percent of the ad viewable with two seconds playback completed). Sponsored Brands video-only metric. |
| ||||||
View Click Through Rate Click-through rate for views (clicks divided by views). |
| ||||||
Year Year such as 2017. |
| ||||||
Year Quarter Year and quarter. |
| ||||||
Year month Year and month. |
| ||||||
Year week Year and week. |
| ||||||
Quarter of the year Quarter of the year |
| ||||||
Month of the year Month of the year |
| ||||||
Month and day Month and day |
| ||||||
Day of the week Day of the week |
| ||||||
Day of the year Day of the year |
| ||||||
Date Year, month, and day. |
| ||||||
Week of the year Week of the year |
| ||||||
Week of the year (start sunday) Week of the year (start sunday) |
| ||||||
Extracted Date The date where the extraction take times. |
| ||||||
Platform Name Return the platform name |
|
.svg){kind=logo}