Expand my Community achievements bar.

SOLVED

Best and worst campaign openers

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Level 6

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

View solution in original post

3 Replies

Avatar

Correct answer by
Level 6

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

Avatar

Level 1

Thank you johnwwilcoxmba,

 

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

Avatar

Administrator

Hi @Simone4,

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

Thanks!



Sukrity Wadhwa