The Marketing Scorecard Template
This template is a ten-row marketing scorecard any business can run in a weekly meeting. Each row carries four working columns: This week (the number as of Monday morning), Target (set from your own history), Status (green, yellow, or red against the target), and Owner (the one person who answers for it). Copy it into Google Sheets with the button below, fill in the targets from your last eight weeks, and run the first review next Monday.
Why this scorecard exists
Most templates are KPI lists. This one is a system.
Search for a marketing scorecard template and you get a spreadsheet with a column of metric names and a column of blank cells. That is a KPI list, not a scorecard. Nobody is named, nothing is scheduled, and no number has a rule attached that says what happens when it goes wrong. A list like that gets filled in twice, then sits in a shared drive until someone builds a new one.
A working scorecard needs three columns most templates leave out. Owner: one role who reports the number and answers for it, never a team. Cadence: how often the number is pulled, which is daily for the few things that break fast and weekly for everything else. Red flag: a written rule that turns a bad number into an action, such as two weeks below target starts a review. Those three columns are the difference between a report people look at and a tool people run a business with.
When the scorecard is live, Monday changes. The numbers are already filled in before anyone sits down, so the meeting is about the reds, not about finding the data. Each owner reads their row in under a minute. Every red flag that fires leaves the room with a name and a due date. The copy button below pastes this template straight into Google Sheets, and if you want the rows tailored to your channels and your kind of business, the builder at /tools/scorecard-builder does that in a few minutes.
The scorecard
10 numbers. Every one has an owner.
| Metric | What it means | How to set the target | Owner | Cadence | Red flag |
|---|---|---|---|---|---|
| Total marketing spend Every other row on the scorecard is judged against this number, so it goes first and it has to be complete. | Every dollar that left the business for marketing this week, including ad platforms, tools, contractors, and printed material. | Set it to the weekly budget the owner approved for the quarter, divided evenly, then adjust for known seasonal weeks from last year's spend pattern. | Marketing lead | Weekly | Spend more than 15 percent over or under the approved weekly figure triggers a same-day check of every platform budget. |
| Qualified leads Raw lead counts reward junk; a qualified count is the number the sales side will actually agree with. | New inquiries this week that match your written definition of a real prospect, counted once each across forms, calls, chats, and walk-ins. | Take your trailing eight-week median of qualified leads and hold it as the floor, then raise the target 10 percent each quarter that you hit it three months running. | Marketing lead | Weekly | Two consecutive weeks below target starts a channel-by-channel source review before any budget moves. |
| Cost per qualified lead It is the fastest way to see whether more spend is buying more prospects or just more traffic. | Total marketing spend divided by qualified leads for the same week. | Use your trailing eight-week median as the ceiling and tighten it 10 percent per quarter, resetting the baseline whenever you add or drop a channel. | Media buyer | Weekly | Any week above the ceiling while lead volume is also down puts a hold on new campaign launches until the cause is found. |
| Lead response time Slow follow-up quietly wastes the spend in row one, and it is the row most businesses have never measured. | Median minutes between a lead arriving and a human replying, measured across every intake channel. | Pull your last 30 leads, find the median response time, and set the target at half that figure until you reach a number you can hold during business hours. | Front desk lead | Daily | Any single business day with a median above target gets flagged that afternoon, and two in a week triggers a staffing and routing review. |
| Lead-to-appointment rate It shows whether marketing is bringing in people who actually want what you sell, and whether sales is picking up the phone. | The share of qualified leads that booked a call, visit, quote, or demo within seven days. | Calculate the rate for your last full quarter and set that as the floor, then raise it in steps only after you have fixed response time. | Sales lead | Weekly | A drop below the floor for two weeks starts a call-recording or inbox review with both the marketing lead and the sales lead in the room. |
| New customers won This is the number the owner cares about, and it keeps the rest of the scorecard from drifting into vanity. | Deals closed or first purchases completed this week that started from a marketing-sourced lead. | Set it from your trailing eight-week median of closed marketing-sourced deals, adjusted for known seasonality in your own history. | Sales lead | Weekly | Two weeks below target while leads and appointments are on target moves the review to the sales process, not the marketing. |
| Cost per new customer It ties the whole scorecard back to a single dollar figure the owner can compare to what a customer is worth. | Total marketing spend divided by new customers won in the same week. | Use your trailing 12-week average as the ceiling, since this number swings week to week, and tighten it 10 percent per quarter. | Owner | Weekly | Four weeks in a row above the ceiling triggers a budget reallocation decision at the next monthly review. |
| Marketing-attributed revenue Lead counts can look fine while the leads get smaller; revenue is the check. | Revenue this week from customers whose first contact was a tracked marketing source. | Set a floor at the trailing eight-week median, and review the target monthly against the revenue goal the owner set for the quarter. | Owner | Weekly | Revenue below floor while new customer count is on target starts a review of deal size by source. |
| Website conversion rate The site is where almost every channel lands, so a drop here explains a lot of other red rows. | Form fills plus tracked calls divided by website sessions, counted from one analytics source. | Take the trailing eight-week median from your analytics and hold it as the floor, resetting the baseline after any site redesign or tracking change. | Marketing lead | Weekly | Any week more than 20 percent below the floor triggers a same-day form and call-tracking test on every key page. |
| Leads with a known source Every row above depends on this one; if you cannot say where leads came from, the cost and revenue rows are guesses. | The share of qualified leads this week where you can name the channel that produced them. | Measure it once, set the target 10 points higher, and keep raising it until the unknown bucket is small enough to ignore. | Marketing lead | Monthly | Any month below target adds a tracking fix to the marketing lead's list before any new channel is added. |
Targets are set from your own history, never from someone else's benchmarks. The builder does the arithmetic once you plug in your numbers.
The weekly review
Twenty minutes, same order, every week.
// 01
Start with new customers and cost per customer
Read the two bottom-line rows first, before anyone explains anything. If both are green, the meeting is short. If either is red, the next fifteen minutes are about finding which upstream row caused it.
// 02
Walk the reds and yellows only
Skip every green row. For each red, the owner states the number, the target, and whether the red flag rule has fired. No slides, no story, just the row.
// 03
Owners speak, everyone else listens
The person in the Owner column reports their row. If they do not know why it moved, they say so, and the meeting notes a follow-up rather than guessing at a cause in the room.
// 04
Leave with names and dates
Every red flag that fired gets one action, one owner, and a due date written on the sheet. Targets are only changed at the monthly review, never in the weekly meeting, so a bad week cannot be fixed by moving the goalposts.
Where scorecards die
Mistakes we see constantly.
Copying the template without changing the targets
The target column ships blank on purpose. Fill it from your own trailing weeks, because a number borrowed from someone else is a number no one on your team will defend.
Naming a team as the owner
If the owner column says Marketing, no one pulls the number on Monday morning. Put one role in the cell, and if that person is out, name the backup.
Adding rows until the sheet is a dashboard
Ten rows is a scorecard; thirty rows is a report nobody reads. Every metric you add should be one you would stop the meeting over.
Skipping the red flag column
Without a written rule, a red cell is an opinion and the meeting turns into a debate. Write the rule once and the decision is already made when the number turns.
Filling in the numbers during the meeting
If the sheet is blank at the start of the review, the meeting is spent hunting data instead of deciding. Numbers are due before the meeting, and a missing number counts as a red.
Other scorecards
Same discipline, different numbers.
By platform
By business type
Want it set up live in your dashboards?
We install scorecards on real data, wire the owners and alerts, and coach the weekly review. Scorecards and accountability is the service.
Questions we get
Straight answers.
How do I get this template into Google Sheets?
Use the copy button on this page, open a blank Google Sheet, and paste into cell A1. The columns land in place, including Owner, Cadence, and Red flag, so all you add is your own targets and this week's numbers.
Can I use this template for a specific platform or business?
This is the general-purpose version. The builder at /tools/scorecard-builder tailors the rows by platform and type of business, and the scorecard cluster has ready pages for channels like Google Ads and Meta and for businesses like home services.
What if I do not have eight weeks of history?
Run the scorecard for four weeks with the target column empty and just record This week. After four weeks you have a median to set the first targets from, and that is a better starting point than any borrowed figure.
How long should the weekly review take?
Twenty minutes if the numbers are filled in before the meeting starts. If it runs longer, the sheet has too many rows or people are debating what a red means instead of following the red flag rule.
Should the owner run the scorecard or the marketing lead?
The marketing lead runs the meeting and keeps the sheet current. The owner owns the two bottom-line rows, attends every week, and is the only person who can change a target at the monthly review.
A scorecard is only as good as the system feeding it.
Start with a diagnostic call. We will tell you which of these numbers you can trust today and what it takes to trust the rest.