Q4 Marketing Strategy
Comparing Three Prompt Engineering Approaches on One Real Marketing Brief.
Objective: build a practical, board-ready Q4 strategy from a deliberately messy brief, and show how prompting technique changes the depth and rigor of the output.
The brief mixes confirmed numbers, assumptions, a flagged bad data source and two competing lead targets, the ambiguity a strategist actually faces. Figures come only from the supplied PDF. This is a prototype: no live link to ad platforms or customer databases.
One brief, many open questions
The Q4 brief mixes confirmed numbers, assumptions, a flagged data source and two competing targets. Nothing in it says which version to trust, and that is exactly what a strategist must handle before spending a rupee.
Two competing lead targets
Finance’s +20% operational target and the board’s +25% aspiration pull in different directions, with no verified baseline to test either.
An unreliable source page
Page 4 of the brief is flagged as bad data, so it is excluded from every performance metric and no Q3 numbers can be trusted.
Which audience is the audience?
15,000 users in the database but 12,500 active: the email audience is unclear, and unengaged addresses risk deliverability.
Budget not yet decided
Finance’s decision and the size of any cut are unknown, so spend is planned as priority tiers, not currency amounts.
A 30% offer with side effects
The win-back discount may cannibalize full-price sales and train customers to wait for deals.
Ambiguous dates and time zones
“Friday 9:00 AM EST” is unconfirmed, and the board-deck date is missing from the brief.
These conflicts stay open until management confirms them. Prompting reveals them; it does not settle them.
One brief, three techniques
Challenge: the brief mixes confirmed numbers, assumptions, a flagged bad data source and two competing lead-generation targets. Page 4 of the source is treated as unreliable and excluded from all performance metrics. Unverified figures are marked Data required.
Naive approach
Total users
Active users
Unengaged users
Prompt: Identify the data and generative-AI-driven strategies to improve customer retention.
Six GenAI retention strategies (tap to open)
Why this is “naive”
Persona approach
Role: Marketing Strategist and Data Analyst, one approach per segment, using only the given data, kept brief.
Tree-of-thoughts approach
Evidence panels
Segments, targets and risk
Customer segmentation
Active 12,500 (83.33%) vs unengaged 2,500 (16.67%) of 15,000. Verified
Lead-generation targets
Indexed to baseline 100, not actual lead volume. 120 is the operational target, 125 is aspirational and not guaranteed.
Optional: enter a verified Q3 lead baseline
Required leads stay formulas until a verified baseline exists: baseline × 1.20 and baseline × 1.25. Data required
Budget priority comparison
Email, LinkedIn, TikTok, retargeting, testing budget, contingency. Nothing cut first.
Highest-performing channel, highest-intent audiences, retargeting, existing database. Cut first: TikTok scale-up, high-cost creative, broad reach.
Retention strategy cards
Risk register
| Risk | Severity | Recommended action |
|---|
Severity ratings are the analyst’s judgment, not measured data.
From validation to evaluation
Priority tiers, no invented currency
| Priority matrix | Full (+25%) | Reduced (+20%) |
|---|
Budget, CPL and monetary allocations are Data required. None are invented here.
What the brief answers, and what it cannot
Each “Data required” flag was checked against the original brief. Where the brief supplies the answer it is filled in below; where it gives no number, the flag stays, because nothing is invented.
| Gap | What the brief supplies | Status |
|---|---|---|
| Board-deck date | Falls on a Tuesday; the calendar date is not given | Partly filled |
| Email send time | Friday 9:00 AM EST; the “yesterday” remark is ignored | Filled confirm date and timezone |
| Email KPIs | Delivery, open, click-through, conversion, unsubscribe, revenue, reactivation rate, incremental revenue, cost per reactivated user | Filled targets need baselines |
| LinkedIn plan | 11-part framework: theme, audience, targeting, pillars, ad concepts, lead magnet, landing page, CTA, qualification, retargeting, KPIs | Framework filled |
| TikTok plan | About 10 concepts built as Hook → Problem → Insight → Solution → Proof → CTA, with no promise of going viral | Structure filled |
| Agency review | 12 criteria and three options: improve, run a competitive pitch, or replace | Framework filled performance data still needed |
| Verified Q3 leads, spend, CPL, conversion | Only the formula; Q3 is described as substantially below expectations, with no figures | Data required |
| Advertising budget and Finance cut | Two scenarios defined, no currency amounts | Data required |
| Email platform, deliverability, geography, product, offer rules, landing page, tracking | Not mentioned | Data required |
Calculations that can be done now
| Metric | Input | Formula | Result | Interpretation |
|---|---|---|---|---|
| Active share | 12,500 of 15,000 | 12,500 ÷ 15,000 | 83.33% | Most of the base is already engaged, so deep discounts for them need justifying. |
| Unengaged share | 2,500 of 15,000 | 2,500 ÷ 15,000 | 16.67% | A small segment, which limits total exposure to the 30% offer. |
| Operational target | Index 100 | 100 × 1.20 | 120 | Indexed, not actual leads. |
| Ambitious target | Index 100 | 100 × 1.25 | 125 | Aspirational, not a promise. |
| Gap between targets | 25 vs 20 points | 25 ÷ 20 | 1.25× | The board ambition needs 25% more extra leads than the operational plan. |
Projected lead trajectory
Planning scenario, indexed to baseline 100. It is not historical performance; the even month-by-month ramp is an assumption.
Three-Statement Financial Model
Budget vs actual variance and scenario analysis: the financial impact of the Full (+25%) and Reduced (+20%) Q4 campaign budgets on the income statement, balance sheet and cash flow.
vs budget -3.3%
vs budget -33.4%
FY27: 14.0%
+13.0% YoY
Net debt (324)
Spend $115k
Scenario comparison
| Metric | 1 · Baseno campaign | 2 · Reduced+20% operational | 3 · Full+25% aspirational |
|---|---|---|---|
| Campaign spend ($000) | – | 115 | 250 |
| Incremental revenue, 5 quarters ($000) | – | 549 | 670 |
| Net contribution, 5 quarters ($000) | – | 209 | 145 |
| ROI on spend | – | 182% | 58% |
| Cost per new customer | – | $958 | $1,667 |
| Cost per incremental lead | – | $58 | $100 |
| Q4 FY26 EBITDA impact ($000) | – | (41) | (167) |
Key takeaways
- Active case: Reduced · +20% operational
- FY26 EBITDA $1,071k vs budget $1,609k (-33.4%)
- Q3 FY26 revenue -8.0% vs budget — the Q3 shortfall the brief describes
- Reduced (+20%) ROI 182% vs Full (+25%) 58%: each extra uplift point costs $27.0k
- Live-case campaign EBITDA hit in Q4 FY26: $(41)k, recovered across FY27
- Dec-27 cash $1,924k; net debt $(324)k
- Offer cannibalisation costs $9.0k of discount on sales that would have happened anyway
Scenario economics ($000)
Reduced +20% returns more net contribution than Full +25% on illustrative inputs: the extra five points of uplift cost more than they earn.
FY26 EBITDA: budget vs actual / latest estimate ($000)
Q1 to Q3 actual, Q4 latest estimate including the Reduced campaign.
Model integrity checks
- OKBalance sheet balances in every period
- OKNet income reconciles to retained earnings
- OKCash never negative
- OKDebt never negative
- OKScenario selector valid (1–3)
- ALL CHECKS PASSOverall status
All financial figures are illustrative placeholders. Only user counts, lead targets (+20% / +25%), offers (10% / 30%) and channel mix come from the Q4 brief.
Campaign Scenario Analysis
Three campaign cases computed side by side · "Live" column feeds the three statements via the selector on Assumptions!C5
| $000 unless stated | 1 · Base | 2 · Reduced | 3 · Full | Live case |
|---|---|---|---|---|
| Scenario | Base — no campaign | Reduced · +20% operational | Full · +25% aspirational | Reduced · +20% operational |
| Scenario levers (inputs) | ||||
| Lead uplift vs baseline | – | 20.0% | 25.0% | 20.0% |
| Run 10% / 30% offers? (1 = yes) | – | 1 | 1 | 1 |
| Spend — Email | – | 25.0 | 30.0 | 25.0 |
| Spend — LinkedIn | – | 60.0 | 75.0 | 60.0 |
| Spend — TikTok (scale-up cut in Reduced) | – | – | 70.0 | – |
| Spend — Retargeting | – | 30.0 | 40.0 | 30.0 |
| Spend — Testing budget | – | – | 15.0 | – |
| Spend — Contingency | – | – | 20.0 | – |
| Total campaign spend | – | 115.0 | 250.0 | 115.0 |
| Lead engine | ||||
| Baseline Q4 leads | 10,000 | 10,000 | 10,000 | 10,000 |
| Incremental leads | – | 2,000 | 2,500 | 2,000 |
| New customers | – | 120.0 | 150.0 | 120.0 |
| Quarterly revenue per customer ($000) | 1.0 | 1.0 | 1.0 | 1.0 |
| Offer economics (Q4 FY26) | ||||
| Offer redeemers — active base | – | 750 | 750 | 750 |
| Truly incremental orders | – | 300 | 300 | 300 |
| Incremental offer revenue (net of 10% discount) | – | 54.0 | 54.0 | 54.0 |
| Cannibalisation cost (discount on sales that would have happened) | – | (9.0) | (9.0) | (9.0) |
| Reactivated users — unengaged segment | – | 200 | 200 | 200 |
| Win-back revenue (net of 30% discount) | – | 21.0 | 21.0 | 21.0 |
| Net offer revenue | – | 66.0 | 66.0 | 66.0 |
| Campaign revenue by quarter (net of discounts) | ||||
| Q4 FY26 | – | 126.0 | 141.0 | 126.0 |
| Q1 FY27 | – | 114.0 | 142.5 | 114.0 |
| Q2 FY27 | – | 108.3 | 135.4 | 108.3 |
| Q3 FY27 | – | 102.9 | 128.6 | 102.9 |
| Q4 FY27 | – | 97.7 | 122.2 | 97.7 |
| Total campaign revenue (5 quarters) | – | 548.9 | 669.7 | 548.9 |
| Returns | ||||
| Gross margin on campaign revenue | – | 323.9 | 395.1 | 323.9 |
| Less: campaign spend | – | (115.0) | (250.0) | (115.0) |
| Net contribution (5 quarters) | – | 208.9 | 145.1 | 208.9 |
| ROI on campaign spend | – | 181.6% | 58.0% | 181.6% |
| Cost per incremental lead ($) | – | $58 | $100 | $58 |
| Cost per new customer ($) | – | $958 | $1,667 | $958 |
| Q4 FY26 EBITDA impact (hits the quarter) | – | (40.7) | (166.8) | (40.7) |
Campaign revenue = new-customer subscriptions (with retention decay) + offer revenue in Q4. Offer figures are net of discounts; cannibalisation is shown as a cost, not ignored.
Income Statement
Quarterly · $000 · Scenario: Reduced · +20% operational
| $000 unless stated | Q1 FY26Actual | Q2 FY26Actual | Q3 FY26Actual | Q4 FY26Forecast | Q1 FY27Forecast | Q2 FY27Forecast | Q3 FY27Forecast | Q4 FY27Forecast | FY26Act + Fcst | FY27Forecast |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | ||||||||||
| Core revenue | 2,772 | 2,813 | 2,760 | 3,088 | 2,898 | 3,040 | 3,182 | 3,515 | 11,432 | 12,635 |
| Campaign revenue (net of discounts) | – | – | – | 126 | 114 | 108 | 103 | 98 | 126 | 423 |
| Total revenue | 2,772 | 2,813 | 2,760 | 3,214 | 3,012 | 3,148 | 3,285 | 3,613 | 11,558 | 13,058 |
| growth QoQ % | 1.5% | (1.9%) | 16.4% | (6.3%) | 4.5% | 4.4% | 10.0% | 13.0% | ||
| Costs & profit | ||||||||||
| Cost of goods sold | 1,136 | 1,153 | 1,159 | 1,318 | 1,235 | 1,291 | 1,347 | 1,481 | 4,766 | 5,354 |
| Gross profit | 1,636 | 1,660 | 1,601 | 1,896 | 1,777 | 1,857 | 1,938 | 2,132 | 6,793 | 7,704 |
| gross margin % | 59.0% | 59.0% | 58.0% | 59.0% | 59.0% | 59.0% | 59.0% | 59.0% | 58.8% | 59.0% |
| People costs | 826 | 838 | 845 | 860 | 870 | 880 | 890 | 910 | 3,369 | 3,550 |
| Marketing — base | 231 | 240 | 255 | 247 | 232 | 243 | 255 | 281 | 973 | 1,011 |
| Marketing — Q4 campaign | – | – | – | 115 | – | – | – | – | 115 | – |
| General & administrative | 314 | 309 | 322 | 320 | 325 | 325 | 330 | 335 | 1,265 | 1,315 |
| Total operating expenses | 1,371 | 1,387 | 1,422 | 1,542 | 1,427 | 1,448 | 1,475 | 1,526 | 5,722 | 5,876 |
| EBITDA | 265 | 273 | 179 | 354 | 350 | 409 | 464 | 605 | 1,071 | 1,828 |
| EBITDA margin % | 9.6% | 9.7% | 6.5% | 11.0% | 11.6% | 13.0% | 14.1% | 16.8% | 9.3% | 14.0% |
| Depreciation | 84 | 85 | 85 | 86 | 86 | 87 | 87 | 88 | 339 | 347 |
| EBIT | 181 | 188 | 94 | 268 | 264 | 323 | 377 | 518 | 732 | 1,481 |
| Interest expense | 40 | 39 | 38 | 37 | 36 | 35 | 34 | 33 | 154 | 138 |
| Profit before tax | 141 | 149 | 56 | 231 | 228 | 288 | 343 | 485 | 578 | 1,343 |
| Income tax | 35 | 37 | 14 | 58 | 57 | 72 | 86 | 121 | 144 | 336 |
| Net income | 106 | 112 | 42 | 174 | 171 | 216 | 257 | 364 | 433 | 1,007 |
| net margin % | 3.8% | 4.0% | 1.5% | 5.4% | 5.7% | 6.9% | 7.8% | 10.1% | 3.7% | 7.7% |
Balance Sheet
Quarter-end · $000 · Scenario: Reduced · +20% operational
| $000 unless stated | Dec-25Opening | Q1 FY26Actual | Q2 FY26Actual | Q3 FY26Actual | Q4 FY26Forecast | Q1 FY27Forecast | Q2 FY27Forecast | Q3 FY27Forecast | Q4 FY27Forecast | FY26Act + Fcst | FY27Forecast |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Assets | |||||||||||
| Cash | 1,500 | 1,514 | 1,538 | 1,540 | 1,396 | 1,618 | 1,693 | 1,809 | 1,924 | 1,396 | 1,924 |
| Accounts receivable | 1,450 | 1,386 | 1,406 | 1,380 | 1,607 | 1,506 | 1,574 | 1,643 | 1,806 | 1,607 | 1,806 |
| Inventory | 700 | 694 | 705 | 708 | 805 | 755 | 789 | 823 | 905 | 805 | 905 |
| Net PP&E | 2,400 | 2,416 | 2,431 | 2,446 | 2,461 | 2,475 | 2,488 | 2,501 | 2,513 | 2,461 | 2,513 |
| Total assets | 6,050 | 6,011 | 6,080 | 6,075 | 6,269 | 6,353 | 6,544 | 6,776 | 7,149 | 6,269 | 7,149 |
| Liabilities | |||||||||||
| Accounts payable | 600 | 505 | 512 | 515 | 586 | 549 | 574 | 599 | 658 | 586 | 658 |
| Debt | 2,000 | 1,950 | 1,900 | 1,850 | 1,800 | 1,750 | 1,700 | 1,650 | 1,600 | 1,800 | 1,600 |
| Total liabilities | 2,600 | 2,455 | 2,412 | 2,365 | 2,386 | 2,299 | 2,274 | 2,249 | 2,258 | 2,386 | 2,258 |
| Shareholders' equity | |||||||||||
| Share capital | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 |
| Retained earnings | 950 | 1,056 | 1,168 | 1,210 | 1,383 | 1,554 | 1,770 | 2,027 | 2,391 | 1,383 | 2,391 |
| Total equity | 3,450 | 3,556 | 3,668 | 3,710 | 3,883 | 4,054 | 4,270 | 4,527 | 4,891 | 3,883 | 4,891 |
| Total liabilities & equity | 6,050 | 6,011 | 6,080 | 6,075 | 6,269 | 6,353 | 6,544 | 6,776 | 7,149 | 6,269 | 7,149 |
| Balance check (assets − L&E, must be 0) | – | – | – | – | – | – | – | – | – | – | – |
| Net debt | 500 | 436 | 362 | 310 | 404 | 132 | 7 | (159) | (324) | 404 | (324) |
Cash Flow Statement
Quarterly · $000 · Indirect method · Scenario: Reduced · +20% operational
| $000 unless stated | Q1 FY26Actual | Q2 FY26Actual | Q3 FY26Actual | Q4 FY26Forecast | Q1 FY27Forecast | Q2 FY27Forecast | Q3 FY27Forecast | Q4 FY27Forecast | FY26Act + Fcst | FY27Forecast |
|---|---|---|---|---|---|---|---|---|---|---|
| Operating activities | ||||||||||
| Net income | 106 | 112 | 42 | 174 | 171 | 216 | 257 | 364 | 433 | 1,007 |
| Add: depreciation | 84 | 85 | 85 | 86 | 86 | 87 | 87 | 88 | 339 | 347 |
| (Increase) / decrease in receivables | 64 | (20) | 26 | (227) | 101 | (68) | (69) | (164) | (157) | (200) |
| (Increase) / decrease in inventory | 6 | (10) | (4) | (97) | 51 | (34) | (34) | (82) | (105) | (100) |
| Increase / (decrease) in payables | (95) | 8 | 3 | 70 | (37) | 25 | 25 | 60 | (14) | 73 |
| Cash from operations | 164 | 173 | 153 | 6 | 372 | 225 | 266 | 265 | 496 | 1,128 |
| Investing activities | ||||||||||
| Capital expenditure | (100) | (100) | (100) | (100) | (100) | (100) | (100) | (100) | (400) | (400) |
| Cash from investing | (100) | (100) | (100) | (100) | (100) | (100) | (100) | (100) | (400) | (400) |
| Financing activities | ||||||||||
| Debt repayment | (50) | (50) | (50) | (50) | (50) | (50) | (50) | (50) | (200) | (200) |
| Cash from financing | (50) | (50) | (50) | (50) | (50) | (50) | (50) | (50) | (200) | (200) |
| Net change in cash | 14 | 23 | 3 | (144) | 222 | 75 | 116 | 115 | (104) | 528 |
| Opening cash | 1,500 | 1,514 | 1,538 | 1,540 | 1,396 | 1,618 | 1,693 | 1,809 | 1,500 | 1,396 |
| Closing cash | 1,514 | 1,538 | 1,540 | 1,396 | 1,618 | 1,693 | 1,809 | 1,924 | 1,396 | 1,924 |
| Free cash flow (CFO + CFI) | 64 | 73 | 53 | (94) | 272 | 125 | 166 | 165 | 96 | 728 |
Budget vs Actual — FY26 Variance Report
$000 · Q1–Q3 actual, Q4 = latest estimate under scenario: Reduced · +20% operational · budget excludes the Q4 campaign
| $000 | Q1 FY26Actual | Q2 FY26Actual | Q3 FY26Actual | Q4 FY26Latest est. | FY26Act + LE | |
|---|---|---|---|---|---|---|
| Actual / latest estimate | ||||||
| Core revenue | 2,772 | 2,813 | 2,760 | 3,088 | 11,432 | |
| Campaign revenue (net) | – | – | – | 126 | 126 | |
| Total revenue | 2,772 | 2,813 | 2,760 | 3,214 | 11,558 | |
| Cost of goods sold | 1,136 | 1,153 | 1,159 | 1,318 | 4,766 | |
| Gross profit | 1,636 | 1,660 | 1,601 | 1,896 | 6,793 | |
| People costs | 826 | 838 | 845 | 860 | 3,369 | |
| Marketing (base + campaign) | 231 | 240 | 255 | 362 | 1,088 | |
| General & administrative | 314 | 309 | 322 | 320 | 1,265 | |
| EBITDA | 265 | 273 | 179 | 354 | 1,071 | |
| Net income | 106 | 112 | 42 | 174 | 433 | |
| Budget (original plan, no Q4 campaign) | ||||||
| Core revenue | 2,800 | 2,900 | 3,000 | 3,250 | 11,950 | |
| Campaign revenue (net) | – | – | – | – | – | |
| Total revenue | 2,800 | 2,900 | 3,000 | 3,250 | 11,950 | |
| Cost of goods sold | 1,120 | 1,160 | 1,200 | 1,300 | 4,780 | |
| Gross profit | 1,680 | 1,740 | 1,800 | 1,950 | 7,170 | |
| People costs | 820 | 830 | 840 | 860 | 3,350 | |
| Marketing (base + campaign) | 224 | 232 | 240 | 260 | 956 | |
| General & administrative | 310 | 310 | 315 | 320 | 1,255 | |
| EBITDA | 326 | 368 | 405 | 510 | 1,609 | |
| Net income | 152 | 183 | 211 | 291 | 837 | |
| Variance — favourable / (unfavourable) | Status (FY26) | |||||
| Core revenue | (28) | (87) | (240) | (162) | (518) | Unfavourable |
| Campaign revenue (net) | – | – | – | 126 | 126 | Favourable |
| Total revenue | (28) | (87) | (240) | (36) | (392) | Unfavourable |
| Cost of goods sold | (16) | 7 | 41 | (18) | 14 | On track |
| Gross profit | (44) | (80) | (199) | (54) | (377) | Unfavourable |
| People costs | (6) | (8) | (5) | – | (19) | On track |
| Marketing (base + campaign) | (7) | (8) | (15) | (102) | (132) | Unfavourable |
| General & administrative | (4) | 1 | (7) | – | (10) | On track |
| EBITDA | (61) | (95) | (226) | (156) | (538) | Unfavourable |
| Net income | (46) | (71) | (170) | (117) | (404) | Unfavourable |
| Variance % of budget | ||||||
| Core revenue | (1.0%) | (3.0%) | (8.0%) | (5.0%) | (4.3%) | |
| Campaign revenue (net) | – | – | – | – | – | |
| Total revenue | (1.0%) | (3.0%) | (8.0%) | (1.1%) | (3.3%) | |
| Cost of goods sold | (1.4%) | 0.6% | 3.4% | (1.3%) | 0.3% | |
| Gross profit | (2.6%) | (4.6%) | (11.1%) | (2.8%) | (5.3%) | |
| People costs | (0.7%) | (1.0%) | (0.6%) | – | (0.6%) | |
| Marketing (base + campaign) | (3.1%) | (3.4%) | (6.2%) | (39.2%) | (13.8%) | |
| General & administrative | (1.3%) | 0.3% | (2.2%) | – | (0.8%) | |
| EBITDA | (18.7%) | (25.8%) | (55.8%) | (30.6%) | (33.4%) | |
| Net income | (30.2%) | (38.9%) | (80.2%) | (40.3%) | (48.2%) | |
Sign convention: positive = favourable to profit (revenue above budget, cost below budget). Q4 variance includes the selected campaign scenario by design.
Assumptions & Scenario Control
All inputs live here · blue = hard-coded input · yellow = key assumption / scenario lever · BRIEF = taken from the Q4 strategy brief · PLACEHOLDER = illustrative (brief gives no financials)
Scenario selector Reduced · +20% operational. In the Excel file, change Assumptions!C5 (1 Base, 2 Reduced, 3 Full) and every sheet recalculates. This page shows the Reduced +20% case.
| Input | Value | Source | Note |
|---|---|---|---|
| General, working capital & financing | |||
| Days per quarter | 90 | Placeholder | Used for DSO / DIO / DPO |
| Tax rate | 25.0% | Placeholder | Applied to positive pre-tax profit |
| Interest rate on debt (annual) | 8.0% | Placeholder | Charged quarterly on opening debt |
| Depreciation (% of opening net PP&E per quarter) | 3.5% | Placeholder | |
| Debtor days (DSO) | 45 | Placeholder | AR = revenue × DSO / days |
| Inventory days (DIO) | 55 | Placeholder | Inventory = COGS × DIO / days |
| Creditor days (DPO) | 40 | Placeholder | AP = COGS × DPO / days |
| Debt repayment per quarter ($000) | 50 | Placeholder | |
| Capex per quarter ($000) | 100 | Placeholder | |
| Variance materiality threshold (±%) | 2.0% | Placeholder | Within this band a budget variance is flagged "On track" |
| Opening balance sheet — 31 Dec 2025 ($000) | |||
| Cash | 1,500 | Placeholder | |
| Accounts receivable | 1,450 | Placeholder | |
| Inventory | 700 | Placeholder | |
| Net PP&E | 2,400 | Placeholder | |
| Accounts payable | 600 | Placeholder | |
| Debt | 2,000 | Placeholder | |
| Share capital | 2,500 | Placeholder | |
| Retained earnings (balancing figure) | 950 | Calc | Plugs so the opening balance sheet balances |
| Campaign & customer assumptions | |||
| Total email database users | 15,000 | From brief | Brief: 15,000 users in database |
| Active users | 12,500 | From brief | Brief: 12,500 active (83.3%) |
| Unengaged users | 2,500 | Calc | Brief: 2,500 (16.7%) |
| Baseline Q4 lead volume (leads) | 10,000 | Placeholder | Brief gives lead targets only as an index (100); verified Q3 baseline still required |
| Lead-to-customer conversion | 6.0% | Placeholder | |
| Revenue per new customer per quarter ($000) | 1.0 | Placeholder | Recurring revenue stream |
| Q4 timing factor (customers join mid-quarter) | 50.0% | Placeholder | Share of a full quarter recognised in Q4 FY26 |
| Quarterly customer retention | 95.0% | Placeholder | Applied to each following quarter |
| Active-user offer discount | 10.0% | From brief | Brief: 10% offer |
| Active-user offer redemption rate | 6.0% | Placeholder | |
| Average order value — active users ($000) | 0.200 | Placeholder | $200 |
| Share of redeemers who would have bought anyway | 60.0% | Placeholder | Cannibalisation risk flagged in the brief |
| Win-back discount (unengaged users) | 30.0% | From brief | Brief: 30% win-back offer |
| Win-back reactivation rate | 8.0% | Placeholder | |
| Win-back average first order ($000) | 0.150 | Placeholder | $150 |
Quarterly operating drivers ($000)
| Driver | Q1 FY26Actual | Q2 FY26Actual | Q3 FY26Actual | Q4 FY26Forecast | Q1 FY27Forecast | Q2 FY27Forecast | Q3 FY27Forecast | Q4 FY27Forecast |
|---|---|---|---|---|---|---|---|---|
| Budget — core revenue | 2,800 | 2,900 | 3,000 | 3,250 | 3,050 | 3,200 | 3,350 | 3,700 |
| Budget — COGS % of revenue | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% |
| Budget — people costs | 820 | 830 | 840 | 860 | 870 | 880 | 890 | 910 |
| Budget — base marketing % of core revenue | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% | 8.0% |
| Budget — G&A | 310 | 310 | 315 | 320 | 325 | 325 | 330 | 335 |
| Forecast — core revenue run-rate vs budget | n/a | n/a | n/a | (5.0%) | (5.0%) | (5.0%) | (5.0%) | (5.0%) |
| Forecast — COGS % of revenue | n/a | n/a | n/a | 41.0% | 41.0% | 41.0% | 41.0% | 41.0% |
Q3 run-rate adjustment reflects the brief: Q3 "substantially below expectations" (no figures given).
Actuals — Input
Reported operating lines for completed quarters · ILLUSTRATIVE PLACEHOLDER figures (replace with ledger actuals)
| $000 | Q1 FY26 | Q2 FY26 | Q3 FY26 |
|---|---|---|---|
| Core revenue | 2,772 | 2,813 | 2,760 |
| COGS | 1,136 | 1,153 | 1,159 |
| People costs | 826 | 838 | 845 |
| Marketing — base | 231 | 240 | 255 |
| G&A | 314 | 309 | 322 |
Q3 core revenue is ~8% under budget, mirroring the brief ("Q3 substantially below expectations"). Legend: blue cells are the ones to overwrite. D&A, interest and tax for actual quarters come from the model schedules.
What each technique surfaced
| Naive | Persona | Tree of thoughts |
|---|
Dot ratings are a qualitative assessment of the three outputs, not measured data.
All three phases agree on the confirmed data: 15,000 users, the 10% and 30% offers and the channel mix. What differs is how much hidden risk and ambiguity each surfaces before the strategy ships.
Fast, but unaudited
Delivers an idea list in seconds, with no validation, no risk flags and no separation of facts from assumptions.
Sharper, still blind
Adds a strategist’s lens and segment actions, yet hides the contradictions and missing data.
Most complete
Surfaces gaps, excludes page 4 and produces board-ready scenarios, at the cost of the longest review time.
Note: figures come only from the supplied brief, except the Financial model section, whose currency amounts are labelled illustrative placeholders. This is a prototype and not production results.
Let’s connect
Tap an icon to connect.