ahrefs

semrush

Designed to help SEO professionals identify strong page targets with low link authority, the Authority Opportunities tool is essential for enhancing site rankings. Users can import SEMRush keyword data and Ahrefs backlink reports, specifically focusing on dofollow links. The tool requires CSV uploads for both site pages/keywords and backlinks, and provides options to exclude data based on minimum search volume (MSV) and brand-related terms. 

This streamlined process involves downloading specific data, uploading it through an intuitive interface, setting exclusions, and submitting for analysis.

### Tool Inputs:

1. **SEMRush Keywords Data (CSV)**: Upload CSV containing keyword data from SEMRush. Specific location in SEMRush to find the download is found in the "Instructions" tab of this page.
2. **Ahrefs Backlinks Data (CSV)**: Upload CSV with dofollow backlink data from Ahrefs. Specific location in Ahrefs to find the download is found in the "Instructions" tab of this page.
3. **Minimum Search Volume (MSV)**: Set a threshold to exclude keywords below a certain search volume.
4. **Brand Exclusion**: Filter out keywords containing specified brand terms.

### Instructions:

Please review the 'Instructions' tab on this page to receive detailed instructions on how to use this tool.

Combine striking distance non-brand with Ahrefs link report to find strong page targets quickly!

Combine striking distance non-brand with Ahrefs link report to find strong opportunities quickly!

Authority Opportunities - Find Strong Page Targets with Low Link Authority

authority.svg

authority

Designed for SEO professionals to compare page (and subsequent keyword) strategies between different domains efficiently, the Competitive Keyword Analysis tool isn't your typical SEO keyword gap tool. Users can upload client and competitor data in CSV format, with each file containing specific required headings. The tool allows users to exclude keywords based on volume and brand-related terms. By adjusting the Minimum Search Volume (MSV) and brand exclusions, users can refine their datasets to focus on relevant keywords.  

The process is straightforward: download data from SEMRush, upload it via a simple drag-and-drop interface, adjust filters, and submit for analysis.

### Tool Inputs:

1. **Client Data (CSV)**: Upload CSV file with data specific to the client's domain.
2. **Competitive Data (CSV)**: Upload CSV file with competitor's domain data.
3. **Volume Exclusion**: Set a minimum search volume to filter out less significant keywords.
4. **Brand Variants**: Exclude keywords that include specific brand-related terms.


### Instructions:

Please review the 'Instructions' tab on this page to receive detailed instructions on how to use this tool.

Designed for SEO professionals to compare keyword strategies between different domains at scale, the Competitive Keyword Analysis tool isn't your typical SEO keyword gap tool. Users can upload client and competitor data in CSV format, with each file containing specific required headings.  

The tool allows users to exclude keywords based on volume and brand-related terms. By adjusting the Minimum Search Volume (MSV) and brand exclusions, users can refine their datasets to focus on relevant keywords.
  
The process is straightforward: download data from SEMRush, upload it via a simple drag-and-drop interface, adjust filters, and submit for analysis.

Designed for SEO professionals to compare keyword strategies between different domains at scale, the Competitive Keyword Analysis tool isn't your typical SEO keyword gap tool.

Competitive Keyword Analysis | SEMRush Tool

relevance.svg

relevance

Convert documents from Word Docs (.docx extension) to HTML. More conversion types coming in the future.

Convert Word Docs (.docx) to HTML

general.svg

general

Google Search Console (GSC) API Data Extraction - Quick and Customizable.

search console

Google Search Console (GSC) API Data Extraction - Quick & Customizable

url - capitalized

The Internal Linking Opportunity Generator is designed for SEO professionals to optimize their site architecture and authority flow through strategic internal linking. This tool helps users identify key internal linking opportunities by analyzing aggregated crawl data and SEMRush keyword targets to look for pre-existing text that can benefit from an internal link addition.  

Users need to upload CSV files containing website URLs and corresponding SEMRush data. The tool offers customization options like setting minimum search volume (MSV) thresholds and excluding brand-related keywords to refine the results.

### Tool Inputs:

