Build email performance analytics (snapshots, age-aligned trends, replies, template scores, perf brief)
Ready nowPer-campaign opens, clicks, replies and booked-call star, age-aligned trend snapshots every 30 minutes from a GitHub Actions cron, template scoreboard and quadrant analysis, an AC reply webhook feeding a reply feed, and a secret-guarded perf endpoint the email skills read at preflight.
Kit
dashboard-shell
You need
| Account | Why | Free or paid | Plan |
|---|---|---|---|
| ActiveCampaign | Email list, broadcasts, automations and tags. The email engine drafts into a dashboard queue and sends through the AC API; funnels subscribe leads via the API; replies come back through an AC webhook. | Paid | Marketing Lite or Plus (from about 15 USD to 49 USD/mo at 1,000 contacts). API access is on every plan. Webhooks (for reply tracking) need automations, which Lite has. |
| Supabase | Postgres database, auth (dashboard logins), row level security, Realtime pulse, Edge Functions and pg_cron for every dashboard, the attribution tables, booking alerts and the Brain state. | Free tier available | Pro (25 USD/mo) for anything a client logs into. The free tier pauses a project after 7 days without traffic and caps an org at 2 active projects; a paused free project took three client dashboards offline at once (a project log). |
| GitHub | Every site, dashboard and workflow lives in a repo. Actions run scheduled jobs (email snapshots, daily scrapes). Issues double as an email alert channel for bookings. | Free | Free plan. Actions minutes on the free plan cover the cron jobs used here (a few minutes a day). |
| Vercel | Hosts every site, funnel, dashboard and serverless API (subscribe, book, attribution, AC proxy). Runs the cron jobs declared in vercel.json. | Free tier available | Pro (20 USD/mo per seat). The Hobby plan forbids commercial use, so any client site or paid product must be on Pro. Hobby is fine for a personal portfolio. |
| Python 3.12 + uv | Runs every pipeline script (video gates, library export, research cache, Brain export, PDF generator, MIDI tools) inside per-project virtual environments. | Free | Free. |
What you bring
- Your email platform account, with lists, tags and a from address
- Your one time webhook setup inside the email platform
The steps
- Set the secret and the env
- Build the perf endpoint with a URL classifier
- Register the reply webhook and store replies
- Add the snapshot endpoint and the GitHub cron
- Build the analytics page
- Add the quadrant report and the template scoreboard
- Write the perf-brief skill the engine calls
Goes further if you have already built Clone and deploy a client dashboard. You can build this without it.