Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

How to Query Has opened at least 1 email in adobe campaign?

jameels50927727
Level 2
Level 2

Hi,

  How to Query Has opened at least 1 email in adobe campaign?please any one help me.

Thanks,

jameel.sk

1 Accepted Solution
Vapsy
Correct answer by
Employee
Employee

Hi Jameel,

You can have a setup like this.

  1. Drop a Query activity on workflow canvas.
  2. Double click on it to configure it.
  3. On the first window select Recipients as the targeting dimension and Tracking logs (Recipients) as the filtering dimension.1228826_pastedImage_1.png
  4. Select Filtering conditions and move to next screen.
  5. Set the condition as Primary Key (@id) is not equal to 0.1228827_pastedImage_2.png
  6. This will give you recipients that will have atleast one tracking log entry which corresponds to email being opened.

Hope this helps.

Regards,

Vipul

View solution in original post

2 Replies
Vapsy
Correct answer by
Employee
Employee

Hi Jameel,

You can have a setup like this.

  1. Drop a Query activity on workflow canvas.
  2. Double click on it to configure it.
  3. On the first window select Recipients as the targeting dimension and Tracking logs (Recipients) as the filtering dimension.1228826_pastedImage_1.png
  4. Select Filtering conditions and move to next screen.
  5. Set the condition as Primary Key (@id) is not equal to 0.1228827_pastedImage_2.png
  6. This will give you recipients that will have atleast one tracking log entry which corresponds to email being opened.

Hope this helps.

Regards,

Vipul

View solution in original post

MarcelSzimonisz
Community Advisor
Community Advisor

Hello Jameel,

you can also do it without filtering dimension by checking if tracking log exists where message was successfully sent and  with user action not equal to opt out.

6-13-2017 5-44-30 PM.png

BR,

Marcel