Marketing Plan Template in Excel: Goals, Funnel Math, Actions, Budget and Tracking
Build a marketing plan template in Excel for a small business: where you stand, measurable goals, reverse funnel math from a sales target, an action plan by channel, budget, and monthly tracking of conversion, CPA, ROAS and CAC, with a worked example.
A marketing plan template in Excel turns a sales goal into marketing numbers (how many orders, visits or leads you need), lists the actions on each channel with owners and dates, assigns a budget to each, and compares plan with results every month. For a small business, five linked tabs are more useful than a long document, because a spreadsheet gets updated and reviewed. This guide walks through each tab and shows how to work backwards from a revenue target.
The five tabs
| Tab | Contents |
|---|---|
| 1. Situation | Sales by channel over the last 12 months, conversion rate, average order, past campaign results, key conclusions |
| 2. Goals and funnel | Revenue target and the orders, visits or leads needed to reach it |
| 3. Actions | What, which channel, who, when, cost and the metric it should move |
| 4. Budget | Spend by channel and month, planned and actual |
| 5. Tracking | Monthly metrics against targets with color alerts |
Tab 1: start from real numbers
Summarize where sales come from (website, marketplace, store, social), your conversion rate, average order value, what each past campaign cost and returned, and three or four specific conclusions, for example “email drives 18% of online sales with 4% of the budget”. Your sales tracker spreadsheet and the competitor analysis template feed this tab.
Tab 2: reverse funnel math
Work backwards from the revenue goal:
- Orders needed:
=ROUNDUP(RevenueGoal/AverageOrder,0) - Visits needed:
=ROUNDUP(Orders/ConversionRate,0) - Paid visits needed:
=MAX(0,VisitsNeeded-OrganicVisitsExpected) - Estimated ad spend:
=PaidVisits*AverageCPC
Example: a bakery’s online pre-orders for one quarter
| Item | Calculation | Value |
|---|---|---|
| Revenue goal | Target | $36,000 |
| Average order | History | $36 |
| Orders needed | $36,000 ÷ $36 | 1,000 |
| Website conversion rate | History | 3% |
| Visits needed | 1,000 ÷ 3% | 33,334 |
| Organic, social and email visits expected | Trend | 22,000 |
| Paid visits needed | 33,334 − 22,000 | 11,334 |
| Ad spend at $0.60 per click | 11,334 × $0.60 | $6,800 |
| Email tools, photography, local partnerships | Plan | $2,200 |
| Total marketing budget | $9,000 |
The funnel also shows the cheaper lever: raising conversion from 3% to 3.5% (faster checkout, clearer pickup times, better product photos) cuts the visits needed to 28,572, saving about $2,860 in ads for the same goal.
Tab 3: action plan
One row per action: channel, specific action (“holiday pre-order email sequence, three emails”), goal it supports, owner, start and end date, planned cost, metric and status. Sort by date to get the quarter’s calendar, and plan the weekly posts in the content calendar template.
Tab 4: budget
Channels in rows, months in columns, planned and actual side by side. Variance: =Actual-Planned and =IF(Planned=0,"",Actual/Planned-1). The marketing budget template goes deeper into this tab.
Tab 5: monthly tracking
| Metric | Formula |
|---|---|
| Conversion rate | Orders ÷ visits |
| Cost per acquisition (CPA) | Ad spend ÷ orders from ads |
| ROAS | Revenue from ads ÷ ad spend |
| Customer acquisition cost (CAC) | Total marketing spend ÷ new customers |
| Repeat customer rate | Returning customers ÷ all customers |
In the example, 11,334 paid visits at 3% conversion bring 340 orders, or $12,240 of revenue, for $6,800 of ads: a ROAS of 1.8. That may look positive, but ROAS measures revenue, not profit. After ingredients, packaging and payment fees, a bakery with a 60% gross margin earns about $7,340 of gross profit from that revenue, barely more than the ad spend. Check it with the profit margin calculator before scaling paid ads, and focus on repeat customers, who cost nothing to reacquire.
Review rhythm
- Weekly: action status and spend to date.
- Monthly: metrics against targets; move budget from weak channels to strong ones.
- Quarterly: refresh the situation tab and redo the funnel with actual numbers.
More planning tools are in Marketing Plans & Trackers.
Frequently asked questions
What should a small business marketing plan include?
Current results, measurable goals, the funnel math to reach them, actions with owners and dates, a budget and a monthly tracking sheet.
Annual or quarterly?
Set the year’s direction and plan in detail by quarter; channels and costs change too fast for a fixed annual plan.
How do I know which channel produced a sale?
Use tagged links, discount codes per channel and your analytics, and keep one attribution method so months are comparable.
Does it work in Google Sheets?
Yes, and the whole team can update actions and results in one file.