Skip to main content
Simone4
New Member
October 1, 2021
Solved

Best and worst campaign openers

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.
JohnWi12Accepted solution
Level 5
October 1, 2021

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 in thread

3 replies

JohnWi12Accepted solution
Level 5
October 1, 2021

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

Translate
    Simone4Author
    New Member
    October 6, 2021

    Thank you johnwwilcoxmba,

     

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

    Translate
    Sukrity_Wadhwa
    Sukrity_Wadhwa
    Level 4
    October 13, 2021

    Hi @simone4,

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

    Thanks!

    Translate
    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...