Skip to content
CallFirst
← All posts

Cleaning a Meta lead export: what to fix before your team starts dialling

· 5 min read

A lead export from an ad platform looks tidy until you try to call from it. Phone numbers carry a "p:" prefix. Some have turned into 9.19E+11 because a spreadsheet tried to be helpful. One person appears four times because they tapped four ads.

The usual problems

  • Prefixes and formats. "p:+919812045671", "098120 45671" and "9812045671" are the same number. They need to become one format before you can spot duplicates.
  • Scientific notation. If a number shows as 9.19811E+11 the digits are gone. That lead can only be reached by email, if at all.
  • Fake numbers. 9999999999 and 9876543210 are typed by people who wanted to see the price without being called.
  • Duplicates. The same buyer enquiring twice is one call, not two. Keep the newest enquiry.
  • Non-buyers. Brokers, channel partners and job seekers fill in lead forms too.

Do not open the CSV in Excel first

Most of the damage happens when a CSV is opened and saved again in a spreadsheet. Long numbers get rounded and leading zeros vanish. If you need to look at the file, import it as text, or use a tool that reads the raw file.

A five minute checklist

  • Normalise every phone number to +91 and ten digits.
  • Flag anything that is not a real mobile number.
  • Remove duplicates by phone number, keeping the latest row.
  • Search the message column for "broker", "channel partner" and "job".
  • Only then sort by how recent and how promising each enquiry is.

CallFirst runs this checklist on import. It reads the raw CSV in your browser, so the file is never uploaded and the numbers are never mangled by a round trip through a spreadsheet.