Filter User IDs in Reports Using Lookup Table Techniques
I have a lookup table and I want to filter User IDs in a report by the User Ids in my lookup table
I have a lookup table and I want to filter User IDs in a report by the User Ids in my lookup table
I'm sorry, but according to the knowledge sources, you cannot use a Lookup Table to filter User IDs in a report by the User IDs in your lookup table. Specifically, mapping a Lookup Table to the $distinct_id (User ID) property is not supported. If you want to filter or enrich user data by User ID, you should use User Profiles instead. To create a user property for a profile, upload it as a user property directly, not via a Lookup Table Lookup Tables FAQ.If you have a list of User IDs and want to create a cohort or filter by them, the recommended approach is to bulk update user profiles with a new property (e.g., via CSV import), and then use that property to define your cohort or filter in reports Users: Explore your user base in Mixpanel.In summary:
- Lookup Tables cannot be mapped to User IDs for filtering.
- Use User Profiles and cohorts for filtering by User ID.
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.
Let me check the knowledge base for you again. One moment! 📚
If you bulk update user profiles with a new property (for example, to help with filtering or cohort creation), you can later delete this property from the user profiles using the Engage API’s $unset operation. This can be done programmatically by sending a request to the /engage#profile-unset endpoint, specifying the property or properties you want to remove.Here’s a summary of how to do this: - Use the $unset operator to remove one or more properties from user profiles.
- You can do this via the Engage API by sending a JSON payload with the $token, $distinct_id, and an array of property names to $unset.**Example request body::**LBKS```LBKS[
{
"$token":: "YOUR_PROJECT_TOKEN",
"$distinct_id": "USER_ID",
"$unset": ["property_to_remove"]
}
]```You can batch this operation for multiple users by including multiple objects in the array Ingestion API - User Profiles / profile-delete-property.Alternatively, if you are using the mixpanel-utils Python library, you can use the people_unset method to remove properties from multiple profiles at once Mixpanel-utils: Unset properties.This approach allows you to clean up any temporary or bulk-added properties after you are done using them Data Clean-Up.
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.
Let me check the knowledge base for you again. One moment! 📚
Based on the knowledge sources, deleting a user property (i.e., unsetting a property from user profiles) cannot be done directly through the Mixpanel UI. The recommended methods are to use the Engage API with the $unset operation or the people_unset method in the mixpanel-utils library to remove properties from user profiles programmatically Data Clean-Up profile-delete-property.There is no mention in the documentation of a UI-based option for bulk unsetting or deleting user properties from profiles. If you need to remove a property from many profiles, you will need to use one of the programmatic approaches.
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.
Let me check the knowledge base for you again. One moment! 📚