Skip to main content
Skip table of contents

Amazon Ads Reference

The public API procedures may call the internal procedures which should not be used directly as they can be changed without any explicit notification in the newer versions of the connector. Internal procedures can be recognized by the prefix internal_ in their names. Public API procedures do not have such prefixes in their names.

AdGroups

Ad groups of sponsored products satisfying optional criteria PLANNED API DEPRECATION June 30, 2023
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<adGroupId> (optional): Retrieve an ad group by ID
<extended> (optional): Retrieve an ad group along with additional properties
<stateFilter> (optional): Restricts results to keywords with state within the specified comma-separated list. Must be one of: enabled, paused, or archived. Default behavior is to include all
<campaignIdFilter> (optional): Restricts results to ad groups within campaigns specified in comma-separated list
<adGroupIdFilter> (optional): Restricts results to ad groups specified in comma-separated list
<name> (optional): Restricts results to ad groups with the specified name
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

adGroupId

long

ID of the ad group

name

string

Name of the ad group

campaignId

long

ID of the campaign to which this ad group belongs

defaultBid

bigdecimal

The bid used when keywords belonging to this ad group don't specify a bid

state

string

Advertiser-specified state of the ad group

creationDate

timestamp

The date the ad group was created

lastUpdatedDate

timestamp

The date the ad group was last updated

servingStatus

string

The computed status, accounting for out of budget, policy violations, etc

Example

SQL
CREATE VIEW amazon_ads_examples.example_AdGroups AS
    SELECT * FROM (
        CALL amazon_ads.AdGroups (
            profileId => 0001,
            extended => true,
            preview => true
        )
    )x

Attribution_Advertisers

Advertisers associated with an Amazon Attribution account

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

advertiserId

long

The identifier of the advertiser

advertiserName

string

The name of the advertiser

Example

SQL
CREATE VIEW amazon_ads_examples.example_Attribution_Advertisers AS
    SELECT *
    FROM (
        CALL amazon_ads.Attribution_Advertisers (
            profileId => 2480654271163770
        )
    ) AS x

Attribution_Publishers

All available publishers

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

id

string

The identifier of the publisher

macroEnabled

boolean

Set to 'true' if the publisher supports macros

name

string

The name of the publisher

Example

SQL
CREATE VIEW amazon_ads_examples.example_Attribution_Publishers AS
    SELECT *
    FROM (
        CALL amazon_ads.Attribution_Publishers (
            profileId => 2480654271163770
        )
    ) AS x

Attribution_Report

Attribution report

Parameter
<profileId> (optional): Profile ID
<advertiserIds> (optional): One or more advertiser Ids to filter reporting by. If requesting reporting for multiple advertiser Ids, input via a comma-delimited list
<endDate> (optional): The end date for the report
<reportType> (optional): The type of report. Either PERFORMANCE or PRODUCTS
<startDate> (optional): The start date for the report. For reportType PRODUCTS, startDate can only be within last 90 days from current date
<daysToRedownload> (optional): Re-download days|How many days to query into the past
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profile_id

long

Profile ID

report_type

string

The type of report. Either PERFORMANCE or PRODUCTS

advertiser_id

long

One or more advertiser Ids to filter reporting by. If requesting reporting for multiple advertiser Ids, input via a comma-delimited list

date

date

Date on which the events took place. Applies to PERFORMANCE and PRODUCTS reportType

adGroupId

string

An ad group external identifier. Applies to PERFORMANCE and PRODUCTS reportType

advertiserName

string

Name of advertiser. Applies to PERFORMANCE and PRODUCTS reportType

brandName

string

Name of the advertiser's brand. Applies only to PRODUCTS reportType

campaignId

string

A campaign external identifier. Applies to PERFORMANCE and PRODUCTS reportType

creativeId

string

A creative external identifier. Applies only to PERFORMANCE reportType

marketplace

string

The Amazon-owned site the product is sold on. Applies only to PRODUCTS reportType

productAsin

string

A unique block of letters and/or numbers that identify all products sold on Amazon. Applies only to PRODUCTS reportType

productCategory

string

A classification for the type of product being sold which determines its place in the Amazon retail catalog. Contains categories of products. Applies only to PRODUCTS reportType

productSubcategory

string

A classification for the type of product being sold which determines its place in the Amazon retail catalog. Contains subcategories of products. Applies only to PRODUCTS reportType

productConversionType

string

The conversion type describes whether the conversion happened on a promoted or a brand halo ASIN. Applies only to PRODUCTS reportType

productGroup

string

A distinct product grouping distinguishing products like watches from video games from toys. Contains groups of products. Applies only to PRODUCTS reportType

productName

string

The name of the product. Applies only to PRODUCTS reportType

publisher

string

The publisher name. Applies to PERFORMANCE and PRODUCTS reportType

attributedAddToCartClicks14d

bigdecimal

The number of promoted add to cart conversions attributed to ad click-throughs within 14 days

attributedDetailPageViewsClicks14d

bigdecimal

The number of promoted detail page view conversions attributed to ad click-throughs within 14 days

attributedNewToBrandPurchases14d

bigdecimal

The number of promoted purchases made for the first time over a one-year lookback window by customers on Amazon, attributed to ad click-throughs within 14 days

attributedNewToBrandSales14d

bigdecimal

The aggregate value of promoted sales made for the first time over a one-year lookback window by customers on Amazon, attributed to ad click-throughs within 14 days

attributedNewToBrandUnitsSold14d

bigdecimal

The number of promoted units sold made for the first time over a one-year lookback window by customers on Amazon, attributed to ad click-throughs within 14 days

attributedPurchases14d

bigdecimal

The number of promoted purchases attributed to ad click-throughs within 14 days

attributedSales14d

bigdecimal

Aggregate value of promoted attributed sales occurring within 14 days of an attribution event in local currency

attributedTotalAddToCartClicks14d

bigdecimal

The number of total add to cart conversions attributed to ad click-throughs within 14 days, including brand halo

attributedTotalDetailPageViewsClicks14d

bigdecimal

The number of total detail page view conversions attributed to ad click-throughs within 14 days, including brand halo

attributedTotalPurchases14d

bigdecimal

The number of total purchases attributed to ad click-throughs within 14 days, including brand halo

brandHaloAttributedAddToCartClicks14d

bigdecimal

The number of Brand halo add to cart conversions attributed to ad click-throughs within 14 days

brandHaloAttributedPurchases14d

bigdecimal

The number of Brand halo purchases attributed to ad click-throughs within 14 days

brandHaloAttributedSales14d

bigdecimal

Aggregate value of Brand halo attributed sales occurring within 14 days of an attribution event in local currency

brandHaloDetailPageViewsClicks14d

bigdecimal

The number of Brand halo detail page view conversions attributed to ad click-throughs within 14 days

brandHaloNewToBrandPurchases14d

bigdecimal

The number of Brand halo purchases made for the first time over a one-year lookback window by customers on Amazon, attributed to ad click-throughs within 14 days

brandHaloNewToBrandSales14d

bigdecimal

The aggregate value of Brand halo sales made for the first time over a one-year lookback window by customers on Amazon, attributed to ad click-throughs within 14 days

brandHaloNewToBrandUnitsSold14d

bigdecimal

The number of Brand halo units sold made for the first time over a one-year lookback window by customers on Amazon, attributed to ad click-throughs within 14 days

brandHaloUnitsSold14d

bigdecimal

The number of Brand halo units sold attributed to ad click-throughs within 14 days

totalAttributedSales14d

bigdecimal

Aggregate value of total attributed sales occurring within 14 days of an attribution event in local currency, including brand halo

totalUnitsSold14d

bigdecimal

The number of total units sold attributed to ad click-throughs within 14 days, including brand halo

unitsSold14d

bigdecimal

The number of promoted units sold attributed to ad click-throughs within 14 days

Example

SQL
CREATE VIEW amazon_ads_examples.example_Attribution_Report AS
    SELECT *
    FROM (
        CALL amazon_ads.Attribution_Report (
            profileId => 2426252344407568,
            reportType => 'PERFORMANCE',
            advertiserIds => '3199887370002,2427069160401',
            startDate => TIMESTAMPADD (SQL_TSI_DAY, -365, CURDATE ()),
            endDate => CURDATE ()
        )
    ) AS x

Attribution_TagsMacro

Attribution tags for third-party publisher campaigns that support macros

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<publisherIds> (optional): List of publisher identifiers for which to request tags
<advertiserIds> (optional): List of advertiser identifiers for which to request tags. If no values are passed, all advertisers are returned
<nonMacroTemplateTag> (optional): If 'true' - gets a list of attribution tags for third-party publisher campaigns that do not support macros, otherwise if 'false' - gets a list of attribution tags for third-party publisher campaigns that support macros, if NULL - gets both
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

advertiserId

string

The advertiser identifier

publisherId

string

Publisher Id

macroTag

string

 

Example

SQL
CREATE VIEW amazon_ads_examples.example_Attribution_TagsMacro AS
    SELECT *
    FROM (
        CALL amazon_ads.Attribution_TagsMacro (
            profileId => 2480654271163770,
            publisherIds => '1,2,3',
            advertiserIds => NULL,
            nonMacroTemplateTag => NULL
        )
    ) AS x

BrandMetrics_Report

Brand Metrics report

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<lookBackPeriod> (optional): Defines the period of time used to determine the number of shoppers in the metrics computation. Currently supported values: "1w" (one week), "1m" (one month) and "1cm" (one calendar month)
<reportStartDate> (optional): Retrieves metrics with metricsComputationDate between reportStartDate and reportEndDate
<reportEndDate> (optional): Retrieves metrics with metricsComputationDate between reportStartDate and reportEndDate
<daysToRedownload> (optional): How many days to query into the past
<daysStep> (optional): Days step to split range of dates
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profile_id

long

Profile ID

brandName

string

Brand Name

categoryNodeName

string

The hierarchical path that leads to a node starting with the root node. If no Category Node Name is passed, then all data available for all brands belonging to the entity are retrieved

categoryNodeTreeName

string

The node at the top of a browse tree. It is the start node of a tree

lookbackPeriod

string

Defines the period of time used to determine the number of shoppers in the metrics computation

metricsComputationDate

date

Metrics computation date

addToCarts

bigdecimal

shoppers that added [Brand Name] to cart in [categoryNodePath] in [lookBackPeriod]

addToCartsCategoryMedian

bigdecimal

shoppers that added the peer median to cart in [categoryNodePath] in [lookBackPeriod]

addToCartsReturnOnEngagement

bigdecimal

The average amount of sales each customer who was in this state 12 months ago drove over 1 year. Calculated by taking the total original population 12 months ago by the total amount of sales this population drove over the last year for your brand in the selected category

addToCartsROECategoryMedian

bigdecimal

The average amount of sales each customer who was in this state for the peer median 12 months ago drove over 1 year. Calculated by taking the total original population 12 months ago by the total amount of sales this population drove over the last year for your brand in the selected category

addToCartsROECategoryTopPerformers

bigdecimal

The average amount of sales each customer who was in this state for the 95-99 percent peers 12 months ago drove over 1 year. Calculated by taking the total orginal population 12 months ago by the total amount of sales this populaton drove over the last year for your brand in the selected category

awarenessIndex

bigdecimal

Awareness Index measures actual on-Amazon audience signals reflecting awareness for your brand in the short and long term, across the whole on-Amazon audience. The percentile lets you know how the awareness activity for your brand compares to that of your peers

brandCustomers

bigdecimal

0%-90% of sales contributing shoppers for [Brand Name] whom purchased in [categoryNodePath] in [lookBackPeriod]

brandCustomersCategoryMedian

bigdecimal

0%-90% of sales contributors for the peer median whom purchased in [categoryNodePath] in [lookBackPeriod]

brandCustomersCategoryTopPerformers

bigdecimal

0%-90% of sales contributors for avg. of the top 95th - 99th percent of peers whom purchased in [categoryNodePath] in [lookBackPeriod]

brandCustomersReturnOnEngagement

bigdecimal

The average amount of sales each customer who was in this state 12 months ago drove over 1 year. Calculated by taking the total orginal population 12 months ago by the total amount of sales this populaton drove over the last year for your brand in the selected category

brandCustomersROECategoryMedian

bigdecimal

The average amount of sales each customer who was in this state for the peer median 12 months ago drove over 1 year. Calculated by taking the total orginal population 12 months ago by the total amount of sales this populaton drove over the last year for your brand in the selected category

brandCustomersROECategoryTopPerformers

bigdecimal

The average amount of sales each customer who was in this state for the 95-99 percent peers 12 months ago drove over 1 year. Calculated by taking the total orginal population 12 months ago by the total amount of sales this populaton drove over the last year for your brand in the selected category

brandedSearchesAndDetailPageViews

bigdecimal

shoppers that searched brand and viewed detail page of [Brand Name] in [categoryNodePath] in [lookBackPeriod]

brandedSearchesAndDetailPageViewsCategoryMedian

bigdecimal

shoppers that searched brand and viewed the detail page of peer median in [categoryNodePath] in [lookBackPeriod]

brandedSearchesAndDetailPageViewsCategoryTopPerformers

bigdecimal

shoppers that searched brand and viewed the detail page of avg. of the top 95th - 99th percent of peers in [categoryNodePath] in [lookBackPeriod]

brandedSearchesAndDetailPageViewsReturnOnEngagement

bigdecimal

The average amount of sales each customer who was in this state 12 months ago drove over 1 year. Calculated by taking the total original population 12 months ago by the total amount of sales this population drove over the last year for your brand in the selected category

brandedSearchesAndDetailPageViewsROECategoryMedian

bigdecimal

The average amount of sales each customer who was in this state for the peer median 12 months ago drove over 1 year. Calculated by taking the total original population 12 months ago by the total amount of sales this population drove over the last year for your brand in the selected category

brandedSearchesAndDetailPageViewsROECategoryTopPerformers

bigdecimal

The average amount of sales each customer who was in this state for the 95-99 percent peers 12 months ago drove over 1 year. Calculated by taking the total original population 12 months ago by the total amount of sales this population drove over the last year for your brand in the selected category

brandedSearchesCategoryMedian

bigdecimal

shoppers that searched for the peer median, but did not further engage or purchase from peer median and [categoryNodePath] in the [lookBackPeriod]

brandedSearchesCategoryTopPerformers

bigdecimal

shoppers that searched for the avg. of the top 95th - 99th percent of peers, and [categoryNodePath] but did not further engage or purchase from the Top Performers in the [lookBackPeriod]

brandedSearchesOnly

bigdecimal

shoppers that searched for [Brand Name] but did not further engage or purchase from [Brand Name] and [categoryNodePath] in the [lookBackPeriod]

considerationIndex

bigdecimal

Consideration Index measures actual on-Amazon audience signals reflecting consideration for your brand in the short and long term, across the whole on-Amazon audience. The percentile lets you know how the consideration activity for your brand compares to that of your peers

customerConversionRate

bigdecimal

percentage of shoppers moving from "considering" [Brand Name] in the [categoryNodePath] to "purchased" in the [lookBackPeriod]

customerConversionRateCategoryMedian

bigdecimal

percentage of shoppers moving from "considering" the peer median in the [categoryNodePath] to "purchased" in the [lookBackPeriod]

customerConversionRateCategoryTopPerformers

bigdecimal

percentage of shoppers moving from "considering" the average of the top 95th-99th percent of peers in the [categoryNodePath] to "purchased" in the l[lookBackPeriod]

engagedShopperRateCategoryMedianLowerBound

bigdecimal

Lower bound on the percentage of unique shoppers in a category that your brand has driven an engagement with or purchased from in the selected time frame divided by the total unique shoppers with 1+ detail page view in the selected category for the median peers

engagedShopperRateCategoryMedianUpperBound

bigdecimal

Upper bound on the percentage of unique shoppers in a category that your brand has driven an engagement with or purchase from in the selected time frame divided by the total unique shoppers with 1+ detail page view in the selected category for the median peers

engagedShopperRateCategoryTopPerformersLowerBound

bigdecimal

Lower bound on the percentage of unique shoppers in a category that your brand has driven an engagement with or purchase from in the selected time frame by the total unique shoppers with 1+ detail page view in the selected category for the top 95th-99th percent of peers

engagedShopperRateCategoryTopPerformersUpperBound

bigdecimal

Upper bound on the percentage of unique shoppers in a category that your brand has driven an engagement with or purchase from in the selected time frame divided by the total unique shoppers with 1+ detail page view in the selected category for the top 95th-99th percent of peers

engagedShopperRateLowerBound

bigdecimal

Lower bound on the percentage of unique shoppers in a category that your brand has driven an engagement with or purchase from int the selected time frame divided by the total unique shoppers with 1+ detail page view in the selected category

engagedShopperRateUpperBound

bigdecimal

Upper bound on the percentage of unique shoppers in a category that your brand has driven an engagement with or purchase from in the selected time frame divided by the total unique shoppers with 1+ detail page view in the selected category

highValueCustomers

bigdecimal

top 10% of sales contributing shoppers for

highValueCustomersCategoryMedian

bigdecimal

top 10% of sales contributing shoppers for peer median in [categoryNodePath] in [lookBackPeriod]

highValueCustomersCategoryTopPerformers

bigdecimal

The average amount of sales each customer who was in this state for the 95-99 percent peers 12 months ago drove over 1 year. Calculated by taking the total orginal population 12 months ago by the total amount of sales this populaton drove over the last year for your brand in the selected category

highValueCustomersReturnOnEngagement

bigdecimal

The average amount of sales each customer who was in this state 12 months ago drove over 1 year. Calculated by taking the total orginal population 12 months ago by the total amount of sales this populaton drove over the last year for your brand in the selected category

highValueCustomersROECategoryMedian

bigdecimal

The average amount of sales each customer who was in this state for the peer median 12 months ago drove over 1 year. Calculated by taking the total orginal population 12 months ago by the total amount of sales this populaton drove over the last year for your brand in the selected category

newToBrandCustomerRate

bigdecimal

share of customers that had not purchased [Brand Name] products in the last 12 months, but did so in the [lookBackPeriod]

newToBrandCustomerRateCategoryMedian

bigdecimal

share of customers that had not purchased peer median products in the last 12 months, but did so in the [lookBackPeriod]

newToBrandCustomerRateCategoryTopPerformers

bigdecimal

share of customers that had not purchased average of the top 95th-99th percent of peers products in the last 12 months, but did so in the [lookBackPeriod]

salesIndex

bigdecimal

Sales Index represents actual on-Amazon sales in the short term and long term, across the whole on-Amazon audience. The percentile lets you know how your sales compare to that of your peers

