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

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

- Family: seller
- Report type: `GET_V2_SELLER_PERFORMANCE_REPORT`
- How fresh: Daily — Daily at 01:10 marketplace local time
- Need it right now: synced only
- Grain: per_mkt · sync: snapshot

## Columns

| Column | Type | Key |
|---|---|---|
| `id` | INTEGER |  |
| `store_id` | VARCHAR(36) | key |
| `marketplace_id` | VARCHAR(20) | key |
| `snapshot_date` | DATE | key |
| `account_status` | VARCHAR(50) |  |
| `account_health_rating` | VARCHAR(50) |  |
| `ahr_status` | VARCHAR(50) |  |
| `order_defect_rate` | NUMERIC(8, 4) |  |
| `afn_order_defect_rate` | NUMERIC(8, 4) |  |
| `mfn_order_defect_rate` | NUMERIC(8, 4) |  |
| `pre_fulfillment_cancel_rate` | NUMERIC(8, 4) |  |
| `late_shipment_rate` | NUMERIC(8, 4) |  |
| `valid_tracking_rate` | NUMERIC(8, 4) |  |
| `invoice_defect_rate` | NUMERIC(8, 4) |  |
| `on_time_delivery_rate` | NUMERIC(8, 4) |  |
| `unit_on_time_delivery_rate` | NUMERIC(8, 4) |  |
| `chargeback_claim_rate` | NUMERIC(8, 4) |  |
| `ahr_score` | NUMERIC(8, 2) |  |
| `late_shipment_count` | INTEGER |  |
| `late_shipment_order_count` | INTEGER |  |
| `missing_invoice_count` | INTEGER |  |
| `late_invoice_count` | INTEGER |  |
| `invoice_defect_order_count` | INTEGER |  |
| `afn_order_count` | INTEGER |  |
| `afn_claims_count` | INTEGER |  |
| `afn_chargebacks_count` | INTEGER |  |
| `afn_negative_feedback_count` | INTEGER |  |
| `mfn_order_count` | INTEGER |  |
| `mfn_claims_count` | INTEGER |  |
| `mfn_chargebacks_count` | INTEGER |  |
| `mfn_negative_feedback_count` | INTEGER |  |
| `on_time_delivery_count` | INTEGER |  |
| `unit_on_time_delivery_count` | INTEGER |  |
| `total_unit_count` | INTEGER |  |
| `valid_tracking_count` | INTEGER |  |
| `pre_fulfillment_cancel_count` | INTEGER |  |
| `listing_policy_violations` | INTEGER |  |
| `product_authenticity_complaints` | INTEGER |  |
| `product_condition_complaints` | INTEGER |  |
| `product_safety_complaints` | INTEGER |  |
| `received_ip_complaints` | INTEGER |  |
| `restricted_product_violations` | INTEGER |  |
| `suspected_ip_violations` | INTEGER |  |
| `food_and_product_safety_issues` | INTEGER |  |
| `customer_product_reviews_violations` | INTEGER |  |
| `other_policy_violations` | INTEGER |  |
| `document_requests` | INTEGER |  |
| `policy_violation_warnings` | INTEGER |  |
| `extra` | JSON |  |

## Query it

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