Before you start: pre-flight checklist
✅ Your events are in your warehouse (or can be quickly mirrored).
✅ You know your top dashboards and critical weekly metrics.
✅ You have a deployment target ready (Kubernetes, Docker, or Linux VM).
✅ Security/IT approvals are in place.
✅ Mixpanel data export path is verified.
Friday evening — connect, validate, smoke-test
1) Deploy Klaritics
# Kubernetes (recommended for production)
helm repo add klaritics https://charts.klaritics.com
helm install klaritics klaritics/klaritics
# Docker Compose (for evaluation or small teams)
curl -fsSL https://get.klaritics.com/compose | bash2) Connect your warehouse
Map events table, user identifier, and timestamp column in Klaritics admin.
3) Validate event parity
SELECT
event_name,
COUNT(*) AS event_count,
COUNT(DISTINCT user_id) AS unique_users,
MIN(event_time) AS earliest,
MAX(event_time) AS latest
FROM events
WHERE event_time >= CURRENT_DATE - INTERVAL '7 days'
GROUP BY event_name
ORDER BY event_count DESC
LIMIT 20;4) Smoke-test top reports
Rebuild top 5 reports in Klaritics and compare with Mixpanel. Track reconciliation items; avoid deep debugging late Friday.
Saturday — rebuild dashboards and reconcile
Recreate core dashboards first, export both sides to CSV, compute variance, and reconcile differences.
Common variance sources:
| Source of variance | Typical impact | Fix |
|---|---|---|
| Time zone mismatch | 1–3% | Standardize org reporting time zone |
| Identity stitching differences | 5–15% | Build/verify identity stitch table |
| Late-arriving events | 1–2% | Align as-of timestamp behavior |
| Bot filtering differences | 0.5–2% | Apply consistent bot filtering |
| Funnel definition mismatch | 5–20% | Audit exact funnel semantics |
Then run parallel for a week to build team trust and catch edge cases.
Sunday — alerts, saved reports, and communication
Migrate alerts, handle long-tail saved reports asynchronously, and publish one migration doc with new dashboard links and owners.
After the one-week parallel run, stop sending events to Mixpanel first, then cancel subscription.
What you'll be glad you did
- Early time-zone audit
- Funnel-definition audit
- Identity resolution validation
- Parallel running
What you'll learn
Most teams discover that a small set of dashboards and alerts drives most decisions. Migration clarifies what truly matters.