Discussions
How can I create a new Calculated Measure for Unique Click-to-Unique Open Rate?
Hi and please help! :)
The out of the box rate for this divides total clicks by total opens. BUT, we need a rate for unique clicks divided by unique opens. Example: 10 unique clicks / 100 unique opens = 10% unique click-to-unique open rate.
I've followed every instruction I can find to do this, I can create the column, the formula is super simple, so I created it. Formatted the data to a % but all my results are 0.00% (even tried to put 6 digits in case the formula was wonky - still 0.00000%).
Has anybody come across this issue, I can't be the only one, right?! I'm sure it's just something simple I'm overlooking.
Help! Thanks!
Comments
-
Per the definitions on the Campaign Analysis Overview report and Email Analysis Overview report, Click-to-Open Rate is the unique clickthroughs by the original recipient divided by the unique opens by the original recipient. This metric calculation ignores possible forwards. (Clicked Sends / Opened Sends).
-
Hi @tenperk
You can use this formula:
(1.0*"Activities"."Unique Clickthroughs")/(1.0*"Activities"."Unique Opens")*100
Althought, the out of the box Click-to-Open Rate metric should work fine (plus, this metric ignores possible forwards).
Piotr Sito
Senior Marketing Automation Specialist
-
thank you both! i must have assumed it was total/total because when I did the math myself it was higher. so, so helpful - thank you so much :) Piotr Sito User_NVFDK
-
I'm glad to hear we could help. Happy reporting!
