Which one is the correct average value for Click Through Rate (CTR)?

Copper Contributor

shasoni619_0-1658159927329.png

CTR is defined as Clicks / Impressions. I want to calculate average CTR of the given data. If I use Average function on CTR it gives me average of 0.16%. If I use Total Clicks / Total Impressions I get average of 0.21%. Which one should I consider as the correct one?

1 Reply

@shasoni619 

The second one =SUM(B2:B8)/SUM(A2:A8).