Our Excel templates


Free templates for Microsoft Excel
Microsoft Excel is probably one of the most used tools in our everyday agency work. Over time, we have created a number of templates for our SEO work that make our lives easier or serve for experimenting, and we are happy to share them for free.
To convince stakeholders, it often helps to forecast how much traffic and revenue defined SEO measures will deliver. This Excel template offers an easy way to calculate project-specific CTR curves based on Google Search Console data and use them to estimate traffic and revenue for a matching keyword set.
To evaluate visibility more holistically, we developed a new metric for SEOkomm 2023 that considers not only the ranking of a single domain but also mentions of a brand within the top 20 search results. We created this Excel template to present a first MVP of the resulting Brand SERP Domination Score.











