Skip to content
SEO Strategy Assistant Documentation
Share
Explore

Start Here

Introduction
I've been trying to get better at generating SEO strategies, so I am building a “SEO Strategy Assistant" dashboard in Google Data Studio.
The current version of the dashboard uses data from SEMrush and Screaming Frog to show the following:
Featured Snippet Opportunities - If you have keywords ranking in the top 10 AND those SERPs have a Featured Snippet available, making small changes to target those snippets drive quick traffic for clients.
Keywords Ranking on Pages 2 and 3 - Another quick win opportunity. If you have keywords ranking on pages 2 or 3, performing on page and content optimizations to those pages could move them to page 1.
Page Degradation - See pages that have declined in traffic over the last 30 days, 90 days, and year over year.
Competitor Keyword Gap - Review keywords where a competitor outranks you on page 1. Close the gap in content quality and on page optimization between you and your competitor, and you can steal their spot.
Top Competitor Pages - See your competitor's top pages by traffic. Use this to help define your site's content strategy.
Technical SEO Crawl Summary - Using data from Screaming Frog, get a high-level overview of the technical health of your site.
Templates

. I plan on continuing to iterate on this dashboard.
Roadmap
I plan on continuing to iterate on this dashboard. Here's some thoughts I have for a roadmap:
Show new keywords to target with new pages
Pages and keywords that have degraded in traffic month-over-month and year-over-year
Keywords that are underperforming for CTR
More technical SEO insights
Prioritizing opportunities by traffic gain
More automation.
Connect with Me
► On Twitter:

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.