Repeat steps 2-6 for any additional keywords
Posted: Tue Dec 17, 2024 5:55 am
Repeat the process you followed with your original keyword but with additional topics that you think your site should target.
Enter your first new topic in the search bar and see another Phrase Match report with the filters you want.
Once you have another list of target germany phone number list keywords, export the list and repeat for each related topic you are interested in. Send all your exports to the Keyword Strategy Builder list .
8. Update your master list metrics in the Keyword Strategy Builder
The next step is to export your master list from Keyword Strategy Builder . The great thing about this tool is that you can update your metrics before exporting your list to ensure your exported file has the most up-to-date metrics.
Simply hit the “Refresh Metrics” button above the list to get the latest Semrush data on competition level, KD%, SERP features, click potential, and top competitors.
img-semblog
Once the list is updated, the rows will be green and you will see the click potential and other metrics updated.
img-semblog
Then, export your list to a spreadsheet .
This spreadsheet will be a valuable reference document during your SEO or PPC campaign.
There will be a column for the keyword, one for the search volume, one for the keyword difficulty index, one for the CPC, one for the competition level, one for the number of results, and finally one for the trend. The number of results and the trend do not matter much in this process, so you can ignore these columns or delete them from the spreadsheet.
A simple trick to organize your spreadsheet is to add conditional formatting to color your metric columns .
First, add filters to your document and highlight the column you want to format.
Then, make sure you are in the “Home” tab and select Conditional Formatting to add a color scale to each column that measures values (volume, KW difficulty, CPC, and competitive density).
Enter your first new topic in the search bar and see another Phrase Match report with the filters you want.
Once you have another list of target germany phone number list keywords, export the list and repeat for each related topic you are interested in. Send all your exports to the Keyword Strategy Builder list .
8. Update your master list metrics in the Keyword Strategy Builder
The next step is to export your master list from Keyword Strategy Builder . The great thing about this tool is that you can update your metrics before exporting your list to ensure your exported file has the most up-to-date metrics.
Simply hit the “Refresh Metrics” button above the list to get the latest Semrush data on competition level, KD%, SERP features, click potential, and top competitors.
img-semblog
Once the list is updated, the rows will be green and you will see the click potential and other metrics updated.
img-semblog
Then, export your list to a spreadsheet .
This spreadsheet will be a valuable reference document during your SEO or PPC campaign.
There will be a column for the keyword, one for the search volume, one for the keyword difficulty index, one for the CPC, one for the competition level, one for the number of results, and finally one for the trend. The number of results and the trend do not matter much in this process, so you can ignore these columns or delete them from the spreadsheet.
A simple trick to organize your spreadsheet is to add conditional formatting to color your metric columns .
First, add filters to your document and highlight the column you want to format.
Then, make sure you are in the “Home” tab and select Conditional Formatting to add a color scale to each column that measures values (volume, KW difficulty, CPC, and competitive density).