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
| # | Decision | Why |
|---|---|---|
| 1 | Google Places API, not directory scraping | Fresh listings and open or closed status |
| 2 | Dedupe on phone, else name plus ZIP | One record per business |
| 3 | Never overwrite pipeline fields on refresh | Sales 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