Messy scraper exports when you sell to electricians
Does your scraper export have columns called field1, field2 and field3? Here is how people who sell to electricians 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 electricians. Electrical contractors range from one person domestic firms to commercial contractors with site teams and estimators. Small firms buy through the owner, while larger ones often have an office manager or contracts manager who handles suppliers and software.
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 electricians, such as domestic or commercial
- Email prefixes that fit, like info@, office@, admin@ 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 electricians
Domestic and commercial electricians sit in the same directory lists, so one message rarely fits both.
Add a Domestic or commercial field, fill it during import and save a filter for each so every campaign stays relevant.
Lists from certification registers and directories overlap heavily.
Riftjaw checks each import against your lead file and flags duplicates before you publish, so the same firm is not mailed twice.
You lose track of which contractors already had a sample or a demo.
Every contact keeps notes, tags and a history of each mail, open and click, so the next person on your team sees what happened.
Fields worth recording for electricians
Record these and you can split the list later, write sharper mails and see who fits your offer.
| 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. |
| Domestic or commercial | The type of work decides which products and messages are relevant. |
| EV charger work | Firms that fit car chargers are a clear audience for charger brands and suppliers. |
| Certification scheme | Membership of a scheme hints at size and at the paperwork they deal with. |
| Service area | Lets you plan outreach by region or by branch territory. |
| Decision maker | Note whether you deal with the owner or an office manager. |
Questions people ask
Common sources are map listings, trade directories and the public registers of certification schemes. You collect the list yourself, for example with a scraper export or the paste and collect tool, and import it into Riftjaw.
Yes, if the information is on their listing or website. Record it in a field or a tag and save a filter on it, which you can then use as the audience of a campaign.
If your file has an email column, that wins. If it only has websites, tick the prefixes you want, such as info@, office@, admin@ 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