Effective marketplace management hinges on identifying reliable partners. Using the OrientDig Spreadsheet, you can quickly analyze key seller metrics to spot trends, reward top performers, and address potential risks. This guide walks you through the process.
Key Metrics for Evaluation
Focus on three core data points within your spreadsheet to build a comprehensive view of seller health:
- QC (Quality Control) Results:
- Rejection Rate:
- Refund Frequency:
- Rejection Rate:
Step-by-Step Analysis Using Spreadsheet Filters
Your OrientDig spreadsheet is a powerful tool when used strategically. Follow these steps to segment and analyze seller data.
Step 1: Initial Data Preparation
Ensure your data columns (Seller Name, QC Pass %, Rejection Rate %, Refund Frequency) are correctly labeled. Convert any raw numbers into consistent percentages for accurate comparison.
Step 2: Isolate Top Performers with Multi-Filter
- Select your data range and apply Filters.
- Set a filter for QC Pass %greater than or equal to 95%.
- Nest another filter for Rejection Rate %less than 2%.
- Finally, add a filter for Refund Frequencyless than 1%.
The sellers remaining are your consistent, high-quality partners. Tag these sellers for priority allocation and partnership development.
Step 3: Identify Sellers Needing Attention
Clear your filters. Now, look for concerning trends:
- Filter for Rejection Rate %greater than 5%.
- Within this result, sort QC Pass %
This reveals sellers whose initial QC looks good but whose final products are frequently rejected—a potential red flag for shipping damage, bait-and-switch, or inaccurate sampling. These cases require investigation.
Step 4: Track Trends Over Time
Create a duplicate sheet sorted by month. Use filters to compare a specific seller's metrics across different periods. Is their Refund FrequencyQC Pass %
Turning Data into Action
Your analysis should directly inform your sourcing strategy:
| Seller Category | Typical Metrics | Recommended Action |
|---|---|---|
| Star Performers | High QC, Low Rejection/Refund | Increase order volume; negotiate long-term contracts. |
| Inconsistent | Fluctuating metrics over months | Maintain current volume but increase audits; have clear conversations. |
| At-Risk | Poor metrics in one or more categories | Place on probation; reduce order volume; issue a formal improvement plan. |
Conclusion
By systematically applying simple filters to the OrientDig Spreadsheet, you transform raw data into actionable intelligence. Regularly evaluating QC results, rejection rates, and refund frequency