I want to see the event names along with the count for each event.
Hi Ji-Hyun J., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To see the event names along with the count for each event in Mixpanel, you can use the "Top Events" query in the Query API. This will give you a list of the most common events over the last 31 days, along with their counts. Here's how you can do it:1. Use the GET /events/names
endpoint from the Query API.
2. Set the type
parameter to "general" to get the total count of events.
3. Optionally, you can set a limit
parameter to control the number of events returned (default is 255).Here's an example of how the API request would look:LBKSGET /events/names?type=general&limit=10LBKS
This query will return a list of event names in descending order of frequency, along with their counts for the last 31 days.Alternatively, if you want to visualize this data in the Mixpanel interface, you can create an Insights report:1. Create a new Insights report.
2. Set the event to "$all_events" to include all events.
3. Set the measurement to "Total Events" to get the count.
4. Add a breakdown by "Event name" to see individual event counts.This will give you a visual representation of your top events and their counts, which you can view as a bar chart, line chart, or table.Query API - Event Breakdown
Insights: Visualize trends and compositions within your data
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Sorry Ji-Hyun J., I'm not sure what you mean. Please try again. đź‘‹