I added custom properties to user profiles to run an A/B test and I no longer need them. Other than uploading another CSV and changing the property value to "None", is there a way to bulk delete properties from user profiles?
Hi Mark N., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
Yes, you can bulk delete custom properties from user profiles in Mixpanel without uploading another CSV. The recommended approach is to use the Engage API’s $unset operation, which allows you to permanently remove specific properties from user profiles.For bulk operations, you can use the Mixpanel-utils library’s people_unset
method. This method lets you target multiple profiles and unset one or more properties in bulk. Here’s an example usage: LBKSmputils.people_unset(['property_name_to_remove'], query_params={ 'selector' : '(your selection criteria)' })LBKS
Replace 'property_name_to_remove'
with the property or properties you want to delete, and adjust the selector to target the relevant user profiles. This will remove the specified properties from all matching profiles, rather than just setting their value to "None" or a similar placeholder.For more details, see the Mixpanel-utils documentation and the Mixpanel Data Clean-Up guide.This approach is more efficient and cleaner than uploading a new CSV to overwrite property values with "None" or similar placeholders.
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.