โ† All skills
Tencent SkillHub ยท Developer Tools

Mixpanel

Query Mixpanel analytics with funnels, retention, segmentation, and event tracking via REST API.

skill openclawclawhub Free
0 Downloads
0 Stars
0 Installs
0 Score
High Signal

Query Mixpanel analytics with funnels, retention, segmentation, and event tracking via REST API.

โฌ‡ 0 downloads โ˜… 0 stars Unverified but indexed

Install for OpenClaw

Quick setup
  1. Download the package from Yavira.
  2. Extract the archive and review SKILL.md first.
  3. Import or place the package into your OpenClaw setup.

Requirements

Target platform
OpenClaw
Install method
Manual import
Extraction
Extract archive
Prerequisites
OpenClaw
Primary doc
SKILL.md

Package facts

Download mode
Yavira redirect
Package format
ZIP package
Source platform
Tencent SkillHub
What's included
SKILL.md, memory-template.md, setup.md

Validation

  • Use the Yavira download entry.
  • Review SKILL.md after the package is downloaded.
  • Confirm the extracted package contains the expected setup assets.

Install with your agent

Agent handoff

Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.

  1. Download the package from Yavira.
  2. Extract it into a folder your agent can access.
  3. Paste one of the prompts below and point your agent at the extracted folder.
New install

I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.

Upgrade existing

I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.

Trust & source

Release facts

Source
Tencent SkillHub
Verification
Indexed source record
Version
1.0.1

Documentation

ClawHub primary doc Primary doc: SKILL.md 18 sections Open source page

Setup

On first use, read setup.md for integration guidelines.

When to Use

User needs product analytics from Mixpanel. Agent handles event queries, funnel analysis, retention cohorts, user segmentation, and profile lookups.

Architecture

Memory lives in ~/mixpanel/. See memory-template.md for structure. ~/mixpanel/ โ”œโ”€โ”€ memory.md # Projects, saved queries, insights โ””โ”€โ”€ queries/ # Saved JQL queries

Quick Reference

TopicFileSetup processsetup.mdMemory templatememory-template.md

1. Authentication

Requires a Mixpanel Service Account: export MP_SERVICE_ACCOUNT="your-service-account" export MP_SERVICE_SECRET="your-service-secret" export MP_PROJECT_ID="123456" Create a service account in Mixpanel โ†’ Organization Settings โ†’ Service Accounts.

2. Query API for Analysis

Use the Query API for insights, funnels, retention: BASE="https://mixpanel.com/api/query" AUTH=$(echo -n "$MP_SERVICE_ACCOUNT:$MP_SERVICE_SECRET" | base64) # Insights query (event counts) curl -s "$BASE/insights?project_id=$MP_PROJECT_ID" \ -H "Authorization: Basic $AUTH" \ -H "Content-Type: application/json" \ -d '{ "params": { "event": ["Sign Up", "Purchase"], "type": "general", "unit": "day", "from_date": "2024-01-01", "to_date": "2024-01-31" } }' | jq

3. Funnel Analysis

curl -s "$BASE/funnels?project_id=$MP_PROJECT_ID" \ -H "Authorization: Basic $AUTH" \ -H "Content-Type: application/json" \ -d '{ "params": { "events": [ {"event": "Sign Up"}, {"event": "Complete Onboarding"}, {"event": "First Purchase"} ], "from_date": "2024-01-01", "to_date": "2024-01-31", "unit": "day" } }' | jq '.data.meta.overall'

4. Retention Cohorts

curl -s "$BASE/retention?project_id=$MP_PROJECT_ID" \ -H "Authorization: Basic $AUTH" \ -H "Content-Type: application/json" \ -d '{ "params": { "born_event": "Sign Up", "event": "App Open", "from_date": "2024-01-01", "to_date": "2024-01-31", "unit": "week", "retention_type": "birth" } }' | jq

5. User Profiles

curl -s "https://mixpanel.com/api/query/engage?project_id=$MP_PROJECT_ID" \ -H "Authorization: Basic $AUTH" \ -H "Content-Type: application/json" \ -d '{ "filter_by_cohort": {"id": 12345}, "output_properties": ["$email", "$name", "plan"] }' | jq

6. Export Raw Events

curl -s "https://data.mixpanel.com/api/2.0/export?project_id=$MP_PROJECT_ID" \ -H "Authorization: Basic $AUTH" \ -d "from_date=2024-01-01" \ -d "to_date=2024-01-07" \ -d "event=[\"Purchase\"]"

7. JQL for Complex Queries

// Mixpanel JQL (JavaScript Query Language) function main() { return Events({ from_date: "2024-01-01", to_date: "2024-01-31", event_selectors: [{event: "Purchase"}] }) .groupByUser(["properties.$city"], mixpanel.reducer.sum("properties.amount")) .groupBy(["key.$city"], mixpanel.reducer.avg("value")) .sortDesc("value") .take(10); }

Common Queries

GoalEndpointKey ParamsEvent counts/insightsevent, type, unit, datesConversion funnel/funnelsevents array, datesUser retention/retentionborn_event, event, unitUser segments/engagefilter_by_cohort, propertiesRaw event export/exportdates, event filter

Mixpanel Traps

Wrong date format โ†’ use YYYY-MM-DD, not timestamps Missing project_id โ†’ every Query API call needs it Rate limits โ†’ 60 requests/hour for free tier, batch queries when possible JQL timeouts โ†’ queries over 60s fail, add .take(N) to limit results

External Endpoints

EndpointData SentPurposemixpanel.com/api/query/*Credentials, project ID, query paramsAnalytics queriesdata.mixpanel.com/api/2.0/*Credentials, project ID, date rangeRaw data export No other data is sent externally.

Security & Privacy

Data sent to Mixpanel (over HTTPS): Service account credentials for authentication Query parameters (event names, date ranges, filters) Project ID Data that stays local: Credentials stored ONLY in environment variables Query results cached in ~/mixpanel/ This skill does NOT: Store credentials in memory.md or any file Send data to services other than mixpanel.com Modify your Mixpanel tracking code or SDK

Trust

By using this skill, analytics data is queried from Mixpanel. Only install if you trust Mixpanel with your product data.

Related Skills

Install with clawhub install <slug> if user confirms: analytics โ€” multi-platform analytics data-analysis โ€” data processing patterns api โ€” REST API best practices

Feedback

If useful: clawhub star mixpanel Stay updated: clawhub sync

Category context

Code helpers, APIs, CLIs, browser automation, testing, and developer operations.

Source: Tencent SkillHub

Largest current source with strong distribution and engagement signals.

Package contents

Included in package
3 Docs
  • SKILL.md Primary doc
  • memory-template.md Docs
  • setup.md Docs