Tracking Field Definitions

Avatar

Avatar

saraw71774576

Avatar

saraw71774576

saraw71774576

08-04-2019

Hello!

We're trying to put together a data dictionary to standardize reporting across all efforts and platforms. I cannot find exact definitions of data fields in the Recipient tracking logs and standard reports.

Can anyone define how these are calculated (i.e. does it include opt-out clicks, mirror clicks, etc.)?

  • Recipient Open
  • Recipient Click
  • I believe these are the same as above, but sometimes there are insignificant differences, so adding here as well:
    • Distinct Opens for the population reached in Tracking Indicators Report
    • Distinct Clicks for the populations reached in Tracking Indicators Report

Thank you!

View Entire Topic

Avatar

Avatar

LeonieSwart

Avatar

LeonieSwart

LeonieSwart

20-01-2020

Hi 

 

Is it correct that the @RecipientOpen field is calculated based on the unique clicks?

As any click equals an open ?

 

I'm asking because I'm currently having an issue where my @TotalRecipientOpen (= total count) is WAY less than my @RecipientOpen (= recipients who have opened). Also when I check the actual tracking logs for opens the number matches the @TotalRecipientOpen and not the @RecipientOpen.

 

As you can see in the screenshot the @RecipientOpen makes more sense if you look at the number of clicks I have.

Screenshot 2020-01-20 at 16.06.12.png

 

Any clue where this difference is coming from?

 

Thanks!

Leonie