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 30

Event 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 day

Unique Users for an Event

python3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py segmentation \
  --event "Purchase" --type unique --days 7

Funnel Analysis

python3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py funnel \
  --funnel-id 12345 --from-date 2026-03-01 --to-date 2026-03-21

List All Funnels

python3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py funnels

Retention 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 day

User 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 100

List All Events

python3 ~/.openclaw/workspace/skills/mixpanel-analytics/scripts/mx.py list-events

Direct 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: events for yesterday's top events + unique users
• Conversion monitoring: segmentation on key events (sign-up → activation)
• Funnel regression alerts: funnel comparison week-over-week
• User debugging: profile lookup when investigating support issues
• Weekly retention report: retention on 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 --limit to cap
• Funnel IDs are found in Mixpanel UI URL: /report/funnels/XXXX
• All dates should be in YYYY-MM-DD format