In the world of agent shopping, consistency is key. A seller's past performance is your best indicator of future reliability. Sugargoo’s powerful spreadsheet feature transforms raw data into actionable insights, allowing you to track trends and make informed purchasing decisions.
Why Trend Analysis Matters
Evaluating a seller based on a single transaction can be misleading. By analyzing performance over time
Key Metrics to Evaluate in the Spreadsheet
1. Seller Reliability Score
This is a composite metric. Track it across multiple orders to see stability.
How to Compare:e.g., consistently above 4.5/5) or show dips during specific periods.
2. QC (Quality Control) Results History
The heart of the spreadsheet. Go beyond "Pass" or "Fail".
How to Compare:
- Photo Consistency:
- Flaw Frequency:
- Accuracy Rate:
- Flaw Frequency:
3. Refund & Exchange Rate Trends
A low refund rate is good, but a spiking
How to Compare:
(Number of Refunds / Total Items Ordered) * 100.
Step-by-Step: Conducting Your Seller Audit
- Data Export:
- Filter & Sort:
- Create a Timeline View:Month, Avg. Reliability Score, QC Pass %, Refund Rate %.
- Populate & Visualize:
- Make a Decision:
- Filter & Sort:
Pro Tips for Effective Tracking
- Context is Key:
- Sample Size Matters:
- Use Community Data:
- Sample Size Matters: