In the Data Booster tests there's a line that looks trivial:
phone_key("+212 535-74 00 37") == phone_key("0535740037")
It means: these two are one number. Data Booster finds numbers in different places: the business's own website, the open maps, the search results. And each place writes the number its own way. If it didn't know these two were the same number, it would think they were two different businesses.
I wrote this test because phone numbers on the internet are never written one way. And you know that if you've ever collected customer numbers in a spreadsheet.
1. The sheet no program accepts
Open any numbers file you've collected from different sources. You'll find something like this:
- 0661 23 45 67
- +212 (0)6 61 23 45 67
- 00212661234567
- 06.61.23.45.67
Four lines, one number. Then you try to upload the file to a sending tool, or open a WhatsApp chat, and half of them get rejected: WhatsApp wants the full number with the country code, no zero at the start, and no spaces or + sign in the link.
And the worst one: +212 (0)6. That zero in the brackets is written by people to say "dial it with a zero inside Morocco." If you leave it in, the number is wrong.
2. The tool: try it now
Paste your numbers, one number per line. Pick the country for numbers written without an international code, and the format you want, then press "Format numbers".
3. What it does with each number
- Understands every way of writing: spaces, dots, dashes and brackets, 00 instead of +, the zero in brackets, an international number written without the + as some files export it, and an extension at the end (ext 12).
- Four formats: international (+212661234567), for WhatsApp and sending tools (212661234567), with double zero, or local (0661234567).
- Mobile or landline: from the first digits of the national number. And the "Mobile only" option gives you the numbers whose owners may be on WhatsApp.
- A WhatsApp link for every mobile: click it in the table, or take all the links in a CSV file.
- Duplicate removal: the four lines above become one number, and the tool tells you which line was a duplicate.
- The reason for every rejection: shorter than this country's numbers, or longer, or with an international code the tool doesn't know.
Supported countries: Morocco, Algeria, Tunisia, Egypt, Saudi Arabia, the UAE, France, Belgium, Spain, and the United States and Canada. And the numbers never leave your device.
4. What it doesn't know, frankly
- "Valid" means the length is right: it doesn't mean the number works, or that its owner will reply.
- It doesn't know who is on WhatsApp: "mobile" is a guess from the first digits. And in the United States and Canada you can't tell mobile from landline by the number, so the tool gives a link for every number.
- Only ten countries: a number with another international code shows as "invalid" with the reason. If you need your country, write it in the comments.
And a word on use: a WhatsApp link makes chatting easier, but it doesn't give you permission. Message people you know your message is relevant to, introduce yourself, and accept "no" the first time.
💳 Price and purchase
The tool formats numbers you already have. Data Booster finds them: it takes the email addresses Lead Miner collected and, for each address, looks up the publicly published information about its owner, including phone, company name, city, website and social media pages, with the source of every piece of information and the confidence in it. It runs alongside Lead Miner on your computer.
Data Booster add-on: $97 a year (or the bundle with Lead Miner: $149 a year)
A question before buying? Message me on WhatsApp.
Messy data doesn't need more effort. It needs one rule applied to every line.
Which country are most of your customers' numbers from? And what strange way of writing a number have you run into? Write it in the comments, without any real number.
Got a lot of files? Merge them first with the CSV Merger, and every month a new free tool reaches the subscribers of the newsletter first.
Comments
Comments
Post a Comment