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

SzilviaG
Regular Participant

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.

7 REPLIES 7
William_A
Moderator

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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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.
SzilviaG
Regular Participant

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?

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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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.
SzilviaG
Regular Participant

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?

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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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.
SzilviaG
Regular Participant

HOw can I sort them by date in xcel?

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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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.
  • 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