Filter recipients who havent opened an email in the last 6 months | Community
Skip to main content
G
god_prophet
Level 6
November 23, 2023
Question

Filter recipients who havent opened an email in the last 6 months

  • November 23, 2023
  • 1 reply
  • 991 views

how to query the nms:trackingLogRcp to filter out Recipients that have not opened an email/sms/push in the last 6 months?

I tried using a Filtering typology, but trackingLogRcp doesn't have a column to filter out Recipients who have not opened an email in X time. 


This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
November 23, 2023

Hello @god_prophet 

 

It looks like your instance is configured to retain the tracking data for 6 months only (this is the default config) and that is why you don't see anything.

You can learn more about data retention in AC here: Data retention | Adobe Campaign

Manoj  | https://themartech.pro
    G
    god_prophetAuthor
    Level 6
    December 13, 2023

    Hello @_manoj_kumar_ ,

    I discovered that the filter was wrong. It should have been : date on or after.. ans we see a record from June, we're on december.

    So how can I filter a users who have not opened an email in the last 6 months with a Typology BUT not those who are new Recipients (in the last 3 months, for example)?

     

    Manoj_Kumar
    Community Advisor
    Manoj_KumarCommunity Advisor
    Community Advisor
    December 13, 2023

    Hello @god_prophet  

     

    You can use this condition

     

    Tracking log does not exists such as

    Event Date one or after 6 months ago

    Manoj  | https://themartech.pro
    Terms & ConditionsAccessibility statement

    Loading footer...