Skip to the content.

Free Google Sheets Lead Tracker

For owners who spend money on ads, directories and mailers and want to know which source actually brings paid jobs.

Open the template · Make a copy · Google Sheet, free, no sign-up

What is inside

Tab What it holds
Dashboard Totals and views built from Leads and Marketing Spend, no typing needed.
Leads Columns Lead ID, Date received, Name, Phone, Email, City or ZIP, Service requested, Source, Campaign or detail and 7 more.
Marketing Spend Columns Spend ID, Month, Source, Amount spent and Notes.
Reports Totals and views built from Leads and Marketing Spend, no typing needed.
Settings Your own dropdown lists (source, service, owner, stage and lost reason), so the choices match how you work.

How to fill it in

  1. Log each lead with the date, service, source and campaign.
  2. Add the quote amount when you price it, and the won amount and date when it books.
  3. Enter what you spent per source each month on Marketing Spend.
  4. Read Reports for cost per lead, conversion and return on spend by source.

A tip from the field

Use the same source names every time, the list sits on Settings. Otherwise Google Ads and google ads count as two sources.

Starter files

Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.

When you outgrow it

Smarfle’s marketing dashboard counts calls, leads and Google results by source in one place. See how it works on smarfle.com.

All free templates