Skip to content
I've just launched MLforSEO ✨ - a training platform, with free resources to help organic search marketers harness machine learning for task automation.
LAZARINA STOY.

Organic Search & ML Consultant

Subscribe to MLforSEO ✨
  • Written Content
    • SEO
    • Data Science and Machine Learning
    • Analytics
    • Consulting
  • Resources
    • Google Looker Studio Dashboard Templates
    • Google Sheets Resources
    • SEO Checklists
    • Webinar and Podcast Appearances
    • Guest Contributions
    • Conference Decks and Presentations
    • Courses
  • About
  • Speaking Schedule

Semrush

Home » Semrush

Google Sheets Formulas for SEOs
Posted inAnalytics SEO

12 Google Sheets Formulas for SEO Keyword Research & Content Analysis

Discover Google Sheets formulas for SEO keyword research and content analysis. This continuously updated guide offers innovative strategies for categorizing and understanding large datasets, enhancing your SEO efforts with efficient data organization and insightful analysis.
Posted by By Lazarina Stoy March 13, 2024Tags: Google Sheets, Content Strategy, Keyword Research, Search Intent, Semrush
Continuous improvement approach for building an intent-driven website architecture
Posted inSEO

How to Build a Search Intent-First Website Architecture

Background to Intent-driven Website Architecture Website planning is complex and it can get quite messy and we, SEOs, are often involved in this process. The trouble is that we are…
Posted by By Lazarina Stoy March 13, 2022Tags: Search Intent, Link Strategy, Semrush, Site Architecture
hand
Posted inSEO

How to Do Intent-driven International Keyword Research

Background, strategies and tactics for handling the complexities of keyword research in real-life, while also touching upon different use-cases such as international keyword research and search intent categories in different industries.
Posted by By Lazarina Stoy November 18, 2021Tags: Looker Studio (formerly Data Studio), Content Strategy, International SEO, Keyword Research, Search Intent, Semrush
Posted inAnalytics SEO

How to Incorporate Search Intent Classification in Looker Studio

Search Intent Keyword Classifier Looker Studio Dashboard Template (with Semrush data) https://www.youtube.com/watch?v=_WSQc1DhB_A Background Over the past few years, there has been a lot of talk in the SEO industry about…
Posted by By Lazarina Stoy August 18, 2021Tags: Looker Studio (formerly Data Studio), Ahrefs, Content Strategy, Keyword Research, Search Intent, Semrush
code screen
Posted inSEO Analytics

5 Ways to Connect Semrush With Looker Studio

Semrush is one of the best all-in-one platforms for digital marketing and analytics. Learn about the five ways to connect Semrush with Data Studio.
Posted by By Lazarina Stoy June 14, 2021Tags: Looker Studio (formerly Data Studio), API, Integrations, Semrush
keyword
Posted inSEO

How To Do Keyword Research Using Semrush and Google Sheets

Learn how to do keyword research with Semrush. Find question-type keywords via a REGEX match filter. Step-by-step beginner-friendly tutorial.
Posted by By Lazarina Stoy May 21, 2021Tags: Semrush, Keyword Research
stacked charts
Posted inAnalytics

How to Create Stacked Combo Charts that Display Negative Numbers in Google Looker Studio

A step-by-step tutorial for creating negative value custom fields, using SEMrush’s Looker Studio connector and Backlinks History data. You have some beautiful data, showing loss and gain of the same…
Posted by By Lazarina Stoy March 7, 2021Tags: Looker Studio (formerly Data Studio), Semrush

I'm currently training hundreds of forward-thinking marketers how to harness the power of machine learning for organic search and digital marketing automation.

Join the MLforSEO academy
Explore resources by type
  • Conference Decks and Presentations
  • Google Looker Studio Dashboard Templates
  • Google Sheets Templates
  • SEO Checklists
  • Video Tutorials & Lessons
  • Courses
  • Guest Contributions
  • Webinar and Podcast Appearances

Explore resources by topic

API (7) Content Localization (1) Content Strategy (4) Core Web Vitals (2) Data Blending (3) Data Reporting & Annotations (3) Data Storytelling (3) Entity Analysis (3) Integrations (3) International SEO (2) Keyword Research (4) Link Strategy (5) Looker Studio (formerly Data Studio) (15) Machine Learning (8) NLP (10) On-Page Optimizations (5) Programmatic SEO (2) Python (2) Search Intent (5) Semrush (7) Sentiment Analysis (3) SEO audits (2) Site Architecture (5) Technical SEO (10) Topic Modelling (3) Troubleshooting (3) video SEO (1) Web Development (2) Wix (1) YouTube SEO (2)

Jump to a Looker Studio Dashboard
  • SEO SERP Analysis with Machine Learning – Looker Studio Template
  • Search Intent Classification Looker Studio Template
  • Core Web Vitals Looker Studio Template
  • Google URL Inspection API Looker Studio Template
  • Custom Expert Commentary Demo with Google Analytics (GA4)
  • Looker Studio template for adding custom event annotations to Search Console data
Take one of my MLforSEO courses ✨
  • Introduction to Machine Learning for SEOs Course
  • Semantic ML-enabled Keyword Research Course
Let’s connect
  • Subscribe on YouTube
  • LinkedIn
  • Medium
  • Twitter
See my projects
  • MLforSEO ✨
  • Women in Marketing – Bulgaria

Buy Me a Coffee

Copyright 2025 — LAZARINA STOY. ownership of La Stoy, Ltd. All rights reserved.
Scroll to Top