Leads spread over spreadsheets when you sell to locksmiths
Are your leads spread over five spreadsheets? Here is how people who sell to locksmiths 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 locksmiths. Most locksmiths are sole traders or very small teams who work from a van and take many urgent calls. Being found fast online matters a great deal to them, and they buy locks, tools and security products from a small group of trusted suppliers.
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 locksmiths, such as emergency service
- Email prefixes that fit, like info@, enquiries@ and hello@
- Status, tags and a segment on every record
The fix, step by step
- 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 locksmiths
Locksmith directories are full of call centres posing as local firms.
Tag records you have checked as genuine and archive the rest, so campaigns only reach real local businesses.
Auto locksmiths and door locksmiths need different messages.
A field for Auto locksmith lets you save two filters and send each its own campaign.
Many locksmiths never answer email from unknown senders.
Keep phone numbers in the same record, tag contacts once you have called, and follow up by mail only where it makes sense.
Fields worth recording for locksmiths
Any column in your import can become a field. These are the ones worth keeping for locksmiths.
| 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. |
| Emergency service | Round the clock locksmiths care about call handling and phone costs. |
| Auto locksmith | Vehicle key work needs specialist tools and suppliers. |
| Safe work | Safe engineers are a small, specific audience. |
| Service area | Shows how far they travel for callouts. |
Questions people ask
Look for a real address, a named owner and a website with local detail. Record what you find in a tag or field and archive records that do not look genuine.
Yes. Import each CSV or Excel file into the same lead file; Riftjaw flags duplicates in the file and against records you already have.
If your file has an email column, that wins. If it only has websites, tick the prefixes you want, such as info@, enquiries@ and hello@, 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