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

Extracting a list of users who both received and opened a transactional Welcome email

Avatar

Avatar
Validate 1
Level 1
bob_digital
Level 1

Likes

4 likes

Total Posts

4 posts

Correct Reply

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

Avatar
Validate 1
Level 1
bob_digital
Level 1

Likes

4 likes

Total Posts

4 posts

Correct Reply

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

23-09-2019

Hello,

Every step of the way we have been encountering errors here.  We are trying to export a list of customers that have both received and opened a Welcome email.  We can query the data in both the Recipients and Tracking Log tables, but we cannot seem to intersect the audience and the Export activity does not seem to do anything.  Any help with how to approach this problem?

Thank you, in advance. 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
Anita_p
MVP

Likes

117 likes

Total Posts

118 posts

Correct Reply

28 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Validate 1
MVP
Anita_p
MVP

Likes

117 likes

Total Posts

118 posts

Correct Reply

28 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
Anita_p
MVP

24-09-2019

Yes Bob. You can export the records from the same wf into a list or on your local as well.

This link might be helpul:

Exporting data

Thanks,

Anita

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
MVP
Anita_p
MVP

Likes

117 likes

Total Posts

118 posts

Correct Reply

28 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Validate 1
MVP
Anita_p
MVP

Likes

117 likes

Total Posts

118 posts

Correct Reply

28 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
Anita_p
MVP

23-09-2019

Hi Bob,

You can query on Recipient Delivery Logs and use below expression :

Screen Shot 2019-09-24 at 2.39.59 pm.png

Hope this helps.

Anita

Avatar

Avatar
Validate 1
Level 1
bob_digital
Level 1

Likes

4 likes

Total Posts

4 posts

Correct Reply

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

Avatar
Validate 1
Level 1
bob_digital
Level 1

Likes

4 likes

Total Posts

4 posts

Correct Reply

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

24-09-2019

Thank you for this information.  My next question then is, how best can I export this data?  Can I export it directly from the workflow?