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 TypeHistorical 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 TypeRefresh Window

Amazon Marketing Stream

1 days

Table name: ad_marketingstream_budgetusage

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

Column NameData typeDescription

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

Table name: ad_marketingstream_conversions

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

Column NameData typeDescription

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

Table name: ad_marketingstream_traffic

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

Column NameData typeDescription

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

Table name: ad_marketingstream_sponsoreddisplay_conversions

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

Column NameData typeDescription

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

Table name: ad_marketingstream_sponsoreddisplay_traffic

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

Column NameData typeDescription

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

Last updated