How can I query the most read pieces of content aggregated by a property from the Mixpanel API?
Hi Lois, 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 query the most read pieces of content aggregated by a property (for example, "content title" or "article ID") from the Mixpanel API, you can use the Event Breakdown endpoints, specifically: 1. Get the top property values for an event:
Use the GET /events/properties/values
endpoint to retrieve the top values for a specific property of your "Read Content" event. For example, if your event is called Content Read
and the property is content_title
, you can get the most frequently read content titles.Example request:Example request:Summary:
- Use /events/properties/values
to get the most read content by property.
- Use /events/properties
to get counts aggregated by property and time.These endpoints allow you to programmatically analyze your most read content pieces, aggregated by any property you track on your events.
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.
Let me check the knowledge base for you again. One moment! 📚
You cannot query custom events directly via the Raw Event Export API, as custom events in Mixpanel are virtual entities defined in the UI and not stored as raw events. If you want to export or query a custom event, you need to look at its definition and query the underlying raw events that make up the custom event instead.However, in Mixpanel's reporting APIs (such as Insights, Funnels, and Flows), custom events can be used just like regular events. For example, you can select custom events as steps in Funnels or as start/end points in Flows reports. But for API-based raw data export, only the underlying events are available, not the custom event itself #Support QA , Custom Events in Flows.Summary: - Raw Event Export API: Cannot export/query custom events directly; must use the underlying events. - Reporting APIs/UI: Custom events can be used in queries and reports as if they were real events.If you need to programmatically analyze custom events, you must reconstruct them by aggregating the relevant raw events according to the custom event's definition.
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.