The Scenario
You are a product analyst. It is Tuesday afternoon and the exec team wants a monthly engagement dashboard ready for the 9 AM all-hands on Thursday.
Your Mixpanel workspace tracks 15 key user actions, everything from app_opened to report_exported to invite_sent. Leadership wants to see total counts and unique user counts for all 15 events over the past 90 days, laid out in the Key Metrics tab of the quarterly reporting workbook that already lives on SharePoint.
The bad version of Tuesday afternoon:
- You open Mixpanel in the browser and start pulling each event one by one
- You copy the total count, switch to Excel, paste it, switch back, copy the unique count, paste it
- You do this fifteen times, for fifteen events
- Halfway through, Mixpanel's date filter resets and you have to check which events you already pulled
- You finish, then notice the column headers were in the wrong order and have to re-sort
- You have spent 45 minutes on data entry for a table that should have taken five.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the event list in your tab and calls Mixpanel for you, so you never have to touch the Mixpanel UI at all.
Open the SheetXAI sidebar and type:
Pull the total and unique event counts for each event listed in column A of the Key Metrics tab over the last 90 days. Write total counts into column B and unique user counts into column C. Leave a timestamp in cell E1 showing when the data was last refreshed.
SheetXAI reads the event names from column A, queries Mixpanel for each one, and writes the counts directly into the workbook. The timestamp lands in E1. The whole operation runs once, without you switching tabs or copying a single number.
What You Get
A complete engagement table across 15 rows, ready for the dashboard:
- Column A — the event names you already had, unchanged
- Column B — total event count over the 90-day window
- Column C — unique user count for the same window
- Cell E1 — a refresh timestamp so nobody asks "is this data current?"
The unique count is what makes this useful for leadership. Total counts tell you volume; unique counts tell you reach. Both land in the workbook in one pass without you doing the math.
If you want the numbers segmented differently next month, just update the date range in the prompt. SheetXAI re-reads column A and re-queries Mixpanel from scratch. You are not managing a saved report or a scheduled export, you are asking a question and getting an answer written into the cells.
What If the Data Is Not Quite Ready
Most real Key Metrics tabs are not as clean as the scenario above. SheetXAI can handle the cleanup, the querying, and the formatting in the same prompt.
When event names in the sheet do not match Mixpanel exactly
Your workbook has friendly display names like "Invite Sent" and "Report Exported," but Mixpanel tracks them as invite_sent and report_exported. Mismatched names return empty results.
Treat the event names in column A as display names. Map each one to its Mixpanel event name using snake_case conversion, then pull total and unique counts for the last 90 days and write results into columns B and C. If any event returns zero results, flag the cell in column D with "check name."
When some rows are headers or blank
Someone left a section header row halfway down the tab, or there are blank rows between event groups that will throw off the loop.
Skip any row in column A that is blank or does not look like a Mixpanel event name. For every valid event name, fetch total and unique counts over the last 90 days and write the results into columns B and C. Leave columns B and C blank for any row you skipped.
When you need a quarter-over-quarter comparison alongside the 90-day totals
Leadership always asks how this quarter compares to the last. Getting that comparison normally means running the Mixpanel query twice, for two date windows, and building the comparison column yourself.
Pull total event counts for each event in column A for two periods: the last 90 days and the 90 days before that. Write the current-period total in column B, the prior-period total in column C, and the percentage change in column D. Format column D as a percentage.
When the workbook has no event list yet and you are starting from scratch
You have an empty tab and want Mixpanel to tell you which events are even worth tracking before you commit to a list.
Fetch the top 20 Mixpanel events by total count over the last 90 days. Write event name into column A, total count into column B, and unique user count into column C on the Key Metrics tab. Sort by total count descending. Then pull unique counts for the same events and add a column D showing the unique-to-total ratio as a percentage.
The pattern: instead of pulling the event list from Mixpanel first and then running a second query for counts, you ask for the discovery and the population in one prompt. SheetXAI handles both passes and writes the output into the workbook without you managing the intermediate step.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with an event list in a column, then ask it to pull 90-day counts from Mixpanel and write them in. The Mixpanel integration is included in every SheetXAI plan. For related workflows, see how to export Mixpanel cohort lists into Excel or the Mixpanel in Excel overview.