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: |
advertising_product_type | String | Advertising product type |
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 |
Last updated