ML-enabled SERP Analysis Data Studio template
Best for: For SEOs who analyse SERPs for a set of keywords and want competitors, entities, sentiment and intent in one visual report, without writing code.
Overview
A free Data Studio template I built for SERP analysis with machine learning, first presented at brightonSEO in 2022. Three companion Google Sheets pull SERP data from DataForSEO, analyse entities, entity sentiment and sentiment with Google Cloud's Natural Language API, and label titles and meta descriptions with OpenAI's GPT-3. The dashboard turns the results into a visual playground: share of search by domain, site categories, entities and sentiment against rankings.
Who it's for
For SEOs who analyse SERPs for a set of keywords and want competitors, entities, sentiment and intent in one visual report, without writing code.
Questions it answers
- Who ranks for my keywords, and how is share of search split?
- Which entities appear in titles and meta descriptions, and how do they relate to rankings?
- Are ranking pages leaning positive or negative towards my brand?
- What site category or search intent does each result represent?
Key features
- Competitor and share-of-search analysis
- Entity and entity-sentiment analysis of titles and meta descriptions
- Sentiment of titles and meta descriptions against ranking position
- Site-category and search-intent labels
Set it up in minutes
- Follow the template page for the three companion Google Sheets: https://lazarinastoy.com/resources/google-looker-studio-dashboard-templates/seo-serp-analysis-with-machine-learning/
- Run the sheets for your keywords to pull and analyse the SERP data.
- Make a copy of the Data Studio template and connect it to your sheets.