Tools

What spreadsheet features are best for tracking lead aging?

Tracking how long a lead has been in your pipeline, known as lead aging, is crucial for effective follow-up and resource allocation. While dedicated software handles this automatically, you can implement robust lead aging tracking in a simple spreadsheet with a few key features.

November 6, 2026 · 3 min read

The importance of tracking lead aging

Lead aging helps you understand how long a motivated seller has been in your pipeline since his or her initial reply. Leads tend to 'cool off' over time, but his or her situation can also change suddenly, bringing him or her back into the 'hot' category. Knowing a lead's age informs your follow-up strategy.

It allows you to prioritize. A lead that replied yesterday might get a different cadence than one from three months ago. Without aging data, you might waste effort on cold leads or neglect those that are ready to move forward. This efficiency is critical for managing your time.

Basic date fields and formulas

Start with two essential date columns: 'Date Lead Acquired' and 'Last Contact Date'. The 'Date Lead Acquired' should be the day you first received the seller's reply. The 'Last Contact Date' should update every time you interact with the seller.

Then, use a simple formula to calculate 'Days in Pipeline' by subtracting 'Date Lead Acquired' from today's date. Another formula for 'Days Since Last Contact' can use 'Last Contact Date'. These formulas provide a dynamic view of your lead's age and activity.

Conditional formatting for visual cues

Conditional formatting is invaluable for quickly identifying leads that need attention. Set rules to change the background color of the 'Days in Pipeline' or 'Days Since Last Contact' cells based on their values. For example, green for recent leads, yellow for maturing leads, and red for leads that have been untouched for too long.

This visual cue allows you to scan your spreadsheet and immediately see where your focus should be. It is a simple but powerful way to ensure no lead falls through the cracks and that you are always prioritising your efforts efficiently.

Filtering and sorting for priority

Use your spreadsheet's filtering capabilities to quickly sort leads by 'Days in Pipeline' or 'Days Since Last Contact'. You can sort oldest to newest, or vice versa, to identify leads that are getting stale or those that are fresh and need immediate attention. This helps with batching your work.

Combine this with filters for lead status ('Hot', 'Warm', 'Cold', 'Under Contract') to create targeted follow-up lists. For example, you might filter for 'Warm' leads that have 'Days Since Last Contact' over 7, creating a list of people to call today. This systematic approach ensures consistent follow-up, which is key to working your leads effectively, as discussed in /how-to-work-your-leads.

Adding a 'last contact' timestamp

Beyond just a date, consider a 'Last Contact Timestamp' that includes the time of day. This is useful for more precise follow-up, especially if you are working with sellers in different time zones or trying to vary your call times. It gives you a granular view of recent activity.

This field helps you avoid contacting a seller too soon after a previous interaction. It also allows you to track patterns in when you are most effective in reaching people. Keeping this updated manually can be tedious, but the precision can pay off.

Simple pivot tables for overview

Once you have enough data, a pivot table can give you a high-level overview of your lead aging. You can group leads by age ranges (e.g., 0-7 days, 8-30 days, 30+ days) and see how many leads fall into each category. This helps you analyse your overall pipeline health.

While a dedicated CRM offers more robust analytics, a pivot table in a spreadsheet can still provide valuable insights into your lead flow and the effectiveness of your follow-up cadences. It is a good way to identify trends and adjust your strategy over time. If you want to compare various lead sources, read /compare/list-stacking-vs-buying-replies.

Questions people ask

What's the most important date to track for lead aging?

The 'Date Lead Acquired' and 'Last Contact Date' are equally important. One tells you the overall age, and the other tells you when you last engaged, guiding your next steps.

Can I use colors to show lead age in a spreadsheet?

Yes, conditional formatting allows you to set rules that automatically change cell colors based on the numerical value of days in pipeline or days since last contact, providing quick visual cues.

How often should I update my lead aging spreadsheet?

Ideally, you should update it every time you interact with a lead, particularly the 'Last Contact Date'. Formulas for 'Days in Pipeline' will automatically update as 'today's date' changes.