A Marketing KPI Dashboard for Brands Under $5M
Build your dashboard now, not after you hire a marketing person. If you are under $5M in revenue, you need a marketing KPI dashboard template small business owners can actually run themselves, on a Friday afternoon, in under 20 minutes. That is the whole test. If it takes longer, it is wrong for your stage.
The short answer
Weekly, five numbers, one spreadsheet. Not a BI tool, not a 40-tile dashboard, not something an agency built to justify its retainer. When I scaled a DTC brand from $100K to $3M+, we ran the whole thing off one Google Sheet: revenue, spend, CAC, return on ad spend, and email list growth. Checked every Monday morning. That was it for two years. The reason weekly wins at this size is speed of feedback. At under $5M you make decisions in days, not quarters. A monthly dashboard means you find out you overspent 30 days after it happened. Weekly means three or four days after.
What changes the timing
- Ad spend as a percent of revenue. If you are spending under 10% of revenue on paid channels, monthly is fine. Above 20%, you need weekly, because a bad week compounds fast.
- Number of active channels. One or two channels, weekly is enough. Five or more channels (paid social, search, email, affiliate, retail), you need a daily glance at spend even if the full review stays weekly.
- Cash position. If you have less than 60 days of runway, check CAC and payback period weekly no matter what else is going on. Tight cash punishes slow feedback loops harder than anything else.
- Seasonality of the business. A brand that does 40% of revenue in Q4 needs daily dashboard checks from October through December and can drop to biweekly the rest of the year.
Signs you are overdue
- You can't answer "what was our CAC last month" in under 10 seconds.
- Marketing spend numbers live in three different places: the ad platform, the bank statement, and someone's memory.
- You find out a campaign underperformed only when the bank balance looks wrong.
- Nobody on the team can tell you current LTV:CAC ratio without opening five tabs.
- Your last "marketing review" was actually just looking at Shopify total sales.
What happens if you wait too long
On the $2.2B infrastructure project I ran marketing for, we had a $10M budget and a reporting cadence that started too slow, monthly, because that's how the client's finance team operated. It took us six weeks to catch that one vendor's cost-per-lead had tripled. By the time we caught it, we'd burned about $180,000 on a channel that should have been cut in week two. That is the cost of waiting: not embarrassment, actual dollars gone before anyone looks at the number.
For a small business, the math is smaller but the pain is the same shape. A $2M revenue brand spending $15,000 a month on Meta ads that quietly slides from a 3:1 return to a 1.5:1 return over six weeks, unnoticed, has burned $9,000 to $12,000 in wasted spend before the owner even opens the ad account. That is real payroll. That is real inventory. Waiting too long on the dashboard doesn't just cost insight, it costs cash you already spent and can't get back.
The most common mistake
Building a dashboard with too many metrics too early. I have seen founders load up a Looker Studio dashboard with 30 tiles: impressions, CTR, bounce rate, session duration, scroll depth, on and on. Nobody looks at it after week three. It becomes furniture.
The fix is brutal simplicity. Your marketing KPI dashboard template for a small business should have five numbers, maybe seven if you run both paid and organic heavily:
- Revenue (weekly, compared to same week last year)
- Total marketing spend
- Blended CAC (spend divided by new customers, all channels combined)
- Return on ad spend by channel
- Email or SMS list growth rate
That's it. Everything else is a drill-down you check when one of these five numbers looks wrong, not something you track every week for its own sake.
Formula worth pinning to the top of the sheet: LTV:CAC ratio. Take average order value times average number of repeat purchases per year times average customer lifespan in years, that's your LTV. Divide by CAC. Under 3:1, you are spending too much to acquire customers relative to what they're worth. Above 5:1, you're probably underspending on growth and leaving money on the table.
Practical takeaway: open a blank spreadsheet today. Five columns, five numbers, one row per week. Review it every Monday for 15 minutes with whoever touches marketing spend. Do that for 90 days before you buy any dashboard software. Most brands under $5M never need the software. They need the discipline of looking at the same five numbers on the same day every week.