Skip to content
Automatizav1
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.