Expand my Community achievements bar.

SOLVED

CTR on Banner

Avatar

Level 3

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.

 

Ricardo33_2-1721663021334.png

Ricardo33_0-1721662930783.png

Would you guys have any thoughts about how can I create this metric?

 

Thank you in advance!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor and Adobe Champion

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:

 

Jennifer_Dungan_0-1721671812704.png

 

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:

  1. It will do the multiply by 100 for you
  2. It will actually display your results as percentages (i.e. 5.91% or 11.68%, etc.)
  3. You will no longer see the percent calculation against your total... "percent" metrics show only the percent (not the number) and that percent is now your expected calculation.

View solution in original post

4 Replies

Avatar

Community Advisor

Have you tried setting the unit of the calculated metric to percent and ditch the x 100?

Cheers from Switzerland!

Avatar

Correct answer by
Community Advisor and Adobe Champion

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:

 

Jennifer_Dungan_0-1721671812704.png

 

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:

  1. It will do the multiply by 100 for you
  2. It will actually display your results as percentages (i.e. 5.91% or 11.68%, etc.)
  3. You will no longer see the percent calculation against your total... "percent" metrics show only the percent (not the number) and that percent is now your expected calculation.