Marketing analytics dashboard numbers every board asks for
8 min read
The three numbers a board asks about on any marketing analytics dashboard are customer acquisition cost (CAC), customer lifetime value (LTV) and CAC payback, each broken down by channel. CAC tells them what a new customer costs, LTV tells them what that customer is worth in gross margin, and payback tells them how many months of margin it takes to earn the acquisition cost back. Blended averages hide the answer, so the useful version shows all three per channel, side by side, with enough data behind each row to trust it.
This article gives the formulas, the traps that make the numbers lie, and a worked example of a channel table built from stated assumptions. Use it to build your own board slide or to check the one you already have.
Why boards ask for these three numbers
A board does not want to manage your campaigns. It wants to know whether marketing spend is an investment that pays back or a cost that keeps growing. CAC, LTV and payback answer that question in the language of finance, which is why they appear in almost every growth company's board pack.
- CAC says how efficiently money turns into customers.
- LTV says how much those customers are worth after the cost of serving them.
- Payback says how long cash is tied up before it comes back, which matters for runway and for how fast you can reinvest.
Together they also make the budget conversation concrete. A channel with fast payback and a healthy LTV to CAC ratio earns more money. A channel with slow payback and thin data earns a test budget, not a bigger line. That is the core of good marketing budget planning.
The formulas, written plainly
Customer acquisition cost
CAC equals the marketing cost of a channel in a period divided by the number of new customers that channel produced in the same period. Decide up front what goes into cost. Media spend alone gives you paid CAC. Media plus tools, content production and the share of marketing salaries gives you fully loaded marketing CAC. Add sales cost and you have fully loaded CAC, which is the figure finance usually prefers. Pick one definition, label it on the slide, and never switch quietly between quarters.
Customer lifetime value
The simple version for subscription businesses is LTV equals average monthly revenue per account multiplied by gross margin, divided by monthly churn rate. For ecommerce, use average order value multiplied by orders per customer over the period you count, multiplied by gross margin. Many boards prefer LTV capped at three years so that a very low churn rate does not produce a number nobody believes.
CAC payback
Payback in months equals CAC divided by monthly gross margin per customer, which is monthly revenue per account multiplied by gross margin. A company that raises money cares about this number most, because it shows how long each new customer consumes cash.
LTV to CAC ratio
Divide LTV by CAC. A ratio around 3 is the common rule of thumb for a healthy business; well below that means you pay too much for customers, and far above it can mean you are underinvesting in a channel that could take more money.
| Metric | Formula | What a board reads from it |
|---|---|---|
| CAC | Channel cost in period / new customers from channel in period | Cost to win one customer |
| LTV (subscription) | Monthly revenue per account x gross margin / monthly churn | Gross margin a customer brings over their life |
| LTV (ecommerce) | AOV x orders per customer x gross margin | Gross margin a customer brings over the counted period |
| Payback | CAC / (monthly revenue per account x gross margin) | Months until the customer has paid back their cost |
| LTV to CAC | LTV / CAC | Return on each acquisition dollar |
A worked example by channel
The numbers below are illustrative. They use the default starting assumptions for a B2B SaaS company in VirtualCmo plus a few extra assumptions stated here, so you can follow every step and redo it with your own data.
Assumptions. First-year deal value 24,000 USD, so monthly revenue per account is 2,000 USD. Gross margin 80 percent, so each customer brings 1,600 USD of monthly gross margin. Monthly marketing budget 60,000 USD, or 180,000 USD per quarter, split Google Ads 26 percent, LinkedIn Ads 18, SEO and Content together 26, Meta Ads 8, Retargeting 8, Partnerships 8, Email 6. CAC here is marketing CAC, without sales cost. New customers per channel and monthly churn per channel are assumed for the example. A rule of thumb from the same defaults says a healthy program cost per new customer is about 25 percent of first-year deal value, which is 6,000 USD.
| Channel | Quarter spend (USD) | New customers | CAC (USD) | Payback (months) | Monthly churn | LTV (USD) | LTV to CAC |
|---|---|---|---|---|---|---|---|
| Google Ads | 46,800 | 5 | 9,360 | 5.9 | 2.0% | 80,000 | 8.5 |
| LinkedIn Ads | 32,400 | 2 | 16,200 | 10.1 | 1.5% | 106,667 | 6.6 |
| SEO and Content | 46,800 | 4 | 11,700 | 7.3 | 2.0% | 80,000 | 6.8 |
| Meta Ads | 14,400 | 1 | 14,400 | 9.0 | 4.0% | 40,000 | 2.8 |
| Retargeting | 14,400 | 2 | 7,200 | 4.5 | 2.5% | 64,000 | 8.9 |
| Partnerships | 14,400 | 2 | 7,200 | 4.5 | 1.25% | 128,000 | 17.8 |
| 10,800 | 1 | 10,800 | 6.75 | 2.5% | 64,000 | 5.9 | |
| Blended | 180,000 | 17 | 10,588 | 6.6 |
How the cells were calculated, using Google Ads as the example: 46,800 USD divided by 5 customers is a CAC of 9,360 USD. Divided by 1,600 USD of monthly gross margin gives 5.9 months of payback. LTV is 1,600 divided by 0.02, which is 80,000 USD. LTV to CAC is 80,000 divided by 9,360, which rounds to 8.5.
What the table tells a board
The blended row says marketing pays back in about six and a half months. That sounds fine and tells you almost nothing about where to put the next dollar. The channel rows do.
- Retargeting and Partnerships are the only channels at or near the 6,000 USD healthy CAC mark. Both are worth testing at a higher budget to see whether efficiency holds as spend grows.
- LinkedIn Ads has the slowest payback at about ten months but low churn, so its customers are worth a lot. That is a channel to keep and optimize, not cut.
- Meta Ads has the weakest LTV to CAC at 2.8, driven by high churn among the customers it brings. It also rests on a single customer, which means the true figure could be far better or far worse.
- Email mostly converts people other channels found, so its CAC should be read alongside attribution, not alone.
Traps that make the numbers lie
Tiny samples
One customer in a quarter is an anecdote, not a CAC. In the example, Meta's 14,400 USD CAC could swing to 7,200 with one more deal. Show sample size on the slide and treat channels with fewer than five new customers per period as directional. Using a rolling two-quarter window helps.
Mixed definitions
If one row uses media-only CAC and another includes content production, the comparison is meaningless. SEO and content look expensive when production cost is counted and nearly free when it is not. Use the same cost basis for every channel.
Time lag
With a 60-day sales cycle, spend in March produces customers in May. Dividing March spend by March customers punishes channels that are ramping up and flatters ones being cut. Match cost to the cohort it produced, or use a period long enough that the lag washes out.
Attribution double counting
If every channel claims the same customer, the channel customer counts add up to more than the real total and every CAC looks better than it is. Make sure the channel counts add up to the blended count, as they do in the table above.
LTV from optimism
A 1 percent monthly churn implies an average customer life of more than eight years. Few boards believe that for a young company. Cap LTV at 36 months, or show both capped and uncapped figures.
What to put on the board slide
Keep it to one page. The board needs a judgment, not a data dump.
- The blended CAC, payback and LTV to CAC this quarter, compared with last quarter and with target.
- The channel table, with sample size, sorted by payback.
- Three decisions taken last quarter on the back of these numbers, and their outcome so far.
- Three decisions needed, each with the expected change in CAC or payback.
A good marketing analytics dashboard produces this page without anyone building it by hand. VirtualCmo calculates CAC, LTV, LTV to CAC, ROAS and payback by channel and by cohort from read-only connections to your ad platforms, analytics and CRM, and the Scale plan exports a board-ready quarterly review as PDF or PPTX. You can see the data flow in how an AI CMO works.
From metrics to budget moves
The numbers matter only if they change where money goes. A practical rule set: move budget toward channels with payback under target and enough sample to trust, hold channels with long payback but strong LTV, and put channels with weak LTV to CAC on a short test with a clear exit rule. If a channel stays outside its band for two weeks running, it is time to act. We cover the exact steps for that in when to cut a paid channel.
This is the work an AI CMO does every week. It scores each channel against the revenue target, recommends shifts with the expected impact on CAC and payback, and logs every approval and outcome so the next board meeting starts from facts. For teams comparing that with a human leader, the fractional CMO alternative page lays out what each option costs and where a person still adds more. Plan details are on the pricing page.
Common questions
Should CAC include sales cost?
For the board, yes, fully loaded CAC including sales is the honest figure. For comparing marketing channels against each other, marketing CAC without sales cost is fine, as long as the slide says which one it is.
What is a good CAC payback period?
It depends on deal size and how much cash you have. Many B2B SaaS companies aim for 12 months or less, and smaller-ticket products often aim for well under six. The trend matters as much as the level.
How do I calculate LTV with only a year of data?
Use observed monthly churn from the cohorts you have and cap the result at 36 months. Revisit it every quarter as cohorts age; early churn is often higher than later churn.
Why does the blended CAC look fine when some channels are bad?
Averages hide spread. A cheap channel and an expensive one can blend to a reasonable number. That is why the board view needs the per-channel table, with sample sizes.
How often should these numbers be updated?
Weekly for the team running budgets, quarterly for the board. Weekly figures catch drift early; quarterly figures smooth out noise for strategic decisions.
CAC, LTV and payback by channel are the shortest path from marketing activity to a board-level answer. Define them once, show sample sizes, watch for lag and double counting, and let the channel table, not the blended average, decide where next quarter's budget goes.
