AK
← All projects

Custom Software

ERS CRM — Lead Generation CRM

A custom PHP/MySQL CRM for a recruitment lead-generation team — companies, contacts, enrichment, phone lookups, email verification, exclusion lists, and activity tracking.

PHPMySQLJavaScriptApollo.io APIHostingerGitHub Actions
Private — in daily use
Diagram — ERS CRM takes companies, contacts, emails and CSV imports and produces lead management, tracking and exports

Why build a CRM

Off-the-shelf CRMs did not match how the lead-generation team actually works: research a company, find contacts, verify emails, look up phones, and hand the result to a rep — with rules about who owns what and when.

Main features

  • Companies & contacts — add, edit, search, import from spreadsheets, export.
  • Weekly ownership lock — a company taken this week is blocked for everyone else until the date moves on.
  • Apollo.io integration — one-click contact enrichment and phone lookups, with a webhook that receives results and a review queue before numbers are saved.
  • Data quality — email verification, an exclusion list, company flagging, and draft saving.
  • Team features — user roles, presence indicator, notifications, and an activity log.

How it is run

Two branches: staging for all work, main for live. GitHub Actions deploys each to Hostinger. Database changes are applied as reviewed SQL migration files, and the project keeps a status document so any new session can pick up where the last one stopped.