Lead score decay in HubSpot: a simple time-decay formula (free sheet)

Updated 2026-11-22

Lead scores usually only go up. A lead that was very engaged six months ago can still outrank someone who visited your pricing page yesterday. Score decay fixes that by reducing a score the longer a lead stays inactive.

The formula

The simplest robust approach is exponential decay with a half-life:

decayed score = raw score × 0.5 ^ (days since last engagement ÷ half-life)

With a 14-day half-life:

Days inactive Share of score kept
0 100%
7 71%
14 50%
28 25%
60 ~5%

Every half-life without activity halves the score, so recent intent wins and nobody's score drops abruptly on a fixed date.

Choosing the half-life

Match it to your sales cycle:

  • Transactional / short cycles (days to weeks): 7–14 days
  • Mid-market (1–3 months): 21–30 days
  • Enterprise (6+ months): 45–90 days

Start with roughly a quarter of your typical time from first touch to opportunity, then check whether reps' top-ranked leads actually convert better.

Doing it in HubSpot

Some HubSpot tiers and newer scoring tools include decay options. If yours doesn't, you can calculate the decayed score outside HubSpot (in a sheet, or with an automation) and write it to a custom property your views and sequences sort by. You need the raw score and the last engagement date for each lead.

Free Google Sheet

I built a free sheet that does this calculation. Copy it, paste your export (lead, score, last engagement date), set your half-life, and sort by rank: get the sheet.