Here is how you can export events from mixpanel:
- From inside mixpanel, head to the gear icon for Settings on the top right to view options.
- Select Organization Settings.
- From the left sidebar menu, go to Service Accounts.
- From the top right corner, locate and click on the + Add Service Account button.
- Enter a name for your account and other details. These will control the scope and power of this specific account.
- One of the more important settings is the Projects to which this account allowed access to.
- Followed by the Project Role which determines the level of authorization or permissions it has over the project.
- Verify all fields and permissions and then click on Create.
- Make sure you copy and save these credentials to your account. These are what will be used to fetch data using the mixpanel API and cannot be retrieved once the window is closed. When done, click Done.
- Now, for advanced users, you may proceed to use the mixpanel APIs that come with great documentation as you see fit to include in your projects. However, a simpler way to test, fetch or export data is to use the user-friendly mixpanel web UI. To do so, head to the Download Data page in the mixpanel docs.
- Enter your credentials in the Authorization fields.
- Fill the required and optional fields for your query. Note that project_id is a required field when using Service Account as authorization.
- When ready, click on Try It!
- The data will be fetched, which you may either copy or use the recommended way to export your data which involves creating a pipeline or process to regularly update your mixpanel data to a destination file such as a CSV.
