Free template
A lead tracker that forces the next step.
A free CSV template for Excel, Google Sheets or Numbers — with a next-action column on every row, so no lead is left without a plan.
What’s in it
Thirteen columns and one example row. The first ten match AutoSalesPilot.ai’s lead import fields, so the same file can be imported later without remapping.
| Column | What to put in it | Example |
|---|---|---|
| Full Name | The lead’s name. The only required column. | EXAMPLE — delete this row |
| Used to spot duplicates. | [email protected] | |
| Phone | Also used to spot duplicates. | +1 555 0100 |
| Company | The organisation they buy for. | Example Co |
| Source | Where the lead came from: website, referral, event, ad… | Website form |
| Lead Status / Stage | One of the stages below. | Qualified |
| Owner | Who is responsible for the next step. | Alex |
| Deal Value | Estimated value, numbers only. | 12000 |
| Lead Score | 0–100: how likely and how valuable. Your best judgement is fine. | 70 |
| Notes | Context that will matter in the next conversation. | Asked for pricing for 10 seats |
| Last Contact Date | YYYY-MM-DD. | 2026-01-15 |
| Next Action | The single next step, written as a verb: “Send revised quote”. | Send pricing and book a demo |
| Next Action Date | YYYY-MM-DD. Every open lead should have one. | 2026-01-16 |
Stage definitions
Agree these as a team. A stage only means something if everyone moves leads for the same reason.
Stage 1
New
Move a lead here when: the lead has arrived but nobody has spoken to them yet.
Stage 2
Contacted
Move a lead here when: you’ve reached out; no real conversation yet.
Stage 3
Qualified
Move a lead here when: there is a real need, budget or timeline, and a decision-maker you can reach.
Stage 4
Proposal
Move a lead here when: a quote or proposal has been sent.
Stage 5
Negotiation
Move a lead here when: terms, scope or price are being discussed.
Stage 6
Won
Move a lead here when: they said yes.
Stage 7
Lost
Move a lead here when: they said no or went silent. Record why in Notes.
Three rules that keep it useful
- Every open lead has a Next Action and a Next Action Date. Filter by date each morning.
- Update the row the moment something happens, not at the end of the week.
- When a lead is Lost, write down why. The pattern is worth more than any single deal.