Best and worst campaign openers

[Simone4]

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

[johnwwilcoxmba · Accepted solution]

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

[Simone4]

Thank you johnwwilcoxmba,

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

PREVIEW

[Sukrity_Wadhwa]

Hi @Simone4,

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

Thanks!