Skip to main content
joshc15614786
New Participant
September 27, 2021
Question

Count of all deliveries sent per subscriber

  • September 27, 2021
  • 1 reply
  • 891 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

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"
New Participant
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