What to Track in Your Sugargoo Spreadsheet
Essential columns and metrics every reseller should monitor for maximum efficiency and profit clarity.
A sugargoo spreadsheet is only as useful as the data you put into it. Track too little, and you miss insights that could boost your profits. Track too much, and you spend more time on data entry than on selling. This guide shows you exactly what to track and why each metric matters.
The Core Metrics (Must-Have)
These are the non-negotiable columns. Without them, you cannot calculate profit or track order status:
| Metric | Why It Matters | Impact |
|---|---|---|
| Order Date | Tracks how long orders take to arrive | High |
| Item Name | Identifies what you bought | Critical |
| Category | Shows which product types perform best | High |
| Purchase Price | Base cost for profit calculation | Critical |
| Shipping Cost | Often underestimated but significant | High |
| Total Cost | True cost including all fees | Critical |
| Sale Price | Revenue for profit calculation | Critical |
| Profit | Your actual earnings per item | Critical |
| Status | Where the order is in your workflow | High |
The Advanced Metrics (Recommended)
Once you have the basics mastered, add these metrics to gain deeper insights:
- Supplier Name: Identifies which vendors are reliable and which cause delays.
- Tracking Number: Lets you check shipping status without logging into multiple sites.
- Days to Arrival: Calculate how long each supplier takes. This helps set accurate delivery expectations for buyers.
- Profit Margin (%): Shows profit as a percentage rather than just a dollar amount. A $50 profit on a $100 item is much better than a $50 profit on a $500 item.
- Platform Fees: Track the fees you pay to selling platforms. These add up and reduce your true profit.
- Return Rate: Track which items get returned most often. This reveals quality issues or misleading descriptions.
- Customer Source: Know where your buyers come from. This helps you focus marketing efforts on the most effective channels.
The Nice-to-Have Metrics (Optional)
These metrics add value but are not essential for everyone. Add them only when you have time and need their specific insights:
- Item Weight: Useful for calculating accurate shipping costs on future orders.
- Product Dimensions: Helps estimate packaging size and shipping box requirements.
- Listing Date: Shows how long items take to sell after arrival.
- Time to Sale: The number of days between arrival and sale. Fast-selling items deserve priority in future purchases.
- SEO Keywords: Track which keywords you used in listings. This helps you optimize future product descriptions.
- Seasonality: Note the season when you bought and sold each item. This reveals seasonal trends in your product categories.
What NOT to Track
Over-tracking is a real problem. Avoid these common traps that create unnecessary work:
- Excessive product details: You do not need to track every color variation, size option, or material specification unless it directly affects your costs or pricing.
- Buyer personal information: Never store sensitive customer data like credit card numbers or addresses in a spreadsheet. Use your selling platform for that.
- Duplicate calculations: If you have a Total Cost column, you do not need separate columns for each fee breakdown unless you specifically need to analyze fee composition.
- Subjective ratings: Scoring items on a 1-10 scale for "quality" or "popularity" creates inconsistency. Use objective metrics instead.
Building Your Custom Tracking System
Start with the core metrics. Use your spreadsheet for at least one month before adding advanced metrics. This prevents overwhelm and ensures you understand the value of each column before adding more. Remember: the goal is actionable insights, not data collection for its own sake.
Frequently Asked Questions
The essential metrics are: purchase price, shipping cost, total cost, sale price, profit, profit margin, order status, and supplier name. These give you a complete picture of your business.
