Managing a $10M Budget: What I'd Do Differently at $100K
Build your marketing KPI dashboard template the day you spend your first dollar on marketing, small business or not. Not after you hit $50K in spend. Not when a board member asks for a report. Day one.
The short answer
Week one, before the first ad goes live. I know that sounds aggressive. But I've managed $10M on a federal infrastructure project and I've scaled a DTC brand from $100K to $3M in revenue. The dashboard looked different at each size, but the habit of tracking from day one was the same. At $100K, I didn't have a dashboard for the first four months. I was "too busy" running the business. I lost track of which channel was actually driving sales until I sat down and reverse-engineered three months of spend. That cost me real money. I'd never make that mistake again.
What changes the timing
A few things push the "when" earlier or later, depending on your situation.
- Number of channels. If you're only running Google Ads, you can survive a few weeks on gut feel. The moment you add a second channel, email, or an agency, you need a dashboard immediately. Attribution gets murky fast.
- Who's spending the money. Solo founder spending your own cash, you can delay slightly because the pain is personal and immediate. The second you have a partner, investor, or employee spending budget, build the dashboard before they touch the ad account.
- Revenue per customer. On the $2.2B infrastructure project, our "customers" were public stakeholders and the KPIs were awareness and sentiment, not sales. Low dollar value per conversion means you need volume data fast to catch problems early. High dollar value means one bad month can be masked by one big win, so you need the dashboard to catch the underlying trend, not just the headline number.
- Seasonality. If your business has a Q4 spike or a back-to-school bump, build the dashboard before that season, not during it. I've seen founders try to build tracking infrastructure in the middle of their biggest month. It never works. You're too busy fighting fires to also build the fire alarm.
Signs you are overdue
- You can't answer "what's my cost per acquisition by channel" without opening five tabs and doing math on a notepad.
- You've increased spend on a channel because it "felt like it was working," with no number behind the feeling.
- Your marketing report to yourself or your team is just screenshots of platform dashboards (Meta Ads Manager, Google Ads) pasted into a Slack message.
- Nobody on your team can tell you last month's blended CAC within 10% accuracy.
- You've had a conversation that started with "wait, how much did we actually spend on that campaign?"
If two or more of these are true right now, you're overdue. Build the dashboard this week, not next quarter.
What happens if you wait too long
On the DTC brand, we went nearly five months without a unified view. We were running Meta, Google, and an affiliate program at the same time. When I finally built the dashboard, pulling blended CAC, channel-level ROAS, and LTV into one sheet, we found the affiliate program was costing us $38 per order against a $31 average margin. We'd been bleeding money on it for three months because the top-line revenue number looked fine. Nobody was looking at the per-channel math.
That's the real cost of waiting. It's not that you don't have data. It's that you have data scattered across five platforms and no single source of truth, so you make decisions on vibes. At small dollar amounts, that costs you thousands. At $10M, it costs you millions, and it costs you your job. The math doesn't change with scale. Only the zeros do.
The most common mistake
The most common mistake I see small business owners make isn't skipping the dashboard. It's overbuilding it. They try to track 40 metrics in a fancy tool with live API connections before they've proven they even need 10. A simple marketing KPI dashboard template for a small business needs about seven numbers:
- Spend by channel
- Leads or orders by channel
- Cost per lead or cost per acquisition
- Conversion rate (lead to customer)
- Average order value or deal size
- Blended CAC
- Return on ad spend (ROAS) by channel
Put it in a Google Sheet. Update it weekly, by hand if you have to. You don't need Tableau at $100K in revenue. You need discipline and seven numbers you check every Monday morning.
Takeaway: don't wait for permission, for scale, or for a "real" tool. Open a spreadsheet today, list those seven metrics, and fill in last week's numbers before you spend another dollar on ads. The dashboard doesn't need to be sophisticated. It needs to exist.