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.
Views
Replies
Total Likes
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
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)?
Views
Replies
Total Likes
Hello @god_prophet
You can use this condition
Tracking log does not exists such as
Event Date one or after 6 months ago
Views
Replies
Total Likes
@_Manoj_Kumar_ but wouldn't this exclude new recipients who were never sent an email/sms/push?
Views
Replies
Total Likes
Hi @god_prophet,
In addition to the above, you need to include the check that a delivery log should exist for the recipients in the last 'x' months.
Regards,
Ishan
Views
Replies
Total Likes
Views
Likes
Replies