How to track lead sources without a CRM

Start with four required columns

• Date — when the inquiry happened.
• Source — how the person says they found the business.
• Contact type — call, walk-in, email, visit or another type you use.
• Location — where the inquiry belongs, even if you currently have only one location.

A first name can be optional. If you add personal contact details, collect only what your business needs and control access to the sheet. Source counting on its own does not require a phone number, email address or a full name.

The downloadable CSV uses these fields plus an optional first_name column. It includes one fictional example row, which you should replace with your own records. Import it into Google Sheets, Excel or another spreadsheet and apply the same source choices to every new row.

When a spreadsheet is enough

A spreadsheet can be a good fit when one person records a modest number of inquiries and is comfortable reviewing the totals. Use a source dropdown instead of free text, keep the original records, and group counts by source and date.

For a fictional week with 20 inquiries, 8 Google search answers represent 40% of all recorded inquiries. If 5 of the 20 records have no named source, report that too. Do not quietly remove unknowns and present the remaining percentage as the share of every inquiry.

When a shared tracker helps

A shared tracker is useful when several people work different shifts, source wording drifts, or the owner needs to review location trends without maintaining spreadsheet summaries.

How They Found You focuses on that routine: your team records the source, contact type and location; the owner reviews recent inquiries and source trends. It is a source tracker, not a follow-up task manager, automated lead generator or sales pipeline.

When you may need a CRM instead

• You need to assign follow-up tasks and reminders.
• You need to track people through a sales pipeline or deal stages.
• You need a history of conversations for each contact.
• You need to connect sales outcomes and revenue to your customer records.

Choose a tool around the job you need done. If you need those capabilities today, evaluate a CRM rather than assuming source tracking will cover them. You can still ask the source question alongside a more detailed sales process.

Source tracking is not the same as ROI reporting

A count of inquiries does not include marketing spend, completed sales or profit. To estimate cost per inquiry, you need a trustworthy spend figure for the same channel and period. To assess return, you also need sales and revenue data plus a defensible attribution method.

Customer-reported answers can help you decide what to investigate next. They do not resolve every touchpoint or identify a specific ad automatically. Keep unknown answers visible and review the data before changing your marketing budget.