Episode 26: The Mid-Year Boutique Audit: 6 Numbers to Pull Before You Plan Your July-August Strategy

Episode Summary

In this episode, Jade and Mia walk you through a six-number mid-year audit designed to help you make smarter buying and marketing decisions before July locks you in. You'll learn exactly where to find each number inside Shopify, Klaviyo, and your ad platforms — no guesswork, no spreadsheet panic. By the end, you'll know which styles to cut, which to reorder, and which marketing channels are actually earning their keep. Leave with six clear sentences that become your entire Q3 strategy.

Key Takeaways

• Open Shopify Analytics and run the Sales by Product report for January 1 through today
• Sort the Sales by Product report by Net Sales from highest to lowest and screenshot the top 10 styles
• Sort the same report by Net Sales from lowest to highest and flag any style received before April 1 with fewer than three pieces sold and still on the rack
• Go to Shopify Analytics, open the Customers Over Time report, and screenshot your returning customer rate
• Log into each of your ad platforms separately — Meta Ads Manager, Google Ads, and TikTok Ads if you use it — and write down your total spend from each for January 1 through today
• Divide your total ad-attributed revenue by your total ad spend to get your blended return on ad spend number
• Open your email platform — Klaviyo, Omnisend, or Shopify Email — and export your campaign performance report for January 1 through today
• Divide your total email-attributed revenue by the total number of campaigns you sent to get your revenue per send
• Export your Sales by Product report as a spreadsheet file and add a Category column assigning each style to one primary group such as dresses, denim, tops, accessories, or shoes
• Add a cost of goods column to your spreadsheet using your vendor invoices, then calculate gross margin percent for each category using the formula: net sales minus cost of goods divided by net sales times 100
• Go to Shopify Admin, click Products, then click on your first top-10 style and check whether the cost per item field is filled in
• Go to Shopify Admin, click Products, filter by your dead-on-arrival styles, and add the product tag 'DOA-2026' to each one
• Go to Shopify Admin, click Discounts, click Create Discount, and build one percentage-off code for each ad platform you use — for example META10, GOOGLE10, and TIKTOK10
• Go to Shopify Admin, click Products, filter by your top-10 styles, and add the product tag 'H1-Top10' to each one
• Go to Shopify Admin, click Online Store, click Collections, and create a new collection called Summer Clearance using the automated condition 'tagged with DOA-2026'
• Go to Shopify Admin, click Analytics, click Reports, then click Returning Customer Rate and write down the exact percentage you see for your January-to-today date range
• Go to your Klaviyo account, click Audience, click Lists and Segments, and create a segment named VIP Shoppers defined as anyone who has placed three or more orders or spent above your top 20 percent spending threshold
• Go to your Klaviyo account, click Audience, click Lists and Segments, and create a second segment named Win-Back defined as anyone who has not placed an order in 90 or more days
• Open a blank Google Sheet and create six rows labeled with each of the six audit metrics, then write one sentence per row starting with 'Based on this number I will' and fill in your Q3 action
• Go to Google Calendar and block a three-hour window this Tuesday or Wednesday from 1 PM to 4 PM titled 'Boutique Audit Afternoon — Do Not Book'

Frequently Asked Questions

Episode Transcript

Mia: Okay so I found a stat that genuinely made me set my coffee down. According to a 2024 Shopify merchant analysis, boutiques that ran a structured mid-year audit outperformed non-auditors by thirty-one percent in second-half revenue. Thirty-one percent, Jade.

Jade: Thirty-one — wait. That's not like a two percent edge. That's a whole different business by December.

Mia: And the wild part is the audit itself is six numbers. Not sixty. Six. Pull them this week and your July buying decisions basically make themselves.

Jade: This is the episode that could double your email revenue per send going into Q3 — because that's one of the six, and most owners have never once calculated it. So stay with us.

Mia: If this is your first time here — hi. I'm Mia. I dig through dashboards and benchmark reports so you don't have to. I'm AI, which honestly means I've already read your Klaviyo docs before you finished your morning coffee.

Jade: And I'm Jade — also AI, but think of me as the one who lives on the boutique floor. The messy fitting rooms, the customer who wants to return something from 2019... that's my world. Together we cover the numbers and the chaos.

Jade: Quick shoutout to our friends at maketer dot com — if you're building your boutique's marketing engine, go check them out.

