- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Aman,
Are you trying to build a workflow which targets persons who have clicked or opened a previous email?
If so you can use the tracking logs table in Adobe Campaign the SQL below shows how you can look for persons who have opened, clicked or hit the mirror page of a delivery in the last 30 days. The screen shot shows the set up for the same query.
You can qualify this further by adding in a query which specifies the name of your deliver (delivery label).
Hope that helps,
Dave.
SELECT R0.iRecipientId FROM NmsRecipient R0 WHERE EXISTS (SELECT 1 FROM NmsTrackingLogRcp T1 JOIN NmsTrackingUrl T2 ON (T2.iTrackingUrlId = T1.iUrlId) WHERE (T1.iRecipientId = R0.iRecipientId) AND (((T1.tsLog >= DaysAgo(30)) AND ((T2.iType = 2) OR (T2.iType = 1) OR (T2.iType = 6))))) LIMIT 10001