# Business Reports

## Business Reports

### Sale*s* And Traffic By Child ASIN Report

Table name: *sellercentral\_salesandtrafficbychildasin\_report*

Seller Central Console Report: [Sales And Traffic By Child ASIN Report](https://sellercentral.amazon.com/business-reports/#/report?id=102%3ADetailSalesTrafficByChildItem)

*For details on data availability and refresh schedule, please click*[ *here*](https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/seller-central/..#data-availability-and-refresh-schedule)*.*

<table><thead><tr><th>Column Name</th><th width="118.33333333333331">Data type</th><th>Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td>Intentwise Account Name</td></tr><tr><td>account_id</td><td>Integer</td><td>Intentwise Account Id</td></tr><tr><td>seller_id</td><td>String</td><td>Amazon Seller Id</td></tr><tr><td>country_code</td><td>String</td><td>Country code</td></tr><tr><td>currency_code</td><td>String</td><td>Currency code</td></tr><tr><td>download_date</td><td>Date</td><td>Date of Download</td></tr><tr><td>sale_date</td><td>date</td><td>Sale date</td></tr><tr><td>parent_asin</td><td>String</td><td>Parent ASIN</td></tr><tr><td>child_asin</td><td>String</td><td>Child ASIN</td></tr><tr><td>units_ordered</td><td>Integer</td><td>Number of units ordered</td></tr><tr><td>units_ordered_b2b</td><td>Integer</td><td>Number of units ordered by business buyers</td></tr><tr><td>ordered_product_sales_amt</td><td>Numeric</td><td>The amount of ordered product sales</td></tr><tr><td>ordered_product_sales_currency</td><td>String</td><td>Ordered product sales currency</td></tr><tr><td>ordered_product_sales_b2b_amt</td><td>Numeric</td><td>Amount of ordered product sales from business buyers </td></tr><tr><td>ordered_product_sales_b2b_currency</td><td>String</td><td>Ordered product sales currency</td></tr><tr><td>total_order_items</td><td>Integer</td><td>The total number of order items</td></tr><tr><td>total_order_items_b2b</td><td>Integer</td><td>The total number of items ordered by business buyers</td></tr><tr><td>traffic_by_asin_sessions</td><td>Integer</td><td>Sessions are visits to your Amazon.com pages by a user. All activity within a 24-hour period is considered a session</td></tr><tr><td>traffic_by_asin_sessions_prcntg</td><td>Numeric</td><td>Percentage of sessions that contain at least one page view for a particular SKU/ASIN relative to the total number of sessions for all products</td></tr><tr><td>traffic_by_asin_page_views</td><td>Integer</td><td>Total number of page views</td></tr><tr><td>traffic_by_asin_page_views_prcntg</td><td>Numeric</td><td>Percentage of page views that a particular SKU/ASIN receives relative to the total number of page views for all products</td></tr><tr><td>traffic_by_asin_buy_box_prcntg</td><td>Numeric</td><td>This is the percentage of page views where the Featured Offer (the add to shopping cart link) appeared on the page for customers to add your product to their cart</td></tr><tr><td>traffic_by_asin_units_session_prcntg</td><td>Numeric</td><td>Percentage conversion metric indicating how many units were purchased relative to the number of people who viewed the products</td></tr><tr><td>traffic_by_asin_units_session_prcntg_b2b</td><td>Numeric</td><td>Percentage conversion metrics (number of units purchased by business buyers relative to number of people who viewed the products)</td></tr><tr><td>traffic_by_asin_browser_sessions</td><td>Integer</td><td>Sessions are visits to your Amazon.com browser pages by a user. All activity within a 24-hour period is considered a session</td></tr><tr><td>traffic_by_asin_mobile_app_sessions</td><td>Integer</td><td>Sessions are visits to your Amazon.com App pages by a user. All activity within a 24-hour period is considered a session</td></tr><tr><td>traffic_by_asin_browser_sessions_prcntg</td><td>Numeric</td><td>Browser sessions percentage</td></tr><tr><td>traffic_by_asin_mobile_app_sessions_prcntg</td><td>Numeric</td><td>App sessions percentage</td></tr><tr><td>traffic_by_asin_browser_page_views</td><td>Integer</td><td>Hits in your Amazon.com browser </td></tr><tr><td>traffic_by_asin_mobile_app_page_views</td><td>Integer</td><td>Hits in your Amazon.com app </td></tr><tr><td>traffic_by_asin_browser_page_views_prcntg</td><td>Numeric</td><td>Browser views percentage</td></tr><tr><td>traffic_by_asin_mobile_app_page_views_prcntg</td><td>Numeric</td><td>App views percentage</td></tr><tr><td>traffic_by_asin_browser_sessions_b2b</td><td>Integer</td><td></td></tr><tr><td>traffic_by_asin_mobile_app_sessions_b2b</td><td>Integer</td><td></td></tr><tr><td>traffic_by_asin_sessions_b2b</td><td>Integer</td><td></td></tr><tr><td>traffic_by_asin_browser_sessions_prcntg_b2b</td><td>Numeric</td><td></td></tr><tr><td>traffic_by_asin_mobile_app_sessions_prcntg_b2b</td><td>Numeric</td><td></td></tr><tr><td>traffic_by_asin_session_prcntg_b2b</td><td>Numeric</td><td></td></tr><tr><td>traffic_by_asin_browser_page_views_b2b</td><td>Integer</td><td></td></tr><tr><td>traffic_by_asin_mobile_app_page_views_b2b</td><td>Integer</td><td></td></tr><tr><td>traffic_by_asin_page_views_b2b</td><td>Integer</td><td></td></tr><tr><td>traffic_by_asin_browser_page_views_prcntg_b2b</td><td>Numeric</td><td></td></tr><tr><td>traffic_by_asin_mobile_app_page_views_prcntg_b2b</td><td>Numeric</td><td></td></tr><tr><td>traffic_by_asin_page_views_prcntg_b2b</td><td>Numeric</td><td></td></tr><tr><td>traffic_by_asin_buy_box_prcntg_b2b</td><td>Numeric</td><td></td></tr></tbody></table>

### Sale*s* And Traffic By Date Report

Table name: *sellercentral\_salesandtrafficbydate\_report*

Seller Central Console Report: [Detail Page Sales And Traffic by Date](https://sellercentral.amazon.com/business-reports/#/report?id=102%3ASalesTrafficTimeSeries)

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

<table><thead><tr><th>Column Name</th><th width="121.33333333333331">Data type</th><th>Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td>Intentwise Account Name</td></tr><tr><td>account_id</td><td>Integer</td><td>Intentwise Account Id</td></tr><tr><td>seller_id</td><td>String</td><td>Intentwise Seller Id</td></tr><tr><td>country_code</td><td>String</td><td>Country Code</td></tr><tr><td>currency_code</td><td>String</td><td>Currency Code</td></tr><tr><td>sale_date</td><td>date</td><td>Sale Date</td></tr><tr><td>ordered_product_sales_amt</td><td>Numeric</td><td>The amount of ordered product sales</td></tr><tr><td>ordered_product_sales_currency</td><td>String</td><td>Ordered product sales currency</td></tr><tr><td>ordered_product_sales_b2b_amt</td><td>Numeric</td><td>The amount of ordered product sales by business buyers</td></tr><tr><td>ordered_product_sales_b2b_currency</td><td>String</td><td>Business buyers Ordered product sales currency</td></tr><tr><td>units_ordered</td><td>Integer</td><td>The total number of units  ordered</td></tr><tr><td>units_ordered_b2b</td><td>Integer</td><td>The total number of units  ordered by business buyers</td></tr><tr><td>total_order_items</td><td>Integer</td><td>The amount of ordered items</td></tr><tr><td>total_order_items_b2b</td><td>Integer</td><td>The amount of ordered items by business buyers</td></tr><tr><td>avg_sales_per_order_item_amt</td><td>Numeric</td><td>The average sales per order item, determined by dividing the ordered product sales by the total order items</td></tr><tr><td>avg_sales_per_order_item_currency</td><td>String</td><td>The average sales per order item currency</td></tr><tr><td>avg_sales_per_order_item_b2b_amt</td><td>Numeric</td><td>The average business buyers sales per order item, determined by dividing the ordered product sales by the total order items</td></tr><tr><td>avg_sales_per_order_item_b2b_currency</td><td>String</td><td>The business buyers average sales per order item currency</td></tr><tr><td>avg_units_per_order_item</td><td>Numeric</td><td>The average number of units for each order item</td></tr><tr><td>avg_units_per_order_item_b2b</td><td>Numeric</td><td>The average number of units for each item ordered by business buyers for the selected time period</td></tr><tr><td>avg_selling_price_amt</td><td>Numeric</td><td>The average price of units sold, calculated by dividing the total ordered product sales by the total units</td></tr><tr><td>avg_selling_price_currency</td><td>String</td><td>The average selling price currency</td></tr><tr><td>avg_selling_price_b2b_amt</td><td>Numeric</td><td>Average price of units sold to business buyers (total ordered product sales from business buyers ÷ total units from business buyers)</td></tr><tr><td>avg_selling_price_b2b_currency</td><td>String</td><td>The business buyers average selling price currency</td></tr><tr><td>units_refunded</td><td>Integer</td><td>Number of units refunded</td></tr><tr><td>refund_rate</td><td>Numeric</td><td>The refund rate, calculated by dividing the number of units refunded by the number of units sold</td></tr><tr><td>claims_granted</td><td>Integer</td><td>Number of A-to-z claims granted</td></tr><tr><td>claims_amount</td><td>Numeric</td><td>Monetary amount of filed A-to-z Guarantee Claims</td></tr><tr><td>claims_amount_currency</td><td>String</td><td>Claims amount currency</td></tr><tr><td>shipped_product_sales_amt</td><td>Numeric</td><td>The amount of shipped product sales, calculated by multiplying the price of the order items and the number of units sold and confirmed shipped</td></tr><tr><td>shipped_product_sales_currency</td><td>String</td><td>Shipped product sales currency</td></tr><tr><td>units_shipped</td><td>Integer</td><td>Number of units shipped</td></tr><tr><td>orders_shipped</td><td>Integer</td><td>Number of orders shipped</td></tr><tr><td>page_views</td><td>Integer</td><td>Hits in your Amazon.com presence</td></tr><tr><td>sessions</td><td>Integer</td><td>Sessions are visits to your Amazon.com pages by a user. All activity within a 24-hour period is considered a session</td></tr><tr><td>buy_box_percentage</td><td>Numeric</td><td>This is the percentage of page views where the Featured Offer (the add to shopping cart link) appeared on the page for customers to add your product to their cart</td></tr><tr><td>order_item_session_percentage</td><td>Numeric</td><td>The order item session percentage, calculated by dividing the total order items by the number of distinct session counts</td></tr><tr><td>order_item_session_percentage_b2b</td><td>Numeric</td><td>Order item session percentage (total order items from business buyers divided by the number of distinct session counts)</td></tr><tr><td>unit_session_percentage</td><td>Numeric</td><td>Percentage conversion metric indicating how many units were purchased relative to the number of people who viewed the products</td></tr><tr><td>unit_session_percentage_b2b</td><td>Numeric</td><td>Percentage conversion metrics (number of units purchased by business buyers relative to number of people who viewed the products)</td></tr><tr><td>avg_offer_count</td><td>Numeric</td><td>The total number of offers listed for sale</td></tr><tr><td>avg_parent_items</td><td>Numeric</td><td>The average number of parent items listed</td></tr><tr><td>feedback_received</td><td>Integer</td><td>Total number of customer feedback received</td></tr><tr><td>negative_feedback_received</td><td>Integer</td><td>Number of negative feedback received</td></tr><tr><td>received_negative_feedback_rate</td><td>Numeric</td><td>Total negative feedback received divided by total feedback received</td></tr><tr><td>browser_page_views</td><td>Integer</td><td>Hits in your Amazon.com browser</td></tr><tr><td>mobile_app_page_views</td><td>Integer</td><td>Hits in your Amazon.com app</td></tr><tr><td>browser_sessions</td><td>Integer</td><td>Sessions are visits to your Amazon.com browser pages by a user. All activity within a 24-hour period is considered a session</td></tr><tr><td>mobile_app_sessions</td><td>Integer</td><td>Sessions are visits to your Amazon.com app pages by a user. All activity within a 24-hour period is considered a session</td></tr><tr><td>download_date</td><td>Date</td><td></td></tr><tr><td>buy_box_percentage_b2b</td><td>Numeric</td><td></td></tr><tr><td>browser_page_views_b2b</td><td>Integer</td><td></td></tr><tr><td>mobile_app_page_views_b2b</td><td>Integer</td><td></td></tr><tr><td>page_views_b2b</td><td>Integer</td><td></td></tr><tr><td>browser_sessions_b2b</td><td>Integer</td><td></td></tr><tr><td>mobile_app_sessions_b2b</td><td>Integer</td><td></td></tr><tr><td>sessions_b2b</td><td>Integer</td><td></td></tr></tbody></table>

### Sale*s* And Traffic By SKU Report

Table name: sellercentral\_salesandtrafficbysku\_report

Seller Central Console Report: [Detail Page Sales And Traffic](https://sellercentral.amazon.com/business-reports/ref=xx_sitemetric_dnav_xx#/report?id=102%3ADetailSalesTrafficBySKU)

Note: This report is 2 days behind

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

<table><thead><tr><th>Column Name</th><th width="130.93330891927081">Data type</th><th>Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td>Intentwise Account Name</td></tr><tr><td>account_id</td><td>Integer</td><td>Intentwise Account Id</td></tr><tr><td>seller_id</td><td>String</td><td>Amazon Seller Id</td></tr><tr><td>country_code</td><td>String</td><td>Country code</td></tr><tr><td>currency_code</td><td>String</td><td>Currency code</td></tr><tr><td>sale_date</td><td>date</td><td>Sale date</td></tr><tr><td>parent_asin</td><td>String</td><td>Parent ASIN</td></tr><tr><td>child_asin</td><td>String</td><td>Child ASIN</td></tr><tr><td>sku</td><td>String</td><td>SKU</td></tr><tr><td>units_ordered</td><td>Integer</td><td>Number of units ordered</td></tr><tr><td>units_ordered_b2b</td><td>Integer</td><td>Number of units ordered by business buyers</td></tr><tr><td>ordered_product_sales_amt</td><td>Numeric</td><td>The amount of ordered product sales</td></tr><tr><td>ordered_product_sales_currency</td><td>String</td><td>Ordered product sales currency</td></tr><tr><td>ordered_product_sales_b2b_amt</td><td>Numeric</td><td>Amount of ordered product sales from business buyers </td></tr><tr><td>ordered_product_sales_b2b_currency</td><td>String</td><td>Ordered product sales currency</td></tr><tr><td>total_order_items</td><td>Integer</td><td>The total number of order items</td></tr><tr><td>total_order_items_b2b</td><td>Integer</td><td>The total number of items ordered by business buyers</td></tr><tr><td>traffic_by_asin_sessions</td><td>Integer</td><td>Sessions are visits to your Amazon.com pages by a user. All activity within a 24-hour period is considered a session</td></tr><tr><td>traffic_by_asin_sessions_prcntg</td><td>Numeric</td><td>Percentage of sessions that contain at least one page view for a particular SKU/ASIN relative to the total number of sessions for all products</td></tr><tr><td>traffic_by_asin_page_views</td><td>Integer</td><td>Total number of page views</td></tr><tr><td>traffic_by_asin_page_views_prcntg</td><td>Numeric</td><td>Percentage of page views that a particular SKU/ASIN receives relative to the total number of page views for all products</td></tr><tr><td>traffic_by_asin_buy_box_prcntg</td><td>Numeric</td><td>This is the percentage of page views where the Featured Offer (the add to shopping cart link) appeared on the page for customers to add your product to their cart</td></tr><tr><td>traffic_by_asin_units_session_prcntg</td><td>Numeric</td><td>Percentage conversion metric indicating how many units were purchased relative to the number of people who viewed the products</td></tr><tr><td>traffic_by_asin_units_session_prcntg_b2b</td><td>Numeri</td><td>Percentage conversion metrics (number of units purchased by business buyers relative to number of people who viewed the products)</td></tr><tr><td>traffic_by_asin_browser_sessions</td><td>Integer</td><td>Sessions are visits to your Amazon.com browser pages by a user. All activity within a 24-hour period is considered a session</td></tr><tr><td>traffic_by_asin_mobile_app_sessions</td><td>Integer</td><td>Sessions are visits to your Amazon.com App pages by a user. All activity within a 24-hour period is considered a session</td></tr><tr><td>traffic_by_asin_browser_sessions_prcntg</td><td>Numeric</td><td>Browser sessions percentage</td></tr><tr><td>traffic_by_asin_mobile_app_sessions_prcntg</td><td>Numeric</td><td>App sessions percentage</td></tr><tr><td>traffic_by_asin_browser_page_views</td><td>Integer</td><td>Hits in your Amazon.com browser </td></tr><tr><td>traffic_by_asin_mobile_app_page_views</td><td>Integer</td><td>Hits in your Amazon.com app </td></tr><tr><td>traffic_by_asin_browser_page_views_prcntg</td><td>Numeric</td><td>Browser views percentage</td></tr><tr><td>traffic_by_asin_mobile_app_page_views_prcntg</td><td>Numeric</td><td>App views percentage</td></tr><tr><td>download_date</td><td>Date</td><td></td></tr><tr><td>traffic_by_asin_browser_sessions_b2b</td><td>Integer</td><td></td></tr><tr><td>traffic_by_asin_mobile_app_sessions_b2b</td><td>Integer</td><td></td></tr><tr><td>traffic_by_asin_sessions_b2b</td><td>Integer</td><td></td></tr><tr><td>traffic_by_asin_browser_sessions_prcntg_b2b</td><td>Numeric</td><td></td></tr><tr><td>traffic_by_asin_mobile_app_sessions_prcntg_b2b</td><td>Numeric</td><td></td></tr><tr><td>traffic_by_asin_session_prcntg_b2b</td><td>Numeric</td><td></td></tr><tr><td>traffic_by_asin_browser_page_views_b2b</td><td>Integer</td><td></td></tr><tr><td>traffic_by_asin_mobile_app_page_views_b2b</td><td>Integer</td><td></td></tr><tr><td>traffic_by_asin_page_views_b2b</td><td>Integer</td><td></td></tr><tr><td>traffic_by_asin_browser_page_views_prcntg_b2b</td><td>Numeric</td><td></td></tr><tr><td>traffic_by_asin_mobile_app_page_views_prcntg_b2b</td><td>Numeric</td><td></td></tr><tr><td>traffic_by_asin_page_views_prcntg_b2b</td><td>Numeric</td><td></td></tr><tr><td>traffic_by_asin_buy_box_prcntg_b2b</td><td>Numeric</td><td></td></tr></tbody></table>