We are implementing our first Mixpanel project and we have found an issue that we don’t know if we have solved it correctly.
Our implementation has users that can login or not to use our product depending if they are in the paid tier or not, if they login, we assign them our internal User ID that comes from our CRM,.
We have been able to do the merge id properly and once a user has logged in, the internal user id shows up in the Distinct ID cluster, the problem is that the Canonical ID does not update to our internal ID and remains the random Distinct ID that Mixpanel assigned, so if for example we want to segment all our paid users that have used the product in the last month and email them a training offer, we cannot individually identify them.
The solution that we have found is to create a User Profile Property called Internal ID that, if the user is logged in, will show our internal ID and if not, the random ID that Mixpanel generates.
Is this the correct implementation?
Best answer by linyeeView original