Data discrepancies between Mixpanel cohort and integration
Sometimes, you may find that the number of users shown in your cohort in Mixpanel does not reflect the number of users in the integration partner's interface. Please see below what could be causing this and how you can find out which users were successfully exported from Mixpanel.
Discrepancies in user count
If you see a discrepancy between the count of your users in a Mixpanel cohort and in the integration partner, the first thing to check is if all your users were eligible to be exported. To match users in both systems, we require a partner ID, e.g. $braze_external_id for Braze cohort exports. You can easily confirm this by querying for your cohort in the User report, then adding the filter $braze_external_id is set. This will show all eligible users that can be exported from Mixpanel to Braze.
Inspect exported cohorts via CSV download
To find out which and how many users have been exported from your cohort to the integration partner, you can now download a CSV containing all users that have been exported. When accessing the cohort export overview by navigating to the integration in your Integrations tab, then clicking on the cohort, you will be navigated to this overview:
You will find a summary of the total count of users exported and removed and a CSV download button. In the CSV, you can find the list of distinct_ids of the users in the export and an operation
column. This operation
column can contain one of three values; add
when the user profile was newly added to the cohort, remove
when the user was removed from the cohort and no-op
when the user remains in the cohort. In the column next to the distinct_id, you will see the partner ID for that user. If the numbers between Mixpanel and the integration partner mismatch, you can confirm if a user has been exported by looking at the CSV file.
Export is paused
If you notice your cohorts are not being exported, you can view the reason for the pause in your Integrations tab. When accessing the integration, you will see the status (either Active or Paused). If the status says Paused, you can hover over the Paused text to see the reason for the pause:
Some integrations have common pause reasons (e.g. Facebook's authentication pause). You can usually resolve the paused reason on your side by confirming the authorization for the integration is still valid, and dis- and reconnecting.
Comments
Please sign in to leave a comment.