Sponsored Brands

Campaign

Table name: ad_sponsoredbrand_campaign

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

profile_id

Integer

Amazon advertising account id

account_id

Integer

Intentwise account id

account_name

String

Intentwise account name

campaignid

Integer

The identifier of the campaign

name

String

The name of the campaign

budget

Numeric

Budget set for the campaign

startdate

Date

The starting date of the campaign. The format of the date is YYYY-MM-DD

enddate

Date

The ending date of the campaign to stop running. The format of the date is YYYY-MM-DD

state

String

The current Campaign state

portfolioid

Integer

The identifier of an existing portfolio to which the campaign is associated

Table name: ad_sponsoredbrand_campaign_report

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

profile_id

integer

Amazon advertising account id

account_id

integer

Intentwise account id

account_name

string

Intentwise account name

reportdate

date

Report date

campaignid

integer

Campaign id

campaignname

string

Campaign name

campaignstatus

string

Campaign status

campaignbudget

numeric

Campaign budget

impressions

integer

Total ad impressions

clicks

integer

Total ad clicks

cost

numeric

Total cost of all clicks. Can be divided by clicks to obtain average CPC

attributedsales14dsamesku

numeric

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

attributedsales14d

numeric

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

attributedconversions14dsamesku

integer

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

attributedconversions14d

integer

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

attributedunitsordered14d

integer

Number of attributed units ordered within 14 days of click on ad

attributedordersnewtobrand14d

integer

The number of first-time orders for products within the brand over a one-year lookback window. Not available for search term report

attributedordersnewtobrandpercentage14d

numeric

The percentage of total sales of new-to-brand purchases. Not available for search term report

attributedorderratenewtobrand14d

numeric

The number of new-to-brand orders relative to the number of clicks. New-to-brand order rate = new-to-brand orders / clicks. Not available for search term report

attributedsalesnewtobrandpercentage14d

numeric

The percentage of total sales of new-to-brand purchases. Not available for search term report

attributedunitsorderednewtobrand14d

integer

The number of units from first-time orders for products within the brand over a one-year lookback window. Not available for search term report

attributedunitsorderednewtobrandpercentage14d

numeric

The percentage of total units that are units from new-to-brand orders. Not available for search term report

attributedsalesnewtobrand14d

numeric

The total sales of new-to-brand orders. Not available for search term report

viewableimpressions

integer

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

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%

videocompleteviews

integer

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

video5secondviews

integer

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

video5secondviewrate

numeric

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

videounmutes

integer

The number of impressions where a shopper unmuted the video

vtr

numeric

View-through-rate (views/impressions)

vctr

numeric

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

unitssold14d

integer

Number of attributed units sold occurring within 14 days of click on an ad. Not available for search term report. Vendor only field

dpv14d

integer

Number of attributed detail page views occurring within 14 days of click on an ad. Not available for search term report. Vendor only field

Table name: ad_sponsoredbrand_keyword

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

profile_id

integer

Amazon advertising account id

account_id

integer

Intentwise account id

account_name

string

Intentwise account name

keywordid

integer

Keyword id

adgroupid

integer

Adgroup id

campaignid

integer

Campaign id

state

string

Keyword status

keywordtext

string

The text of the expression to match against a search query

matchtype

string

The type of match. ex: exact, phrase and broad

bid

numeric

Table name: ad_sponsoredbrand_keyword_report

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

profile_id

Integer

Amazon advertising account id

account_id

Integer

Intentwise account id

account_name

String

Intentwise account name

reportdate

Date

Report date

keywordid

Integer

The identifier of the advertised keyword text

adgroupid

Integer

The identifier of the adgroup

impressions

Integer

Total ad impressions

clicks

Integer

Total ad clicks

cost

Numeric

Total cost of all clicks. Can be divided by clicks to obtain average CPC

attributedsales14dsamesku

Numeric

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

attributedsales14d

Numeric

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

attributedconversions14dsamesku

Integer

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

attributedconversions14d

Integer

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

attributedunitsordered14d

Integer

Number of attributed units ordered within 14 days of click on ad

viewableimpressions

Integer

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

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%

videocompleteviews

Integer

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

video5secondviews

Integer

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

video5secondviewrate

Numeric

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

videounmutes

Integer

The number of impressions where a shopper unmuted the video

vtr

Numeric

View-through-rate (views/impressions)

vctr

Numeric

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

unitssold14d

Integer

Number of attributed units sold occurring within 14 days of click on an ad. Not available for search term report. Vendor only field

dpv14d

Integer

Number of attributed detail page views occurring within 14 days of click on an ad. Not available for search term report. Vendor only field

topofsearchimpressionshare

Numeric

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

Table name: ad_sponsoredbrand_negativekeyword

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

