Master the art of data sorting in Sugargoo's comprehensive spreadsheet to track seller performance, identify trends, and build a reliable list of partners based on long-term consistency.
Why Track Seller Ratings Over Time?
The Sugargoo agent platform provides detailed spreadsheet data
Step-by-Step: Sorting the Sugargoo Spreadsheet for Time-Based Analysis
Step 1: Access the Seller Spreadsheet Data
Log into your Sugargoo account. Navigate to the "Seller""Data Center"Seller Name, Item Rating, Service Rating, Transaction Date, and Overall Score.
Step 2: Structure Your Data for Tracking
Ensure your data includes a date column
Step 3: The Core Sorting & Comparison Technique
This is the key to comparing quality over time.
- Sort by Seller Name (A to Z):
- Then Sort by Date (Oldest to Newest):
This two-level sort allows you to scroll through each seller's history sequentially, making trend analysis possible.
Step 4: Analyze for Long-Term Consistency
With the data sorted by seller and date, scan each seller's history. Look for:
- Stable High Scores:
- Downward Arrows:
- Upward Recovery:
- High Volatility:
- Downward Arrows:
Step 5: Create a Summary Sheet
For your top candidates, create a simple summary table. Note the seller's name, average rating, rating trend (↑ Stable, ↑ Improving, ↓ Declining), and the date of their most recent transactions. This becomes your personalized, vetted seller list.
Pro Tips for Effective Comparison
Use Conditional Formatting
Apply color scales to the rating columns. This will visually highlight high (green) and low (red) scores, making trends immediately visible across a seller's timeline.
Focus on Service Rating Trends
While item quality can vary, a declining Service Rating
Cross-Reference with Community Feedback
Combine your spreadsheet findings with recent reviews on subreddits like FashionRepsRepsneakers
Update Regularly
Seller performance is dynamic. Export and analyze the data monthly or quarterly to keep your trusted seller list current.