Project: SEO Keyword Optimization Audit Report
Enhancing search visibility through detailed keyword analysis and strategic insights.
Client: Medical Company
Challenge
The medical company needed a comprehensive analysis of their keyword rankings to identify opportunities for optimization and improve search visibility.
Solution
I conducted an SEO keyword optimization audit using Google Search Console and Looker Studio. The audit involved analyzing all keyword rankings and grouping them based on search intent into categories such as service inquiry, user action, general brand, and corporate-related searches. The service inquiry category was further broken down by branded vs. non-branded, service types, location inquiry, and blended service + location inquiry
Key Actions:
Advanced Regex Query Writing Suited for Keyword Grouping: Utilized advanced regex code to group keywords based on search intent, enabling a more structured analysis.
Opportunity Identification: Created different keyword opportunity groups including:
High impression/low CTR %
Page 1/position 4-10 rankings
2nd/3rd page rankings
Content strategy insights
Data Visualization: Developed a dynamic dashboard in Looker Studio with a metric selector to easily visualize different metrics such as impressions, clicks, CTR%, and average ranking.
Technical Details:
Tools Used: Looker Studio, Google Search Console, Google Sheet
Responsibilities: Keyword analysis, grouping by search intent, opportunity identification, data visualization
Impact:
Strategic Insights: Provided actionable insights for content strategy and keyword optimization.
Improved Visibility: Identified key areas for improving search visibility and performance.
Enhanced Reporting: Created a user-friendly dashboard that allowed for dynamic metric selection and visualization, making it easier to track and analyze performance.
View the Report:
Check out the detailed SEO keyword optimization audit report via Looker Studio.