profile_id

integer

Amazon advertising account id

account_id

integer

Intentwise account id

account_name

string

Intentwise account name

keywordid

integer

Keyword id

campaignid

integer

Campaign id

adgroupid

integer

Adgroup id

state

string

Negative keyword status

keywordtext

string

The text of the expression to match against a search query

matchtype

string

The type of match. ex: negativeExact, negativePhrase

creationdate

timestamptz(0)

Negative keyword created date

lastupdateddate

timestamptz(0)

Negative keyword last updated date

servingstatus

string

Product Target

Table name: ad_sponsoredbrand_target

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

profile_id

integer

Amazon advertising account id

account_id

integer

Intentwise account id

account_name

string

Intentwise account name

targetid

integer

Target id

adgroupid

integer

Adgroup id

campaignid

integer

Campaign id

expressiontype

string

state

string

Product target state

bid

numeric

creationdate

timestamptz(0)

Product target created date

lastupdateddate

timestamptz(0)

Product target last updated date

autoexpressionvalue

string

asinpricelessthan

numeric

Target a price that is less than the price expressed

asinpricegreaterthan

numeric

Target a price that is greater than the price expressed

asinreviewratinglessthan

numeric

Target a review rating less than the review rating that is expressed

asinreviewratinggreaterthan

numeric

Target a review rating that is greater than the review rating expressed

asincategorysameas

string

Negatively Target the same category as the category expressed

asinbrandsameas

string

Target the brand that is the same as the brand expressed

asinpricebetween

string

Target a price that is between the prices expressed

asinreviewratingbetween

string

Target a price that is between the prices expressed

asinsameas

string

Target an ASIN that is the same as the ASIN expressed

Table name: ad_sponsoredbrand_target_report

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

profile_id

integer

Amazon advertising account id

account_id

integer

Intentwise account id

account_name

string

Intentwise account name

reportdate

date

Report date

report_date

date

targetid

integer

Target id

impressions

integer

Total ad impressions

clicks

integer

Total ad clicks

cost

numeric

Total cost of all clicks. Can be divided by clicks to obtain average CPC

attributedsales14dsamesku

numeric

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

attributedsales14d

numeric

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

attributedconversions14dsamesku

integer

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

attributedconversions14d

integer

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

attributedunitsordered14d

integer

Number of attributed units ordered within 14 days of click on ad

is_video

boolean

viewableimpressions

integer

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

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%

videocompleteviews

integer

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

video5secondviews

integer

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

video5secondviewrate

numeric

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

videounmutes

integer

The number of impressions where a shopper unmuted the video

vtr

numeric

View-through-rate (views/impressions)

vctr

numeric

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

unitssold14d

integer

Number of attributed units sold occurring within 14 days of click on an ad. Not available for search term report. Vendor only field

dpv14d

integer

Number of attributed detail page views occurring within 14 days of click on an ad. Not available for search term report. Vendor only field

Table Name: ad_sponsoredbrand_keywordsearchterm_report

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

profile_id

Integer

Amazon advertising account id

account_id

Integer

Intentwise account id

account_name

varchar(1020)

Intentwise account name

keywordid

int8

The identifier of the advertised keyword text

keywordtext

varchar(256)

The text of the expression to match against a search query

matchtype

varchar(256)

The type of match. ex: exact, phrase and broad

campaignid

int8

The identifier of the campaign

adgroupid

int8

The identifier of the adgroup

reportdate

date

Report date

query

varchar(500)

Query

impressions

int8

Total ad impressions

clicks

int4

Total ad clicks

cost

numeric(12, 2)

Total cost of all clicks. Can be divided by clicks to obtain average CPC

attributedsales14dsamesku

numeric(12, 2)

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

attributedsales14d

numeric(12, 2)

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

attributedconversions14dsamesku

int4

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

attributedconversions14d

int4

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

attributedunitsordered14d

int4

Number of attributed units ordered within 14 days of click on ad

searchtermimpressionrank

int4

The numeric rank of your account-wide impression

searchtermimpressionshare

numeric(12, 2)

Account-wide share (in %) of the total impressions across all advertisers

impressionswithshare

int8

Improssion with share

totalimpressions

int8

Total Impression

Table Name: ad_sponsoredbrand_producttargetsearchterm_report

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

profile_id

int8

Amazon advertising account id

account_id

int8

Intentwise account id

account_name

varchar(1020)

Intentwise account name

targetid

int8

Target id

campaignid

int8

The identifier of the campaign

adgroupid

int8

The identifier of the adgroup

reportdate

date

Report date

query

varchar(500)

Query

impressions

int8

Total ad impressions

clicks

int4

Total ad clicks

cost

numeric(12, 2)

