Performance Reports
Performance reports
Flat File Feedback Report
Table name: sellercentral_flatfilefeedback_report
Seller Central Console Report: Feedback Report (Help)
For details on data availability and refresh schedule, please click here.
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 (Help)
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.
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.
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.
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
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.
account_name
String
Intentwise Account Name
account_id
Integer
Intentwise Account Identifier
country_code
String
Country Code
currency_code
String
Currency Code
coupon_performance_report_id
Integer
Unique identifer for the report
coupon_start_date_from
Timestamp
Coupon Start Date
coupon_start_date_to
Timestamp
Coupon End Date
report_date
Date
Report Date
download_date
Date
Download Date
Seller Coupon Performance Report Coupon
Table name: sellercentral_couponperformance_coupon
Note: Use this table along with sellercentral_couponperformance_report
account_name
String
Intentwise Account Name
account_id
Integer
Intentwise Account Identifier
country_code
String
Country Code
currency_code
String
Currency Code
coupon_performance_report_id
Integer
Foreign Key use to join with sellercentral_couponperformance_report
coupon_id
String
Unique identifier of the coupon.
merchant_id
String
Merchant customer ID associated with the coupon
market_place_id
String
Marketplace the coupon is running in
name
String
The name given to the coupon.
website_message
String
The message displayed with the coupon on the product page.
start_date_time
Timestamp
Coupon start date-time in UTC
end_date_time
Timestamp
Coupon end date-time in UTC
discount_type
String
Whether the discount is given as a fixed amount or a percentage off the list price.
discount_amount
Numeric
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
total_discount
Numeric
Total amount saved by customers redeeming the coupon. Currency value. Represents a gross value, including purchases that were returned or cancelled.
clips
Integer
Number of times the coupon has been applied on the product page by unique customers
redemptions
Integer
Number of times the coupon has been used for a purchase. Represents a gross value, including purchases that were returned or cancelled
budget
Numeric
The budget allocated to the coupon to cover discount offering and clip/redemption fees. Currency value.
budget_spent
Numeric
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
budget_remaining
Numeric
The budget remaining for the coupon, equal to budget minus budgetSpent. Currency value. Represents a gross value, including purchases that were returned or cancelled
budget_percentage_used
Numeric
Percentage of the allocated budget that has been spent, equal to the budgetSpent divided by budget
sales
Numeric
Total revenue generated by redemptions of the coupon after the discount. Currency value. Represents a gross value, including purchases that were returned or cancelled
download_date
Date
Download date
coupon_performance_coupon_id
Integer
Unique Identifier
Seller Coupon Performance Report Asin
Table name: sellercentral_couponperformance_asin
Note: Use this table along with sellercentral_couponperformance_coupon
account_name
String
Intentwise Account Name
account_id
Integer
Intentwise Account Identifier
country_code
String
Country Code
coupon_performance_coupon_id
Integer
Foreign Key use to join with sellercentral_couponperformance_report
asin
String
The asin used in coupon
download_date
Date
Download Date
Last updated