viewedDetailPageCategoryMedian

bigdecimal

shoppers that viewed the detail page only of peer median in [categoryNodePath] in [lookBackPeriod]

viewedDetailPageCategoryTopPerformers

bigdecimal

shoppers that viewed the detail page only of avg. of the top 95th - 99th percent of peers in [categoryNodePath] in [lookBackPeriod]

viewedDetailPageOnly

bigdecimal

shoppers that viewed detail page only of [Brand Name] in [categoryNodePath] in [lookBackPeriod]

viewedDetailPageOnlyReturnOnEngagement

bigdecimal

The average amount of sales each customer who was in this state 12 months ago drove over 1 year. Calculated by taking the total original population 12 months ago by the total amount of sales this population drove over the last year for your brand in the selected category

viewedDetailPageROECategoryMedian

bigdecimal

The average amount of sales each customer who was in this state for the peer median 12 months ago drove over 1 year. Calculated by taking the total original population 12 months ago by the total amount of sales this population drove over the last year for your brand in the selected category

viewedDetailPageROECategoryTopPerformers

bigdecimal

The average amount of sales each customer who was in this state for the 95-99 percent peers 12 months ago drove over 1 year. Calculated by taking the total original population 12 months ago by the total amount of sales this population drove over the last year for your brand in the selected category

Example

SQL
CREATE VIEW amazon_ads_examples.example_BrandMetrics_Report AS
    SELECT *
    FROM (
        CALL amazon_ads.BrandMetrics_Report (
            profileId => 2426252344407568,
            lookBackPeriod => '1w',
            reportStartDate => TIMESTAMPADD (SQL_TSI_DAY, -100, CURDATE ()),
            reportEndDate => CURDATE ()
        )
    ) AS x

Brands_AdGroups

Ad groups of sponsored brands associated with the client identifier passed in the authorization header, filtered by specified criteria

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<adGroupIdFilter> (optional): The returned array includes only ad groups with identifiers matching those specified in the comma-delimited string
<campaignIdFilter> (optional): The returned array includes only ad groups associated with campaign identifiers matching those specified in the comma-delimited string
<name> (optional): The returned array includes only ad groups with the specified name
<adGroupId> (optional): The identifier of an existing ad group
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

adGroupId

long

The idenitifier of the ad group

campaignId

long

The identifier of the campaign associated with the ad group

name

string

The name of the ad group

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_AdGroups AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_AdGroups (
            profileId => 0001,
            name => NULL,
            adGroupIdFilter => NULL,
            campaignIdFilter => NULL
        )
    ) AS x

Brands_Asins

Gets ASIN information for a specified address

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<pageUrl> (required): For sellers, the address of a Store page. Vendors may also specify the address of a custom landing page
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

code

string

The enumerated response code: - SUCCESS - The request was successful. The 'asinList' field includes all available ASINs. - INVALID_ARGUMENT - The request was not successful because the address was not for a valid landing page. - BAD_GATEWAY - The request failed because the landing page at the specified address did not have any ASINs

description

string

 

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_Asins AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_Asins (
            profileId => 0001,
            pageUrl => 'https://www.amazon.com/stores/JIMMYBAR/JIMMYBAR/page/2FEB7CEA-D932-4BAF-85B9-5FE4D106DF0B'
        )
    ) AS x

Brands_Assets

Assets of sponsored brands associated with a specified brand entity identifier

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<brandEntityId> (optional): For sellers, the Brand entity identifier of the Brand for which assets are returned
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

assetID

string

The identifier of an asset associated with a store

mediaType

string

 

name

string

The name of the asset

url

string

The address where the asset is stored

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_Assets AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_Assets (
            profileId => 0001,
            brandEntityId => NULL
        )
    ) AS x

Brands_BidsRecommendations

Bid recommendations for a specified list of keywords or products

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<campaignId> (optional): The identifier of the campaign for which bid recommendations are created
<keywords> (optional): CSV list of text of the keyword. Maximum of 10 words
<targets> (optional): CSV list of A name value pair that defines a targeting expression. The type field defines the predicate. The value field defines the value to match for the predicate
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

recommendation_type

string

 

code

string

An enumerated response code

details

string

A human-readable description of the enumerated response code in the 'code' field

keywordIndex

bigdecimal

Correlates the keyword to the keyword array index specified in the request

keyword_keywordText

string

The keyword text

keyword_matchType

string

Match Type

keyword_type

string

The match type, one of the following: broad, exact, phrase

keyword_value

string

The text of the keyword

recommendationId

string

The identifier of the target bid recommendation

recommendedBid_rangeEnd

bigdecimal

 

recommendedBid_rangeStart

bigdecimal

 

recommendedBid_recommended

bigdecimal

 

targetsIndex

bigdecimal

Correlates the keyword to the keyword array index specified in the request

targets_type

string

One of the following: asinCategorySameAs, asinBrandSameAs, asinPriceLessThan, asinPriceBetween, asinPriceGreaterThan, asinReviewRatingLessThan, asinReviewRatingBetween, asinReviewRatingGreaterThan, asinSameAs

targets_value

string

The text of the targeting expression

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_BidsRecommendations AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_BidsRecommendations (
            profileId => 0001,
            campaignId => NULL,
            targets => NULL,
            keywords => NULL
        )
    ) AS x

Brands_BrandRecommendations

Brand suggestions

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<preview> (optional): Preview only, don't write into table
<categoryId> (optional): The category identifier for which to get recommendations
<keyword> (optional): The keyword for which to get recommendations
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

id

long

The Brand identifier

name

string

The Brand name

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_BrandRecommendations AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_BrandRecommendations (
            profileId => 0001,
            keyword => 'bar'
        )
    ) AS x

Brands_Brands

Brand data objects for the Brand associated with the profile ID passed in the header

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attibute

Type

Description

profileId

long

Profile ID

brandEntityId

string

The Brand entity identifier

brandId

string

The Brand identifier

brandRegistryName

string

The Brand name

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_Brands AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_Brands (
            profileId => 0001
        )
    ) AS x

Brands_Campaigns

Campaigns of sponsored brands associated with the client identifier passed in the authorization header, filtered by specified criteria

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<campaignIdFilter> (optional): The returned array includes only campaigns with identifiers matching those specified in the comma-delimited string
<name> (optional): The returned array includes only campaigns with the specified name
<portfolioIdFilter> (optional): The returned array includes only campaigns associated with Portfolio identifiers matching those specified in the comma-delimited string
<campaignId> (optional): The identifier of an existing campaign
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

campaignId

long

The campaign identifier

name

string

The name of the campaign. This name must be unique to the Amazon Advertising account to which the campaign is associated. Maximum length of the string is 128 characters

startDate

date

The start date for the campaign. If this field is not set to a value, the current date is used

endDate

date

The end date for the campaign. Must be greater than the value for 'startDate'. If not specified, the campaign has no end date and runs continuously

bidMultiplier

bigdecimal

A bid multiplier. Note that this field can only be set when 'bidOptimization' is set to false. Value is a percentage to two decimal places. Example: If set to -30.00 for a $5.00 bid, the resulting bid is $3.00

bidOptimization

boolean

Set to 'true' to allow Amazon to automatically optimize bids for placements below top of search

brandEntityId

string

The brand entity identifier. Note that this field is required for sellers

budget

bigdecimal

The budget amount associated with the campaign

budgetType

string

Note that for the lifetime budget type, 'startDate' and 'endDate' must be specified. The lifetime budget range is from 100 to 20,000,000 and daily budget range is 1 to 1,000,000 by default for most marketplaces. For the JP marketplace, the lifetime budget range is fromt 10,000 to 2,000,000,000, and the daily budget range is 100 to 21,000,000

creative_asins

string

An array of ASINs associated with the creative

creative_brandLogoAssetID

string

The identifier of the brand logo image from the Store assets library

creative_brandLogoUrl

string

The address of the hosted image

creative_brandName

string

A brand name. Maximum length is 30 characters

creative_headline

string

The headline text. Maximum length of the string is 50 characters for all marketplaces other than Japan, which has a maximum length of 35 characters

creative_shouldOptimizeAsins

boolean

Note that this field is supported only in the US and UK marketplaces. Set to true to have Amazon show other products from your landing page in the advertisement if they are more relevant to the shopper's search. Set to false to use the ASINs specified in the 'asins' field. Do not specify in unsupported marketplaces

landingPage_asins

string

An array of ASINs used to generate a simple landing page. The response includes the URL of the generated simple landing page. Do not include this property in the request if the 'url' property is also included, these properties are mutually exclusive

landingPage_pageType

string

 

landingPage_url

string

"URL of a Store page. Vendors may also specify the URL of a custom landing page. If a custom URL is specified, the landing page must include include the ASINs of at least three products that are advertised as part of the campaign. Do not include this property in the request if the 'asins' property is also included, these properties are mutually exclusive."

portfolioId

long

The identifier of the portfolio to which the campaign is associated

servingStatus

string

One of the following : asinNotBuyable, billingError, ended, landingPageNotAvailable, outOfBudget, paused, pendingReview, ready, rejected, running, scheduled, terminated

state

string

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_Campaigns AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_Campaigns (
            profileId => 0001,
            name => NULL,
            portfolioIdFilter => NULL,
            campaignIdFilter => NULL
        )
    ) AS x

Brands_CampaignsModeration

Moderation result for a campaign specified by identifier

Parameter
<profileId> (optional): Profile ID
<campaignId> (optional): The identifier of an existing campaign
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

campaignId

long

The campaign identifie

moderationStatus

string

One of the following : APPROVED, IN_PROGRESS, REJECTED

etaForModeration

timestamp

Expected date and time by which moderation will be complete

policyDescription

string

A human-readable description of the policy

policyLinkUrl

string

Address of the policy documentation. Follow the link to learn more about the specified policy

asinEvidences_asin

string

The ASIN that violates the specified policy

imageEvidences_violatingImageCrop_height

integer

The height of the content that violates the specfied policy within the image

imageEvidences_violatingImageCrop_topLeftX

integer

The top left X-coordinate of the content that violates the specfied policy within the image

imageEvidences_violatingImageCrop_topLeftY

integer

The top left Y-coordinate of the content that violates the specfied policy within the image

imageEvidences_violatingImageCrop_width

integer

The width of the content that violates the specfied policy within the image

moderatedComponent

string

The ad component that includes the text that violates the specified policy

reviewedImageUrl

string

Address of the image reviewed during moderation

reviewedText

string

The specific text reviewed during moderation

textEvidences

string

The specific text determined to violate the specified policy in 'reviewedText'

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_CampaignsModeration AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_CampaignsModeration (
            profileId => 0001,
            campaignId => 0002
        )
    ) AS x

Brands_DraftCampaigns

Draft campaign objects of sponsored brands

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<draftCampaignIdFilter> (optional): The returned array includes only draft campaigns with identifiers matching those specified in the comma-delimited string.
<name> (optional): The returned array only includes draft campaigns with the specified name
<portfolioIdFilter> (optional): The returned array includes only campaigns associated with Portfolio identifiers matching those specified in the comma-delimited string
<draftCampaignId> (optional): The identifier of an existing draft campaign
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

draftCampaignId

long

The identifier of the draft campaign

name

string

The name of the draft campaign. Maximum 128 characters. Duplicate campaign names are not allowed

startDate

date

The start date for the campaign. If this field is not set to a value, the current date is used

endDate

date

The end date for the campaign. Must be greater than the value for 'startDate'. If not specified, the campaign has no end date and runs continuously

bidMultiplier

bigdecimal

A bid multiplier. Note that this field can only be set when 'bidOptimization' is set to false. Value is a percentage to two decimal places. Example: If set to -30.00 for a $5.00 bid, the resulting bid is $3.00

bidOptimization

boolean

Set to 'true' to allow Amazon to automatically optimize bids for placements below top of search

brandEntityId

string

The brand entity identifier. Note that this field is required for sellers

budget

bigdecimal

The budget associated with the draft campaign

budgetType

string

Note that for the lifetime budget type, 'startDate' and 'endDate' must be specified. The lifetime budget range is from 100 to 20,000,000 and daily budget range is 1 to 1,000,000 by default for most marketplaces. For the JP marketplace, the lifetime budget range is fromt 10,000 to 2,000,000,000, and the daily budget range is 100 to 21,000,000

creative_asins

string

An array of ASINs associated with the creative

creative_brandLogoAssetID

string

The identifier of the brand logo image from the Store assets library

creative_brandLogoUrl

string

The address of the hosted image

creative_brandName

string

A brand name. Maximum length is 30 characters

creative_headline

string

The headline text. Maximum length of the string is 50 characters for all marketplaces other than Japan, which has a maximum length of 35 characters

creative_shouldOptimizeAsins

boolean

Note that this field is supported only in the US and UK marketplaces. Set to true to have Amazon show other products from your landing page in the advertisement if they are more relevant to the shopper's search. Set to false to use the ASINs specified in the 'asins' field. Do not specify in unsupported marketplaces

landingPage_asins

string

An array of ASINs used to generate a simple landing page. The response includes the URL of the generated simple landing page. Do not include this property in the request if the 'url' property is also included, these properties are mutually exclusive

landingPage_pageType

string

 

landingPage_url

string

"URL of a Store page. Vendors may also specify the URL of a custom landing page. If a custom URL is specified, the landing page must include include the ASINs of at least three products that are advertised as part of the campaign. Do not include this property in the request if the 'asins' property is also included, these properties are mutually exclusive."

portfolioId

long

The identifier of the Portfolio to which the draft campaign is associated

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_DraftCampaigns AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_DraftCampaigns (
            profileId => 0001,
            name => NULL,
            draftCampaignIdFilter => NULL,
            portfolioIdFilter => NULL
        )
    ) AS x

Brands_KeywordRecommendations

Keyword recommendation objects for a set of ASINs included either on a landing page or a Store page. Vendors may also specify a custom landing page

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<maxNumSuggestions> (required): Maximum number of suggestions to return. Max value is 1000. If not provided, default to 100
<asins> (optional): CSV list of of ASINs. Minimum: 3, maximum: 100
<url> (optional): The URL of the Stores page, or, Vendors may also specify the URL of a custom landing page
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

matchType

string

The match type

recommendationId

string

A recommendation identifier that describes the suggested action for the recommendation

value

string

Recommended keyword value

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_KeywordRecommendations AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_KeywordRecommendations (
            profileId => 0001,
            asins => NULL,
            url => 'https://www.amazon.com/stores/URL'
        )
    ) AS x

Brands_Keywords

Keywords of sponsored brands, filtered by optional criteria

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<adGroupIdFilter> (optional): The returned array includes only keywords associated with ad groups matching those specified by identifier in the comma-delimited string
<campaignIdFilter> (optional): The returned array includes only keywords associated with campaigns matching those specified by identifier in the comma-delimited string
<keywordIdFilter> (optional): The returned array includes only keywords with identifiers matching those specified in the comma-delimited string
<keywordText> (optional): The returned array includes only keywords with the specified text
<keywordId> (optional): The identifier of an existing keyword
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

adGroupId

long

The identifier of the ad group associated with the keyword

bid

bigdecimal

The bid associated with the keyword

campaignId

long

The identifier of the campaign associated with the keyword

keywordId

long

The keyword identifier

keywordText

string

The keyword text. The maximum number of words for this string is 10

matchType

string

The match type. For more information, see match types in the Amazon Advertising support center

state

string

Newly created SB keywords are in a default state of 'draft' before transitioning to a 'pending' state for moderation. After moderation, the keyword will be in an enabled state

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_Keywords AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_Keywords (
            profileId => 0001,
            keywordText => NULL,
            campaignIdFilter => NULL,
            adGroupIdFilter => NULL,
            keywordIdFilter => NULL
        )
    ) AS x

Brands_NegativeKeywords

Negative keywords of sponsored brands, filtered by optional criteria

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<adGroupIdFilter> (optional): The returned array includes only negative keywords associated with ad groups matching those specified by identifier in the comma-delimited string
<campaignIdFilter> (optional): The returned array includes only negative keywords associated with campaigns matching those specified by identifier in the comma-delimited string
<keywordIdFilter> (optional): The returned array includes only negative keywords with identifiers matching those specified in the comma-delimited string
<keywordText> (optional): The returned array includes only negative keywords with the specified text
<keywordId> (optional): The identifier of an existing negative keyword
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

adGroupId

long

The identifier of the ad group associated with the keyword

campaignId

long

The identifier of the campaign associated with the keyword

keywordId

long

The keyword identifier

keywordText

string

The keyword text. The maximum number of words for this string is 10

matchType

string

The negative match type. For more information, see negative keyword match types in the Amazon Advertising support center

state

string

Newly created SB keywords are in a default state of 'draft' before transitioning to a 'pending' state for moderation. After moderation, the keyword will be in an enabled state

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_NegativeKeywords AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_NegativeKeywords (
            profileId => 0001,
            keywordText => NULL,
            campaignIdFilter => NULL,
            adGroupIdFilter => NULL,
            keywordIdFilter => NULL
        )
    ) AS x

Brands_NegativeTargets

Product negative targets associated with the client identifier passed in the authorization header, filtered by specified criteria

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<maxResults> (required): Sets a limit on the number of results returned by an operation. Max value is 100. If not provided, default to 100
<adGroup_ids> (optional): CSV list of of AdGroup Ids
<campaign_ids> (optional): CSV list of of Campaign Ids
<targeting_states> (optional): CSV list of of targeting states
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

adGroupId

long

The identifier of the ad group to which the target is associated

bid

bigdecimal

The bid associated with the keyword

campaignId

long

The identifier of the campaign to which the target is associated

expressions_type

string

One of the following: asinCategorySameAs, asinBrandSameAs, asinPriceLessThan, asinPriceBetween, asinPriceGreaterThan, asinReviewRatingLessThan, asinReviewRatingBetween, asinReviewRatingGreaterThan, asinSameAs

expressions_value

string

The text of the targeting expression

resolvedExpressions_type

string

One of the following: asinCategorySameAs, asinBrandSameAs, asinPriceLessThan, asinPriceBetween, asinPriceGreaterThan, asinReviewRatingLessThan, asinReviewRatingBetween, asinReviewRatingGreaterThan, asinSameAs

resolvedExpressions_value

string

The human-readable target text

state

string

One of the following: enabled, paused, pending, archived, draft

targetId

long

The target identifier

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_NegativeTargets AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_NegativeTargets (
            profileId => 0001,
            targeting_states => 'enabled,pending'
        )
    ) AS x

Brands_ProductRecommendations

Recommended products for targeting

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<asins> (optional): CSV list of of ASINs
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

