Leads spread over spreadsheets when you sell to solar companies
Are your leads spread over five spreadsheets? Here is how people who sell to solar companies 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 solar companies. Solar companies design and fit panels, batteries and related systems for homes and businesses. Many are growing firms with a sales team and fitting crews, so they buy lead generation, finance options, equipment and software to keep both sides busy.
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 solar companies, such as batteries offered
- Email prefixes that fit, like info@, sales@, hello@ and enquiries@
- Status, tags and a segment on every record
How to fix 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 solar companies
Solar firms change fast, so lists go out of date.
Every record keeps its source and date, and you can archive firms that closed or merged so they are no longer mailed.
Battery specialists and panel only fitters need different offers.
Add a Batteries offered field and save a filter on it, then write a campaign for each group.
A sales led market means many other suppliers mail them too.
Use placeholders for the company name and a personal detail field so each message reads like it was written for them.
Fields worth recording for solar companies
Add these as fields in your lead file. Any column in your import can become a field.
| 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. |
| Batteries offered | Firms fitting storage need different stock and training. |
| Commercial projects | Commercial roofs mean bigger orders and longer sales cycles. |
| Accreditation | Registered firms can offer schemes that many customers ask for. |
| Sales team | Firms with salespeople buy CRM and lead tools. |
| Brands used | Shows which panel and inverter makers they work with. |
Questions people ask
Accredited fitter registers, industry association lists and map listings are common public sources. Collect them yourself, then import the files into Riftjaw.
Yes. Record it in a field or tag during your research and save a filter on it that you use as the campaign audience.
If your file has an email column, that wins. If it only has websites, tick the prefixes you want, such as info@, sales@, hello@ and enquiries@, 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
Solar Companies in PerthWestern Australia, Australia
Solar Companies in ManchesterGreater Manchester, United Kingdom
Solar Companies in San FranciscoCalifornia, United States
Solar Companies in SeattleWashington, United States
Solar Companies in MelbourneVictoria, Australia
Solar Companies in PhoenixArizona, United StatesBuild 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