Law Firm Lead Tracking Sheet

A simple tool to help attorneys track where leads come from, which calls are good fits, and what marketing is actually working.

Many law firms know when the phone rings, but they do not always know which marketing source produced the call, whether the lead was a good fit, or whether the consultation turned into a client. This free lead tracking sheet is designed to help solo attorneys and small law firms make better decisions with simple, practical information.

Why Attorneys Should Track Leads

Law firm marketing can feel confusing because the results are not always obvious. One month you may get several calls from Google. Another month a referral source may send a strong case. A directory may produce inquiries, but none of them may be the right fit. Google Ads may generate calls, but some of those calls may be outside your practice area or service area.

Without simple tracking, it is easy to make marketing decisions based on memory, guesses, or whoever called most recently.

A lead tracking sheet helps answer better questions:

• Where did this lead come from?
• Was the lead a good fit?
• Did the person schedule a consultation?
• Did the person hire the firm?
• Which sources produce quality leads, not just more calls?
• Which marketing efforts deserve more attention?
• Which sources may be wasting time or budget?

What Is Included in the Law Firm Lead Tracking Sheet?

The spreadsheet includes a lead tracker, dashboard, dropdown lists, and basic instructions. It is designed for solo attorneys, small law firms, and office staff who want a simple way to track incoming opportunities without learning complicated software.

The dashboard summarizes total leads, good-fit leads, consultations, hires, conversion rates, estimated value, and lead sources. This gives your firm a quick monthly snapshot without needing to build a report from scratch.

Which Lead Sources Should a Law Firm Track?

Every firm is different, but most attorneys should track the sources that commonly influence new calls and inquiries.

The key is to use consistent names. For example, do not mark one lead as “Google,” another as “Maps,” and another as “Google profile” if they all came from your Google Business Profile. Consistent tracking makes the dashboard more useful.

Why Lead Quality Matters More Than Lead Volume

More leads are not always better. A law firm can receive plenty of calls and still waste time if the inquiries are outside the firm’s practice area, outside the service area, too low-value, or not a good fit for the attorney’s goals.

That is why the lead tracking sheet includes fields for:

• Good fit, poor fit, or maybe
• Consultation scheduled
• Hired or not hired
• Reason not hired
• Estimated fee or value

This helps separate activity from results. A source that produces fewer leads may still be more valuable if those leads are better qualified and more likely to hire.

How Attorneys Can Use the Lead Tracking Sheet Each Week

This sheet is most useful when it becomes part of the normal intake process. It does not need to take long. Someone just needs to enter basic information after each call, form submission, consultation, or referral.

The follow-up date column can be especially helpful. Many law firms lose opportunities not because the lead was bad, but because no one followed up clearly after the first call.

What to Review Each Month

Once a month, review the dashboard and ask what the numbers are actually telling you. Do not just look at total leads. Look at where the best opportunities came from.

This type of review can help attorneys make practical changes. For example, a firm may discover that Google Maps leads are strong but the Google Business Profile needs more attention. Another firm may find that Google Ads is producing calls, but the search terms are too broad. Another may realize that referral leads are strong but no one is consistently staying in touch with referral sources.

How Lead Tracking Helps SEO and Website Decisions

Lead tracking can also help attorneys decide which pages and practice areas deserve more attention. If people are calling about a service you want more of, your website may need stronger practice area pages, better FAQs, clearer calls to action, or more supporting content.

For example:

• If family law leads are strong, your divorce, custody, support, and mediation pages may deserve more attention.
• If criminal defense leads are poor quality, your ads, service pages, or local targeting may need review.
• If estate planning leads come from referrals but not search, your website may need stronger local SEO and service pages.
• If potential clients mention a blog post, that topic may deserve better internal links to the related service page.

For more on law firm SEO and website structure, visit Search Engine Optimization for Lawyers and Law Firm Marketing Services.

How Lead Tracking Helps Google Ads Decisions

Google Ads can create faster visibility, but paid clicks can get expensive in legal markets. That makes lead quality tracking especially important.

A campaign may look successful if it produces calls, but the real question is whether those calls are useful.

This can help your firm avoid wasting money on clicks that do not match your services. It can also reveal when a landing page needs clearer language, stronger trust signals, or a better contact process.

For more on paid search, see Google Ads Advertising for Attorneys and 7 Google Ads Mistakes Law Firms Make.

Lead Tracking and Intake Go Together

Tracking leads is not just a marketing task. It is also an intake task. If the person answering the phone does not ask how the caller found the firm, the marketing data will always be incomplete.

A simple intake question can help:

The answer may not always be perfect. Someone may say “Google” when they really found you on Google Maps. Someone may say “online” when they clicked a legal directory profile. But even imperfect answers are better than not asking at all.

Over time, you can combine intake notes with website analytics, Google Business Profile insights, call tracking, form tracking, and ad reports to get a clearer picture.

Common Lead Tracking Mistakes

Lead tracking does not have to be perfect, but there are a few common mistakes that can make it less useful.

When a Spreadsheet Is Enough and When You Need More

For many small law firms, a spreadsheet is enough to start. It is simple, inexpensive, and easy to customize. You can use it to build the habit of tracking before investing in more advanced software.

You may need something more advanced if:

• Your firm receives a high volume of leads.
• Multiple people handle intake.
• You need automated reminders and follow-up workflows.
• You want deeper reporting by campaign, keyword, or landing page.
• You need CRM or practice management integration.
• You want call recording, call scoring, or more detailed attribution.

Even then, the basic idea stays the same: track the source, track the quality, and track the outcome.

Use the Sheet With Your Monthly Marketing Review

The lead tracking sheet works best when paired with a simple monthly review. Look at the dashboard and compare it with your website analytics, Google Business Profile activity, Google Ads data, Search Console information, and actual client intake notes.

This helps turn marketing from a guessing game into a more practical business review.

Download the Law Firm Lead Tracking Sheet

This free spreadsheet is designed to give attorneys a simple starting point for tracking calls, forms, referrals, consultations, hires, and lead quality.

Need Help Understanding What Your Law Firm Marketing Is Producing?

If you are tracking leads but still not sure what your website, SEO, Google Business Profile, Google Ads, or content are actually doing, LuckyFish Media can help you review the bigger picture.

I help solo attorneys and small law firms improve online visibility, build clearer websites, track leads, and make better marketing decisions without unnecessary jargon or pressure.

You may also find these resources helpful:

• Michigan Law Firm Marketing Resource Center
• Michigan Attorney Resource Hub
• Law Firm AI Visibility and Website Review
• How Michigan Solo Attorneys Can Track Which Marketing Channels Actually Work