kapa.ai how can I add an ability to break down by user email domains in reports ?
To break down your reports by user email domains, you would need to have the email domains as a property in your user profiles or events. If you have this, you can use the Breakdown feature in Mixpanel's reporting tools. Here's how you can do it:1. In your report, click the Breakdown button. 2. In the dropdown menu, select the property that represents the user email domains.Please note that the dropdown menus only show events/event properties that were ingested within the last 30 days. If the email domain property has not been ingested in the last 30 days, you would need to type the exact name of the property in the Breakdown search bar. Keep in mind that property names are case sensitive.If you don't have the email domains as a property, you would need to add this to your tracking implementation. Once the property is being sent to Mixpanel, you can use it for breakdowns in your reports.For more information, you can refer to the Mixpanel documentation on Advanced Filter & Breakdown Usage.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.
Let me check the knowledge base for you again. One moment! đź“š
To create a property that automatically parses the domain from the email, you can use Mixpanel's custom properties feature. Here's a step-by-step guide:1. Click the plus button to the right of the search bar, then select User Property to open the property builder.
2. Give your property a name and click into the formula bar to start defining it.
3. Use the parse_url()
function to extract the domain from the email address. The parse_url()
function extracts the part of the URL that is specified: domain or full_domain. Here's an example of how you might use it:LBKSparse_url(user.email, "domain")LBKS
This will extract the domain from the user's email address.4. Click Apply to save the custom property locally to the report. To save the custom property permanently for use in other reports and to make it usable by other project members, click Save.Please note that the formula used to compose your custom property can’t be longer than 20,000 characters.For more information, you can refer to the Mixpanel documentation on creating a custom property and the Mixpanel documentation on the parse_url() function.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.