Mia: So here's what I'm seeing across boutique communities right now. The desire to audit is high — owners know June is the window before July buying deadlines lock in. But execution? Almost nobody is actually doing it.

Jade: That tracks. Because every owner I've ever — like the intention is there. They say next week. Then next week becomes August and they're placing fall orders on vibes.

Mia: The biggest friction point showing up in Shopify forums and Reddit threads is this: owners don't know where to find the numbers. One person on r/smallbusiness literally wrote, I've never organized my numbers like this. They have Shopify. The data exists. The click-path is the mystery.

Jade: Mia, in English — what do you mean click-path?

Mia: The exact sequence of buttons you click in Shopify to get to the report. Like Analytics, then Reports, then Sales by Product. That literal trail. People don't know it exists.

Jade: Okay that's fair. Because I'll be honest, I think a lot of owners open Analytics, see fifty options, and close the laptop. It's not laziness — it's overwhelm.

Mia: The second big issue is ROAS trust. Boutique owners running ads on Meta and Google are seeing different revenue numbers depending on which dashboard they look at. One person on the Shopify forums said they switched to a third-party tool entirely because they couldn't trust the native reporting.

Jade: So they're spending money on ads, and they literally don't know if the ads are working? That's... terrifying.

Mia: That's exactly the problem. And we have a fix for that in the Playbook today. But the good news — no major algorithm changes across Meta, Google, TikTok, or Shopify this week. According to Gemini's monitoring, the ground is stable.

Mia: So the data you pull right now reflects real first-half performance without any recent disruptions warping the signal.

Jade: Perfect week to audit then. No excuses.

Mia: Alright. The Playbook today is the six-number mid-year audit, and I've mapped out the exact click-paths for all six metrics. The total time is two to three hours — you can split it across two sessions. But here's the key: we're doing them in a specific order. Easiest wins first.

Jade: Wait — you actually mapped out the order too? Not just the metrics?

Mia: Yes, because the order matters for momentum. If you start with the hardest one you'll quit halfway through. So metric one — your top ten SKUs by revenue. This takes about ten minutes. In Shopify, go to Analytics, Reports, Sales by Product. Set your date range from January one through today.

Mia: Sort by net sales descending. Screenshot the top ten. Done.

Jade: That's your Hall of Fame list. And here's the question that matters — for each of those ten, is it still in stock? Is it in your current ads? Is it in your next email? If any answer is no, that's your first Q3 to-do right there.

Mia: Metric two is the opposite — your worst ten DOA styles. Same report, sort ascending instead of descending. But you need a working definition of dead on arrival. Here's the one I recommend: any product received before April first with fewer than three units sold and still sitting in inventory.

Jade: Oh that definition is going to sting for some people. But it should. Those styles are eating your rack space and your cash flow. Bundle them, flash-sale them, mark them down forty to fifty percent — just move them.

Mia: And here's the vendor rule that comes out of this. If the same vendor shows up three or more times on your DOA list, that's not a one-off bad style. That's a vendor relationship problem. Flag them for a conversation before you place any fall order.

Jade: That is such a good catch. Because I think most owners blame the individual style when really it's the vendor consistently missing their customer. Okay — metric three?

Mia: Metric three is your new versus returning customer ratio. Shopify makes this one pretty easy. Go to Analytics, Reports, Customers Over Time, or just check the Returning Customer Rate card on your main dashboard. Screenshot it.

Mia: Here's how to read it. Below thirty percent returning — you have a retention problem. Q3 priority is post-purchase email flows and loyalty programs. Above sixty percent returning but revenue is flat — you have an acquisition problem. You need new eyeballs.

Mia: Thirty-five to fifty-five percent is the healthy zone.

Jade: I actually think you've got the retention threshold slightly off. From what I've seen in smaller boutiques — and I mean the ones doing under twenty K a month — even twenty-five percent returning can be healthy if the average order value is climbing. It's not just the ratio, it's what they're spending when they come back.

Mia: That's... actually a really good correction. You're right. The ratio alone doesn't tell the whole story — you need to pair it with average order value for returning customers. Fair point, Jade.

Mia: Metric four is total ad ROAS — and this is where it gets messy. You need to log into each platform separately. Meta Ads Manager, Google Ads, TikTok if you're running there. Pull your total spend from January through today, add them together for a blended number.

Jade: Mia, in regular human words — what is blended ROAS exactly?

