Skip to content

Simple CRM: Track Leads from Ads to Sales in 1 Day

Why track ad leads to sales

Spending on ads without tracking is like fishing blindfolded. You need to know which ads, landing pages, or keywords actually bring customers so you can spend smarter. This guide shows a low-effort CRM setup you can use today to see which ads turn into paid customers.

Quick overview of the system

Goal: Capture lead info from an ad, label where it came from, follow with a simple sales pipeline, and record the final outcome (sale, no sale, no answer).

  1. Choose a simple CRM tool (sheet or free CRM).
  2. Tag each lead with the ad source (UTM or source tag).
  3. Move leads through 3 pipeline stages: Contacted, Qualified, Closed.
  4. Record outcome and revenue.

Pick a tool (decision rule)

Pick one option based on staff comfort and volume:

  • If you get fewer than 20 leads per week and prefer simple: Google Sheets. (Decision: leads/week <= 20 → Sheets)
  • If you want some automation and visual pipeline: Airtable or HubSpot free. (Decision: want automations or team → Airtable/HubSpot)
  • If you have many leads or sales reps: a paid CRM (Pipedrive, Zoho). (Decision: leads/week > 100 or multiple reps → paid CRM)

Minimum fields every lead needs

Create columns or fields for these. Keep them required.

  • Lead ID (short unique code, e.g., L-2025-001)
  • Date/time
  • Name
  • Contact (phone/email)
  • Source (ad name or UTM source)
  • Landing page or form name
  • Product/Service interest
  • Pipeline stage (New, Contacted, Qualified, Closed-Won, Closed-Lost)
  • Outcome date
  • Revenue (if won)
  • Notes (short)

How to tag where a lead came from

Use a simple UTM or a hidden form field on your landing page. Examples:

  • UTM example: ?utm_source=facebook&utm_campaign=may_sale&utm_medium=cpc
  • Hidden field: <input type="hidden" name="ad_source" value="FB_MaySale_CPC">

Make a rule: if source contains “facebook” tag as Facebook. If contains “google” tag as Google Ads.

Phone calls and walk-ins

Phone calls: use a tracking number per campaign or note the ad code when intake happens. Quick rule: if caller mentions an ad, write that ad code in the Source field.

Walk-ins: ask how they heard about you and enter that in Source. Always capture a contact method to follow up.

Sample lead row (example)

Lead ID: L-2025-042 • Date: 2025-05-12 • Name: Maria Lopez • Phone: 555-1234 • Source: FB_MaySale_CPC • Landing page: landing-may • Product: HVAC Tune-up • Stage: Contacted • Outcome date: • Revenue: • Notes: Left voicemail 5/12

Simple automations worth setting

Automations save time. Start with just two:

  • New lead → send automatic thank-you email (or text) right away.
  • Lead in Contacted stage with no activity for 3 days → create a task to follow up.

Tool-specific quick tips:

  • Sheets: use Zapier or Make to push form submissions to the sheet and send emails.
  • Airtable/HubSpot: use built-in automations for emails and task creation.

Pipeline rules (keep it simple)

Use only these stages and strict move rules so data stays clean:

  • New: just arrived. Action required within 24 hours.
  • Contacted: spoke with lead or left a meaningful message. If no reply after 3 tries in 7 days, mark as Closed-Lost.
  • Qualified: lead has budget and timing and is likely to buy. Schedule estimate/appointment.
  • Closed-Won: sale completed and revenue recorded.
  • Closed-Lost: no sale. Add reason: No budget / No response / Chose competitor / Other.

Follow-up cadence (simple decision rules)

Use this minimal set:

  • New → Contact within 24 hours.
  • After first contact: follow up 2 more times over 7 days. If no answer → Closed-Lost.
  • Qualified leads: follow up every 2–3 days until appointment or sale.

Weekly and monthly checklists

Weekly (10–20 minutes):

  • Review new leads — any older than 24 hours without contact?
  • Check Contacted leads — next steps scheduled?
  • Record any Closed-Won revenue.

Monthly (30 minutes):

  • Sum revenue by source (Facebook, Google, etc.).
  • Calculate cost per lead and cost per sale for each ad campaign.
  • Turn off campaigns with cost per sale much higher than target.

Simple templates

Email to send automatically when lead submits form:

Subject: Thanks — we received your request
Body: Hi {FirstName}, thanks for contacting us. We’ll call you within one business day. Reply if you prefer a specific time.

Phone call script (30 seconds):

  1. Introduce: “Hi, this is {YourName} from {Business}. You reached out about {Service}.”
  2. Confirm need: “Is this still a good time to talk?”
  3. Next step: “Great — can we schedule an estimate/appointment?”

Simple reporting you can run in 10 minutes

Monthly report steps:

  1. Filter Closed-Won in the month and sum Revenue by Source.
  2. Count leads by Source and calculate Conversion Rate = Closed-Won / Total Leads.
  3. Cost per Sale = (Ad Spend for Source) / Closed-Won.

Decision rules from report:

  • If Conversion Rate < 2% and Cost per Sale > 3× average revenue → pause campaign.
  • If Conversion Rate > 5% and Cost per Sale < 1× average revenue → increase budget.

Common mistakes to avoid

  • Not recording the source (makes ROI impossible).
  • Using too many pipeline stages (keeps team confused).
  • Not following up within 24 hours (leads go cold fast).

One-day setup checklist

  1. Choose tool (Sheets, Airtable, or free CRM).
  2. Create fields listed in “Minimum fields.”
  3. Add UTM or hidden form field to landing pages.
  4. Set basic automations: welcome message and 3-day no-response task.
  5. Create weekly and monthly report templates (one sheet or view).
  6. Train anyone who handles leads on the 24-hour and 7-day rules.

Next steps

Pick your tool and set up the minimum fields today. Start small, keep rules strict, and run the monthly report after 30 days to see what ads actually bring customers.