Skip to main content
Level 2
Jun 27, 2022 8:18 PM UTC
Solved

Unique Sends

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.
Craig_Thonis
Craig_ThonisAccepted solution
Adobe Employee
Jun 28, 2022 12:48 PM UTC

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
Jun 28, 2022 12:48 PM UTC

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

Translate