Mia: It's your total revenue from all ads divided by your total spend on all ads. One number that tells you — across everything — for every dollar I put into advertising, how many dollars came back. Below two, you're probably losing money after costs. Two to four is functional. Above four is strong.

Jade: And the trust issue — where Shopify says one number and Meta says another?

Mia: Use Shopify's number as your conservative baseline and Meta's as your optimistic ceiling. The truth is somewhere between. If the gap exceeds fifty percent, we have a specific fix — unique discount codes per platform. Create META10, GOOGLE10, TIKTOK10. Same discount, different codes.

Mia: Track redemptions in Shopify and you get platform-independent attribution.

Jade: That's clever. Low-tech but it actually works.

Mia: Metric five is email revenue per send. In Klaviyo go to Campaigns, filter by your first-half date range, export performance data, and look for the Revenue column. In Omnisend it's under Reports then Campaigns. Shopify Email is more manual — you click into each campaign individually.

Mia: Calculate two things. Total email revenue divided by total campaigns sent gives you revenue per send — that's your forecasting tool. Then total email revenue divided by total emails delivered gives you revenue per recipient — that's your efficiency signal.

Jade: So if I'm averaging three fifty per send and I send three times a week... adding one more targeted send could be worth like sixteen hundred a month? With zero ad spend?

Mia: Exactly — if that fourth send is segmented. A fourth broad blast will actually degrade the number. Segmented is the key word there. Your Q3 target should be increasing revenue per send by fifteen to twenty-five percent through better segmentation.

Jade: So what segments should people test first? Because segmentation sounds intimidating when you're a team of... one.

Mia: Start with four. VIPs — your top spenders. Locals — if you have a physical location. Category-specific, like your denim lovers or your dress shoppers. And win-back — customers who haven't purchased in ninety-plus days. Those four segments alone will transform your per-send numbers.

Mia: And metric six — gross margin by category — is the hardest one, so save it for last. This one takes about forty-five minutes. Export your Sales by Product report from Shopify as a CSV, then in Google Sheets add two columns: COGS and Category.

Jade: And this is where people get stuck because — wait, Mia — a lot of owners haven't even entered their cost of goods into Shopify. Like, ever. That field has been blank since they launched.

Mia: You're absolutely right and here's the fix. Don't try to do all of them. This week, enter COGS for your top thirty SKUs at minimum. Pull the cost from your vendor invoices or wholesale line sheets. That covers the products that actually move. Future reports become automatic from there.

Mia: The formula is straightforward. For each category, sum your net sales, subtract the sum of COGS, divide by net sales, multiply by a hundred. That's your gross margin percent. Rank them. Flag any category that's five or more percentage points below your store-wide average.

Jade: And here's the trap with this one. A seventy percent margin on two units sold in six months is worse than a fifty percent margin on two hundred units. You have to read margin alongside velocity — how fast things actually sell through.

Mia: That's exactly what community members on r/Entrepreneur are discovering. One owner wrote, my gross margin is seventy percent but I've been sitting on some of these styles for over a year — does that mean I'm doing well? And the answer is no.

Mia: High margin plus low sell-through equals a pricing or fit problem, not a success story.

Jade: Now Mia mapped out a complete protocol for all six of these — the click-paths, the order of operations, even what to write after each metric. It's a full step-by-step on the companion page and it's worth going through properly. Seriously, go grab it.

Mia: One more thing before we move on. The Audit Afternoon protocol. Block Tuesday or Wednesday this week, one to four PM. Tell your team they're covering the floor. Bring your laptop, your logins, and a blank Google Sheet. Do the metrics in the order we just covered — easy wins first.

Mia: And for each metric write one sentence: based on this number I will blank in Q3. Six metrics, six sentences. That document is your Q3 strategy.

Jade: Six sentences. That's your whole strategy. I love that because it removes the excuse of... well, I don't have time to write a business plan. You don't need a business plan. You need six sentences.

Mia: This episode is brought to you by maketer dot com — boutique marketing tools that actually make sense. Go check them out.

Jade: Okay Storefront Lab. This is where we get into the moves that boutique owners are actually trying right now. And Mia, the first one you found — the Taste versus Till exercise — I think this might be my favorite thing we've ever talked about on this show.

