Extracting a list of users who both received and opened a transactional Welcome email | Community
Skip to main content
Level 2
September 23, 2019
Solved

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

  • September 23, 2019
  • 3 replies
  • 4733 views

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. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Anita_punmiya

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

3 replies

Anita_punmiya
Level 5
September 24, 2019

Hi Bob,

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

Hope this helps.

Anita

Level 2
September 24, 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?

Anita_punmiya
Anita_punmiyaAccepted solution
Level 5
September 25, 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