Google Search Console Insights

Act as an SEO data analyst who has extracted actionable insights from Google Search Console for websites with millions of pages, identifying optimization opportunities that increased organic traffic 25-50% through systematic data analysis. Generate a comprehensive Google Search Console analysis framework for a specific website, including performance metrics extraction, query analysis, page optimization, and technical issue identification. Begin with performance data extraction including date range selection (compare 28-day periods for monthly trends, year-over-year for seasonality, 16-month for long-term), metric selection (clicks, impressions, CTR, position, click-through rate calculation at query level, impression share estimation), dimension breakdown (queries, pages, countries, devices, search appearance, dates), filter application (regex for query patterns, page path hierarchy, specific countries, mobile vs desktop, excluding brand queries), and data export limits (2500 rows per request, scheduled exports via API, Google Sheets add-on integration). Develop query analysis including top query identification (branded vs non-branded split, head terms vs long-tail, question queries vs keyword-based), query performance quadrant (high click high impression: protect and maintain, high click low impression: increase targeting, low click high impression: optimize CTR, low click low impression: prioritize if relevant), query clustering by intent (informational, commercial, transactional, navigational, local), query opportunity scoring (volume potential x current position x relevance, priority 1-5, effort estimation, expected impact), query cannibalization detection (multiple pages ranking for same query, identifying canonical issues, consolidation opportunities), and query tracking for key terms (position tracking, volatility monitoring, competitor comparison). Create page analysis including top page identification by traffic contribution, page performance grouping (position distribution, CTR by position benchmark, page type categorization: blog post, product page, category, landing, tool), page opportunity scoring (pages with position 5-15 highest opportunity, pages with high impressions low CTR, pages with declining clicks but stable impressions), page content gaps (query coverage analysis, topics missing from page, information hierarchy issues, search intent mismatch), and page pruning candidates (zero-click pages, low-quality thin content, duplicate content, outdated information). Add technical issue identification including coverage report analysis (valid pages, excluded pages, error pages, warning pages, valid with warning), error categorization (404 not found, 500 server errors, soft 404, redirected errors, blocked by robots, excluded by noindex, crawl anomaly, page fetch error), indexation monitoring (indexed pages count trend, new page indexation speed, removal requests effectiveness, canonical tag compliance), sitemap health (submitted vs indexed ratio, sitemap errors, last read timestamp, URL count consistency), and crawl stats analysis (crawl requests by response type, crawl delay impact, mobile vs desktop crawling, host load issues). Implement CTR optimization including position CTR benchmark by industry (position 1: 25-30%, position 2: 15-18%, position 3: 10-12%, position 4-5: 5-8%, position 6-10: 2-4%), meta description optimization for high impression low CTR pages (compelling copy, keyword in first 50 characters, CTA, differentiation from competitors), title tag optimization (primary keyword early, emotional hook, length 50-60 characters, brand inclusion, number or list, year freshness), structured data implementation for rich snippets (review stars, FAQ, how-to, product availability, price, recipe, video), and SERP feature targeting (position zero featured snippets, people also ask targeting, video carousels, image packs). Provide weekly, monthly, and quarterly analysis cadence including anomaly detection (sudden drops or spikes, weather and event correlation, algorithm update identification), reporting templates with executive summary, key opportunities table, progress tracking, and recommended actions with owners. Include GSC API automation scripts (Python with google-api-python-client, scheduled reports to BigQuery, anomaly detection alerts, Slack notifications for significant changes).