{"skill":{"slug":"mixpanel-analytics","displayName":"Mixpanel Analytics","summary":"Query Mixpanel product analytics — events, funnels, retention, user profiles, and cohorts via the Mixpanel Data Export API. Use when you need to: (1) Query e...","description":"---\nname: mixpanel-analytics\ndescription: \"Query Mixpanel product analytics — events, funnels, retention, user profiles, and cohorts via the Mixpanel Data Export API. Use when you need to: (1) Query event counts or unique users over time, (2) Analyze funnel conversion rates, (3) Check retention metrics, (4) Look up or update user profiles, (5) Export raw event data, (6) Get top events or properties, (7) List cohorts. Requires MIXPANEL_SERVICE_ACCOUNT_USERNAME + MIXPANEL_SERVICE_ACCOUNT_SECRET (or MIXPANEL_API_SECRET for legacy projects).\"\n---\n\n# Mixpanel Analytics Skill\n\nQuery product analytics data from Mixpanel using the Data Export API.\n\n## Setup\n\n### Option A — Service Account (recommended, new projects)\n\n```bash\nexport MIXPANEL_SERVICE_ACCOUNT_USERNAME=\"your-sa-username\"\nexport MIXPANEL_SERVICE_ACCOUNT_SECRET=\"your-sa-secret\"\nexport MIXPANEL_PROJECT_ID=\"12345678\"\n```\n\nGet these: Mixpanel → Organization Settings → Service Accounts → Create Service Account\n\n### Option B — API Secret (legacy / project-level)\n\n```bash\nexport MIXPANEL_API_SECRET=\"your-api-secret\"\n```\n\nGet it: Mixpanel → Project Settings → Access Keys → API Secret\n\n### Data Residency (optional)\n\n```bash\nexport MIXPANEL_DATA_REGION=\"eu\"  # for EU data residency (default: us)\n```\n\n## Core Workflows\n\n### Top Events (Last 30 Days)\n\n```bash\npython3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py events --days 30\n```\n\n### Event Count Over Time\n\n```bash\npython3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py segmentation \\\n  --event \"Sign Up\" --from-date 2026-01-01 --to-date 2026-03-21 --unit day\n```\n\n### Unique Users for an Event\n\n```bash\npython3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py segmentation \\\n  --event \"Purchase\" --type unique --days 7\n```\n\n### Funnel Analysis\n\n```bash\npython3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py funnel \\\n  --funnel-id 12345 --from-date 2026-03-01 --to-date 2026-03-21\n```\n\n### List All Funnels\n\n```bash\npython3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py funnels\n```\n\n### Retention Cohort (Daily)\n\n```bash\npython3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py retention \\\n  --from-date 2026-03-01 --to-date 2026-03-21 --retention-type birth --unit day\n```\n\n### User Profile Lookup\n\n```bash\npython3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py profile --distinct-id \"user@example.com\"\n```\n\n### Export Raw Events\n\n```bash\npython3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py export \\\n  --from-date 2026-03-20 --to-date 2026-03-21 \\\n  --event \"Purchase\" --limit 100\n```\n\n### List All Events\n\n```bash\npython3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py list-events\n```\n\n## Direct API Calls (Advanced)\n\nFor EU data residency, replace `data.mixpanel.com` with `data-eu.mixpanel.com`.\n\n```bash\n# Segment by event with breakdown\ncurl -s \"https://data.mixpanel.com/api/2.0/segmentation?project_id=$MIXPANEL_PROJECT_ID&event=Sign%20Up&from_date=2026-03-01&to_date=2026-03-21&unit=day\" \\\n  -u \"$MIXPANEL_SERVICE_ACCOUNT_USERNAME:$MIXPANEL_SERVICE_ACCOUNT_SECRET\"\n```\n\n## Key Concepts\n\n- **Events**: User actions tracked in your product (clicks, purchases, sign-ups)\n- **Distinct ID**: Unique identifier per user in Mixpanel\n- **Funnels**: Conversion paths (e.g. View → Add to Cart → Purchase)\n- **Retention**: How often users return after a trigger event\n- **Cohorts**: Groups of users with common behaviors for analysis\n\n## Agent Use Cases\n\n- Daily growth briefing: `events` for yesterday's top events + unique users\n- Conversion monitoring: `segmentation` on key events (sign-up → activation)\n- Funnel regression alerts: `funnel` comparison week-over-week\n- User debugging: `profile` lookup when investigating support issues\n- Weekly retention report: `retention` on 7-day and 30-day windows\n\n## Notes\n\n- Data Export API has a rate limit of 60 requests/hour\n- Raw event export can return large datasets — use `--limit` to cap\n- Funnel IDs are found in Mixpanel UI URL: `/report/funnels/XXXX`\n- All dates should be in `YYYY-MM-DD` format\n","tags":{"latest":"1.0.0"},"stats":{"comments":0,"downloads":360,"installsAllTime":14,"installsCurrent":0,"stars":0,"versions":1},"createdAt":1774090952758,"updatedAt":1778492083540},"latestVersion":{"version":"1.0.0","createdAt":1774090952758,"changelog":"Initial release: query events, funnels, retention, user profiles via Mixpanel Data Export API","license":"MIT-0"},"metadata":null,"owner":{"handle":"fr3kstyle","userId":"s172vkz3ch7z1ffq01w45memad885m0p","displayName":"fr3kstyle","image":"https://avatars.githubusercontent.com/u/218435724?v=4"},"moderation":null}