How to Export a List of 9000 Logged-In Users from Our Application
i want to export a list of 9000 users that have logged in on our application, how do i do that
Hi Philip J., 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 export a list of users that have logged in on your application, you can use Mixpanel's User Profile Export feature. Here are the steps:1. Navigate to the Users tab in Mixpanel. 2. Query the profiles that you are interested in seeing. In your case, you would want to filter for users that have logged in. 3. Click the “Export” button in the top right corner to export the profiles as a CSV.Please note that only the columns shown in the UI will be exported in the CSV. You can modify the table by clicking the “Edit Columns” button to choose the profile properties to return before your export.If you want to export the data programmatically, you can use the Mixpanel's Engage API. Here is a sample request:
LBKScurl --request POST \ --url '[https://mixpanel.com/api/query/engage?project_id=1234567](https://mixpanel.com/api/query/engage?project_id=1234567)' \ --header 'accept: application/json' \ --header 'authorization: Basic YOUR _TOKEN \ --header 'content-type: application/x-www-form-urlencoded'LBKSThis will return a JSON object where the profiles are stored in the results key, as an array of objects where each profile is its own object.Please note that there is a limit of 2000 users per request when exporting user data for GDPR or CCPA compliance. If you need to export more than 2000 users, you will need to submit multiple requests.For more information, you can refer to the Mixpanel documentation on User Profile Export and Engage API.kapa.ai is still learning and improving, please let me know how I did by reacting below.
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.