Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.
How to use the template
Set your targets once
On the Settings tab, enter your contribution margin, target MER, target platform ROAS, and target and maximum CAC. Break-even MER is 1 divided by contribution margin: at 50% margin it is 2.0. The other thresholds are starting points; replace them with ranges from your own history after 8 to 12 weeks.
Log last week every Monday
Add one row to the Weekly log for Monday to Sunday: budget, spend by platform, store revenue, new customers, platform-attributed revenue, and Meta impressions, reach, link clicks, video impressions, 3-second video plays and ThruPlays. Save a 'Monday report' column preset in Ads Manager so this takes two minutes.
Read top to bottom
Spend vs budget first: if the plan didn't run, the other numbers mean less. Then money (MER, CAC, ROAS), then creative (hook rate, hold rate, CTR), then the auction (frequency, CPM). When a layer is off, the layer below usually explains why.
Act on red, watch amber, check the trend
Start with red rows and use the Check first and Do this columns. Before a big change, open the 12-week trend: three weeks of sliding hook rate and rising frequency calls for new creative; one odd week after a holiday may not.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Number | In plain words | Formula |
|---|---|---|
| Spend vs budget | Did you spend what you planned? Over budget means a surprise bill; under budget means the plan didn't run. | Total ad spend / planned ad budget for the week |
| MER | Marketing efficiency ratio. For every $1 of ads, how many dollars of total sales came in from all channels. It doesn't depend on platform tracking. | Total store revenue / total ad spend |
| CAC | Customer acquisition cost. How much ad spend it took to win one new customer. | Total ad spend / new (first-time) customers that week |
| ROAS | Return on ad spend as the ad platforms report it: revenue they credit to their own ads per $1 spent. | Platform-attributed revenue / spend on that platform |
| Hook rate | Out of every 100 times a video ad was shown, how many people watched at least 3 seconds. It grades your first frame and first line. | 3-second video plays / impressions of video ads |
| Hold rate | Of the people you hooked, how many kept watching to 15 seconds (or the end of a shorter video). | ThruPlays / 3-second video plays |
| CTR | Link click-through rate. Of every 100 impressions, how many clicked through to your site. | Link clicks / impressions |
| Frequency | The average number of times each person saw your ads this week. | Impressions / reach |
| CPM | Cost per 1,000 impressions: the price of attention in the auction. | Spend / impressions x 1,000 (the workbook compares it with the previous 4 weeks) |
Worked review example
Illustrative week (2 to 8 November 2026): spend $7,350 against a $7,000 budget (105%, good). MER fell from 2.75 to 2.35 and CAC rose from $47 to $55 (both watch: profitable but below target). Platform ROAS slipped to 2.02, just above the 2.0 break-even.
The creative rows explain it: hook rate dropped from 23% to 19% (bad) while frequency rose from 2.9 to 3.6 (bad), with the same 4 ads in their sixth week. The 12-week trend shows a three-week slide, not a blip. The action is new hooks and new concepts for prospecting, not a budget cut or an attribution change.
What this template does and does not establish
The thresholds are GaaS editorial starting points, not industry benchmarks; search, retargeting and different categories behave differently. Platform ROAS is the platforms' own attribution and can overlap between platforms; MER is the reconciled top-line check. Reach is not additive, so frequency must come from exactly the reporting week. This weekly check-in does not replace a monthly stakeholder report or an incrementality test.
Primary references
- Meta: 3-second video plays
- Meta: ThruPlays (15-second)
- Meta: Frequency
- Meta: CPM (cost per 1,000 impressions)
- Meta: CTR (link click-through rate)
- Meta: About daily budgets (spend flexibility)
- Google Ads: Overdelivery and average daily budget
- Google Ads API: metrics reference
