// step two — diagnosis

Data Health

Before cleanup
74%
37 raw records · 9 duplicates
After cleanup
94%
28 sales-ready leads · 0 duplicates
Cleanup pending

Run the cleanup to merge duplicates, standardise phone numbers and map every status to a stage.

Issues found// 5 categories
Duplicates
9 found

Same person or company entered twice with different spellings.

  • · S. Moyo / Sarah Moyo
  • · Blue Peak Digital / BluePeak Digital
  • · ZIMBUILD (PVT) LTD
9 → ?
Missing details
6 found

Records with no email address or no phone number.

  • · Tinashe Chikore — no email
  • · Leah Ncube — no phone
  • · Tendai Rusike — no email
6 → ?
Invalid phone numbers
21 found

Three different formats in one file.

  • · 0771234567
  • · +263771234567
  • · 263 77 123 4567
21 → ?
Inconsistent statuses
14 found

Free-text statuses mapped onto five pipeline stages.

  • · new / New Lead
  • · CONTACTED / contacted
  • · follow-up / Interested
14 → ?
Unassigned leads
9 found

No owner on the record, so nobody followed up.

  • · Assigned to Tendai, Chipo, Blessing, Farai
9 → ?
Activity log// most recent first
  • 09:42phonesStandardised 37 phone numbers to +263 / +2xx international format
  • 09:42statusNormalised 6 status values (new, New Lead, CONTACTED, follow-up, Interested)
  • 09:41mergeMerged S. Moyo into Sarah Moyo — BluePeak Digital
  • 09:41mergeMerged Ruth Dube duplicate from ZIMBUILD (PVT) LTD
  • 09:41mergeMerged T. Chikore and Tinashe chikore into Tinashe Chikore
  • 09:40companyCorrected capitalisation on 14 company names
  • 09:40namesExpanded 5 initial-only names using matched company records
  • 09:39gapsFlagged 6 records missing an email address or phone number
  • 09:39ownersAssigned 9 unassigned leads to Tendai, Chipo, Blessing and Farai
  • 09:38importImported 37 raw records from leads-export-sept.csv