Amazon Marketing Stream

Data Availability & Refresh Schedule

Historical Availability

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
Amazon Marketing Stream	1 day

For historical data going further back, please write to us at [email protected]

Data Refresh Schedule

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
Amazon Marketing Stream	1 days

Sponsored Ads Budget Usage

Table name: ad_marketingstream_budgetusage

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

Column Name	Data type	Description
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

Sponsored Products Conversions

Table name: ad_marketingstream_conversions

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

Sponsored Products Traffic

Table name: ad_marketingstream_traffic

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

Sponsored Display Conversions

Table name: ad_marketingstream_sponsoreddisplay_conversions

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

Sponsored Display Traffic

Table name: ad_marketingstream_sponsoreddisplay_traffic

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