English Español Deutsch Français Italiano Português (Brasil) Русский 中文 日本語

5 Hours of SEO | Scaling Ranking Data Analysis: Organizing, Visualizing, and Having Some Fun with SEMrush Data


We don’t always have access to first-party data (😔), buuuut luckily, we can use third-party data to develop our understanding and help derive directional business intelligence and insights (😊).

During the session, we are going to spend 15 minutes going through one method of gleaning insights from a large-scale ranking dataset. Using SEMrush’s organic ranking report* (our sizeable third-party dataset for today), we’re going to:

  1. Segment keywords into different subsets using a Jupyter Notebook (including brand/non-brand, SERP intent, intents, question words, etc.),
  2. Load the data into Power Bi*,
  3. Visualize some data to support identifying insights.

If you love content, ranking analyses, or are passionate about efficiencies in reporting, you’re going to enjoy the fifth session of 5 Hours of SEO with Alexis Sanders!

*Note: regardless of your toolset (for ranking and BI visualization), this methodology can help you identify insights.

This thirty-minute session is hosted by Nik Ranger.

All levels

Check out other webinars from this series