Discrepancies Between Mixpanel Dashboard and Gsheet Data Extracts
I'm using the Gsheet extension to send Mixpanel data to a Gsheet hourly, but the extract is different to the dashboard? What could be causing this?
I'm using the Gsheet extension to send Mixpanel data to a Gsheet hourly, but the extract is different to the dashboard? What could be causing this?
Hi Khayalethu L., 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
There are several reasons why the data exported from Mixpanel to Google Sheets using the Gsheet extension might differ from what you see in your Mixpanel dashboard: 1. Different Report Types and Calculations: Mixpanel reports (e.g., Insights, Funnels) calculate data differently. For example, Insights may show total event counts, while Funnels may show unique user conversions. Ensure you are comparing the same report type and metric in both Mixpanel and your Gsheet export. Filters and breakdowns applied in the dashboard may not be reflected in the export if not configured identically Debugging Discrepancies.2. Timeframes and Timezones: Make sure both the dashboard and the export are using the same time frame and timezone. Mixpanel records events in UTC, but displays them in your project’s configured timezone, which may differ from what is shown in the export Debugging Discrepancies.3. Filters and Query Parameters: The export to Google Sheets requires you to specify parameters such as report URL, project ID, and report ID. If these do not match the dashboard configuration (e.g., filters, breakdowns), the data will differ Export to Google Sheet.4. Data Sync Delays: There may be a delay in data availability between Mixpanel and the export, especially if you are exporting hourly. Late-arriving data or processing delays can cause temporary discrepancies Export Frequency.5. Unique User vs. Total Event Count: Double-check whether you are comparing unique users or total events, as this can cause apparent discrepancies Debugging Discrepancies.To troubleshoot, ensure you are: - Comparing the same report type, metric, and time frame. - Using the same filters and breakdowns in both the dashboard and the export. - Accounting for any data processing or sync delays.If discrepancies persist, try removing all filters from both the dashboard and the export to compare the raw data, then reapply filters one by one to identify where the difference arises Debugging Discrepancies.
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.
Khayalethu L. Hi! can you please share the tool you’re using?