recommendedTargetAsin

string

 

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_ProductRecommendations AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_ProductRecommendations (
            profileId => 0001,
            asins => '1'
        )
    ) AS x

Brands_Report

Sponsored Brands Reports
Parameter
<recordType> (required): The type of entity for which the report should be generated. Supported record types: campaigns, adGroups, keywords, targets
<segment> (optional): Dimension on which to segment the report. Supported dimensions: placement, query
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<reportDate> (optional): The date to retrieve the performance report for
<reportDateEnd> (optional): The date to retrieve the performance reports for multiple days till
<includeVideo> (optional): Include Sponsored Brands video report
<daysToRedownload> (optional): Re-download days|How many days to query into the past
<leaveReDownloadedData> (optional): Leave all data in the table|Skip the deletion of data
<days_step> (optional): Number of days to query in a single batch
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multitenancy label

Attribute

Type

Description

profileId

long

Profile Id

reportDate

date

The date of the performance report

isVideo

boolean

From Sponsored Brands video report

placement

string

The optional dimension on which to segment a campaigns report. Placement refers to the location on a page where your ad appears

query

string

The optional dimension on which to segment a keyword report. This is also referred to as the search terms report

adGroupId

long

Unique AdGroup ID

adGroupName

string

Unique AdGroup name

campaignBudget

bigdecimal

The campaign budget

campaignBudgetType

string

One of: daily or lifetime

campaignId

long

Unique campaign ID

campaignName

string

Advertiser created campaign name

campaignRuleBasedBudget

bigdecimal

The value of the rule-based budget

campaignStatus

string

Current status of the campaign

keywordId

long

Keyword ID

keywordBid

bigdecimal

User-set bid value for keyword

keywordStatus

string

Keyword state

keywordText

string

Keyword or phrase used in bid

applicableBudgetRuleId

string

The identifier of the active rule

applicableBudgetRuleName

string

The name of the active rule

targetId

long

The product target identifier

targetingExpression

string

The product targeting expression. Not available for search term report

targetingText

string

The product targeting text. Not available for search term report

targetingType

string

The product targeting type. One of: asinCategorySameAs, asinBrandSameAs, asinPriceLessThan, asinPriceBetween, asinPriceGreaterThan, asinReviewRatingLessThan, asinReviewRatingBetween, asinReviewRatingGreaterThan, asinSameAs

searchTermImpressionRank

string

Search term impression rank provides account-level ad-attributed impression rank for search terms

searchTermImpressionShare

string

Search term impression share provides account-level ad-attributed impression share for search terms

matchType

string

One of: broad, phrase, or exact

attributedConversions14d

bigdecimal

Number of attributed conversion events occurring within 14 days of click on ad

attributedConversions14dSameSKU

bigdecimal

Number of attributed conversion events occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised

attributedDetailPageViewsClicks14d

bigdecimal

The number of detail page view conversions attributed to ad click-throughs within 14 days

attributedOrderRateNewToBrand14d

bigdecimal

The number of new-to-brand orders relative to the number of clicks

attributedOrdersNewToBrand14d

bigdecimal

The number of first-time orders for products within the brand over a one-year lookback window

attributedOrdersNewToBrandPercentage14d

bigdecimal

The percentage of total orders that are new-to-brand orders

attributedSales14d

bigdecimal

Number of attributed sales occurring within 14 days of click on an ad

attributedSales14dSameSKU

bigdecimal

Aggregate value of attributed sales occurring within 14 days of click on ad where the purchased SKU was the same as the one advertised

attributedSalesNewToBrand14d

bigdecimal

The total sales of new-to-brand orders

attributedSalesNewToBrandPercentage14d

bigdecimal

The percentage of total sales of new-to-brand purchases

attributedUnitsOrderedNewToBrand14d

bigdecimal

The number of units from first-time orders for products within the brand over a one-year lookback window

attributedUnitsOrderedNewToBrandPercentage14d

bigdecimal

The percentage of total units that are units from new-to-brand orders

clicks

bigdecimal

Total ad clicks

cost

bigdecimal

Total cost of all clicks

dpv14d

bigdecimal

Number of attributed detail page views occurring within 14 days of click on an ad

impressions

bigdecimal

Total ad impressions

topOfSearchImpressionShare

bigdecimal

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

unitsSold14d

bigdecimal

Number of attributed units sold occurring within 14 days of click on an ad

viewableImpressions

bigdecimal

Views is the number of impressions that met the MRC viewability standard (50% viewable with 2 seconds playback completed)

videoFirstQuartileViews

bigdecimal

The number of impressions where the video was viewed to 25%

videoMidpointViews

bigdecimal

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

bigdecimal

The number of impressions where the video was viewed to 75%

videoCompleteViews

bigdecimal

The number of impressions where the video was viewed to 100%

video5SecondViews

bigdecimal

The number of impressions where the shopper watched the complete video or 5 seconds (whichever is shorter)

video5SecondViewRate

bigdecimal

The percentage of impressions where the shopper watched the complete video or 5 seconds (whichever is shorter)

videoUnmutes

bigdecimal

The number of impressions where a shopper unmuted the video

vtr

bigdecimal

View-through-rate (views/impressions)

vctr

bigdecimal

Clicks-through-rate for views (clicks/views)

errorMessage

string

Error message if any problem happened

Brands_TargetingCategoriesRecommendations

Recommended categories for targeting

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<asins> (required): CSV list of of ASINs
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

id

long

The category identifier

isTargetable

boolean

Set to 'true' if the category can be targeted in a targeting expression, and 'false' if not

name

string

The category name

path

string

The path of the category within the category catalogue

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_TargetingCategoriesRecommendations AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_TargetingCategoriesRecommendations (
            profileId => 0001,
            asins => '1'
        )
    ) AS x

Brands_Targets

Product targets associated with the client identifier passed in the authorization header, filtered by specified criteria

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<maxResults> (required): Sets a limit on the number of results returned by an operation. Max value is 100. If not provided, default to 100
<adGroup_ids> (optional): CSV list of of AdGroup Ids
<campaign_ids> (optional): CSV list of of Campaign Ids
<targeting_states> (optional): CSV list of of targeting states
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

adGroupId

long

The identifier of the ad group to which the target is associated

bid

bigdecimal

The bid associated with the keyword

campaignId

long

The identifier of the campaign to which the target is associated

expressions_type

string

One of the following: asinCategorySameAs, asinBrandSameAs, asinPriceLessThan, asinPriceBetween, asinPriceGreaterThan, asinReviewRatingLessThan, asinReviewRatingBetween, asinReviewRatingGreaterThan, asinSameAs

expressions_value

string

The text of the targeting expression

resolvedExpressions_type

string

One of the following: asinCategorySameAs, asinBrandSameAs, asinPriceLessThan, asinPriceBetween, asinPriceGreaterThan, asinReviewRatingLessThan, asinReviewRatingBetween, asinReviewRatingGreaterThan, asinSameAs

resolvedExpressions_value

string

The human-readable target text

state

string

One of the following: enabled, paused, pending, archived, draft

targetId

long

The target identifier

Example

SQL
CREATE VIEW amazon_ads_examples.example_Brands_Targets AS
    SELECT *
    FROM (
        CALL amazon_ads.Brands_Targets (
            profileId => 0001,
            targeting_states => 'enabled,pending'
        )
    ) AS x

Campaigns

Sponsored Products campaigns with additional properties based on the specified criteria PLANNED API DEPRECATION June 30, 2023
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<campaignId> (optional): Retrieves a campaign by ID
<extended> (optional): Retrieve a campaign along with additional properties
<campaignType> (optional): Campaign type filter
<stateFilter> (optional): Restricts results to campaigns with state within the specified comma-separated list. Must be one of: enabled, paused, or archived. Default behavior is to include all
<name> (optional): Restricts results to campaigns with the specified name
<campaignIdFilter> (optional): Restricts results to campaigns specified in comma-separated list
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

campaignId

long

ID of the campaign

name

string

Name of the campaign

targetingType

string

Differentiates between a keyword-targeted and automatically targeted campaign

state

string

Advertiser-specified state of the campaign

dailyBudget

bigdecimal

Daily budget for the campaign

startDate

date

The date the campaign will go or went live

endDate

date

The optional date the campaign will stop running

premiumBidAdjustment

boolean

When enabled, Amazon will increase the default bid for your ads that are eligible to appear in this placement

placement

string

Ad placement. Only returned when segment is set to placement

creationDate

timestamp

The date the campaign was created

lastUpdatedDate

timestamp

The date the campaign was last updated

servingStatus

string

The computed status, accounting for campaign out of budget, policy violations, etc

portfolioId

long

The ID of the portfolio

Example

SQL
CREATE VIEW amazon_ads_examples.example_Campaigns AS
    SELECT * FROM (
        CALL amazon_ads.Campaigns (
            profileId => 0001,
            extended => true,
            preview => true
        )
    )x

Consolidated_Report

Consolidated Reports
Parameter
<recordType> (required): The type of entity for which the report should be generated. Available values: campaigns, adGroups, keywords, productAds, targets
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<reportDate> (optional): The date to retrieve the performance report for
<reportDateEnd> (optional): The date to retrieve the performance reports for multiple days till
<daysToRedownload> (optional): Re-download days|How many days to query into the past
<leaveReDownloadedData> (optional): Leave all data in the table|Skip the deletion of data
<days_step> (optional): Number of days to query in a single batch
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<target_table_products> (optional): Table name to save the data to
<target_table_display> (optional): Table name to save the data to
<target_table_brands> (optional): Table name to save the data to
<target_table_keywords> (optional): Table name to save keyword data to
<label> (optional): Multitenancy label

Attribute

Type

Description

report_source

string

Source report name

tactic

string

Advertising tactic associated with campaign for sponsored display report

profileId

long

Profile Id

reportDate

date

The date of the performance report

campaignName

string

Unique name of the campaign

campaignId

long

Unique numerical ID of the campaign

campaignStatus

string

Current status of the campaign

campaignBudget

bigdecimal

Total budget allotted to the campaign

campaignBudgetType

string

One of: daily or lifetime

adGroupName

string

Unique name of the ad group

adGroupId

long

Unique numerical ID of the ad group

adid

long

The unique numerical ID of the ad

keywordId

long

ID of the keyword used in bid

keywordText

string

Text of the keyword or phrase used in bid

keywordStatus

string

Keyword state

keywordBid

bigdecimal

User-set bid value for keyword

matchType

string

Type of matching for the keyword or phrase used in bid. Must be one of: broad, phrase, or exact

placement

string

The optional dimension on which to segment a campaigns report. Placement refers to the location on a page where your ad appears

query

string

The optional dimension on which to segment a keyword report. This is also referred to as the search terms report

targetId

long

The identifier of the targeting expression used in a bid

targetingExpression

string

A string representation of your expression object in targeting clauses

targetingText

string

A resolved string representation of your expression object in targeting clauses

targetingType

string

Type of matching for the targeting expression used in bid. For manually created expressions this value is: TARGETING_EXPRESSION. For auto-targeting expressions this value is: TARGETING_EXPRESSION_PREDEFINED

clicks

bigdecimal

Total number of ad clicks associated with the campaign

cost

bigdecimal

The total cost of all ad clicks for the campaign. Divide cost by clicks to calculate average cost per click (CPC)

currency

string

The currency code associated with the campaign

impressions

bigdecimal

Total number of ad impressions

asin

string

The ASIN that is being advertised

sku

string

The SKU that is being advertised

attributedConversions1d

bigdecimal

Total number of attributed conversion events occuring within 24 hours of ad click

attributedConversions1dSameSKU

bigdecimal

Total number of attributed conversion events occuring within 24 hours of ad click, where the SKU of the product advertised and the SKU of the conversion event are equivalent

attributedSales1d

bigdecimal

Total number of attributed sales occuring within 24 hours of ad click

attributedSales1dSameSKU

bigdecimal

Aggregate value of all attributed sales occuring within 24 hours of ad click, where the SKU of the product advertised and the SKU of the purchased item are equivalent

attributedUnitsOrdered1d

bigdecimal

Total number of attributed units ordered within 24 hours of ad click

attributedUnitsOrdered1dSameSKU

bigdecimal

Total number of units ordered within 24 hours of ad click where the purchased SKU was the same as the SKU advertised

attributedConversions7d

bigdecimal

Total number of attributed conversion events occuring within 7 days of ad click

attributedConversions7dSameSKU

bigdecimal

Total number of attributed conversion events occuring within 7 days of ad click, where the SKU of the product advertised and the SKU of the conversion event are equivalent

attributedSales7d

bigdecimal

Total number of attributed sales occuring within 7 days of ad click

attributedSales7dSameSKU

bigdecimal

Aggregate value of all attributed sales occuring within 7 days of ad click, where the SKU of the product advertised and the SKU of the purchased item are equivalent

attributedUnitsOrdered7d

bigdecimal

Total number of attributed units ordered within 7 days of ad click

attributedConversions14d

bigdecimal

Total number of attributed conversion events occuring within 14 days of ad click

attributedConversions14dSameSKU

bigdecimal

Total number of attributed conversion events occuring within 14 days of ad click, where the SKU of the product advertised and the SKU of the conversion event are equivalent

attributedDPV14d

bigdecimal

Number of attributed detail page views occuring within 14 days of click on an ad

attributedDetailPageViewsClicks14d

bigdecimal

The number of detail page view conversions attributed to ad click-throughs within 14 days

attributedOrderRateNewToBrand14d

bigdecimal

The number of new-to-brand orders relative to the number of clicks

attributedOrdersNewToBrand14d

bigdecimal

The number of first-time orders for products within the brand over a one-year lookback window

attributedOrdersNewToBrandPercentage14d

bigdecimal

The percentage of total orders that are new-to-brand orders

attributedSales14d

bigdecimal

Number of attributed sales occurring within 14 days of click on an ad

attributedSales14dSameSKU

bigdecimal

Aggregate value of all attributed sales occuring within 14 days of ad click, where the SKU of the product advertised and the SKU of the purchased item are equivalent

attributedSalesNewToBrand14d

bigdecimal

The total sales of new-to-brand orders

attributedSalesNewToBrandPercentage14d

bigdecimal

The percentage of total sales of new-to-brand purchases

attributedUnitsOrdered14d

bigdecimal

Total number of attributed units ordered within 14 days of ad click

attributedUnitsOrderedNewToBrand14d

bigdecimal

The number of units from first-time orders for products within the brand over a one-year lookback window

attributedUnitsOrderedNewToBrandPercentage14d

bigdecimal

The percentage of total units that are units from new-to-brand orders

attributedUnitsSold14d

bigdecimal

Number of attributed units sold occurring within 14 days of click on an ad

dpv14d

bigdecimal

Number of attributed detail page views occurring within 14 days of click on an ad

attributedConversions30d

bigdecimal

Total number of attributed conversion events occuring within 30 days of ad click

attributedConversions30dSameSKU

bigdecimal

Total number of attributed conversion events occuring within 30 days of ad click, where the SKU of the product advertised and the SKU of the conversion event are equivalent

attributedSales30d

bigdecimal

Total number of attributed sales occuring within 30 days of ad click

attributedSales30dSameSKU

bigdecimal

Aggregate value of all attributed sales occuring within 30 days of ad click, where the SKU of the product advertised and the SKU of the purchased item are equivalent

attributedUnitsOrdered30d

bigdecimal

Total number of attributed units ordered within 30 days of ad click

isVideo

boolean

From Sponsored Brands video report

errorMessage

string

Error message if any problem happened

Display_AdGroups

Ad groups of sponsored display with extended fields

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<adGroupIdFilter> (optional): The returned array is filtered to include only ad groups with an identifier specified in the comma-delimited list
<campaignIdFilter> (optional): The returned array is filtered to include only ad groups associated with the campaign identifiers in the comma-delimited list
<name> (optional): The returned array includes only ad groups with the specified name
<stateFilter> (optional): The returned array is filtered to include only campaigns with state set to one of the values in the comma-delimited list
<adGroupId> (optional): The identifier of the requested ad group
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

adGroupId

long

The identifier of the ad group

campaignId

long

The identifier of the campaign that this ad group is associated with

defaultBid

bigdecimal

The amount of the default bid associated with the ad group. Used if no bid is specified

name

string

The name of the ad group

servingStatus

string

The status of the ad group

state

string

The delivery state of the ad group

creationDate

timestamp

Epoch time the ad group was created

lastUpdatedDate

timestamp

Epoch time any property in the ad group was last updated

Example

SQL
CREATE VIEW amazon_ads_examples.example_Display_AdGroups AS
    SELECT *
    FROM (
        CALL amazon_ads.Display_AdGroups (
            profileId => 0001,
            stateFilter => NULL,
            campaignIdFilter => NULL,
            adGroupIdFilter => NULL,
            name => NULL
        )
    ) AS x

Display_Campaigns

Campaigns of sponsored display with extended fields

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<campaignIdFilter> (optional): The returned array includes only campaigns with identifiers matching those specified in the comma-delimited string
<name> (optional): The returned array includes only campaign with the specified name using an exact string match
<stateFilter> (optional): The returned array is filtered to include only campaigns with state set to one of the values in the specified comma-delimited list
<campaignId> (optional): The identifier of the requested campaign
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

campaignId

long

The identifier of the campaign

startDate

date

The start date of the campaign. The date must be today or in the future

endDate

date

The end date of the campaign

budget

bigdecimal

The amount of the budget

budgetType

string

The time period over which the amount specified in the 'budget' property is allocated

costType

string

 

deliveryProfile

string

 

name

string

The name of the campaign

servingStatus

string

The status of the campaign

state

string

The state of the campaign

tactic

string

The advertising tactic associated with the campaign. The following table lists available tactic names: T00001, T00020, remarketing

creationDate

timestamp

Epoch date the campaign was created

lastUpdatedDate

timestamp

Epoch date of the last update to any property associated with the campaign

Example

SQL
CREATE VIEW amazon_ads_examples.example_Display_Campaigns AS
    SELECT *
    FROM (
        CALL amazon_ads.Display_Campaigns (
            profileId => 0001,
            stateFilter => NULL,
            name => NULL,
            campaignIdFilter => NULL
        )
    ) AS x

Display_ProductAds

Product ads of sponsored display with extended fields

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<adGroupIdFilter> (optional): The returned array is filtered to include only products ads associated with ad groups identifiers in the comma-delimited list
<adIdFilter> (optional): The returned array includes only product ads with identifiers matching those in the comma-delimited string
<campaignIdFilter> (optional): The returned array is filtered to include only product ads associated with the campaign identifiers in the comma-delimited list
<stateFilter> (optional): The returned array is filtered to include only campaigns with state set to one of the values in the specified comma-delimited list
<adId> (optional): The identifier of the requested product ad
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

