Google's search quality team tracks how often people click each result position. A healthy page has most clicks near the top.
For each result position, show the number of clicks and the click-through rate: clicks at that position as a percentage of all searches.
Expected output
ctr_pct rounded to 2 decimals; any row orderExample of the shape (made-up values):
| position | clicks | ctr_pct |
|---|---|---|
| 1 | 900 | 27.30 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.