# 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*](/iac-source-data/data-models/amazon-source-data/seller-central.md#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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/seller-central/business-reports.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.