Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

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

Avatar

Level 2

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. 

1 Accepted Solution

Avatar

Correct answer by
Level 7

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

View solution in original post

3 Replies

Avatar

Level 7

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

Level 2

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?

Avatar

Correct answer by
Level 7

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