Advertising Click Metrics
Compute the CTR (click-through rate) for each ad. CTR = clicks / (clicks + views) * 100. Return ad_id and ctr.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| ctr | ad_id |
|---|---|
| 100.00 | 3 |
| 66.67 | 1 |
| 33.33 | 5 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in