Total cost of all clicks. Can be divided by clicks to obtain average CPC

attributedsales14dsamesku

numeric(12, 2)

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

attributedsales14d

numeric(12, 2)

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

attributedconversions14dsamesku

int4

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

attributedconversions14d

int4

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

attributedunitsordered14d

int4

Number of attributed units ordered within 14 days of click on ad

searchtermimpressionrank

int4

The numeric rank of your account-wide impression

searchtermimpressionshare

numeric(12, 2)

Account-wide share (in %) of the total impressions across all advertisers

impressionswithshare

int8

Improssion with share

totalimpressions

int8

Total Impression

Table Name: ad_sponsoredbrand_ad

Every adId can have mulitple asin's, This table should be joined with ad_sponsoredbrand_ad_asin based on profileId and adId.

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

profile_id

Integer

Amazon advertising account id

account_id

Integer

Intentwise account id

account_name

String

Intentwise account name

adid

Integer

Advertised product identifier

adgroupid

Integer

The identifier of the adgroup

campaignid

Integer

The identifier of the campaign

state

String

The current resource state.

creationdate

Timestamp

Creation date in epoch time.

lastupdateddate

Timestamp

ASIN last updated date

servingstatus

String

The ad serving status determined by system.

brandname

String

The Brand to which product belongs

headline

String

The headline text

type

String

The creative type of SB ad. Possible Values: PRODUCT_COLLECTION, STORE_SPOTLIGHT, VIDEO, BRAND_VIDEO

landingpagepagetype

String

The type of landing page, such as store page, product list (simple landing page), custom url.

landingpageurl

String

URL of an existing simple landing page or Store page. Vendors may also specify the URL of a custom landing page. If a custom URL is specified, the landing page must 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. Note that brandVideo ads only support Store page as landing page and does not allow asins property.

name

String

The name of the ad. Note: Ads created using version 3/non-multi ad group campaigns do not have an associated name

systemlastupdateddate

Timestamp

System last updated date

Table Name: ad_sponsoredbrand_ad_asin

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

profile_id

Integer

Amazon advertising account id

account_id

Integer

Intentwise account id

account_name

String

Intentwise account name

adid

Integer

Advertised product identifier

asin

String

The ASIN that is being advertised.

creationdate

Timestamp

Creation date in epoch time.

Table Name: ad_sponsoredbrand_ad_report

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

profile_id

Integer

The identifier of the amazon advertising account

account_id

Integer

Intentwise account id

account_name

String

Intentwise account name

reportdate

Date

Report date

adid

Integer

The identifier of the advertised product

adgroupid

Integer

The identifier of the adgroup

campaignid

Integer

Campaign id

impressions

Integer

Total ad impressions

clicks

Integer

Total ad clicks

cost

Numeric

Total cost of all clicks. Can be divided by clicks to obtain average CPC

attributedsales14dsamesku

Numeric

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

attributedsales14d

Numeric

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

attributedconversions14dsamesku

Integer

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

attributedconversions14d

Integer

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

attributeddetailpageviewsclicks14d

Integer

The number of attributed detail page view conversions 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.

attributedordersnewtobrandpercentage14d

Numeric

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

attributedorderratenewtobrand14d

Numeric

The number of new-to-brand orders relative to the number of clicks. New-to-brand order rate = new-to-brand orders / clicks. Not available for book vendors.

attributedsalesnewtobrand14d

Numeric

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

attributedsalesnewtobrandpercentage14d

Numeric

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

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.

attributedunitsorderednewtobrandpercentage14d

Numeric

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.

viewableimpressions

Integer

Number of impressions that met the Media Ratings Council (MRC) viewability standard (50 percent of the ad viewable with two seconds playback completed). Sponsored Brands video-only metric.

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%.

videocompleteviews

Integer

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

video5secondviews

Integer

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

video5secondviewrate

Numeric

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.

videounmutes

Integer

The number of impressions where a customer unmuted the video.

vtr

Numeric

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

vctr

Numeric

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

unitssold14d

Integer

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

dpv14d

Integer

Number of attributed detail page views occurring within 14 days of click on an ad. Vendor-only field.

attributedbrandedsearches14d

Integer

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

Ad Store

Brand Store analytic metrics provide brands with analytics about the Brand Store performance and customer behavior. These metrics offer a deeper understanding of how shoppers interact with the Brand Store, helping brands optimize their strategies to drive engagement and sales.

Table name: amazon_source_data.ad_store

For details on data availability and refresh schedule, please click here.

Column Name
Data Type
Description

profile_id

Integer

Amazon advertising account id

account_id

Integer

Intentwise Account Identifier

account_name

Varchar

Intentwise Account Name

region

Varchar

Region of the account

brandentityid

