Can i make an export of all the event properties and the values they can have?
Hi Natan D., 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
Yes, you can export event properties and their values from Mixpanel using a couple of different methods:1. Using the Raw Event Export API:
You can use the Raw Event Export API to export all your event data, including all properties and their values. This method allows you to download your event data as it is received and stored within Mixpanel, complete with all event properties and their values.Here's an example API request:LBKScurl --request GET \ --url '[https://data.mixpanel.com/api/2.0/export?from_date=<FROM_DATE](https://data.mixpanel.com/api/2.0/export?from_date=<FROM_DATE) &to_date=<TO_DATE> >' \ --header 'accept: text/plain' \ --header 'authorization: Basic ' # set up service account authLBKS
This will export all events and their properties for the specified date range.2. Using the Query API:
For a more targeted approach, you can use the Query API's Event Property Values endpoint to get the top values for a specific property of an event. Here's an example:LBKSGET /events/properties/valuesLBKS
This endpoint allows you to specify an event and a property name, and it will return the top values for that property.3. Exporting Lexicon Data:
If you're looking for a more user-friendly method, you can export your Lexicon data, which includes events and their properties. Project owners, admins, analysts, and consumers can click "Export" in Lexicon to receive a CSV file via email that contains the events and properties data from a project.Keep in mind that there are some limitations and considerations for each method, such as API rate limits and maximum number of properties that can be exported. For large-scale exports, you might want to consider using Mixpanel's Data Pipelines feature if available in your plan.
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.