Skip to main content

Benefit from our experts’ know-how

SEO Forecasting Excel Template

Benefit from our experts’ templates
Try our Excel template to estimate potential traffic and revenue for the SEO channel based on a project-specific CTR curve.



SEO forecasting explained

To convince stakeholders, it often helps to forecast how much traffic and revenue defined SEO measures will deliver. While this cannot be predicted with 100% accuracy, translating expected ranking improvements into business metrics helps make better investment decisions. To do this, you first need to define a keyword set, including search volumes, for which landing pages will be built or existing URLs optimized. Second, you need a realistic estimate of which ranking positions a website can reach in the near future.


Combining this data with a suitable CTR curve gives you a forecast of future SEO traffic. Multiplying it by the expected conversion rate and average order value (or alternatively an estimate of a lead’s value) lets you calculate a revenue forecast. There are basically two options for choosing a suitable CTR curve: either you use data from publicly available CTR studies, such as Sistrix, Advanced Web Ranking or Rank Ranger, or you calculate a project-specific CTR curve based on existing rankings. In both cases, it is important that the data reflects the page type, search intent and characteristics of the keyword set you want to forecast as closely as possible.


Our free Excel template provides a helpful foundation for your own SEO forecasting. It lets you calculate a project-specific CTR curve based on Google Search Console data and use it to estimate traffic and revenue. Download our Excel template now and try it yourself! If you would like us to run a comprehensive SEO forecast for your website or have questions about the template, feel free to contact us.

Our SEO forecasting Excel template includes:

  • A template for calculating a project-specific CTR curve based on GSC data.
  • Formulas to automatically calculate a potential increase in traffic and revenue (customizable to your needs).
  • Several forecasting options, including ranking improvements or reaching top positions.

    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