Google Sheets campaign performance tracking with budget, views, clicks, and CTR metrics.

To find the Click-Through Rate (CTR) for each campaign, we use the formula:

CTR = (Clicks ÷ Views) × 100%

We’ll calculate this for each row to verify or complete the table. The CTR column is already filled in, but let’s double-check a few to make sure they’re correct — especially since this might be part of a homework task where you need to confirm accuracy or fill missing values.

Let’s go row by row:

---

Campaign 1:
Views = 500, Clicks = 10
CTR = (10 ÷ 500) × 100% = 0.02 × 100% = 2.00% → ✔ Matches

Campaign 2:
Views = 100, Clicks = 70
CTR = (70 ÷ 100) × 100% = 0.70 × 100% = 70.00% → ✔ Matches

Campaign 3:
Views = 300, Clicks = 80
CTR = (80 ÷ 300) × 100% ≈ 0.2667 × 100% = 26.67% → ✔ Matches

Campaign 4:
Views = 600, Clicks = 100
CTR = (100 ÷ 600) × 100% ≈ 0.1667 × 100% = 16.67% → ✔ Matches

Campaign 5:
Views = 700, Clicks = 300
CTR = (300 ÷ 700) × 100% ≈ 0.4286 × 100% = 42.86% → ✔ Matches

Campaign 6:
Views = 800, Clicks = 400
CTR = (400 ÷ 800) × 100% = 0.50 × 100% = 50.00% → ✔ Matches

Campaign 7:
Views = 1000, Clicks = 600
CTR = (600 ÷ 1000) × 100% = 0.60 × 100% = 60.00% → ✔ Matches

Campaign 8:
Views = 500, Clicks = 200
CTR = (200 ÷ 500) × 100% = 0.40 × 100% = 40.00% → ✔ Matches

Campaign 9:
Views = 400, Clicks = 100
CTR = (100 ÷ 400) × 100% = 0.25 × 100% = 25.00% → ✔ Matches

Campaign 10:
Views = 800, Clicks = 80
CTR = (80 ÷ 800) × 100% = 0.10 × 100% = 10.00% → ✔ Matches

---

All CTR values in the table are correctly calculated.

Since no specific question was asked beyond solving the problem shown, and all data is already complete and accurate, the final answer is that all CTR values are correct as displayed.

But if the task was simply to compute or verify CTRs, then we’ve done that.

Final Answer: All CTR values in the table are correctly calculated.