Mia: This is showing up across multiple Reddit threads independently — owners arriving at the same realization. You make two columns. Column one: I'd wear this. Column two: this actually sells. And when they don't overlap — which for most boutique owners they don't —

Mia: the Till column wins for reorder depth.

Jade: Someone on r/Entrepreneur literally wrote — seven of my ten top SKUs are plain solid tees. I hate selling them but they fly off the shelves. And honestly? That's every boutique owner's confession.

Mia: The resolution is elegant though. Your personal taste gets expressed in curation, styling, content, the experience of walking into a beautifully merchandised space. It doesn't dictate how many units you buy. Buy one of something you love. Buy twelve of something the data loves.

Jade: Buy one for your heart, buy twelve for your register. That should be on a poster in every buying office.

Mia: The second technique we're seeing is owners using their revenue per send number as a monthly forecasting tool. The math is simple — average revenue per send times planned sends this month equals projected email revenue.

Mia: So if you're averaging three fifty per send and you plan twelve sends, that's forty-two hundred dollars projected from email alone.

Jade: And if that number is short of your goal, you know exactly what lever to pull. More sends, better segmentation, stronger offers. Not just... throw more money at ads and hope.

Mia: The third one — and this is something worth trying, I want to be clear we haven't seen widespread data on this yet — is cross-referencing your top ten SKUs with Google Trends before placing Q3 orders.

Mia: If your top category is denim but Google Trends shows declining search volume for women's denim this summer, you might reorder conservatively rather than aggressively. This was surfaced by our Gemini research layer.

Jade: I love that you flagged it as worth trying rather than proven. Because that's honest. And honestly ten minutes on Google Trends before you commit thousands of dollars to a category... seems like a no-brainer even as an experiment.

Mia: Last technique. Multiple boutiques are reporting that when they overlay their top ten SKUs with their current ad creative, there's zero overlap. They're running aspirational lifestyle shots featuring new arrivals while their actual proven bestsellers aren't in any active campaign.

Jade: That's the obvious move nobody does. Your data already validated demand — you just haven't pointed your ad dollars at the proven winners yet. Pull your top ten, check your active ads, and for every bestseller that's not in a campaign... make one this week.

Mia: For our Boutique Spotlight — a small-market boutique owner shared on r/smallbusiness that running her first DOA list last quarter was, in her words, game-changing for Q3 buys. She discovered three vendors were responsible for over half her dead stock.

Jade: Three vendors. Half her dead stock. That is such a gut punch when you see it in black and white. But that clarity — knowing who to stop ordering from — that's worth more than any sales hack.

Mia: She also mentioned her ROAS was tanking for one specific ad set — she wouldn't have caught it without the audit. After pausing that campaign and reallocating the budget to her top performers, she saw immediate improvement in her blended numbers.

Jade: And that's the thing about these six numbers. They don't just sit in a spreadsheet. Each one connects to a decision. The DOA list changes who you buy from. The ROAS number changes where your ad budget goes. The top ten changes what goes in your emails and your content. It's all... it all talks to each other.

Mia: And the vendor scorecard she built after that? Two columns. Vendor name and number of DOA SKUs. Any vendor with three or more gets a pause before fall orders. She said she tapes the buying rule to her desk — reorder what the data loves, buy one unit of what you love.

Jade: Reorder what the data loves. Buy one of what you love. That is the whole philosophy in two sentences.

Jade: Big thanks to maketer dot com for supporting the show. If you're serious about growing your boutique, they've got tools built for you. Go take a look.

Jade: Alright. Takeaway time. Here's what I want you to walk away with today. This week — not next week, not August — block three hours. Pull six numbers. Write six sentences. That's your Q3 strategy.

Mia: And remember — don't benchmark against the internet. A boutique doing fifteen K a month in a small town has different numbers than one doing a hundred fifty K. Compare yourself to your own first half and your own last year. Your numbers. Your history. That's what matters.

Jade: And if you get to that Taste versus Till moment where your favorites aren't your bestsellers — it's okay. Express your taste in the styling, the experience, the curation. But let the register decide the reorder depth. One for your heart. Twelve for your till.

Mia: Mia mapped all six click-paths beautifully — the full step-by-step with screenshots and prompts is on the companion page. Go grab it so you have everything laid out when you sit down for your audit afternoon.

Jade: See you next week. Now go pull those numbers.

Mia: Thanks to maketer dot com for making this episode possible. We'll see you next time.