Overall organic traffic compared to competitors

bajadas864@huiz

First make a list of your competitors’ domains. We’ll be using only direct business competitors because there’s always going to be blogs and other websites popping up in the top results. These may get significant traffic in your industry, but they don’t own any market share. Next, paste you and your competitors’ domains into Ahrefs’ Batch Analysis to see each site’s estimated organic traffic and the number of keywords they rank for. 2 batch analysis keywords traffic Export the data and get rid of anything other than the Target, Keywords, and Traffic columns. Then, create two new columns for keyword and traffic shares. Enter this formula in row one of the first new column: =iferror(arrayformula(if(row(B$1:B)=1,"Keyword share",if(B1:B="","",B1:B/sum($B$2:B))))) And this formula in the first row of the second new column: =iferror(arrayformula(if(row(C$1:C)=1,"Traffic share",if(C1:C="","",C1:C/sum($C$2:C))))) Sidenote.


Here’s an example sheet with cells with formulas highlighted green. Now comes the drawback Special Data of this quick method. The broader the target audience of a given website, the more keywords and traffic opportunities there is. That means websites with abnormally high keyword shares probably target a wider audience. On top of that, some sites rank for high-volume keywords with virtually no value for their business. Those can skew the data quite a bit. For example, one ‘competitor’ of ours gets a lot of organic traffic to a Spanish blog post explaining what a CEO is. 4 competitor low business value Although that pumps up their SOV when using this method, the blog post has pretty much zero ‘business value’ and is unlikely to attract any customers. In conclusion, take these numbers with a grain of salt.




We’ll move onto a method that eliminates these drawbacks and inaccuracies to a certain degree. 2. Tracking a representative sample of your industry keywords The only way to avoid the differences between websites’ target audiences is to choose the keywords you want to consider traffic from. The best approach here is to take your keyword research master sheet, paste all main keywords into Rank Tracker, add your competitors’ domains, and check the visibility in the Competitors overview tab: 5 rank tracker visibility2 The visibility metric shows the percentage of all clicks from your tracked keywords that land on the respective website. Just a couple of quick notes when doing this: First, you only want to track the main keywords. That’s the “fat head” keyword that gets the most clicks for a topic.