Hi all, I uploaded a CSV to Mixpanel with two columns: distinct_id and Poly_alloted_2. Out of ~14,000 users, only around 6,000 profiles show the Poly_alloted_2 value. The remaining ~8,000 show it as undefined ,even though the CSV has valid values for all rows, and all distinct_ids exist in the user profiles. Both fields were mapped correctly during import. Would really appreciate any help if someone has faced this or knows what might be going wrong.
Hi Mounesh- Julianne from Mixpanel Support here.
The CSV user profile expects $distinct_id
as the column name, rather than distinct_id
. If you don't include a $distinct_id
column, it will be generated randomly for each profile. This would cause the Poly_alloted_2
property not to be applied to the expected users.
If you did upload the column as $distinct_id
, I would expect the property to be applied to the specified user. If that didn't occur, can you reach out directly to Support via our webform? This will allow troubleshooting specific to your project.
When you submit the ticket, it would be helpful if you included examples of the users that received and didn't receive the update, along with the CSV that was uploaded.