Authority Opportunities
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:
- 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.
- 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.
- Minimum Search Volume (MSV): Set a threshold to exclude keywords below a certain search volume.
- 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.
SEMRush Keywords Import
Drag & drop or choose file.
Ahrefs Links Import (Only 'utf-8' CSVs)
Drag & drop or choose file.
1. Download site page / keyword data from SEMRush.
- Navigate to https://www.semrush.com/analytics/organic/positions/.
- Individually input and download each of the desired domains into the search bar within SEMRush (1 by 1 unfortunately, somewhat tedious).
- While you have to export 1 by 1, keep in mind that you can upload multiple domains at once into the SEO Workflows UI (e.g., you can drop 5 separate CSVs into the SEMRush CSV input - which sometimes can be helpful for extremely large scale sites given the SEMRush export row limits.
- Click the 'Export' CTA on the bottom righthand side of the 'Organic Keywords Trend' and download as CSV files.
2. Ahrefs Backlink Report (Dofollow Backlinks Only) - Legacy Report Link in Dropdown
- Download links from the legacy backlink report - must be dofollow backlinks only.
- Get the report from here by replacing 'deptagency.com' in URL param with your domain! - https://app.ahrefs.com/v2-site-explorer/backlinks?anchorRules=&bestFilter=all&domainNameRules=&followType=dofollow&grouping=all&highlightChanges=30d&history=all&limit=50&mode=subdomains&offset=0&refPageAuthorRules=&refPageTitleRules=&refPageUrlRules=&sort=traffic&sortDirection=desc&surroundingRules=&target=deptagency.com%2F&targetUrlRules=
- Ensure you download as UTF-8 CSV (NOT THE UTF-16).
3. Input downloaded data into their respective Dropzone's within the interface.
- Either click on the dropzone or drag and drop files onto the dropzone.
- Double check to ensure all the files have the .csv extension when adding!
4. Update the MSV and Brand exclusion inputs.
- MSV input will exclude all data less than this value. E.g., if you add 100, no keywords with less than 100 volume will be in output dataset.
- Brand input will exclude all keywords that contain the word / phrase. E.g., '3q' would eliminate '3q / 3qdigital / 3q digital / etc...'
