I’ve checked the number of users in Users section. ‘Users with profiles’ are 110k. All ‘Users’ are over 1 mln. I’ve downloaded CSV files of both databases. The users of ‘Users’ that are not in ‘Users with profiles’ do have distinct ID. But when I create dashboards or filter users that have commited particular event, only ‘Users with profiles’ are shown. How can I make dashboards that takes into account ALL users?
Hi Islam U., 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
In Mixpanel, the distinction between "Users with profiles" and "All Users" is important:
- Users with profiles: These are users who have at least one user profile property set. - All Users: This includes anyone who has triggered an event, even if they do not have a user profile.
When you create dashboards or filter users based on events, Mixpanel typically joins event data with user profiles using the distinct_id. However, if a user has only triggered events and does not have a user profile, they may not appear in certain user-based reports or dashboards that rely on profile properties or the "User Profiles" view. This is why you see only 110k users (with profiles) in your dashboards, even though there are over 1 million total users who have triggered events.
How to include all users in dashboards:
- In the Users page, you can select All Users to see everyone who has triggered an event, not just those with profiles. However, most Mixpanel reports and dashboards (like Funnels, Retention, or Insights) are based on events and should, by default, include all users who have triggered those events, regardless of whether they have a profile.
- If you are filtering or segmenting by user profile properties, only users with profiles will be included. To ensure all users are included, avoid using filters or breakdowns based on user profile properties—filter or segment by event properties instead.
- If you want all users to have profiles (so they appear in both types of reports), you can bulk create user profiles for all users by importing a CSV or using the API to set at least one property for each user. This will ensure every user with a distinct_id has a profile and will appear in both "Users with profiles" and event-based reports. See the User Profiles documentation for more on importing profiles.
Summary: - Reports based on events (not user profile properties) should include all users who have triggered those events, even if they do not have a profile. - If you need all users to have profiles for consistent reporting, consider bulk-creating profiles for users who currently lack them.
For more details, see the Mixpanel documentation on Users and User Profiles.
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.