adId

long

The identifier of the ad

adGroupId

long

The identifier of the ad group associated with the ad

asin

string

The ASIN of the product being advertised

campaignId

long

The identifier of the campaign associated with the ad

servingStatus

string

The status of the product ad

sku

string

The SKU of the product being advertised

state

string

The state of the product ad

creationDate

timestamp

Epoch date the product ad was created

lastUpdatedDate

timestamp

Epoch date of the last update to any property associated with the product ad

Example

SQL
CREATE VIEW amazon_ads_examples.example_Display_ProductAds AS
    SELECT *
    FROM (
        CALL amazon_ads.Display_ProductAds (
            profileId => 0001,
            stateFilter => NULL,
            adIdFilter => NULL,
            adGroupIdFilter => NULL,
            campaignIdFilter => NULL
        )
    ) AS x

Display_Report

Sponsored Display Reports
Parameter
<recordType> (required): The type of entity for which the report should be generated. Supported record types: asins, adGroups, campaigns, matchedTarget, productAds, targets
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<reportDate> (optional): The date to retrieve the performance report for
<reportDateEnd> (optional): The date to retrieve the performance reports for multiple days till
<tactic> (optional): The advertising tactic associated with the campaign. The following table lists available tactic names: T00020, T00030
<daysToRedownload> (optional): Re-download days|How many days to query into the past
<leaveReDownloadedData> (optional): Leave all data in the table|Skip the deletion of data
<days_step> (optional): Number of days to query in a single batch
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multitenancy label

Attribute

Type

Description

profileId

long

Profile Id

reportDate

date

The date of the performance report

tactic

string

The advertising tactic associated with the campaign

adGroupId

long

Unique numerical ID of the ad group.

adGroupName

string

The name of the ad group as entered by the advertiser.

adId

long

Unique numerical ID of the ad.

applicableBudgetRuleId

string

The ID associated to the active budget rule for Sponsored Brands campaigns. For more information, see Including budget rules values in Reports.

applicableBudgetRuleName

string

The name associated to the active budget rule for Sponsored Brands campaigns. For more information, see Including budget rules values in Reports.

asin

string

The ASIN associated to an advertised product.

attributedBrandedSearches14d

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click.

attributedConversions14d

integer

Number of attributed conversion events occurring within 14 days of an ad click.

attributedConversions14dOtherSKU

integer

The total number of attributed conversion events occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised.

attributedConversions14dSameSKU

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.

attributedConversions1d

integer

Number of attributed conversion events occurring within 24 hours of ad click.

attributedConversions1dSameSKU

integer

Number of attributed conversion events occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised.

attributedConversions30d

integer

Number of attributed conversion events occurring within 30 days of an ad click.

attributedConversions30dOtherSKU

integer

The total number of attributed conversion events occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised.

attributedConversions30dSameSKU

integer

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.

attributedConversions7d

integer

Number of attributed conversion events occurring within seven days of an ad click.

attributedConversions7dOtherSKU

integer

The total number of attributed conversion events occurring within seven days of an ad click where the purchased SKU was different from the SKU advertised.

attributedConversions7dSameSKU

integer

Number of attributed conversion events occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised.

attributedDPV14d

integer

This metric is in beta. Number of attributed detail page views occurring within 14 days of ad click.

attributedOrdersNewToBrand14d

integer

The number of first-time orders for brand products over a one-year lookback window. Not available for book vendors.

attributedSales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click.

attributedSales14dOtherSKU

bigdecimal

Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised.

attributedSales14dSameSKU

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.

attributedSales1d

bigdecimal

Total value of sales occurring within 24 hours of an ad click.

attributedSales1dOtherSKU

bigdecimal

Total value of sales occurring within 24 hours of an ad click where the purchased SKU was different from the SKU advertised.

attributedSales1dSameSKU

bigdecimal

Total value of sales occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised.

attributedSales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click.

attributedSales30dOtherSKU

bigdecimal

Total value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised.

attributedSales30dSameSKU

bigdecimal

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.

attributedSales7d

bigdecimal

Total value of sales occurring within seven days of an ad click.

attributedSales7dOtherSKU

bigdecimal

Total value of sales occurring within seven days of an ad click where the purchased SKU was different from the SKU advertised.

attributedSales7dSameSKU

bigdecimal

Total value of sales occurring within seven days of ad click where the purchased SKU was the same as the SKU advertised.

attributedSalesNewToBrand14d

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors.

attributedUnitsOrdered14d

integer

Total number of units ordered within 14 days of an ad click.

attributedUnitsOrdered14dOtherSKU

integer

Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised.

attributedUnitsOrdered1d

integer

Total number of units ordered within 24 hours of an ad click.

attributedUnitsOrdered1dOtherSKU

integer

Total number of units ordered within 24 hours of an ad click where the purchased SKU was different from the SKU advertised.

attributedUnitsOrdered30d

integer

Total number of units ordered within 30 days of an ad click.

attributedUnitsOrdered30dOtherSKU

integer

Total number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised.

attributedUnitsOrdered7d

integer

Total number of units ordered within 7 days of an ad click.

attributedUnitsOrdered7dOtherSKU

integer

Total number of units ordered within seven days of an ad click where the purchased SKU was different from the SKU advertised.

attributedUnitsOrderedNewToBrand14d

integer

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.

avgImpressionsFrequency

bigdecimal

Average number of times unique users were exposed to an ad over the lifetime of the campaign.

bidOptimization

string

Bid optimization for Sponsored Display ad groups. For vCPM campaigns, the value is always reach. For CPC campaigns, value is either clicks or conversions.

campaignBudget

bigdecimal

Total budget allocated to the campaign.

campaignId

long

Unique numerical ID of a campaign.

campaignName

string

The name of the campaign as entered by the advertiser.

campaignRuleBasedBudget

bigdecimal

The value of the rule-based budget for Sponsored Brands campaigns. For more information, see Including budget rules values in Reports.

campaignStatus

string

Current status of the campaign. One of active, paused, or archived.

clicks

integer

Total number of ad clicks.

cost

bigdecimal

Total cost of ad clicks.

costType

string

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click). Only relevant for Sponsored Display campaigns.

cumulativeReach

integer

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.

currency

string

The currency code associated with the campaign.

impressions

integer

Total number of ad impressions.

otherAsin

string

Represents a product that was purchased after an ad click but has a different SKU/ASIN that what was advertised.

sku

string

The SKU being advertised. Not available for vendors.

targetId

long

The identifier of the targeting expression.

targetingExpression

string

A string representation of the expression object used in the targeting clause.

targetingText

string

The text used in the targeting expression.

targetingType

string

The type of targeting used in the expression.

vctr

bigdecimal

Click-through rate for views (clicks divided by views).

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%.

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%.

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%.

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%.

videoUnmutes

integer

The number of impressions where a customer unmuted the video.

viewAttributedBrandedSearches14d

integer

For Sponsored Display vCPM campaigns, this is the number of searches that included the name of your brand occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedBrandedSearches14d.

viewAttributedConversions14d

integer

For Sponsored Display vCPM campaigns, the total number of attributed conversion events occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedConversions14d.

viewAttributedConversions14dOtherSKU

integer

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. For CPC campaigns, this value is equal to attributedConversions14dOtherSKU.

viewAttributedConversions1dOtherSKU

integer

For Sponsored Display vCPM campaigns, the total number of attributed conversion events occurring within 24 hours of an ad click or view where the purchased SKU was different from the SKU advertised. For CPC campaigns, this value is equal to attributedConversions1dOtherSKU.

viewAttributedConversions30dOtherSKU

integer

For Sponsored Display vCPM campaigns, the total number of attributed conversion events occurring within 30 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 attributedConversions30dOtherSKU.

viewAttributedConversions7dOtherSKU

integer

For Sponsored Display vCPM campaigns, the total number of attributed conversion events occurring within seven 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 attributedConversions7dOtherSKU.

viewattributedDPV14d

integer

This metric is in beta. For Sponsored Display vCPM campaigns, the total number of attributed detail page views occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedDPV14d.

viewAttributedOrdersNewToBrand14d

integer

For Sponsored Display vCPM campaigns, the number of first-time orders for brand products over a one-year lookback window. Not available for book vendors. For CPC campaigns, this value is equal to attributedOrdersNewToBrand14d.

viewAttributedSales14d

bigdecimal

For Sponsored Display vCPM campaigns, the total value of sales occurring within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedSales14d.

viewAttributedSales14dOtherSKU

bigdecimal

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. For CPC campaigns, this value is equal to attributedSales14dOtherSKU.

viewAttributedSales1dOtherSKU

bigdecimal

For Sponsored Display vCPM campaigns, the total value of sales occurring within 24 hours of an ad click or view where the purchased SKU was different from the SKU advertised. For CPC campaigns, this value is equal to attributedSales1dOtherSKU.

viewAttributedSales30dOtherSKU

bigdecimal

For Sponsored Display vCPM campaigns, the total value of sales occurring within 30 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 attributedSales30dOtherSKU.

viewAttributedSales7dOtherSKU

bigdecimal

For Sponsored Display vCPM campaigns, the total value of sales occurring within seven 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 attributedSales7dOtherSKU.

viewAttributedSalesNewToBrand14d

bigdecimal

For Sponsored Display vCPM campaigns, the total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors. For CPC campaigns, this value is equal to attributedSalesNewToBrand14d.

viewAttributedUnitsOrdered14d

integer

For Sponsored Display vCPM campaigns, the total number of units ordered within 14 days of an ad click or view. For CPC campaigns, this value is equal to attributedUnitsOrdered14d.

viewAttributedUnitsOrdered14dOtherSKU

integer

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.

viewAttributedUnitsOrdered1dOtherSKU

integer

For Sponsored Display vCPM campaigns, the total number of units ordered within 24 hours of an ad click or view where the purchased SKU was different from the SKU advertised. For CPC campaigns, this value is equal to attributedUnitsOrdered1dOtherSKU.

viewAttributedUnitsOrdered30dOtherSKU

integer

For Sponsored Display vCPM campaigns, the total number of units ordered within 30 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 attributedUnitsOrdered30dOtherSKU.

viewAttributedUnitsOrdered7dOtherSKU

integer

For Sponsored Display vCPM campaigns, the total number of units ordered within seven 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 attributedUnitsOrdered7dOtherSKU.

viewAttributedUnitsOrderedNewToBrand14d

integer

For Sponsored Display vCPM campaigns, the 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. For CPC campaigns, this value is equal to attributedUnitsOrderedNewToBrand14d.

viewImpressions

integer

The total number of viewable impressions. Only relevant for Sponsored Display vCPM campaigns.

vtr

bigdecimal

View-through rate (vtr). Views divided by impressions.

errorMessage

string

Error message if any problem happened

Display_SuggestedProducts

Products eligible for advertising using the specified tactic type. Each product in the list includes an associated readiness status

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<tacticFilter> (required): The list in the response is filtered to include only products that are eligible for advertising using the requested tactic. The currently available tactic identifiers are: T00010, remarketing
<readinessFilter> (optional): The returned response is filtered to include only eligible products with a readiness status value that matches those specified in the comma-delimited string
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

asins

string

A list of ASINs

readinessStatus

string

One of the following: HIGH, MEDIUM, LOW

Example

SQL
CREATE VIEW amazon_ads_examples.example_Display_SuggestedProducts AS
    SELECT *
    FROM (
        CALL amazon_ads.Display_SuggestedProducts (
            profileId => 0001,
            tacticFilter => 'remarketing',
            readinessFilter => NULL
        )
    ) AS x

Display_Targets

Targeting clause objects of sponsored display with extended fields

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<adGroupIdFilter> (optional): optional list of comma separated adGroupIds. Restricts results to targeting clauses with the specified 'adGroupId'
<campaignIdFilter> (optional): Restricts results to ads within campaigns specified in comma-separated list
<stateFilter> (optional): Restricts results to keywords with state within the specified comma-separated list. Must be one of: 'enabled', 'paused', or 'archived'. Default behavior is to include enabled, paused, and archived
<targetIdFilter> (optional): Restricts results to ads with the specified 'tagetId' specified in comma-separated list
<targetId> (optional): The identifier of a targeting clause
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

targetId

long

The identifier of the targeting expression used in a bid

adGroupId

long

The identifier of the ad group

bid

bigdecimal

If a value for 'bid' is specified, it overrides the current adGroup bid. Note that this field is ignored for negative targeting clauses

expression

string

The targeting expression to match against

resolvedExpression

string

 

servingStatus

string

The status of the target

state

string

One of the following: enabled, paused, archived

creationDate

timestamp

Epoch date the target was created

lastUpdatedDate

timestamp

Epoch date of the last update to any property associated with the target

Example

SQL
CREATE VIEW amazon_ads_examples.example_Display_Targets AS
    SELECT *
    FROM (
        CALL amazon_ads.Display_Targets (
            profileId => 0001,
            stateFilter => NULL,
            targetIdFilter => NULL,
            adGroupIdFilter => NULL,
            campaignIdFilter => NULL
        )
    ) AS x

History

History of changes for provided event sources that match the filters and time ranges specified

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<fromDate> (optional): Start from date. Max 90 days of history
<toDate> (optional): Finish to date
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

timestamp

timestamp

Timestamp

changeType

string

Change type for Entity types

entityType

string

Entity type

entityId

string

Entity id

newValue

string

New value

previousValue

string

Previous value

metadata_productTargetingType

string

Product targeting type

metadata_programType

string

Program type

metadata_campaignId

string

Campaign id

metadata_campaignBudgetType

string

Campaign budget type

metadata_keywordType

string

Keyword type

metadata_predefinedTarget

string

Predefined target

metadata_keyword

string

Keyword

metadata_adAsin

string

Ad asin

metadata_targetingExpression

string

Targeting expression

metadata_placementGroupPosition

string

Placement group position

metadata_negativeTargetingType

string

Negative targeting type

metadata_adGroupId

string

AdGroup id

Example

SQL
CREATE VIEW amazon_ads_examples.example_History AS
    SELECT *
    FROM (
        CALL amazon_ads.History (
            profileId => 3394093858963275,
            fromDate => TIMESTAMPADD (SQL_TSI_MONTH, -1, CURDATE ()),
            toDate => CURDATE ()
        )
    ) AS x

Invoices

Invoices for advertiser

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<invoiceStatuses> (optional): Invoice status: - ISSUED: An invoice is issued when its charges are finalized and tax is computed on the total amount; - PAID_IN_PART: When a partial payment is received, the invoice status will change to paid in part; - PAID_IN_PART: One full payment has been received, the invoice will be paid in full; - WRITTEN_OFF: If an invoice is written off because of an error, the status will be updated to written off
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

fromDate

date

From date

toDate

date

To date

id

string

Invoice Id

invoiceDate

date

Invoice date

dueDate

date

Due date

status

string

Invoice Status: - ISSUED: An invoice is issued when its charges are finalized and tax is computed on the total amount; - PAID_IN_PART: When a partial payment is received, the invoice status will change to paid in part; - PAID_IN_PART: One full payment has been received, the invoice will be paid in full; - WRITTEN_OFF: If an invoice is written off because of an error, the status will be updated to written off

purchaseOrderNumber

string

Account-level purchase order number

paymentMethod

string

Payment method: CREDIT_CARD, ELECTRONIC_FUNDS_TRANSFER, DEDUCT_FROM_PAYMENT, UNIFIED_BILLING

amountDue_amount

bigdecimal

Amount due

amountDue_currencyCode

string

The currency used for all monetary values for entities under this profile

taxAmountDue_amount

bigdecimal

Amount due

taxAmountDue_currencyCode

string

The currency used for all monetary values for entities under this profile

remainingAmountDue_amount

bigdecimal

Remaining Amount due

remainingAmountDue_currencyCode

string

The currency used for all monetary values for entities under this profile

remainingTaxAmountDue_amount

bigdecimal

Amount due

remainingTaxAmountDue_currencyCode

string

The currency used for all monetary values for entities under this profile

Example

SQL
CREATE VIEW amazon_ads_examples.example_Invoices AS
    SELECT *
    FROM (
        CALL amazon_ads.Invoices (
            profileId => 1384439365692608,
            invoiceStatuses => 'PAID_IN_FULL'
        )
    ) AS x

Keywords

Ad group or campaign-level biddable or negative keywords based on the specified criteria PLANNED API DEPRECATION June 30, 2023
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<negative> (optional): If true, will return negative keywords. Biddable otherwise (and default)
<campaignLevel> (optional): If true, will return campaign-level keywords. AdGroup otherwise (and default)
<keywordId> (optional): Keyword ID
<extended> (optional): Retrieve keywords along with additional properties
<campaignType> (optional): Campaign type
<matchTypeFilter> (optional): Match type filter
<keywordText> (optional): Keyword text
<stateFilter> (optional): State filter
<campaignIdFilter> (optional): Campaign ID filter
<adGroupIdFilter> (optional): Ad group ID filter
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

keywordId

long

Keyword ID

adGroupId

long

Ad group ID

campaignId

long

Campaign ID

keywordText

string

Keyword text

nativeLanguageKeyword

string

The unlocalized keyword text in the preferred locale of the advertiser

bid

bigdecimal

id associated with this keyword. Applicable to biddable match types only

matchType

string

Match type

state

string

State

servingStatus

string

Serving status

creationDate

timestamp

Creation date

lastUpdatedDate

timestamp

Last update date

Example

SQL
CREATE VIEW amazon_ads_examples.example_Keywords AS
    SELECT * FROM (
        CALL amazon_ads.Keywords (
            profileId => 0001,
            extended => true,
            campaignType => null,
            matchTypeFilter => null,
            keywordText => null,
            stateFilter => null,
            campaignIdFilter => null,
            adGroupIdFilter => 0005,
            target_table => null,
            preview => true,
            label => null
        )
    )x

Keywords_Suggested

Suggested keywords for specified ad group
Parameter
<profileId> (optional): Profile ID
<adGroupId> (optional): Ad group ID
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

adGroupId

long

Ad group ID

keywordText

string

Keyword text

matchType

string

Match type

Example

SQL
CREATE VIEW amazon_ads_examples.example_Keywords_Suggested AS
    SELECT * FROM (
        CALL amazon_ads.Keywords_Suggested (
            profileId => 0001,
            adGroupId => 0004,
            preview => true
        )
    )x

ManagerAccounts

