Identify your top-performing vendors by tracking key performance metrics.
For any serious USFANS user managing multiple vendors, keeping track of who performs best is crucial for efficiency and quality. A Seller Leaderboard, created within your master spreadsheet, transforms subjective feelings into data-driven decisions. By ranking vendors on critical criteria like accuracy, quality control, and communication, you can easily identify and reward your most reliable partners.
Prerequisites: Your Core Spreadsheet
Before creating the leaderboard, ensure your main USFANS tracking spreadsheet has (at minimum) these columns for each order:
- Vendor Name
- Order Accuracy
- QC Score
- Communication Score
- Order Date
- QC Score
Step-by-Step: Creating the Leaderboard
Step 1: Set Up a New Leaderboard Sheet
Within your existing spreadsheet workbook, create a new tab named "Seller Leaderboard". This will be your dedicated summary view.
Step 2: Define Your Vendor List & Metrics
In the new sheet, set up the following columns in Row 1:
| Vendor Name | Total Orders | Avg. Accuracy Score | Avg. QC Score | Avg. Communication Score | Overall Composite Score | Rank |
|---|
Step 3: Use Formulas to Pull and Calculate Data
This is the core functionality. Assuming your data sheet is named "OrderLog":
- Total Orders:=COUNTIF(OrderLog!B:B, A2)
- Average Scores:=AVERAGEIF(OrderLog!$B:$B, $A2, OrderLog!C:C)
- Composite Score:
= (C2*0.4)+(D2*0.4)+(E2*0.2)- Rank:=RANK(F2, $F$2:$F$50, 0)
- Average Scores:=AVERAGEIF(OrderLog!$B:$B, $A2, OrderLog!C:C)
Step 4: Sort and Visualize
Sort your leaderboard by the RankConditional Formatting
Best Practices for Your Leaderboard
- Standardize Your Scales:
- Weight Based on Priorities:
- Regular Updates:
- Actionable Insights:
- Weight Based on Priorities: