What We Learned Analyzing Etsy Stores with Product Mix
When we built our product categories analysis feature, we didn't expect to uncover just how disconnected most Etsy sellers were from their actual sales data. We thought we were building a simple reporting tool. What we ended up creating was something that fundamentally changed how shop owners think about their inventory.
The Challenge: "I Know What Sells"
I'll never forget the conversation that sparked this whole thing. Sarah, an Etsy seller who'd been running a successful handmade jewelry shop for three years, reached out to us frustrated. She was drowning in inventory, working 60-hour weeks, and somehow her profits were shrinking despite increasing sales.
"I know what sells," she told me on our call. "My custom crystal necklaces. I make at least 20 variations every week because they're my bread and butter."
When we pulled her actual sales data, we discovered something shocking: those crystal necklaces she was spending 70% of her time on? They accounted for less than 15% of her revenue. Her simple sterling silver stud earrings—the ones she considered "filler products" and barely promoted—were generating 42% of her total sales.
She had no idea.
What the Data Revealed
We started running this analysis across dozens, then hundreds of Etsy shops. The pattern was consistent and honestly kind of heartbreaking. Shop owners were making critical inventory decisions based on gut feeling, customer comments, or what they personally enjoyed making—not what was actually driving their business.
Here's what we found when we analyzed product mix across different shop types:
The 80/20 rule was more like 90/10: In most successful shops, about 10-15% of product variations were generating 80-90% of revenue. Yet sellers were spreading their time and resources equally across all products.
Best sellers weren't always obvious: The products getting the most favorites, comments, or social media engagement weren't necessarily the revenue drivers. We saw shops where the "Instagram-worthy" products had thousands of likes but converted at 2%, while boring basics nobody photographed were converting at 18%.
Seasonal patterns were invisible without data: One seller was convinced her holiday ornaments were her winter winner. The data showed her cozy scarf category actually peaked in September—people buying early for gifts—and she was missing that entire window by not ramping up production until November.
The Surprising Insight
The biggest revelation wasn't about what was selling. It was about what this information meant for how sellers should spend their time.
We built a dashboard feature that showed not just revenue by category, but also profitability and time investment. When sellers could see their product mix alongside these metrics, the conversations changed completely.
Take Marcus, who ran a print-on-demand shop selling art prints and custom portraits. His custom portraits took 3-4 hours each, sold for $85, and he was getting maybe 5 orders a month. His art prints took 15 minutes to fulfill, sold for $24, and he was moving 200+ monthly.
Do the math: Custom portraits were bringing in $425/month for 15-20 hours of work ($21-28/hour). Art prints were generating $4,800/month for about 50 hours ($96/hour).
But here's what surprised us: when we showed Marcus these numbers, his first reaction wasn't to drop the portraits. It was to realize he could raise the portrait price to $200, market them as premium products, and actually make them more profitable per hour than the prints. He restructured his entire business based on that product mix insight.
Taking Action: From Data to Decisions
After seeing these patterns emerge, we knew we needed to make this analysis accessible to every Etsy seller, not just the ones who could afford custom analytics consulting services. That's why we built the Product Mix Analysis tool directly into our platform.
Here's how sellers are using it to make real decisions:
Inventory Planning: Instead of guessing which variations to stock up on, they're looking at which product categories have the highest sell-through rates and revenue contribution. One seller reduced her SKU count by 40% and increased revenue by 22% just by focusing on what the data showed was working.
Marketing Focus: Knowing which categories drive revenue changes everything about how you market. Why waste ad spend promoting low-performing categories? Several sellers told us they cut their Etsy Ads budget in half and got better results just by focusing on their proven winners.
Pricing Strategy: When you can see your product mix alongside profit margins, pricing decisions become clearer. You can identify which categories have room to raise prices versus which ones need to compete on volume.
Product Development: This is the big one. Instead of creating new products based on what seems cool or trendy, sellers are analyzing their successful categories and creating variations within those proven winners. It's like product bundle analysis—understanding what customers actually want, not what we think they want.
Results and Lessons Learned
Six months after launching this feature, we checked back in with Sarah, the jewelry seller from the beginning of this story. She'd completely restructured her shop based on the product mix data.
She discontinued 30% of her product line—including some of those custom crystal necklaces she'd been so sure about. She tripled production of her simple earrings and added more variations in that category. She started tracking her product mix weekly instead of just looking at total revenue.
Her results? Revenue up 34%, working hours down to 40 per week, and—this is the part that got me—she said she actually enjoyed her business again because she wasn't constantly stressed about inventory decisions.
"I thought I knew my business," she told me. "Turns out I knew my feelings about my products. The data showed me what my customers actually wanted."
That quote stuck with me because it captures something we see across all types of commerce analytics. Our intuition about our business is valuable, but it's incomplete. The customers vote with their wallets, and if we're not listening to that data, we're flying blind.
What We're Building Next
This experience taught us that sellers don't just need reports—they need actionable insights that connect directly to business decisions. We're working on predictive features that will forecast which product categories are trending up or down based on your historical mix, and automated alerts when your product mix shifts significantly.
We're also building deeper connections between product mix and customer behavior. Because understanding what sells is just the first step. Understanding who's buying it, when they're buying it, and what else they're buying with it—that's where the real competitive advantage lives.
If you want to explore our other analytics tutorials, we've got guides on everything from cohort analysis to customer lifetime value. And if you're curious about how this all works in practice, check out our live demo to see the platform in action.
Ready to Discover Your Product Mix?
Here's my challenge to you: Before you make your next inventory decision, your next product launch, or your next marketing campaign—look at your data. You might be surprised by what you find.
We built the Product Mix Analysis tool to answer one simple question: What's actually selling in my shop? But that simple question leads to dozens of better decisions.
Connect your Etsy shop, run the analysis, and see where your revenue is really coming from. It takes about 5 minutes to set up, and I guarantee you'll learn something that changes how you think about your business.
Because data-driven decisions aren't about removing the creativity and passion from your shop. They're about channeling that creativity and passion into the products your customers actually want to buy.