Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!

Count of all deliveries sent per subscriber

Avatar

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

Avatar

Employee Advisor

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"

Avatar

Level 6

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