Practice challenge
Calculate click-through rate
#19
3 attempts remaining
BeginnerMarketingTarget D2
A marketing report tracks impressions and clicks by campaign.
Write a formula for D2 that calculates CTR and returns "N/A" when impressions are zero.
Calculate click-through rate
Swipe horizontally to view the full table.
| A | B | C | D | |
|---|---|---|---|---|
| # | Campaign | Impressions | Clicks | CTR |
| 2 | Search | 12,000 | 620 | blank |
| 3 | Social | 8,000 | 480 | blank |
| 4 | Pilot | 0 | 0 | blank |
| 5 | Display | 15,000 | 250 | blank |