how you compete against all

[rochon.a1.119]

img-semblog
You can also view the entire competitive landscape for a term in one row, so you can see the competing websites you've analyzed. Add all the terms to a single sheet and make sure each website's current position is in its own column.

image.png

By now, you should be using an Excel PivotTable. If you don't know how to use PivotTables, here's a quick overview, but you can also read this tutorial or this one by Microsoft for a more detailed step-by-step guide.

I can't believe I worked at SEP for so many years without knowing jiangsu mobile database how to do this. It will literally save you hundreds of hours. Create a pivot table in a new spreadsheet in your Excel file by selecting "Insert" and then "Pivot Table."

image.png

Then select all the columns you want to merge from your other spreadsheet.


image.png
When you create your pivot table, make sure your Rows are your Keywords (you can drag the keywords field into the rows area). Drag the other fields into the Values ​​area and make sure to set metrics like search volume, keyword difficulty, CPC to something like the maximum value rather than the sum of the values ​​- this will automatically add all the data for each keyword into a single row.


image.png
Copy all the data and paste it as text into a new spreadsheet.

image.png

For each of your keywords you can now see the terms for which you and your competitors rank. If most of your competitors are currently ranking for a term, it's likely that it's also quite relevant and important for you to optimize for.

I often also add a "minimum" field (e.g. formula =MIN(E2,F2,G2,H2,I2,J2,K2) in Excel and filter it on a specific "minimum" position. This formula displays the lowest value within the specified range. For organic rankings, the lowest number is obviously the best rank.

For example, if neither my site nor any of my competitors rank in the top 30 or lower (the first three pages of Google), I may consider those terms to be a much lower priority. You should still analyze them, as they may be relevant, but often these end up being terms that one of those sites ranked for because of a particular piece of content, but it's not particularly relevant.