Capstone: A Quarterly Marketing Plan
Bring the whole course together in a nine-part quarterly plan with a three-month forecast, worst and best cases, a search for the conversion rate needed to reach the target, and rules for review.
In this lesson you will
- Write a nine-part marketing plan
- Forecast with base, worst and best cases
- Find what must be true to reach a target
- Set review dates and decision rules
About 30 minutes
One plan that holds the whole course together
This is the capstone. Noor writes the plan for the next three months of her shop, using everything in the course: the goal, audience and offer, the channels and content, the budget, tracking, a forecast with scenarios, and the rules she will use to decide what to do when the results come in. A plan like this is not a prediction. It is a way to think clearly before spending, and to notice early when reality is not matching what you hoped.
The nine parts
- Goal. A number and a date.
- Audience and offer. One segment and a clear offer (lessons 2 and 11).
- Channels and content. Where you will show up, and the calendar (lessons 4, 5, 13 and 14).
- Budget. Limits checked against margin, CAC and payback (lessons 7, 16, 22 and 25).
- Tracking. Tagged links, a sales check and consent (lessons 9, 17 and 27).
- Forecast. Visitors, conversion, orders and profit, with a worst and best case.
- Review dates. Weekly checks and a monthly review.
- Decision rules. Written before the results arrive (lesson 20).
- Risks. What could go wrong, and what you will do.
Forecast it, with scenarios
The program below forecasts three months for the candle shop. It starts from the four traffic sources of lesson 10, applies a different monthly growth rate to each, a 3.2 per cent conversion rate, an 18 pound average order, a 45 per cent margin and a 200 pound monthly ad budget. Then it runs a worst case, with conversion 20 per cent lower and no growth, and a best case, with conversion 20 per cent higher and growth twice as fast. Finally it asks a question forecasts exist to answer: what would have to be true to reach the target?
# MADE-UP quarter plan for the candle shop: monthly visitors by channel
base = {"email": 300, "social": 400, "search": 200, "ads": 333}
growth = {"email": 0.10, "social": 0.05, "search": 0.15, "ads": 0.0}
conv, aov, margin_rate, ad_spend = 0.032, 18.0, 0.45, 200.0
target_profit = 600.0
def quarter(c, g_scale=1.0):
rows = []
for mth in range(3):
v = sum(base[k] * (1 + g_scale * growth[k]) ** mth for k in base)
orders = v * c
profit = orders * aov * margin_rate - ad_spend
rows.append((v, orders, profit))
return rows
def show(label, rows):
tot = sum(r[2] for r in rows)
print(f"{label}: profit {tot:.0f}, orders {sum(r[1] for r in rows):.0f}")
return tot
for m_, (v, o, p) in enumerate(quarter(conv), 1):
print(f"month {m_}: visitors {v:.0f}, orders {o:.0f}, profit {p:.0f}")
base_p = show("base", quarter(conv))
worst = show("worst (lower conversion, no growth)", quarter(conv * 0.8, 0.0))
best = show("best (higher conversion, double growth)", quarter(conv * 1.2, 2.0))
print("target profit:", target_profit)
print("base meets target:", base_p >= target_profit)
print("worst still positive:", worst > 0)
lo, hi = 0.01, 0.2
for _ in range(40):
mid = (lo + hi) / 2
if sum(r[2] for r in quarter(mid)) >= target_profit:
hi = mid
else:
lo = mid
print("conversion needed for target:", round(100 * hi, 2), "%")
print("rise needed:", round(100 * (hi / conv - 1)), "%")
sections = ["goal", "audience", "offer", "channels", "budget", "tracking", "forecast", "review dates", "decision rules"]
have = ["goal", "audience", "offer", "channels", "budget", "tracking", "forecast", "review dates", "decision rules"]
print("plan sections missing:", [s for s in sections if s not in have] or "none")
month 1: visitors 1233, orders 39, profit 120
month 2: visitors 1313, orders 42, profit 140
month 3: visitors 1402, orders 45, profit 163
base: profit 423, orders 126
worst (lower conversion, no growth): profit 167, orders 95
best (higher conversion, double growth): profit 710, orders 162
target profit: 600.0
base meets target: False
worst still positive: True
conversion needed for target: 3.75 %
rise needed: 17 %
plan sections missing: none
In the base case, month 1 brings 1233 visitors and 120 pounds of profit, and by month 3 there are 1402 visitors and 163 pounds. Over the quarter the base case gives 423 pounds of profit from 126 orders, against a target of 600.0. The base case misses the target. The worst case still makes 167 pounds, because the cost is low and the margin is fair, and the best case reaches 710. The search for the answer says conversion would need to be 3.75 per cent, a rise of about 17 per cent from today’s 3.2, with the same growth in traffic. That is useful. It does not say the target will be met. It says where the effort should go: lesson 18 and 19’s testing and fixing of the funnel, which might lift conversion that much, rather than more advertising. A plan that shows a gap on paper is doing its job.
Using the plan
- Write the nine parts on one page, in plain words.
- Check each number against real data, and label any guess as a guess.
- Pick the one or two moves that close the gap, and put them on the calendar.
- Review weekly for numbers and monthly for decisions, using the rules you wrote.
- After the quarter, compare forecast with results, record what you learned and write the next plan.
Making the plan reach the target by changing the assumptions until it does. If the forecast only works when everything goes right, the plan is a wish. Show the gap honestly, and plan to close it.
Every figure here is made up, and real results vary. Keep to the rules that apply to your marketing, including consent, email and advertising rules, and be honest with customers and clients. Nobody can promise results from marketing, so measure, learn and keep improving.
Practice for this lesson
Check what you learned
Five quick questions. Pick an answer and you will see straight away whether it is right and why.
Why run worst and best cases?
- To see the range of outcomes
- To get a bigger number
- To avoid decisions
- To hide risk
Scenarios show what a plan can survive and what it could gain.
Did the base case reach the profit target?
- Yes
- No
- Exactly
- It was not run
It fell short of the 600 pound target.
What did the search for the needed conversion show?
- No change was needed
- Conversion must halve
- It could not be found
- A rise of about 17 per cent was needed
About 3.75 per cent against today’s 3.2.
When should decision rules be written?
- After the results
- Before the results arrive
- Never
- Only if losing
Rules written in advance keep judgement honest.
What should you do about a gap in the forecast?
- Change assumptions until it vanishes
- Ignore it
- Spend everything
- Plan moves to close it
A plan that shows a gap lets you act on it.
Summary
- A plan has a goal, audience, offer, channels, budget, tracking, forecast, review dates and decision rules.
- Scenarios show the range, not a promise.
- Find what must be true to reach the target, and plan to close the gap.
- Review, learn and write the next plan.
Questions
How long should a plan be?
One page is enough, with the nine parts in plain words and the key numbers. A plan you follow beats a long one you do not.
Are the figures real?
No. They are made-up sample numbers to show the method. Use your own.
What if my forecast misses the target?
Good, you found out early. Decide whether to change the target, find more traffic or improve conversion, and write down which you chose and why.
