Skip to content
SEO Strategy Assistant Documentation
Start Here
Setup
Reference Docs
More
Share
Explore
Reference Docs

icon picker
Data Sources, Dimensions, Metrics, Sorts and Filters

This page contains a list of all of the data sources, dimension, metrics, sorts and filters used in the Data Studio template.

Featured Snippet Opportunities

Data Origin: SEMrush
Data Source: "data source_Featured Snippets" from Google Sheet
Dimensions: Keyword, URL, Position
Metrics: Search Volume
Sort: Search Volume (descending)
Filter: Include >> Position >> Less Than or Equal To >> 10
⁠

Keywords Ranking On Pages 2 & 3

Data Origin: SEMrush
Data Source: "data source_All Organic Positions" from Google Sheet
Dimensions: Keyword, URL
Metrics: Position, Search Volume
Sort: Search Volume (descending)
Filter: Include >> Position >> Greater Than >> 10 AND Include >> Position >> Less Than >> 31
⁠

Competitor Keyword Gap

Data Origin: SEMrush
Data Source: "data source_Keyword Gap " from Google Sheet
Dimensions: Keyword, URL
Metrics: Search Volume, Your Rank, Competitor Rank
Sort: Traffic (descending)
Filter: Include >> Competitor Gap Opportunity >> Equal To >> Yes
⁠

Competitor Top Pages

Data Origin: SEMrush
Data Source: "data source_Competitor Pages" from Google Sheet
Dimensions: URL, Monthly Organic Traffic, Top Keyword, Search Volume, Your Rank, Competitor Rank
Sort: Monthly Organic Traffic (descending)
⁠

Technical Crawl - Total URLs Crawled

Data Origin: Screaming Frog
Data Source: "data source_Screaming Frog" from Google Sheet
Metrics: Total URLs Crawled
⁠

Technical Crawl - Indexable URLs

Data Origin: Screaming Frog
Data Source: "data source_Screaming Frog" from Google Sheet
Metrics: Indexable URLs
Filters: Include >> Indexability >> Equal To >> Indexable
⁠

Technical Crawl - Non-Indexable URLs

Data Origin: Screaming Frog
Data Source: "data source_Screaming Frog" from Google Sheet
Metrics: Indexable URLs
Filters: Exclude >> Indexability >> Equal To >> Indexable
⁠

Technical Crawl - Redirect URLs

Data Origin: Screaming Frog
Data Source: "data source_Screaming Frog" from Google Sheet
Metrics: Redirected URLs (3xx)
Filters: Include >> Status Code >> Between >> 300 and 399
⁠

Technical Crawl - Broken URLs

Data Origin: Screaming Frog
Data Source: "data source_Screaming Frog" from Google Sheet
Metrics: Broken URLs (4xx)
Filters: Include >> Status Code >> Between >> 400 and 499
⁠

Technical Crawl - URLs with Server Errors

Data Origin: Screaming Frog
Data Source: "data source_Screaming Frog" from Google Sheet
Metrics: URLs with Server Errors (5xx)
Filters: Include >> Status Code >> Between >> 500 and 599
⁠

Technical Crawl - Missing Title Tags

Data Origin: Screaming Frog
Data Source: "data source_Screaming Frog" from Google Sheet
Metrics: Missing Title Tags
Filters: Include >> Title 1 Length >> Equal To >> 0 AND Include >> Status Code >> Equal To >> 200 AND Include >> Content >> Contains >> html
⁠

Technical Crawl - Long Titles

Data Origin: Screaming Frog
Data Source: "data source_Screaming Frog" from Google Sheet
Metrics: Long Title Tags
Filters: Include >> Title 1 Length >> Greater Than >> 60
⁠

Technical Crawl - Short Title Tags

Data Origin: Screaming Frog
Data Source: "data source_Screaming Frog" from Google Sheet
Metrics: Short Title Tags
Filters: Include >> Title 1 Length >> Less Than >> 30 AND Include >> Content >> Contains >> html AND Exclude >> Title 1 Length >> Equal To >> 0
⁠

Technical Crawl - Missing Meta Descriptions

Data Origin: Screaming Frog
Data Source: "data source_Screaming Frog" from Google Sheet
Metrics: Missing Meta Descriptions
Filters: Include >> Title 1 Length >> Equal To >> 0 AND Include >> Status Code >> Equal To >> 200 AND Include >> Content >> Contains >> html
⁠

Technical Crawl - Long Meta Descriptions


Data Origin: Screaming Frog
Data Source: "data source_Screaming Frog" from Google Sheet
Metrics: Long Meta Description
Filters: Include >> Meta Description 1 Length >> Greater Than >> 155
⁠

Technical Crawl - Short Meta Descriptions

Data Origin: Screaming Frog
Featured Snippet Opportunities
Keywords Ranking On Pages 2 & 3
Competitor Keyword Gap
Competitor Top Pages
Technical Crawl - Total URLs Crawled
Technical Crawl - Indexable URLs
Technical Crawl - Non-Indexable URLs
Technical Crawl - Redirect URLs
Technical Crawl - Broken URLs
Technical Crawl - URLs with Server Errors
Technical Crawl - Missing Title Tags
Technical Crawl - Long Titles
Technical Crawl - Short Title Tags
Technical Crawl - Missing Meta Descriptions
Technical Crawl - Long Meta Descriptions
Technical Crawl - Short Meta Descriptions
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.