Q4 Strategy
Live project · Prompt engineering · data-driven prototype

Q4 Marketing Strategy

Comparing Three Prompt Engineering Approaches on One Real Marketing Brief.

S. GIRIDHARAN
MBA · Finance & Marketing
S. GiridharanMBA · Finance & MarketingView LinkedIn profile ↗

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.

Explore Project
The business problem

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.

Messy brief→Prompt engineering→Structured output→Human verification→Board decision

These conflicts stay open until management confirms them. Prompting reveals them; it does not settle them.

01 · Brief and methodology

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.

02 · Phase 1

Naive approach


Verified
0

Total users

Verified
0

Active users

Verified
0

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”

03 · Phase 2

Persona approach


Role: Marketing Strategist and Data Analyst, one approach per segment, using only the given data, kept brief.

AssumptionNeeds and motivations are assumptions drawn from segment labels. Behavioral data is Data required before treating them as facts.
04 · Phase 3

Tree-of-thoughts approach


Evidence panels

05 · Analytics dashboard

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

Scenario 1 · Full budget · +25% aspirational

Email, LinkedIn, TikTok, retargeting, testing budget, contingency. Nothing cut first.

Scenario 2 · Reduced budget · +20% operational

Highest-performing channel, highest-intent audiences, retargeting, existing database. Cut first: TikTok scale-up, high-cost creative, broad reach.

Retention strategy cards

Risk register

RiskSeverityRecommended action

Severity ratings are the analyst’s judgment, not measured data.

06 · Q4 timeline

From validation to evaluation


07 · Budget and risk

Priority tiers, no invented currency


Priority matrixFull (+25%)Reduced (+20%)
RiskThe 30% offer may cannibalize full-price sales.
RiskUnengaged addresses may hurt email deliverability and sender reputation.

Budget, CPL and monetary allocations are Data required. None are invented here.

09 · Gaps filled from the brief

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.

GapWhat the brief suppliesStatus
Board-deck dateFalls on a Tuesday; the calendar date is not givenPartly filled
Email send timeFriday 9:00 AM EST; the “yesterday” remark is ignoredFilled confirm date and timezone
Email KPIsDelivery, open, click-through, conversion, unsubscribe, revenue, reactivation rate, incremental revenue, cost per reactivated userFilled targets need baselines
LinkedIn plan11-part framework: theme, audience, targeting, pillars, ad concepts, lead magnet, landing page, CTA, qualification, retargeting, KPIsFramework filled
TikTok planAbout 10 concepts built as Hook → Problem → Insight → Solution → Proof → CTA, with no promise of going viralStructure filled
Agency review12 criteria and three options: improve, run a competitive pitch, or replaceFramework filled performance data still needed
Verified Q3 leads, spend, CPL, conversionOnly the formula; Q3 is described as substantially below expectations, with no figuresData required
Advertising budget and Finance cutTwo scenarios defined, no currency amountsData required
Email platform, deliverability, geography, product, offer rules, landing page, trackingNot mentionedData required

Calculations that can be done now

MetricInputFormulaResultInterpretation
Active share12,500 of 15,00012,500 ÷ 15,00083.33%Most of the base is already engaged, so deep discounts for them need justifying.
Unengaged share2,500 of 15,0002,500 ÷ 15,00016.67%A small segment, which limits total exposure to the 30% offer.
Operational targetIndex 100100 × 1.20120Indexed, not actual leads.
Ambitious targetIndex 100100 × 1.25125Aspirational, not a promise.
Gap between targets25 vs 20 points25 ÷ 201.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.

10 · Financial model

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.

IllustrativeEarlier sections use no currency, because the brief gives none. This model is separate: it takes only the user counts, +20% / +25% targets, 10% / 30% offers and channel mix from the brief, and fills every currency amount, margin and ratio with a labelled Placeholder. Replace them with real data before relying on any figure. Units: $000 unless stated; FY = calendar year.
Q4-Marketing-Strategy-Financial-Model.xlsx · 8 linked sheets · live formulas
FY26 revenue
$11,558k

vs budget -3.3%

FY26 EBITDA
$1,071k

vs budget -33.4%

FY26 EBITDA margin
9.3%

FY27: 14.0%

FY27 revenue
$13,058k

+13.0% YoY

Cash, Dec-27
$1,924k

Net debt (324)

Campaign ROI (live case)
182%

Spend $115k

Scenario comparison

Metric1 · Baseno campaign2 · Reduced+20% operational3 · Full+25% aspirational
Campaign spend ($000)–115250
Incremental revenue, 5 quarters ($000)–549670
Net contribution, 5 quarters ($000)–209145
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.

08 · Comparison and conclusion

What each technique surfaced


NaivePersonaTree 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.

Technique sets the depth. Verification sets the trust.
Naive

Fast, but unaudited

Delivers an idea list in seconds, with no validation, no risk flags and no separation of facts from assumptions.

Persona

Sharper, still blind

Adds a strategist’s lens and segment actions, yet hides the contradictions and missing data.

Tree of thoughts

Most complete

Surfaces gaps, excludes page 4 and produces board-ready scenarios, at the cost of the longest review time.

Still requiredNo technique resolves the open conflicts alone. Confirm the Q3 lead baseline, Finance’s budget decision, the send date and the board-deck date, and record every assumption.
SG
Academic attribution

S. Giridharan

MBA · Finance & Marketing

giridharan1662005@gmail.com

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.

Return to Dashboard