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

Avatar

Avatar
Validate 1
Level 2
jameels50927727
Level 2

Likes

3 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
jameels50927727
Level 2

Likes

3 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
jameels50927727
Level 2

12-06-2017

Hi,

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

Thanks,

jameel.sk

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

13-06-2017

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

Answers (1)

Answers (1)

Avatar

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

103 likes

Total Posts

227 posts

Correct reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

103 likes

Total Posts

227 posts

Correct reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile
MarcelSzimonisz
MVP

13-06-2017

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