USFANS: How to Build a Seller Performance Dashboard with the USFANS Spreadsheet
A practical guide to tracking vendor quality control using a simple, color-coded system.
Why You Need a Seller Performance Dashboard
Managing multiple vendors on platforms like Amazon can be chaotic. Without clear metrics, identifying your top performers and problematic suppliers is guesswork. A Seller Performance DashboardQC Accuracy, Speed, and Reliability.
Core Principles: The Three Pillars of Performance
1. QC Accuracy
Measures the quality of received goods. Key metrics: Defect Rate (%), Customer Return Rate (%), Positive Feedback %.
2. Speed
Tracks operational efficiency. Key metrics: On-Time Shipping Rate (%), Average Handling/Ship Time (Days), Communication Response Time (Hours).
3. Reliability
Assesses consistency and trustworthiness. Key metrics: Order Fulfillment Rate (%), Policy Compliance Score, Incident Reports (#).
Building the Dashboard: A Step-by-Step Guide
Step 1: Data Foundation
Create separate sheets in your USFANS workbook:
- Raw Data Log:
- Vendor Master List:
- Dashboard Sheet:
- Vendor Master List:
Step 2: Define & Calculate Metrics
In your Dashboard sheet, create columns for each vendor and rows for each KPI. Use formulas to pull from the Raw Data. Examples:
=IFERROR((COUNTIFS(RawData!VendorColumn, "VendorA", RawData!DefectFlag, "Yes") / COUNTIF(RawData!VendorColumn, "VendorA")), 0) // Calculates Defect Rate %
=AVERAGEIFS(RawData!ShipTime, RawData!VendorColumn, "VendorA") // Calculates Average Ship Time
Step 3: Implement Color-Coded Logic (The Heart of the Dashboard)
Use Conditional Formatting
Apply similar logic for Speed (Green = fast, Red = delayed) and Reliability (Green = high, Red = low). Add a "Vendor Health Score" (a weighted average of all metrics) and use data barssparklines
Performance Band
Color
Example Threshold (Defect Rate)
Action
Excellent / On Target
< 2%
Maintain relationship, prioritize orders.
Needs Watch / Average
2% - 5%
Review QC reports, send reminder, sample check.
Critical / Poor
> 5%
Formal warning, negotiate, seek alternative.
Step 4: Create Summary Visuals
Best Practices for USFANS Dashboard Management
- Update Regularly:
- Keep Vendors Informed:
- Iterate:
- Simplicity is Key:
- Keep Vendors Informed: