# rpt_dk_sales_traffic_by_date (https://sellersheetai.com/docs/data/rpt_dk_sales_traffic_by_date)

> Seller reports (SP-API) · DK_SALES_TRAFFIC_BY_DATE · Daily at 01:18 marketplace local time

- Family: seller
- Report type: `DK_SALES_TRAFFIC_BY_DATE`
- How fresh: Daily — Daily at 01:18 marketplace local time
- Need it right now: [`sales_getOrderMetrics`](https://sellersheetai.com/docs/mcp-api/tools/sales_getOrderMetrics) (sales, not traffic)
- Grain: per_mkt · sync: incremental

## Columns

| Column | Type | Key |
|---|---|---|
| `id` | INTEGER |  |
| `store_id` | VARCHAR(36) | key |
| `report_date` | DATE |  |
| `date` | DATE | key |
| `country_code` | VARCHAR(16) | key |
| `marketplace_id` | VARCHAR(20) |  |
| `currency_code` | VARCHAR(8) |  |
| `ordered_product_sales` | NUMERIC(16, 2) |  |
| `ordered_product_sales_b2b` | NUMERIC(16, 2) |  |
| `average_sales_per_order_item` | NUMERIC(16, 2) |  |
| `average_selling_price` | NUMERIC(16, 2) |  |
| `average_units_per_order_item` | NUMERIC(12, 4) |  |
| `shipped_product_sales` | NUMERIC(16, 2) |  |
| `claims_amount` | NUMERIC(16, 2) |  |
| `claims_granted` | INTEGER |  |
| `units_ordered` | INTEGER |  |
| `units_ordered_b2b` | INTEGER |  |
| `total_order_items` | INTEGER |  |
| `total_order_items_b2b` | INTEGER |  |
| `units_refunded` | INTEGER |  |
| `refund_rate` | NUMERIC(8, 4) |  |
| `units_shipped` | INTEGER |  |
| `orders_shipped` | INTEGER |  |
| `browser_page_views` | INTEGER |  |
| `mobile_app_page_views` | INTEGER |  |
| `page_views` | INTEGER |  |
| `browser_sessions` | INTEGER |  |
| `mobile_app_sessions` | INTEGER |  |
| `sessions` | INTEGER |  |
| `buy_box_percentage` | NUMERIC(8, 4) |  |
| `order_item_session_percentage` | NUMERIC(8, 4) |  |
| `unit_session_percentage` | NUMERIC(8, 4) |  |
| `average_offer_count` | INTEGER |  |
| `average_parent_items` | INTEGER |  |
| `feedback_received` | INTEGER |  |
| `negative_feedback_received` | INTEGER |  |
| `received_negative_feedback_rate` | NUMERIC(8, 4) |  |
| `extra` | JSON |  |

## Query it

```json
{
  "name": "query_report_data",
  "arguments": {
    "store": "myStore-US",
    "tables": [
      "rpt_dk_sales_traffic_by_date"
    ],
    "columns": [
      "rpt_dk_sales_traffic_by_date.date",
      "rpt_dk_sales_traffic_by_date.country_code"
    ],
    "order_by": [
      {
        "column": "rpt_dk_sales_traffic_by_date.date",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}
```