Enter the Share Your Success Sweepstakes 2024 For the Chance to Win Great Prizes!

Segments can only pull data till 2018, but I started using CC in 2010, but can not segment them

SzilviaG
Rookie
0 Votes

Segments can only pull data till 2018, but I started using CC in 2010, but can not segment those people added 2010-2018.

 

Very disappointing as I can only segment half my list.

Top Answer
William_A
Administrator

Hello @SzilviaG ,

 

At the moment you're right, the Contact Details > Date Added segment criteria cannot go back further than 5 years ago the day of creation / refreshing. For example, you wouldn't be able to create a segment today that included Contact Details > Date Added > January 10, 2018 or sooner. 

 

That said, contacts added before 2018 are still available for your segments, depending on the segmentation types you make. For example, if you made a segment of Contact Activity > Engagement > Least Engaged AND Contact Activity > Did Not Open > Any Email > In the last > 90 days - that would still include contacts added before 2018.

 

I've tracked the general feature request for improvements to the Segmentation tool with your details and my own testing added to its notes. The only workaround I can suggest for you in the meantime would be to utilize different segmentation criteria, or possibly make a list of all contacts added before 2023 (as an example) so you can quickly have that list pulled into your criteria whenever you need it.


7 REPLIES 7
William_A
Administrator
0 Votes

Hello @SzilviaG ,

 

At the moment you're right, the Contact Details > Date Added segment criteria cannot go back further than 5 years ago the day of creation / refreshing. For example, you wouldn't be able to create a segment today that included Contact Details > Date Added > January 10, 2018 or sooner. 

 

That said, contacts added before 2018 are still available for your segments, depending on the segmentation types you make. For example, if you made a segment of Contact Activity > Engagement > Least Engaged AND Contact Activity > Did Not Open > Any Email > In the last > 90 days - that would still include contacts added before 2018.

 

I've tracked the general feature request for improvements to the Segmentation tool with your details and my own testing added to its notes. The only workaround I can suggest for you in the meantime would be to utilize different segmentation criteria, or possibly make a list of all contacts added before 2023 (as an example) so you can quickly have that list pulled into your criteria whenever you need it.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
SzilviaG
Rookie
0 Votes

Thanks for the reply! I tried that, but the problem is... if you make a segment of Contact Activity > Engagement > Least Engaged AND Contact Activity > Did Not Open > Any Email > In the last > 90 days - that would still include contacts added before 2018.

 

That it does include the 2010 contacts, but it also includes those I just added last week.

 

Ideally I want to filter those inactive people who are on my list for at least 3 months ( since I started with Constant Contact - 2010) and have not opened anything in the last 3 months. How can I achieve that?

William_A
Administrator
0 Votes

The only ay to go about doing this is by adding the segment with the suggested criteria to a list, then sorting that list by date added and manually removing those more recently added contacts.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
SzilviaG
Rookie
0 Votes

I tried that too, but when I export the list it alfabetize it 😉 So I have 11.000+ emails in random order. Is there a way to export them by date?

William_A
Administrator
0 Votes

Well, you can either sort via the UI, or if you are exporting the file you can just use whatever spreadsheet program you prefer to sort by date added.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
SzilviaG
Rookie
0 Votes

HOw can I sort them by date in xcel?

William_A
Administrator
0 Votes

I found this when doing a search for "sorting by date in Excel." My assistance on anything outside of our system is going to be limited based on service recommendation compliance. If it involves a program outside our system I'd recommend doing an internet search for it to find additional guidance and info, or utilizing the program's internal Help functionality if it has one.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
William A
Community & Social Media Support
  • 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

    Share Your Success Sweepstakes

    Share a success story from the last year and be entered for a chance to win great prizes!

    Enter now!
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