1. **Crawl URLs (CSV)**: Upload CSV files with a list of site URLs.
2. **SEMRush Keyword Targets (CSV)**: Upload CSV files with keyword data from SEMRush.
3. **Minimum Search Volume (MSV)**: Exclude keywords with search volumes below a specified threshold.
4. **Brand Exclusions**: Exclude keywords associated with certain brands.

### Instructions:

Please review the 'Instructions' tab on this page to receive detailed instructions on how to use this tool.

Two inputs. Page + keyword list, as well as a URL list to scrape to review on-page text for linking opportunities. 

SEO Internal Linking Opportunity Generator

technical.svg

technical

The scrape URLs CSV column header must be 'URL'. If 'Crawl Type' is JavaScript Enable, the max URLs is 50. Otherwise, the max URLs for static HTML is 200. Both input files have to be CSV files!

Compare 2 time periods to see changes in page and keyword level KPIs!

Automated Keyword Change Analysis | SEMRush Tool

matching - match

matching - input

Input 2 CSVs for values and matching criteria to find all matches, match types, and reasoning!

Find Every Match Type - Opportunity Analysis on Steroids

Input 2 CSVs for values and matching criteria to find all matches.

Automated Many to Many Joins | CSV Input & Download Tool

Insert text to quickly find patterns using ngrams.

Ngram Analyzer

No fancy 3rd party tools are needed. Just import CSV with a column named 'URL', and you are good to go.

URL Extraction / Splitter - Quick CSV Input

gsc-page-and-query-only

Use Google Search Console data to get insights into potential opportunities for page-level consolidation based on apparent keyword cannibalization.

SEO Cannibalization Analysis - GSC Data Input

Maximize your SEO investment with precise ROI insights.

Accurately measure the success of your SEO campaigns with our intuitive ROI Calculator. Input your traffic goals, investment details, and profit metrics to track performance and make data-driven decisions. 

SEO ROI Calculator - Free Tool To Measure SEO ROI

Estimate the financial impact of SEO changes with our dynamic tool. Predict how positive or negative adjustments might affect monthly traffic and revenue. Plan and assess risks effectively.

SEO Revenue Impact Estimator: Predict Potential Financial Outcomes of SEO Changes

Analyze SEO Data with our CASE Statement Generator Tool. Easily create SQL CASE statements for filtering and processing data based on custom conditions. Improve your SEO analysis workflow with precise data manipulation.

SQL CASE Statement Generator for Looker Studio - Build Data Segments Fast

stack id

Convert horizontally aligned data to vertically - no more "transposing" in excel.

CSV Data Cleaning - Stack Rows to Cols

Take multiple CSV files from the same data sources and quickly convert them into 1 single file.

Spreadsheet Stack - Convert Multiple CSVs Into Single File

schema tool

Check client vs competitor structured data on-page in seconds.

Structured Data Analysis - Competitive Comparison

urlAndTagReference

Quickly check if target striking distance (top 30) keywords are optimized within your <title> tags!

Must have column headers 'URL' and 'Tag' to work!

Title Tag Quick Wins - Keyword Optimization Checker

Upload a CSV. Choose a dimension, a metric, and a number of instances. The tool will return the top values for that dimension (watch the tutorial for more context).

Get The Top "N" Per Dimension - CSV Data Cleaning Tool

Group SEMRush data and understand KPIs by URL directory (subfolder).

URL Grouping KPI Analysis | SEMRush Tool

Get keyword data at scale from the SEMRush API to expedite keyword research and exploration.

All SEO Tools

Authority Opportunities

Competitive Keyword Analysis

Convert Word Docs (.docx) to HTML

GSC API Data Extractor

Internal Linking Opportunity Generator

Keyword Changes

Match Types - Every Type (Between 2 Datasets)

Match Types - Many to Many (Between 2 Datasets))

Ngram Analyzer

Quick URL Segment Builder

SEO Cannibalization Analysis (GSC Data Input)

SEO ROI Calculator

SEO Revenue Impact Estimator

SQL CASE Statement Generator for Looker Studio

Spreadsheet Cleanup - Rows to Columns Converter

Spreadsheet Stack - Convert Multiple CSVs Into Single File

Structured Data Analysis - Competitive Comparison

Title Optimization Checker

Top "N" Per Dimension - CSV Data Cleaning

URL Grouping KPI Analysis

URL-Level Keyword Data (SEMRush API)