Manager accounts that a user has access to, along with metadata for all of the Amazon Advertising accounts that are linked to the Manager account

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

managerAccountId

string

Id of the Manager Account

managerAccountName

string

The name given to a Manager Account

linkedAccounts_accountId

string

Id of the Amazon Advertising account

linkedAccounts_accountName

string

The name given to the Amazon Advertising account

linkedAccounts_accountType

string

Type of the Amazon Advertising account

linkedAccounts_marketplaceId

string

The identifier of the marketplace to which the account is associated. See this table for marketplaceId mappings

linkedAccounts_profileId

string

The identifier of a profile associated with the advertiser account. Note that this value is only populated for a subset of account types: [ SELLER, VENDOR, MARKETING_CLOUD ]. It will be null for accounts of other types

Example

SQL
CREATE VIEW amazon_ads_examples.example_ManagerAccounts AS
    SELECT *
    FROM (
        CALL amazon_ads.ManagerAccounts (
            profileId => 2480654271163770
        )
    ) AS x

Portfolios

Portfolios that consist of campaigns that are grouped together and linked to a distinct Advertiser Account

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<portfolioId> (optional): Retrieve a portfolio by ID
<extended> (optional): Retrieve a portfolio along with additional properties
<portfolioIdFilter> (optional): Restricts results to portfolios with ID within the specified comma-separated list
<portfolioNameFilter> (optional): Restricts results to portfolios within names specified in comma-separated list
<portfolioStateFilter> (optional): Restricts results to portfolios with state specified in comma-separated list
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

portfolioId

long

ID of the portfolio

name

string

Name of the portfolio

budget_amount

bigdecimal

Bdget amount

budget_currencyCode

string

Currency code of the budget

budget_policy

string

Policy of the portfolio

budget_startDate

date

Start date of the portfolio

budget_endDate

date

End date of the portfolio

inBudget

boolean

States if the portfolio is still within budget

state

string

Status of the portfolio

creationDate

timestamp

Date the portfolio was created

lastUpdatedDate

timestamp

Date the portfolio was last updated

servingStatus

string

Serving status of the portfolio

Example

SQL
CREATE VIEW amazon_ads_examples.example_Portfolios AS
    SELECT * FROM (
        CALL amazon_ads.Portfolios (
            profileId => 0001,
            extended => true,
            preview => true
        )
    ) x

ProductAds

Product ads satisfying optional criteria PLANNED API DEPRECATION June 30, 2023
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<adId> (optional): Returns single Ad, rather than list
<extended> (optional): Retrieve product ads along with additional properties
<sku> (optional): Restricts results to product ads with the specified sku
<asin> (optional): Restricts results to product ads with the specified asin
<stateFilter> (optional): Restricts results to ads with state within the specified comma-separated list. Must be one of: enabled, paused, archived. Default behavior is to include all
<campaignIdFilter> (optional): Restricts results to ads within campaigns specified in comma-separated list
<adGroupIdFilter> (optional): Restricts results to ads within ad groups specified in comma-separated list
<adIdFilter> (optional): Restricts results to ads with the specified product ad Id specified in comma-separated list
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

adId

long

ID of the product ad

campaignId

long

ID of the campaign to which this product ad belongs

adGroupId

long

ID of the ad group to which this product ad belongs

sku

string

SKU for the listed product to be advertised

asin

string

ASIN for the listed product to be advertised

state

string

Advertiser-specified state of the product ad

creationDate

timestamp

Date the ad group was created

lastUpdatedDate

timestamp

Date the ad group was last updated

servingStatus

string

Computed status, accounting for out of budget, policy violations, etc.

Example

SQL
CREATE VIEW amazon_ads_examples.example_ProductAds AS
    SELECT * FROM (
        CALL amazon_ads.ProductAds (
            profileId => 0001,
            extended => true,
            preview => true
        )
    )x

Profiles

Profiles associated with credentials

Parameter
<profileId> (optional): Return one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return one or more profiles for the mentioned in CSV list of account Ids
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

countryCode

string

Country code identifying the publisher(s) on which ads will run

currencyCode

string

Currency used for all monetary values for entities under this profile

dailyBudget

bigdecimal

Optional budget shared by all entities created under this profile

timezone

string

Tz database time zone used for all date-based campaign management and reporting

marketplaceStringId

string

Identifier for the marketplace associated with this profile. This is the same identifier used by MWS

account_id

string

Identifier for the ID associated with this account

account_name

string

Identifier for the account name

account_type

string

 

account_subType

string

 

validPaymentMethod

string

 

Example

SQL
CREATE VIEW amazon_ads_examples.example_Profiles AS
    SELECT * FROM (
        CALL amazon_ads.Profiles(
            profileId => null
        )
    ) x

Report_Brands_AdGroup

Sponsored Brands : Ad Group Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: adGroup
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

adStatus

string

Status of the ad group.

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignBudgetType

string

One of daily or lifetime

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

costType

string

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

impressions

integer

Total number of ad impressions

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViews

integer

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

newToBrandDetailPageViewsClicks

integer

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

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandPurchasesPercentage

bigdecimal

The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.

newToBrandPurchasesRate

bigdecimal

The percentage of total orders that are new-to-brand orders. Not available for book vendors

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandSalesPercentage

bigdecimal

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

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

newToBrandUnitsSoldPercentage

bigdecimal

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

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromoted

integer

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

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesPromoted

bigdecimal

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

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks

integer

Number of attributed units sold within 14 days of an ad click

video5SecondViewRate

bigdecimal

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

video5SecondViews

integer

The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands video-only metric

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Brands_AdGroup AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Brands_AdGroup (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Brands_Ads

Sponsored Brands : Ads Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: ads
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

adId

long

Unique numerical ID of the ad

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignBudgetType

string

One of daily or lifetime

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

costType

string

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

impressions

integer

Total number of ad impressions

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViews

integer

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

newToBrandDetailPageViewsClicks

integer

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

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandPurchasesPercentage

bigdecimal

The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.

newToBrandPurchasesRate

bigdecimal

The percentage of total orders that are new-to-brand orders. Not available for book vendors

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandSalesPercentage

bigdecimal

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

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

newToBrandUnitsSoldPercentage

bigdecimal

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

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromoted

integer

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

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesPromoted

bigdecimal

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

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks

integer

Number of attributed units sold within 14 days of an ad click

video5SecondViewRate

bigdecimal

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

video5SecondViews

integer

The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands video-only metric

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

viewableImpressions

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Brands_Ads AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Brands_Ads (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Brands_CampaignPlacement

Sponsored Brands : Campaign Placement Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: campaignPlacement,campaign
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignBudgetType

string

One of daily or lifetime

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

costType

string

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

impressions

integer

Total number of ad impressions

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViews

integer

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

newToBrandDetailPageViewsClicks

integer

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

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandPurchasesPercentage

bigdecimal

The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.

newToBrandPurchasesRate

bigdecimal

The percentage of total orders that are new-to-brand orders. Not available for book vendors

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandSalesPercentage

bigdecimal

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

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

newToBrandUnitsSoldPercentage

bigdecimal

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

placementClassification

string

The page location where an ad appeared

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromoted

integer

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

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesPromoted

bigdecimal

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

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks

integer

Number of attributed units sold within 14 days of an ad click

video5SecondViewRate

bigdecimal

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

video5SecondViews

integer

The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands video-only metric

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

viewableImpressions

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

viewClickThroughRate

bigdecimal

Click-through rate for views (clicks divided by views)

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Brands_CampaignPlacement AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Brands_CampaignPlacement (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;

Report_Brands_Campaigns

Sponsored Brands : Campaigns Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: campaign
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignBudgetType

string

One of daily or lifetime

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

costType

string

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

impressions

integer

Total number of ad impressions

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViews

integer

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

newToBrandDetailPageViewsClicks

integer

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

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandPurchasesPercentage

bigdecimal

The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.

newToBrandPurchasesRate

bigdecimal

The percentage of total orders that are new-to-brand orders. Not available for book vendors

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandSalesPercentage

bigdecimal

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

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

newToBrandUnitsSoldPercentage

bigdecimal

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

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromoted

integer

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

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesPromoted

bigdecimal

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

topOfSearchImpressionShare

bigdecimal

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

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks

integer

Number of attributed units sold within 14 days of an ad click

video5SecondViewRate

bigdecimal

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

video5SecondViews

integer

The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands video-only metric

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

viewableImpressions

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

viewClickThroughRate

bigdecimal

Click-through rate for views (clicks divided by views)

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Brands_Campaigns AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Brands_Campaigns (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Brands_GrossAndInvalids

Sponsored Brands : Gross And Invalids Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: campaign
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

clicks

integer

Total number of clicks on an ad

grossClickThroughs

integer

The total number of times the ad was clicked. This includes valid, potentially fraudulent, non-human, and other illegitimate clicks

grossImpressions

integer

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

integer

Total number of ad impressions

invalidClickThroughRate

bigdecimal

The percentage of gross click-throughs that were removed by the traffic quality filter. (Invalid click-throughs rate = invalid click-throughs / gross click-throughs)

invalidClickThroughs

integer

Clicks that were removed by the traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic

invalidImpressionRate

bigdecimal

The percentage of gross impressions that were removed by the traffic quality filter. (Invalid impression rate = invalid impressions / gross impressions)

invalidImpressions

integer

The number of impressions removed by a traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Brands_GrossAndInvalids AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Brands_GrossAndInvalids (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Brands_PurchasedProducts

Sponsored Brands : Purchased Products Report v.3

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

date

date

Date when the ad activity occurred in the format YYYY-MM-DD

adGroupName

string

The name of the ad group as entered by the advertiser

attributionType

string

Describes whether a purchase is attributed to a promoted product or brand-halo effect

budgetCurrency

string

The currency code

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignName

string

The name associated with a campaign

newToBrandOrders14d

integer

The number of orders

newToBrandOrdersPercentage14d

bigdecimal

The percentage of orders

newToBrandPurchases14d

integer

The number of first-time orders for brand products over a one-year lookback window. Not available for book vendors

newToBrandPurchasesPercentage14d

bigdecimal

The percentage of total orders that are new-to-brand orders. Not available for book vendors

newToBrandSales14d

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandSalesPercentage14d

bigdecimal

Percentage of total sales made up of new-to-brand purchases. Not available for book vendors

newToBrandUnitsSold14d

integer

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

newToBrandUnitsSoldPercentage14d

bigdecimal

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

orders14d

integer

Orders within the last 14 days

productCategory

string

The category the product is associated with on Amazon

productName

string

The name of the product

purchasedAsin

string

The ASIN of the product that was purchased

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click

unitsSold14d

integer

Number of attributed units sold within 14 days of click on an ad. Vendor-only field. Same as unitsSoldClicks14d

Example

SQL
CREATE VIEW amazon_ads_examples.example_Report_Brands_PurchasedProducts AS
    SELECT *
    FROM (
        CALL amazon_ads.Report_Brands_PurchasedProducts (
            groupBy => NULL,
            startDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
            endDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
        )  
) AS x;;

Report_Brands_SearchTerms

Sponsored Brands : Search Term Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: searchTerm
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

keywordId

long

ID associated with a keyword or targeting expression

keywordText

string

Text of the keyword.

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

adKeywordStatus

string

Current status of a keyword

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignBudgetType

string

One of daily or lifetime

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

costType

string

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).

impressions

integer

Total number of ad impressions

keywordBid

bigdecimal

Bid associated with a keyword or targeting expression

matchType

string

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: TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

searchTerm

string

The search term used by the customer. Same as query

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

video5SecondViewRate

bigdecimal

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

video5SecondViews

integer

The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands video-only metric

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

viewableImpressions

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

viewClickThroughRate

bigdecimal

Click-through rate for views (clicks divided by views)

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Brands_SearchTerms AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Brands_SearchTerms (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Brands_Targeting

Sponsored Brands : Targeting Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: targeting
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

keywordId

long

ID associated with a keyword or targeting expression

keywordText

string

Text of the keyword.

keywordType

string

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: TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

adKeywordStatus

string

Current status of a keyword

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignBudgetType

string

One of daily or lifetime

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

costType

string

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

impressions

integer

Total number of ad impressions

keywordBid

bigdecimal

Bid associated with a keyword or targeting expression

matchType

string

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: TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViews

integer

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

newToBrandDetailPageViewsClicks

integer

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

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandPurchasesPercentage

bigdecimal

The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.

newToBrandPurchasesRate

bigdecimal

The percentage of total orders that are new-to-brand orders. Not available for book vendors

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandSalesPercentage

bigdecimal

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

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

newToBrandUnitsSoldPercentage

bigdecimal

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

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromoted

integer

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

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesPromoted

bigdecimal

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

targetingExpression

string

A string representation of the expression object used in the targeting clause

targetingId

long

The identifier of the targeting expression

targetingText

string

The text used in the targeting expression

targetingType

string

The type of targeting used in the expression

topOfSearchImpressionShare

bigdecimal

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

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Brands_Targeting AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Brands_Targeting (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Consolidated_AdGroup

Consolidated Report for Ad Group v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): The date to retrieve the performance report for
<endDate> (optional): The date to retrieve the performance reports for multiple days till
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<target_table_Brands> (optional): Table name to save the data for Brands
<target_table_Display> (optional): Table name to save the data for Display
<target_table_Products> (optional): Table name to save the data for Products
<target_table_Television> (optional): Table name to save the data for Television
<label> (optional): Multitenancy label

Attribute

Type

Description

report_source

string

Source report name

profileId

long

Profile Id

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignName

string

The name associated with a campaign

campaignId

long

The ID associated with a campaign

campaignStatus

string

The status of a campaign

campaignBudgetType

string

One of daily or lifetime

adGroupName

string

The name of the ad group as entered by the advertiser

adGroupId

long

Unique numerical ID of the ad group

adStatus

string

Status of the ad group.

portfolioId

long

The portfolio the campaign is associated with

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

impressions

integer

Total number of ad impressions

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToCartViews

integer

Number of times shoppers added the brands' products to their cart, attributed to an ad view

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

addToListFromViews

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view

attributedSalesSameSku14d

bigdecimal

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

attributedSalesSameSku1d

bigdecimal

Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku30d

bigdecimal

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku7d

bigdecimal

Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

bidOptimization

string

Bid optimization for Sponsored Display ad groups. For vCPM campaigns, the value is always reach. For CPC campaigns, value is either clicks or conversions

brandedSearchRate

bigdecimal

Rate of Branded Searches relative to the number of impressions. (BS/Impressions)

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

brandedSearchesViews

integer

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

campaignApplicableBudgetRuleId

long

The ID associated to the active budget rule for a campaign

campaignApplicableBudgetRuleName

string

The name associated to the active budget rule for a campaign

campaignBiddingStrategy

string

The bidding strategy associated with a campaign

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignRuleBasedBudgetAmount

bigdecimal

The value of the rule-based budget for a campaign

clickThroughRate

bigdecimal

Clicks divided by impressions

costPerClick

bigdecimal

Total cost divided by total number of clicks

costPerThousandImpressions

bigdecimal

The cost per thousand impressions

costType

string

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).

cumulativeReach

integer

Total unduplicated audience reached

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

detailPageViewsViews

integer

The number of times a product detail page was viewed attributed to an ad view

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

eCPBrandSearch

bigdecimal

Effective (average) cost to acquire a Branded Search

impressionsFrequencyAverage

bigdecimal

Average number of times unique users were exposed to an ad over the lifetime of the campaign

impressionsViews

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

leadFormOpens

integer

The number of times your lead forms were opened

leads

integer

The number of leads collected through your lead generation campaigns

linkOuts

integer

The number of times link-outs to landing page were clicked.

newToBrandDetailPageViewClicks

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViewViews

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad view

newToBrandDetailPageViews

integer

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

newToBrandDetailPageViewsClicks

integer

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

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandPurchasesPercentage

bigdecimal

The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.

newToBrandPurchasesRate

bigdecimal

The percentage of total orders that are new-to-brand orders. Not available for book vendors

newToBrandPurchasesViews

integer

The number of new to branch purchases attributed to an ad view

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandSalesPercentage

bigdecimal

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

newToBrandSalesViews

bigdecimal

Total value of sales by new to brand customers occurring within 14 days of an ad view.

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

newToBrandUnitsSoldPercentage

bigdecimal

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

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click. Sponsored Products only

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromoted

integer

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

purchasesPromotedClicks

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku14d

integer

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

purchasesSameSku1d

integer

Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku30d

integer

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku7d

integer

Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesViews

integer

Number of attributed conversion events occurring within 14 days of an ad view

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromViews

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

roas

bigdecimal

Return on ad spend

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromViews

integer

Estimated royalty payment attributed to Kindle Unlimited users who viewed the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click. Includes sales attributed to both clicks and views for vCPM campaigns, but only sales attributed to clicks for CPC campaigns

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesPromoted

bigdecimal

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

salesPromotedClicks

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

salesViews

bigdecimal

Total value of sales occurring within 14 days of an ad view.

spend

bigdecimal

Total cost of ad clicks

topOfSearchImpressionShare

bigdecimal

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

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks

integer

Number of attributed units sold within 14 days of an ad click

unitsSoldClicks14d

integer

Total number of units sold within 14 days of an ad click

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldSameSku14d

integer

Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku1d

integer

Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku30d

integer

Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku7d

integer

Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldViews

integer

Number of attributed units sold within 14 days of an ad view

video5SecondViewRate

bigdecimal

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

video5SecondViews

integer

The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands video-only metric

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewClickThroughRate

bigdecimal

Click-through rate for views (clicks divided by views)

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

errorMessage

string

Error message if any problem happened

Report_Consolidated_AdvertisedProduct

Consolidated Report for Advertised Product v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): The date to retrieve the performance report for
<endDate> (optional): The date to retrieve the performance reports for multiple days till
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<target_table_Display> (optional): Table name to save the data for Display
<target_table_Products> (optional): Table name to save the data for Products
<label> (optional): Multitenancy label

Attribute

Type

Description

report_source

string

Source report name

profileId

long

Profile Id

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignName

string

The name associated with a campaign

campaignId

long

The ID associated with a campaign

campaignStatus

string

The status of a campaign

campaignBudgetType

string

One of daily or lifetime

adGroupName

string

The name of the ad group as entered by the advertiser

adGroupId

long

Unique numerical ID of the ad group

adId

long

Unique numerical ID of the ad

portfolioId

long

The portfolio the campaign is associated with

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

impressions

integer

Total number of ad impressions

acosClicks14d

bigdecimal

Advertising cost of sales based on purchases made within 14 days of an ad click

acosClicks7d

bigdecimal

Advertising cost of sales based on purchases made within 7 days of an ad click

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToCartViews

integer

Number of times shoppers added the brands' products to their cart, attributed to an ad view

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

addToListFromViews

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view

advertisedAsin

string

The ASIN associated to an advertised product

advertisedSku

string

The SKU being advertised. Not available for vendors

attributedSalesSameSku14d

bigdecimal

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

attributedSalesSameSku1d

bigdecimal

Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku30d

bigdecimal

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku7d

bigdecimal

Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

bidOptimization

string

Bid optimization for Sponsored Display ad groups. For vCPM campaigns, the value is always reach. For CPC campaigns, value is either clicks or conversions

brandedSearchRate

bigdecimal

Rate of Branded Searches relative to the number of impressions. (BS/Impressions)

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

brandedSearchesViews

integer

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

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

clickThroughRate

bigdecimal

Clicks divided by impressions

costPerClick

bigdecimal

Total cost divided by total number of clicks

cumulativeReach

integer

Total unduplicated audience reached

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

eCPBrandSearch

bigdecimal

Effective (average) cost to acquire a Branded Search

impressionsFrequencyAverage

bigdecimal

Average number of times unique users were exposed to an ad over the lifetime of the campaign

impressionsViews

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

leadFormOpens

integer

The number of times your lead forms were opened

leads

integer

The number of leads collected through your lead generation campaigns

linkOuts

integer

The number of times link-outs to landing page were clicked.

newToBrandDetailPageViewClicks

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViewViews

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad view

newToBrandDetailPageViews

integer

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

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

promotedAsin

string

The ASIN associated to an advertised product

promotedSku

string

The SKU being advertised. Not available for vendors

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click. Sponsored Products only

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromotedClicks

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku14d

integer

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

purchasesSameSku1d

integer

Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku30d

integer

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku7d

integer

Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromViews

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

roasClicks14d

bigdecimal

Return on ad spend based on purchases made within 14 days of an ad click

roasClicks7d

bigdecimal

Return on ad spend based on purchases made within 7 days of an ad click

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromViews

integer

Estimated royalty payment attributed to Kindle Unlimited users who viewed the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click. Includes sales attributed to both clicks and views for vCPM campaigns, but only sales attributed to clicks for CPC campaigns

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesOtherSku7d

bigdecimal

Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised

salesPromotedClicks

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

spend

bigdecimal

Total cost of ad clicks

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks

integer

Number of attributed units sold within 14 days of an ad click

unitsSoldClicks14d

integer

Total number of units sold within 14 days of an ad click

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldOtherSku7d

integer

Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldSameSku14d

integer

Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku1d

integer

Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku30d

integer

Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku7d

integer

Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewClickThroughRate

bigdecimal

Click-through rate for views (clicks divided by views)

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

errorMessage

string

Error message if any problem happened

Report_Consolidated_CampaignPlacement

Consolidated Report for Campaign Placement v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): The date to retrieve the performance report for
<endDate> (optional): The date to retrieve the performance reports for multiple days till
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<target_table_Brands> (optional): Table name to save the data for Brands
<target_table_Display> (optional): Table name to save the data for Display
<target_table_Products> (optional): Table name to save the data for Products
<target_table_Television> (optional): Table name to save the data for Television
<label> (optional): Multitenancy label

Attribute

Type

Description

report_source

string

Source report name

profileId

long

Profile Id

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignName

string

The name associated with a campaign

campaignId

long

The ID associated with a campaign

campaignStatus

string

The status of a campaign

campaignBudgetType

string

One of daily or lifetime

portfolioId

long

The portfolio the campaign is associated with

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

impressions

integer

Total number of ad impressions

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToCartViews

integer

Number of times shoppers added the brands' products to their cart, attributed to an ad view

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

addToListFromViews

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view

attributedSalesSameSku14d

bigdecimal

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

attributedSalesSameSku1d

bigdecimal

Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku30d

bigdecimal

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku7d

bigdecimal

Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

brandedSearchRate

bigdecimal

Rate of Branded Searches relative to the number of impressions. (BS/Impressions)

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

brandedSearchesViews

integer

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

campaignApplicableBudgetRuleId

long

The ID associated to the active budget rule for a campaign

campaignApplicableBudgetRuleName

string

The name associated to the active budget rule for a campaign

campaignBiddingStrategy

string

The bidding strategy associated with a campaign

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignRuleBasedBudgetAmount

bigdecimal

The value of the rule-based budget for a campaign

clickThroughRate

bigdecimal

Clicks divided by impressions

costPerClick

bigdecimal

Total cost divided by total number of clicks

costPerThousandImpressions

bigdecimal

The cost per thousand impressions

costType

string

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).

cumulativeReach

integer

Total unduplicated audience reached

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

detailPageViewsViews

integer

The number of times a product detail page was viewed attributed to an ad view

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

eCPBrandSearch

bigdecimal

Effective (average) cost to acquire a Branded Search

impressionsFrequencyAverage

bigdecimal

Average number of times unique users were exposed to an ad over the lifetime of the campaign

impressionsViews

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

leadFormOpens

integer

The number of times your lead forms were opened

leads

integer

The number of leads collected through your lead generation campaigns

linkOuts

integer

The number of times link-outs to landing page were clicked.

newToBrandDetailPageViewClicks

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViewViews

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad view

newToBrandDetailPageViews

integer

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

newToBrandDetailPageViewsClicks

integer

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

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandPurchasesPercentage

bigdecimal

The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.

newToBrandPurchasesRate

bigdecimal

The percentage of total orders that are new-to-brand orders. Not available for book vendors

newToBrandPurchasesViews

integer

The number of new to branch purchases attributed to an ad view

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandSalesPercentage

bigdecimal

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

newToBrandSalesViews

bigdecimal

Total value of sales by new to brand customers occurring within 14 days of an ad view.

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

newToBrandUnitsSoldPercentage

bigdecimal

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

placementClassification

string

The page location where an ad appeared

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click. Sponsored Products only

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromoted

integer

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

purchasesPromotedClicks

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku14d

integer

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

purchasesSameSku1d

integer

Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku30d

integer

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku7d

integer

Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesViews

integer

Number of attributed conversion events occurring within 14 days of an ad view

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromViews

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

roas

bigdecimal

Return on ad spend

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromViews

integer

Estimated royalty payment attributed to Kindle Unlimited users who viewed the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click. Includes sales attributed to both clicks and views for vCPM campaigns, but only sales attributed to clicks for CPC campaigns

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesPromoted

bigdecimal

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

salesPromotedClicks

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

salesViews

bigdecimal

Total value of sales occurring within 14 days of an ad view.

spend

bigdecimal

Total cost of ad clicks

topOfSearchImpressionShare

bigdecimal

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

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks

integer

Number of attributed units sold within 14 days of an ad click

unitsSoldClicks14d

integer

Total number of units sold within 14 days of an ad click

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldSameSku14d

integer

Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku1d

integer

Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku30d

integer

Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku7d

integer

Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldViews

integer

Number of attributed units sold within 14 days of an ad view

video5SecondViewRate

bigdecimal

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

video5SecondViews

integer

The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands video-only metric

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewClickThroughRate

bigdecimal

Click-through rate for views (clicks divided by views)

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

viewableImpressions

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

errorMessage

string

Error message if any problem happened

Report_Consolidated_Campaigns

Consolidated Report for Campaigns v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): The date to retrieve the performance report for
<endDate> (optional): The date to retrieve the performance reports for multiple days till
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<target_table_Brands> (optional): Table name to save the data for Brands
<target_table_Display> (optional): Table name to save the data for Display
<target_table_Products> (optional): Table name to save the data for Products
<target_table_Television> (optional): Table name to save the data for Television
<label> (optional): Multitenancy label

