Sponsored Display

Sponsored Display Campaign

Table name: ad_sponsoreddisplay_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	Campaign id
name	String	Campaign name
tactic	String
budgettype	String	The time period over which the amount specified in the budget property is allocated
budget	Numeric	Budget set for the campaign
startdate	Date	Start date of the campaign
enddate	Date	End date of the campaign
state	String	Campaign state
portfolioid	Integer	Amazon advertising account id
servingstatus	String	The status of the campaign 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
costtype	String	Determines how the campaign will bid and charge
creationdate	Date Time	Campaign created date
lastupdateddate	Date Time	Campaign last updated date

Sponsored Display Campaign Report

Table name: ad_sponsoreddisplay_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
viewimpressions	integer	Total number of ad viewable impressions
viewattributedconversions14d	integer	Total number of attributed conversion events occurring within 14 days of ad click or view
viewattributedsales14d	numeric	Total number of attributed sales occurring within 14 days of ad click or view
viewattributedunitsordered14d	integer	Total number of attributed units ordered occurring within 14 days of ad click or view

Sponsored Display AdGroup

Table name: ad_sponsoreddisplay_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
name	string	Adgroup name
campaignid	integer	Campaign id
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

Sponsored Display AdGroup Report

Table name: ad_sponsoreddisplay_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
adgroupname	string	Adgroup name
campaignid	integer	Campaign id
campaignname	string	Campaign name
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
viewimpressions	integer	Total number of ad viewable impressions
viewattributedconversions14d	integer	Total number of attributed conversion events occurring within 14 days of ad click or view
viewattributedsales14d	numeric	Total number of attributed sales occurring within 14 days of ad click or view
viewattributedunitsordered14d	integer	Total number of attributed units ordered occurring within 14 days of ad click or view

Sponsored Display Advertised Product

Table name: ad_sponsoreddisplay_productad

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
adgroupid	integer	Adgroup id
campaignid	integer	Campaign id
asin	string	The ASIN that is being advertised.
sku	string	The SKU that is being advertised. Not available for vendors.
state	string	The ASIN that is being advertised.
creationdate	timestamptz(0)	The ASIN that is being advertised.
lastupdateddate	timestamptz(0)	The ASIN that is being advertised.
servingstatus	string	The status of the product ad. 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, AD_STATUS_LIVE, AD_STATUS_PAUSED, AD_STATUS_ARCHIVED, MISSING_IMAGE, MISSING_DECORATION, NOT_BUYABLE, NOT_IN_BUYBOX, OUT_OF_STOCK, NOT_IN_POLICY

Sponsored Display Advertised Product Report

Table name: ad_sponsoreddisplay_productad_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
adid	Integer
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 advertise
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
viewimpressions	Integer	Total number of ad viewable impressions
viewattributedconversions14d	Integer	Total number of attributed conversion events occurring within 14 days of ad click or view
viewattributedsales14d	Numeric	Total number of attributed sales occurring within 14 days of ad click or view
viewattributedunitsordered14d	Integer	Total number of attributed units ordered occurring within 14 days of ad click or view

Sponsored Display Target

Table name: ad_sponsoreddisplay_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	Target state
bid	numeric
creationdate	timestamptz(0)	target created date
lastupdateddate	timestamptz(0)	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 review rating that is between the review ratings expressed
asinsameas	string	Target an ASIN that is the same as the ASIN expressed
asinisprimeshippingeligible	string	Target products that are Prime Shipping Eligible. This refinement can be applied at a category or brand level only
asinagerangesameas	string	Target an age range that is in the expressed range. This refinement can be applied for toys and games categories only
asingenresameas	string	Target products related to the expressed genre. This refinement can be applied for Books and eBooks categories only
servingstatus	string	The status of the target. 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, TARGET_STATUS_LIVE, TARGET_STATUS_PAUSED, TARGET_STATUS_ARCHIVED
lookback	integer
views	string

Sponsored Display Target Report

Table name: ad_sponsoreddisplay_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
viewimpressions	integer	Total number of ad viewable impressions
viewattributedconversions14d	integer	Total number of attributed conversion events occurring within 14 days of ad click or view
viewattributedsales14d	numeric	Total number of attributed sales occurring within 14 days of ad click or view
viewattributedunitsordered14d	integer	Total number of attributed units ordered occurring within 14 days of ad click or view