Chapter 1 of 7 · Three samples, three shapes
About this video
This video uses sample data, not real Local Scraper data. It doesn't show how to scrape. BillionVerify is not affiliated with or endorsed by Local Scraper. File verification needs a paid account.
Video transcript
Three samples, three shapes
Local Scraper's sample files don't match. One has no email column, one has one, and one has two. Here's what to do with each. Download Local Scraper's sample files, and compare the headers. The Google Quick file has no email column at all. Yahoo Local has one. Yellow Pages has two. That Google file isn't broken. Finding emails is an optional step. The docs don't name the column it adds, so go by your own header.
Two email columns
Yellow Pages needs more care. The sample has Email, and Email from Web. They aren't copies. The one row with both filled shows two different addresses. File List Verify reads one column, and it normally goes for the one called Email. Addresses that only sit in Email from Web would never get checked. So stack them. Copy Email from Web under Email, repeat the business on each new row, and delete the second column. Rows with neither go to a phone list.
Merging different sources
Merging runs from different sites? Line up the headers first. Google says Zip, Yahoo says Zip Code. Main Category is Category. Business Verified is Merchant Verified. Then add a column of your own. These samples have no field naming the site, and files are saved by keyword and location. So write the source in as you merge. Repeats are harder here, because the sites share no ID. Even phone numbers change shape. The Google sample uses plus one and dashes. Yahoo uses brackets. The exact address is the one thing that matches across all of them. If the same address appears twice, we count it once, and you pay once.
Verify the merged file
Now the merged file goes into File List Verify. Read the precheck carefully. If the unique count falls well short of your own, check that the second column really got stacked. Start the job, and it carries on in the background. You'll hear by email. Those are bigger sample lists, not Local Scraper files.
Route each result
Your own mix will differ. Then split the results. Valid is your first send. Role means a shared inbox, so make it easy to forward. Catch-all is a small test. Unknown stays parked. Invalid goes on a suppression list. Select a status and hit Export Results. Your source column survives the trip. Sort by it, and you'll see which site gives you the most usable addresses in your market.
What it costs
A word on credits. Each valid, invalid, catch-all or role result is one credit. Unknown, bad syntax and disposable are free. You'll need a paid account to upload files, and any credit purchase counts.
Get started free
20 free credits every day you use your account, up to 600 a month. No credit card required. Start at billionverify.com.
Featured in this video
Local Scraper Email VerificationLocal Scraper email verification: clean multi-source business exports, label catch-all, role, invalid, and unknown addresses, and check emails before import.Try Local Scraper Email VerificationMore in Google Maps Leads
All email verification videosBillionVerify pricing
Start free, then pay for what you verify. Pick a plan or buy credits once.
billed yearly $96
Save 60%$0.0004 / per credit
All 240,000 credits arrive at once. Use them anytime.
Choose your credits
Included in every paid plan
- 240,000 credits / year
- Single email verification
- Bulk email verification
- Email Finder
- Bulk Email Finder
- Company Search
- Live SMTP mailbox check
- Real-time API + batch processing
- CSV & Excel upload support
- Comprehensive verification reports
- Workspaces and teams with spend limits
- Credits never expire
Try the AI email verification features
20 free credits every day you log in, up to 600 a month. Free AI first email verification across every feature, no credit card.
Native MCP Server integration · Catch-all reported separately · Free tier, no credit card