Messy scraper exports when you sell to law firms
Does your scraper export have columns called field1, field2 and field3? Here is how people who sell to law firms 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 law firms. Law firms vary from sole practitioners to large partnerships with a practice manager or operations team. Purchases often go through a practice manager and a partner, and anything touching client data gets close scrutiny.
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 law firms, such as practice areas
- Email prefixes that fit, like info@, enquiries@, reception@ and office@
- 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 law firms
Generic enquiry addresses are screened by staff who expect client work, not sales.
Test several prefixes, record which ones got replies and adjust your prefix choice for the next list.
A list of law firms covers practice areas that need entirely different messages.
Store practice areas as tags and send each campaign to a saved filter on one tag.
Firms ask where you got their details.
Every record keeps its source and date, so you can answer the question honestly.
Fields worth recording for law firms
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. |
| Practice areas | Family, property or corporate law firms buy different tools. |
| Lawyers | Headcount shows budget and whether there is a practice manager. |
| Practice manager | Often the person who handles suppliers day to day. |
| Case management system | Their current system matters for any software pitch. |
| Offices | Firms with several offices need central tools. |
Questions people ask
Riftjaw stores the source and date on each record, so you can say exactly which public listing it came from. Unsubscribed contacts are never mailed again.
Yes, if your list records practice areas. Add them as tags or a field and save a filter for conveyancing, then use it 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@, enquiries@, reception@ and office@, 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