Mock interview. You're interviewing for a product analyst job on a search team. The interviewer says: "When people don't find what they want, they often type a better search right away. If we can guess that better search, we could suggest it and save them a step."
A quick rewrite is when a search gets no click, and the same user's next search comes within 60 seconds.
"Find quick rewrites and show the most common pairs: the original search and the search that followed. Show pairs that happened at least 30 times."
Expected output
original_query, rewritten_query, times; sorted by times, highest first, then original_queryExample of the shape (made-up values):
| original_query | rewritten_query | times |
|---|---|---|
| shoes | running shoes sale | 60 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.