Ask three people in a boiler office how many customers you have, and you will often get three answers. Before any reminder or campaign can work, you need one list everyone trusts: who the customer is, what equipment they have, when it was last serviced and what they agreed to receive. We clean that list, keep it clean, and turn it into a one-page scorecard you can read in two minutes.
What the service is
Short answer: a one-time clean-up of your service records, followed by monthly reporting on the numbers that drive recurring revenue.
The clean-up merges duplicates, standardizes addresses, adds equipment details where your invoices or install records show them, and tags every contact with a consent status and channel. The reporting turns that list into a short monthly scorecard. Customer records are personal information, so we keep access limited and follow your privacy practices; the federal privacy commissioner's PIPEDA overview is a useful starting point for owners.
Who it's for
Short answer: any boiler company whose records are spread across a CRM, spreadsheets, an accounting system and somebody's memory.
If your records don't live in a proper CRM yet, HVACCRM.ca covers CRM setup and staff training in depth. Clean data is also the right first step for companies planning a maintenance plan launch or a reminder program, because both depend on knowing who your customers are and how you may contact them.
What's included
Short answer: the fields, the clean-up, the consent tags and the scorecard.
Fields we aim to fill for each customer
- name, service address and the contact channels they use
- equipment type (combi, system boiler, indirect tank, other) and approximate install year, where records show it
- last service date and who did it
- plan status and renewal date
- consent type and date for text and email, as documented
- source of the original job
The monthly scorecard
| Number | Why it matters |
|---|---|
| Booked tune-ups | The direct output of reminders and campaigns |
| New plan members | Growth of the recurring base |
| Active members | The base itself |
| Renewal rate | Whether the base is holding |
| Reminder opt-outs | Whether messages are welcome |
| Revenue per member | Whether the plan pays for the visits |
Why equipment age belongs on the list
Equipment details turn a contact list into a planning tool. If you know which households have a boiler installed fifteen or more years ago, you can make sure their annual visit happens, and your techs arrive knowing what they will find. Those same records tell you which customers might soon face a replacement decision, so your office can offer an honest conversation about options rather than waiting for a breakdown call. We only record what your own invoices and install records show; we never guess an age to fill a field.
Timeline
Short answer: two to six weeks for clean-up, then a scorecard every month.
Week one is discovery: which systems hold customer data and who updates them. The middle weeks are merging, tagging and filling gaps. The final week sets up the scorecard and a short routine so the list stays clean, such as who records consent at the end of each visit.
How results are measured
Short answer: by how complete and trusted the list is, and later by the scorecard numbers improving.
At the start we report a baseline: total records, duplicates found, records with a last-service date, and records with a documented consent status. At the end we report the same numbers again. After that, the scorecard itself is the measure. Our guide on auditing your service list explains how to take the baseline yourself.
Mistakes to avoid
Short answer: guessing consent, deleting history and building reports nobody reads.
- Marking everyone as "consented" to make the numbers look good. If you can't show when and how someone agreed, tag them as unknown. ISED's consent page explains why proof matters.
- Deleting old customers. A household you served six years ago may still have the same boiler. Archive, don't delete.
- Twenty-number dashboards. Owners stop reading them. Six numbers on one page get read.
- No one owns data entry. Decide who records equipment and consent at each visit, or the list decays within a season.
- Cleaning once and never again. We include a quarterly check in every managed plan; see pricing.
Frequently asked questions
What software do we need?
Whatever CRM or field-service tool you use now is usually fine. We work inside it, and if it truly can't store equipment and consent fields, we explain the options before you spend anything.
Do you take a copy of our customer data?
We work inside your systems as invited users wherever possible. If an export is needed for clean-up, it is handled securely, used only for the project and returned or deleted afterwards.
Which numbers go on the scorecard?
Booked tune-ups, plan sign-ups, active members, renewal rate, reminder opt-outs and revenue per member. A handful of numbers, the same ones every month.
How long does clean-up take?
Two to six weeks, depending on how many records you have and how many systems they are spread across.
Sources
- Office of the Privacy Commissioner of Canada: PIPEDA overview (2026-10-22)
- ISED: Getting consent to send email (2026-10-22)