# Performance Reports

## Performance reports

### **Flat File Feedback Report**

Table name: *sellercentral\_flatfilefeedback\_report*

Seller Central Console Report: [Feedback Report](https://sellercentral.amazon.com/feedback-manager/index.html#/report) ([Help](https://sellercentral.amazon.com/gp/help/help-popup.html/?itemID=761))

*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)*.*

| Column Name   | Data type | Description |
| ------------- | --------- | ----------- |
| account\_id   | Integer   |             |
| account\_name | String    |             |
| seller\_id    | Integer   |             |
| rating        | Integer   |             |
| date          | Date      |             |
| comments      | String    |             |
| response      | String    |             |
| order\_id     | String    |             |
| rater\_email  | String    |             |

### **Seller Performance Report**

Table name (Primary): sellercentral\_sellerperformance\_report

Seller Central Console Report: [Account Health](https://sellercentral.amazon.com/performance/dashboard) ([Help](https://sellercentral.amazon.com/help/hub/reference/popup/200205250?ie=UTF8#mnd_2jc_jcb-1))

| Column Name           | Data type | Description (Refer help link above) |
| --------------------- | --------- | ----------------------------------- |
| account\_name         | String    |                                     |
| account\_id           | Integer   |                                     |
| country\_code         | String    |                                     |
| id                    | Integer   |                                     |
| reporting\_date\_from | Timestamp |                                     |
| reporting\_date\_to   | Timestamp |                                     |
| status                | String    |                                     |
| target\_value         | Numeric   |                                     |
| target\_condition     | String    |                                     |
| defects\_count        | Integer   |                                     |
| report\_date          | Date      |                                     |

Table name (Secondary): sellercentral\_sellerperformance\_shippingperformance\_report 

Foreign Key: seller\_performance\_report\_id , references  sellercentral\_sellerperformance\_report(id)

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

| Column Name                                                      | Data type | Description |
| ---------------------------------------------------------------- | --------- | ----------- |
| account\_name                                                    | String    |             |
| account\_id                                                      | Integer   |             |
| country\_code                                                    | String    |             |
| currency\_code                                                   | String    |             |
| seller\_performance\_report\_id                                  | Integer   |             |
| late\_shipment\_rate\_reporting\_date\_from                      | Timestamp |             |
| late\_shipment\_rate\_reporting\_date\_to                        | Timestamp |             |
| late\_shipment\_rate\_status                                     | String    |             |
| late\_shipment\_rate\_target\_value                              | Numeric   |             |
| late\_shipment\_rate\_target\_condition                          | String    |             |
| late\_shipment\_rate\_order\_count                               | Integer   |             |
| late\_shipment\_rate\_late\_shipment\_count                      | Integer   |             |
| late\_shipment\_rate\_rate                                       | Numeric   |             |
| on\_time\_delivery\_rate\_reporting\_date\_from                  | Timestamp |             |
| on\_time\_delivery\_rate\_reporting\_date\_to                    | Timestamp |             |
| on\_time\_delivery\_rate\_status                                 | String    |             |
| on\_time\_delivery\_rate\_target\_value                          | Numeric   |             |
| on\_time\_delivery\_rate\_target\_condition                      | String    |             |
| on\_time\_delivery\_rate\_shipment\_count\_with\_valid\_tracking | Integer   |             |
| on\_time\_delivery\_rate\_on\_time\_delivery\_count              | Integer   |             |
| on\_time\_delivery\_rate\_rate                                   | Numeric   |             |
| valid\_tracking\_rate\_reporting\_date\_from                     | Timestamp |             |
| valid\_tracking\_rate\_reporting\_date\_to                       | Timestamp |             |
| valid\_tracking\_rate\_status                                    | String    |             |
| valid\_tracking\_rate\_target\_value                             | Numeric   |             |
| valid\_tracking\_rate\_target\_condition                         | String    |             |
| valid\_tracking\_rate\_shipment\_count                           | Integer   |             |
| valid\_tracking\_rate\_valid\_tracking\_count                    | Integer   |             |
| valid\_tracking\_rate\_rate                                      | Numeric   |             |
| pre\_fulfillment\_cancellation\_rate\_reporting\_date\_from      | Timestamp |             |
| pre\_fulfillment\_cancellation\_rate\_reporting\_date\_to        | Timestamp |             |
| pre\_fulfillment\_cancellation\_rate\_status                     | String    |             |
| pre\_fulfillment\_cancellation\_rate\_target\_value              | Numeric   |             |
| pre\_fulfillment\_cancellation\_rate\_target\_condition          | String    |             |
| pre\_fulfillment\_cancellation\_rate\_order\_count               | Integer   |             |
| pre\_fulfillment\_cancellation\_rate\_cancellation\_count        | Integer   |             |
| pre\_fulfillment\_cancellation\_rate\_rate                       | Numeric   |             |
| download\_date                                                   | Date      |             |

Table name (Secondary): sellercentral\_sellerperformance\_policycompliance\_report

Foreign Key: seller\_performance\_report\_id , references  sellercentral\_sellerperformance\_report(id)

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

| Column Name                                                           | Data type | Description |
| --------------------------------------------------------------------- | --------- | ----------- |
| account\_name                                                         | String    |             |
| account\_id                                                           | Integer   |             |
| country\_code                                                         | String    |             |
| currency\_code                                                        | String    |             |
| seller\_performance\_report\_id                                       | Integer   |             |
| account\_health\_rating\_ahr\_status                                  | String    |             |
| account\_health\_rating\_reporting\_date\_from                        | Timestamp |             |
| account\_health\_rating\_reporting\_date\_to                          | Timestamp |             |
| listing\_policy\_violations\_reporting\_date\_from                    | Timestamp |             |
| listing\_policy\_violations\_reporting\_date\_to                      | Timestamp |             |
| listing\_policy\_violations\_status                                   | String    |             |
| listing\_policy\_violations\_target\_value                            | Numeric   |             |
| listing\_policy\_violations\_target\_condition                        | String    |             |
| listing\_policy\_violations\_defects\_count                           | Integer   |             |
| product\_authenticity\_cust\_complaints\_reporting\_date\_from        | Timestamp |             |
| product\_authenticity\_cust\_complaints\_reporting\_date\_to          | Timestamp |             |
| product\_authenticity\_cust\_complaints\_status                       | String    |             |
| product\_authenticity\_cust\_complaints\_target\_value                | Numeric   |             |
| product\_authenticity\_cust\_complaints\_target\_condition            | String    |             |
| product\_authenticity\_cust\_complaints\_defects\_count               | Integer   |             |
| product\_condition\_cust\_complaints\_reporting\_date\_from           | Timestamp |             |
| product\_condition\_cust\_complaints\_reporting\_date\_to             | Timestamp |             |
| product\_condition\_cust\_complaints\_status                          | String    |             |
| product\_condition\_cust\_complaints\_target\_value                   | Numeric   |             |
| product\_condition\_cust\_complaints\_target\_condition               | String    |             |
| product\_condition\_cust\_complaints\_defects\_count                  | Integer   |             |
| product\_safety\_cust\_complaints\_reporting\_date\_from              | Timestamp |             |
| product\_safety\_cust\_complaints\_reporting\_date\_to                | Timestamp |             |
| product\_safety\_cust\_complaints\_status                             | String    |             |
| product\_safety\_cust\_complaints\_target\_value                      | Numeric   |             |
| product\_safety\_cust\_complaints\_target\_condition                  | String    |             |
| product\_safety\_cust\_complaints\_defects\_count                     | Integer   |             |
| received\_intellectual\_property\_complaints\_reporting\_date\_from   | Timestamp |             |
| received\_intellectual\_property\_complaints\_reporting\_date\_to     | Timestamp |             |
| received\_intellectual\_property\_complaints\_status                  | String    |             |
| received\_intellectual\_property\_complaints\_target\_value           | Numeric   |             |
| received\_intellectual\_property\_complaints\_target\_condition       | String    |             |
| received\_intellectual\_property\_complaints\_defects\_count          | Integer   |             |
| restricted\_product\_policy\_violations\_reporting\_date\_from        | Timestamp |             |
| restricted\_product\_policy\_violations\_reporting\_date\_to          | Timestamp |             |
| restricted\_product\_policy\_violations\_status                       | String    |             |
| restricted\_product\_policy\_violations\_target\_value                | Numeric   |             |
| restricted\_product\_policy\_violations\_target\_condition            | String    |             |
| restricted\_product\_policy\_violations\_defects\_count               | Integer   |             |
| suspected\_intellectual\_property\_violations\_reporting\_date\_from  | Timestamp |             |
| suspected\_intellectual\_property\_violations\_reporting\_date\_to    | Timestamp |             |
| suspected\_intellectual\_property\_violations\_status                 | String    |             |
| suspected\_intellectual\_property\_violations\_target\_value          | Numeric   |             |
| suspected\_intellectual\_property\_violations\_target\_condition      | String    |             |
| suspected\_intellectual\_property\_violations\_defects\_count         | Integer   |             |
| food\_and\_product\_safety\_issues\_reporting\_date\_from             | Timestamp |             |
| food\_and\_product\_safety\_issues\_reporting\_date\_to               | Timestamp |             |
| food\_and\_product\_safety\_issues\_status                            | String    |             |
| food\_and\_product\_safety\_issues\_target\_value                     | Numeric   |             |
| food\_and\_product\_safety\_issues\_target\_condition                 | String    |             |
| food\_and\_product\_safety\_issues\_defects\_count                    | Integer   |             |
| customer\_product\_reviews\_policy\_violations\_reporting\_date\_from | Timestamp |             |
| customer\_product\_reviews\_policy\_violations\_reporting\_date\_to   | Timestamp |             |
| customer\_product\_reviews\_policy\_violations\_status                | String    |             |
| customer\_product\_reviews\_policy\_violations\_target\_value         | Numeric   |             |
| customer\_product\_reviews\_policy\_violations\_target\_condition     | String    |             |
| customer\_product\_reviews\_policy\_violations\_defects\_count        | Integer   |             |
| other\_policy\_violations\_reporting\_date\_from                      | Timestamp |             |
| other\_policy\_violations\_reporting\_date\_to                        | Timestamp |             |
| other\_policy\_violations\_status                                     | String    |             |
| other\_policy\_violations\_target\_value                              | Numeric   |             |
| other\_policy\_violations\_target\_condition                          | String    |             |
| other\_policy\_violations\_defects\_count                             | Integer   |             |
| download\_date                                                        | Date      |             |

Table name (Secondary): sellercentral\_sellerperformance\_customerserviceperformance\_report

Foreign Key: seller\_performance\_report\_id , references  sellercentral\_sellerperformance\_report(id)

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

| Column Name                                            | Data type | Description |
| ------------------------------------------------------ | --------- | ----------- |
| account\_name                                          | String    |             |
| account\_id                                            | Integer   |             |
| country\_code                                          | String    |             |
| currency\_code                                         | String    |             |
| seller\_performance\_report\_id                        | Integer   |             |
| order\_defect\_rate\_afn\_reporting\_date\_from        | Timestamp |             |
| order\_defect\_rate\_afn\_reporting\_date\_to          | Timestamp |             |
| order\_defect\_rate\_afn\_status                       | String    |             |
| order\_defect\_rate\_afn\_target\_value                | Numeric   |             |
| order\_defect\_rate\_afn\_target\_condition            | String    |             |
| order\_defect\_rate\_afn\_order\_with\_defects\_status | String    |             |
| order\_defect\_rate\_afn\_order\_with\_defects\_count  | Integer   |             |
| order\_defect\_rate\_afn\_claims\_status               | String    |             |
| order\_defect\_rate\_afn\_claims\_count                | Integer   |             |
| order\_defect\_rate\_afn\_chargebacks\_status          | String    |             |
| order\_defect\_rate\_afn\_chargebacks\_count           | Integer   |             |
| order\_defect\_rate\_afn\_negative\_feedback\_status   | String    |             |
| order\_defect\_rate\_afn\_negative\_feedback\_count    | Integer   |             |
| order\_defect\_rate\_afn\_order\_count                 | Integer   |             |
| order\_defect\_rate\_afn\_rate                         | Numeric   |             |
| order\_defect\_rate\_afn\_fulfillment\_type            | String    |             |
| order\_defect\_rate\_mfn\_reporting\_date\_from        | Timestamp |             |
| order\_defect\_rate\_mfn\_reporting\_date\_to          | Timestamp |             |
| order\_defect\_rate\_mfn\_status                       | String    |             |
| order\_defect\_rate\_mfn\_target\_value                | Numeric   |             |
| order\_defect\_rate\_mfn\_target\_condition            | String    |             |
| order\_defect\_rate\_mfn\_order\_with\_defects\_status | String    |             |
| order\_defect\_rate\_mfn\_order\_with\_defects\_count  | Integer   |             |
| order\_defect\_rate\_mfn\_claims\_status               | String    |             |
| order\_defect\_rate\_mfn\_claims\_count                | Integer   |             |
| order\_defect\_rate\_mfn\_chargebacks\_status          | String    |             |
| order\_defect\_rate\_mfn\_chargebacks\_count           | Integer   |             |
| order\_defect\_rate\_mfn\_negative\_feedback\_status   | String    |             |
| order\_defect\_rate\_mfn\_negative\_feedback\_count    | Integer   |             |
| order\_defect\_rate\_mfn\_order\_count                 | Integer   |             |
| order\_defect\_rate\_mfn\_rate                         | Numeric   |             |
| order\_defect\_rate\_mfn\_fulfillment\_type            | String    |             |
| invoice\_defect\_rate\_reporting\_date\_from           | Timestamp |             |
| invoice\_defect\_rate\_reporting\_date\_to             | Timestamp |             |
| invoice\_defect\_rate\_status                          | String    |             |
| invoice\_defect\_rate\_target\_value                   | Numeric   |             |
| invoice\_defect\_rate\_target\_condition               | String    |             |
| invoice\_defect\_rate\_invoice\_defect\_status         | String    |             |
| invoice\_defect\_rate\_invoice\_defect\_count          | Integer   |             |
| invoice\_defect\_rate\_missing\_invoice\_status        | String    |             |
| invoice\_defect\_rate\_missing\_invoice\_count         | Integer   |             |
| invoice\_defect\_rate\_late\_invoice\_status           | String    |             |
| invoice\_defect\_rate\_late\_invoice\_count            | Integer   |             |
| invoice\_defect\_rate\_order\_count                    | Integer   |             |
| invoice\_defect\_rate\_rate                            | Numeric   |             |
| download\_date                                         | Date      |             |

Table name (Secondary): sellercentral\_sellerperformance\_lateshipment\_report

Foreign Key: seller\_performance\_report\_id , references  sellercentral\_sellerperformance\_report(id)

*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="238.5999755859375">Data type</th><th>Description</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td></td></tr><tr><td>account_id</td><td>Integer</td><td></td></tr><tr><td>country_code</td><td>String</td><td></td></tr><tr><td>currency_code</td><td>String</td><td></td></tr><tr><td>seller_performance_report_id</td><td>Integer</td><td></td></tr><tr><td>reporting_date_from</td><td>DateTime</td><td></td></tr><tr><td>reporting_date_to</td><td>DateTime</td><td></td></tr><tr><td>status</td><td>String</td><td></td></tr><tr><td>target_value</td><td>Numeric</td><td></td></tr><tr><td>target_condition</td><td>String</td><td></td></tr><tr><td>order_count</td><td>Integer</td><td></td></tr><tr><td>shipment_count</td><td>Integer</td><td></td></tr><tr><td>rate</td><td>Numeric</td><td></td></tr><tr><td>report_date</td><td>Date</td><td></td></tr><tr><td>download_date</td><td>Date</td><td></td></tr></tbody></table>

## **Seller Coupon Performance Report**

Table name: sellercentral\_couponperformance\_report

Note: Data for the current year is retrieved daily based on the start and end dates of coupons. Its recommended to use latest report\_date information

*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 width="220">Column Name</th><th width="156.79545454545456">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 Identifier</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>coupon_performance_report_id</td><td>Integer</td><td>Unique identifer for the report</td></tr><tr><td>coupon_start_date_from</td><td>Timestamp</td><td>Coupon Start Date</td></tr><tr><td>coupon_start_date_to</td><td>Timestamp</td><td>Coupon End Date</td></tr><tr><td>report_date</td><td>Date</td><td>Report Date</td></tr><tr><td>download_date</td><td>Date</td><td>Download Date</td></tr></tbody></table>

### **Seller Coupon Performance Report Coupon**

Table name: sellercentral\_couponperformance\_coupon

Note: Use this table along with sellercentral\_couponperformance\_report

<table><thead><tr><th width="268.5999755859375">Column Name</th><th width="182.60003662109378">Data type</th><th width="289.4000244140625">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 Identifier</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>coupon_performance_report_id</td><td>Integer</td><td>Foreign Key use to join with sellercentral_couponperformance_report</td></tr><tr><td>coupon_id</td><td>String</td><td>Unique identifier of the coupon.</td></tr><tr><td>merchant_id</td><td>String</td><td>Merchant customer ID associated with the coupon</td></tr><tr><td>market_place_id</td><td>String</td><td>Marketplace the coupon is running in</td></tr><tr><td>name</td><td>String</td><td>The name given to the coupon.</td></tr><tr><td>website_message</td><td>String</td><td>The message displayed with the coupon on the product page.</td></tr><tr><td>start_date_time</td><td>Timestamp</td><td>Coupon start date-time in UTC</td></tr><tr><td>end_date_time</td><td>Timestamp</td><td>Coupon end date-time in UTC</td></tr><tr><td>discount_type</td><td>String</td><td>Whether the discount is given as a fixed amount or a percentage off the list price.</td></tr><tr><td>discount_amount</td><td>Numeric</td><td>Discount amount the customer receives. Reflects a percentage when discountType is PERCENT_OFF_LIST_PRICE and a currency value when discountType is AMOUNT_OFF_LIST_PRICE</td></tr><tr><td>total_discount</td><td>Numeric</td><td>Total amount saved by customers redeeming the coupon. Currency value. Represents a gross value, including purchases that were returned or cancelled.</td></tr><tr><td>clips</td><td>Integer</td><td>Number of times the coupon has been applied on the product page by unique customers</td></tr><tr><td>redemptions</td><td>Integer</td><td>Number of times the coupon has been used for a purchase. Represents a gross value, including purchases that were returned or cancelled</td></tr><tr><td>budget</td><td>Numeric</td><td>The budget allocated to the coupon to cover discount offering and clip/redemption fees. Currency value.</td></tr><tr><td>budget_spent</td><td>Numeric</td><td>Total amount spent by the seller on the coupon, including clip fees and redemption fees. Currency value. Represents a gross value, including purchases that were returned or cancelled</td></tr><tr><td>budget_remaining</td><td>Numeric</td><td>The budget remaining for the coupon, equal to budget minus budgetSpent. Currency value. Represents a gross value, including purchases that were returned or cancelled</td></tr><tr><td>budget_percentage_used</td><td>Numeric</td><td>Percentage of the allocated budget that has been spent, equal to the budgetSpent divided by budget</td></tr><tr><td>sales</td><td>Numeric</td><td>Total revenue generated by redemptions of the coupon after the discount. Currency value. Represents a gross value, including purchases that were returned or cancelled</td></tr><tr><td>download_date</td><td>Date</td><td>Download date</td></tr><tr><td>coupon_performance_coupon_id</td><td>Integer</td><td>Unique Identifier</td></tr></tbody></table>

### **Seller Coupon Performance Report Asin**

Table name: sellercentral\_couponperformance\_asin

Note: Use this table along with sellercentral\_couponperformance\_coupon

<table><thead><tr><th width="239.20001220703125">Column Name</th><th width="140.800048828125">Data type</th><th width="347">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 Identifier</td></tr><tr><td>country_code</td><td>String</td><td>Country Code</td></tr><tr><td>coupon_performance_coupon_id</td><td>Integer</td><td>Foreign Key use to join with sellercentral_couponperformance_report</td></tr><tr><td>asin</td><td>String</td><td>The asin used in coupon</td></tr><tr><td>download_date</td><td>Date</td><td>Download Date</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/performance-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.