Search quality by query

MediumGoogleexistsaggregationctesmin· 40 XP (20 per step)

Google's search quality team wants a per-query report card. Two signals matter: how often a query gets no click at all, and how far down the page people go to find what they want.

Step 1: Searches with no click

For each query, show the number of searches and the percentage that got no click.

Expected output

  • no_click_pct rounded to 1 decimal; any row order

Example of the shape (made-up values):

query searches no_click_pct
weather 140 31.4

Hints, the later steps and the answer come with Pro.

Step 1 of 2

Write your query here. Ctrl + Enter submits.