Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Best and worst campaign openers

Simone4
Level 1
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
johnwwilcoxmba
Correct answer by
Level 5
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

View solution in original post

3 Replies
johnwwilcoxmba
Correct answer by
Level 5
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

View solution in original post

Simone4
Level 1
Level 1

Thank you johnwwilcoxmba,

 

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

Sukrity_Wadhwa
Employee
Employee

Hi @Simone4,

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

Thanks!