Always-On Marketing KPI Dashboard Template (Free + How to Use It)

Every marketing team I work with has a dashboard. Most of them open it twice in the first month and never again. The reason is consistent. The dashboard has too many metrics and none of them predict anything.

An always-on marketing dashboard does not need 40 charts. It needs eight. Six of them are leading indicators. Two are lagging. The point is to know whether the program is healthy before the lagging numbers tell you.

Here is the framework I use. Free to copy in any BI tool. Looker, Tableau, Power BI, a Google Sheet. The tool matters less than the structure.

The six leading indicators

1. Publishing velocity

Count of content shipped per week against the cadence target. Articles, emails, social posts, videos. One number per channel, trended weekly.

When this drops, every other metric drops 30 to 60 days later. Catching the velocity dip early is the single highest-leverage thing the dashboard does.

2. Audience size by channel

Followers, email subscribers, podcast listeners, retargeting pool size. Trended weekly. Net change matters more than absolute numbers.

An always-on program adds to these pools steadily. A flat or declining curve is a warning sign that one of the channels has gone quiet.

3. Engagement rate by channel

Email click-through rate. Social engagement rate. Article scroll depth. Podcast completion rate. One number per channel.

Engagement is the truth-teller about whether the content is landing. The volume could be steady but if engagement is dropping, the program is losing the audience's attention.

4. Branded search volume

Monthly Google search volume on your brand name and core variations. Pull from Google Search Console. Trended quarterly because monthly numbers bounce too much for B2B.

Always-on programs that are working drive branded search up. It is the single best leading indicator of brand growth. Lagged by about a quarter behind the actual program activity.

5. Marketing-influenced pipeline

For B2B: percentage of pipeline that has at least one marketing touchpoint in the buyer's journey. For ecommerce: percentage of revenue with at least one marketing touchpoint in the customer's discovery path.

Attribution is imperfect. The trend matters more than the absolute number. The right number for most B2B SaaS is 50 to 70%. If yours is 90%, your attribution is generous. If it is 20%, your attribution is undercounting.

6. New customer rate

Percentage of new customers in the last 30 days who had no prior touch with the brand. The signal you want is that the always-on program is bringing in genuinely new audiences, not just nurturing the existing pool.

For B2B SaaS, healthy new customer rate is 60 to 80%. For ecommerce, often higher. When this number drops, the acquisition machinery is stalling even if revenue is still flat.

The two lagging indicators

7. CAC, trended monthly

Cost of acquisition by channel and blended. Trended monthly. Healthy always-on programs see CAC drop by 15 to 30% over the first 12 months as the channels compound.

CAC is the number the CFO cares about. It is also the number that takes the longest to move. Report it last in the dashboard layout so people read the leading indicators first.

8. Marketing-sourced revenue

Revenue from customers acquired through marketing channels. Trended monthly. This is the lagging indicator that gets always-on programs renewed.

The trend matters more than the absolute number. A flat number with the leading indicators dropping is the early warning system. A flat number with the leading indicators climbing is fine, the revenue is coming.

What to leave out

Open rate. Apple Mail Privacy Protection has made it noise. Click rate is the email engagement metric.

Impressions on social. They tell you almost nothing useful for decision-making.

Cost per lead. CAC at the customer level is what matters. Cost per lead optimizes for the wrong thing and incentivizes channels to send low-quality leads.

Bounce rate. Modern bounce rate measurement is broken and the metric is rarely actionable.

How to build it in two hours

Pick a tool. Looker Studio (free) is fine if you do not have a BI platform. Connect the data sources: ad platforms, CRM, web analytics, email tool, social analytics.

Build one tile per metric. Eight tiles total. Use a simple template. Big number, sparkline of the trailing 13 weeks, and a small annotation showing the trend direction.

Group the leading six at the top in two rows. The lagging two at the bottom. Headers separating the sections. That is the entire layout.

Do not add more than these eight metrics. Once a quarter, review whether any of them should be swapped. Most quarters the answer is no.

Operating rhythm

Weekly: the team reviews the four highest-frequency leading indicators. Publishing velocity, audience size, engagement, new customer rate.

Monthly: full dashboard review including CAC and marketing-sourced revenue.

Quarterly: dashboard audit. Are these still the right metrics? Are the targets still right? Pair this with the marketing audit framework for the program-level review.

Common dashboard mistakes

Adding metrics for every channel team to have their own tile. Use channel-level dashboards for channel teams. The program dashboard is for the leadership view.

Using year-over-year comparisons too early. Most always-on programs have not been running long enough for YoY to be meaningful. Use trailing 13 weeks instead. The comparison is more honest.

Mixing leading and lagging indicators on the same chart. Confuses everyone. Leading indicators predict. Lagging indicators report. Different jobs.

Frequently asked questions

What tool should I build this in?

Looker Studio if free is the constraint. Tableau or Power BI if you have one already. A Google Sheet works for small teams. The structure matters more than the tool.

Should every team see the same dashboard?

Yes for the program dashboard. Each channel team can have their own dashboard underneath, but the program leadership view should be one shared view. Different views drive different decisions and the conversations get harder.

How does this fit with the always-on budget framework?

The dashboard reports on the budget allocation. The budget framework decides how to spend. Review them together at the quarterly audit. If a channel is overspending without leading indicators improving, the budget moves.

Which two metrics on this list are not in your dashboard today? That is usually where the next 90 days of improvement come from.