Messy scraper exports when you sell to security companies
Does your scraper export have columns called field1, field2 and field3? Here is how people who sell to security 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 security companies. Security companies provide guarding, alarm monitoring, CCTV and access control to businesses and homes. Guarding firms focus on staff and scheduling, while systems firms care about equipment, fitting and monitoring contracts, so the right pitch depends on which type you reach.
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 security companies, such as guarding or systems
- Email prefixes that fit, like info@, sales@, office@ and enquiries@
- Status, tags and a segment on every record
The fix, step by step
- 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 security companies
Guarding firms and alarm fitters share the same category on most directories.
Add a Guarding or systems field and save a filter for each, so equipment offers never reach guarding firms.
Approved registers and directories give you overlapping lists.
Import both into the same lead file and let Riftjaw flag duplicates in the file and against existing records.
Interest from security firms often comes slowly, after several touches.
Open and click history on each contact shows who engaged, so you follow up with the right people first.
Fields worth recording for security companies
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. |
| Guarding or systems | The two sides of the industry buy completely different things. |
| Monitoring centre | Firms with their own monitoring buy software and connectivity. |
| Sectors served | Retail, construction and events each have their own demands. |
| Licensed staff | Guarding firms depend on licensed people and training. |
Questions people ask
Yes. Record the type in a field during research, then use a saved filter on that field as your campaign audience.
Approved contractor registers, industry association lists and map listings are common public sources. You gather them yourself and import them as CSV or Excel.
If your file has an email column, that wins. If it only has websites, tick the prefixes you want, such as info@, sales@, office@ 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
Security Companies in AucklandNew Zealand
Security Companies in SeattleWashington, United States
Security Companies in HoustonTexas, United States
Security Companies in BelfastCounty Antrim, United Kingdom
Security Companies in MelbourneVictoria, AustraliaSecurity Companies in DublinCounty Dublin, IrelandBuild 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