Creating a Cohort from Users Based on Email Domains in CSV
I have a CSV with a list of domains. I would like to create a cohort of all users whose emails match one of those domains. How do I do this?
I have a CSV with a list of domains. I would like to create a cohort of all users whose emails match one of those domains. How do I do this?
Hi JW, 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 create a cohort of users whose emails match domains from a CSV list, you can follow these steps in Mixpanel: 1. First, upload your CSV list of domains as a user profile property. You can do this by adding a unique property to each user profile that matches a domain in your list.2. Once the property is added, you can create a cohort using the Cohort Builder in Mixpanel. Here's how: a. Navigate to the Cohorts section by clicking on the "Data Management" tab and selecting "Cohorts".
b. Click on "Create New Cohort" to open the Cohort Builder.
c. In the Cohort Builder, you'll need to set up a filter that matches user emails with the domains in your list.3. To set up the filter:
a. Choose the user profile property that contains the email (usually "$email").
b. Use the "matches regex" operator.
c. Create a regex pattern that matches the domains in your list. For example, if your domains are "example.com" and "test.com", your regex might look like this: (@example\.com|@test\.com)$4. Save your cohort with an appropriate name.This method allows you to create a dynamic cohort that will update as new users with matching email domains are added to your project.For more detailed information on creating cohorts, you can refer to the Mixpanel documentation on Cohorts.Note that this method assumes you're comfortable with regex. If you're not, or if your list of domains is very large, you might need to consider alternative approaches, such as using Mixpanel's API to create the cohort programmatically. However, the knowledge sources provided don't contain specific information about such an approach.
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! 📚
I apologize for the misunderstanding. You're right, and I can provide a more direct solution based on your clarification. Since you already have the users' emails and just need to create a cohort based on matching domains, here's a more appropriate approach: 1. First, you'll need to upload your CSV list of domains to Mixpanel as a cohort. You can do this using the Cohort Builder or by importing the list.2. Once your list of domains is in Mixpanel, you can create a cohort of users whose email domains match this list. Here's how: a. Go to the Cohorts section in Mixpanel (under Data Management).
b. Click on "Create New Cohort" to open the Cohort Builder.
c. In the Cohort Builder, set up a filter using the email property (usually "$email").
d. Use the "matches regex" operator.
e. Create a regex pattern that extracts the domain part of the email and matches it against your list of domains.3. Save your cohort with an appropriate name.For more detailed information on creating and managing cohorts, you can refer to the Mixpanel documentation on Cohorts.If you have a large number of domains or prefer not to use regex, you might consider using Mixpanel's API to create the cohort programmatically. However, the provided knowledge sources don't contain specific information about this approach.I apologize, but the knowledge sources don't provide more specific step-by-step instructions for this particular use case. If you need more detailed guidance, I recommend reaching out to Mixpanel's support team for assistance with this specific scenario.
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! 📚
I apologize for the confusion in my previous response. After carefully reviewing the knowledge sources, I realize I made an incorrect assumption about uploading a CSV list of domains directly as a cohort. Let me provide a more accurate answer based on the available information.The Cohort Builder in Mixpanel doesn't have a direct option to upload a CSV list of domains. Instead, you have a few options to work with your list of domains: 1. You can import the domains as a user profile property. According to the Mixpanel documentation on User Profiles, you can bulk import user data from a CSV file. This would allow you to add a property to users whose email domains match your list.2. Once you have the domain information as a user property, you can use the Cohort Builder to create a cohort based on that property. As mentioned in the Mixpanel documentation on Cohorts, you can "define cohorts based on a precise set of conditions" using the Cohort Builder.3. If you prefer not to modify user profiles, you might need to consider using Mixpanel's API to create the cohort programmatically. However, the provided knowledge sources don't contain specific information about this approach.I apologize again for the incorrect information in my previous response. The Cohort Builder doesn't have a direct option to upload a CSV list of domains as I initially suggested. If you need more specific guidance on how to proceed with your list of domains, I recommend contacting Mixpanel's support team for the most up-to-date and accurate information on handling this 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.
Let me check the knowledge base for you again. One moment! 📚
Yes, the Cohort Builder in Mixpanel does allow for regex (regular expressions). This capability is mentioned in the knowledge sources provided. According to the Mixpanel documentation on Cohorts, when creating a cohort using the Cohort Builder, you can use regex as part of your filtering criteria. Specifically, when setting up a filter for user properties (such as email), you can use the "matches regex" operator.For example, if you wanted to create a cohort of users whose email domains match certain patterns, you could: 1. Choose the user profile property that contains the email (usually "$email"). 2. Use the "matches regex" operator. 3. Create a regex pattern that matches the domains you're interested in.This feature allows for powerful and flexible cohort creation based on complex patterns in your user data. However, it's important to note that using regex effectively requires some knowledge of regex syntax and patterns.If you need more detailed information on how to use regex in the Cohort Builder, you might want to consult Mixpanel's specific documentation on advanced filtering options, as the provided knowledge sources don't contain step-by-step instructions for using regex in cohort creation.
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.