HELP - Understanding Delivery Indicators | Community
Skip to main content
Level 3
April 30, 2020
Solved

HELP - Understanding Delivery Indicators

  • April 30, 2020
  • 2 replies
  • 3740 views

I'm hoping someone can help me understand how delivery indicators are calculated.  When i look at the estimation of the number of recipients who have opened the emails ([indicators/@estimatedRecipientOpen]) i see a number that is different my individual count when i sum the individual recipients who have opened the email.  I'm not sure if this is due to recipients opened the email on multiple days or on multiple devices but i'm trying to figure out the exact criteria that defines a unique open and also is there a way to export the list of individual recipients who have unique opens so that i can match to my export?  Again, when i export directly from the delivery itself i get results that don't match.

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 DavidKangni

Hi Wes,

 

See there an explanation of Adobe campaign calculation method.

For your export, you can build something like the screenshot below

  • query the delivery from tracking logs to get all the logs
  • split and keep only url type equal open
  • dedup on the recipient ID 
  • extract the file

One more thing, I think if someone clicked on opt out link (flagged as opt-out category in ACC) it's not count in opens nor clicks in the reports

 

Thanks

David

 

2 replies

DavidKangni
Community Advisor
DavidKangniCommunity AdvisorAccepted solution
Community Advisor
April 30, 2020

Hi Wes,

 

See there an explanation of Adobe campaign calculation method.

For your export, you can build something like the screenshot below

  • query the delivery from tracking logs to get all the logs
  • split and keep only url type equal open
  • dedup on the recipient ID 
  • extract the file

One more thing, I think if someone clicked on opt out link (flagged as opt-out category in ACC) it's not count in opens nor clicks in the reports

 

Thanks

David

 

David Kangni
xgijaneyx-eQ8MX
March 11, 2023

i am sick of gooing round and round