Jul 18 2022 09:07 AM
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?
Jul 18 2022 09:24 AM
The second one =SUM(B2:B8)/SUM(A2:A8).