Best and worst campaign openers | Community

Solved

Best and worst campaign openers

Forum|Forum|4 years ago
October 1, 2021
2 replies
1505 views

Hi everyone,

Does someone know if it's possible to download from Campaign a file (csv, txt, ...) containing a list of the recipients (eg. emails) and the deliveries opened by each of them? Consider that our campaigns are sent mostly to the same customer base, so we want to know who are "the best and the worst openers".

Thank you

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 JohnWi12

In a workflow I do the following to get number of opens per profile:

Query profile
Add tracking logs as additional data
Choose type =aggregate
CountDistinct([delivery/@name])
Filter Type Opens

Extract File and Transfer File

JohnWi12Accepted solution

Level 5

In a workflow I do the following to get number of opens per profile:

Query profile
Add tracking logs as additional data
Choose type =aggregate
CountDistinct([delivery/@name])
Filter Type Opens

Extract File and Transfer File

Thank you johnwwilcoxmba,

I'll come back to you once I create the workflow.

Community Manager

Community Manager

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!

Sukrity Wadhwa