Tracking Photography Leads in a Spreadsheet: What to Log

What to log when you track photography leads in a spreadsheet, the statuses to use, where a sheet breaks and when to move to something built for the job.

A spreadsheet is a fine way to track photography leads at the start. Log the date, name, contact, source, event date, venue, budget, status, next action and result, update it daily and review it weekly. It stops being enough when inquiries arrive faster than you can follow up, or when more than one person needs to see it. Here is what to put in, how to keep it honest and how to know when to move on.

The columns you need

Keep it short. Each column must help you decide something.

Column	Why
Date received	Measures how fast you reply
Name	Obvious, but keep it consistent
Contact	Email and phone in separate columns if you use both
Source	Google, Instagram, referral, website form, directory
Type of job	Wedding, portrait, commercial
Event date	Shows clashes and urgency
Venue or area	Travel time and fit
Budget	A range is fine
Status	See next section
Next action and date	The most important column
Value	Quoted price, for forecasting
Result and reason	Won or lost, and why

Two additional columns are worth adding only if you use them: "owner" if more than one person replies, and "date replied" so you can see your response time.

Example row (made up): 12 Mar, Sam Lee, sam@example.com, Instagram, wedding, 14 June, hillside garden, 3,000 to 4,000, proposal sent, follow up 15 Mar, 3,500, open.

Statuses that mean something

A status should tell you what to do next. Use as few as you can.

New: received, not answered.
Replied: you answered, waiting for them.
Call or meeting booked: a time is set.
Proposal sent: quoted, waiting for a decision.
Won: contract signed and deposit paid.
Lost: with a reason.
Parked: future date or not ready.

Add a rule for each: New is cleared within a day. Proposal sent gets a follow-up in three days. Parked gets a date to revisit. Avoid statuses such as "interested" that describe a feeling instead of a step. Our post on how to qualify leads can help you decide who deserves a proposal.

Where spreadsheets break

Spreadsheets work until they do not. Common problems:

No reminders. A sheet cannot tell you a follow-up is due. You have to look.
Inquiries in many places. Email, direct messages, forms and phone calls all need entering by hand.
Version confusion. Two copies, two people, two answers.
No link to the work. A won lead needs a contract, invoices, a calendar entry and a project. All are separate.
Messy data. Typed statuses vary: "Replied", "replied", "Reply sent".
No view of money. You can see a quote but not what has been paid.
Privacy. Client details in a shared file are hard to restrict by person.

Fixes to try first: use drop-down lists for status and source, colour overdue next actions with a simple rule, freeze the header row and sort by next action date each morning. These small changes make a sheet usable for a long time.

A weekly review habit

Fifteen minutes every Friday keeps it honest.

Sort by status and check anything in New older than a day.
Look at Proposal sent. Who needs a nudge?
Update Lost with reasons.
Count: inquiries received, replied, proposals sent, bookings won.
Note where the bookings came from, comparing with your sources.
Write down the three follow-ups for Monday.

Example weekly count (made up): 9 inquiries, 8 replied within a day, 4 proposals, 2 won. The numbers matter less than the habit, which shows what is working. If you pay for ads, check which source gave real bookings, not just clicks. See Google Ads for photographers for more on that.

When to move off the sheet

Signs it is time:

You have missed a follow-up and lost a job because of it.
You spend more time updating the sheet than replying.
More than one person needs the same list.
You want to see reply times, sources and money in one place.
You are re-typing details into contracts and invoices.
You are comparing tools and want to know what is on offer.

You do not need to move all at once. Export the sheet as a CSV, start new inquiries in the new system and let old rows finish.

How ClickBook helps

ClickBook puts leads from Google Ads, Meta ads, a website form, Instagram, email and referrals in one list with date, venue, budget, an owner and a tracked reply time. A won deal becomes a client and project in one step. You can see how a sheet turns into a lead list in the demo.

Example: setting the sheet up in ten minutes

These steps are an example for a sheet with a few inquiries a week.

Create the twelve columns above, with the header row frozen.
Add drop-down lists for Source, Type of job and Status.
Add a rule that turns the Next action date red when it is today or earlier.
Enter your open inquiries from the last month, even rough ones.
Sort by Next action date and work down the list each morning.

Keep one tab for open leads and another for won and lost, so the main list stays short. If your reply time slips, our post on inquiry response time shows why it matters, and spreadsheet versus software compares the two routes fairly.

Frequently asked questions

Is a spreadsheet enough to track photography leads?

For a few inquiries a month, yes. It stops being enough when you miss follow-ups, work with a team or need to see money and bookings together.

How many columns should a lead tracker have?

About ten to twelve. More than that and you stop filling it in. Add a column only when you will use it to make a decision.

How often should I update the sheet?

Every inquiry the day it arrives, and every status change the day it happens. A weekly review catches what slipped.

Should I track leads I lost?

Yes. Mark them lost and note the reason. Over time it shows patterns in price, date availability and response speed.