Amazon Ads Fields

Suggest Edits

Dimensions (60)

Account

NinjaCat System ID: amazon_ads:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

Ad Group Id

API Name: adGroupId

NinjaCat System ID: amazon_ads:DIM_adGroupId

Data Type: text

Ad Group Name

API Name: adGroupName

NinjaCat System ID: amazon_ads:DIM_adGroupName

Data Type: text

Aggregates To: DIM_AD_GROUP_NAME

Ad Id

API Name: adId

NinjaCat System ID: amazon_ads:DIM_adId

Data Type: text

Ad Keyword Status

API Name: adKeywordStatus

NinjaCat System ID: amazon_ads:DIM_adKeywordStatus

Data Type: text

Ad Status

API Name: adStatus

NinjaCat System ID: amazon_ads:DIM_adStatus

Data Type: text

Advertised Asin

API Name: advertisedAsin

NinjaCat System ID: amazon_ads:DIM_advertisedAsin

Data Type: text

Advertised Sku

API Name: advertisedSku

NinjaCat System ID: amazon_ads:DIM_advertisedSku

Data Type: text

Asin Brand Halo

API Name: asinBrandHalo

NinjaCat System ID: amazon_ads:DIM_asinBrandHalo

Data Type: text

Attribution Type

API Name: attributionType

NinjaCat System ID: amazon_ads:DIM_attributionType

Data Type: text

Bid Optimization

API Name: bidOptimization

NinjaCat System ID: amazon_ads:DIM_bidOptimization

Data Type: text

Campaign Applicable Budget Rule Id

API Name: campaignApplicableBudgetRuleId

NinjaCat System ID: amazon_ads:DIM_campaignApplicableBudgetRuleId

Data Type: text

Campaign Applicable Budget Rule Name

API Name: campaignApplicableBudgetRuleName

NinjaCat System ID: amazon_ads:DIM_campaignApplicableBudgetRuleName

Data Type: text

Campaign Bidding Strategy

API Name: campaignBiddingStrategy

NinjaCat System ID: amazon_ads:DIM_campaignBiddingStrategy

Data Type: text

Campaign Budget

API Name: campaignBudgetAmount

NinjaCat System ID: amazon_ads:DIM_campaignBudget

Data Type: decimal

Display As: currency

Campaign Budget Amount

API Name: campaignBudgetAmount

NinjaCat System ID: amazon_ads:DIM_campaignBudgetAmount

Data Type: decimal

Display As: currency

Campaign Budget Currency Code

API Name: campaignBudgetCurrencyCode

NinjaCat System ID: amazon_ads:DIM_campaignBudgetCurrencyCode

Data Type: text

Campaign Budget Type

API Name: campaignBudgetType

NinjaCat System ID: amazon_ads:DIM_campaignBudgetType

Data Type: text

Campaign Group

Deprecated: 2024-11-07T01:28:37.866Z

NinjaCat System ID: amazon_ads:DIM_CampaignGroup

Data Type: text

Aggregates To: DIM_CAMPAIGN_GROUPS

Campaign Id

API Name: campaignId

NinjaCat System ID: amazon_ads:DIM_campaignId

Data Type: text

Campaign Name

API Name: campaignName

NinjaCat System ID: amazon_ads:DIM_campaignName

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

Campaign Rule Based Budget Amount

API Name: campaignRuleBasedBudgetAmount

NinjaCat System ID: amazon_ads:DIM_campaignRuleBasedBudgetAmount

Data Type: decimal

Display As: currency

Campaign Status

API Name: campaignStatus

NinjaCat System ID: amazon_ads:DIM_campaignStatus

Data Type: text

Cost Type

API Name: costType

NinjaCat System ID: amazon_ads:DIM_costType

Data Type: text

Currency

NinjaCat System ID: amazon_ads:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: amazon_ads:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

Date

API Name: date

NinjaCat System ID: amazon_ads:DIM_date

Data Type: date

Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: amazon_ads:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: amazon_ads:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

End Date

API Name: endDate

NinjaCat System ID: amazon_ads:DIM_endDate

Data Type: date

External Id

NinjaCat System ID: amazon_ads:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

Keyword

API Name: keyword

NinjaCat System ID: amazon_ads:DIM_keyword

Data Type: text

Aggregates To: DIM_KEYWORDS

Keyword Id

API Name: keywordId

NinjaCat System ID: amazon_ads:DIM_keywordId

Data Type: text

Keyword Text

API Name: keywordText

NinjaCat System ID: amazon_ads:DIM_keywordText

Data Type: text

Keyword Type

API Name: keywordType

