Overview
Keith demonstrated the new Rank and Wizard SEO opportunity analysis tool, which uses data from Looker Studio, Google Search Console, Google Analytics, CSV exports and an OpenAI key to identify ranking opportunities and recommended improvements.
Tool Setup
- The tool is available through the Rank and Wizard classroom under Rank and Wizard apps, with additional tools available on premium and mastermind plans.
- Starter users now have videos covering Google Tag Manager, Google Search Console, Google Analytics and Data Studio report setup.
- The required report includes users, keyword overview, top pages and query-plus-page data, including potential keyword cannibalisation.
Analysis Workflow
- The user enters the site name, location, reporting period, users, sessions, clicks, impressions, CTR, average position and available conversion data into a Google Sheet.
- Four CSV files are uploaded: the Looker Studio analysis sheet, keyword overview, top pages table and Google Search Console query-plus-page data.
- Data quality checks estimate the OpenAI cost before the report is generated and saved in Markdown, with PDF download and report history available.
Findings
- The example for Bedbug Services Clearwater covered the last 28 days: 16 users, 22 sessions, 3 clicks, 1,307 impressions, 20.23% CTR and average position 23.66.
- The report identified low visibility and engagement, possible title and meta-description issues, and opportunities around Oldsmar, Dunedin and Safety Harbour.
- The SEO opportunity score was 2. Conversion data was incomplete because call and form activity was not fully available. Behaviour insights may be added later.
Outline
Product Access
- Keith introduced the SEO opportunity analysis tool in Rank and Wizard.
- Access is available through the classroom, with plan-dependent tool availability.
- Starter onboarding includes setup guidance for Google Tag Manager, Google Search Console, Google Analytics and Data Studio.
Data Preparation
- The required Looker Studio report contains user, keyword, top-page and query-plus-page views.
- A Google Sheet captures site details, location, reporting period, traffic metrics, search metrics and any available conversion data.
- The reporting period in the example was the last 28 days.
Report Generation
- The user exports the sheet and three report views as CSV files, then uploads them to the analysis tool.
- An OpenAI key is required in the tool settings.
- Data quality and estimated cost are checked before generating and saving the analysis.
- Reports are available in Markdown, PDF and saved report history.
SEO Insights
- The example report showed 1,307 impressions, 3 clicks, 20.23% CTR and average position 23.66.
- Bed bug service searches around Safety Harbour, Oldsmar and Dunedin indicated possible expansion opportunities.
- The report highlighted low visibility, low engagement, potential title and meta-description weaknesses, content relevance issues and incomplete conversion data.
- The tool is intended to make an analysis previously performed manually more efficient.
Enjoy!