Import local business leads into Clay
Yes. Pick Clay under Export in 67Leads and the CSV comes out with 18 columns named the way Clay names its fields, the owner's name already split into first and last. Rows without an email are kept, because the tool accepts them. 7,056 of the 150,200 US local businesses we list carry an email confirmed by an SMTP mailbox check.
Updated . Counts are computed from the warehouse when this page is served.
Get 67 leads freeOpens the app with the Clay layout chosen under Export. No card. Search is free with contacts masked.
The Clay columns
Clay is a data enrichment tables. The file has these columns, in this order. Rating and review counts are left out of every tool layout.
| Column | What it holds |
|---|---|
Company Name | The business name. |
Domain | The website's domain, without www. |
Website | The company's website, where it has one. |
First Name | The owner's first name, split from the owner name where the company's site gives one; blank when it does not. |
Last Name | The owner's last name, split the same way; blank for a single name. |
Full Name | First and last name together. |
Email | The email address read from the company's own website. |
Email Status | valid, risky or unverified: the result of our SMTP mailbox check. |
Email Verified | yes when the mailbox was confirmed, otherwise no. |
Phone | The main phone number in +1 format. |
City | City. |
State | Two-letter state code. |
Postal Code | ZIP code. |
Category | The trade the business was graded into. |
Pitch Tags | Pitch angles on the row, such as no website or site down, separated by semicolons. |
No Website | yes when the business has no website. |
Site Down | yes when its website did not load when last checked. |
Last Checked | When the email was last checked. |
Import steps in Clay
- For a new table: from the workspace home choose Create new, search for CSV, upload the 67Leads file and pick Create new table.
- For an existing table: open it, choose Tools, then Import, upload the file and pick Add to current table.
- Match the CSV columns to the table's fields. Company Name and Domain are separate columns, ready for enrichment.
- Choose Save and run rows in this CSV to start enrichment, or Save and don't run.
Niches that suit Clay
Live counts. Each link opens that niche in the app with the Clay layout chosen.
| Niche | Companies | |
|---|---|---|
| Tree service companies | 43,553 listed | Open in the app with the Clay layout |
| Plumbers | 16,378 listed | Open in the app with the Clay layout |
| Roofing contractors | 14,865 listed | Open in the app with the Clay layout |
| Dentists | 14,524 listed | Open in the app with the Clay layout |
| HVAC contractors | 13,278 listed | Open in the app with the Clay layout |
| Electricians | 11,808 listed | Open in the app with the Clay layout |
Filters worth setting
- Keep rows with a website if the next step enriches by domain; rows with no website have no domain to look up.
- Email Status and Last Checked tell your waterfall which rows still need an email.
- No Website and Site Down are columns of their own, ready for a filter or a formula.
Questions
Yes. Pick Clay under Export in 67Leads and the CSV comes out with 18 columns named the way Clay names its fields, the owner's name already split into first and last. Rows without an email are kept, because the tool accepts them. 7,056 of the 150,200 US local businesses we list carry an email confirmed by an SMTP mailbox check.
Company Name, Domain, Website, First Name, Last Name, Full Name, Email, Email Status, Email Verified, Phone, City, State, Postal Code, Category, Pitch Tags, No Website, Site Down, Last Checked.
No. The headers follow Clay's own import documentation, linked on this page. Check the mapping screen Clay shows anyway; it is quick.
Each row says valid, risky or unverified. 7,056 addresses (12% of those on file) were confirmed by asking the mail server whether the mailbox exists. If an email we marked valid hard-bounces, tell us and we credit it back. Addresses marked risky or unknown carry no such guarantee.
Searching is free with contacts masked and no daily cap, no account needed. Sign up and your first 67 leads export free, no card. Paying unlocks the rest. Plans: $6.70 for 1,000 credits, one time, no subscription; $67 a month for up to 500 new leads a day, no credits; $677 once for lifetime access, 500 new leads a day, limited to 100 seats. Full refund within 7 days of your first payment.
Other integrations
InstantlySmartleadlemlistGoHighLevelHubSpotApolloAll integrations
PricingLead tool pricing comparedHow the data is builtHTTP API