Messy scraper exports when you sell to solar companies
Does your scraper export have columns called field1, field2 and field3? Here is how people who sell to solar companies fix it.
Does your scraper export have columns called field1, field2 and field3?
Browser scrapers and directory exports produce files with odd column names, several URL columns and a lot of noise. Turning that into a usable list takes work.
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.
Raw exports stay unused on your desktop. The time you saved by scraping is lost again on cleaning.
From raw export to clean records in one import.
Riftjaw reads CSV with comma or semicolon and Excel .xlsx files. You map each column to a field and, when there are several URL columns, you pick which is the website and which is something else. Records start as concepts, so you can review before publishing, and an import can be deleted.
- 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
Fixing it in Riftjaw
- Upload the export. Drop in the CSV or Excel file straight from your scraper.
- Name the columns. Map each column and choose which URL column is the website.
- Review the concepts. Check the records, then publish or delete the import.
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
Build 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