Attribute

Type

Description

report_source

string

Source report name

profileId

long

Profile Id

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignName

string

The name associated with a campaign

campaignId

long

The ID associated with a campaign

campaignStatus

string

The status of a campaign

campaignBudgetType

string

One of daily or lifetime

portfolioId

long

The portfolio the campaign is associated with

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

impressions

integer

Total number of ad impressions

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToCartViews

integer

Number of times shoppers added the brands' products to their cart, attributed to an ad view

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

addToListFromViews

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view

attributedSalesSameSku14d

bigdecimal

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

attributedSalesSameSku1d

bigdecimal

Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku30d

bigdecimal

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku7d

bigdecimal

Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

brandedSearchRate

bigdecimal

Rate of Branded Searches relative to the number of impressions. (BS/Impressions)

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

brandedSearchesViews

integer

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

campaignApplicableBudgetRuleId

long

The ID associated to the active budget rule for a campaign

campaignApplicableBudgetRuleName

string

The name associated to the active budget rule for a campaign

campaignBiddingStrategy

string

The bidding strategy associated with a campaign

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignRuleBasedBudgetAmount

bigdecimal

The value of the rule-based budget for a campaign

clickThroughRate

bigdecimal

Clicks divided by impressions

costPerClick

bigdecimal

Total cost divided by total number of clicks

costPerThousandImpressions

bigdecimal

The cost per thousand impressions

costType

string

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).

cumulativeReach

integer

Total unduplicated audience reached

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

detailPageViewsViews

integer

The number of times a product detail page was viewed attributed to an ad view

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

eCPBrandSearch

bigdecimal

Effective (average) cost to acquire a Branded Search

impressionsFrequencyAverage

bigdecimal

Average number of times unique users were exposed to an ad over the lifetime of the campaign

impressionsViews

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

leadFormOpens

integer

The number of times your lead forms were opened

leads

integer

The number of leads collected through your lead generation campaigns

linkOuts

integer

The number of times link-outs to landing page were clicked.

newToBrandDetailPageViewClicks

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViewViews

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad view

newToBrandDetailPageViews

integer

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

newToBrandDetailPageViewsClicks

integer

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

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandPurchasesPercentage

bigdecimal

The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.

newToBrandPurchasesRate

bigdecimal

The percentage of total orders that are new-to-brand orders. Not available for book vendors

newToBrandPurchasesViews

integer

The number of new to branch purchases attributed to an ad view

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandSalesPercentage

bigdecimal

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

newToBrandSalesViews

bigdecimal

Total value of sales by new to brand customers occurring within 14 days of an ad view.

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

newToBrandUnitsSoldPercentage

bigdecimal

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

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click. Sponsored Products only

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromoted

integer

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

purchasesPromotedClicks

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku14d

integer

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

purchasesSameSku1d

integer

Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku30d

integer

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku7d

integer

Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesViews

integer

Number of attributed conversion events occurring within 14 days of an ad view

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromViews

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

roas

bigdecimal

Return on ad spend

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromViews

integer

Estimated royalty payment attributed to Kindle Unlimited users who viewed the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click. Includes sales attributed to both clicks and views for vCPM campaigns, but only sales attributed to clicks for CPC campaigns

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesPromoted

bigdecimal

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

salesPromotedClicks

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

salesViews

bigdecimal

Total value of sales occurring within 14 days of an ad view.

spend

bigdecimal

Total cost of ad clicks

topOfSearchImpressionShare

bigdecimal

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

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks

integer

Number of attributed units sold within 14 days of an ad click

unitsSoldClicks14d

integer

Total number of units sold within 14 days of an ad click

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldSameSku14d

integer

Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku1d

integer

Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku30d

integer

Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku7d

integer

Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldViews

integer

Number of attributed units sold within 14 days of an ad view

video5SecondViewRate

bigdecimal

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

video5SecondViews

integer

The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands video-only metric

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewClickThroughRate

bigdecimal

Click-through rate for views (clicks divided by views)

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

viewableImpressions

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

errorMessage

string

Error message if any problem happened

Report_Consolidated_GrossAndInvalids

Consolidated Report for Gross And Invalids v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): The date to retrieve the performance report for
<endDate> (optional): The date to retrieve the performance reports for multiple days till
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<target_table_Brands> (optional): Table name to save the data for Brands
<target_table_Display> (optional): Table name to save the data for Display
<target_table_Products> (optional): Table name to save the data for Products
<label> (optional): Multitenancy label

Attribute

Type

Description

report_source

string

Source report name

profileId

long

Profile Id

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

clicks

integer

Total number of clicks on an ad

impressions

integer

Total number of ad impressions

grossClickThroughs

integer

The total number of times the ad was clicked. This includes valid, potentially fraudulent, non-human, and other illegitimate clicks

grossImpressions

integer

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

invalidClickThroughRate

bigdecimal

The percentage of gross click-throughs that were removed by the traffic quality filter. (Invalid click-throughs rate = invalid click-throughs / gross click-throughs)

invalidClickThroughs

integer

Clicks that were removed by the traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic

invalidImpressionRate

bigdecimal

The percentage of gross impressions that were removed by the traffic quality filter. (Invalid impression rate = invalid impressions / gross impressions)

invalidImpressions

integer

The number of impressions removed by a traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic

errorMessage

string

Error message if any problem happened

Report_Consolidated_PurchasedProduct

Consolidated Report for Purchased Product v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): The date to retrieve the performance report for
<endDate> (optional): The date to retrieve the performance reports for multiple days till
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<target_table_Brands> (optional): Table name to save the data for Brands
<target_table_Display> (optional): Table name to save the data for Display
<target_table_Products> (optional): Table name to save the data for Products
<label> (optional): Multitenancy label

Attribute

Type

Description

report_source

string

Source report name

profileId

long

Profile Id

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignName

string

The name associated with a campaign

campaignId

long

The ID associated with a campaign

adGroupName

string

The name of the ad group as entered by the advertiser

adGroupId

long

Unique numerical ID of the ad group

portfolioId

long

The portfolio the campaign is associated with

keywordId

long

ID associated with a keyword or targeting expression

matchType

string

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: TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

addToListFromViews

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view

advertisedAsin

string

The ASIN associated to an advertised product

advertisedSku

string

The SKU being advertised. Not available for vendors

asinBrandHalo

string

Represents a product that was purchased after an ad click but has a different SKU/ASIN that what was advertised

attributionType

string

Describes whether a purchase is attributed to a promoted product or brand-halo effect

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignPriceTypeCode

string

The code of the campaign cost type

conversionsBrandHalo

integer

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

conversionsBrandHaloClicks

integer

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

keyword

string

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

keywordType

string

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: TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

newToBrandPurchases14d

integer

The number of first-time orders for brand products over a one-year lookback window. Not available for book vendors

newToBrandPurchasesPercentage14d

bigdecimal

The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.

newToBrandSales14d

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandSalesPercentage14d

bigdecimal

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

newToBrandUnitsSold14d

integer

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

newToBrandUnitsSoldPercentage14d

bigdecimal

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

orders14d

integer

Number of orders within the last 14 days. Includes orders attributed to both clicks and views for vCPM campaigns, but only sales attributed to clicks for CPC campaigns

ordersClicks14d

integer

Number of orders within the last 14 days attributed to ad clicks

productCategory

string

The category the product is associated with on Amazon

productName

string

The name of the product

promotedAsin

string

The ASIN associated to an advertised product

promotedSku

string

The SKU being advertised. Not available for vendors

purchasedAsin

string

The ASIN of the product that was purchased

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click. Sponsored Products only

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesOtherSku14d

integer

Number of attributed conversion events occurring within 14 days of an ad click where the SKU purchased was different that the advertised SKU

purchasesOtherSku1d

integer

Number of attributed conversion events occurring within 1 day of an ad click where the SKU purchased was different that the advertised SKU

purchasesOtherSku30d

integer

Number of attributed conversion events occurring within 30 days of an ad click where the SKU purchased was different that the advertised SKU

purchasesOtherSku7d

integer

Number of attributed conversion events occurring within 7 days of an ad click where the SKU purchased was different that the advertised SKU

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromViews

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromViews

integer

Estimated royalty payment attributed to Kindle Unlimited users who viewed the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click. Includes sales attributed to both clicks and views for vCPM campaigns, but only sales attributed to clicks for CPC campaigns

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesBrandHalo

integer

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

salesBrandHaloClicks

integer

Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised

salesClicks14d

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesOtherSku14d

bigdecimal

Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised

salesOtherSku1d

bigdecimal

Total value of sales occurring within 1 day of an ad click where the purchased SKU was different from the SKU advertised

salesOtherSku30d

bigdecimal

Total value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised

salesOtherSku7d

bigdecimal

Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSold14d

integer

Number of attributed units sold within 14 days of an click or view. Only valid for Sponsored Brands version 3 campaigns, not Sponsored Brands video or multi-ad group (version 4) campaigns. Includes sales attributed to both clicks and views for vCPM campaigns, but only sales attributed to clicks for CPC campaigns

unitsSoldBrandHalo

integer

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

unitsSoldBrandHaloClicks

integer

Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldClicks14d

integer

Total number of units sold within 14 days of an ad click

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldOtherSku14d

integer

Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldOtherSku1d

integer

Total number of units ordered within 1 day of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldOtherSku30d

integer

Total number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldOtherSku7d

integer

Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised

errorMessage

string

Error message if any problem happened

Report_Consolidated_SearchTerm

Consolidated Report for Search Term v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): The date to retrieve the performance report for
<endDate> (optional): The date to retrieve the performance reports for multiple days till
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<target_table_Brands> (optional): Table name to save the data for Brands
<target_table_Products> (optional): Table name to save the data for Products
<label> (optional): Multitenancy label

Attribute

Type

Description

report_source

string

Source report name

profileId

long

Profile Id

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignName

string

The name associated with a campaign

campaignId

long

The ID associated with a campaign

campaignStatus

string

The status of a campaign

campaignBudgetType

string

One of daily or lifetime

adGroupName

string

The name of the ad group as entered by the advertiser

adGroupId

long

Unique numerical ID of the ad group

portfolioId

long

The portfolio the campaign is associated with

keywordId

long

ID associated with a keyword or targeting expression

keywordText

string

Text of the keyword.

keywordBid

bigdecimal

Bid associated with a keyword or targeting expression

matchType

string

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: TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

impressions

integer

Total number of ad impressions

acosClicks14d

bigdecimal

Advertising cost of sales based on purchases made within 14 days of an ad click

acosClicks7d

bigdecimal

Advertising cost of sales based on purchases made within 7 days of an ad click

adKeywordStatus

string

Current status of a keyword

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

attributedSalesSameSku14d

bigdecimal

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

attributedSalesSameSku1d

bigdecimal

Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku30d

bigdecimal

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku7d

bigdecimal

Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

clickThroughRate

bigdecimal

Clicks divided by impressions

