Overview

Analysis Overview

Cross-Platform Content Performance

Analysis overview and configuration

Configuration

Analysis TypePerformance
CompanyMCP Analytics
ObjectiveAnalyze cross-platform content performance by joining GSC search data with GA4 engagement metrics
Analysis Date2026-03-02
Processing Idtest_1772477877
Total Observations159

Module Parameters

ParameterValue_row
min_clicks5min_clicks
min_impressions50min_impressions
min_pageviews10min_pageviews
domainmcpanalytics.aidomain
content_type_regexcontent_type_regex
Performance analysis for MCP Analytics

Interpretation

Purpose

This cross-platform content performance analysis integrates Google Search Console (GSC) search visibility data with Google Analytics 4 (GA4) engagement metrics to classify 159 content pages into strategic quadrants. The analysis identifies which pages drive search traffic, which engage users, and where misalignments exist—enabling data-driven content optimization decisions.

Key Findings

  • Match Rate: 25.1% — Only one-quarter of the initial 798 pages successfully matched between GSC and GA4 due to URL normalization differences, resulting in 159 analyzable pages and 639 unmatched records separated into diagnostic datasets.
  • Quadrant Distribution: Pages split evenly between Stars (35 pages: high search + engagement), SEO Opportunities (45 pages: high engagement, low search visibility), and Optimize Content (45 pages: high search traffic, low engagement).
  • Engagement-Search Mismatch: Average bounce rate of 0.48 and session duration of 62.2 seconds indicate moderate user engagement, while the composite score averaging 0.45 reflects balanced but inconsistent performance across the portfolio.
  • Traffic Concentration: 38,548 total impressions but only 162 clicks (0.42% aggregate CTR) suggests visibility without conversion—a
Data Preparation

Data Pipeline

URL Normalization & Join

Data preprocessing and column mapping

Data Quality

Initial Rows798
Final Rows159
Rows Removed639
Retention Rate19.9

Data Quality

MetricValue
Initial Rows798
Final Rows159
Rows Removed639
Retention Rate19.9%
Processed 798 observations, retained 159 (19.9%) after cleaning

Interpretation

Purpose

This section documents the data consolidation process that merged Google Search Console (GSC) and Google Analytics 4 (GA4) datasets through URL normalization. The 19.9% retention rate reflects the join operation's selectivity—only pages appearing in both platforms were retained for cross-platform performance analysis, which directly supports the stated objective of analyzing content performance by combining search visibility with engagement metrics.

Key Findings

  • 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)

Interpretation

