Amazon Marketing Stream
Last updated
Last updated
Historical availability of data refers to the pulling in of past data from Amazon in Intentwise Analytics. This refers to your data for the time period before you added a particular account as a data source under My Connections.
| Report Type | Historical Availability |
|---|---|
For historical data going further back, please write to us at [email protected]
Data for all Amazon Marketing Stream tables is updated daily between 7:30 AM PST to 10:30 AM PST.
Intentwise Analytics pulls in multiple days of data daily to account for variations in past data due to various factors like Amazon’s click attribution logic, cancellations/returns, adjustments by Amazon, etc.
The following table highlights the refresh window for each data source—the number of days for which we pull in data from Amazon in every data load cycle.
| Report Type | Refresh Window |
|---|---|
Table name: ad_marketingstream_budgetusage
For details on data availability and refresh schedule, please click here.
| Column Name | Data type | Description |
|---|---|---|
Table name: ad_marketingstream_conversions
For details on data availability and refresh schedule, please click here.
Table name: ad_marketingstream_traffic
For details on data availability and refresh schedule, please click here.
Table name: ad_marketingstream_sponsoreddisplay_conversions
For details on data availability and refresh schedule, please click here.
Table name: ad_marketingstream_sponsoreddisplay_traffic
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 |
|---|---|---|
Amazon Marketing Stream
1 day
Amazon Marketing Stream
1 days
advertiser_id
String
Numerical ID of the advertiser. Note that this value is not unique and may be the same across marketplaces.
profile_id
The identifier of the amazon advertising account
account_id
Intentwise account id
account_name
Intentwise account name
marketplace_id
String
The identifier of the marketplace to which the account is associated.
usage_updated_timestamp
Timestamp
Last evaluation time for budget usage.
budget_scope_id
String
The unique identifier of campaign or portfolio for which budget usage percentage is provided.
budget_scope_type
String
The type of budget scope. Currently supported values: CAMPAIGN or PORTFOLIO.
advertising_product_type
String
Advertising product type sp (Sponsored Products), sb (Sponsored Brands), or sd (Sponsored Display).
budget
Numeric
Value of budget for budget_scope_id. It will be rule-based budget if any budget rule is winning. Otherwise it will be the advertiser's set budget.
budget_usage_percentage
Numeric
Budget usage percentage (Spend divided by budget).
download_time
TimeStamp
Time of data download
profile_id
Integer
The identifier of the amazon advertising account
account_id
Integer
Intentwise account id
account_name
String
Intentwise account name
advertiser_id
String
Numerical ID of the advertiser. Note: this value is not unique and may be the same across marketplaces.
marketplace_id
String
The marketplace identifier associated with the account.
time_window_start
Timestamp
The start of the hour to which the performance data is attributed ISO 8601 date time.
currency
String
The currency used for all monetary values for entities under the profile.
ad_id
Integer
Unique numerical ID for the ad.
placement
String
The page location where an ad appeared.
campaign_id
Integer
Unique numerical ID for a campaign.
ad_group_id
Integer
Unique numerical ID for an ad group.
keyword_id
Integer
ID of the keyword used for a bid.
keyword_text
String
Keyword text
match_type
String
Match type of keyword
attributed_conversions_1d
Integer
Number of attributed conversion events occurring within 24 hours of ad click.
attributed_conversions_7d
Integer
Number of attributed conversion events occurring within 7 days of an ad click.
attributed_conversions_14d
Integer
Number of attributed conversion events occurring within 14 days of an ad click.
attributed_conversions_30d
Integer
Number of attributed conversion events occurring within 30 days of an ad click.
attributed_conversions_1d_same_sku
Integer
Number of attributed conversion events occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised.
attributed_conversions_7d_same_sku
Integer
Number of attributed conversion events occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised.
attributed_conversions_14d_same_sku
Integer
Number of attributed conversion events occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.
attributed_conversions_30d_same_sku
Integer
Number of attributed conversion events occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.
attributed_sales_1d
Numeric
Total value of sales occurring within 24 hours of an ad click.
attributed_sales_7d
Numeric
Total value of sales occurring within 7 days of an ad click.
attributed_sales_14d
Numeric
Total value of sales occurring within 14 days of an ad click.
attributed_sales_30d
Numeric
Total value of sales occurring within 30 days of an ad click.
attributed_sales_1d_same_sku
Numeric
Total value of sales occurring within 24 hours of ad click where the purchased SKU was the same as the SKU advertised.
attributed_sales_7d_same_sku
Numeric
Total value of sales occurring within 7 days of ad click where the purchased SKU was the same as the SKU advertised.
attributed_sales_14d_same_sku
Numeric
Total value of sales occurring within 14 days of ad click where the purchased SKU was the same as the SKU advertised.
attributed_sales_30d_same_sku
Numeric
Total value of sales occurring within 30 days of ad click where the purchased SKU was the same as the SKU advertised.
attributed_units_ordered_1d
Integer
Total number of units ordered within 24 hours of an ad click.
attributed_units_ordered_7d
Integer
Total number of units ordered within 7 days of an ad click.
attributed_units_ordered_14d
Integer
Total number of units ordered within 14 days of an ad click.
attributed_units_ordered_30d
Integer
Total number of units ordered within 30 days of an ad click.
attributed_units_ordered_1d_same_sku
Integer
Total number of units ordered within 24 hours of ad click where the purchased SKU was the same as the SKU advertised.
attributed_units_ordered_7d_same_sku
Integer
Total number of units ordered within 7 days of ad click where the purchased SKU was the same as the SKU advertised.
attributed_units_ordered_14d_same_sku
Integer
Total number of units ordered within 14 days of ad click where the purchased SKU was the same as the SKU advertised
attributed_units_ordered_30d_same_sku
Integer
Total number of units ordered within 30 days of ad click where the purchased SKU was the same as the SKU advertised.
download_time
Timestamp
Time of download
profile_id
Integer
The identifier of the amazon advertising account
account_id
Integer
Intentwise account id
account_name
String
Intentwise account name
advertiser_id
String
Numerical ID of the advertiser. Note: this value is not unique and may be the same across marketplaces.
marketplace_id
String
The marketplace identifier associated with the account.
impressions
Integer
Total ad impressions.
time_window_start
Timestamp
The start of the hour to which the performance data is attributed (ISO 8601 date time).
currency
String
The currency used for all monetary values for entities under the profile.
ad_id
Integer
Numerical ID of the advertiser. Note: this value is not unique and may be the same across marketplaces.
placement
String
The page location where an ad appeared.
campaign_id
Integer
Unique numerical ID for a campaign.
ad_group_id
Integer
Unique numerical ID for an ad group.
keyword_id
Integer
ID of the keyword used for a bid.
keyword_text
String
Text of the keyword or phrase used for a bid.
match_type
String
Type of matching for the keyword or phrase used in a bid.
cost
Numeric
Total cost of all clicks. Expressed in local currency.
clicks
Integer
Total ad clicks.
download_time
Timestamp
Time of download
profile_id
Integer
The identifier of the amazon advertising account
account_id
Integer
Intentwise account id
account_name
String
Intentwise account name
advertiser_id
String
Numerical ID of the advertiser. Note: this value is not unique and may be the same across marketplaces.
marketplace_id
String
The marketplace identifier associated with the account.
time_window_start
Timstamp
The start of the hour to which the performance data is attributed ISO 8601 date time.
currency
String
The currency used for all monetary values for entities under the profile.
ad_id
Integer
Unique numerical ID for the ad.
campaign_id
Integer
Unique numerical ID for a campaign.
ad_group_id
Integer
Unique numerical ID for an ad group.
target_id
Integer
The identifier of the targeting expression.
attributed_conversions_14d
Integer
Number of attributed conversion events occurring within 14 days of an ad click.
attributed_sales_14d
Numeric
Total value of sales occurring within 14 days of an ad click.
attributed_units_ordered_14d
Integer
Total number of units ordered within 14 days of an ad click.
attributed_units_ordered_new_to_brand_14d
Integer
Total number of units ordered within 14 days of an ad click or view (for vCPM campaigns only).
attributed_sales_new_to_brand_14d
Numeric
Total value of new to brand sales within 14 days of an ad click.
attributed_orders_new_to_brand_14d
Integer
Total number of orders within 14 days of an ad click.
view_attributed_conversions_14d
Integer
Number of attributed conversion events occurring within 14 days of an ad click or view (for vCPM campaigns only).
view_attributed_sales_14d
Numeric
Total value of sales occurring within 14 days of an ad click or view (for vCPM campaigns only).
view_attributed_units_ordered_14d
Integer
Total number of units ordered within 14 days of an ad click or view (for vCPM campaigns only).
view_attributed_units_ordered_new_to_brand_14d
Integer
Total number of orders within 14 days of an ad click or view (for vCPM campaigns only).
view_attributed_sales_new_to_brand_14d
Numeric
Total value of new to brand sales within 14 days of an ad click or view (for vCPM campaigns only).
view_attributed_orders_new_to_brand_14d
Integer
Total number of new to brand units ordered within 14 days of an ad click or view (for vCPM campaigns only).
download_time
Timstamp
Time of download
profile_id
Integer
The identifier of the amazon advertising account
account_id
Integer
Intentwise account id
account_name
String
Intentwise account name
advertiser_id
String
Numerical ID of the advertiser. Note: this value is not unique and may be the same across marketplaces.
marketplace_id
String
The marketplace identifier associated with the account.
impressions
Integer
Total ad impressions.
time_window_start
Timestamp
The start of the hour to which the performance data is attributed (ISO 8601 date time).
currency
String
The currency used for all monetary values for entities under the profile.
campaign_id
Integer
Unique numerical ID for a campaign.
ad_group_id
Integer
Unique numerical ID for an ad group.
ad_id
Integer
Unique numerical ID for the ad.
target_id
Integer
The identifier of the targeting expression.
targeting_text
String
The text used in the targeting expression.
cost
Numeric
Total cost of all clicks (CPC) or click or view (vCPM). Expressed in local currency.
clicks
Integer
Total ad clicks.
view_impressions
Integer
Total ad viewable impressions (for vCPM campaigns only).
download_time
Timestamp
Time of download