Purpose

Retention Rate (19.9%): 639 rows removed during URL join operation; this is intentional filtering rather than data loss, as unmatched pages were preserved in diagnostic datasets (unmatched_gsc and unmatched_ga4) for separate analysis
Match Rate (25.1%): Aligns with retention rate, indicating approximately 1 in 4 pages have complete data across both platforms
Final Dataset (159 rows): Represents the analyzable universe for quadrant classification and cross-platform scoring; sufficient for the four-quadrant segmentation (Stars: 35, SEO Opportunities: 45, Optimize Content: 45, Review: 34)

This section identifies 45 pages that demonstrate strong visitor engagement but rank poorly in search results (average position 10.7). These pages represent high-ROI SEO targets because they've already proven content-market fit through user behavior—improving their search visibility requires optimization rather than content creation.

Key Findings

SEO Opportunity Count: 45 pages identified with proven engagement but limited search traffic
Average Engagement Rate: 0.52 indicates strong user interaction; zero bounce rate across the cohort signals content relevance
Average Search Position: 10.7 places these pages beyond the typical top-10 visibility threshold, explaining low impression volume despite quality content
Session Duration Pattern: Mean of 122.5 seconds (median 38.4) shows visitors spend meaningful time on these pages when they arrive

Interpretation

These pages occupy a unique position in the content performance matrix: they convert engaged visitors but receive insufficient search exposure. The zero bounce rate and extended session durations confirm content quality and relevance. The gap between engagement strength (0.75 mean engagement score) and search visibility (position 10.7) indicates optimization opportunities rather than content failures. This cohort represents the highest-probability targets for SEO investment because ranking improvements directly amplify existing conversion potential.

Context

This analysis assumes consistent GA4 tracking and GSC data from the same