Brand Analytics Reports
Brand Analytics Reports are available for both Seller and Vendor accounts
Data Source
To enable Brand Analytics Promotion Performance, Brand Analytics Market Basket Analysis & Brand Analytics Repeat Purchase Reports, the datasource: Amazon Vendor Central has to be enabled on the Intentwise Platform
Brand Analytics Promotion Performance
Table name: brandanalytics_promotionperformance_report
The Promotion Performance report contains data to help vendors/sellers optimize their promotions and adjust their advertising strategies. Currently, three promotion types are supported: Best Deal, Lightning Deal, and Price Discount.
Frequency: Daily
Note: The promotion's start date in the request is always the beginning of the current year, and the end date is the previous day. Essentially, year-to-date data is retrieved daily. Using the most recent report date for reporting purposes would be ideal.
account_id
Integer
Intentwise account id
account_name
String
Intentwise account name
currency_code
String
Currency code
report_date
date
Date for which the metrics belongs
promotion_id
String
The unique identifier of the promotion
promotion_name
String
The customer facing name of the promotion
vendor_code
String
The vendor code associated with the promotion funding agreement. For vendors only.
amount_spent_currency_code
String
The ISO 4217 currency code of amountSpent
revenue_currency_code
String
The ISO 4217 currency code of revenue.
type
String
The type of the promotion
status
String
The state that the promotion is in.
funding_agreement_id
String
The ID for the funding agreement. For vendors only.
start_date_time
Timestamp
Promotion start date-time in ISO 8601 format in UTC.
end_date_time
Timestamp
Promotion end date-time in ISO 8601 format in UTC.
created_date_time
Timestamp
The promotion creation date-time in ISO 8601 format in UTC.
last_updated_date_time
Timestamp
The promotion last updated date-time in ISO 8601 format in UTC.
asin
String
Amazon Standard Identification Number. The unique identifier given to a product
product_name
String
Name of the Product
product_glance_views
Integer
The number of customer views of the product detail page.
product_units_sold
Integer
The number of units sold at the promotional price
product_amount_spent
Numeric
Total funding provided across all ASINs in the promotion. For vendors only.
product_revenue
Numeric
The total revenue generated across all ASINs in the promotion. For sellers, this is equivalent to "sales" in the Seller Central UI.
download_date
Date
Download Date
merchant_id
String
marketplace_id
String
Brand Analytics Market Basket Analysis
Table name: brandanalytics_marketbasket_report
Vendor Central Console Report : Market Basket Analysis
Frequency: Daily
account_id
int8
Intentwise account id
account_name
varchar(1020)
Intentwise account name
report_date
date
Date for which the metrics belongs
asin
varchar(255)
Amazon Standard Identification Number. The unique identifier given to a product
purchased_with_asin
varchar(255)
The ASIN of the product that is 2nd most frequently purchased with your product.
purchased_with_rank
int4
Purchased with Rank
combination_pct
numeric(12, 2)
Percentage of orders that contain both your product and the #1 purchased product in comparison to the total number of orders that contained at least two different items including your product.
download_date
date
Report downloaded date
Brand Analytics Repeat Purchase
Table name: brandanalytics_repeatpurchase_report
Vendor Central Console Report : Repeat Purchase Behavior
Frequency: Weekly (Friday)
For details on data availability and refresh schedule, please click here.
account_id
Integer
Intentwise account id
account_name
String
Intentwise account name
currency_code
String
Currency Code
start_date
Date
Week start date
end_date
Date
Week end date
asin
String
Amazon Standard Identification Number. The unique identifier given to a product
orders
Integer
Number of orders. An order may include multiple quantities of a product and differs from ordered units.
unique_customers
Integer
Number of unique customers who placed an order in the selected reporting time frame.
repeat_customers_pct_total
Numeric
Displayed percent of total.
repeat_purchase_revenue_amount
Numeric
Ordered revenue from repeat customers. Returns are not reflected.
repeat_purchase_revenue_currency_code
String
Currency Code
repeat_purchase_revenue_pct_total
Numeric
Displayed percent of total.
download_date
Date
Download date of report
Brand Analytics Search Terms Report
Table name: brandanalytics_searchterms_report
Vendor Central Console Report: Amazon Search Terms
Frequency: Weekly (Wednesday)
For details on data availability and refresh schedule, please click here. Data Source
To enable Brand Analytics Search Terms Report, the datasource: Amazon Brand Search Term Report has to be enabled on the Intentwise Platform
country_code
String
Country Code
marketplace_id
String
Amazon marketplace Id
department_name
String
Amazon department - Amazon.com, Amazon.co.uk etc
search_term
String
Keyword searched by Amazon customers
search_frequency_rank
Integer
Ranking based on search frequency
clicked_asin
String
Most clicked ASIN based on the search results in the selected time frame
clicked_item_name
String
Name of the Product
click_share_rank
Integer
Click Share Rank
click_share
Numeric
Clicks that the product received in comparison to the total clicks based on the search results in the selected time frame
conversion_share
Numeric
Conversions that the product achieved in comparison to the total conversions based on the search results in the selected time frame
report_start_date
Date
Report Start Date
report_end_date
Date
Report End Date
Brand Analytics Search Query Performance Report
Table name: brandanalytics_searchqueryperformance_report
For Details on the description and console report, click here
Frequency: Weekly
Availability: Sellers with the Brand Analytics Selling Partner API role are registered in the Amazon Brand Registry.
Note: This provides overall query performance, such as impressions, clicks, cart adds, and purchases, for a given ASIN and specified date range.
Data Source
To enable Brand Analytics Search Query Performance Report, the datasource: Amazon Search Analytics has to be enabled on the Intentwise Platform
account_id
Integer
Intentwise Account Id
account_name
String
Intentwise Account Name
currency_code
String
Currency Code
id
Integer
ID
start_date
Date
Report Start Date
end_date
Date
Report End Date
asin
String
A list of Amazon Standard Identification Numbers (ASINs)
search_query
String
Search Query
search_query_score
Integer
Score based on search query
search_query_volume
Integer
Volume based on search query
total_query_impression_count
Integer
Total Query Impression Count
asin_impression_count
Integer
Asin Impression Count
asin_impression_share
Integer
Asin Impression Share
total_click_count
Integer
Total Click Count
total_click_rate
Integer
Total Click Rate
asin_click_count
Integer
Asin Click Count
asin_click_share
Integer
Asin Click Share
total_median_click_price_amount
Integer
Total Median Click Price Amount
total_median_click_price_currency_code
String
Total Median Click Price Currency Code
asin_median_click_price_amount
Integer
Asin Median Click Price Amount
asin_median_click_price_currency_code
String
Asin Median Click Price Currency Code
total_same_day_shipping_click_count
Integer
Total Same Day Shipping Click Count
total_one_day_shipping_click_count
Integer
Total One Day Shipping Click Count
total_two_day_shipping_click_count
Integer
Total Two Day Shipping Click Count
total_cart_add_count
Integer
Total Cart Add Count
total_cart_add_rate
Integer
Total Cart Add Rate
asin_cart_add_count
Integer
Asin Cart Add Count
asin_cart_add_share
Integer
Asin Cart Add Share
total_median_cart_add_price_amount
Integer
Total Median Cart Add Price Amount
total_median_cart_add_price_currency_code
String
Total Median Cart Add Price Currency Code
asin_median_cart_add_price_amount
Integer
Asin Median Cart Add Price Amount
asin_median_cart_add_price_currency_code
String
Asin Median Cart Add Price Currency Code
total_same_day_shipping_cart_add_count
Integer
Total Same Day Shipping Cart Add Count
total_one_day_shipping_cart_add_count
Integer
Total One Day Shipping Cart Add Count
total_two_day_shipping_cart_add_count
Integer
Total Two Day Shipping Cart Add Count
total_purchase_count
Integer
Total Purchase Count
total_purchase_rate
Integer
Total Purchase Rate
asin_purchase_count
Integer
Asin Purchase Count
asin_purchase_share
Integer
Asin Purchase Share
total_median_purchase_price_amount
Integer
Total Median Purchase Price Amount
total_median_purchase_price_currency_code
String
Total Median Purchase Price Currency Code
asin_median_purchase_price_amount
Integer
Asin Median Purchase Price Amount
asin_median_purchase_price_currency_code
String
Asin Median Purchase Price Currency Code
total_same_day_shipping_purchase_count
Integer
Total Same Day Shipping Purchase Count
total_one_day_shipping_purchase_count
Integer
Total One Day Shipping Purchase Count
total_two_day_shipping_purchase_count
Integer
Total Two Day Shipping Purchase Count
seller_id
String
Selling Partner ID
download_date
Date
Download Date
Brand Analytics Search Catalog Performance Report
Table name: brandanalytics_searchcatalogperformance_report
For Details on the description and console report, click here
Frequency: Weekly
Availability: Sellers with the Brand Analytics Selling Partner API role are registered in the Amazon Brand Registry.
Note: Provides search engagement metrics such as impressions, clicks, cart adds, and purchases for a specified date range.
account_id
Integer
Intentwise account id
account name
String
Intentwise account name
asin
String
A list of Amazon Standard Identification Numbers (ASINs)
cart_add_count
Integer
Cart Add Count
cart_added_median_price_amount
Numeric
Cart Added Median Price Amount
cart_added_median_price_currency_code
String
Cart Added Median Price Currency Code
click_count
Integer
Click Count
click_rate
Numeric
Click Rate
clicked_median_price_amount
Numeric
Clicked Median Price Amount
clicked_median_price_currency_code
String
Clicked Median Price Currency Code
conversion_rate
Numeric
Conversion Rate
download_date
Date
Download Date
end_date
Date
End Date
id
Integer
Id
impression_count
Integer
Impression Count
impression_median_price_amount
Numeric
Impression Median Price Amount
impression_median_price_currency_code
String
Impression Median Price Currency Code
one_day_shipping_cart_add_count
Integer
One Day Shipping Cart Add Count
one_day_shipping_click_count
Integer
One Day Shipping Click Count
one_day_shipping_impression_count
Integer
One Day Shipping Impression Count
one_day_shipping_purchase_count
Integer
One Day Shipping Purchase Count
purchase_count
Integer
Purchase Count
purchase_median_price_amount
Numeric
Purchase Median Price Amount
purchase_median_price_currency_code
String
Purchase Median Price Currency Code
report_period
String
Report Period
same_day_shipping_cart_add_count
Integer
Same Day Shipping Cart Add Count
same_day_shipping_click_count
Integer
Same Day Shipping Click Count
same_day_shipping_impression_count
Integer
Same Day Shipping Impression Count
same_day_shipping_purchase_count
Integer
Same Day Shipping Purchase Count
search_traffic_sales_amount
Numeric
Search Traffic Sales Amount
search_traffic_sales_currency_code
String
Search Traffic Sales Currency Code
seller_id
String
Selling Partner ID
start_date
Date
Start Date
two_day_shipping_cart_add_count
Integer
Two Day Shipping Cart Add Count
two_day_shipping_click_count
Integer
Two Day Shipping Click Count
two_day_shipping_impression_count
Integer
Two Day Shipping Impression Count
two_day_shipping_purchase_count
Integer
Two Day Shipping Purchase Count
Replenishment Reports
Replenishment Reports are available for both Seller and Vendor accounts
Replenishment Offer
Table name: replenishment_offer
Download Frequency: WEEKLY
Report Documentation: Replenishment Report API
account_id
Integer
Intentwise Account Id
account_name
String
Intentwise Account Name
marketplace_id
String
Marketplace ID
auto_enrollment
String
The auto-enrollment preference indicates whether the offer is opted-in to or opted-out of Amazon's auto-enrollment feature.
asin
String
A list of Amazon Standard Identification Numbers (ASINs)
sku
String
The SKU. This property is only supported for sellers and not for vendors.
selling_partner_funded_base_discount_percentage
numeric
A base discount set by the selling partner on the offer.
selling_partner_funded_tiered_discount_percentage
numeric
A tiered discount set by the selling partner on the offer.
amazon_funded_base_discount_percentage
numeric
A base discount set by Amazon on the offer.
amazon_funded_tiered_discount_percentage
numeric
A tiered discount set by Amazon on the offer.
enrollment_method
String
Determines whether the offer was automatically or manually enrolled in the program. This property is only supported for sellers and not vendors.
program_type
String
The replenishment program type Ex: SUBSCRIBE_AND_SAVE
eligibility
String
The current eligibility status of an offer.
vendor_codes
String
A list of vendor codes associated with the offer
download_date
Date
Download date
fulfillment_network_id_type
String
The fulfillment network identifier type for the offer, indicating how the offer is fulfilled.
delivery_condition
String
A list of delivery conditions for the offer, indicating the health of upcoming deliveries.
delivery_condition_next_30_days_deliveries
String
The condition type of upcoming deliveries for the offer.
price
numeric
The current price of the offer. This is the listed price amount for the item.
price_currency_code
String
The currency code in ISO 4217 format for the price. For example, USD for US dollars.
inventory
Integer
The available inventory count for the offer.
next_15_days_forecast_deliveries
Integer
An object which contains the projected subscriber demand for the offer over different time horizons.
next_30_days_forecast_deliveries
Integer
An object which contains the projected subscriber demand for the offer over different time horizons.
next_60_days_forecast_deliveries
Integer
An object which contains the projected subscriber demand for the offer over different time horizons.
next_90_days_forecast_deliveries
Integer
An object which contains the projected subscriber demand for the offer over different time horizons.
Replenishment Offer Metrics
Table name: replenishment_offer_metrics
Download Frequency: Weekly
Report Documentation: Replenishment Report API
account_id
Integer
Intentwise Account Id
account_name
String
Intentwise Account Name
marketplace_id
String
Marketplace ID
program_type
String
The replenishment program type Ex: SUBSCRIBE_AND_SAVE
aggregation_frequency
String
Aggreation frequency - Week.
time_period_type
String
The time period type - PERFORMANCE
asin
String
A list of Amazon Standard Identification Numbers (ASINs)
sku
String
The SKU. This property is only supported for sellers and not for vendors.
not_delivered_due_to_oos
numeric
The percentage of items that were not shipped out of the total shipped units over a period of time due to being out of stock. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
Maximum value : 100
total_subscriptions_revenue
numeric
The revenue generated from subscriptions over a period of time. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
shipped_subscription_units
numeric
The number of units shipped to the subscribers over a period of time. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
active_subscriptions
numeric
The number of active subscriptions present at the end of the period. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
revenue_penetration
numeric
The percentage of total program revenue out of total product revenue. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
Maximum value : 100
start_date
date
Start Date of the week
end_date
date
End Date of the week
download_date
date
Download Date
fulfillment_channel_type
String
The fulfillment channel type of an offer. Note that this is only valid for sellers and not for vendors.
lost_revenue_due_to_oos
Numeric
The revenue that would have been generated had there not been out of stock. Applicable to PERFORMANCE timePeriodType.
coupons_revenue_penetration
Numeric
The percentage of revenue from ASINs with coupons out of total revenue from all ASINs
share_of_coupon_subscriptions
Numeric
The percentage of new subscriptions acquired through coupons
Replenishment Offer Metrics Monthly
Table name: replenishment_offer_metrics_monthly
Download Frequency: Monthly
Report Documentation: Replenishment Report API
account_id
Integer
Intentwise Account Id
account_name
String
Intentwise Account Name
marketplace_id
String
Marketplace ID
program_type
String
The replenishment program type Ex: SUBSCRIBE_AND_SAVE
aggregation_frequency
String
Aggreation frequency - Month.
time_period_type
String
The time period type - PERFORMANCE
asin
String
A list of Amazon Standard Identification Numbers (ASINs)
sku
String
The SKU. This property is only supported for sellers and not for vendors.
not_delivered_due_to_oos
numeric
The percentage of items that were not shipped out of the total shipped units over a period of time due to being out of stock. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
Maximum value : 100
total_subscriptions_revenue
numeric
The revenue generated from subscriptions over a period of time. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
shipped_subscription_units
numeric
The number of units shipped to the subscribers over a period of time. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
active_subscriptions
numeric
The number of active subscriptions present at the end of the period. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
revenue_penetration
numeric
The percentage of total program revenue out of total product revenue. Applicable only for the PERFORMANCE timePeriodType.
Minimum value : 0
Maximum value : 100
start_date
date
Start Date of the week
end_date
date
End Date of the week
download_date
date
Download Date
fulfillment_channel_type
String
The fulfillment channel type of an offer. Note that this is only valid for sellers and not for vendors.
lost_revenue_due_to_oos
Numeric
The revenue that would have been generated had there not been out of stock. Applicable to PERFORMANCE timePeriodType.
coupons_revenue_penetration
Numeric
The percentage of revenue from ASINs with coupons out of total revenue from all ASINs
share_of_coupon_subscriptions
Numeric
The percentage of new subscriptions acquired through coupons
Replenishment Offer Metrics Forecast
Table name: replenishment_offer_metrics_forecast
Download Frequency: WEEKLY
Report Documentation: Replenishment Report API
account_id
Integer
Intentwise Account Id
account_name
String
Intentwise Account Name
currency_code
String
Currency Code
program_type
String
The replenishment program type Ex: SUBSCRIBE_AND_SAVE
time_period_type
String
The time period type - FORECAST
fulfillment_channel_type
String
The fulfillment channel type of an offer. Note that this is only valid for sellers and not for vendors.
asin
String
A list of Amazon Standard Identification Numbers (ASINs)
sku
String
The SKU. This property is only supported for sellers and not for vendors.
next_30_day_total_subscriptions_revenue
numeric
The projected total revenue expected from active and renewing subscriptions over the next 30 days, based on current customer subscription patterns and pricing
next_60_day_total_subscriptions_revenue
numeric
The projected total revenue expected from active and renewing subscriptions over the next 60 days, based on current customer subscription patterns and pricing
next_90_day_total_subscriptions_revenue
numeric
The projected total revenue expected from active and renewing subscriptions over the next 90 days, based on current customer subscription patterns and pricing
next_30_day_shipped_subscription_units
numeric
The forecasted number of subscription-based product units expected to be shipped in the next 30 days
next_60_day_shipped_subscription_units
numeric
The forecasted number of subscription-based product units expected to be shipped in the next 60 days
next_90_day_shipped_subscription_units
numeric
The forecasted number of subscription-based product units expected to be shipped in the next 90 days
start_date
date
Start Date
end_date
date
End Date
download_date
date
Download date
Last updated
Was this helpful?