Leads spread over spreadsheets when you sell to HVAC contractors
Are your leads spread over five spreadsheets? Here is how people who sell to HVAC contractors fix it.
Are your leads spread over five spreadsheets?
One list sits in a scraper export, another in an old Excel file and a third in a shared sheet that someone renamed. Each file has different columns and nobody knows which version is current.
It hits harder when you sell to HVAC contractors. HVAC contractors fit and service heating, ventilation, air conditioning and heat pump systems for homes and commercial buildings. Many run service contracts, so they value tools and suppliers that help them schedule maintenance visits and keep engineers on the road.
You spend time looking for the right file instead of contacting companies. Good prospects get lost between versions and are never approached.
Every list in one database, on your own server.
Riftjaw imports CSV and Excel files from any source into one lead database of your own. You map every column to a field once, and unknown columns become new fields. After that every company has one record with one status.
- Fields that fit HVAC contractors, such as heat pumps
- Email prefixes that fit, like info@, service@, office@ and sales@
- Status, tags and a segment on every record
Fixing it in Riftjaw
- Import your files. Upload each CSV or Excel file and pick an existing lead file or create a new one.
- Map the columns. Match every column to a field; columns you do not recognise become new fields.
- Publish the records. Review the concept records, then publish them into your database.
Other walls when prospecting HVAC contractors
Manufacturer contractor lists and directory lists use different column names for the same things.
Map each file to the same fields during import; unknown columns become new fields instead of being thrown away.
The owner, the service manager and the office all have different addresses and roles.
Keep them in one lead file with a role field, and use placeholders so each mail still opens with the right name.
A cold mail sent in peak season gets buried.
Plan campaigns for quieter months and pause or resume a running campaign at any time.
Fields worth recording for HVAC contractors
Any column in your import can become a field. These are the ones worth keeping for HVAC contractors.
| Field | Why it helps |
|---|---|
| Company name | The key field. Duplicates are checked on it or on the website. |
| Website | Needed to derive an email when the export has none. |
| Heat pumps | Contractors working with heat pumps are the audience for a fast growing product range. |
| Commercial or residential | Commercial firms buy larger equipment and often have a buying office. |
| Service contracts | Firms with maintenance contracts care about scheduling and recurring billing. |
| Brands worked with | Shows which manufacturers they already trust. |
| Number of engineers | Helps you size the offer and set the right price level. |
Questions people ask
Yes. Add a Heat pumps field or tag while you import or review records, then save a filter on it and use that filter as a campaign audience.
Addresses such as service@ or office@ usually reach the people who handle suppliers. Email from domain can suggest these, but they are guesses, so check them where it matters.
If your file has an email column, that wins. If it only has websites, tick the prefixes you want, such as info@, service@, office@ and sales@, and Riftjaw derives addresses from each domain. Derived addresses are good guesses, not verified, so start with small batches.
Yes. The Free plan runs the whole pipeline on one list with small campaigns, and you do not need a credit card. Move to Pro when you want more lists, segments and bigger campaigns.
Build the list in a city
HVAC Contractors in WashingtonDistrict of Columbia, United StatesHVAC Contractors in LiverpoolMerseyside, United Kingdom
HVAC Contractors in San FranciscoCalifornia, United StatesHVAC Contractors in PerthWestern Australia, Australia
HVAC Contractors in SheffieldSouth Yorkshire, United Kingdom
HVAC Contractors in TorontoOntario, CanadaBuild a database you own
Create your account, import your first list and see it turn into records you can work.
No credit card · cancel any time · your data stays yours