Simple Template to Audit Your Database
Most people want better conversions⌠But almost nobody has a clean, usable database. So hereâs a simple template you can use to clean yours in under an hour. It is the same five-bucket clean up system I give clients before we launch any pipeline work: HOT WARM PAST CLIENTS COLD QUALIFIED NURTURE ONLY This structure removes chaos, reveals hidden revenue, and shows you exactly where your conversations should start. Here is how to set it up. Step One: Export all of your contacts into one sheetPull them from your CRM, lead forms, email list, social DMs, and past campaigns. Place everything into a single spreadsheet so you have complete visibility. Step Two: Sort every contact into one of the five buckets Hot leads are people who engaged recently, replied, or showed interest. Warm leads are people who almost converted but went quiet. Past clients are individuals who have paid you before. Cold-qualified leads fit your ideal client but never engaged. Nurture-only leads are not a fit or are long-term prospects. Step Three: Add a column titled âLast Activity Dateâ This helps you prioritize your outreach. Zero to ninety days indicates a hot or warm lead. Ninety to one hundred eighty days is cold. One hundred eighty days or more belongs in nurture. Step Four: Apply the correct outreach style for each bucketHot leads receive a light check-in. Warm leads receive a âstill working on this?â message. Past clients receive a review or reactivation prompt. Cold qualified leads receive a simple pattern interrupt. Nurture-only leads receive light value touches. Step Five: Use the following revival scripts to reactivate each group Hot âHey [name], How's it going? Are you still looking at [goal or problem]?â Warm âHey [name], last time we talked you we're exploring [goal]. Still on your radar?â Past Clients âHey [name], if you had a good experience last time, would you mind leaving a quick review? Also, if you are planning anything for Q1, I have openings.â