Count of all deliveries sent per subscriber | Adobe Higher Education
Skip to main content
joshc15614786
Level 2
September 27, 2021
Question

Count of all deliveries sent per subscriber

Hi - Using delivery logs how can I get a count of all deliveries sent per subscriber?

 

The aim is to see how many emails each subscriber is receiving.

 

Thanks

 

Ce sujet a été fermé aux réponses.

1 commentaire

Adobe Employee
October 1, 2021

2 options:

  • Query profile
  • Add delivery logs as additional data
  • Choose type =aggregate

 

Or:

  • Query for broadlog
  • Use row num function to determine the row count RowNum(PartitionBy(<some unique field in recipient>), OrderBy(1))
  • Use deduplication and choose "expression"; then row num and "keep largest"
Level 5
October 1, 2021

For our metric we use what is described above:

  • Query profile
  • Add delivery logs as additional data
  • Choose type =aggregate
  • CountDistinct(@deliveryLogID)

Then I do a segmentation with a range of # of emails sent