Claude Templates / A-tier · High leverage

Growth & SEO

The Customer Analytics Playbook

First-party event tracking that outlives cookie blockers — and costs nothing per event.

CUSTOMER-ANALYTICS-PLAYBOOK.md · 14 sections · 2,384 words · 19 KB · markdown

What's inside

• //The page_events schema and the event taxonomy that goes in it
• //A hardened /api/track ingest route with bot filtering
• //visitor_id rotation + the anonymous → identified stitch on signup
• //Signup attribution: UTM capture, referrer classification, AI-source recovery
• //Funnel-step modeling that stays in lockstep across the code
• //Why first-party beats Mixpanel/Amplitude at this scale

Straight from the file

Trade-off you accept: no out-of-the-box "session replay" or "heatmap." If you need those, layer PostHog OSS on top — but the ingest stays first-party.

Table of contents

1. 0. Use this spec
2. 1. Why first-party (vs GA / Mixpanel / Segment)
3. 2. Architecture
4. 3. Schema (Supabase)
5. 4. The atomic upsert RPC
6. 5. /api/track ingest
7. 6. Visitor + session IDs
8. 7. Signup attribution (don't break visitor stability)
9. 8. Event taxonomy (5–10 events, not 500)
10. 9. /api/metrics/live (public HUD counters)
11. 10. Admin analytics dashboard
12. 11. Churn-risk signal
13. 12. Common pitfalls
14. 13. Kickoff prompt

More growth & seo playbooks