Sponsored Display
Last updated
Last updated
Table name: ad_sponsoreddisplay_campaign
For details on data availability and refresh schedule, please click here.
| Column Name | Data type | Description |
|---|---|---|
Table name: ad_sponsoreddisplay_campaign_report
For details on data availability and refresh schedule, please click here.
Table name: ad_sponsoreddisplay_adgroup
For details on data availability and refresh schedule, please click here.
Table name: ad_sponsoreddisplay_adgroup_report
For details on data availability and refresh schedule, please click here.
Table name: ad_sponsoreddisplay_productad
For details on data availability and refresh schedule, please click here.
Table name: ad_sponsoreddisplay_productad_report
For details on data availability and refresh schedule, please click here.
Table name: ad_sponsoreddisplay_target
For details on data availability and refresh schedule, please click here.
Table name: ad_sponsoreddisplay_target_report
For details on data availability and refresh schedule, please click here.
| Column Name | Data type | Description |
|---|---|---|
| Column Name | Data type | Description |
|---|---|---|
| Column Name | Data type | Description |
|---|---|---|
| Column Name | Data type | Description |
|---|---|---|
| Column Name | Data type | Description |
|---|---|---|
| Column Name | Data type | Description |
|---|---|---|
| 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
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
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
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
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
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
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
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