How to find page-two keywords from a GSC CSV
Page-two keywords are query rows with an average position of 11–20. A Pages.csv average cannot tell you the exact position of every query that led to that page.
Export the right evidence
- Select your property, reporting period and search filters in Search Console.
- Export the Queries tab. Filter to one page first when you need exact query-to-page evidence.
- Upload Pages.csv for page actions and Queries.csv for query-level evidence.
- Inspect queries at positions 11–20 and prioritise demand relative to the site's own exported query distribution.
Demand is relative to your site
The planner uses the 75th percentile of impressions in matching query exports as its high-demand threshold. Impressions are observed exposure, not total keyword search volume. An incomplete export can bias that threshold, so check row limits and filters.
A plateau needs more than one snapshot
A single query period identifies a candidate near page one, not proof that it has stalled. Add an equal, non-overlapping earlier query export with identical filters to compare movement. Momentum requires an improvement of at least five average-position places and rising impressions.
Check the destination before changing content
For deeper positions, review the searcher's need and the page's actual content. An intent mismatch cannot be proven by CTR or query wording alone. Use a page-filtered query export and supplied page content; review any AI interpretation against its exact evidence and existing destinations.
Open SEO Action Planner to review your own exported page-two and long-tail evidence.