Weekly performance
Week: Aug 23–29 · 12-week viewWeek in progress — Aug 30 – Sep 5 (day 3 of 7)
Revenue IN PROGRESS
₹28,772
3 of 7 days elapsed
Orders
20
so far this week
Customers
19
so far this week
Monthly target %
0.1%
₹785 of ₹7.0L (Sep day 1)
Sub renewal
₹5,386
so far this week
New customers
2
so far this week
Last full week — Aug 23 – 29
Revenue
₹1.29L
↑ 24.6% vs prior week
Orders
71
↑ 16.4% vs prior week
Customers
57
≈ flat vs prior week
August (final)
₹4.06L
↓ 16.8% vs Jul's ₹4.89L
Sub renewal
₹53.2K
↑ from ₹6.8K prior week
Deliveries
107
97 consignees
12-week parameter matrix
Highest in row
Lowest in row
Better than last week
Current week (in progress)
↑ / ↓ WoW % rows
| Parameter | Target | Aug 30+ In progress |
Aug 23–29 | Aug 16–22 | Aug 09–15 | Aug 02–08 | Jul 26–Aug 1 | Jul 19–25 | Jul 12–18 | Jul 5–11 | Jun 28–Jul 4 | Jun 21–27 | Jun 14–20 |
|---|
Revenue trend — 12 weeks
Performance insights
Strong week
Jun 21–27 is still the strongest week in the current 12-week window at ₹1.48L, driven by a subscription renewal spike (₹42K). It has held that top spot across the last several refreshes despite the window rolling forward — no week since has matched it. Aug 23–29 (₹1.29L) is the closest recent challenger, also subscription-driven (₹53.2K renewal revenue).
Monthly target gap
August closed at ₹4.06L final — roughly 58% of the ₹7L convention target used on this dashboard (August's own specific target wasn't recoverable from source this pull, see Daily tracker note). That's down 16.8% from July's ₹4.89L, itself already short of target. This is now three consecutive months tracking meaningfully below ₹7L — worth treating as a structural gap rather than a one-month dip when planning September.
Channel shift
Website has out-ordered WhatsApp for 4 of the last 5 completed weeks — Aug 23–29 was 34 website vs 15 WhatsApp (69% website share), continuing Aug 16–22's 31 vs 19 and Aug 9–15's 22 vs 16. This is no longer a one-week blip; it's a sustained pattern across a month. The one exception was Jul 26–Aug 1 (24 WhatsApp vs 16 website), which lines up with a broadcast send that week — reinforcing that broadcast activity, not organic demand, is what still drives WhatsApp volume.
Customers
Aug 30–Sep 5 in progress · Aug 23–29 last full week · Lapse view: last 3 weeksWeek in progress — Aug 30 – Sep 5 (day 3 of 7)
Active this week IN PROGRESS
19
3 of 7 days elapsed
Revenue from customers
₹28,772
so far this week
Subscription revenue
₹5,386
so far this week
New customers
2
so far this week
Rebuilt this pass from the sheet's own precomputed per-customer weekly matrix (SalesPerformanceThisWeek — avg_per_week, weeks_active, and lapse columns are calculated in-sheet, not derived here). Lapsed-1-week count is measured against a week that's only 3 days in, so it will naturally shrink as Aug 30–Sep 5 fills out.
Last full week — Aug 23–29
Active this week
57
≈ flat vs Aug 16–22
Revenue from customers
₹1.29L
Avg ₹2,266 / customer
Subscription revenue
₹53,248
↑ 682.5% vs ₹6,806 last week
New customers
6
↑ from 5 prior week
Lapsed — 1 week
49
bought Aug 23–29, not since (week 3 days in)
Lapsed — 2 & 3 wks
56
34 + 22 need outreach
AOV — new customers
₹869
↑ vs ₹565 last wk
11-week avg ₹1,400
Target ₹1,000 · Below target this week
AOV — repeat customers
₹2,431
↑ vs ₹1,939 last wk
11-week avg ₹1,940
Target ₹1,500 · Above target ✓
Multiple purchases this week
12
customers bought 2× or more
Damanjeet Singh (12 orders, ₹17,555 — flag as outlier, likely bulk/wholesale) · Tanya Singh (2, ₹11,060) · NARANG MARCHE (2, ₹5,126)
Aug 23–29 · real per-customer count from source sheet
Subscription this week
New sub revenue
₹1,420
Aug 23–29
Renewal revenue
₹53,248
↑ 682.5% vs ₹6,806 last wk
Subscription 12-week range
Peak week
₹53.2K
Aug 23–29 — new peak
Last full wk
₹53.2K
highest of 11 weeks
Low week
₹1.4K
Jun 14–20
Most loyal customers active this week
| Customer | Orders this wk | Weeks active (of 12) | Avg orders / week |
|---|---|---|---|
| Neena Rai | 1 | 12 / 12 | 1.00 |
| Indira Mansingh | 2 | 11 / 12 | 1.08 |
| Manoj Kumar | 1 | 11 / 12 | 1.00 |
| Dr. Sumita Kanwar | 1 | 11 / 12 | 0.92 |
| Meera Ahuja | 1 | 10 / 12 | 1.17 |
Lapsed customers — action list
49
Lapsed 1 week · bought Aug 23–29, not since
34
Lapsed 2 weeks · bought Aug 16–22, gone since
22
Lapsed 3 weeks · bought Aug 09–15, gone since
Customer intelligence — who to focus on this week
✅ Maribel Alfonso is back — bought in both of the last two completed weeks, after 4 straight refreshes flagged
This is the clearest win in this refresh: after appearing on the silent-regulars list for four consecutive pulls since mid-July, she bought again in both Aug 2–8 and Aug 9–15. Whatever the last outreach was (call, escalation, or otherwise), it worked — she's now active, not lapsed, and off every list on this dashboard. Worth a quick note to whoever made that call, since it's a useful data point on what actually recovers a chronic lapse.
✅ Regulars-gone-silent list down to 1 — from 7 last pull, 12 before that
Recomputed fresh from the sheet's own weeks_active/lapse columns: only Dr Kamini Prakash (8/12 weeks active, ~₹830/wk avg, last bought Aug 9–15) still fits the pattern. Barkha Deva, Verena Sas, Nicole Schaulin, Parveen Khanna, Arvinder Arora, Guri Meenu and Sahiba Sawhney have all bought again since the last pull. This is a real, continuing improvement across four straight refreshes (12 → 7 → 1).
📉 Lapsed count at 105 (49+34+22) — measurement point changed, not a reversal
Total lapsed across L1+L2+L3 is 105, up from 82 last pull — but that's mostly because the reference week shifted: L1 (49) is measured against Aug 30–Sep 5, which is only 3 days old, so most regular customers simply haven't had a chance to buy yet this week. L2 (34, bought Aug 16–22, gone since) and L3 (22, bought Aug 9–15, gone since) are the more stable, comparable figures — both similar in scale to the prior pull's 26 and 20. Don't read the raw total as a reversal of the recent improving trend.
🎯 Target list for this week — the one remaining silent regular
With the silent-regulars list down to one name, there's a single clear priority: Dr Kamini Prakash, 8/12 weeks active, ~₹830/wk average, last bought Aug 9–15 (3 weeks ago now). A personal call or WhatsApp referencing her usual order has the highest chance of recovery. Beyond her, work the L2 list (34 names, bought Aug 16–22) — that's the freshest genuinely-lapsed segment now that L1 is still forming.
📞 Call list — regulars who have gone quiet (1, down from 7)
Recomputed fresh this pass on the "5+ of last 8 weeks active, absent the last 2 full weeks" pattern. One name warrants a personal call this week.
| Customer | Weeks active / 12 | Avg spend / week | Last seen | Action |
|---|---|---|---|---|
| Dr Kamini Prakash | 8 / 12 | ₹830 | Aug 9–15 | 📞 Call today |
📞 Call today = 7+ of last 8 weeks active, highest urgency
📊 AOV signal — repeat customer spend jumped, new customer spend still recovering
New customer AOV in the last full week (Aug 23–29) was ₹869 against an 11-week average of ₹1,400 and a target of ₹1,000 — below target, up from ₹565 the week before. Repeat customer AOV was ₹2,431, well above both the ₹1,940 average and the ₹1,500 target, and up sharply from ₹1,939. Worth noting: Damanjeet Singh's 12-order week (₹17,555) is inflating the repeat-customer figure — this looks like a bulk or wholesale account, not organic growth, and is worth confirming with Anubhav.
Items sold
Last full week: Aug 23–29 · 11-week category matrix (current partial week excluded)Top 3 categories this week
#1 Subscription
₹67,905
↑ 947.6%
vs ₹6,482 last week
Volume this wk
13 units
Volume last wk
2 units
#2 Vegetables
₹22,501
↓ 24.8%
vs ₹29,935 last week
Volume this wk
321 units
Volume last wk
432 units
#3 Curated Boxes
₹12,786
↑ 72.8%
vs ₹7,399 last week
Volume this wk
20 units
Volume last wk
14 units
11-week category matrix — value & volume
Highest in row
Lowest in row
Better than last week
| Category | Metric | 11-wk avg | Aug 9–15 | Aug 2–8 | Jul 26–Aug 1 | Jul 19–25 | Jul 12–18 | Jul 5–11 | Jun 28–Jul 4 | Jun 21–27 | Jun 14–20 | Jun 7–13 | May 31–Jun 6 |
|---|
Long shelf-life tracker — Flours · Dressings & Spreads · Oils · Sweeteners
These categories have longer purchase cycles. Growth here signals brand depth beyond weekly fresh produce.
Shelf-life category — 11-week revenue
Flours — weekly trend (strongest shelf-life category)
Category insights & messaging strategy
⚠️ Oils — a ₹21,250 single-week spike, 39× the normal run rate
Oils normally runs ₹0–850/week (11-week average excluding the spike is ~₹350). Aug 16–22 alone brought in ₹21,250 — 86% of the entire 11-week category total came from that one week. It's already reverted to ₹543 in Aug 23–29. This has the hallmarks of a single large order (possibly bulk/wholesale, similar to the Damanjeet Singh pattern flagged on the Customers section) rather than a demand shift. Action: Check the Aug 16–22 order log for Oils specifically — if it's one customer, this shouldn't be read as category growth or built into any campaign plan.
🌾 Flours — jumped back up to ₹6,899, breaking the "reverted to baseline" read
The last refresh called the Jul 26–Aug 1 spike (₹16,119) a one-week anomaly that had "fully reverted." That read now needs revising: Flours moved 552 → 2,550 → 7,109 → 6,899 over the last four completed weeks — a real upward trend, not noise around a low baseline. 11-week total is now ₹62,105, still the largest shelf-life category by a wide margin. Action: Worth testing a Flours-focused recipe campaign now rather than waiting — the demand signal looks more durable than the earlier single-spike read suggested.
📦 Curated Boxes — up 72.8% to ₹12,786, back in its normal range
Curated Boxes rose sharply to ₹12,786 in Aug 23–29 from ₹7,399 the week before — this is a return to the ₹7,196–₹13,804 range seen through most of July, not a new high. 11-week total ₹88,392. The category remains volatile week to week with no clear directional trend across the window; treat individual week moves with caution.
🌶️ Exotic — down 13.4% to ₹9,689, still well above the summer low
Exotic eased to ₹9,689 from ₹11,187 the week before, but both weeks are comfortably above the low-point stretch from mid-July (₹4,126–7,351/week). 11-week total ₹79,427. This looks like a genuine, sustained recovery holding in the ₹8K–11K range for three straight weeks now — a stronger signal than the earlier stop-start pattern. Action: Safe to resume Exotic-led messaging; the two-consecutive-week stability bar this dashboard set previously has now been met.
🍎 Fruits — down 7.5% to ₹8,448, still range-bound well off its Jun peak
Fruits eased slightly to ₹8,448 from ₹9,137, continuing a seven-week plateau roughly between ₹6,000–9,300/week since the ₹18,006 peak in Jun 21–27. No clear recovery trend yet, but no further deterioration either — this remains a floor, not a turnaround.
🥣 Soup Kit — back from zero to ₹1,420, breaking the "seasonal exit" read
Soup Kit had gone to ₹0 in Aug 16–22 and was read as confirming a clean seasonal exit. It came back to ₹1,420 in Aug 23–29 — not a huge number, but a real reversal of that call. Worth considering whether this is early interest ahead of the planned September re-launch (cooler weather approaching) rather than waiting for the Sep 1 broadcast to trigger demand. Action: Check whether this week's Soup Kit buyers are prior-season customers — if so, consider moving the re-launch broadcast earlier.
📈 Salts & Vinegars — up to ₹1,432, consistent with the lumpy pattern
Salts & Vinegars rose to ₹1,432 from ₹475 — within its established pattern of infrequent, chunky orders rather than steady demand (11-week total ₹14,976, ranging from ₹0 to ₹6,890 week to week). No action needed; continue treating as low-priority and unpredictable.
Daily tracker
September 2026 · MTD through day 1 · target ₹7.00LMonthly target
₹7.00L
Actual (day 1)
₹785
0.1% achieved
Variance
−₹22,548
vs day-1 pace target
Daily avg (to date)
₹785
target ₹23,333 / day
Days above target
0
of 1 day so far
August (final)
₹4.06L
closed at 58.0% of its target*
September is 1 day in — far too early for any trend read; the day-1 figure and daily target come straight from the sheet's own TargetPerformance tab (verified, not estimated). August closed at ₹4,06,288 final, down 16.8% from July's ₹4,88,566 — that's a real, confirmed decline across a full month, not noise. *August's own specific target wasn't recoverable from this pull (no historical target log found); the 58.0% figure uses the ₹7.00L convention carried from June/September for comparability — treat it as directional, not exact. Also worth flagging again: the source workbook's "Target" cell for total monthly revenue still reads a clearly-wrong ₹28,076 as of this pull, the third consecutive refresh showing this — that cell looks genuinely broken and is worth Anubhav checking directly rather than something this dashboard should keep working around silently.
Day-of-week average ⚠️ unverified — see note
This chart's data (avgs=[15049,6536,22878,...], target ₹23,333/day) has not been refreshed this pass or verified against any specific month — it does not match the current ₹20,968/day target used elsewhere on this dashboard. The source workbook doesn't provide day-of-week granularity in what's been pulled so far. Treat this chart as stale until it can be rebuilt from real data.
Daily sales vs ₹20,968 target (August)
Day-by-day detail
| Day | Date | Sales | vs target | Cumulative |
|---|
Daily insights
⚠️ Day-of-week patterns not refreshable this pass — no daily-granularity source available
The Fridays/Weekend/Mid-month cards below are carried over from an earlier pull (originally based on June daily data) and have not been rebuilt with current data — the only day-level figure available in this refresh is September's single confirmed day (Sep 1, Tuesday: ₹785). Building genuine day-of-week or mid-month patterns needs a source with a full month of daily splits, which this pull didn't have access to. Treat the three cards below as historical reference only, not current guidance, until a proper daily-level pull is done.
Fridays lead (from Jun data, unverified since)
Friday average of ₹27,633 is the only day consistently above the ₹23,333 target. Days 26 (₹41.1K) and 5 (₹28.3K) were both Fridays. Scheduling key promotions or subscription renewals to land on Fridays maximises daily revenue.
Weekend drag (from Jun data, unverified since)
Saturday avg ₹6,304 and Sunday avg ₹5,990 — both well below a third of the daily target. These two days are structurally low. If subscription deliveries could be scheduled to trigger payment on Saturdays, it would smooth out the weekend dip.
Mid-month trough (from Jun data, unverified since)
Days 6–14 (Jun 6–14) averaged only ₹8,040 — a mid-month slump consistent with customers running out of credit or subscription gaps. A mid-month broadcast targeting lapsed customers in week 2 of every month could break this pattern.
Recommendations
Week of Aug 23–29 (last full week) · Rebuilt Sep 1 from current data across all sectionsHigh priority
4
actions this week
Medium priority
4
actions this week
Low priority
3
plan ahead
Revenue at stake
₹1.5L+
recoverable this month, conservative estimate
Customers to contact
112
1 regular + 49 L1 + 34 L2 + 22 L3 + 6 new — real counts, Sep 1
September target
₹7.0L
confirmed from source's own TargetPerformance sheet
High priority
Act within 48 hours — revenue and retention at direct risk
H1 · TodayCustomers
Call Dr Kamini Prakash — the last remaining silent regular
She's the only name left on a list that had 12 people four refreshes ago — 8/12 weeks active historically, ~₹830/wk average, last bought Aug 9–15. Everyone else on that list (Maribel Alfonso, Barkha Deva, Verena Sas, Nicole Schaulin, Parveen Khanna, Arvinder Arora, Guri Meenu, Sahiba Sawhney) has bought again. A personal call referencing her usual order has the highest recovery odds of anything on this dashboard right now.
Target
✦ One call, one order
✦ Revenue: ~₹830/wk if recovered
✦ Deadline: this week
✦ Revenue: ~₹830/wk if recovered
✦ Deadline: this week
H2 · This weekCustomers
WhatsApp the strongest names on the 2-week lapsed list (34 total)
Prioritise by history within the L2 list: Christopher Pacheco (6/12 weeks active), Inder Setia, Guri Meenu, Hiroko, Saumya Verma, Tanuja Sharma, Jai Prakash Chaudhary, Arvinder Arora (5/12 each). All bought in Aug 16–22, none since. A personal message referencing what they usually buy — not a broadcast — has the best recovery odds. Use the Download button on the 2-week lapsed list in Customers to share the full 34 with your team.
Target
✦ Recover 8 of 34
✦ Revenue: ~₹12K
✦ Deadline: this week
✦ Revenue: ~₹12K
✦ Deadline: this week
H3 · Today–TomorrowItems
Investigate the ₹21,250 Oils spike — likely one bulk order, not category growth
Oils normally does ₹0–850/week; Aug 16–22 alone brought in ₹21,250 (86% of the entire 11-week category total) and has already reverted to ₹543. Pull the Aug 16–22 Oils order log — if it's one customer, flag it as bulk/wholesale (same pattern as Damanjeet Singh's 12–13 order weeks) so it doesn't get read as demand growth in future refreshes.
Target
✦ Identify order source
✦ Flag if wholesale
✦ Deadline: this week
✦ Flag if wholesale
✦ Deadline: this week
H4 · OngoingBroadcast
Locate the real broadcast tracking source
This section has been unrefreshable for multiple months now — the "Broadcast Tracking 2026" source referenced in the dashboard isn't in the current weekly workbook, only a stale Oct 2025 send calendar with no performance metrics. WhatsApp has been losing share to Website for a month straight (see Performance insights) with broadcast activity as the suspected driver — but that's unverifiable without real data. This needs an answer from Anubhav on where broadcast performance is actually tracked now, not another automated retry.
Target
✦ Confirm data source
✦ Re-enable this section
✦ Ask Anubhav directly
✦ Re-enable this section
✦ Ask Anubhav directly
Medium priority
Complete this week — growth and retention levers
M1 · This weekItems
Run a Flours recipe campaign — the trend looks real now, not a one-off
Flours moved 552 → 2,550 → 7,109 → 6,899 over the last four completed weeks — a genuine climb, not the single-spike anomaly it was read as last pull. 11-week total ₹62,105, the largest shelf-life category by far. A recipe-led broadcast (one dish, one flour, one ROF product) paired with Ghee or Spices for a higher-AOV bundle should extend this run.
Target
✦ ≥10 Flour orders
✦ Revenue: ₹6,000+
✦ Deadline: this week
✦ Revenue: ₹6,000+
✦ Deadline: this week
M2 · This weekItems
Check if Soup Kit's early return should move the September re-launch up
Soup Kit went from ₹0 (Aug 16–22) back to ₹1,420 (Aug 23–29) — breaking the clean seasonal-exit read from last pull. Check whether this week's buyers are prior-season customers; if so, the planned Sep 1 re-launch broadcast to the Nov 2025–Mar 2026 buyer list could move earlier to capture this early demand instead of waiting.
Target
✦ Confirm buyer identity
✦ Decide on launch timing
✦ Deadline: this week
✦ Decide on launch timing
✦ Deadline: this week
M3 · This weekCustomers
Follow up with the 6 new customers from Aug 23–29
Average first-order AOV was ₹869 — below the ₹1,000 target and the ₹1,400 11-week average. A "how was your first order?" message within the first 10–14 days converts new buyers to repeat at a meaningfully higher rate than no follow-up. Small batch this week, so this should be quick to execute.
Target
✦ 2 of 6 place a 2nd order
✦ Revenue: ~₹1,700
✦ Deadline: within 10 days
✦ Revenue: ~₹1,700
✦ Deadline: within 10 days
M4 · By FriCustomers
Start working the 3-week lapsed list (22 names) before it grows
These 22 bought in Aug 9–15 and haven't since — the oldest, coldest of the three lapsed buckets. Recovery odds drop the longer this goes untouched. A lighter-touch broadcast-style nudge (rather than 1:1 calls, given the volume) referencing what they usually buy is appropriate here.
Target
✦ Recover 4 of 22
✦ Revenue: ~₹4K
✦ Deadline: Fri
✦ Revenue: ~₹4K
✦ Deadline: Fri
Low priority
Plan this week, execute over the next 2–4 weeks
L1 · OngoingSubscriptions
Spread subscription renewal dates — volatility is still extreme
Weekly subscription renewal revenue has ranged from ₹1.4K (Jun 14–20) to ₹53.2K (Aug 23–29) across the 12-week window — a 38× swing driven entirely by expiry-date clustering. Staggering renewal anchors across the month would smooth this into a predictable weekly floor instead of boom-and-bust weeks.
Target
✦ Weekly sub floor: ₹15K+
✦ Volatility reduced ≥50%
✦ Plan by month-end
✦ Volatility reduced ≥50%
✦ Plan by month-end
L2 · This weekItems
Resume Exotic messaging — three-week stability bar now met
Exotic has held ₹8K–11K/week for three straight weeks after its summer low. This is the stability threshold this dashboard previously said to wait for — safe to feature Exotic again in upcoming campaigns.
Target
✦ Resume Exotic features
✦ Monitor next 2 weeks
✦ No hard deadline
✦ Monitor next 2 weeks
✦ No hard deadline
L3 · OngoingCustomers
Confirm whether Damanjeet Singh is a wholesale account
This customer placed 12 orders (₹17,555) in Aug 23–29 alone, and shows a similar pattern on the monthly dashboard (13 orders in August). If this is a bulk/wholesale relationship rather than a retail customer, it should probably be excluded from AOV and multi-purchase metrics so it doesn't distort the read on genuine customer behavior.
Target
✦ Confirm account type
✦ Decide on metric treatment
✦ No hard deadline
✦ Decide on metric treatment
✦ No hard deadline
September week-by-week plan
| Week | Rough share of monthly target | Primary focus |
|---|---|---|
| Aug 30–Sep 5 | ₹1.6L | H1 Dr Kamini Prakash call · H2 lapsed WhatsApp · H3 Oils investigation |
| Sep 6–12 | ₹1.75L | M1 Flours campaign · M3 new customer follow-up · Sep 5 subscription batch (6 due) |
| Sep 13–19 | ₹1.75L | M4 3-week lapsed outreach · Sep 12 & 19 subscription batches (11 due) |
| Sep 20–26 | ₹1.9L | L2 Exotic messaging · Sep 26 subscription batch (5 due) · month-close push |
| September total | ₹7.00L | Confirmed target from source's TargetPerformance sheet — weekly split above is an even-ish allocation, not individually confirmed sub-targets |
Broadcast performance
⚠️ Stale — last refreshable data: Jun 21–27 · Source: Broadcast Tracking 2026 (not found in current weekly workbook)This section could not be refreshed this pass
The per-send performance data below (Jun 21–27 broadcasts, delivery/read rates, top-5 broadcasts) came from a "Broadcast Tracking 2026" source that isn't present in the current ROF Weekly Sales Review workbook. The only broadcast-adjacent data in the current workbook is a send calendar from Oct 2025 (no performance metrics) and a "Week 1/2/3" summary table that doesn't map to real dates and appears to be from the same period. Everything below this notice is carried over from whenever it was last pulled — it is not being kept current by this refresh process. If broadcast tracking still exists somewhere (a different sheet, a WhatsApp Business API export, etc.), point me to it and I'll wire it into the regular refresh.
Broadcasts this week
8
vs 7 prior week
Total sent
1,847
across all cohorts
Delivered
892
48.3% delivery rate
Read
312
35.0% of delivered
Purchases attributed
0
₹0 revenue this week
Jun attributed total
₹7,042
vs ₹1.45L in Jan
This week’s broadcasts — Jun 21–27
| Date | Time | Cohort | Template | Sent | Delivered | Read | Replied | Del% | Read% | Buys | Revenue |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Mon Jun 23 | 8:30 AM | Active Buyers | monday_place_your_order | 94 | 38 | 42 | 14 | 40.4% | 44.7% | 0 | ₹0 |
| Mon Jun 23 | 8:35 AM | No purchase 31–60d | choose_your_box | 58 | 42 | 11 | 3 | 72.4% | 19.0% | 0 | ₹0 |
| Mon Jun 23 | 8:40 AM | Archive Leads (6,597) | leads_m1_intro_original | 6,597 | Not found | — | — | — | — | 0 | ₹0 |
| Wed Jun 25 | 8:30 AM | Active Buyers | wed_order_w27 | 97 | 46 | 38 | 15 | 47.4% | 39.2% | 0 | ₹0 |
| Wed Jun 25 | 8:35 AM | No purchase 31–60d | fruits_confirmation_august | 62 | 48 | 19 | 4 | 77.4% | 30.6% | 0 | ₹0 |
| Wed Jun 25 | 8:40 AM | Archive Leads (6,597) | product_in_stock | 6,597 | Not found | — | — | — | — | 0 | ₹0 |
| Fri Jun 27 | 8:30 AM | Active Buyers | friday_confirmation_09 | 96 | 41 | 32 | 12 | 42.7% | 33.3% | 0 | ₹0 |
| Fri Jun 27 | 8:35 AM | No purchase 31–60d | salad_and_more_products | 53 | 39 | 14 | 3 | 73.6% | 26.4% | 0 | ₹0 |
Attributed revenue vs broadcasts sent — Jan–Jun 2026
Top 5 best performing broadcasts — Jan–Jun 2026
| Date | Template | Cohort | Type | Sent | Delivered | Replied | CTR | Purchases | Revenue |
|---|---|---|---|---|---|---|---|---|---|
| 9 Feb 2026 | monday_place_your_order | Active Buyers | UTILITY | 95 | 30 | 20 | 66.7% | 13 | ₹17,320 |
| 16 Jan 2026 | reminder_order_closing | Active Buyers | UTILITY | 79 | 41 | 13 | 31.7% | 10 | ₹15,602 |
| 30 Jan 2026 | dressings_new_batch | Active Buyers | UTILITY | 96 | 34 | 15 | 44.1% | 9 | ₹13,472 |
| 12 Jan 2026 | reminder_order_closing | Active Buyers | UTILITY | 71 | 37 | 10 | 27.0% | 8 | ₹12,918 |
| 23 Jan 2026 | reminder_order_closing | Active Buyers | UTILITY | 89 | 48 | 12 | 25.0% | 7 | ₹11,800 |
Broadcast insights
Zero purchase attribution this week — 8 sends, ₹0 revenue
8 broadcasts went out this week. Active Buyer delivery rates were 40–47% and read rates 33–45%. Zero purchases attributed. The sends are happening and being read — the template or timing is not converting. This is a conversion problem, not a reach problem.
Jun 2026 attributed ₹7,042 vs Jan peak ₹1.45L — 95% collapse
Three things changed in March: templates shifted away from Reminder format, sends moved to morning instead of afternoon, and the 6,597-contact archive lead cohort began dominating sends, diluting active-buyer targeting. Broadcast volume has not changed — conversion has.
Winning formula — all 5 top broadcasts share the same DNA
Cohort = Active Buyers only (71–114 people), Time = Afternoon 12:30–12:45 PM, Type = UTILITY. Reminder-type templates consistently generate 7–13 purchases at ₹11K–₹17K. This week’s sends all went at 8:30–8:40 AM. Afternoon sends to active buyers is the single highest-impact change.
Next week action: one Reminder send, 12:30 PM, active buyers only
Template: reminder_order_closing or monday_place_your_order. Cohort: Active buyers last 45 days. Time: 12:30 PM. Day: Monday or Friday. Expected: 7–13 purchases, ₹11K–₹17K attributed — exactly what this formula produced in Jan–Feb across 5+ consecutive weeks.