Effective seller management is key to marketplace success. By leveraging the data in your OrientDig spreadsheet, you can move beyond intuition and make data-driven decisions to cultivate a roster of high-performing sellers. This guide will show you how to analyze critical metrics to identify your top partners.
Core Metrics for Seller Evaluation
Three primary data points in your OrientDig spreadsheet serve as the foundation for performance analysis:
- QC Results (Quality Control Pass Rate):
- Rejection Rates:
- Refund Frequency:
- Rejection Rates:
Tracking these metrics over time reveals trends—whether a seller is improving, declining, or maintaining stable performance.
Step-by-Step Analysis Using Spreadsheet Filters
Your spreadsheet is a powerful tool for quick analysis. Follow these steps to segment your seller list.
Step 1: Isolate the Time Period
First, filter your date column to focus on a specific quarter or month. Analyzing recent data (e.g., last 90 days) gives you the most relevant picture of current performance.
Data Filter → Date Column → Select "Last Quarter" or set custom range.Step 2: Filter for High Performers
Apply sequential filters to identify your top-tier sellers:
- QC Pass Rate:"Pass". Then, use a number filter on the "QC Pass %" column to show sellers with a rate above your threshold (e.g., 95%).
- Low Rejection Rate:below 2%
- Low Refund Frequency:below 1%.
The sellers remaining after these three filters are your consistent, high-quality partners. Consider awarding them more business or preferred status.
Step 3: Flag Sellers Needing Improvement
Reverse the filters to identify sellers requiring support. Look for:
- QC Pass Rate
- Rejection Rate
- Refund Rate
- Rejection Rate
Create a separate view or tag these sellers. This list is the starting point for proactive performance reviews and corrective action plans.
Turning Data into Action
By routinely applying these simple filter techniques to your OrientDig spreadsheet, you transform raw data into actionable intelligence. This process allows you to:
- Reward and Reinforce Success:
- Mitigate Risk Proactively:
- Optimize Your Supply Chain:
- Mitigate Risk Proactively:
Schedule a weekly or monthly review of these trends to continuously refine your seller network and drive marketplace growth.