Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Count of all deliveries sent per subscriber

joshc15614786
Level 2
Level 2

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

 

2 Replies
ramon_bisswanger
Employee
Employee

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
Level 5
Level 5

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

johnwwilcoxmba_0-1633097394891.png