A complete content audit, powered by intelligent BI analysis, is the most effective way to identify and rectify underperforming digital assets. Many organizations invest heavily in content creation without a clear, data-driven strategy for evaluating its effectiveness, leading to wasted resources and missed opportunities. This tutorial outlines a precise methodology for using Google Analytics 4 (GA4) and Google Looker Studio to pinpoint exactly where your content falls short and how to initiate its asset optimization.
Key Takeaways
- Connect Google Analytics 4 and Google Search Console to Looker Studio for a unified content performance dashboard.
- Use GA4’s “Engagement Rate” and “Average Engagement Time” metrics to identify content with low user interaction.
- Create calculated fields in Looker Studio to normalize page views against content production date for fair comparison.
- Focus optimization efforts on content ranking on Google Search Console pages 2 to 5, as these often require minimal effort for significant gains.
- Implement A/B testing for identified underperforming assets, focusing on headline, meta description, and introductory paragraph variations.
Step 1: Consolidate Your Data Sources in Looker Studio
Before any analysis can begin, you need a single, unified view of your content performance. This means bringing together data from your primary analytics platform and your search performance tool. I always recommend Google Analytics 4 (GA4) and Google Search Console (GSC) for this. They are free, powerful, and integrate smoothly.
1.1 Create a New Report in Looker Studio
- Navigate to Looker Studio.
- Click the “Blank report” button in the top left corner.
1.2 Add Google Analytics 4 as a Data Source
- On the “Add data to report” page, search for “Google Analytics.”
- Select the “Google Analytics” connector.
- Choose your GA4 property from the list. If you manage multiple properties, ensure you select the correct one.
- Click “Add.” Confirm the data source addition if prompted.
1.3 Add Google Search Console as a Data Source
- With your report open, click “Add data” from the toolbar at the top.
- Search for “Google Search Console.”
- Select the “Google Search Console” connector.
- Choose “Site Impression” as the Table type. This provides page-level data.
- Select your website property.
- Click “Add.” Confirm the data source addition.
You now have the foundational data streams. A common mistake here is failing to link both data sources correctly to the same report. Without both, your insights will be incomplete, like trying to drive with one eye closed.
Step 2: Build Your Underperforming Content Dashboard
A good dashboard tells a story at a glance. For content auditing, that story needs to highlight low engagement and poor search visibility. We’ll focus on key metrics that directly indicate underperformance.
2.1 Add a Table Chart for GA4 Page Performance
- Click “Add a chart” from the toolbar.
- Select “Table” from the options.
- Drag and drop the table onto your canvas.
- In the “Setup” panel on the right, configure the following:
- Data source: Your GA4 property.
- Dimension:
Page path and screen class. This is your content URL. - Metrics:
ViewsEngagement rateAverage engagement timeConversions(if applicable to your content, e.g., lead forms, newsletter sign-ups)
Sort this table by Engagement rate in ascending order. This immediately surfaces pages where users land but quickly leave or show minimal interaction. A low engagement rate (say, below 30%) for an informational article is a red flag. For a commercial page, it’s a blaring siren.
2.2 Integrate Search Console Data for Ranking Insights
- Add another “Table” chart to your canvas.
- In the “Setup” panel:
- Data source: Your GSC property (Site Impression).
- Dimension:
Page. - Metrics:
ImpressionsClicksAverage Position
Sort this table by Average Position in ascending order to see your top-ranking pages, but also pay close attention to pages ranking on positions 10 to 50. These are often “low-hanging fruit” for optimization. According to a HubSpot report on search engine statistics, the first page of Google captures the vast majority of clicks, making improvements on pages 2-5 highly impactful.
2.3 Create a Blended Data Source for Holistic View
This is where the real power of BI analysis comes in. We need to see GA4 engagement alongside GSC performance for the same content piece.
- Select both table charts you just created (click one, then Shift+click the other).
- Right-click and choose “Blend data.”
- In the “Configure Blend” window, ensure the “Join Key” is set to
Page path and screen class(from GA4) andPage(from GSC). This maps the URLs. - You may need to adjust the join type to “Left Outer Join” to ensure all GA4 pages are included, even if GSC has no data for them.
- Click “Save.”
- Now, create a new table chart using this blended data source. Your dimensions should include
Page path and screen class, and your metrics should includeViews,Engagement rate,Average Position, andClicks.
This blended table is your battlefield map. It highlights articles with high impressions but low clicks (poor title/meta description), or high views but low engagement (content quality issue). It’s a critical step most marketers skip, relying on fragmented data.
Step 3: Define “Underperforming” with Custom Metrics
What constitutes “underperforming” varies by content type and business goals. A product page with a 2% conversion rate might be stellar, while a blog post with a 2% engagement rate is abysmal. We need to create calculated fields to give context.
3.1 Normalize Views by Content Age
New content naturally has fewer views than old, established content. To compare fairly, we need to normalize this.
- In your blended data source, click “Add a field” at the bottom of the “Available Fields” list.
- Name the field “Views per Day.”
- Use the following formula (assuming you have a custom dimension for “Content Publish Date” in GA4, which I strongly recommend you implement):
SUM(Views) / (DATE_DIFF(CURRENT_DATE(), Content Publish Date))
If you don’t have a “Content Publish Date” custom dimension, you’ll need to manually categorize content by age buckets (e.g., “new,” “mid-life,” “evergreen”) and filter your reports, which is less precise but still useful. - Set the “Type” to “Number.”
- Click “Apply.”
This calculated metric gives you a fairer comparison of content vitality. A content piece from 2023 with 1000 views per day is performing far better than one from 2020 with the same total views.
3.2 Segment Content by Goal and Funnel Stage
Not all content has the same objective. A “top-of-funnel” blog post aims for awareness (impressions, engagement), while a “bottom-of-funnel” product comparison aims for conversions. Create filters or custom dimensions to categorize your content.
- In GA4, go to “Admin” > “Custom definitions” > “Custom dimensions.”
- Create a new “Event-scoped custom dimension” called “Content Category” or “Funnel Stage.”
- Work with your development team to pass this dimension with your
page_viewevent for each content piece. For example, a blog post might have “Awareness” as its category, while a service page has “Conversion.”
Once this data flows into GA4, you can use it as a dimension in Looker Studio, allowing you to filter your underperforming content by its intended purpose. This prevents comparing apples to oranges.
Step 4: Analyze and Prioritize Underperforming Assets
Now, with your data consolidated and metrics refined, you can identify and prioritize content for optimization. This step requires a critical eye and an understanding of your business goals.
4.1 Identify Low Engagement, High Traffic Pages
In your blended Looker Studio table, filter for pages with:
Viewsabove your average.Engagement ratebelow your average (or a defined threshold like 40%).Average engagement timesignificantly lower than similar content.
These pages are attracting users but failing to hold their attention. The content itself, its structure, or its presentation is likely the issue. Perhaps the introduction fails to hook the reader, or the information isn’t presented clearly. I see this often with verbose, undifferentiated content.
4.2 Pinpoint High Impression, Low Click-Through Rate (CTR) Pages
Filter for pages with:
Impressionsabove average.Clickssignificantly below average for their impression volume (i.e., a low CTR).Average Positionon Google Search Console between 10 and 50.
These pages are visible in search results but aren’t enticing users to click. The problem usually lies with the title tag and meta description. These are your ad copy for search engines. Experiment with stronger calls to action, benefit-driven language, or more precise keyword integration. A/B testing these elements is straightforward and can yield fast results.
4.3 Discover Pages with Low Conversions (If Applicable)
If your content has conversion goals (e.g., a “contact us” button, a download), filter for pages with:
- Decent
Views. - Very low
Conversions.
Here, the content might be engaging, but it fails to drive the desired action. Evaluate your calls to action (CTAs), their placement, clarity, and the value proposition presented. Is the conversion path clear? Is there too much friction?
Step 5: Implement Optimization Strategies and Monitor
Identification is only half the battle. The real work begins with optimization. Don’t just make changes; track their impact rigorously.
5.1 Content Refreshes and Rewrites
For pages with low engagement, consider:
- Updating statistics and examples: Ensure all data is current for 2026.
- Improving readability: Use shorter paragraphs, bullet points, and subheadings.
- Adding multimedia: Images, videos, or interactive elements can significantly boost engagement.
- Deepening insights: Provide more actionable advice or unique perspectives.
After a significant rewrite, update the publish date if appropriate. Google often favors fresh, high-quality content. I once saw a client’s blog post jump from page 3 to page 1 for a competitive keyword simply by updating its statistics and adding a new expert quote, proving that sometimes small changes make a big difference.
5.2 SEO Adjustments
For pages with low CTR or poor search visibility:
- Rewrite title tags and meta descriptions: Focus on compelling language and primary keywords. Check the character limits to avoid truncation in search results.
- Enhance internal linking: Link to the underperforming content from relevant, high-authority pages on your site.
- Optimize for featured snippets: Structure your content with clear definitions and answer common questions directly.
- Address core web vitals: Ensure the page loads quickly and is mobile-friendly. Google’s Core Web Vitals report in Search Console provides specific recommendations.
5.3 A/B Testing
For critical underperforming assets, implement A/B tests. Tools like Google Optimize (though its capabilities are evolving rapidly in 2026) or third-party solutions allow you to test variations of headlines, intros, CTAs, or even entire sections. This provides definitive data on what improvements resonate with your audience.
5.4 Ongoing Monitoring
The content audit is not a one-time event. Schedule regular reviews (quarterly or bi-annually) of your Looker Studio dashboard. Set up alerts for significant drops in engagement or search performance for your critical content pieces. Continuous monitoring ensures your content remains a valuable asset, not a digital dust collector.
Regularly reviewing your content performance through a data-driven lens prevents accumulation of digital dead weight and ensures every asset contributes meaningfully to your marketing objectives.
How frequently should a content audit be performed?
A full, deep content audit using BI analysis should be conducted at least annually. However, a lighter review of key performance indicators in your Looker Studio dashboard should occur monthly or quarterly to catch significant underperformance early.
What is a good engagement rate for blog content?
A “good” engagement rate varies by industry and content type, but for most informational blog content, anything consistently below 40% typically indicates a need for review. For high-value, in-depth articles, aim for 60% or higher.
Can I use other BI tools besides Looker Studio for this process?
Yes, while Looker Studio is free and integrates well with Google products, you can use other BI tools like Tableau or Power BI. The core principle remains the same: connect your analytics and search console data, then build dashboards to visualize key performance metrics.
What if I don’t have “Content Publish Date” as a custom dimension in GA4?
Without a “Content Publish Date” dimension, you can segment your content by manually categorizing it into age groups (e.g., “published 2025,” “published 2024,” “evergreen”) and applying filters in Looker Studio. This is less precise but still allows for some normalization.
Should I delete underperforming content?
Deletion should be a last resort. First, attempt to optimize the content through refreshes, rewrites, and SEO adjustments. If, after optimization, the content still performs poorly and provides no value, consider redirecting it to a more relevant, higher-performing page.