how can I list which are the latest user properties added to my mixpanel schema? same with events or property events
Hi Juan I., 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 list the latest user properties, events, or event properties added to your Mixpanel schema, you have a couple of options, but there are some important limitations and distinctions to be aware of:
1. Lexicon UI
The Mixpanel Lexicon UI displays all entities (events and properties) that have either: - Been sent to your project in the last 30 days, or - Have an associated Lexicon Schema (i.e., have been described or documented in Lexicon)This means that the Lexicon UI is the best place to visually inspect which user properties, events, or event properties have been recently added or seen in your project. However, the UI does not provide a direct "sort by most recently added" feature, but you can see which properties have appeared recently by their presence in the UI if they were sent in the last 30 days or have a schema attached Lexicon Schemas API.
2. Lexicon Schemas API
You can use the Lexicon Schemas API to programmatically retrieve the list of events and properties that have an associated schema. However, this API only returns entities with an explicit schema and does not include all properties/events that have merely been sent to your project. It also does not provide a "created at" or "last seen" timestamp, so you cannot directly list the latest additions—only the current set of documented entities Lexicon Schemas API.
3. CSV Export from Lexicon
If you want a full export of all entities (including those sent in the last 30 days without a schema), you can use the CSV export feature from the Lexicon UI. This export will include all events and properties as seen in the UI, but again, it does not include a "date added" field. You would need to compare exports over time to infer what is new Lexicon Schemas API.---Summary: - There is no built-in way in Mixpanel to directly list the "latest" user properties, events, or event properties by creation date. - The Lexicon UI and CSV export show all recently seen or documented entities. - The Lexicon Schemas API returns only entities with an explicit schema, not all seen in the last 30 days, and does not include timestamps for when properties were added.If you need to track when properties or events are added, you may need to maintain your own change log or periodically export and compare the Lexicon data.For more details, see the documentation on Lexicon Schemas API.
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.