Analyzes, builds, modifies, and adds explainer text cards to Mixpanel dashboards with the mixpanel_headless Python library. It reads a dashboard's layout and runs every report on it, creates dashboards with text cards and a grid layout, edits cells and rows in place, and writes data-driven explainer cards. Use when the user asks to analyze, summarize, explain, build, create, redesign, update, reorganize, or clean up a Mixpanel dashboard; asks about dashboard layout, rows, cell widths, text cards, or which chart type suits a board; or wants to turn queries into reports placed on a dashboard. Do not use for general analytics questions or one-off queries (use mixpanelyst), or for what a specific user did in a session recording (use session-replay).
Analyze, build, modify, and explain Mixpanel dashboards with mixpanel_headless. A dashboard is a list of rows. Each row holds one to four cells on a 12-column grid. A cell is a report (owned by this dashboard), a report link (owned by another dashboard, read-only), or a text card (HTML).
Run code with the plugin's Python environment: ${CLAUDE_PLUGIN_DATA}/venv/bin/python script.py or ${CLAUDE_PLUGIN_DATA}/venv/bin/python -c "...". Always write that full literal path, never a shell variable such as $CLAUDE_PLUGIN_DATA, because a variable expands to nothing in the shell and the command is denied.
If that interpreter path fails, the environment is not set up. Do not check again with ls, which, or shell variables; those checks are denied and prompt the user. Instead:
/mixpanel-headless:setup before any analysis code.mp --version on its own (the mp on PATH, not the plugin path).mp help <query> for look-ups only.A denial of some other command does not mean Bash is blocked, so still try the bare mp --version.
Do not run analysis code with a Python or mp found on PATH, because its library version is unknown. The one other route is the user's own project: if it already has mixpanel_headless (for example a uv project), uv run python works.
| User intent | Mode | Steps |
|---|---|---|
| Analyze, read, understand, audit a dashboard | Analyze | Read the layout, run each report, summarize by section |
| Build, create, make a new dashboard | Build | Check the data, plan the sections, create with rows in one call, pin |
| Modify, add to, fix, reorganize a dashboard | Modify | Read the current state, plan the changes, apply them in the fixed order |
| Explain a dashboard, add insights or explainer cards to it | Explain | Analyze, compute key numbers, insert explainer cards |
The reading guide at the end says which reference to read for each mode. Show the user a plan before you create or change a dashboard. A dashboard is shared team state, and a wrong layout is slow to undo.
import datetime
import re
import mixpanel_headless as mp
ws = mp.Workspace()
end = datetime.date.today()
start = end - datetime.timedelta(days=90)
dash = ws.get_dashboard(DASHBOARD_ID)
layout, contents = dash.layout, dash.contents
# Rows -> cells -> content items
for row_id in layout["order"]:
for cell in layout["rows"][row_id]["cells"]:
cid, ctype = str(cell["content_id"]), cell["content_type"]
if ctype in ("report", "report-link"):
info = contents["report"][cid]
tag = " [linked]" if ctype == "report-link" else ""
print(f"[{cell['width']}w] {info['name']} ({info['type']}){tag}")
elif ctype == "text":
md = contents["text"][cid].get("markdown", "")
header = " [SECTION]" if re.search(r"<h2[\s>]", md, re.I) else ""
print(f"[{cell['width']}w] TEXT{header}: {md[:60]}")
# Run each report -> DataFrame
for cid, info in contents.get("report", {}).items():
btype, bid = info["type"], info["id"]
if btype == "flows":
result = ws.query_saved_flows(bid)
elif btype == "funnels":
# Without dates, a saved funnel runs over the last 30 days.
result = ws.query_saved_report(
bid, bookmark_type="funnels", from_date=start.isoformat(), to_date=end.isoformat()
)
else:
result = ws.query_saved_report(bid, bookmark_type=btype)
print(f"{info['name']}: {len(result.df)} rows, columns={list(result.df.columns)}")import json
import mixpanel_headless as mp
from mixpanel_headless.types import CreateDashboardParams, DashboardRow, DashboardRowContent
ws = mp.Workspace()
dau = ws.query("Login", math="dau", last=90)
signups = ws.query("Sign Up", math="total", last=90)
def text(html):
return DashboardRowContent(content_type="text", content_params={"markdown": html})
def report(name, btype, result):
return DashboardRowContent(
content_type="report",
content_params={"bookmark": {
"name": name, "type": btype, "params": json.dumps(result.params),
}},
)
dashboard = ws.create_dashboard(CreateDashboardParams(
title="Product Health",
description="Core metrics.",
rows=[
DashboardRow(contents=[text("<h2>Product Health</h2><p>Core metrics, last 90 days.</p>")]),
DashboardRow(contents=[
report("DAU (90d)", "insights", dau),
report("Signups (90d)", "insights", signups),
]),
],
))
ws.pin_dashboard(dashboard.id) # new dashboards are not visible to the team until pinnedrows places every cell in one call, and the cells in a row share the 12 columns evenly. Check each result before you add it: skip a report whose result.df is empty, because an empty chart on a shared board looks like a bug.
Analyze. Read the structure (quick start above). Group cells into sections: a text card with an <h2> starts a section. Run every report and extract the key numbers for its type. Look for links between reports, for example a DAU trend against a retention curve. Present an overview, a section-by-section summary, cross-report findings, and suggestions.
Build. Check that each candidate event has volume. Pick a template from references/templates.md and map its placeholders to real events. Present the plan. Query each metric, then create the dashboard with rows in one call. Pin it. Open it and confirm every report renders.
Modify. Read the current state first and show it to the user. Classify each change. Apply the changes in the order in gotcha 3. Read the dashboard again between layout changes, because row and cell IDs change.
Explain. Run the analyze steps. For each report, compute the latest value and the change against a baseline from result.df. Insert a short explainer card under the chart it explains. The card patterns and the HTML rules are in references/text-cards.md.
These 14 rules come from failures against the live Mixpanel API. The library does not check most of them for you.
content and layout together to place a cell in an existing row. Put both in one UpdateDashboardParams. With content alone, the new cell goes to a new full-width row at the bottom.12 // (N + 1), because the widths in a row must sum to 12.rows_order), cell updates, cell deletes, row deletes. A reorder before a create fails with an unknown row ID, and an early delete can leave gaps.per_user needs math_property. Without it, the query raises BookmarkValidationError before any network call. The same is true for math="average", "median", and the percentiles.CreateBookmarkParams.dashboard_id is required, but it does not place the report on the dashboard. Mixpanel requires every saved report to belong to a dashboard. Place a report with an inline bookmark content action or with rows.add_report_to_dashboard() clones the report. The copy gets a "Duplicate of ..." name and a new content ID. Prefer rows or an inline content action.order and rows as a dict keyed by row ID. PATCH takes rows_order and rows as a list with an id on each row. A patch with order does not reorder anything.version out of a layout PATCH. GET returns "version": "2.0.0", and the API rejects a patch that sends it back..replace("\n", "").strip() before you send it. With newlines, the editor in Mixpanel parses the HTML as markdown and garbles it.content_type. To turn a text card into a report, delete the cell, then create a new one.report-link cell shows a report that another dashboard owns. You can run it, but you cannot edit its params from this dashboard.ws.pin_dashboard(dashboard.id).markdown field takes HTML only. Markdown syntax such as # Heading or **bold** shows as literal text. Use <h2> and <strong>.When the plugin environment exists, mp below means ${CLAUDE_PLUGIN_DATA}/venv/bin/mp; run it with that full path. When it does not exist, use the bare-mp fallback near the top of this file.
The installed library documents itself, so do not guess a method name, a parameter, or a type field. Verify any signature with mp help Workspace.<method>, for example mp help Workspace.update_dashboard. Other useful look-ups:
mp help Workspace --domain dashboards lists every dashboard method.mp help Workspace --domain reports lists the saved-report (bookmark) methods.mp help CreateDashboardParams and mp help DashboardRow show the fields and a worked example.The full look-up loop is in the mixpanelyst skill. The same text is available as ${CLAUDE_PLUGIN_DATA}/venv/bin/python -m mixpanel_headless help <query>.
To read a report URL that the user pasted, call ws.resolve_report_link(link). It returns the params and the report type, and ws.query_report_link(link) runs it. To give the user a URL for a report on a dashboard, call ws.saved_report_link(bookmark_id, report_type="funnels") with the report's type.
Read a reference only when its condition is true. Each file stands alone.
| Read | When |
|---|---|
| references/content-and-layout.md | Before you analyze or modify a dashboard, and before any update_dashboard call that adds, moves, resizes, or deletes a cell or row. It covers content actions, the grid, the PATCH format, operation order, report-link semantics, time filters, and duplication. |
| references/text-cards.md | Before you write or change a text card, and in Explain mode. It covers the allowed HTML, the whitespace rule, and card patterns. |
| references/report-pipeline.md | Before you build a dashboard, or when you turn query results from any engine into reports on a dashboard. It covers the build steps and the query-to-report path for insights, funnels, retention, and flows. |
| references/templates.md | When you plan a new dashboard or a new section. It has nine templates with rows, widths, heights, text, and report specifications. Read the selection guide and "How to use these templates", then read only the chosen template's section. |
| references/chart-types.md | When you pick or check a chart type, or pick a width for a chart. |
aa4e414
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.