I need to display the following data on the Mixpanel widget: How many customers we have per week in the last 3 months, but each customer has a different number of users, and I don't need to take it into account. If at least 1 user triggered a specific event = this customer has been active in the specific week. Suggest a non-coding solution to create such a widget.
Hi Ilya L., 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 achieve your goal—displaying the number of active customers (accounts) per week over the last 3 months, where a customer is considered active if at least one user triggered a specific event in a given week—you can use Mixpanel’s Group Analytics and Account Analytics features. Here’s a non-coding, UI-based solution: 1. Ensure Group Analytics is Enabled Make sure your Mixpanel project has Group Analytics enabled and that you have set up a group key (e.g., “company_id” or “account_id”) to represent your customers. This allows you to analyze data at the account/customer level rather than the individual user level. More on Group Analytics2. Create an Insights Report - Go to the Insights report in Mixpanel. - Select the specific event that defines customer activity (e.g., “Logged In”, “Purchase”, etc.). - Set the time range to the last 3 months. - Set the interval to “Week”.3. Change the Counting Method to Unique Groups - In the report, look for the “Unique Users” dropdown (usually above the query builder). - Change the measurement from “Unique Users” to “Unique [Group Identifier]” (e.g., “Unique Companies” or “Unique Accounts”). This will count each customer only once per week, regardless of how many users they have or how many times the event was triggered. - This ensures that if at least one user from a customer triggers the event in a week, that customer is counted as active for that week.4. Visualize the Data - The resulting chart will show you the number of active customers per week for the last 3 months. - You can further customize the visualization (e.g., line or bar chart) as needed.No coding is required for this workflow; it’s all achievable through Mixpanel’s UI, provided you have Group Analytics set up. This approach directly matches your requirements: it counts each customer once per week if any user from that customer is active, regardless of the number of users per customer.For more details, see the documentation on Group Analytics and Account Analytics.
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 do not have Group Analytics enabled, Mixpanel does not natively support aggregating users into "customers" or "accounts" for reporting purposes, since this functionality relies on the Group Analytics feature and the use of a group key (such as company_id or account_id) to represent each customer. Without Group Analytics, Mixpanel’s standard reports (like Insights) only allow you to count unique users, not unique customers/accounts, based on user-level data.The knowledge sources do not provide a non-coding, UI-based solution for counting unique customers per week without Group Analytics. All documented solutions for account-level aggregation require Group Analytics to be enabled in your project. If you need this functionality, you may need to contact your Mixpanel account representative to discuss enabling Group Analytics for your workspace, as suggested in the documentation and blog posts about account-level analytics and company health metrics Mixpanel Account Analytics: Insights for B2B product and customer success teams Company health and activation metrics.I'm sorry, but without Group Analytics, there is no supported way in Mixpanel’s UI to create a widget that counts unique customers (regardless of user count) per week.
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, Mixpanel’s standard interface allows you to create Custom Events by combining multiple events or filtering events by properties. However, Custom Events operate at the event and user level—they do not provide a way to aggregate or deduplicate by a "customer" or "account" identifier unless you have Group Analytics enabled.Custom Events can be used to merge or filter events (e.g., “User Signup” + “Account Created” → “Signup”), but they do not support logic like “if at least 1 user per customer, display 1; else 0” at the customer/account level in the standard UI. The aggregation you describe (per customer, regardless of user count) is not possible without Group Analytics, as Mixpanel’s standard reports and custom events only operate at the user and event level, not at a higher grouping level like customer or account Custom Events: Combine multiple events for analyses.Therefore, it is not possible via the standard Mixpanel interface to create a custom event or report that displays 1 if at least one user per customer is active, and 0 otherwise, without Group Analytics. The knowledge sources do not mention any workaround for this scenario in the standard UI.
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! đź“š
Certainly! Here’s a step-by-step guide to setting up Group Analytics in Mixpanel, based on the current documentation: ---
1. Define the Group Key in Project Settings
- Go to your Mixpanel Project Settings.
- Find the Group Keys section.
- Click +Add Group Key.
- Enter the event property you want to use as your group key (e.g., company_id, account_id, etc.).
- Optionally, set a display name for the group key.
- Click Save.> Note: The group key must be set up before you send group data. Property names and values are case-sensitive, so ensure you use the exact name in your tracking code as you set here
See more details---
2. Send Events with the Group Key as an Event Property
- When tracking events, include the group key as an event property, with the value being the group ID (e.g., the specific company or account identifier).
- For example, if your group key is company_id, your event should look like:
```LBKSLBKS- If you want to attribute an event to multiple groups, pass the group key value as a list: LBKS
```LBKS mixpanel.track("Some Event", { company_id: ["12345", "67890"] });
```LBKSLBKS> **Only events with the group key property will be attributed to a group. Historical data before the group key was set up will not be backfilled.**
[More info](https://docs.mixpanel.com/docs/data-structure/group-analytics#implementation)LBKS---
3. (Optional) Set Up Group Profiles
- You can set group profile properties (like company size, industry, etc.) using your SDK’s group profile methods. - For example, in JavaScript:
name: 'Acme Corp',
industry: 'Manufacturing'
});
```LBKSLBKS> **Group profiles allow you to store and analyze group-level attributes, similar to user profiles.**
[See Group Profiles](https://docs.mixpanel.com/docs/data-structure/group-analytics#group-profiles)LBKS---
4. Analyze by Group in Reports
- In Mixpanel reports (like Insights), use the Analyze Uniques by dropdown above the query builder.
- Select your group key (e.g., company_id) to view metrics at the group level instead of the user level.---
5. Verify Your Setup
- Trigger some events with the group key property. - Go to the Users section, select your group identifier, and confirm that group profiles and group-level analytics are appearing as expected.---If you follow these steps, you’ll have Group Analytics set up and ready to use in Mixpanel. If you need SDK-specific code, refer to the implementation section for links to each SDK’s guide.If you have any trouble or don’t see the group key option, double-check that your plan includes Group Analytics and that you’ve saved your group key in Project Settings.
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! đź“š
No, you cannot simply utilize an existing user property for Group Analytics without updating your code to send it as an event property. According to the documentation, for Group Analytics to work, the group key (e.g., company_id, account_id) must be sent as an event property on every event you want attributed to a group. Having the group key as a user profile property is not sufficient—Mixpanel will not attribute events to groups based on user properties alone.> The group key property must be present as an event property on an event in order to attribute them to a group profile.
Having the group key present as a user profile property does not automatically attribute the events by that user to the group. Docs / Data-structure / Group Analytics: FAQIf your events are not already being sent with the group key as an event property, you will need to update your tracking implementation to include it.
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.