Script to update Mixpanel user identity for historical data • Find all device IDs associated with each event-level attribute userid • Identify the oldest device ID for each user • Link all device IDs to the canonical user ID (which is the event-level attribute userid) • Set the user profile using the oldest device's profile data for attributes like initial UTM source, etc. please confirm if this script flow works or if anyone has other suggestions
Anyone ?
Hi Shrikant- Julianne from Mixpanel Support here. Historical event data in Mixpanel is generally immutable. This means to update the historical data, you would need to extract, transform, and load it as well. Is that included in the script? Would you be uploading the data to a new project? Is there a reason that the device ID isn't associated with the known userid? If following the recommended user flows (ie seen here for Original ID Merge), then the deviceid should be associated with the canonical ID. Can you also share what version of ID management the project is on? You can see this in the 'Identity Management' tab of the project settings. Looking forward to your response!