Forum Discussion

juliali's avatar
juliali
Practitioner
2 years ago

Sending email to CSV

I'm very new to Braze and trying to figure things out. I did User Import and uploaded a list of 50 people. It says 50/50 success below.

When I create a segment and choose this list it now says I only have 31 people on this list. Why is this? Is there a way in Braze to send an email to the exact people on a CSV? 

Segmentation
  • EmilyCalderon's avatar
    EmilyCalderon
    Icon for Community Manager rankCommunity Manager
    2 years ago

    Hi juliali!

    When I want to send an email to a specific list of emails I create a segment by 'select email address matches regex', and then list out the email addresses. The email addresses should be separated by a '|', so I add them to a google sheet and then use =join(“|”,A1:AX) to merge them all together if there are many emails. 

    Hope this helps! 

  • Max's avatar
    Max
    Specialist
    2 years ago

    Hey Julia,

    there might be several reasons why you have only 31 people in the segment. When you upload a CSV file, you need to include an "external_id" or "public_id". If the user does not exist, it will create a new user. If you don't have an external_id you can use "user_alias_name" and "user_alias_label". From the Braze documentation: "An alias serves as an alternative unique user identifier, and can be helpful if you are trying to market to anonymous users who haven’t signed up or made an account with your app."

    If you have doubled email addresses or doubled external_ids in your list this can reduce the total amount of people in the segment. However, it's hard to say why you have only 31 people in the segment without any details to the segment creation and the CSV file. Maybe some of them don't have an external_id? Then you have to use an alias name.

    I would suggest to create the segment directly with the CSV import. You can do it by enabling "Import users in this CSV and also make it possible to retarget this specific batch of users as a group." and "Automatically generate a segment from the users who are imported from this CV." during the upload process.

    If you have further questions or need further help, please share more details of your CSV file and the Segment settings.

    Hope that helps 🙂