Segmenting large lists prior to sending

SOLVED
Go to solution
JayM4501
Occasional Participant

How does one group a large list of email addresses into many small groups, eg., of 10 in each group? These groupings would not be based on any particular characteristics as in "segments" but rather more manageable chunks for personalization. Thank you. 

1 ACCEPTED SOLUTION
William_A
Moderator

Hello @JayM4501 ,

 

There isn't really a way to do this in-product that wouldn't be just going through, selecting contacts individually, and then moving them into a newly made list with each selected group.

 

You could potentially do this through a spreadsheet program a little quicker:

  1. Export your big contact list, and download it. You only really need the email addresses, since that's what denotes a unique contact, and a reupload of existing contacts with just emails will avoid changing any other contact data.
  2. Open the downloaded file in your preferred spreadsheet program (Excel, Numbers, Google Sheet, etc.)
  3. Highlight a selection of contacts, copy and paste them into a new spreadsheet. Save this spreadsheet with an identifiable name, such as the name of the new list you'll be making for it, or something generic like SMALLER LIST 1. Close out of that new list spreadsheet, and open another new, blank one. Repeat this process until you've split up your larger list completely.
  4. Upload those smaller list files, and add them to newly made lists each time.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Did I answer your question? If so, please mark my post as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

Anyone can be a marketer! Visit our Blog & Resources page to brush up on the latest tips and tricks.

View solution in original post

2 REPLIES 2
William_A
Moderator

Hello @JayM4501 ,

 

There isn't really a way to do this in-product that wouldn't be just going through, selecting contacts individually, and then moving them into a newly made list with each selected group.

 

You could potentially do this through a spreadsheet program a little quicker:

  1. Export your big contact list, and download it. You only really need the email addresses, since that's what denotes a unique contact, and a reupload of existing contacts with just emails will avoid changing any other contact data.
  2. Open the downloaded file in your preferred spreadsheet program (Excel, Numbers, Google Sheet, etc.)
  3. Highlight a selection of contacts, copy and paste them into a new spreadsheet. Save this spreadsheet with an identifiable name, such as the name of the new list you'll be making for it, or something generic like SMALLER LIST 1. Close out of that new list spreadsheet, and open another new, blank one. Repeat this process until you've split up your larger list completely.
  4. Upload those smaller list files, and add them to newly made lists each time.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Did I answer your question? If so, please mark my post as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

Anyone can be a marketer! Visit our Blog & Resources page to brush up on the latest tips and tricks.
JayM4501
Occasional Participant

Thank you for letting me know how to do what I asked. Happy holidays. 

  • Support Tips

    Reporting Metrics

    "Authenticating your emails is the best way to ensure your emails achieve maximum deliverability. If you have your own domain, setting up self-authentication is especially important! " - Will

    See Article
    Avatar
  • Support Tips

    Call-To-Action Links

    "Target your most engaged contacts by creating a segment. Create a special offer or show your appreciation!" - Caitlin

    See Article
    Avatar
  • Support Tips

    Read Before You Send a Test Email

    "Did you know? You can send unlimited test emails to your verified email address, but only 50 in a 24-hour period to non-verified email addresses." - Nick

    See Article
    Avatar