In the list of events (Data > Events), we can add columns for Event Properties along with Distinct ID - which is a link to the user's profile. But is there a way we can directly see some of the user's properties as columns in the events section? It would make the event page far more readable as currently it's missing all user information.
Hi Divyaansh A., 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
There’s no explicit mention in the docs that you can add user profile properties as columns in the raw Events stream (Data > Events). The documentation only confirms that: - Events and User Profiles are stored separately and joined at query time on distinct_id, and reports can use both event and user properties together. [Data model; User profiles FAQ]
- In reports, the properties menu lets you choose between event properties and user (profile) properties when filtering/breaking down, but this is described for reports, not for the Events debug view. [Reports properties menu]Because the knowledge sources don’t describe a way to surface user properties as columns in the Events list itself, I’m not able to confirm that this is possible from the Events page UI.If you need events and user properties together in a tabular view, the documented options are: - Use standard reports (e.g. Insights) and add user properties as breakdowns/filters, since those can mix event and profile properties. [Reports properties menu]
- Use JQL to explicitly join events and profiles (join(Events(), People())) and return a custom table that includes both event and user fields. [JQL join]So based on the docs provided, there is no documented way to add user profile columns directly to the Events debug view; you’d need to use a report or JQL to see them side by side.
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.
kapa.ai How do I see a similar view to the Events section as an Insights report? Say I only want to see the list of events on a specific day along with the event properties and user properties as a table
Let me check the knowledge base for you again. One moment! 📚
The knowledge sources don’t describe a way to fully replicate the Data > Events “raw row list” as an Insights table that also includes user properties. They do confirm you can: - Query events over a date range. [Date range]
- Use both event and user properties together in reports and in JQL by joining events and profiles. [JQL events; JQL join]However, the docs provided don’t show an Insights configuration that simply outputs a flat table of individual events + event properties + user properties like the Events view.If you need that table-like output, the documented way to do it is with JQL, which lets you: 1. Pull events for a specific day.
2. Join them with user profiles.
3. Return a custom collection of objects that includes both event and user fields. [JQL events; JQL join]A minimal JQL example (run via the JQL API or JQL app) to get a table of events for one day with selected event and user properties: js function main() { return join( Events({ from_date: "2024-01-10", to_date: "2024-01-10" }), People() ) .map(function (row) { return { event_name: row.event && row.event.name, time: row.event && row.event.time, distinct_id: row.distinct_id, // event properties event_prop_1: row.event && row.event.properties && row.event.properties.prop_1, event_prop_2: row.event && row.event.properties && row.event.properties.prop_2, // user properties user_email: row.user && row.user.properties && row.user.properties.$email, user_plan: row.user && row.user.properties && row.user.properties.plan }; }); }LBKSThis returns a JSON array you can view as a table (or export) with one row per event and both event and user properties included.
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.
