Skip to main content

Benefit from our experts’ ideas

Brand SERP Domination Score Excel Template

Benefit from our experts’ ideas

Try our Excel template to easily calculate the Brand SERP Domination Score, a visibility metric we developed to visualize keyword-based market penetration in the top 20 search results.



The Brand SERP Domination Score explained

Search engine optimization contributes greatly to increasing the visibility of websites in the search results of Google and others. In the first instance, visibility therefore always depends on optimizing a domain. But to dominate a topic and its search results, you need a more holistic view of visibility.

If you look at how many brands belong to a group that follows a multi-brand strategy, it becomes clear that visibility cannot be assessed on the basis of one domain alone. It is much more important that the related domains dominate the search results together and do not compete with each other organically.

Other online marketing measures, such as digital PR, also often create external landing pages that point to a brand and likewise achieve good Google rankings. Some companies even get the chance to be visible with their brand for certain search terms exclusively through cooperation and sales partners like these. That is why a new metric is needed that no longer looks at organic visibility on the basis of one domain, but measures a brand’s visibility within the top 20 search results. This is exactly where the Brand SERP Domination Score comes in. It is defined as the estimated CTR of a keyword multiplied by a factor that rates the value of the rankings for a given brand.


In our free Excel template, the selection of keywords to monitor is limited to 5 search terms. The calculation of the Brand SERP Domination Score in our Excel file is also kept at a very simple level.

To evaluate the domains that mention a brand, we use the IsFoundOnPage() function of the popular Excel plugin SEOtools for Excel. Depending on the position (HTML title, H1 and link) and frequency of the brand mention, the corresponding relevance factor increases. You can adjust these factors as you see fit.


Download our Excel template now and see the idea of Brand SERP Domination for yourself! If you like our approach and are interested in a scalable tool solution, feel free to contact us.


Our Brand SERP Domination Score Excel template includes:

  • An annual template to document your own top 20 rankings per keyword each month using SEOtools for Excel and the DataForSEO API.

  • Formulas to automatically calculate a Brand SERP Domination Score (customizable to your needs).

  • A summary dashboard visualizing Brand SERP Domination based on up to 5 keywords.


    Kontaktdaten


    Our SEO news

    Learn more about Claneo

    Search engine optimization

    We support you holistically in aligning your SEO strategy. Together with you, we develop tailored concepts for long-term success and support you in all relevant areas of SEO. We advise you on all current and future topics related to organic search.

    Content Marketing

    In close collaboration with you, we design holistic content marketing campaigns and develop sophisticated seeding strategies for maximum impact. We focus on promoting informative content rather than simply advertising services or products.


    You found us - now let us help you to be found!

    Get in touch with us. We will get back to you as soon as possible.


    Squares and photo of smiling employee
     Squares and photo of smiling employee