Data Analyst + Sheets + Drive brief. 2 prompts · 3 agent turns · 9.18 credits · Max effort. Every tool call and decision below is real product behaviour, replayed read-only.
Analyse our Q3 sales and put together a short brief I can share with my co-founder. Where are we actually leaking money?
Here's the honest version — three leaks, and the biggest one is not the one you think.
The numbers (Q3 FY26)
| Metric | Q3 | vs target | vs Q2 |
|---|---|---|---|
| Net revenue | ₹41.8L | ✅ +18.4% YoY | +6.2% |
| Gross margin | 58.2% | ❌ 65% target | −3.1pp |
| Repeat purchase rate | 21.4% | ❌ 30% target | +0.8pp |
| Return rate | 7.1% of units | ❌ 4% target | +2.3pp |
| Blended CAC | ₹781 | ❌ ₹650 ceiling | +27% |
Leak 1 — Delivery, not discounting: ₹2.94L 🔴 Return rate jumped from 4.8% → 7.1%, and 41% of all returns are the 30ml Vitamin C Serum — the SKU we push hardest. Reason codes are unambiguous:
| Reason | Share |
|---|---|
| "Bottle leaked / cap cracked in transit" | 62% |
| "Wrong item shipped" (Amazon FBA mixing) | 18% |
| "Didn't suit my skin" | 12% |
| Other | 8% |
Return shipping + dead stock + Amazon fees = ₹2.94L, i.e. 6.7% of net revenue. The 30ml amber bottle ships with a push-in dropper and no induction seal — it survives your warehouse and dies in a courier bag.
Leak 2 — Channel fee drag: ₹1.6L You price the same at MRP everywhere, but Amazon charges 18.4% + closing fee while your own site costs 2.1%. You're effectively sub-sidising Amazon growth with D2C margin. The 30ml at ₹1,499 nets ₹1,094 on Amazon vs ₹1,383 on your site.
Leak 3 — Repeat rate stuck: ₹? 21.4% repeat is the quiet one. Someone who buys the serum once and never returns has cost you 3× more than a first-time discount would. There's no post-purchase touchpoint at all — no 3-week follow-up, no routine email, nothing.
What I'd fix first, in order:
- Induction-seal + dropper cap on the 30ml (biggest ₹, cheapest fix)
- Stop discounting on Amazon; shift budget to your own site + a 3-week post-purchase routine email
- Fix FBA labelling — 18% wrong-item returns is pure process, not customers
Want me to write this up as the brief for Aakash and drop it in your Drive?
Yes — and create a Google Doc in Drive, plus keep the breakdown sheet so we can drill in.
Both are in your Drive.
📄 Brief — Q3_Executive_Brief_IndianHerbs (2 pages)
- Headline: ₹41.8L net revenue, but 6.7% of it is coming back as returns
- The three leaks, quantified
- Fix list with owners: packaging → Ravi (Oct 4), Amazon pricing → Aakash (Sep 30), post-purchase flow → me (draft by Oct 2)
- One-year view: fixing packaging + repeat rate moves GM 58.2% → 63.4%
📊 Sheet — Q3_Leak_Breakdown (4 tabs)
| Tab | What's in it |
|---|---|
| Revenue | Monthly net revenue by SKU + channel |
| Margin | Landed cost, fees, true margin per SKU — sorted worst-first |
| Returns | Reason codes × SKU, with the packaging cluster isolated |
| Scenario | The 4 fixes modelled, with margin impact per fix |
Where we're leaking, in one line: we're not losing money on marketing — we're losing it in the courier bag and in a repeat rate that never compounds.
I'll re-run this the day the new induction-seal bottles ship so we can measure the fix against the 7.1% baseline.
End of recorded conversation. Pick another chat from the sidebar, or create an account to run this on your own products — new accounts get 50 free credits.
This workspace is a recording of a real Indian Herbs account — nothing you click here is sent anywhere.
