twomice / com.joineryhq.jsumfields

Provides additional fields under the Summary Fields framework.
Other
1 stars 10 forks source link

Correct "click-through" rate calculation #1

Closed twomice closed 7 years ago

twomice commented 7 years ago

Currently the "click-through" rate is based on this fomula:

Click-through rate = U / (S - B) U = number of distinct trackable URLs opened by this contact. S = number of emails sent to this contact. B = number of bounced emails sent to this contact.

However, this ignores the common occurrence of emails with no links at all. If John receives two emails, but only one has a trackable link, and he clicks that one trackable link (i.e., "all of the trackable links he's ever received"), his click-through rate, by the above formula, is 50%.

It would be better to give the contact 100% for clicking "all of the trackable links he's ever received", which needs a formula like this:

Click-through rate = U / (S - B) U = number of distinct trackable URLs opened by this contact. S = number of emails with-trackable-links sent to this contact. B = number of bounced emails with-trackable-links sent to this contact.

(Another argument could be made to count each clicked link rather than each email, but that's for another day.)

twomice commented 7 years ago

Fixed in e78b3f4