Jessie Lee Martin
Internal tool

LeadFinder

An internal tool built at Social Points Media to replace a spreadsheet and an old directory scraper with an online lead database, CRM, call list and exports.

The problem

Finding local business prospects lived in a spreadsheet fed by a directory scraper whose listings were stale and could not tell open businesses from closed ones.

My role

  • Chose the Google Places API over the old directory because it reports whether a business is still open.
  • Defined the deduplication rules and protected the sales team's notes and status fields from being overwritten on refresh.
  • Hosted it on its own server so its traffic stays separate from customer-facing products.

Key decisions

#DecisionWhy
1Google Places API, not directory scrapingFresh listings and open or closed status
2Dedupe on phone, else name plus ZIPOne record per business
3Never overwrite pipeline fields on refreshSales notes and do-not-contact flags are safe

Results

  • Live internally with search, CRM, call list and exports, backed by 228 automated tests at launch.
Role
Project manager and lead developer
Users
Internal sales team
Stack
Laravel, MySQL, Google Places API
Status
Live internally (no public link)
Employer
Social Points Media