The low retention rate is a direct consequence of the analysis design—the algorithm prioritizes data quality over volume by requiring URL matches across both GSC and GA4. This ensures that composite scores and quadrant assignments are based on complete information (search

Executive Summary

Executive Summary

Key Findings & Recommendations

Key Metrics

matched_pages
159
match_rate
25.1
stars_count
35
seo_opportunity_count
45
optimize_content_count
45
avg_bounce_rate
48.4
avg_position
10.7
content_types_found
6

Key Findings

findingvalue
Total pages analyzed159
Match rate (GSC + GA4)25.1%
Star pages (high search + engagement)35
SEO opportunities (high engagement, low search)45
Content to optimize (high search, low engagement)45
Best performing page/articles/cox-proportional-hazards-practical-guide-for-data-
Top SEO opportunity/whitepapers/whitepaper-pca
Biggest mismatch page/articles/one-class-svm-practical-guide-for-data-driven-deci

Summary

Bottom Line: Analyzed 159 matched pages for MCP Analytics from 451 GSC pages and 342 GA4 pages (25.1% match rate).

Key Findings:
Stars: 35 pages (22%) excel at both search visibility and engagement
SEO Opportunities: 45 pages have proven engagement but need search visibility
Optimize Content: 45 pages rank well but fail to engage visitors
Average Bounce Rate: 48.4%
Average Position: 10.7

Recommendation: Top priority: 45 SEO opportunity pages have proven engagement but need search visibility improvements.

Interpretation

EXECUTIVE SUMMARY

Purpose

This analysis evaluates cross-platform content performance by matching Google Search Console (GSC) search visibility data with Google Analytics 4 (GA4) engagement metrics. The objective is to identify which content drives both search traffic and user engagement, and where strategic improvements can unlock value.

Key Findings

  • Match Rate (25.1%): Only 159 of 798 pages successfully matched between GSC and GA4, indicating significant data fragmentation or URL normalization issues that limit visibility into full content performance
  • Star Pages (35 pages, 22%): High-performing content excelling in both search visibility and engagement—these represent proven winners worth amplifying
  • SEO Opportunities (45 pages, 28%): Content with strong engagement signals but weak search visibility—represents the highest-value optimization opportunity
  • Optimize Content (45 pages, 28%): Pages ranking well in search but failing to convert visitors (avg bounce rate 90%)—indicates messaging or UX misalignment
  • Average Bounce Rate (48.4%): Nearly half of visitors leave without engagement, suggesting content-audience fit issues across the portfolio

Interpretation

The portfolio is evenly split between three actionable segments. The 45 SEO opportunity pages represent the most attractive investment—they've already proven ability to engage users, requiring only improved search visibility

Figure 4

Content Quality Matrix

Search Performance vs Engagement Quality

Quality matrix scatter plot classifying every matched page into quadrants based on search performance score vs engagement quality score

Interpretation

Purpose

This section classifies your 159 matched pages into four performance quadrants based on search visibility (impressions, clicks, position) versus user engagement quality (bounce rate, session duration). Understanding this distribution reveals which content is working well, which needs optimization, and where untapped opportunities exist—directly supporting the goal of improving cross-platform content performance.

Key Findings

  • Stars (35 pages, 22%): High search visibility AND strong engagement—your best-performing content demonstrating proven SEO and user value alignment
  • SEO Opportunities (45 pages, 28%): Strong engagement but low search visibility—content users love that search engines haven't yet discovered
  • Optimize Content (45 pages, 28%): High search traffic but low engagement—pages attracting visitors who aren't converting or staying
  • Review (34 pages, 21%): Low performance on both dimensions—minimal search visibility and weak user engagement

Interpretation

The distribution is nearly balanced across quadrants, indicating a diverse content portfolio with distinct optimization needs. The equal split between SEO Opportunities and Optimize Content (45 each) suggests your site has both untapped potential and underperforming high-traffic pages. The 22% Stars rate indicates room for improvement—most content isn't simultaneously strong in search and engagement, revealing systematic gaps in either discoverability or user experience.

Context

Figure 5

Top Performing Pages

Highest Combined Search + Engagement

Top performing pages ranked by composite search + engagement score — these pages excel at both attracting search traffic and engaging visitors

Interpretation

Purpose

The Stars section identifies your highest-performing content—pages that simultaneously achieve strong search visibility and visitor engagement. These 35 pages represent proven content templates that successfully attract organic traffic while keeping users engaged, making them benchmarks for understanding what works across your content portfolio.

Key Findings

  • Stars Count: 35 pages qualify as top performers out of 159 analyzed (22% of matched content)
  • Total Impressions: 38,548 impressions concentrated in this high-quality segment, indicating significant search visibility
  • Average Composite Score: 0.72 (range 0.65–0.90), reflecting consistently strong dual performance
  • Engagement Score: Mean 0.72 with low variance (sd=0.13), showing reliable visitor retention across star pages
  • Search Score: Mean 0.71, demonstrating these pages rank competitively in search results
  • Impression Distribution: Highly skewed (skew=1.41), with the homepage (2,650 impressions) and top articles (1,500+) driving disproportionate traffic

Interpretation

Star pages validate that your content strategy works when both SEO and UX elements align. The tight clustering of engagement scores (0.49–1.0, sd=0.13) suggests these pages share consistent quality attributes. However, the low average CT

Figure 6

SEO Opportunities

High Engagement, Low Search Visibility

High engagement but low search visibility pages ranked by engagement score — these are the highest-ROI targets for SEO investment

Interpretation

Purpose

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

Table 7

Optimize Content

High Search, Low Engagement Pages

High search visibility but low engagement pages with mismatch severity — these pages attract visitors but fail to engage them

page_pathimpressionsclicksctrbounce_rateavg_session_durationmismatch_score
/articles/one-class-svm-practical-guide-for-data-driven-decisions111119.00e-04100.8792
/articles/bayesian-regularization-practical-guide-for-data-driven-decisions93700100.8555
/articles/general-linear-models-glm-practical-guide-for-data-driven-decisions145140.00280.88891.50.8405
/articles/price-elasticity-practical-guide-for-data-driven-decisions192320.0010.81.40.8205
/tutorials/how-to-use-mrr-analysis-in-stripe-step-by-step-tutorial69720.0029100.8144
/articles/principal-component-analysis-pca-practical-guide-for-data-driven-decisions62300100.7988
/articles/arima-practical-guide-for-data-driven-decisions119020.00170.85713.70.7894
/tutorials/how-to-use-revenue-overview-in-stripe-step-by-step-tutorial37110.0027100.7269
/articles/association-rules-apriori-practical-guide-for-data-driven-decisions97920.0020.757.90.6861
/articles/intraclass-correlation-icc-practical-guide-for-data-driven-decisions151930.0020.714346.10.6809
/tutorials/how-to-use-discount-effectiveness-in-etsy-step-by-step-tutorial25510.0039100.6749
/articles/customer-lifetime-value-ltv-practical-guide-for-data-driven-decisions21900100.6538
/tutorials/how-to-use-listing-performance-comparison-in-etsy-step-by-step-tutorial19700100.6391
/whitepapers/whitepaper-difference-in-differences1910010.20.6347
/articles/xgboost-practical-guide-for-data-driven-decisions16600100.6155
/whitepapers/whitepaper-factor-analysis16600100.6155
/articles/propensity-score-matching-practical-guide-for-data-driven-decisions101830.00290.666726.90.6149
/articles/holm-bonferroni-method-practical-guide-for-data-driven-decisions232730.00130.6364114.20.6126
/articles/logistic-regression-practical-guide-for-data-driven-decisions1460014.70.5925
/whitepapers/whitepaper-fishers-exact56330.00530.71434.40.5893

Interpretation

Purpose

This section identifies 45 pages that achieve strong search visibility but fail to convert visitor interest into engagement. These pages attract traffic through search rankings but experience high bounce rates (mean 0.48, median 1.0), indicating a critical mismatch between search intent and page content. Understanding this gap is essential for the cross-platform analysis, as it reveals where SEO success masks content quality problems.

Key Findings

  • Optimize Content Count: 45 pages identified with high search visibility but low engagement signals
  • Average Bounce Rate: 0.484 (48.4%) — substantially elevated, with median at 1.0, indicating most pages lose visitors immediately
  • Impressions vs. Engagement: Mean 802 impressions per page but only 1.35 clicks and near-zero CTR, showing traffic arrives but doesn't convert
  • Session Duration Collapse: Mean 10.55 seconds (median 0.1), confirming visitors exit without meaningful interaction
  • Mismatch Severity: Mean mismatch score 0.71, with top offenders scoring 0.88, quantifying the search-engagement disconnect

Interpretation

These pages represent a critical inefficiency in the content portfolio. While they successfully rank in search results, the extreme bounce rates and minimal session duration reveal that page content fails to satisfy visitor expectations set by search

Figure 8

Content Type Comparison

Search vs Engagement by Format

Aggregate search and engagement metrics compared across content types (Articles, Tutorials, Homepage, etc.)

Interpretation

Purpose

This section identifies which content formats drive the strongest cross-platform performance by comparing search visibility and user engagement metrics across six content types. Understanding format-level performance reveals whether certain content structures attract organic traffic but fail to engage users—or vice versa—informing both SEO and content quality strategies.

Key Findings

  • Articles: Highest search score (0.69) but lowest engagement (0.35)—strong visibility, weak user retention
  • Blog: Best engagement rate (0.63) with moderate search score (0.44)—strong user connection despite lower visibility
  • Homepage: Dominates impressions (756 avg) and clicks (60 avg) with balanced scores (search: 0.83, engagement: 0.56)
  • Services: Lowest search visibility (0.25) and engagement (0.31)—underperforming across both dimensions
  • Search-Engagement Mismatch: Articles represent the clearest opportunity—high search traffic without corresponding user engagement

Interpretation

Articles attract significant organic search traffic but visitors don't engage deeply, suggesting content quality or relevance gaps. Conversely, Blog content achieves strong engagement despite lower search prominence, indicating format resonates with users once they arrive. The Homepage's exceptional performance across all metrics reflects its structural advantage in both discoverability and user interaction. This pattern directly supports the overall analysis

Table 9

Unmatched Pages

GSC-Only and GA4-Only Pages

Diagnostic view of pages found in only one data source — GSC-only pages may have tracking gaps, GA4-only pages reveal non-search traffic

page_pathimpressionsclicksctrposition
/articles/spectral-clustering-practical-guide-for-data-driven-decisions21360016.2
/articles/price-elasticity-practical-guide-for-data-driven-decisions.html13500010.5
/articles/xgboost-practical-guide-for-data-driven-decisions.html12580020.5
/articles/session-based-recommendations-practical-guide-for-data-driven-decisions930007
/articles/holm-bonferroni-method-practical-guide-for-data-driven-decisions.html85320.00238.8
/blogs/content/stripe-card-brands-matter797008.5
/articles/cox-proportional-hazards-practical-guide-for-data-driven-decisions.html6430021.4
/whitepapers/whitepaper-fishers-exact.html48020.004213.1
/articles/decision-trees-practical-guide-for-data-driven-decisions43010.002318.1
/whitepapers/whitepaper-icc.html41210.002412.4
/articles/intraclass-correlation-icc-practical-guide-for-data-driven-decisions.html41110.002410.1
/articles/var-vector-autoregression-practical-guide-for-data-driven-decisions.html41110.002413.6
/whitepapers/whitepaper-umap409007.8
/blogs/content/stripe-card-brands-matter.html338008.9
/whitepapers/whitepaper-chi-square323009.6
/articles/anova-practical-guide-for-data-driven-decisions3150014.5
/whitepapers/whitepaper-kolmogorov-smirnov.html3050011.4
/whitepapers/whitepaper-ancova.html2910013.6
/tutorials/how-to-use-revenue-overview-in-stripe-step-by-step-tutorial.html281009
/whitepapers/whitepaper-tsne.html2810015.4
page_pathscreenPageViewstotalUserssessionsbounceRate
/login10966820.1585
/signup6050510
/tutorials/how-to-use-tax-and-fee-analysis-in-amazon-step-by-step-tutorial3436360.3889
/machine-learning2725250.8
/chat/f7e6be32-67bd-41c1-9954-d50dd09383ab17160
/catalog8220
/chat/cb62dedc-82c6-4df5-be70-57c045467b4b5120
/account-app4110
/chat/29f89cdf-58d2-43ad-8f71-3bc959990b424110
/chat/8d01257f-dc85-4cf0-9e39-8567859dfe384130.3333
/chat/9211bec2-4d03-41b4-bdeb-2ccd5bd10b814120
/chat/cae22414-bd52-421a-ac03-cb90dd4453184110
/chat/db1bb4c3-3a2c-406f-bab3-dc4ba556d9f14110
/account3330.6667
/analysis/reports/commerce__amazon__orders__business_vs_individual3330
/authors3330
/blogs3220
/chat/13482160-e8d7-486e-9e0d-833d1aac19d93110
/chat/3ba85522-cffe-4dc9-bbfb-32806381a7f43110
/chat/4710ca8d-8182-4194-8dc1-d73553fec3be3110

Interpretation

Purpose

This section identifies pages that exist in only one data source, revealing potential tracking gaps and traffic source diversity. The 25.1% match rate indicates significant data fragmentation—292 pages appear in Google Search Console (GSC) but lack GA4 engagement data, while 183 pages show GA4 traffic without search visibility. Understanding these mismatches is critical for validating data completeness and identifying pages driven by non-search channels.

Key Findings

  • Unmatched GSC Pages (292): Pages generating search impressions (mean 632.7, max 2,136) but showing zero GA4 engagement—suggests potential GA4 tracking implementation gaps or pages excluded from analytics
  • Unmatched GA4 Pages (183): Pages receiving traffic (mean 15.25 screen views) without search visibility—indicates non-search traffic sources (direct, social, referral, internal navigation) or noindexed/recently published content
  • Position Pattern: GSC-only pages rank at mean position 12.52 (mid-to-lower SERP), explaining lower click-through potential despite search visibility

Interpretation

The low match rate reflects a portfolio with diverse traffic sources beyond organic search. GSC-only pages represent untapped conversion opportunities if GA4 tracking is properly installed. GA4-only pages (including login, signup

Want to run this analysis on your own data? Upload CSV — Free Analysis See Pricing