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:
- Segment keywords into different subsets using a Jupyter Notebook (including brand/non-brand, SERP intent, intents, question words, etc.),
- Load the data into Power Bi*,
- 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.