Can I export Mixpanel reports to a g-sheet? How would I do this?

Hi Bradley A., 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> 👋

Yes, you can export Mixpanel reports to Google Sheets using the official Sheets ⇔ Mixpanel extension. Here's how to do it:

1. First, install the Sheets ⇔ Mixpanel extension from the Google Workspace Marketplace2. After installation, you'll see the Sheets ⇔ Mixpanel dropdown under "extensions" in any Google Sheet3. To export from Mixpanel to Sheets: - Select "Mixpanel → Sheet" from the extension menu - Provide the necessary parameters, including: - A Service Account (with consumer or higher permission) - Your report URL (from mixpanel.com or eu.mixpanel.com) - Your project_id - Your workspace_id - The report_id or cohort_idThe simplest approach is to paste the URL of the report/cohort you wish to sync from your Mixpanel project, and the app should automatically parse the required parameters.Note that as of version 1.12, only insights, funnels, and retention reports are supported for export to Google Sheets Google Sheets Integration.

If you prefer not to use the extension, you can also: 1. Download reports as CSV from the Mixpanel UI by clicking the "..." button in the top right corner of any report and selecting "Export" 2. Then manually import the CSV into Google SheetsFor more information about the Sheets ⇔ Mixpanel extension, you can watch the tutorial video: Learn to Use Mixpanel: Getting Started in Mixpanel With Our New Sheets ↔️ Mixpanel Extension.The extension is open source, and the code is available on GitHub.

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

I understand your concern about discrepancies between the data in your exported Google Sheets and what's shown in your Mixpanel Insights report. This is a common issue that has several potential causes.

There are several reasons why your exported data might not match what you see in Mixpanel:

Mixpanel applies different types of filters in different contexts: - Inline Filters (Pre-Query): These are applied to specific steps before the query runs - Global Filters (Post-Query): These are applied to the entire report after the query runs - Hidden Events: Mixpanel exports all events to your destination, even ones that are hidden in the UI via Lexicon Data Pipelines FAQ

- Data Delay: It can take up to 1 day for late-arriving data to be synced from Mixpanel to your destination - Data Sync Status: If Data Sync is not enabled or not supported for your pipeline, this could cause discrepancies Data Pipelines FAQ

- Different Mixpanel reports calculate data in different ways (total events vs. unique users) - The export might include data that's filtered out in your specific Insights view Data Discrepancies

To debug these discrepancies, I recommend: 1. Check filtering consistency: Ensure that you're applying the same filters in both systems - "It's important to look out for differences in properties - E.g. event property vs. user property vs. custom property" Data Discrepancies2. Verify time frames and timezones: Make sure both systems are looking at the same time period and timezone - "At the same time frame and timezone" Debugging Discrepancies3. Check for hidden events: Verify if the count in your destination includes events that have been hidden in the Mixpanel UI4. Examine calculation methods: Confirm you're comparing the same metrics (total events vs. unique users)This behavior is expected to some extent due to the different ways data is processed and filtered between systems. For the most accurate comparison, try removing all filters from both systems and gradually adding them back to identify where discrepancies occur.If you continue to experience significant discrepancies, you might want to contact Mixpanel support for more specific guidance related to your implementation.

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