Hey folks. I'm trying to use the API to query for an aggregate of specific events. I've set up a custom event that aggregates the types of events/event-property values I'd like to count, but I can't get the API to return any counts for the custom event. Has anyone had/solved this issue before?
I dont believe you can. I asked that last year and it wasn't possible https://mixpanelcommunity.slack.com/archives/C05VD9GBF09/p1712628987959759?thread_ts=1712628509.409809&cid=C05VD9GBF09
I received a response from mixpanel on the linked post above, and they are saying it is not possible. They recommend instead creating a Insights dashboard for the custom event and querying for that instead.
Response from Mixpanel; Hi Dahne, Julianne from Mixpanel Support here- thanks for reaching out about this. Diving right in, the event aggregate API endpoint can only return values for actual raw data, so it would expect an actual event that has been tracked. It isn't able to return data for custom events- apologies for not having better news there. I've gone ahead and filed a feature request on your belhalf around custom events in the APIs. One option to get custom event data would be to create and save a report with the information that you're interested in. From there, you could use the Query API to query for the saved report. Please let me know if anything above needs further clarification. Looking forward to your response! Best, Julianne Support Engineer | Mixpanel
