- name
- mixpanel-analytics
- description
- 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).
Mixpanel Analytics Skill
Query product analytics data from Mixpanel using the Data Export API.
Setup
Option A — Service Account (recommended, new projects)
export MIXPANEL_SERVICE_ACCOUNT_USERNAME="your-sa-username"
export MIXPANEL_SERVICE_ACCOUNT_SECRET="your-sa-secret"
export MIXPANEL_PROJECT_ID="12345678"Get these: Mixpanel → Organization Settings → Service Accounts → Create Service Account
Option B — API Secret (legacy / project-level)
export MIXPANEL_API_SECRET="your-api-secret"Get it: Mixpanel → Project Settings → Access Keys → API Secret
Data Residency (optional)
export MIXPANEL_DATA_REGION="eu" # for EU data residency (default: us)Core Workflows
Top Events (Last 30 Days)
python3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py events --days 30Event Count Over Time
python3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py segmentation \
--event "Sign Up" --from-date 2026-01-01 --to-date 2026-03-21 --unit dayUnique Users for an Event
python3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py segmentation \
--event "Purchase" --type unique --days 7Funnel Analysis
python3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py funnel \
--funnel-id 12345 --from-date 2026-03-01 --to-date 2026-03-21List All Funnels
python3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py funnelsRetention Cohort (Daily)
python3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py retention \
--from-date 2026-03-01 --to-date 2026-03-21 --retention-type birth --unit dayUser Profile Lookup
python3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py profile --distinct-id "user@example.com"Export Raw Events
python3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py export \
--from-date 2026-03-20 --to-date 2026-03-21 \
--event "Purchase" --limit 100List All Events
python3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py list-eventsDirect API Calls (Advanced)
For EU data residency, replace data.mixpanel.com with data-eu.mixpanel.com.
# Segment by event with breakdown
curl -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" \
-u "$MIXPANEL_SERVICE_ACCOUNT_USERNAME:$MIXPANEL_SERVICE_ACCOUNT_SECRET"Key Concepts
- Events: User actions tracked in your product (clicks, purchases, sign-ups)
- Distinct ID: Unique identifier per user in Mixpanel
- Funnels: Conversion paths (e.g. View → Add to Cart → Purchase)
- Retention: How often users return after a trigger event
- Cohorts: Groups of users with common behaviors for analysis
Agent Use Cases
- Daily growth briefing:
eventsfor yesterday's top events + unique users - Conversion monitoring:
segmentationon key events (sign-up → activation) - Funnel regression alerts:
funnelcomparison week-over-week - User debugging:
profilelookup when investigating support issues - Weekly retention report:
retentionon 7-day and 30-day windows
Notes
- Data Export API has a rate limit of 60 requests/hour
- Raw event export can return large datasets — use
--limitto cap - Funnel IDs are found in Mixpanel UI URL:
/report/funnels/XXXX - All dates should be in
YYYY-MM-DDformat