Content Opportunities

Surface quick-win content optimization targets: pages or queries sitting in positions 11–20 with high impression volume but low CTR.

Steps

1. Call list_properties to confirm the exact site_url.
2. Call get_advanced_search_analytics with:

• dimensions=query,page
• row_limit=500 or the highest supported row limit
• start_date = 28 days ago, end_date = today

1. Treat the returned rows as a top-row sample from Search Analytics, not a complete export. Do not assume the API sorted by impressions.
2. Filter the retrieved rows client-side to keep only rows where:

• position is between 11 and 20 (page 2, just below the fold)
• impressions > 100 (meaningful search volume)
• ctr < 0.03 (3% — below average for these positions)

1. Sort the filtered set client-side by impressions descending.
2. Return the top 20 rows.

Output format

Present as a table: Query | Page | Position | Impressions | CTR | Opportunity Score

Opportunity Score = impressions × (0.05 − ctr) — a rough estimate of clicks gained if CTR reaches 5%.

Follow the table with specific recommendations for each entry:

• Title/meta description optimization ideas
• Whether to merge with a better-ranking page
• Whether to add internal links to boost the page

Note: Google Search Analytics returns top rows for the requested dimensions. This workflow is an adjacent approximation for content ideas, not a guaranteed exhaustive list of every high-impression, low-CTR opportunity.