Skip to content

SEO Strategy Assistant Documentation

More

Share

Explore

Reference Docs

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

Data Source: "data source_Screaming Frog" from Google Sheet

Metrics: Short Meta Descriptions

Filters: Include >> Meta Description 1 Length >> Less Than >> 70

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.