Marketing scorecard template: 12 numbers with definitions, formulas, sources and owners

What is a marketing scorecard template, and which 12 numbers belong on it?

A marketing scorecard template is one page with 12 numbers in four groups: business outcomes, pipeline and customers, brand, and efficiency. Each number has a definition, a formula, a data source and a named owner. That way the chief executive officer (CEO) and the board read the same figure the same way every quarter.

Here is a worked example, not a benchmark. LTV of 12 and CAC of 4, both in thousands of dollars, give an LTV:CAC ratio of 12 ÷ 4 = 3. Show all three figures on the page, because a ratio without its inputs invites the first question a CFO will ask.

The scorecard then feeds the quarterly board deck. The brand rows draw on a brand tracking program.

The template: 12 numbers to copy

Copy the table below into a spreadsheet. The rows follow the four groups set out at the top of this piece, in the same order, and each number appears once. The Target column stays blank until the CFO and CEO agree a figure for the quarter.

Gartner's 2026 figures put paid media at 31.4% and AI at 15.3% of marketing budgets, with the average budget at 7.8% of company revenue.

Marketing spend shares reported by Gartner, 2026

Marketing spend shares reported by Gartner, 2026

Label	Value
Paid media share of marketing budget	31.4%
AI share of marketing budget	15.3%
Marketing budget as share of company rev	7.8%

Worked ratio

Team dashboard, not the board sheet

What marketing metrics does the board want to see?

Earlier we noted that CMOs place the chief financial officer (CFO) and the chief executive officer (CEO) among the executives most skeptical of marketing's value. Those two people read the scorecard first. They think in revenue, margin and cash, so the business outcomes and efficiency rows lead and the activity rows sit lower on the page.

A worked example

How a scorecard differs from a dashboard, and why 12 numbers is enough

What every row on the scorecard needs

Why a short list beats activity metrics

Length matters as much as choice. We think 12 rows is about what a CMO can read aloud and defend in one board slot.

Here is a worked example, not a benchmark. A scorecard with 12 numbers and 3 flagged At Risk or Off Track leaves 9 on track. The review then spends its time on 3 rows, each with a named owner and one next step, instead of scrolling through every metric.

Hold the list steady

How to define marketing-sourced pipeline so finance accepts it

Finance rejects pipeline numbers when the rules behind them are vague or change from quarter to quarter. The fix is a one-page written definition, agreed with the chief financial officer (CFO) and the head of sales before the scorecard goes live, then held steady. Our method covers four rules. For the term itself, see our glossary entry.

The four rules to write down

1. First-touch rule. An opportunity is marketing-sourced only if its first recorded touch was a marketing response, such as a form fill, event registration or content download, and that touch came before any logged sales outreach to the same contact or account.
2. Stage at which value counts. Count value only once the opportunity reaches a named stage in the customer relationship management (CRM) system, the one where sales has confirmed a buyer and a need. Earlier stages appear as volume, never as dollars.
3. Time window. The marketing touch must fall within a fixed lookback window before opportunity creation. Pick one length, write it down and leave it alone for the year. In the example below we use 12 months, as an example, not a benchmark.
4. Sales-created exclusion. If a rep's logged outreach came before the first marketing response, the opportunity is sales-sourced, whatever marketing did later. Later marketing touches can still make it marketing-influenced.

Worked example: one opportunity, each rule

The inputs are round example numbers. A rep sent an outbound email to an account. Three weeks later a contact there registered for a webinar. Four months after the webinar, the rep created an opportunity, which then reached the counting stage.

Change one fact and the answer changes. Had the webinar registration come before the rep's email, the same opportunity would be marketing-sourced.

Put the definition in the scorecard's notes column, date it and have the CFO sign it. When a dispute comes up, the written rule settles it, not the meeting. For how to run that agreement, see our guide to CMO, CEO and CFO alignment.

How to fill each part: data sources, owners and update cadence

Each row in the template has four working columns after its definition and formula: where the number comes from, who owns it, how often it refreshes and its target. Fill them in that order. A row with no source system cannot have a real owner, and a row with no owner will not stay current.

Source, owner and cadence by row type

Set cadence by how fast the number can move

Pipeline changes every week. Brand measures move in waves. Lifetime value barely shifts inside a quarter. Refreshing a slow number monthly produces noise that someone will try to explain.

Test each row with MMAP before it stays

Use that chain as a gate. For every row, write three words in a hidden column: the activity, the intermediate outcome and the cash driver. Paid search spend leads to qualified pipeline, which leads to new revenue. If you cannot name the cash driver, the row is an activity metric and comes off the board version.

A worked example: one quarter for a $300M B2B company

Here is the template filled in for one illustrative quarter. The inputs are round example numbers chosen to make the arithmetic easy to follow. They are not benchmarks, and no row should be read as a target.

Spend group commentary

Pipeline group commentary

Marketing sourced $12M of pipeline on $4M of media, which is 3 dollars of pipeline per media dollar. Of that $12M, $3M closed, a 25% conversion of sourced pipeline to revenue this quarter. The commentary line for the board should say whether that $3M closed from pipeline created this quarter or carried over from earlier ones.

What the commentary should flag

We think a 75% acquisition share paired with strong pipeline per dollar is the pattern a board will praise this quarter and question in two years. We would write one line under the spend group naming the retention spend and the customer metric it is meant to move. That turns the split into a decision the CEO can see, rather than a ratio.

For more on how companies divide spend between stages, see brand versus performance budget split and our digest of the Gartner 2026 CMO spend findings.

The traps that make a scorecard dishonest, and the first five steps

Four traps cause most of the damage.

The financial-link test

As an example, not a benchmark: if 4 of your 12 draft rows fail the test, 8 survive, and you rebuild the missing ones from the template before the meeting.

Five steps before the next board meeting

Then walk the CFO through the draft a week early. Disputes settled in that walkthrough stay out of the boardroom. If you are new in the seat, the first 90 days playbook covers the timing.

What this page does not cover

This page does not set targets for any row, and the worked numbers are examples, not benchmarks. It does not evaluate or compare brand trackers, search volume tools or other providers. It is not financial or legal advice.

Related on CMO Tribune: Marketing board deck template: eight slides and the numbers a board expects; Annual Marketing Plan Template: The Four-Page Plan a CEO and CFO Will Read; Marketing agency RFP template: sections, pricing table and scoring weights that make answers comparable.