We manage multiple brands using separate Mixpanel Projects. What is the recommended approach to get unified analytics (e.g., total MAU) across all projects? Is exporting data from each project to a central data warehouse the standard method?
Hi Eliott C., 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
Based on the knowledge sources, there are a few approaches to get unified analytics across multiple Mixpanel projects for different brands.
Options for Unified Analytics Across Projects
1. Data Warehouse Integration
Exporting data from each project to a central data warehouse is indeed a standard method. Mixpanel offers Data Pipelines, which allows you to continuously export data from your Mixpanel projects to a cloud storage bucket or data warehouse of your choice.Mixpanel supports several data warehouse destinations: - BigQuery - Redshift Spectrum - Snowflake - Cloud storage options like AWS S3, Google Cloud Storage, and Azure Blob StorageThis feature is available as an add-on package for Enterprise or Growth plan customers according to the documentation.
2. Project Consolidation/Merging
Another approach is to merge your separate projects into a single Mixpanel project. This would give you unified analytics directly within Mixpanel without needing to export to a data warehouse.The documentation outlines a process for merging Mixpanel projects: 1. Stop sending data to the old projects 2. Begin sending all data to the new consolidated project 3. Export data from old projects via the raw data export API 4. Import that data into the new project via Mixpanel's import API
3. Data Views for Consolidated Projects
If you do consolidate your projects, you can use Data Views to maintain separation between brands within a single project. Data Views act as mini Mixpanel projects within a Mixpanel project, displaying only the events and properties you specify.As mentioned in the Data Views documentation, this feature allows you to create separate views for different teams, functions, or in your case, brands.
Considerations
When deciding between maintaining separate projects or consolidating: - If you want to track cross-brand user behavior, a consolidated approach might be better - If your brands offer fundamentally different functionality, separate projects might make more sense - Note that an organization is charged based on data across all projects, so the same event sent to multiple projects will count against your data allowance multiple timesFor the specific goal of calculating total MAU across projects, the data warehouse approach would allow you to perform this calculation using SQL queries on the exported data.
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.
