IAC - Source Data
  • Source Data Models
  • Data Models
    • Amazon Source Data
      • Sponsored Ads
        • Sponsored Products
        • Sponsored Brands
        • Sponsored Display
        • Sponsored Television
      • Amazon Marketing Stream
      • Seller Central
        • Replenishment Reports
        • Business Reports
        • Order Reports
        • Inventory Reports
        • Fulfillment By Amazon
        • Performance Reports
        • Settlement Reports
        • Returns Reports
        • Finance Reports
      • Vendor Central
      • Brand Analytics Reports
      • Content Product Listing
      • Share of Voice
      • Amazon Marketing Cloud
      • Amazon DSP
      • Others
    • Criteo Source Data
      • Sponsored Ads
    • Walmart Source Data
      • Sponsored Ads
      • Marketplace Reports
  • Instacart Source Data
    • Instacart Source Data
  • Tiktok Source Data
    • Sponsored Ads
Powered by GitBook
On this page
  • Brand Analytics Promotion Performance
  • Brand Analytics Market Basket Analysis
  • Brand Analytics Repeat Purchase
  • Brand Analytics Search Terms Report
  • Brand Analytics Search Query Performance Report
  • Brand Analytics Search Catalog Performance Report

Was this helpful?

  1. Data Models
  2. Amazon Source Data

Brand Analytics Reports

Brand Analytics Reports are available for both Seller and Vendor accounts

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.

Column Name
Data Type
Description

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

Frequency: Daily

Column Name
Data type
Description

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

Frequency: Weekly (Friday)

Column Name
Data type
Description

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

Frequency: Weekly (Wednesday)

Column Name
Data type
Description

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

Frequency: Weekly

Note: This provides overall query performance, such as impressions, clicks, cart adds, and purchases, for a given ASIN and specified date range.

Column Name
Data type
Description

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

Frequency: Weekly

Note: Provides search engagement metrics such as impressions, clicks, cart adds, and purchases for a specified date range.

Column Name
Data Type
Description

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

PreviousVendor CentralNextContent Product Listing

Last updated 1 month ago

Was this helpful?

Vendor Central Console Report :

Vendor Central Console Report :

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

Vendor Central Console Report :

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

For Details on the description and console report, click

Availability: Sellers with the Brand Analytics Selling Partner API role are registered in the .

For Details on the description and console report, click

Availability: Sellers with the Brand Analytics Selling Partner API role are registered in the .

Market Basket Analysis
Repeat Purchase Behavior
Amazon Search Terms
here
Amazon Brand Registry
here
Amazon Brand Registry
here
here