What is the template file look like for User Profile to import from CSV
Based on the knowledge sources provided, I can answer your question about the template file for importing User Profiles from CSV in Mixpanel.According to the User Profile documentation, when preparing a CSV file for bulk import of User Profiles, you should not include column headers in the CSV file itself. The column headers will be identified through the CSV upload wizard in the Mixpanel UI.Here's what you need to know about the CSV structure:1. The CSV should not contain column headers (e.g., email, etc.).
2. The most important column is the $distinct_id
for user profiles (or $group_id
for Group Profiles).
3. Other columns can include additional profile properties.An example of what the CSV content might look like (without headers):LBKSc994bb,Drake,Pop,True,Hotline Bling,2015-10-18T22:00:00Z d8d949,Gipsy Kings,Flamenco,False,Bamboleo,1987-07-12T05:00:00Z a43fb8,Daft Punk,House,False,Aerodynamic,2001-03-12T07:30:00ZLBKS
In this example, the first column would be mapped to $distinct_id
during the import process, and the subsequent columns would be mapped to other profile properties.Remember that you'll identify the column headers and map them to the appropriate Mixpanel properties during the CSV upload process in the Mixpanel UI.It's also worth noting that there's a limit of 1M rows for the CSV file size.User Profile documentation provides more detailed information on the import process and considerations.
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.