All payments made in the preview are in test mode. Read more
All guides

// free tool

ROI Calculator for Leads

Running social ads to fill your pipeline and paying an agency to do it? See what a lead, a booking, and a customer actually cost you.

5 min readPaid AdsSpreadsheet
// share
// on this page

// what's inside

A plug-and-play spreadsheet that connects your monthly ad spend and agency retainer to every stage of your funnel — so you can see your true cost per lead, per booked appointment, and per customer.

  • True cost per lead, booking, and customer
  • Revenue, net return, ROI, and ROAS in one view
  • Break-even line: how many sales you need each month

// what you get

  • The full ROI calculator spreadsheet (Google Sheets + Excel)
  • Inputs for ad spend, retainer, leads, booking rate, show rate, close rate, and average sale
  • Live outputs for cost per lead, per booking, per customer, ROI, and ROAS
  • A break-even view so you know the minimum sales that make the month work

// who it's for

  • Businesses running Meta ads with an agency retainer on top
  • Owners who know their spend but not their true cost per customer
  • Anyone deciding whether to scale spend, fix the funnel, or raise price

// preview

Start reading

Do you actually know what a customer costs you?

Most businesses track what they spend on ads and what they pay their agency. Very few can tell you what those two line items actually return.

If you're running Meta ads to generate leads, you probably know your monthly ad spend down to the dollar, and your retainer to the cent. What's murkier is the part that matters: what it actually costs to turn those two expenses into a paying customer — and whether the whole machine is making money.

The problem with judging ads on impressions

Impressions don't pay the bills, and neither do leads that never book, never show, or never close. The only number that matters is what a customer costs you all-in, and what they're worth in return.

To see that clearly you have to connect your total monthly investment — media plus retainer — to each stage of your funnel: leads, booked appointments, shows, and closed sales.

What the calculator shows you

Plug in your spend, retainer, and a few funnel numbers and it instantly returns:

  • Your true cost per lead, per booked appointment, and per customer
  • Your revenue, net return, ROI, and ROAS
  • Your break-even line — how many sales you need each month just to cover the investment

Why it's worth two minutes

The most useful part isn't the answer it gives you today — it's what it reveals about which lever moves your return the most. For some businesses the fastest path to profit is a stronger close rate. For others it's raising the average sale, or simply spending more where the numbers already work.

Run your numbers. If they raise questions — and they usually do — that's exactly the conversation worth having.

// free tool

Email me the ROI Calculator for Leads

Drop your email and we'll open the spreadsheet for you — and send the link to your inbox.

By downloading you agree to receive occasional emails from Figs Marketing.

// faq

Is the calculator really free?+

Yes. Drop your email and we'll send the spreadsheet link — no payment, no call required.

What numbers do I need before I start?+

Monthly ad spend, your agency retainer, leads per month, booking rate, show rate, close rate, and average sale value. Estimates are fine for a first pass.

Does it work if I run ads in-house?+

Yes — just set the retainer field to your internal cost (or zero) and everything else still works.

// more guidebooks