Count of all deliveries sent per subscriber

[joshc15614786]

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

[ramon_bisswanger]

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"

[johnwwilcoxmba]

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