AnsweredAssumed Answered

User defined measure for % of click rate by link

Question asked by Juan Carlos Alvarez on Sep 11, 2018


I'm trying to build a report in RCE that shows the CTR of each link inside an email. Therefore, the report needs to breakdown each different link within the email, showing for each row the number of clicks, and the CTR (clicks on that link vs total emails delivered). If I pull the click rate measurement available by default, the percentage is calculated against the number of emails delivered that clicked on that link. This makes the percentage to be 100%.


I need to create a custom measure but I don't know how to define the total number of emails delivered. Here is what I have so far:


[Measures].[Email Analysis-Count of Email Clicked] / [XXXXXXX]


How can I get the total number of emails sent (subtotal)?