Unique Sends | Community
Skip to main content
Level 2
June 27, 2022
Solved

Unique Sends

  • June 27, 2022
  • 1 reply
  • 616 views

Hey All, 

I'm trying to understand how best to get number of unique email sends for specific email campaigns (the campaigns may send to the same recipient multiple times which is why I care more about unique than total). My initial assumption that I have been using is to find either the number of unique recipientIDs or broadlogIDs from the nmsbroadlogrcp table that are related to email codes from joining with the nmsdelivery table. The numbers I get seem logical, but I was wondering if there is another accepted way considering the delivery table does provide email send metrics but they seem to be more in line with total emails sent rather than uniques. 

 

Thanks for all the help!!

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

Hello,

Your method of using the unique broadlogrcp IDs and mapping them back to the nmsdelivery table is the correct and most efficient method.

 

Regards,

Craig

1 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
June 28, 2022

Hello,

Your method of using the unique broadlogrcp IDs and mapping them back to the nmsdelivery table is the correct and most efficient method.

 

Regards,

Craig