Got a 'How do I' question? Join 'Ask a Trainer' Monday to Friday, 11am to 4pm ET for instant help and pro tips!

Segmenting large lists prior to sending

SOLVED
Go to solution
JayM4501
Rookie
0 Votes

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
Administrator

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

View solution in original post

2 REPLIES 2
William_A
Administrator

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
JayM4501
Rookie
0 Votes

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

  • Avatar

    Featured Article

    Use Sections to Build Email Campaigns Faster and Improve Engagement Rates

    Using Sections while designing your marketing email not only increases your own efficiency but helps you to deliver a more friendly, organized message. Check out some of the key benefits of using sections in email.

    See Article
  • Avatar

    Featured Thread

    Casual Conversations: What's your go-to playlist?

    If you listen to music while you work, share your playlist below so we can be inspired and maybe find some new music!

    View thread
  • Avatar

    Featured Thread

    Ready, Set, Send Reflections

    The Ready, Set, Send Challenge has finished! Let's reflect on the wins and accomplishments over the last six weeks.

    Join challenge
Updates
Just Getting Started?

We’re here to help you grow. With how-to tutorials, courses, getting-started guides, videos and step-by-step instructions to start and succeed with Constant Contact.

Start Here

73% of SMBs express doubt that their marketing strategy is effective. Does this sound familiar? Read our Small Business Now Report to learn how you can tweak your strategy to see better results.

Go read our article
Upcoming Webinars
DEC 12
Ask Us Anything: Your Digital Marketing Questions Answered
2PM - 3PM EST