Hi, I'm trying to build a calculated metric for the CTR of banners present in the client's home page.
Separately, the CTR for Banner 1, for example, would be 6% (e14 / page views * 100). But upon using the calculated metric, the values nor the percentages make sense.
Would you guys have any thoughts about how can I create this metric?
Thank you in advance!
Solved! Go to Solution.
Views
Replies
Total Likes
Hi, this is actually a very simple fix
So there's 2 things here...
You don't actually have to multiply by 100... just change your calculated metric's format to percent:
This will do that part of the math for you.
Second, the reason your numbers are looking odd is because your calculation is the decimal portion of cell, the percentage that is showing isn't your calculation at this point, it's the percent calculation of your row value against the total...
So looking at your total "5.91" (is the average percent for all your rows, displayed as a decimal), and your row 1 value "11.68" (is the percent displayed as a decimal) followed by % against the total calculation... 11.68 is 197.6% of 5.91.
Changing your values format to percent has multiple benefits:
Have you tried setting the unit of the calculated metric to percent and ditch the x 100?
Hi, this is actually a very simple fix
So there's 2 things here...
You don't actually have to multiply by 100... just change your calculated metric's format to percent:
This will do that part of the math for you.
Second, the reason your numbers are looking odd is because your calculation is the decimal portion of cell, the percentage that is showing isn't your calculation at this point, it's the percent calculation of your row value against the total...
So looking at your total "5.91" (is the average percent for all your rows, displayed as a decimal), and your row 1 value "11.68" (is the percent displayed as a decimal) followed by % against the total calculation... 11.68 is 197.6% of 5.91.
Changing your values format to percent has multiple benefits:
Thank you Jennifer.
You're very welcome
Views
Replies
Total Likes