Excluding Specific IDs from Analytics Reports in identify()
In the identify() I receive an id only. I want to exclude some of these Ids from the analytics when making my reports. How can I tag them or put into a list to ignore those ids?
In the identify() I receive an id only. I want to exclude some of these Ids from the analytics when making my reports. How can I tag them or put into a list to ignore those ids?
Hi Nadine T., 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
To exclude specific user IDs from your Mixpanel analytics reports, you have a couple of options, depending on your use case:
1. Tagging Users with a Property
You can tag the users you want to exclude by setting a custom user property (e.g., exclude_from_analytics: true) when you identify them. Later, you can filter out these users in your reports by excluding users with this property set.**Example:** js mixpanel.identify('USER_ID'); mixpanel.people.set({ 'exclude_from_analytics': true });LBKSThen, in your Mixpanel reports, add a filter to exclude users where exclude_from_analytics is true.
2. Filtering by User Profile Properties in Data Views
If you are on an Enterprise plan, you can use Data Views to filter out users based on user profile properties. For example, you can create a Data View that excludes users with certain IDs or with a specific property set, and assign this view to your team or reports. This approach is scalable and doesn't require manual filtering each time you build a report.> You can add data views within your project settings. A combination of filters can be applied depending upon the data access required:
- User Profile Properties - filter explicit users based on their user property value (example: Staff User = true) Plan Data Access and Visibility
3. Excluding IDs in JQL or Custom Reports
If you use JQL (JavaScript Query Language) for custom queries, you can filter out users by their IDs directly in your query logic.Example:Note: There is no built-in "ignore list" for user IDs in Mixpanel, but using user properties or Data Views provides a robust way to filter out unwanted users from your analytics. If you want to block these users from being tracked at all, you would need to implement logic in your code to prevent sending events for those IDs.If you need to filter out bot traffic, you can use the $ignore property when tracking events, but this is typically for event-level exclusion, not user-level exclusion. See Block unwanted bot traffic for more details.If you need more advanced or automated exclusion, consider reaching out to Mixpanel support for guidance tailored to your specific use case.
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.
I need to do it in Mixpanel, not in the code.
Can I add those profile properties manually?
Let me check the knowledge base for you again. One moment! 📚
Yes, you can manually identify users by their ID and add a property like isEmployee directly in Mixpanel using the UI. Here’s how you can do it: 1. Go to the Users Page:
Navigate to the Users page in your Mixpanel project.2. Add/Edit Profile:
Click on Add/Edit Profile. This allows you to create or update user profiles manually.3. Set the Identifier:
Enter the user’s $distinct_id (the ID you want to tag).4. Add the Property:
Add a new property, for example, isEmployee, and set its value (e.g., true).5. Save the Changes:
Save the profile. The property will now be associated with that user.You can repeat this process for each user you want to tag. Later, you can filter or exclude these users in your reports by using the isEmployee property.For bulk updates, you can also import a CSV with a list of user IDs and the property you want to set. When uploading, assign $distinct_id to the ID column and isEmployee to the property column. This will update or create profiles with the specified property for each user in the CSV. Note that if a $distinct_id does not match an existing user, a new user will be created with that ID Creating a Cohort via a CSV | Importing Profiles via the UI.Once tagged, you can easily filter out these users in your Mixpanel reports by excluding users where isEmployee is true.
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.