and evaluate the terms individually
Posted: Thu Jan 30, 2025 7:16 am
At this point, the process is pretty similar to gathering keywords for your own site. You can download the “common keywords” here, which are just the ones that your site and theirs rank for. But keep in mind that to find keywords you’re completely missing, you need to download your competitor’s full list of organic keywords.
Just like with your own site, you can do this in both Google Ads and SEMrush. But within SEMrush, you can also limit the download to terms for which your competition ranks above a certain point, say 20 or 30, assuming that if they don't rank lower than that, it might not be the best term for you. I prefer to download the full list.
With SEMrush you can also apply filters and remove terms that include your competitors' brand names. Moz will likely rank for a group of keywords that include "Moz," but they wouldn't really be very relevant to a SEMrush organic keyword strategy.
Organize keyword data in Excel
When you’re working with competitive keywords, you need to find jiangsu mobile database a way to combine the data so that all the information for a keyword is on a single line in your spreadsheet. When you have data for a single site that comes from multiple sources, say multiple Google Ads sheets, SEMrush, and Ahrefs, if you don’t already know how to do this, do yourself a favor and learn how to remove duplicates in Excel.
Removing duplicates in Excel is easily done on the Data tab. Select Remove Duplicates and check only the box that corresponds to the column for which you want to remove duplicates. In the case below it is "Keyword".
Just like with your own site, you can do this in both Google Ads and SEMrush. But within SEMrush, you can also limit the download to terms for which your competition ranks above a certain point, say 20 or 30, assuming that if they don't rank lower than that, it might not be the best term for you. I prefer to download the full list.
With SEMrush you can also apply filters and remove terms that include your competitors' brand names. Moz will likely rank for a group of keywords that include "Moz," but they wouldn't really be very relevant to a SEMrush organic keyword strategy.
Organize keyword data in Excel
When you’re working with competitive keywords, you need to find jiangsu mobile database a way to combine the data so that all the information for a keyword is on a single line in your spreadsheet. When you have data for a single site that comes from multiple sources, say multiple Google Ads sheets, SEMrush, and Ahrefs, if you don’t already know how to do this, do yourself a favor and learn how to remove duplicates in Excel.
Removing duplicates in Excel is easily done on the Data tab. Select Remove Duplicates and check only the box that corresponds to the column for which you want to remove duplicates. In the case below it is "Keyword".