Clarifying Lexicon Names for Mixpanel Raw Data Export
the names used in the lexicon is that the name used by Mixpanel when I do a raw data export kapa.ai
the names used in the lexicon is that the name used by Mixpanel when I do a raw data export kapa.ai
The names you see in the Lexicon—specifically the "Event Name" and "Property Name" fields—correspond to the database names used by Mixpanel. When you perform a raw data export (for example, using the Raw Event Export API), the exported data will use these database names, not the display names or any custom labels you may have set in the Lexicon UI.
So, if your Lexicon shows an event with the database name "user_signup" and a display name "User Signed Up," the raw export will use "user_signup" as the event name in the JSON payload. The same applies to property names: the raw export will use the database property names, not the display names.
This is confirmed in the Lexicon documentation, which distinguishes between the "database name" (used in exports and APIs) and the "display name" (used in the UI) for both events and properties. The exported data will always use the database name fields as shown in Lexicon, not the display names or descriptions Lexicon Overview.
If you need to see exactly which names will appear in your export, refer to the "Name" column in the Lexicon for both events and properties.
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! 📚
For your questions:
1. What are the column names for event name and description in a raw data export?
In a raw event data export (using the Raw Event Export API), the event name appears as the value of the "event" key, and event properties (including any descriptions, if tracked as a property) are found within the "properties" object. There is no dedicated "description" field in the raw event export; descriptions are metadata managed in Lexicon, not part of the event data itself. For example:
```
{"event"::"user_signup","properties"::{"time"::1602611311,"distinct_id"::"12345"}}
LBKSHere, "event" is the event name. There is no "description" column in the raw event export payload [Export Methods](https://docs.mixpanel.com/docs/export-methods).
**2. Can I do a raw data export of the Lexicon?**
You cannot export the Lexicon (data dictionary) via the Raw Event Export API. However, you can export Lexicon data (including event names and descriptions) as a CSV from the Lexicon UI. This export will include the database names, display names, and descriptions for events and properties. To do this, go to Lexicon, click **Export**, and you will receive a CSV file via email [Export and Import Lexicon Data](https://docs.mixpanel.com/docs/data-governance/lexicon#export-and-import-lexicon-data).
Alternatively, you can use the Lexicon Schemas API to export schemas, but this will only include entities with an associated schema and may not match everything visible in the Lexicon UI [Lexicon Schemas API](https://docs.mixpanel.com/docs/data-governance/lexicon#lexicon-schemas-api).
**Summary:**
- In raw event exports, "event" is the event name; there is no "description" column.
- To export event names and descriptions, use the Lexicon CSV export from the UI, not the raw data export 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.
Let me check the knowledge base for you again. One moment! 📚
For your questions:
1. What are the column names for event name and description?
- In a raw event data export (using the Raw Event Export API), the event name appears as the value of the "event" key in the JSON object. There is no column or field for "description" in the raw event export; descriptions are not included in the raw event data, as they are metadata managed in Lexicon, not part of the event payload itself Export Methods.
- In the Lexicon UI and its CSV export, the relevant columns are:
- Event Name: The database name of the event.
- Display Name: The event name as shown in the Mixpanel interface.
- Description: The information that describes the event, such as what triggers it or what properties are sent with it Lexicon Overview.
2. Can I do a raw data export of the Lexicon for events data?
- No, you cannot export Lexicon (event metadata) using the Raw Event Export API. The Raw Event Export API only exports event data as it is tracked (i.e., the events themselves, not their metadata or descriptions) Export Methods. - To export Lexicon data (including event names and descriptions), you should use the Lexicon UI's Export feature, which provides a CSV file containing the metadata for events and properties Export and Import Lexicon Data.
If you need the event names and descriptions, use the Lexicon CSV export, not the raw event export 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.