how can i create reports that combine information from 2 projects?

Hi Tobias, 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> 👋

To create reports that combine information from two Mixpanel projects, you have a couple of options: 1. Move Boards: You can use the Move feature to copy boards containing reports from one project to another. This allows you to replicate analyses across different projects. However, note that this doesn't actually combine data from two projects, but rather lets you recreate reports in a new project. Move Boards documentation provides details on how to use this feature.2. Merge Projects: If you need to actually combine data from two projects, you can merge Mixpanel projects. This process involves: a) Stopping data sending to the old project(s) b) Sending all data to the new project c) Exporting data from the old project using the raw data export API d) Importing that data into the new project via Mixpanel's import API Merge Mixpanel Projects documentation provides more details on this process.It's important to note that merging projects is a more complex process and requires careful consideration of data integrity, especially if you're using the alias method for user identification.Remember that these methods don't allow for real-time combination of data from two separate, active projects. If you need ongoing analysis across multiple projects, you might need to consider adjusting your project structure or leveraging external tools to combine the data outside of Mixpanel.

ℹ️ 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! 📚

Based on the information provided in the knowledge sources, there isn't a direct method within Mixpanel to perform ongoing analysis across multiple active projects simultaneously. However, I can provide some guidance on adjusting your project structure to better suit your needs for cross-project analysis: 1. Consolidate into a single project: The most straightforward approach is to consolidate your data into a single Mixpanel project. This allows for easier cross-analysis of all your data. As mentioned in the Managing Projects documentation, you can merge Mixpanel projects by exporting data from one project and importing it into another.2. Use Warehouse Connectors: If you have a data warehouse (like Snowflake, BigQuery, or Redshift), you can use Mixpanel's Warehouse Connectors to bring all your data into one Mixpanel project. This approach is described in the Mixpanel blog post about business data analysis. It allows you to analyze data from multiple sources within Mixpanel without the need for multiple projects.3. Implement consistent tracking across platforms: If you decide to keep multiple projects, ensure that you're using consistent event naming and user identification across all your platforms and projects. This is highlighted in the best practices for cross-platform tracking.4. Consider your use case: As mentioned in the documentation about multiple production projects, you should consider whether you need to track cross-platform user behavior. If so, it's generally better to have all data in one project.5. Use data governance tools: If you do consolidate into a single project, make use of Mixpanel's data governance tools like verified metrics, pinned boards, and data standards to keep your data organized and easily accessible for different teams. This is discussed in the project migration playbook.Remember, while these approaches can help, they may require significant changes to your current setup. If none of these solutions fit your needs, you might need to explore external tools or custom solutions to combine data from multiple Mixpanel projects for ongoing analysis.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.