I have a list of phone number of users in the app. Those numbers have a profile in mixpanel. They are around 1000 Phone numbers, is there a way that I can create a cohort and bulk specify or build upload those numbers to be included in that cohort. Because if I want to create a cohort manually and specify number by number its gonna take a long time
Hi Ibrahim M., 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
Yes, there is a way to create a cohort in Mixpanel by bulk uploading a list of phone numbers. You can do this by importing user profiles with a specific property that you can then use to create a cohort. Here's how you can accomplish this: 1. First, prepare a CSV file with two columns: one for the phone numbers and another for a unique property that will identify this group of users.2. Import the user profiles using the CSV file. You can do this via the Mixpanel UI as described in the User Profile documentation. Make sure to set the $phone property for the phone numbers and add a custom property (e.g., "SpecialGroup = PhoneList") to identify these users.3. After importing the profiles, you can create a cohort based on this custom property. Here's a step-by-step guide: 1. Navigate to the Cohorts page in Mixpanel.
2. Click on "Create New Cohort" or use the Cohort Builder.
3. Set up a filter for the custom property you added (e.g., "SpecialGroup equals PhoneList").
4. Save the cohort with an appropriate name.This method allows you to quickly create a cohort with all the phone numbers you've imported, without having to manually enter each number.For more detailed information on creating cohorts and importing user profiles, you can refer to these Mixpanel documentation pages: Cohorts: Group users by demographic and behavior
User Profile: Demographic attributes for your usersBy following this approach, you can efficiently create a cohort with your list of 1000 phone numbers without the need for manual entry.
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.
in my case what would be the formula ?
kapa.ai in my case what would be the formula
Let me check the knowledge base for you again. One moment! đź“š
Based on the previous conversation and your current question, I understand you're asking about the specific formula or steps to create a cohort in Mixpanel using a list of phone numbers. Here's a more detailed breakdown of the process: 1. Prepare your CSV file:
- Column 1: $phone (for the phone numbers)
- Column 2: A custom property, let's call it BulkUploadGroup Your CSV might look like this (without headers):
+1987654321,PhoneListCohort
```LBKSLBKS2. Import the CSV:
Follow the steps outlined in the [User Profile documentation](https://docs.mixpanel.com/docs/data-structure/user-profiles#bulk-import-from-csv) for bulk import from CSV. Make sure to map the columns correctly:
- Map the first column to the `$phone` property
- Map the second column to your custom property `BulkUploadGroup`LBKS3. Create the cohort:
- Go to the [Cohort Builder](https://docs.mixpanel.com/docs/users/cohorts#creating-cohorts)
- Set up a filter: `BulkUploadGroup equals PhoneListCohort`LBKSThe "formula" for your cohort would essentially be: LBKSLBKS```LBKSUsers where BulkUploadGroup = "PhoneListCohort"LBKS```LBKSLBKSThis will create a cohort containing all the users whose profiles were updated with the `BulkUploadGroup` property set to "PhoneListCohort" during your CSV import.LBKSRemember, you need to choose property names that make sense for your use case. The key is to use a unique identifier in your CSV that you can then use to filter and create your cohort.LBKS[Cohorts: Group users by demographic and behavior](https://docs.mixpanel.com/docs/users/cohorts) provides more detailed information on creating and managing cohorts in Mixpanel.
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.