Introduction: The Need for Automated Scoring

Manually evaluating dozens or hundreds of vendors on KAKOBUY is time-consuming and prone to inconsistency. An automated scoring system in a spreadsheet transforms raw data (QC pass rates, refund ratios, and shipping on-time performance) into a clear, objective vendor ranking. This guide will walk you through creating your own KAKOBUY Seller Performance Dashboard.

Step 1: Laying the Data Foundation

First, structure your data. Create columns for essential metrics pulled from your KAKOBUY analytics or manual logs.

| Vendor ID | Vendor Name | QC Pass Rate (%) | Refund Rate (%) | On-Time Shipping (%) |
|-----------|-------------|------------------|-----------------|-----------------------|
| KV-1001   | TechGadget Co.| 95.2           | 2.1             | 97.8                  |
| KV-1002   | StyleApparel | 88.5           | 5.7             | 92.1                  |
| KV-1003   | HomeEssentials| 98.9           | 1.0             | 99.5                  |
        

Step 2: Creating the Weighted Scoring Formula

Not all metrics are equally important. Assign weights that reflect your business priorities. For example:

• QC Pass Rate (Weight: 40%): Most critical for customer satisfaction.
• Refund Rate (Weight: 35%): Directly impacts profitability.
• On-Time Shipping (Weight: 25%): Key for operational reliability.

In a new column, "Performance Score", create a formula. Assuming data starts in row 2:

= (C2 * 0.40) + ((100 - D2) * 0.35) + (E2 * 0.25)
        

Note: We use `(100 - Refund Rate)` so that a lower refund rate results in a higher score, aligning with QC and Shipping logic.

Step 3: Implementing the Ranking & Tiers

Use the calculated score to assign a rank and a clear performance tier.

In the "Rank"

=RANK(F2, $F$2:$F$500, 0) // Ranks the score in column F in descending order.
        

=IF(F2 >= 90, "A: Excellent",
    IF(F2 >= 80, "B: Good",
        IF(F2 >= 70, "C: Monitor",
            "D: Review Required"
        )
    )
)