How can I create a chart in a board, where I'm able to list all the possible locations of a user and I'm able to search specific property of a user in that chart. Be mindful I'm not talking about a user's view accessbile via left-side panel
Hi Anshul S., 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 create a chart in a Mixpanel board that lists all possible user locations and allows you to search for a specific user property within that chart, you should use the Insights report and then add it to your board. Here’s how you can achieve this: 1. Create an Insights Report: - Go to the Insights report builder. - Select the event or user profile data you want to analyze. - For listing all possible locations, use the “City”, “Region”, or “Country” property as a Breakdown. This will segment your data by user location, showing all the locations where your users are active. - To filter or search for a specific user property (e.g., email, plan type, etc.), use the Filter option. Add a filter for the user property you want to search or segment by (e.g., “Plan Type” equals “Premium”) Insights Quick Start.2. Add the Report to a Board: - Once your Insights report is set up with the desired breakdowns and filters, click to add it to a board. This will create a chart card on your board that displays user locations and is filtered by the property you specified.3. Interactivity: - In the board, you can interact with the chart. For example, you can click on a segment (such as a specific city) to drill down further or use the search/filter options within the report to adjust which user property you’re focusing on Boards Overview.Note: This approach does not refer to the Users view accessible from the left-side panel, but rather to a report/chart embedded in a board, as you requested.If you need to display multiple user properties or allow for dynamic searching within the board, you may need to adjust the filters or breakdowns in the Insights report and re-add or update the chart on your board.For more advanced segmentation, you can also use custom properties or cohorts to further refine the users shown in your chart Custom Properties.If you need to display a table of user properties (not just aggregate charts), you may be limited by the visualization options in the Insights report, as the board primarily supports chart-based cards rather than full user tables.Let me know if you need step-by-step instructions for a specific property or visualization!
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.
I’m not trying to create an insight report. I want to do a raw dump and pull (mistake I formerly said push) of all events and user properties to Azure data platform for example without using Mixpanel data sync integration - where they push the data for us. I want full control hence why I want to pull the data. kapa.ai
Let me check the knowledge base for you again. One moment! 📚
To pull (not push) all events and user properties from Mixpanel to your own Azure data platform—without using Mixpanel’s Data Pipelines integration (which pushes data for you)—you should use Mixpanel’s Export APIs.
1. Exporting Raw Event Data
You can use the Raw Event Export API to pull all event data. This API allows you to export events as JSONL (each line is a JSON object), and you can specify date ranges and filter by event types if needed.Example request:Note: There are API rate limits: max 100 concurrent queries, 60 queries per hour, and 3 queries per second. For projects created before March 2023, timestamps are in your project’s timezone; otherwise, they are in UTC. Export Methods: Export raw data and reports from Mixpanel Step 3: Export Existing Data
2. Exporting User Profile Data
To export user properties (profiles), use the Engage API. This API returns user profiles as a JSON object, with each profile in the results array.Example request:Summary:
You do not need to use Mixpanel’s Data Pipelines (push/integration) to get your data. You can pull all events and user properties using the Export and Engage APIs, then load the data into your Azure platform as you wish. This gives you full control over the extraction and ingestion process.If you need more details on the API endpoints or sample code for automating the process, let me know!
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! 📚
To pull all events and user properties from Mixpanel to your own Azure data platform (without using Mixpanel’s Data Pipelines integration), you should use the following official Mixpanel documentation: ---1. Exporting Raw Event Data- Use the Raw Event Export API to export your event data as JSONL. Example request:
--url '[https://data.mixpanel.com/api/2.0/export?from_date=YYYY-MM-DD&to_date=YYYY-MM-DD](https://data.mixpanel.com/api/2.0/export?from_date=YYYY-MM-DD&to_date=YYYY-MM-DD)' \
--header 'accept: text/plain' \
--header 'authorization: Basic YOUR_TOKEN'
```LBKS You can specify date ranges and filter by event types. The API returns raw event data, which you can ingest into your Azure platform.
[Export Methods: Export raw data and reports from Mixpanel](https://docs.mixpanel.com/docs/export-methods#exporting-events)LBKS---LBKS**2. Exporting User Profile Data**LBKS- Use the [Engage API](https://docs.mixpanel.com/docs/export-methods#exporting-profiles) to export user profile data.
Example request:
```LBKS curl --request POST \
--url '[https://mixpanel.com/api/query/engage?project_id=YOUR_PROJECT_ID](https://mixpanel.com/api/query/engage?project_id=YOUR_PROJECT_ID)' \
--header 'accept: application/json' \
--header 'authorization: Basic YOUR_TOKEN' \
--header 'content-type: application/x-www-form-urlencoded'
```LBKS The response contains user profiles in the `results` array. You can specify which properties to return using the `output_properties` parameter.LBKS---LBKSFor more details and examples, refer to the [Export Methods documentation](https://docs.mixpanel.com/docs/export-methods), which provides a high-level overview and links to the relevant API references.LBKSIf you need to automate or script this process, you can also refer to the [Mixpanel-utils Python module](https://docs.mixpanel.com/troubleshooting/faqs#exporting-data-from-mixpanel), which interacts with these APIs directly.LBKS> These methods allow you to pull (not push) your data from Mixpanel, giving you full control over the extraction and ingestion process into your Azure data platform, as you requested.
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! 📚
To pull Mixpanel data on a daily basis using the Export API or Engage API, you should set the from_date and to_date parameters in your API call to the specific day you want to export. For example, to export data for July 24, 2024, both from_date and to_date would be set to 2024-07-24. You would automate this process (e.g., with a daily script or cron job) to update these parameters each day.Example for daily event export:Note: The Export API has rate limits (60 queries per hour, 3 queries per second, and 100 concurrent queries), so ensure your automation respects these limits Export Methods: Export raw data and reports from Mixpanel.There is no built-in Mixpanel feature for scheduling these pulls; scheduling must be managed on your side (e.g., with cron, Airflow, Azure Data Factory, etc.) Troubleshooting FAQ.
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.