Marin Skincare went from blind spot to unlocking a complete wholesale year-end report in a few minutes without a single CSV export

THE CHALLENGE

Sam Griswold at Marin Skincare needed to conduct a year-end review of the company's wholesale business, a separate Shopify store serving B2B customers including retailers, spas, and medical practices. The problem was not a lack of data. It was a lack of organization.

Despite having tens of thousands of active wholesale customers across a large and diverse B2B base, none of those customers had been segmented by industry. Sam had defined nine categories including Gift Store, Esthetician, Dermatologist, Spa/Med Spa, Natural/Foods, Medical Practice, Hotel, Gym, and Other, but not one had been applied to customer records. Without that taxonomy in place, the team had no way to identify which industries drove the most revenue, carried the highest average order value, or represented the best growth opportunities heading into 2026.

Year-end strategic planning was effectively blocked. The alternative was hours of CSV exports, manual spreadsheet pivots, and guesswork.

THE SOLUTION

Sam brought the question to Flaunt's AI analyst. In a few minutes, he had a complete wholesale business overview ready for leadership.

Flaunt parsed hundreds of thousands of orders and customer records to deliver a full 2025 performance snapshot with directional clarity on monthly trends, seasonal patterns, and average order value shifts across the year. Q4 emerged as the clear strength period, with a notable peak in November and an AOV increase in the back half of the year pointing to meaningful shifts in purchasing behavior.

Crucially, Flaunt also diagnosed the data gap itself. It surfaced that 99.98% of customers had no industry tags at all, confirming why segmented analysis had never been possible and giving Sam a clear starting point for fixing it. From there, Flaunt generated an export of the top 100 customers by 2025 revenue, complete with email, revenue, order count, AOV, and existing tags, along with a recommended roadmap for prioritizing the tagging project.

THE RESULTS

• In a single conversation, Sam walked away with a complete year-in-review report ready for leadership, a prioritized list of high-value accounts to begin industry tagging, and a clear diagnostic on why segmented reporting had not been possible before.
• The analysis also set the foundation for what comes next. Once industry tags are applied, Flaunt can immediately re-run the full analysis segmented by customer type, showing revenue, AOV, order frequency, product preferences, and geographic distribution by industry. The year-end review became both a deliverable and a starting point.
• What would have taken an estimated two to four hours of manual work was done in two minutes.