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

[SzilviaG]

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.

[SzilviaG]

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]

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.

[SzilviaG]

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]

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.

[SzilviaG]

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]

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.

[SzilviaG]

HOw can I sort them by date in xcel?

[William_A]

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.