DEV Community

Viral Videos
Viral Videos

Posted on

How to Track Cost Per Lead in Google Sheets (Free Template)

If you're a SaaS founder running ads, you probably track Cost Per Lead (CPL) in a messy spreadsheet or worse — in your head. Here's a dead-simple Google Sheets template that does the math for you.

Why CPL matters
CPL tells you which channels are working. If Facebook gives you leads at $8 each and LinkedIn costs $25, you know where to focus. But manually tracking this across weeks is tedious.

The template
I built a Google Sheets tracker with:

  • 5-channel breakdown (Facebook, Google, LinkedIn, Email, Organic)
  • Auto-calculated CPL per channel
  • Conditional formatting (green/yellow/red)
  • Monthly trend view
  • Pre-filled sample data

It takes 2 minutes to set up. Just paste your ad spend and leads.

Grab the template here: microtoolsb2b.gumroad.com/l/cost-per-lead-tracker

No signup wall — just a direct download.

Pro tip: Track CPL weekly, not monthly. The sooner you spot a channel going red, the sooner you can reallocate budget.

Top comments (0)