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).
Resources
1Install
npx skillscat add mixpanel/mixpanel-headless/dashboard-expert Install via the SkillsCat registry.
Dashboard Expert
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:
- Ask the user to run
/mixpanel-headless:setupbefore any analysis code. - For look-ups until then, run the bare command
mp --versionon its own (themponPATH, not the plugin path). - If it shows 0.3.0 or later, use the bare
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.
Pick the mode
| 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.
Quick start: analyze a dashboard
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)}")Quick start: build a dashboard
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.
Mode steps in short
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.
Gotchas
These 14 rules come from failures against the live Mixpanel API. The library does not check most of them for you.
- Send
contentandlayouttogether to place a cell in an existing row. Put both in oneUpdateDashboardParams. Withcontentalone, the new cell goes to a new full-width row at the bottom. - Redistribute widths when you add to a row. A row with N cells gets N+1 cells of width
12 // (N + 1), because the widths in a row must sum to 12. - Apply updates in this order: metadata, cell creates, row reorder (
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_userneedsmath_property. Without it, the query raisesBookmarkValidationErrorbefore any network call. The same is true formath="average","median", and the percentiles.CreateBookmarkParams.dashboard_idis 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 withrows.add_report_to_dashboard()clones the report. The copy gets a "Duplicate of ..." name and a new content ID. Preferrowsor an inline content action.- The GET layout and the PATCH layout differ. GET returns
orderandrowsas a dict keyed by row ID. PATCH takesrows_orderandrowsas a list with anidon each row. A patch withorderdoes not reorder anything. - Leave
versionout of a layout PATCH. GET returns"version": "2.0.0", and the API rejects a patch that sends it back. - Remove newlines from text card HTML. Call
.replace("\n", "").strip()before you send it. With newlines, the editor in Mixpanel parses the HTML as markdown and garbles it. - Stay inside the limits: title 255 characters, description 400, text card 2,000 (keep it under 500), 4 cells per row, 30 rows per dashboard.
- An update cannot change
content_type. To turn a text card into a report, delete the cell, then create a new one. - Report-link cells are read-only. A
report-linkcell shows a report that another dashboard owns. You can run it, but you cannot edit its params from this dashboard. - Pin a new dashboard. A new dashboard is not visible to the team until you call
ws.pin_dashboard(dashboard.id). - The
markdownfield takes HTML only. Markdown syntax such as# Headingor**bold**shows as literal text. Use<h2>and<strong>.
Look up the API before you write code
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 dashboardslists every dashboard method.mp help Workspace --domain reportslists the saved-report (bookmark) methods.mp help CreateDashboardParamsandmp help DashboardRowshow 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>.
Report links
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.
Reading guide
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. |