NinjaCat System ID: amazon_ads:DIM_keywordType

Data Type: text

Matched Target Asin

API Name: matchedTargetAsin

NinjaCat System ID: amazon_ads:DIM_matchedTargetAsin

Data Type: text

Match Type

API Name: matchType

NinjaCat System ID: amazon_ads:DIM_matchType

Data Type: text

Month Of Year

NinjaCat System ID: amazon_ads:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

Network

API Name: nc_network

NinjaCat System ID: amazon_ads:DIM_Network

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

Placement

API Name: placementClassification

NinjaCat System ID: amazon_ads:DIM_placement

Data Type: text

Placement Classification

API Name: placementClassification

NinjaCat System ID: amazon_ads:DIM_placementClassification

Data Type: text

Portfolio Id

API Name: portfolioId

NinjaCat System ID: amazon_ads:DIM_portfolioId

Data Type: text

Product Category

API Name: productCategory

NinjaCat System ID: amazon_ads:DIM_productCategory

Data Type: text

Product Name

API Name: productName

NinjaCat System ID: amazon_ads:DIM_productName

Data Type: text

Promoted Asin

API Name: promotedAsin

NinjaCat System ID: amazon_ads:DIM_promotedAsin

Data Type: text

Promoted Sku

API Name: promotedSku

NinjaCat System ID: amazon_ads:DIM_promotedSku

Data Type: text

Purchased Asin

API Name: purchasedAsin

NinjaCat System ID: amazon_ads:DIM_purchasedAsin

Data Type: text

Quarter

NinjaCat System ID: amazon_ads:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

Query

API Name: searchTerm

NinjaCat System ID: amazon_ads:DIM_query

Data Type: text

Row

NinjaCat System ID: amazon_ads:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

Search Term

API Name: searchTerm

NinjaCat System ID: amazon_ads:DIM_searchTerm

Data Type: text

Start Date

API Name: startDate

NinjaCat System ID: amazon_ads:DIM_startDate

Data Type: date

System Account ID

NinjaCat System ID: amazon_ads:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

Targeting

API Name: targeting

NinjaCat System ID: amazon_ads:DIM_targeting

Data Type: text

Targeting Expression

API Name: targetingExpression

NinjaCat System ID: amazon_ads:DIM_targetingExpression

Data Type: text

Targeting Id

API Name: targetingId

NinjaCat System ID: amazon_ads:DIM_targetingId

Data Type: text

Targeting Text

API Name: targetingText

NinjaCat System ID: amazon_ads:DIM_targetingText

Data Type: text

Targeting Type

API Name: targetingType

NinjaCat System ID: amazon_ads:DIM_targetingType

Data Type: text

Week Of Year

NinjaCat System ID: amazon_ads:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: amazon_ads:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

Metrics (162)

Acos Clicks (14d)

API Name: acosClicks14d

NinjaCat System ID: amazon_ads:MET_acosClicks14d

Data Type: decimal

Display As: currency

Acos Clicks (7d)

API Name: acosClicks7d

NinjaCat System ID: amazon_ads:MET_acosClicks7d

Data Type: decimal

Display As: currency

Add To Cart

API Name: addToCart

NinjaCat System ID: amazon_ads:MET_addToCart

Data Type: integer

Add To Cart Clicks

API Name: addToCartClicks

NinjaCat System ID: amazon_ads:MET_addToCartClicks

Data Type: integer

Add To Cart Rate

NinjaCat System ID: amazon_ads:MET_addToCartRate

Data Type: decimal

Display As: percent

Formula: amazon_ads:MET_addToCart / amazon_ads:MET_impressions

Add To Cart Views

API Name: addToCartViews

NinjaCat System ID: amazon_ads:MET_addToCartViews

Data Type: integer

