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
Frequency : Daily
Note: The promotion's start date in the request is always the beginning of the current year, and the end date is yesterday. 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
Promotion Id
promotion_name
String
Promotion Name
vendor_code
String
Vendor Code
amount_spent_currency_code
String
Promotion amount spent
revenue_currency_code
String
Currency code
type
String
Promotion Type
status
String
Promotion Status
funding_agreement_id
String
start_date_time
Timestamp
Promotion Start Date
end_date_time
Timestamp
Promotion End Date
created_date_time
Timestamp
last_updated_date_time
Timestamp
asin
String
Amazon Standard Identification Number. The unique identifier given to a product
product_name
String
Title of Product
product_glance_views
Integer
Product glance views
product_units_sold
Integer
Units Sold
product_amount_spent
Numeric
product_revenue
Numeric
Product Revenue
download_date
Date
Report Downloaded Date
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
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
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
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)
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
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)
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
Last updated
Was this helpful?