Discussions

How can I create a new Calculated Measure for Unique Click-to-Unique Open Rate?

Posts: 5 NewUser

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!

Tagged:

• Posts: 57 Red Ribbon

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).

• Posts: 66 Red Ribbon

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

https://ivenium.marketing/?utm_source=topliners

• Posts: 5 NewUser
edited Jan 23, 2023 4:33PM

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

• Posts: 57 Red Ribbon

I'm glad to hear we could help. Happy reporting!