costPerClick

bigdecimal

Total cost divided by total number of clicks

costType

string

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).

keyword

string

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

keywordType

string

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: TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click. Sponsored Products only

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesSameSku14d

integer

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

purchasesSameSku1d

integer

Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku30d

integer

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku7d

integer

Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

roasClicks14d

bigdecimal

Return on ad spend based on purchases made within 14 days of an ad click

roasClicks7d

bigdecimal

Return on ad spend based on purchases made within 7 days of an ad click

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click. Includes sales attributed to both clicks and views for vCPM campaigns, but only sales attributed to clicks for CPC campaigns

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesOtherSku7d

bigdecimal

Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised

searchTerm

string

The search term used by the customer. Same as query

targeting

string

A string representation of the expression object used in the targeting clause

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks14d

integer

Total number of units sold within 14 days of an ad click

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldOtherSku7d

integer

Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldSameSku14d

integer

Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku1d

integer

Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku30d

integer

Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku7d

integer

Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised

video5SecondViewRate

bigdecimal

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

video5SecondViews

integer

The number of impressions where the customer watched the complete video or 5 seconds (whichever is shorter). Sponsored Brands video-only metric

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewClickThroughRate

bigdecimal

Click-through rate for views (clicks divided by views)

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

viewableImpressions

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

errorMessage

string

Error message if any problem happened

Report_Consolidated_Targeting

Consolidated Report for Targeting v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): The date to retrieve the performance report for
<endDate> (optional): The date to retrieve the performance reports for multiple days till
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<target_table_Brands> (optional): Table name to save the data for Brands
<target_table_Display> (optional): Table name to save the data for Display
<target_table_Products> (optional): Table name to save the data for Products
<target_table_Television> (optional): Table name to save the data for Television
<label> (optional): Multitenancy label

Attribute

Type

Description

report_source

string

Source report name

profileId

long

Profile Id

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignName

string

The name associated with a campaign

campaignId

long

The ID associated with a campaign

campaignStatus

string

The status of a campaign

campaignBudgetType

string

One of daily or lifetime

adGroupName

string

The name of the ad group as entered by the advertiser

adGroupId

long

Unique numerical ID of the ad group

portfolioId

long

The portfolio the campaign is associated with

keywordId

long

ID associated with a keyword or targeting expression

keywordText

string

Text of the keyword.

keywordBid

bigdecimal

Bid associated with a keyword or targeting expression

matchType

string

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: TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED

targetingExpression

string

A string representation of the expression object used in the targeting clause

targetingText

string

The text used in the targeting expression

targetingType

string

The type of targeting used in the expression

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

impressions

integer

Total number of ad impressions

acosClicks14d

bigdecimal

Advertising cost of sales based on purchases made within 14 days of an ad click

acosClicks7d

bigdecimal

Advertising cost of sales based on purchases made within 7 days of an ad click

adKeywordStatus

string

Current status of a keyword

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToCartViews

integer

Number of times shoppers added the brands' products to their cart, attributed to an ad view

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

addToListFromViews

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view

attributedSalesSameSku14d

bigdecimal

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

attributedSalesSameSku1d

bigdecimal

Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku30d

bigdecimal

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku7d

bigdecimal

Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

brandedSearchRate

bigdecimal

Rate of Branded Searches relative to the number of impressions. (BS/Impressions)

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

brandedSearchesViews

integer

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

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

clickThroughRate

bigdecimal

Clicks divided by impressions

costPerClick

bigdecimal

Total cost divided by total number of clicks

costPerThousandImpressions

bigdecimal

The cost per thousand impressions

costType

string

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

detailPageViewsViews

integer

The number of times a product detail page was viewed attributed to an ad view

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

eCPBrandSearch

bigdecimal

Effective (average) cost to acquire a Branded Search

impressionsViews

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

keyword

string

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

keywordType

string

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: TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

leadFormOpens

integer

The number of times your lead forms were opened

leads

integer

The number of leads collected through your lead generation campaigns

linkOuts

integer

The number of times link-outs to landing page were clicked.

newToBrandDetailPageViewClicks

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViewViews

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad view

newToBrandDetailPageViews

integer

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

newToBrandDetailPageViewsClicks

integer

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

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandPurchasesPercentage

bigdecimal

The percentage of total orders that are new-to-brand orders within 14 days of an ad click. Not available for book vendors.

newToBrandPurchasesRate

bigdecimal

The percentage of total orders that are new-to-brand orders. Not available for book vendors

newToBrandPurchasesViews

integer

The number of new to branch purchases attributed to an ad view

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandSalesPercentage

bigdecimal

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

newToBrandSalesViews

bigdecimal

Total value of sales by new to brand customers occurring within 14 days of an ad view.

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

newToBrandUnitsSoldPercentage

bigdecimal

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

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click. Sponsored Products only

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromoted

integer

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

purchasesPromotedClicks

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku14d

integer

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

purchasesSameSku1d

integer

Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku30d

integer

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku7d

integer

Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesViews

integer

Number of attributed conversion events occurring within 14 days of an ad view

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromViews

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

roas

bigdecimal

Return on ad spend

roasClicks14d

bigdecimal

Return on ad spend based on purchases made within 14 days of an ad click

roasClicks7d

bigdecimal

Return on ad spend based on purchases made within 7 days of an ad click

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromViews

integer

Estimated royalty payment attributed to Kindle Unlimited users who viewed the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click. Includes sales attributed to both clicks and views for vCPM campaigns, but only sales attributed to clicks for CPC campaigns

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesOtherSku7d

bigdecimal

Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised

salesPromoted

bigdecimal

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

salesPromotedClicks

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

salesViews

bigdecimal

Total value of sales occurring within 14 days of an ad view.

targeting

string

A string representation of the expression object used in the targeting clause

targetingId

long

The identifier of the targeting expression

topOfSearchImpressionShare

bigdecimal

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

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks

integer

Number of attributed units sold within 14 days of an ad click

unitsSoldClicks14d

integer

Total number of units sold within 14 days of an ad click

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldOtherSku7d

integer

Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldSameSku14d

integer

Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku1d

integer

Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku30d

integer

Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku7d

integer

Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldViews

integer

Number of attributed units sold within 14 days of an ad view

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewClickThroughRate

bigdecimal

Click-through rate for views (clicks divided by views)

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

errorMessage

string

Error message if any problem happened

Report_Display_AdGroup

Sponsored Display : Ad Group Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: adGroup,matchedTarget
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToCartViews

integer

Number of times shoppers added the brands' products to their cart, attributed to an ad view

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

addToListFromViews

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view

bidOptimization

string

Bid optimization for Sponsored Display ad groups. For vCPM campaigns, the value is always reach. For CPC campaigns, value is either clicks or conversions

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

brandedSearchesViews

integer

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

brandedSearchRate

bigdecimal

Rate of Branded Searches relative to the number of impressions. (BS/Impressions)

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

cumulativeReach

integer

Total unduplicated audience reached

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

eCPBrandSearch

bigdecimal

Effective (average) cost to acquire a Branded Search

impressions

integer

Total number of ad impressions

impressionsFrequencyAverage

bigdecimal

Average number of times unique users were exposed to an ad over the lifetime of the campaign

impressionsViews

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

leadFormOpens

integer

The number of times your lead forms were opened

leads

integer

The number of leads collected through your lead generation campaigns

linkOuts

integer

The number of times link-outs to landing page were clicked.

matchedTargetAsin

string

The ASIN associated with the product page where a Sponsored Display ad appeared

newToBrandDetailPageViewClicks

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViews

integer

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

newToBrandDetailPageViewViews

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad view

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromotedClicks

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromViews

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromViews

integer

Estimated royalty payment attributed to Kindle Unlimited users who viewed the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesPromotedClicks

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks

integer

Number of attributed units sold within 14 days of an ad click

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

viewClickThroughRate

bigdecimal

