CONNECTOR · MIXPANEL
Mixpanel — Web + mobile event analytics. Funnel and retention models exist in-tool, but we mirror to warehouse.
CONNECTOR · MIXPANEL
Mixpanel
Web + mobile event analytics. Funnel and retention models exist in-tool, but we mirror to warehouse.
- categorySource · Product analytics
- freshness targetDaily batch via Mixpanel Data Warehouse export.
- auth modelProject token + service account.
- sync modeS3 / GCS export → staging → dbt.
TABLES SYNCED
events, people, identities. Per-event materialization optional.
SCHEMA · SAMPLE
schema.sqlSQL
CREATE TABLE mixpanel.events (
event TEXT,
distinct_id TEXT,
time TIMESTAMP,
properties JSONB
);QUERY · SAMPLE
query.sqlSQL
SELECT event, COUNT(*) AS n
FROM mixpanel.events
WHERE time >= now() - interval 0
GROUP BY 1 ORDER BY 2 DESC;OPS NOTES
Backfills are limited by Mixpanel's history retention plan. Negotiate retention before signing the data contract.
Wire a real pipeline to your warehouse
30-min stack review. We come back with a scoped plan, an owner, and a freshness contract. No SDR, no slide deck.