Job 7 of 19 · Outline

Track which lead sources actually sell cars

The problem

Paid lead sites vary a lot in quality. A simple tracker shows the cost per sale from each source.

What AI does

AI builds a simple spreadsheet layout that shows how many leads and sales each source brings and what each sale cost you.

Time

Time: 20 minutes to set up, then 10 minutes a monthTools: Google Sheets, ChatGPT

The steps, in short

  1. Record every lead and where it came from.
  2. Mark which leads became sales.
  3. Have AI set up the tracker.
  4. Look at the numbers before renewing any paid lead source.

A short sample prompt

Design a simple spreadsheet for a car dealer to track leads. Columns for [date], [source], [sold yes/no] and [monthly cost per source]. Add formulas for leads, sales and cost per sale for each source. No customer names.

In the full playbook

  • 4 steps in full
  • The exact prompt to copy
  • A check-before-you-send list (3 points)
  • UK notes with official sources
The full playbook

Unlock the other 16 car dealers jobs

Every job has the full steps, the exact prompt, a check-before-you-send list and optional UK notes. We keep adding new jobs and new niches, and re-checking existing jobs, while you subscribe. Monthly, cancel anytime, instant access, no password.

Just car dealers

£5 a month

Every job in car dealers plus the updates we make to it.

Subscribe · £5/mo

3 niches

£12.99 a month

Starts with car dealers; you pick the other two (or swap later) on your account page.

Subscribe · £12.99/mo

All niches

£19.99 a month

All 81 niches, and every new one we add. Or £149 a year: save £90.88.

Subscribe · £19.99/mo or £149 a year (save £90.88)

Cancel anytime. One click in Stripe's billing page, no emails or phone calls: how to cancel.

Pay securely with Stripe. Prices include any VAT. Digital content: at checkout you ask for instant access and agree you lose the 14-day right to cancel once it starts. Terms · Privacy · Pricing · Already subscribed? Sign in

More jobs for car dealers

See all 19 jobs in the car dealers playbook →