Click-through rate for views (clicks divided by views)

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Display_AdGroup AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Display_AdGroup (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Display_AdvertisedProducts

Sponsored Display : Advertised Products Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: advertiser
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

adId

long

Unique numerical ID of the ad

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToCartViews

integer

Number of times shoppers added the brands' products to their cart, attributed to an ad view

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

addToListFromViews

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view

bidOptimization

string

Bid optimization for Sponsored Display ad groups. For vCPM campaigns, the value is always reach. For CPC campaigns, value is either clicks or conversions

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

brandedSearchesViews

integer

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

brandedSearchRate

bigdecimal

Rate of Branded Searches relative to the number of impressions. (BS/Impressions)

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

cumulativeReach

integer

Total unduplicated audience reached

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

eCPBrandSearch

bigdecimal

Effective (average) cost to acquire a Branded Search

impressions

integer

Total number of ad impressions

impressionsFrequencyAverage

bigdecimal

Average number of times unique users were exposed to an ad over the lifetime of the campaign

impressionsViews

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

leadFormOpens

integer

The number of times your lead forms were opened

leads

integer

The number of leads collected through your lead generation campaigns

linkOuts

integer

The number of times link-outs to landing page were clicked.

newToBrandDetailPageViewClicks

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViews

integer

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

newToBrandDetailPageViewViews

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad view

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

promotedAsin

string

The ASIN associated to an advertised product

promotedSku

string

The SKU being advertised. Not available for vendors

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromotedClicks

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromViews

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromViews

integer

Estimated royalty payment attributed to Kindle Unlimited users who viewed the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesPromotedClicks

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks

integer

Number of attributed units sold within 14 days of an ad click

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

viewClickThroughRate

bigdecimal

Click-through rate for views (clicks divided by views)

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Display_AdvertisedProducts AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Display_AdvertisedProducts (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Display_Campaigns

Sponsored Display : Campaigns Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: campaign,matchedTarget
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToCartViews

integer

Number of times shoppers added the brands' products to their cart, attributed to an ad view

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

addToListFromViews

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

brandedSearchesViews

integer

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

brandedSearchRate

bigdecimal

Rate of Branded Searches relative to the number of impressions. (BS/Impressions)

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

costType

string

Determines how the campaign will bid and charge. One of vCPM (cost per thousand viewable impressions) or CPC (cost per click).

cumulativeReach

integer

Total unduplicated audience reached

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

eCPBrandSearch

bigdecimal

Effective (average) cost to acquire a Branded Search

impressions

integer

Total number of ad impressions

impressionsFrequencyAverage

bigdecimal

Average number of times unique users were exposed to an ad over the lifetime of the campaign

impressionsViews

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

leadFormOpens

integer

The number of times your lead forms were opened

leads

integer

The number of leads collected through your lead generation campaigns

linkOuts

integer

The number of times link-outs to landing page were clicked.

matchedTargetAsin

string

The ASIN associated with the product page where a Sponsored Display ad appeared

newToBrandDetailPageViewClicks

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViews

integer

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

newToBrandDetailPageViewViews

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad view

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromotedClicks

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromViews

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromViews

integer

Estimated royalty payment attributed to Kindle Unlimited users who viewed the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesPromotedClicks

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks

integer

Number of attributed units sold within 14 days of an ad click

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

viewClickThroughRate

bigdecimal

Click-through rate for views (clicks divided by views)

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Display_Campaigns AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Display_Campaigns (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Display_GrossAndInvalids

Sponsored Display : Gross And Invalids Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: campaign
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

clicks

integer

Total number of clicks on an ad

grossClickThroughs

integer

The total number of times the ad was clicked. This includes valid, potentially fraudulent, non-human, and other illegitimate clicks

grossImpressions

integer

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

integer

Total number of ad impressions

invalidClickThroughRate

bigdecimal

The percentage of gross click-throughs that were removed by the traffic quality filter. (Invalid click-throughs rate = invalid click-throughs / gross click-throughs)

invalidClickThroughs

integer

Clicks that were removed by the traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic

invalidImpressionRate

bigdecimal

The percentage of gross impressions that were removed by the traffic quality filter. (Invalid impression rate = invalid impressions / gross impressions)

invalidImpressions

integer

The number of impressions removed by a traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Display_GrossAndInvalids AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Display_GrossAndInvalids (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Products_PurchasedProducts

Deprecated Sponsored Products : Purchased Products Report V3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

advertisedAsin

string

The ASIN associated to an advertised product

advertisedSku

string

The SKU being advertised. Not available for vendors

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

keyword

string

Text of the keyword or a representation of the targeting expression. For targets, the same value is returned in the targeting metric

keywordId

long

ID associated with a keyword or targeting expression

keywordType

string

Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For targeting expressions, one of TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED. Same as matchType

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

matchType

string

Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For targeting expressions, one of TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED. Same as keywordType

portfolioId

long

The portfolio the campaign is associated with

purchasedAsin

string

The ASIN of the product that was purchased

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesOtherSku14d

integer

Number of attributed conversion events occurring within 14 days of an ad click where the SKU purchased was different that the advertised SKU

purchasesOtherSku1d

integer

Number of attributed conversion events occurring within 1 day of an ad click where the SKU purchased was different that the advertised SKU

purchasesOtherSku30d

integer

Number of attributed conversion events occurring within 30 days of an ad click where the SKU purchased was different that the advertised SKU

purchasesOtherSku7d

integer

Number of attributed conversion events occurring within 7 days of an ad click where the SKU purchased was different that the advertised SKU

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesOtherSku14d

bigdecimal

Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised

salesOtherSku1d

bigdecimal

Total value of sales occurring within 1 day of an ad click where the purchased SKU was different from the SKU advertised

salesOtherSku30d

bigdecimal

Total value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised

salesOtherSku7d

bigdecimal

Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldClicks14d

integer

Total number of units ordered within 14 days of an ad click. Same as unitsSold14d

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldOtherSku14d

integer

Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldOtherSku1d

integer

Total number of units ordered within 1 day of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldOtherSku30d

integer

Total number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldOtherSku7d

integer

Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Display_PurchasedProducts AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Products_PurchasedProducts_v3 (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Products_SearchTerms

Deprecated Sponsored Products : Search Term Report V3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

acosClicks14d

bigdecimal

Advertising cost of sales based on purchases made within 14 days of an ad click

acosClicks7d

bigdecimal

Advertising cost of sales based on purchases made within 7 days of an ad click

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

adKeywordStatus

string

Current status of a keyword

attributedSalesSameSku14d

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku1d

bigdecimal

Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku30d

bigdecimal

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku7d

bigdecimal

Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignBudgetType

string

One of daily or lifetime

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

clicks

integer

Total number of ad clicks

clickThroughRate

bigdecimal

Clicks divided by impressions

cost

bigdecimal

Total cost of ad clicks. Same as spend

costPerClick

bigdecimal

Total cost divided by total number of clicks

impressions

integer

Total number of ad impressions

keyword

string

Text of the keyword or a representation of the targeting expression. For targets, the same value is returned in the targeting metric

keywordBid

bigdecimal

Bid associated with a keyword or targeting expression

keywordId

long

ID associated with a keyword or targeting expression

keywordType

string

Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For targeting expressions, one of TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED. Same as matchType

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

matchType

string

Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For targeting expressions, one of TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED. Same as keywordType

portfolioId

long

The portfolio the campaign is associated with

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesSameSku14d

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku1d

integer

Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku30d

integer

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku7d

integer

Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

roasClicks14d

bigdecimal

Return on ad spend based on purchases made within 14 days of an ad click

roasClicks7d

bigdecimal

Return on ad spend based on purchases made within 7 days of an ad click

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesOtherSku7d

bigdecimal

Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised

searchTerm

string

The search term used by the customer

targeting

string

A string representation of the expression object used in the targeting clause. The targeting expression is also returned in keyword

unitsSoldClicks14d

integer

Total number of units ordered within 14 days of an ad click. Same as unitsSold14d

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldOtherSku7d

integer

Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldSameSku14d

integer

Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku1d

integer

Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku30d

integer

Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku7d

integer

Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Products_SearchTerms AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Products_SearchTerms_v3 (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Display_Targeting

Sponsored Display : Targeting Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: targeting,matchedTarget
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

addToCart

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad view or click

addToCartClicks

integer

Number of times shoppers added a brand's products to their cart, attributed to an ad click

addToCartRate

bigdecimal

Calculated by divididing addToCart by impressions

addToCartViews

integer

Number of times shoppers added the brands' products to their cart, attributed to an ad view

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

addToListFromClicks

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad click

addToListFromViews

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view

adKeywordStatus

string

Current status of a keyword

brandedSearches

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click or view

brandedSearchesClicks

integer

The number of searches that included the name of your brand occurring within 14 days of an ad click

brandedSearchesViews

integer

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

brandedSearchRate

bigdecimal

Rate of Branded Searches relative to the number of impressions. (BS/Impressions)

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

clicks

integer

Total number of clicks on an ad

cost

bigdecimal

Total cost of ad clicks

detailPageViews

integer

Number of detail page views occurring within 14 days of an ad click or view

detailPageViewsClicks

integer

Number of detail page views occurring within 14 days of an ad click

eCPAddToCart

bigdecimal

Effect cost per add to cart, calculated by cost divided by add-to-cart

eCPBrandSearch

bigdecimal

Effective (average) cost to acquire a Branded Search

impressions

integer

Total number of ad impressions

impressionsViews

integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard. See viewability details at

https://advertising.amazon.com/library/guides/viewability

leadFormOpens

integer

The number of times your lead forms were opened

leads

integer

The number of leads collected through your lead generation campaigns

linkOuts

integer

The number of times link-outs to landing page were clicked.

matchedTargetAsin

string

The ASIN associated with the product page where a Sponsored Display ad appeared

newToBrandDetailPageViewClicks

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad click.

newToBrandDetailPageViewRate

bigdecimal

Calculated by dividing newToBrandDetailPageViews / impressions

newToBrandDetailPageViews

integer

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

newToBrandDetailPageViewViews

integer

Number of new-to-brand detail page views for all the brands' products, attributed to an ad view

newToBrandECPDetailPageView

bigdecimal

Effective cost per new-to-brand detail page view, calculated by cost divided by new-to-brand detail page view

newToBrandPurchases

integer

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

newToBrandPurchasesClicks

integer

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

newToBrandSales

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click or view. Not available for book vendors

newToBrandSalesClicks

bigdecimal

Total value of new-to-brand sales occurring within 14 days of an ad click. Not available for book vendors

newToBrandUnitsSold

integer

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

newToBrandUnitsSoldClicks

integer

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

purchases

integer

Number of attributed conversion events occurring within 14 days of an ad click or view

purchasesClicks

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchasesPromotedClicks

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromClicks

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

qualifiedBorrowsFromViews

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromClicks

integer

Estimated royalty payment attributed to Kindle Unlimited users who clicked on the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

royaltyQualifiedBorrowsFromViews

integer

Estimated royalty payment attributed to Kindle Unlimited users who viewed the ad, downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales

bigdecimal

Total value of sales occurring within 14 days of an ad click or view.

salesClicks

bigdecimal

Total value of sales occurring within 14 days of an ad click.

salesPromotedClicks

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

targetingExpression

string

A string representation of the expression object used in the targeting clause

targetingId

long

The identifier of the targeting expression

targetingText

string

The text used in the targeting expression

unitsSold

integer

Number of attributed units sold within 14 days of an ad click or view

unitsSoldClicks

integer

Number of attributed units sold within 14 days of an ad click

videoCompleteViews

integer

The number of impressions where the video was viewed to 100%

videoFirstQuartileViews

integer

The number of impressions where the video was viewed to 25%

videoMidpointViews

integer

The number of impressions where the video was viewed to 50%

videoThirdQuartileViews

integer

The number of impressions where the video was viewed to 75%

videoUnmutes

integer

The number of impressions where a customer unmuted the video

viewabilityRate

bigdecimal

View-through rate (vtr). Views divided by impressions

viewClickThroughRate

bigdecimal

Click-through rate for views (clicks divided by views)

errorMessage

string

Error message if any problem happened

SQL
CREATE VIEW amazon_ads_examples.example_Report_Display_Targeting AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Display_Targeting (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Products_AdvertisedProducts

Deprecated Sponsored Products : Advertised Products Report V3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

acosClicks14d

bigdecimal

Advertising cost of sales based on purchases made within 14 days of an ad click

acosClicks7d

bigdecimal

Advertising cost of sales based on purchases made within 7 days of an ad click

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

adId

long

Unique numerical ID of the ad

advertisedAsin

string

The ASIN associated to an advertised product

advertisedSku

string

The SKU being advertised. Not available for vendors

attributedSalesSameSku14d

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku1d

bigdecimal

Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku30d

bigdecimal

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku7d

bigdecimal

Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignBudgetType

string

One of daily or lifetime

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

clicks

integer

Total number of ad clicks

clickThroughRate

bigdecimal

Clicks divided by impressions

cost

bigdecimal

Total cost of ad clicks. Same as spend

costPerClick

bigdecimal

Total cost divided by total number of clicks

impressions

integer

Total number of ad impressions

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

portfolioId

long

The portfolio the campaign is associated with

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesSameSku14d

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku1d

integer

Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku30d

integer

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku7d

integer

Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

roasClicks14d

bigdecimal

Return on ad spend based on purchases made within 14 days of an ad click

roasClicks7d

bigdecimal

Return on ad spend based on purchases made within 7 days of an ad click

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesOtherSku7d

bigdecimal

Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised

spend

bigdecimal

Total cost of ad clicks. Same as cost

unitsSoldClicks14d

integer

Total number of units ordered within 14 days of an ad click. Same as unitsSold14d

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldOtherSku7d

integer

Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldSameSku14d

integer

Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku1d

integer

Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku30d

integer

Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku7d

integer

Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised

errorMessage

string

Error message if any problem happened

Example

SQL
CREATE VIEW amazon_ads_examples.example_Report_Products_AdvertisedProducts AS
    SELECT *
    FROM (
        CALL amazon_ads.Report_Products_AdvertisedProducts_v3 (
            groupBy => NULL,
            startDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
            endDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
        )
    ) AS x

Report_Products_AdvertisedProducts_v3

Sponsored Products : Advertised Products Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: advertiser
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

portfolioId

long

The portfolio the campaign is associated with

adId

long

Unique numerical ID of the ad

acosClicks14d

bigdecimal

Advertising cost of sales based on purchases made within 14 days of an ad click

acosClicks7d

bigdecimal

Advertising cost of sales based on purchases made within 7 days of an ad click

addToList

integer

Number of times shoppers added a promoted product to a wish list, gift list, or registry, attributed to an ad view or click. Use Total ATL to see all conversions for the brands' products

advertisedAsin

string

The ASIN associated to an advertised product

advertisedSku

string

The SKU being advertised. Not available for vendors

attributedSalesSameSku14d

bigdecimal

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

attributedSalesSameSku1d

bigdecimal

Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku30d

bigdecimal

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku7d

bigdecimal

Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignBudgetType

string

One of daily or lifetime

clicks

integer

Total number of clicks on an ad

clickThroughRate

bigdecimal

Clicks divided by impressions

cost

bigdecimal

Total cost of ad clicks

costPerClick

bigdecimal

Total cost divided by total number of clicks

impressions

integer

Total number of ad impressions

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click. Sponsored Products only

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesSameSku14d

integer

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

purchasesSameSku1d

integer

Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku30d

integer

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku7d

integer

Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

qualifiedBorrows

integer

Number of Kindle Unlimited users who have downloaded the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

roasClicks14d

bigdecimal

Return on ad spend based on purchases made within 14 days of an ad click

roasClicks7d

bigdecimal

Return on ad spend based on purchases made within 7 days of an ad click

royaltyQualifiedBorrows

integer

Estimated royalty payment attributed to Kindle Unlimited users downloading the book due to ad exposure, during the attribution window, and have read a percent of the book within the window, triggering a royalty payment. Relevant to book advertisers only

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click. Includes sales attributed to both clicks and views for vCPM campaigns, but only sales attributed to clicks for CPC campaigns

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesOtherSku7d

bigdecimal

Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised

spend

bigdecimal

Total cost of ad clicks

unitsSoldClicks14d

integer

Total number of units sold within 14 days of an ad click

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldOtherSku7d

integer

Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldSameSku14d

integer

Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku1d

integer

Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku30d

integer

Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku7d

integer

Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised

errorMessage

string

Error message if any problem happened

Report_Products_Campaigns

Deprecated Sponsored Products : Campaigns Report V3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<reportId> (optional): Id of the report to parse
<groupBy> (optional): Group by one of the following values: campaign, adGroup, campaignPlacement
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

adStatus

string

Status of the ad group

attributedSalesSameSku14d

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku1d

bigdecimal

Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku30d

bigdecimal

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku7d

bigdecimal

Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

campaignApplicableBudgetRuleId

string

The ID associated to the active budget rule for a campaign

campaignApplicableBudgetRuleName

string

The name associated to the active budget rule for a campaign

campaignBiddingStrategy

string

The bidding strategy associated with a campaign

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignBudgetType

string

One of daily or lifetime

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignRuleBasedBudgetAmount

bigdecimal

The value of the rule-based budget for a campaign

campaignStatus

string

The status of a campaign

clicks

integer

Total number of ad clicks

clickThroughRate

bigdecimal

Clicks divided by impressions

cost

bigdecimal

Total cost of ad clicks. Same as spend

costPerClick

bigdecimal

Total cost divided by total number of clicks

impressions

integer

Total number of ad impressions

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

placementClassification

string

The page location where an ad appeared

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesSameSku14d

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku1d

integer

Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku30d

integer

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku7d

integer

Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

spend

bigdecimal

Total cost of ad clicks. Same as cost

topOfSearchImpressionShare

bigdecimal

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

unitsSoldClicks14d

integer

Total number of units ordered within 14 days of an ad click. Same as unitsSold14d

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldSameSku14d

integer

Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku1d

integer

Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku30d

integer

Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku7d

integer

Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised

errorMessage

string

Error message if any problem happened

Example

SQL
CREATE VIEW amazon_ads_examples.example_Report_Products_Campaigns AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Products_Campaigns_v3 (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Products_GrossAndInvalids

Sponsored Products : Gross And Invalids Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: campaign
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

clicks

integer

Total number of clicks on an ad

grossClickThroughs

integer

The total number of times the ad was clicked. This includes valid, potentially fraudulent, non-human, and other illegitimate clicks

grossImpressions

integer

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

integer

Total number of ad impressions

invalidClickThroughRate

bigdecimal

The percentage of gross click-throughs that were removed by the traffic quality filter. (Invalid click-throughs rate = invalid click-throughs / gross click-throughs)

invalidClickThroughs

integer

Clicks that were removed by the traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic

invalidImpressionRate

bigdecimal

The percentage of gross impressions that were removed by the traffic quality filter. (Invalid impression rate = invalid impressions / gross impressions)

invalidImpressions

integer

The number of impressions removed by a traffic quality filter. This includes potentially fraudulent, non-human, and other illegitimate traffic

errorMessage

string

Error message if any problem happened

SQL
CCREATE VIEW amazon_ads_examples.example_Report_Products_GrossAndInvalids AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Products_GrossAndInvalids (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Products_PurchasedProducts

Sponsored Products : Purchased Products Report v.3

Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

Profile ID

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

advertisedAsin

string

The ASIN associated to an advertised product

advertisedSku

string

The SKU being advertised. Not available for vendors

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

keyword

string

Text of the keyword or a representation of the targeting expression. For targets, the same value is returned in the targeting metric

keywordId

long

ID associated with a keyword or targeting expression

keywordType

string

Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For targeting expressions, one of TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED. Same as matchType

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

matchType

string

Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For targeting expressions, one of TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED. Same as keywordType

portfolioId

long

The portfolio the campaign is associated with

purchasedAsin

string

The ASIN of the product that was purchased

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesOtherSku14d

integer

Number of attributed conversion events occurring within 14 days of an ad click where the SKU purchased was different that the advertised SKU

purchasesOtherSku1d

integer

Number of attributed conversion events occurring within 1 day of an ad click where the SKU purchased was different that the advertised SKU

purchasesOtherSku30d

integer

Number of attributed conversion events occurring within 30 days of an ad click where the SKU purchased was different that the advertised SKU

purchasesOtherSku7d

integer

Number of attributed conversion events occurring within 7 days of an ad click where the SKU purchased was different that the advertised SKU

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesOtherSku14d

bigdecimal

Total value of sales occurring within 14 days of an ad click where the purchased SKU was different from the SKU advertised

salesOtherSku1d

bigdecimal

Total value of sales occurring within 1 day of an ad click where the purchased SKU was different from the SKU advertised

salesOtherSku30d

bigdecimal

Total value of sales occurring within 30 days of an ad click where the purchased SKU was different from the SKU advertised

salesOtherSku7d

bigdecimal

Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldClicks14d

integer

Total number of units ordered within 14 days of an ad click. Same as unitsSold14d

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldOtherSku14d

integer

Total number of units ordered within 14 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldOtherSku1d

integer

Total number of units ordered within 1 day of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldOtherSku30d

integer

Total number of units ordered within 30 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldOtherSku7d

integer

Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised

errorMessage

string

Error message if any problem happened

Example

SQL
CREATE VIEW amazon_ads_examples.example_Report_Products_PurchasedProducts AS
    SELECT *
    FROM (
        CALL amazon_ads.Report_Products_PurchasedProducts (
            groupBy => NULL,
            startDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
            endDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
        )
    ) AS x

Report_Products_SearchTerms

Deprecated Sponsored Products : Search Term Report V3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

acosClicks14d

bigdecimal

Advertising cost of sales based on purchases made within 14 days of an ad click

acosClicks7d

bigdecimal

Advertising cost of sales based on purchases made within 7 days of an ad click

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

adKeywordStatus

string

Current status of a keyword

attributedSalesSameSku14d

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku1d

bigdecimal

Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku30d

bigdecimal

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku7d

bigdecimal

Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignBudgetType

string

One of daily or lifetime

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

clicks

integer

Total number of ad clicks

clickThroughRate

bigdecimal

Clicks divided by impressions

cost

bigdecimal

Total cost of ad clicks. Same as spend

costPerClick

bigdecimal

Total cost divided by total number of clicks

impressions

integer

Total number of ad impressions

keyword

string

Text of the keyword or a representation of the targeting expression. For targets, the same value is returned in the targeting metric

keywordBid

bigdecimal

Bid associated with a keyword or targeting expression

keywordId

long

ID associated with a keyword or targeting expression

keywordType

string

Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For targeting expressions, one of TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED. Same as matchType

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

matchType

string

Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For targeting expressions, one of TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED. Same as keywordType

portfolioId

long

The portfolio the campaign is associated with

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesSameSku14d

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku1d

integer

Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku30d

integer

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku7d

integer

Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

roasClicks14d

bigdecimal

Return on ad spend based on purchases made within 14 days of an ad click

roasClicks7d

bigdecimal

Return on ad spend based on purchases made within 7 days of an ad click

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesOtherSku7d

bigdecimal

Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised

searchTerm

string

The search term used by the customer

targeting

string

A string representation of the expression object used in the targeting clause. The targeting expression is also returned in keyword

unitsSoldClicks14d

integer

Total number of units ordered within 14 days of an ad click. Same as unitsSold14d

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldOtherSku7d

integer

Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldSameSku14d

integer

Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku1d

integer

Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku30d

integer

Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku7d

integer

Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised

errorMessage

string

Error message if any problem happened

Example

SQL
CREATE VIEW amazon_ads_examples.example_Report_Products_SearchTerms AS 
	SELECT * 
	FROM (
		CALL amazon_ads.Report_Products_SearchTerms_v3 (
			groupBy => NULL,
			endDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
			startDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
		)
	) AS x;;

Report_Products_Targeting

Sponsored Products : Targeting Report V3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

acosClicks14d

bigdecimal

Advertising cost of sales based on purchases made within 14 days of an ad click

acosClicks7d

bigdecimal

Advertising cost of sales based on purchases made within 7 days of an ad click

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

adKeywordStatus

string

Current status of a keyword

attributedSalesSameSku14d

bigdecimal

Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku1d

bigdecimal

Total value of sales occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku30d

bigdecimal

Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

attributedSalesSameSku7d

bigdecimal

Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

campaignBudgetAmount

bigdecimal

Total budget allocated to the campaign

campaignBudgetCurrencyCode

string

The currency code associated with the campaign

campaignBudgetType

string

One of daily or lifetime

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

clicks

integer

Total number of ad clicks

clickThroughRate

bigdecimal

Clicks divided by impressions

cost

bigdecimal

Total cost of ad clicks. Same as spend

costPerClick

bigdecimal

Total cost divided by total number of clicks

impressions

integer

Total number of ad impressions

keyword

string

Text of the keyword or a representation of the targeting expression. For targets, the same value is returned in the targeting metric

keywordBid

bigdecimal

Bid associated with a keyword or targeting expression

keywordId

long

ID associated with a keyword or targeting expression

keywordType

string

Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For targeting expressions, one of TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED. Same as matchType

kindleEditionNormalizedPagesRead14d

integer

Number of attributed Kindle edition normalized pages read within 14 days of ad click

kindleEditionNormalizedPagesRoyalties14d

bigdecimal

The estimated royalties of attributed estimated Kindle edition normalized pages within 14 days of ad click

matchType

string

Type of matching for the keyword used in bid. For keywords, one of: BROAD, PHRASE, or EXACT. For targeting expressions, one of TARGETING_EXPRESSION or TARGETING_EXPRESSION_PREDEFINED. Same as keywordType

portfolioId

long

The portfolio the campaign is associated with

purchases14d

integer

Number of attributed conversion events occurring within 14 days of an ad click

purchases1d

integer

Number of attributed conversion events occurring within 1 day of an ad click

purchases30d

integer

Number of attributed conversion events occurring within 30 days of an ad click

purchases7d

integer

Number of attributed conversion events occurring within 7 days of an ad click

purchasesSameSku14d

integer

Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku1d

integer

Number of attributed conversion events occurring within 1 day of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku30d

integer

Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised

purchasesSameSku7d

integer

Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised

roasClicks14d

bigdecimal

Return on ad spend based on purchases made within 14 days of an ad click

roasClicks7d

bigdecimal

Return on ad spend based on purchases made within 7 days of an ad click

sales14d

bigdecimal

Total value of sales occurring within 14 days of an ad click

sales1d

bigdecimal

Total value of sales occurring within 1 day of an ad click

sales30d

bigdecimal

Total value of sales occurring within 30 days of an ad click

sales7d

bigdecimal

Total value of sales occurring within 7 days of an ad click

salesOtherSku7d

bigdecimal

Total value of sales occurring within 7 days of an ad click where the purchased SKU was different from the SKU advertised

targeting

string

A string representation of the expression object used in the targeting clause. The targeting expression is also returned in keyword

topOfSearchImpressionShare

bigdecimal

The percentage of top-of-search impressions earned out of all the top-of-search impressions that were eligible for a given data range

unitsSoldClicks14d

integer

Total number of units ordered within 14 days of an ad click. Same as unitsSold14d

unitsSoldClicks1d

integer

Total number of units ordered within 1 day of an ad click

unitsSoldClicks30d

integer

Total number of units ordered within 30 days of an ad click

unitsSoldClicks7d

integer

Total number of units ordered within 7 days of an ad click

unitsSoldOtherSku7d

integer

Total number of units ordered within 7 days of an ad click where the purchased SKU was different from the SKU advertised

unitsSoldSameSku14d

integer

Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku1d

integer

Total number of units ordered within 1 day of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku30d

integer

Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised

unitsSoldSameSku7d

integer

Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised

errorMessage

string

Error message if any problem happened

Example

SQL
CREATE VIEW amazon_ads_examples.example_Report_Products_Targeting AS
    SELECT *
    FROM (
        CALL amazon_ads.Report_Products_Targeting (
            groupBy => NULL,
            startDate => TIMESTAMPADD (SQL_TSI_DAY, -5, CURDATE ()),
            endDate => TIMESTAMPADD (SQL_TSI_DAY, -6, CURDATE ())
        )
    ) AS x

Report_Television_Campaigns

Sponsored Television : Campaigns Report v3
Parameter
<profileId> (optional): Return results for one or more profiles mentioned in CSV list of profile Ids
<accountId> (optional): Return results for those profiles with the mentioned in CSV list account Ids
<startDate> (optional): Start date
<endDate> (optional): End date
<groupBy> (optional): Group by one of the following values: campaign,adGroup
<reportId> (optional): Id of the report to parse
<days_step> (optional): Number of days to query in a single batch
<days_redownload> (optional): Number of days to redownload
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to
<label> (optional): Multi-tenancy label

Attribute

Type

Description

profileId

long

ID of the profile

date

date

Date when the ad activity ocurred in the format YYYY-MM-DD

campaignId

long

The ID associated with a campaign

campaignName

string

The name associated with a campaign

campaignStatus

string

The status of a campaign

adGroupId

long

Unique numerical ID of the ad group

adGroupName

string

The name of the ad group as entered by the advertiser

portfolioId