Marketing Attribution · Web to Phone · Compliance as Code
LiveThe Attribution Chain
- Next.js
- Node
- SQL
- PostgreSQL
- Neon
- Vercel
- REST API
- TLDCRM
- Google Ads
- Facebook Ads
- Bing Ads
- Google Analytics 4
- Meta Pixel
- Search Console
Paid Acquisition
A health agency was buying traffic it could not connect to a single sale. 1 phone number across 355 links meant the source of every call was gone the moment somebody picked up. Now a click resolves to a session, a session to a call, and a call to a policy.
// Chosen from this map, never interpolated from a request.const DIMENSION_SQL = { source: SOURCE_LABEL, campaign: `COALESCE(s.campaign, '(not set)')`,} // The report counts what it could NOT attribute, beside// what it could. A blind spot with a size gets fixed.SELECT count(*) AS total, count(*) FILTER (WHERE lead_id IS NULL) AS unattributed FROM calls WHERE started_at >= ?