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

Count of all deliveries sent per subscriber

  • September 27, 2021
  • 1 reply
  • 894 views

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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

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