Attributed Conversions (14d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: purchases14d

NinjaCat System ID: amazon_ads:MET_attributedConversions14d

Data Type: integer

Attributed Conversions (1d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: purchases1d

NinjaCat System ID: amazon_ads:MET_attributedConversions1d

Data Type: integer

Attributed Conversions (30d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: purchases30d

NinjaCat System ID: amazon_ads:MET_attributedConversions30d

Data Type: integer

Attributed Conversions (7d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: purchases7d

NinjaCat System ID: amazon_ads:MET_attributedConversions7d

Data Type: integer

Attributed Conversions: Same as SKU (14d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: purchasesSameSku14d

NinjaCat System ID: amazon_ads:MET_attributedConversions14dSameSKU

Data Type: integer

Attributed Conversions: Same as SKU (1d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: purchasesSameSku1d

NinjaCat System ID: amazon_ads:MET_attributedConversions1dSameSKU

Data Type: integer

Attributed Conversions: Same as SKU (30d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: purchasesSameSku30d

NinjaCat System ID: amazon_ads:MET_attributedConversions30dSameSKU

Data Type: integer

Attributed Conversions: Same as SKU (7d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: purchasesSameSku7d

NinjaCat System ID: amazon_ads:MET_attributedConversions7dSameSKU

Data Type: integer

Attributed Sales (14d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: sales14d

NinjaCat System ID: amazon_ads:MET_attributedSales14d

Data Type: decimal

Display As: currency

Attributed Sales (1d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: sales1d

NinjaCat System ID: amazon_ads:MET_attributedSales1d

Data Type: decimal

Display As: currency

Attributed Sales (30d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: sales30d

NinjaCat System ID: amazon_ads:MET_attributedSales30d

Data Type: decimal

Display As: currency

Attributed Sales (7d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: sales7d

NinjaCat System ID: amazon_ads:MET_attributedSales7d

Data Type: decimal

Display As: currency

Attributed Sales: Other SKU (14d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: salesOtherSku14d

NinjaCat System ID: amazon_ads:MET_attributedSales14dOtherSKU

Data Type: decimal

Display As: currency

Attributed Sales: Other SKU (1d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: salesOtherSku1d

NinjaCat System ID: amazon_ads:MET_attributedSales1dOtherSKU

Data Type: decimal

Display As: currency

Attributed Sales: Other SKU (30d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: salesOtherSku30d

NinjaCat System ID: amazon_ads:MET_attributedSales30dOtherSKU

Data Type: decimal

Display As: currency

Attributed Sales: Other SKU (7d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: salesOtherSku7d

NinjaCat System ID: amazon_ads:MET_attributedSales7dOtherSKU

Data Type: decimal

Display As: currency

Attributed Sales: Same as SKU (14d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: attributedSalesSameSku14d

NinjaCat System ID: amazon_ads:MET_attributedSales14dSameSKU

Data Type: decimal

Display As: currency

Attributed Sales: Same as SKU (1d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: attributedSalesSameSku1d

NinjaCat System ID: amazon_ads:MET_attributedSales1dSameSKU

Data Type: decimal

Display As: currency

Attributed Sales: Same as SKU (30d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: attributedSalesSameSku30d

NinjaCat System ID: amazon_ads:MET_attributedSales30dSameSKU

Data Type: decimal

Display As: currency

Attributed Sales: Same as SKU (7d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: attributedSalesSameSku7d

NinjaCat System ID: amazon_ads:MET_attributedSales7dSameSKU

Data Type: decimal

Display As: currency

Attributed Sales Same Sku (14d)

API Name: attributedSalesSameSku14d

NinjaCat System ID: amazon_ads:MET_attributedSalesSameSku14d

Data Type: decimal

Display As: currency

Attributed Sales Same Sku (1d)

API Name: attributedSalesSameSku1d

NinjaCat System ID: amazon_ads:MET_attributedSalesSameSku1d

Data Type: decimal

Display As: currency

Attributed Sales Same Sku (30d)

API Name: attributedSalesSameSku30d

NinjaCat System ID: amazon_ads:MET_attributedSalesSameSku30d

Data Type: decimal

Display As: currency

Attributed Sales Same Sku (7d)

API Name: attributedSalesSameSku7d

NinjaCat System ID: amazon_ads:MET_attributedSalesSameSku7d

Data Type: decimal

Display As: currency

Attributed Units Ordered (14d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: unitsSold14d

NinjaCat System ID: amazon_ads:MET_attributedUnitsOrdered14d

Data Type: integer

Attributed Units Ordered (14d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: unitsSold14d

NinjaCat System ID: amazon_ads:MET_attributedUnitsOrdered30d

Data Type: integer

Attributed Units Ordered (14d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: unitsSold14d

NinjaCat System ID: amazon_ads:MET_attributedUnitsOrdered7d

Data Type: integer

Attributed Units Ordered (14d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: unitsSold14d

NinjaCat System ID: amazon_ads:MET_attributedUnitsOrdered1d

Data Type: integer

Attributed Units Ordered Other SKU (14d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: unitsSoldOtherSku14d

NinjaCat System ID: amazon_ads:MET_attributedUnitsOrdered14dOtherSKU

Data Type: integer

Attributed Units Ordered Other SKU (1d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: unitsSoldOtherSku1d

NinjaCat System ID: amazon_ads:MET_attributedUnitsOrdered1dOtherSKU

Data Type: integer

Attributed Units Ordered Other SKU (30d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: unitsSoldOtherSku30d

NinjaCat System ID: amazon_ads:MET_attributedUnitsOrdered30dOtherSKU

Data Type: integer

Attributed Units Ordered Other SKU (7d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: unitsSoldOtherSku7d

NinjaCat System ID: amazon_ads:MET_attributedUnitsOrdered7dOtherSKU

Data Type: integer

Branded Searches

API Name: brandedSearches

NinjaCat System ID: amazon_ads:MET_brandedSearches

Data Type: integer

Branded Searches Clicks

API Name: brandedSearchesClicks

NinjaCat System ID: amazon_ads:MET_brandedSearchesClicks

Data Type: integer

Branded Searches Views

API Name: brandedSearchesViews

NinjaCat System ID: amazon_ads:MET_brandedSearchesViews

Data Type: integer

Branded Search Rate

NinjaCat System ID: amazon_ads:MET_brandedSearchRate

Data Type: decimal

Display As: percent

Formula: amazon_ads:MET_brandedSearches / amazon_ads:MET_impressions

Campaign Budget Amount

API Name: campaignBudgetAmount

NinjaCat System ID: amazon_ads:MET_campaignBudgetAmount

Data Type: decimal

Display As: currency

Clicks

API Name: clicks

NinjaCat System ID: amazon_ads:MET_clicks

Data Type: integer

Aggregates To: MET_CLICKS

Conversions Brand Halo

API Name: conversionsBrandHalo

NinjaCat System ID: amazon_ads:MET_conversionsBrandHalo

Data Type: integer

Conversions Brand Halo Clicks

API Name: conversionsBrandHaloClicks

NinjaCat System ID: amazon_ads:MET_conversionsBrandHaloClicks

Data Type: integer

Conv. Rate

NinjaCat System ID: amazon_ads:MET_conversionRate

Data Type: decimal

Display As: percent

Aggregates To: MET_CONVERSION_RATE

Formula: amazon_ads:MET_ActionLeadingToConv / amazon_ads:MET_sales

Cost

API Name: cost

NinjaCat System ID: amazon_ads:MET_cost

Data Type: decimal

Display As: currency

Aggregates To: MET_COST

Cost / Conv.

NinjaCat System ID: amazon_ads:MET_cpa

Data Type: decimal

Display As: currency

Aggregates To: MET_CPA

Formula: amazon_ads:MET_cost / amazon_ads:MET_sales

Cost Per Click

API Name: costPerClick

NinjaCat System ID: amazon_ads:MET_costPerClick

Data Type: decimal

Display As: currency

Cost Per Thousand Impressions

API Name: costPerThousandImpressions

NinjaCat System ID: amazon_ads:MET_costPerThousandImpressions

Data Type: decimal

Display As: currency

Count (Unique Dimensions)

NinjaCat System ID: amazon_ads:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

CPC

NinjaCat System ID: amazon_ads:MET_cpc

Data Type: decimal

Display As: currency

Aggregates To: MET_CPC

Formula: amazon_ads:MET_cost / amazon_ads:MET_clicks

CPM

NinjaCat System ID: amazon_ads:MET_cpm

Data Type: decimal

Display As: currency

Aggregates To: MET_CPM

Formula: amazon_ads:MET_cost / amazon_ads:MET_impressions

CTR

NinjaCat System ID: amazon_ads:MET_ctr

Data Type: decimal

Display As: percent

Aggregates To: MET_CTR

Formula: amazon_ads:MET_clicks / amazon_ads:MET_impressions

Cumulative Reach

API Name: cumulativeReach

NinjaCat System ID: amazon_ads:MET_cumulativeReach

Data Type: integer

Is Unique: True

DEPRECATED -- New To Brand Purchases Percentage (14d)

Deprecated: 2024-11-07T01:28:37.866Z

NinjaCat System ID: amazon_ads:MET_newToBrandPurchasesPercentage14d

Data Type: decimal

Display As: percent

Formula: amazon_ads:MET_newToBrandPurchases14d / amazon_ads:MET_purchases14d

DEPRECATED -- New To Brand Sales Percentage (14d)

Deprecated: 2024-11-07T01:28:37.866Z

NinjaCat System ID: amazon_ads:MET_newToBrandSalesPercentage14d

Data Type: decimal

Display As: percent

Formula: amazon_ads:MET_newToBrandSales14d / amazon_ads:MET_sales14d

Detail Page Views

API Name: detailPageViews

NinjaCat System ID: amazon_ads:MET_detailPageViews

Data Type: integer

Detail Page Views Clicks

API Name: detailPageViewsClicks

NinjaCat System ID: amazon_ads:MET_detailPageViewsClicks

Data Type: integer

Detail Page Views Views

API Name: detailPageViewsViews

NinjaCat System ID: amazon_ads:MET_detailPageViewsViews

Data Type: integer

ECP Add To Cart

API Name: eCPAddToCart

NinjaCat System ID: amazon_ads:MET_eCPAddToCart

Data Type: decimal

Display As: currency

ECP Brand Search

API Name: eCPBrandSearch

NinjaCat System ID: amazon_ads:MET_eCPBrandSearch

Data Type: decimal

Display As: currency

Impressions

API Name: impressions

NinjaCat System ID: amazon_ads:MET_impressions

Data Type: integer

Aggregates To: MET_IMPRESSIONS

Impressions Views

API Name: impressionsViews

NinjaCat System ID: amazon_ads:MET_impressionsViews

Data Type: integer

Keyword Bid

API Name: keywordBid

NinjaCat System ID: amazon_ads:MET_keywordBid

Data Type: decimal

Display As: currency

Kindle Edition Normalized Pages Read (14d)

API Name: kindleEditionNormalizedPagesRead14d

NinjaCat System ID: amazon_ads:MET_kindleEditionNormalizedPagesRead14d

Data Type: integer

Kindle Edition Normalized Pages Royalties (14d)

API Name: kindleEditionNormalizedPagesRoyalties14d

NinjaCat System ID: amazon_ads:MET_kindleEditionNormalizedPagesRoyalties14d

Data Type: decimal

Display As: currency

New To Brand Detail Page View Clicks

API Name: newToBrandDetailPageViewClicks

NinjaCat System ID: amazon_ads:MET_newToBrandDetailPageViewClicks

Data Type: integer

New To Brand Detail Page View Rate

NinjaCat System ID: amazon_ads:MET_newToBrandDetailPageViewRate

Data Type: decimal

Display As: percent

Formula: amazon_ads:MET_newToBrandDetailPageViews / amazon_ads:MET_impressions

New To Brand Detail Page Views

API Name: newToBrandDetailPageViews

NinjaCat System ID: amazon_ads:MET_newToBrandDetailPageViews

Data Type: integer

New To Brand Detail Page Views Clicks

API Name: newToBrandDetailPageViewsClicks

NinjaCat System ID: amazon_ads:MET_newToBrandDetailPageViewsClicks

Data Type: integer

New To Brand Detail Page View Views

API Name: newToBrandDetailPageViewViews

NinjaCat System ID: amazon_ads:MET_newToBrandDetailPageViewViews

Data Type: integer

New To Brand ECP Detail Page View

API Name: newToBrandECPDetailPageView

NinjaCat System ID: amazon_ads:MET_newToBrandECPDetailPageView

Data Type: decimal

Display As: currency

New To Brand Percentage Purchases

NinjaCat System ID: amazon_ads:MET_newToBrandPercentagePurchases

Data Type: decimal

Display As: percent

Formula: amazon_ads:MET_newToBrandPurchases / amazon_ads:MET_purchases

New To Brand Purchase Rate

NinjaCat System ID: amazon_ads:MET_newToBrandPurchaseRate

Data Type: decimal

Display As: percent

Formula: amazon_ads:MET_newToBrandPurchases / amazon_ads:MET_clicks

New To Brand Purchases

API Name: newToBrandPurchases

NinjaCat System ID: amazon_ads:MET_newToBrandPurchases

Data Type: integer

New To Brand Purchases (14d)

API Name: newToBrandPurchases14d

NinjaCat System ID: amazon_ads:MET_newToBrandPurchases14d

Data Type: integer

New To Brand Purchases Clicks

API Name: newToBrandPurchasesClicks

NinjaCat System ID: amazon_ads:MET_newToBrandPurchasesClicks

Data Type: integer

New To Brand Purchases Percentage

API Name: newToBrandPurchasesPercentage

NinjaCat System ID: amazon_ads:MET_newToBrandPurchasesPercentage

Data Type: decimal

Display As: percent

New To Brand Purchases Rate

NinjaCat System ID: amazon_ads:MET_newToBrandPurchasesRate

Data Type: decimal

Display As: percent

Formula: amazon_ads:MET_newToBrandPurchases / amazon_ads:MET_purchases

New To Brand Purchases Views

API Name: newToBrandPurchasesViews

NinjaCat System ID: amazon_ads:MET_newToBrandPurchasesViews

Data Type: integer

New To Brand Sales

API Name: newToBrandSales

NinjaCat System ID: amazon_ads:MET_newToBrandSales

Data Type: decimal

Display As: currency

New To Brand Sales (14d)

API Name: newToBrandSales14d

NinjaCat System ID: amazon_ads:MET_newToBrandSales14d

Data Type: decimal

Display As: currency

New To Brand Sales Clicks

API Name: newToBrandSalesClicks

NinjaCat System ID: amazon_ads:MET_newToBrandSalesClicks

Data Type: decimal

Display As: currency

New To Brand Sales Percentage

NinjaCat System ID: amazon_ads:MET_newToBrandSalesPercentage

Data Type: decimal

Display As: percent

Formula: amazon_ads:MET_newToBrandSales / amazon_ads:MET_sales

New To Brand Sales Promoted

API Name: newToBrandSalesPromoted

NinjaCat System ID: amazon_ads:MET_newToBrandSalesPromoted

Data Type: decimal

Display As: currency

New To Brand Sales Views

API Name: newToBrandSalesViews

NinjaCat System ID: amazon_ads:MET_newToBrandSalesViews

Data Type: decimal

Display As: currency

New To Brand Units Sold

API Name: newToBrandUnitsSold

NinjaCat System ID: amazon_ads:MET_newToBrandUnitsSold

Data Type: integer

New To Brand Units Sold (14d)

API Name: newToBrandUnitsSold14d

NinjaCat System ID: amazon_ads:MET_newToBrandUnitsSold14d

Data Type: integer

New To Brand Units Sold Clicks

API Name: newToBrandUnitsSoldClicks

NinjaCat System ID: amazon_ads:MET_newToBrandUnitsSoldClicks

Data Type: integer

New To Brand Units Sold Percentage

NinjaCat System ID: amazon_ads:MET_newToBrandUnitsSoldPercentage

Data Type: decimal

Display As: percent

Formula: amazon_ads:MET_newToBrandUnitsSold / amazon_ads:MET_unitsSold

New To Brand Units Sold Percentage (14d)

NinjaCat System ID: amazon_ads:MET_newToBrandUnitsSoldPercentage14d

Data Type: decimal

Display As: percent

Formula: amazon_ads:MET_newToBrandUnitsSold14d / amazon_ads:MET_unitsSold14d

Orders (14d)

API Name: orders14d

NinjaCat System ID: amazon_ads:MET_orders14d

Data Type: integer

Purchases

API Name: purchases

NinjaCat System ID: amazon_ads:MET_purchases

Data Type: integer

Aggregates To: MET_CONVERSIONS

Purchases (14d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: purchases14d

NinjaCat System ID: amazon_ads:MET_purchases14d

Data Type: integer

Purchases (1d)

API Name: purchases1d

NinjaCat System ID: amazon_ads:MET_purchases1d

Data Type: integer

Purchases (30d)

API Name: purchases30d

NinjaCat System ID: amazon_ads:MET_purchases30d

Data Type: integer

Purchases (7d)

API Name: purchases7d

NinjaCat System ID: amazon_ads:MET_purchases7d

Data Type: integer

Purchases Clicks

API Name: purchasesClicks

NinjaCat System ID: amazon_ads:MET_purchasesClicks

Data Type: integer

Purchases Other Sku (14d)

API Name: purchasesOtherSku14d

NinjaCat System ID: amazon_ads:MET_purchasesOtherSku14d

Data Type: integer

Purchases Other Sku (1d)

API Name: purchasesOtherSku1d

NinjaCat System ID: amazon_ads:MET_purchasesOtherSku1d

Data Type: integer

Purchases Other Sku (30d)

API Name: purchasesOtherSku30d

NinjaCat System ID: amazon_ads:MET_purchasesOtherSku30d

Data Type: integer

Purchases Other Sku (7d)

API Name: purchasesOtherSku7d

NinjaCat System ID: amazon_ads:MET_purchasesOtherSku7d

Data Type: integer

Purchases Promoted

API Name: purchasesPromoted

NinjaCat System ID: amazon_ads:MET_purchasesPromoted

Data Type: integer

Purchases Promoted Clicks

API Name: purchasesPromotedClicks

NinjaCat System ID: amazon_ads:MET_purchasesPromotedClicks

Data Type: integer

Purchases Same Sku (14d)

API Name: purchasesSameSku14d

NinjaCat System ID: amazon_ads:MET_purchasesSameSku14d

Data Type: integer

Purchases Same Sku (1d)

API Name: purchasesSameSku1d

NinjaCat System ID: amazon_ads:MET_purchasesSameSku1d

Data Type: integer

Purchases Same Sku (30d)

API Name: purchasesSameSku30d

NinjaCat System ID: amazon_ads:MET_purchasesSameSku30d

Data Type: integer

Purchases Same Sku (7d)

API Name: purchasesSameSku7d

NinjaCat System ID: amazon_ads:MET_purchasesSameSku7d

Data Type: integer

Purchases Views

API Name: purchasesViews

NinjaCat System ID: amazon_ads:MET_purchasesViews

Data Type: integer

ROAS

API Name: roas

NinjaCat System ID: amazon_ads:MET_roas

Data Type: decimal

Display As: currency

ROAS Clicks (14d)

API Name: roasClicks14d

NinjaCat System ID: amazon_ads:MET_roasClicks14d

Data Type: decimal

Display As: currency

ROAS Clicks (7d)

API Name: roasClicks7d

NinjaCat System ID: amazon_ads:MET_roasClicks7d

Data Type: decimal

Display As: currency

Sales

API Name: sales

NinjaCat System ID: amazon_ads:MET_sales

Data Type: decimal

Display As: currency

Sales (14d)

Deprecated: 2024-11-07T01:28:37.866Z

API Name: sales14d

NinjaCat System ID: amazon_ads:MET_sales14d

Data Type: decimal

Display As: currency

Sales (1d)

API Name: sales1d

NinjaCat System ID: amazon_ads:MET_sales1d

Data Type: decimal

Display As: currency

Sales (30d)

API Name: sales30d

NinjaCat System ID: amazon_ads:MET_sales30d

Data Type: decimal

Display As: currency

Sales (7d)

API Name: sales7d

NinjaCat System ID: amazon_ads:MET_sales7d

Data Type: decimal

Display As: currency

Sales Brand Halo

API Name: salesBrandHalo

NinjaCat System ID: amazon_ads:MET_salesBrandHalo

Data Type: integer

Sales Brand Halo Clicks

API Name: salesBrandHaloClicks

NinjaCat System ID: amazon_ads:MET_salesBrandHaloClicks

Data Type: integer

Sales Clicks

API Name: salesClicks

NinjaCat System ID: amazon_ads:MET_salesClicks

Data Type: decimal

Display As: currency

Sales Other Sku (14d)

API Name: salesOtherSku14d

NinjaCat System ID: amazon_ads:MET_salesOtherSku14d

Data Type: decimal

Display As: currency

Sales Other Sku (1d)

API Name: salesOtherSku1d

NinjaCat System ID: amazon_ads:MET_salesOtherSku1d

Data Type: decimal

Display As: currency

Sales Other Sku (30d)

API Name: salesOtherSku30d

NinjaCat System ID: amazon_ads:MET_salesOtherSku30d

Data Type: decimal

Display As: currency

Sales Other Sku (7d)

API Name: salesOtherSku7d

NinjaCat System ID: amazon_ads:MET_salesOtherSku7d

Data Type: decimal

Display As: currency

Sales Promoted

API Name: salesPromoted

NinjaCat System ID: amazon_ads:MET_salesPromoted

Data Type: decimal

Display As: currency

Sales Promoted Clicks

API Name: salesPromotedClicks

NinjaCat System ID: amazon_ads:MET_salesPromotedClicks

Data Type: decimal

Display As: currency

Sales Views

API Name: salesViews

NinjaCat System ID: amazon_ads:MET_salesViews

Data Type: decimal

Display As: currency

Search Term Impression Rank

API Name: searchTermImpressionRank

NinjaCat System ID: amazon_ads:MET_searchTermImpressionRank

Data Type: integer

Search Term Impression Share

API Name: searchTermImpressionShare

NinjaCat System ID: amazon_ads:MET_searchTermImpressionShare

Data Type: decimal

Is Unique: True

Display As: float

Spend

API Name: spend

NinjaCat System ID: amazon_ads:MET_spend

Data Type: decimal

Display As: currency

Top Of Search Impression Share

API Name: topOfSearchImpressionShare

NinjaCat System ID: amazon_ads:MET_topOfSearchImpressionShare

Data Type: decimal

Is Unique: True

Display As: float

Units Sold

API Name: unitsSold

NinjaCat System ID: amazon_ads:MET_unitsSold

Data Type: integer

Units Sold (14d)

API Name: unitsSold14d

NinjaCat System ID: amazon_ads:MET_unitsSold14d

Data Type: integer

Units Sold Brand Halo

API Name: unitsSoldBrandHalo

NinjaCat System ID: amazon_ads:MET_unitsSoldBrandHalo

Data Type: integer

Units Sold Brand Halo Clicks

API Name: unitsSoldBrandHaloClicks

NinjaCat System ID: amazon_ads:MET_unitsSoldBrandHaloClicks

Data Type: integer

Units Sold Clicks

API Name: unitsSoldClicks

NinjaCat System ID: amazon_ads:MET_unitsSoldClicks

Data Type: integer

Units Sold Clicks (14d)

API Name: unitsSoldClicks14d

NinjaCat System ID: amazon_ads:MET_unitsSoldClicks14d

Data Type: integer

Units Sold Clicks (1d)

API Name: unitsSoldClicks1d

NinjaCat System ID: amazon_ads:MET_unitsSoldClicks1d

Data Type: integer

Units Sold Clicks (30d)

API Name: unitsSoldClicks30d

NinjaCat System ID: amazon_ads:MET_unitsSoldClicks30d

Data Type: integer

Units Sold Clicks (7d)

API Name: unitsSoldClicks7d

NinjaCat System ID: amazon_ads:MET_unitsSoldClicks7d

Data Type: integer

Units Sold New To Brand

API Name: unitsSoldNewToBrand

NinjaCat System ID: amazon_ads:MET_unitsSoldNewToBrand

Data Type: integer

Units Sold Other Sku (14d)

API Name: unitsSoldOtherSku14d

NinjaCat System ID: amazon_ads:MET_unitsSoldOtherSku14d

Data Type: integer

Units Sold Other Sku (1d)

API Name: unitsSoldOtherSku1d

NinjaCat System ID: amazon_ads:MET_unitsSoldOtherSku1d

Data Type: integer

Units Sold Other Sku (30d)

API Name: unitsSoldOtherSku30d

NinjaCat System ID: amazon_ads:MET_unitsSoldOtherSku30d

Data Type: integer

Units Sold Other Sku (7d)

API Name: unitsSoldOtherSku7d

NinjaCat System ID: amazon_ads:MET_unitsSoldOtherSku7d

Data Type: integer

Units Sold Same Sku (14d)

API Name: unitsSoldSameSku14d

NinjaCat System ID: amazon_ads:MET_unitsSoldSameSku14d

Data Type: integer

Units Sold Same Sku (1d)

API Name: unitsSoldSameSku1d

NinjaCat System ID: amazon_ads:MET_unitsSoldSameSku1d

Data Type: integer

Units Sold Same Sku (30d)

API Name: unitsSoldSameSku30d

NinjaCat System ID: amazon_ads:MET_unitsSoldSameSku30d

Data Type: integer

Units Sold Same Sku (7d)

API Name: unitsSoldSameSku7d

NinjaCat System ID: amazon_ads:MET_unitsSoldSameSku7d

Data Type: integer

Units Sold Views

API Name: unitsSoldViews

NinjaCat System ID: amazon_ads:MET_unitsSoldViews

Data Type: integer

Video 5-Second View Rate

NinjaCat System ID: amazon_ads:MET_video5SecondViewRate

Data Type: decimal

Display As: percent

Formula: amazon_ads:MET_video5SecondViews / amazon_ads:MET_impressions

Video 5-Second Views

API Name: video5SecondViews

NinjaCat System ID: amazon_ads:MET_video5SecondViews

Data Type: integer

Video Complete Views

API Name: videoCompleteViews

NinjaCat System ID: amazon_ads:MET_videoCompleteViews

Data Type: integer

Video First Quartile Views

API Name: videoFirstQuartileViews

NinjaCat System ID: amazon_ads:MET_videoFirstQuartileViews

Data Type: integer

Video Midpoint Views

API Name: videoMidpointViews

NinjaCat System ID: amazon_ads:MET_videoMidpointViews

Data Type: integer

Video Third Quartile Views

API Name: videoThirdQuartileViews

NinjaCat System ID: amazon_ads:MET_videoThirdQuartileViews

Data Type: integer

Video Unmutes

API Name: videoUnmutes

NinjaCat System ID: amazon_ads:MET_videoUnmutes

Data Type: integer

Viewable Impressions

API Name: viewableImpressions

NinjaCat System ID: amazon_ads:MET_viewableImpressions

Data Type: integer

View Click Through Rate

NinjaCat System ID: amazon_ads:MET_viewClickThroughRate

Data Type: decimal

Display As: percent

Formula: amazon_ads:MET_clicks / amazon_ads:MET_viewableImpressions

VTR

NinjaCat System ID: amazon_ads:MET_viewabilityRate

Data Type: decimal

Display As: percent

Aggregates To: MET_VTR

Formula: amazon_ads:MET_viewableImpressions / amazon_ads:MET_impressions

Updated 4 months ago