Report to identify which events are not used in any reports or charts, and which events are the most frequently used?
You can identify unused vs. frequently used events in Mixpanel using Lexicon and the Mixpanel Monitoring Dashboard.
1. Lexicon โ Query Volume Metrics
Lexicon is your primary tool for this analysis. It shows UI and API query volumes for the last 30 days for every event and property, allowing you to sort and compare usage.
Navigate to Lexicon in your Mixpanel project.
Sort events by query volume (ascending to find unused events, descending to find the most queried ones).
Key metadata available per event includes:
Who first/last queried the event and when
Last 30-day volume vs. number of queries
Which reports use the event
This lets you make data-driven decisions about which events to keep, hide, or drop. [Lexicon Query Volumes]
2. Mixpanel Monitoring Dashboard
The Mixpanel Monitoring Dashboard (available within your project) gives you a broader view of event volume and usage trends across the project, helping you pinpoint cleanup priorities and identify unused or duplicate events. [Govern Data]
3. What to Do with the Results
Unused events (low/zero query volume): Consider hiding them from dropdowns to reduce clutter, or dropping them entirely to stop ingestion. [Data Clean-Up]
Frequently used events: Ensure they have clear descriptions and are well-documented in Lexicon. [Establish Governance]
Note: Mixpanel also automatically hides events from report dropdowns if they haven't been fired in the last 30 days (unless they've been modified in Lexicon), which is another signal for identifying inactive events. [Debugging]
In summary, Lexicon is the go-to report for this use case โ sort by query volume to instantly see which events are driving analysis and which are sitting idle.
โน๏ธย Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
