Unique Opens | Community
Skip to main content
H
hopeful_email_tracker
Level 2
May 20, 2022
Solved

Unique Opens

  • May 20, 2022
  • 1 reply
  • 1244 views

I'm trying to figure out unique opens for some of our email campaigns. I understand that the delivery table has this indicator, but I'm wanting to break it up into quarters and some of our campaigns go past these boundaries so the indicator isn't reliable for this. My current view is to use nmsbroadlogrcp's event data to set my date boundaries, joining nmstrackinglogrcp in order to get open data, and then counting distinct recipientids to get the number of unique recipient opens. Does this seem logical/correct? I have also read sometimes here of people using broadlogid. Is that more appropriate/why is that used?

 

Thanks for all your 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 costa_n11

Hi @hopeful_email_tracker 


it will work as you mention it, I would count the recipient Id. 
as for the date if you choose the event date you associate the open to the send date even if it happen days later. It’s a business choice to define which date will be relevant. 
thanks

denis. 

1 reply

C
Adobe Employee
costa_n11Adobe EmployeeAccepted solution
Adobe Employee
May 20, 2022

Hi @hopeful_email_tracker 


it will work as you mention it, I would count the recipient Id. 
as for the date if you choose the event date you associate the open to the send date even if it happen days later. It’s a business choice to define which date will be relevant. 
thanks

denis. 

H
hopeful_email_trackerAuthor
Level 2
May 20, 2022

Thanks so much for the help Denis! This service is quite new to me so any and all clarifications are super appreciated!

Terms & ConditionsAccessibility statement

Loading footer...