{"id":7018,"date":"2022-11-22T13:47:47","date_gmt":"2022-11-22T13:47:47","guid":{"rendered":"https:\/\/craighordlow.com\/index.php\/2022\/11\/22\/use-this-seo-forecasting-template-to-gain-insights-for-2023\/"},"modified":"2022-11-22T13:47:47","modified_gmt":"2022-11-22T13:47:47","slug":"use-this-seo-forecasting-template-to-gain-insights-for-2023","status":"publish","type":"post","link":"https:\/\/craighordlow.com\/index.php\/2022\/11\/22\/use-this-seo-forecasting-template-to-gain-insights-for-2023\/","title":{"rendered":"Use this SEO forecasting template to gain insights for 2023"},"content":{"rendered":"<p>Even in boom times, marketing budgets are divided among a range of teams, channels, and initiatives. <\/p>\n<p>Going into 2023, with a <a href=\"https:\/\/searchengineland.com\/marketing-recession-common-mistakes-389542\" target=\"_blank\" rel=\"noopener\">shaky economy<\/a> likely to cap many budgets and headcounts far below optimal levels, it will be especially important for marketers to articulate a compelling case for why their area of expertise should get a fair share of resources.<\/p>\n<p>In other words: forecasting how <em>X<\/em> resources will achieve <em>Y<\/em> growth is going to be vital.<\/p>\n<p>Because of this, I frequently get the following questions from clients (and prospective clients):<\/p>\n<p>\u201cHow much traffic will we get from SEO and how long will it take?\u201d\u201cWhat can SEO do for our revenue?\u201d\u201cWhat kind of lift are we going to see from this work?\u201d<\/p>\n<p>The beauty and unique challenge of SEO is its <a href=\"https:\/\/searchengineland.com\/seo-is-math-388151\" target=\"_blank\" rel=\"noopener\">blend of art and science<\/a>. Unlike paid performance channels, where you have CPC and CPM benchmarks that tell you how many clicks and impressions you\u2019ll get for a specific amount of spend, SEO doesn\u2019t have a clear, quantifiable path to cause\/effect.<\/p>\n<p>That said, you <strong>can<\/strong><em> <\/em>do SEO forecasting to give some directional answers to these questions and set traffic expectations for the year (or any specified time frame) ahead. In this article, I\u2019ll explain my approach.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/11\/22\/use-this-seo-forecasting-template-to-gain-insights-for-2023\/#SEO_forecasting_template_for_2023_How_to_use_the_tool\" >SEO forecasting template for 2023: How to use the tool<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/11\/22\/use-this-seo-forecasting-template-to-gain-insights-for-2023\/#Benchmarking_your_growth_data\" >Benchmarking your growth data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/11\/22\/use-this-seo-forecasting-template-to-gain-insights-for-2023\/#Forecasting_baseline_growth_with_no_resources\" >Forecasting baseline growth (with no resources)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/11\/22\/use-this-seo-forecasting-template-to-gain-insights-for-2023\/#Forecasting_growth_with_resources\" >Forecasting growth with resources<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/11\/22\/use-this-seo-forecasting-template-to-gain-insights-for-2023\/#Using_SEO_forecasting_to_gain_directional_insights\" >Using SEO forecasting to gain directional insights<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"SEO_forecasting_template_for_2023_How_to_use_the_tool\"><\/span>SEO forecasting template for 2023: How to use the tool <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>We\u2019ve built a forecasting template that I\u2019m happy to share with you <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1nX_wtvXRA8ULrv_HthMNQLrQDNJbmJ0gSBgKLMhkZ1A\/edit#gid=0\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.\u00a0<\/p>\n<p>Before we get started, note that:<\/p>\n<p>It\u2019s view-only, so you\u2019ll have to download your copy. The ranges are not recommendations; you\u2019ll need to fill in your own. The randbetween() formulas recalculate with every change to the document, so numbers will not be static. We recommend saving these estimates in another sheet\/location for posterity and comparisons.<\/p>\n<p>Let\u2019s break down how the tool works.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Benchmarking_your_growth_data\"><\/span>Benchmarking your growth data<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In this SEO forecasting doc, rows 3-14 give you a year\u2019s worth of monthly traffic history. For the purpose of forecasting a full year to come, you should be able to reference at least a year of historical data for benchmarking. <\/p>\n<p>It\u2019s important to note, though, that reliable forecasting depends on having mature data as a benchmark. Extrapolating growth rates from, say, the first 12 months of a website\u2019s traffic will yield highly skewed projections.<\/p>\n<p>Pick a time period that makes sense for your brand\u2019s traffic history. Make sure you\u2019re accounting for factors that artificially spiked or depressed any particular month\u2019s search:<\/p>\n<p>A one-off ad campaign.A site migration.A prolonged site outage.Etc.<\/p>\n<p>Once you have your benchmarking data selected, take those numbers and calculate an average month-over-month growth rate (and add to cell L5); this smooths out factors like seasonality.\u00a0<\/p>\n<p><!-- START INLINE FORM --><\/p>\n<div class=\"nl-inline-form border py-2 px-1 my-2\">\n<div class=\"row align-items-center\">\n<div class=\"col-12 col-lg-3 col-xl-4 pe-md-0 pb-2 pb-lg-0\">\n<p class=\"inline-form-text text-center mb-0\">Get the daily newsletter search marketers rely on.<\/p>\n<\/div>\n<div class=\"col-12 col-lg-7 col-xl-6  pe-lg-0\">\n<div class=\"form-nl-inline\">\n<div class=\"row g-0\">\n<div class=\"form-group col-12 col-lg-8 mb-0\"><\/div>\n<div class=\"col-12 col-lg-4 col-xl-4 mb-0\">\n<div class=\"d-none\">\n<p>Processing\u2026Please wait.<\/p>\n<\/div>\n<p>\t\t\t\t\t\t\t<button class=\"btn btn-dark inlineButton w-100 rounded-0 font-weight-bold\">SUBSCRIBE<\/button>\n\t\t\t\t\t\t<\/p><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"col-12 col-lg-2 col-xl-2 ps-1\">\n<p class=\"text-center mb-0\"><a class=\"nl-terms\" href=\"https:\/\/searchengineland.com\/termsofuse\" target=\"_blank\" rel=\"noopener noreferrer\">See terms.<\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><!-- END INLINE FORM --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Forecasting_baseline_growth_with_no_resources\"><\/span>Forecasting baseline growth (with no resources)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Your next 12 rows after the historical benchmarking data are where the forecasting begins.\u00a0<\/p>\n<p>Starting with row 15, <strong>Column B<\/strong> takes your benchmarked traffic and simply applies the average growth rate (in L5) over the next year to get a forecasting baseline.<\/p>\n<p><strong>Column D<\/strong> takes the previous year&#8217;s data and applies the <a href=\"https:\/\/support.google.com\/docs\/answer\/3094000?hl=en\" target=\"_blank\" rel=\"noopener noreferrer\">Google Sheets \u201cforecast\u201d formula<\/a>, which you can get by entering <em>=round(forecast(A15,C$3:C14,A$3:A14),0)<\/em> into Column D, Row 15 and dragging the formula down through all applicable cells. <\/p>\n<p>This formula does not produce a flat month-over-month growth rate; as Google describes the formula, it &#8220;calculates the expected y-value for a specified x based on a linear regression of a dataset.&#8221;<\/p>\n<p>The values in columns B and D are forecasting models for your growth<em> <\/em><strong>if you applied no SEO resources at all<\/strong> and simply let your growth momentum continue on its own.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Forecasting_growth_with_resources\"><\/span>Forecasting growth with resources<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>We really get to the good stuff with <strong>Column E<\/strong>, which takes your historical, known SEO data (rows 3-14) and applies a range of expected % of growth given whatever SEO resources you&#8217;re projected to have on hand.\u00a0<\/p>\n<p>It&#8217;s up to you to set the two ranges we&#8217;ll describe below (which are only included as examples and not as recommendations in the forecasting doc). <\/p>\n<p>To calculate the expected growth ranges:<\/p>\n<p>Start by analyzing the keywords you want to rank for over the next year.Look at the monthly search volume.Then apply a basic CTR to get total traffic if you ranked on Page 1 for those terms for approximately nine months (given that it will take a few months to achieve a higher ranking).\u00a0<\/p>\n<p>Create two ranges: one conservative range for the first three months (to allow momentum to build for newly in-focus keywords) and a more aggressive range for the following nine months.\u00a0<\/p>\n<p>Once you have your conservative range, add the low end to L6 in the sheet and the high end to M6. Paste the formula <em>=round(D3*((RANDBETWEEN($L$6,$M$6)\/100)+1),0)<\/em> into Column E, Row 15, and drag down for the first three months to get forecasts for applicable cells.\u00a0<\/p>\n<p>Once you have your aggressive range, add the low end to L7 in the sheet and the high end to M7. Paste the formula <em>=round(E6*((RANDBETWEEN($L$7,$M$7)\/100)+1),0) <\/em>into Column E, Row 18, and drag down for the next nine months to get forecasts for applicable cells.\u00a0<\/p>\n<p>Now you have your forecasts for traffic without SEO resources (Column D) and traffic with SEO resources (Column E). <\/p>\n<p><strong>Note:<\/strong> I recommend using Column D, not Column B, for comparison purposes because you&#8217;ll likely report to your team by month, not by year, and should therefore reference the more accurate monthly forecasts. Subtract the number from Column D from the number in Column E, and you&#8217;ll have estimates for SEO growth that you can share with your stakeholders.\u00a0<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Using_SEO_forecasting_to_gain_directional_insights\"><\/span>Using SEO forecasting to gain directional insights<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This is not an exact science because of the nature of SEO. With frequent algorithm and SERP updates that can swing your traffic one way or another, this data will be directional. <\/p>\n<p>It also won&#8217;t account for external factors like a planned site relaunch, cuts in top-of-funnel ad spend that may stunt organic growth for brand keywords, etc.\u00a0<\/p>\n<p>That said, it is a reference point for what&#8217;s at stake for teams weighing whether to <a href=\"https:\/\/searchengineland.com\/seo-investment-not-cost-384995\" target=\"_blank\" rel=\"noopener\">invest in SEO<\/a> in the coming months. <\/p>\n<p>All good SEO professionals know how to paint a picture with some data ambiguity, so use those storytelling skills and some <a href=\"https:\/\/searchengineland.com\/excel-pivot-table-best-practices-for-search-marketers-389254\" target=\"_blank\" rel=\"noopener\">Excel formulas<\/a> to support your cause.<\/p>\n<p>The post <a href=\"https:\/\/searchengineland.com\/seo-forecasting-template-389686\" target=\"_blank\" rel=\"noopener\">Use this SEO forecasting template to gain insights for 2023<\/a> appeared first on <a href=\"https:\/\/searchengineland.com\/\" target=\"_blank\" rel=\"noopener\">Search Engine Land<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"<p>Even in boom times, marketing budgets are divided among a range of teams, channels, and initiatives. Going into 2023, with a shaky economy likely to cap many budgets and headcounts far below optimal levels, it will be especially important for marketers to articulate a compelling case for why their area of expertise should get a fair share of resources. In other words: forecasting how X resources will achieve Y growth is going to be vital. Because of this, I frequently get the following questions from clients [&hellip;]<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"h5ap_radio_sources":[],"cybocfi_hide_featured_image":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-7018","post","type-post","status-publish","format-standard","hentry","category-best-seo-blogs"],"featured_image_src":null,"featured_image_src_square":null,"author_info":{"display_name":false,"author_link":"https:\/\/craighordlow.com\/author\/"},"_links":{"self":[{"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/posts\/7018","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/comments?post=7018"}],"version-history":[{"count":0,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/posts\/7018\/revisions"}],"wp:attachment":[{"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/media?parent=7018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/categories?post=7018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/tags?post=7018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}