Varchar

ID used in campaign creation and asset registration

storename

Varchar

The name of the store

storepageid

Varchar

The ID of the store

storepageurl

Varchar

The store url page. Can be used for SB campaigns as a possible landing page

store_page_name

Varchar

The page name. Defaults to Home for the main store page

Ad Store Insights Report

Table name: amazon_source_data.ad_store_insights_report

For details on data availability and refresh schedule, please click here.

Column Name
Data Type
Description

profile_id

Integer

Amazon advertising account id

account_id

Integer

Intentwise Account Identifier

account_name

Varchar

Intentwise Account Name

region

String

Region of the account

reportdate

Date

Date of the report

brandentityid

Varchar

ID used in campaign creation and asset registration

dimensiontype

Varchar

Dimensional grain at which the report is generated Types - PAGE / SOURCE / TAG / STORE / DATE

dimensionvalue

Varchar

Dimensional value. If dimension_type is PAGE, dimension_value will be page_id

views

Integer

Number of page views.

orders

Integer

Estimated total orders placed by Store visitors within 14 days of their visit. Orders contain one or more units sold.

units

Integer

Estimated units purchased by Store visitors within 14 days of their last visit

sales

Numeric

Estimated total sales generated by Store visitors within 14 days of their last visit

visits

Integer

Total visits to a page within a single day. Each visitor can visit more than one page, and they can visit your Store from more than one traffic source

visitors

Integer

Total visitors to your Store within the selected date range, calculated based on daily unique users or devices

scorelevel

Varchar

Store Quality rating calculated on various factors defining the quality of a store. It can be HIGH, MEDIUM, or LOW

dwell

Numeric

Average time a customer spends on the store, specifically for store quality measurement

peerdwell

Numeric

Average time a customer spends on other similar (peer) stores on average

dwelltime

Numeric

Average time a customer spends on the store, providing insights into user engagement by calculating the average duration of visits

bouncerate

Numeric

Ratio of total bounce visits (customer who landed on the store and left quickly without engaging) to total landing visits, providing insights into visitor engagement

newtostore

Integer

Total count of unique visitors who are new to the store, providing valuable insights into the number of first-time shoppers

systemlastupdateddate

Timestamp

Time on which the results were captured

Table name: ad_sponsoredbrand_adgroup

For details on data availability and refresh schedule, please click here

Column Name
Data type
Description

profile_id

integer

Amazon advertising account id

account_id

integer

Intentwise account id

account_name

string

Intentwise account name

adgroupid

integer

Adgroup id

campaignid

integer

Campaign id

name

string

Campaign Name

defaultbid

numeric

Default bid set for the adgroup

state

string

Adgroup state

creationdate

timestamptz(0)

Adgroup created date

lastupdateddate

timestamptz(0)

Adgroup last updated date

servingstatus

string

The status of the ad group ADVERTISER_STATUS_ENABLED, STATUS_UNAVAILABLE, ADVERTISER_PAUSED, ACCOUNT_OUT_OF_BUDGET, ADVERTISER_PAYMENT_FAILURE, CAMPAIGN_PAUSED, CAMPAIGN_ARCHIVED, PENDING_START_DATE, ENDED, CAMPAIGN_OUT_OF_BUDGET, AD_GROUP_STATUS_ENABLED, AD_GROUP_PAUSED, AD_GROUP_ARCHIVED, AD_GROUP_INCOMPLETE, AD_GROUP_LOW_BID, ADGROUP_POLICING_PENDING_REVIEW, ADGROUP_POLICING_CREATIVE_REJECTED

Table name: ad_sponsoredbrand_adgroup_report

For details on data availability and refresh schedule, please click here.

Column Name
Data type
Description

profile_id

integer

Amazon advertising account id

account_id

integer

Intentwise account id

account_name

string

Intentwise account name

reportdate

date

Report date

adgroupid

integer

Adgroup id

impressions

integer

Total ad impressions

clicks

integer

Total ad clicks

cost

numeric

Total cost of all clicks. Can be divided by clicks to obtain average CPC

attributedsales14dsamesku

numeric

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

attributedsales14d

numeric

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

attributedconversions14dsamesku

integer

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

attributedconversions14d

integer

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

attributedunitsordered14d

integer

Number of attributed units ordered within 14 days of click on ad

viewableimpressions

integer

Total number of ad viewable impressions

videofirstquartileviews

integer

videomidpointviews

integer

videothirdquartileviews

integer

videocompleteviews

integer

video5secondviews

integer

video5secondviewrate

Numeric

videounmutes

integer

vtr

Numeric

vctr

Numeric

unitssold14d

integer

dpv14d

integer

attributedbrandedsearches14d

integer

download_date

Date

Download Date

Last updated