📊 The Simple KPI Template: 5 Numbers That Tell You If Your Ads Work

KPI stands for Key Performance Indicator. That's a mouthful. Here's what it really means: a number that tells you if your marketing is working.

Think about a lemonade stand. You could track a hundred things: how hot it was, how many cars drove by, how many people smiled. But the numbers that actually matter are simple. How many cups did I sell? How much did the lemons cost? How much money is in the jar at the end of the day? Those are your KPIs.

Your business is the same. There are a million numbers you could watch. There are about five you should watch. This template is built around those five.

Why Bother?

Because you can't improve what you don't measure. If your ads "feel slow" this month, what do you fix? The ad? The offer? The follow-up? The sales call? Without numbers, you're guessing. With numbers, you can point at the exact step that's broken and fix only that.

Pick Your 5 Numbers

For almost every local business that runs ads and books appointments, the funnel looks like this. A funnel is just the path from stranger to paying customer, and it gets narrower at each step.

1. Budget: how much you spent on ads
2. Leads: how many people gave you their name and phone number
3. Appointments: how many of those leads booked a time to come in or talk
4. Shows: how many actually showed up
5. Clients: how many paid you

That's it. Five rows. Whether you run a gym, a dental office, a chiropractic clinic, a martial arts school, or a roofing company, these five tell the whole story.

Set Your Monthly Goals

Now decide what you want each of those five numbers to be this month. Start from the bottom (clients) and work up. Here's the real example we use with clients:

Monthly Goals Example

• 40 clients
• 100 shows
• 200 appointments
• 600 leads
• $5,000 ad budget

Notice how each step is about double or triple the one below it. That's normal. Not every lead books. Not every booking shows. Not every show buys. In this example, about 1 in 3 leads books, about half of the bookings show up, and about 40 percent of the shows become clients.

Break Monthly Goals Into Weekly Goals

A month is too long to wait. If you only check your numbers on the 30th, you've already lost the month. So divide everything by four.

Weekly Goals (from the example above)

• 10 clients per week
• 25 shows per week
• 50 appointments per week
• 150 leads per week
• $1,250 ad spend per week

Now every Friday you can look at the sheet and ask: "Did we hit 150 leads? Did we hit 50 appointments?" If the answer is no in week one, you have three weeks left to fix it. That's the whole point.

Work Out What Each Step Can Cost (Your CPA Goals)

CPA stands for Cost Per Acquisition. Plain words: how much you pay to get one of something. One lead, one appointment, one show, one client. This is where the template gets powerful, because now you know exactly when you're overpaying.

The Math (It's Just Division)

Take your budget and divide it by your goal for each row:

• $5,000 ÷ 600 leads = $8.33 per lead
• $5,000 ÷ 200 appointments = $25 per appointment
• $5,000 ÷ 100 shows = $50 per show
• $5,000 ÷ 40 clients = $125 per client

Your CPA Targets

• $8.30 cost per lead (max)
• $25 cost per appointment
• $50 cost per show
• $125 cost per client

Now when you look at your ad account and see leads costing $14, you don't have to wonder if that's bad. You know. Your target is $8.30. Something needs to change.

Find the Broken Step and Fix Only That

Here's where the template earns its keep. Every week, compare your real numbers to your targets. Whichever step is most over its target is the step to fix. Not the whole campaign. Just that step.

A Real Example

A client of ours had a $25 target per appointment. Their real cost came in at $50 per appointment. Double. Leads were coming in at a good price, so the ads weren't the problem. The problem was between "lead" and "appointment." Not enough leads were booking.

So we did two things:

1. Changed the targeting so the ads reached people a bit more likely to actually want an appointment, not just a free download.
2. Hired appointment setters, people whose only job was to text and call every new lead fast and get them booked. Every lead got a text within 5 minutes, automatically, and a real person followed up the same day.

The cost per appointment dropped from $50 to $22. Under the $25 target. The monthly goal was back on track, and nobody touched the ad creative or the offer, because those weren't broken.

Build the Actual Sheet

Here's exactly what to put in your spreadsheet. One tab per month. Keep it boring and simple.

Columns

Metric, Monthly Goal, Weekly Goal, Week 1, Week 2, Week 3, Week 4, Month Total, Target Cost, Real Cost.

Rows

• Ad Spend
• Leads
• Appointments
• Shows
• Clients (counted on the day they paid)

Formulas

• Month Total = Week 1 + Week 2 + Week 3 + Week 4
• Real Cost = Ad Spend Total ÷ that row's Month Total
• Color the Real Cost cell green if it's under target, red if it's over

That's the whole template. Five rows, a few formulas, and a splash of red and green. Every Friday, fill in the week. Every month, start a new tab.

Use the Numbers to Spend Smarter

Once you've tracked for a couple of months, something great happens. You stop making decisions based on feelings and start making them based on facts. That means:

• Faster decisions. You don't need a meeting to decide whether to pause an ad. The sheet already told you.
• Smarter budget. If Facebook gives you clients at $110 and Google gives you clients at $180, move money to Facebook. If a certain offer gets more shows, run more of it.
• Confidence to scale. When every step is under target, you can raise the budget knowing roughly what you'll get back.

Week 1: Build the sheet

1. Make a spreadsheet with the five rows and the columns from step 6
2. Decide how many clients you need this month and work backward to set each goal
3. Divide each goal by four for your weekly targets

Week 2: Set your targets

1. Divide your budget by each goal to get your target cost per lead, appointment, show, and client
2. Check that your cost per client is well below what a client is worth to you
3. Fill in your first week of real numbers

Week 3: Find the leak

1. Compare real costs to targets. Mark the biggest miss in red
2. Fix only that step (ad, follow-up, reminders, or sales talk)
3. If it's follow-up, set up automatic texting within 5 minutes of every new lead

Week 4: Review and decide

1. Total up the month. Compare every row to its goal
2. Write one line of notes about what changed and when
3. Set next month's goals a little higher on whatever worked