Expand my Community achievements bar.

SOLVED

Retargeting non - openers - Adobe Campaign classic

Avatar

Level 3

Hello Masters of Adobe Campaign,

 

I am trying to create a workflow that will send an email to an audience. If the audience does not open the email after 2 days, another reminder email will be sent. If the reminder email is not going to be opened by the same audience, the 3rd email will be sent to the same audience prompting for opening.

My workflow does not work correctly, and I am seeking help and correct logic.

 

I will really appreciate any insights.

 

Thank you,

1 Accepted Solution

Avatar

Correct answer by
Level 2

You will need to query the recipients from the prior delivery and ensure that an "open" or "click" tracking log event does not exist from that delivery.

 

  1. Set up the Reminder Workflow to query the recipients from that delivery 3 days prior with a status equal to "sent."
  2. In the same query activity, use the "does not exist such as" operator for the trackingLogs where the delivery equals the one sent 3 days ago, and the Url type equals  "Open" or "Email Click."

Repeat the above steps to create the 3rd email.

View solution in original post

5 Replies

Avatar

Correct answer by
Level 2

You will need to query the recipients from the prior delivery and ensure that an "open" or "click" tracking log event does not exist from that delivery.

 

  1. Set up the Reminder Workflow to query the recipients from that delivery 3 days prior with a status equal to "sent."
  2. In the same query activity, use the "does not exist such as" operator for the trackingLogs where the delivery equals the one sent 3 days ago, and the Url type equals  "Open" or "Email Click."

Repeat the above steps to create the 3rd email.

Avatar

Level 9

What @mattLiddy said above
Also be aware that email clients like Yahoo and the new changes from Apple iOS15 MPP update will "pre-fetch" the tracking pixel when the email is received, so it will appear as if the email has been opened but it has only been delivered. You might want to factor in these clients to your strategy.
https://www.validity.com/blog/how-will-apples-mail-privacy-protection-in-ios-15-affect-email-marketi...

Cheers

Darren

Avatar

Community Advisor

Hi @MarioGlad ,

 

Here's how you can design your workflow.

1) Take query activity and keep targeting and filtering dimension as 'nms:Recipients'.

2) Query as shown below:

Jyoti_Y_0-1633610299672.png

 

3) Schedule your workflow to trigger after two days or you can put a wait activity of two days.

4) For delivery on 3rd day, same way design your workflow to look for non openers of delivery sent after two days. In this way, you will cover all the recipients who had not opened 'delivery1' and 'delivery2'.

 

Thanks,

Jyoti

Avatar

Level 6

Sorry but really a bad idea:
good practice is to target active users from the last 6 month (and 3, in the teddy bear world). In other term, to target people that, at least opened, your email. (actual good pratice is too target only clickers as the open tracking is less and less accurate. See my colleagues' answers for the technical explanation)

targetting people that provide no click/opening will lead to more SPAM/complaints & spamtrap and will lead to loss of ISP reputation: you'll send then less emails per hour).
With a such targetting politic there's 2 options:
1- using a dedicated pool of IPs and a dedicated subdomain that will always have a bad ISP reputation... But you won't have deliverability issue on your main sendings
2- calculate the max amount of targets and try to send the email when you recieve the most tracking activity of your users in order to mitigate the "bad points" from the main ISPs

Now if that's ok on your marketing project (the aboves are functionnal recommandations, not technical ones) and you still have green lights

You can do like this:
1- assign 2 different deliveryCode to your templates for email 1, 2, 3
2- for workflow on email 2, query your main audience, use a split activity and use this filter:
* TrackingLog doesn't exist such as
     > [delivery/@deliveryCode] equal to "xxxxx"
     > @date after DaysAgo(2)
* BroadLog exist such as
 > [delivery/@deliveryCode] equal to "xxxxx"
 > @eventDate after DaysAgo(2)
 > @Status equal sent
 
3- for workflow on email 3, query your main audience, use a split activity and use this filter:
 * TrackingLog doesn't exist such as
     > [delivery/@deliveryCode] in "xxxxx", "yyyyy"
     > @date after DaysAgo(4)
* BroadLog exist such as
 > [delivery/@deliveryCode] equal to "yyyyy"
 > @eventDate after DaysAgo(2)
 > @Status equal sent

If something is not clear, don't hesitate to ask

Avatar

Administrator

Hi @MarioGlad,

Were you able to resolve this query with the help of any of the given solutions or do you still need more help here? Do let us know.
Thanks!



Sukrity Wadhwa