Categories
SEO Software

Get insights for 2023 with this SEO prediction template


Even during boom times, marketing budgets are divided among different teams, channels, and initiatives.

As we move into 2023, a volatile economy is likely to constrain many budgets and headcounts well below optimal levels, making it imperative for marketers that their specialties get their fair share of resources. It is especially important to articulate a compelling case for why there is.

In other words, how do we predict X resources achieve world Growth becomes important.

Because of this, I often get questions from clients (and potential customers) like:

  • “How much traffic do you get from SEO and how long does it take?”
  • “What can SEO do for revenue?”
  • “What kind of lift can you see from this work?”

The beauty of SEO, and its unique challenge, is the marriage of art and science. Unlike paid performance channels, which have CPC and CPM benchmarks that show how many clicks and impressions you can get for a given spend, SEO has no clear and quantifiable causal pathway.

That being said, you can SEO predictions provide directional answers to these questions and set traffic projections for the next year (or a specified time frame). This article describes my approach.

I’ve created a prediction template that I’m happy to share here.

Before you start, please note the following:

  • It’s read-only, so you’ll need to download a copy. Ranges are not recommendations. you have to enter it yourself.
  • of randbetween() The numbers are not static because the formulas are recalculated every time the document changes. We recommend saving these estimates to a separate sheet/location for posterity and comparison.

Let’s take a closer look at how the tool works.

Growth data benchmark

Rows 3 through 14 of this SEO forecast document show a year’s worth of monthly traffic history. In order to predict his year ahead, we need to be able to reference at least one year of his historical data for benchmarking.

However, it is important to note that reliable predictions rely on using mature data as benchmarks. For example, estimating the growth rate of a website’s traffic over the first 12 months yields highly skewed projections.

Choose a time period that fits your brand’s traffic history. Make sure you account for factors that artificially spiked or slowed down searches in a given month.

  • One-off advertising campaign.
  • Site migration.
  • Prolonged site outages.
  • etc.

Once you’ve selected your benchmark data, take those numbers and calculate the average month-over-month growth (append to cell L5). This smoothes out factors such as seasonality.


Get the daily newsletter search marketers rely on.


Projected baseline growth (without resources)

The predictions start on the next 12 rows after the historical benchmark data.

From line 15, row B takes the benchmark traffic and simply applies next year’s average growth rate (in L5 units) to get a forecast baseline.

D row Get the data for the previous year, “Forecast” formula in Google Sheetscan be obtained by typing =round(forecast(A15,C$3:C14,A$3:A14),0) Enter in column D, row 15 and drag the formula to all applicable cells.

This formula does not give constant month-over-month growth. As Google describes the formula, “calculates the expected y value for a given x based on a linear regression on a dataset”.

The values ​​in columns B and D are the growth prediction models If you didn’t apply any SEO resources And let the growth momentum continue naturally.

Forecast Growth by Resources

we get really good Column EIt takes the historical known SEO data (rows 3-14) and applies a range of expected growth rates to whatever SEO resource you might have at hand.

It’s up to you to set the two ranges described below (these are included as examples only, not as recommendations in the forecast document).

To calculate the expected growth range:

  • Start by analyzing the keywords you want to rank for over the next year.
  • Look at monthly search volume.
  • Then apply a basic CTR to get the total traffic if you were ranked on Page 1 for about 9 months on those terms (it can take months to achieve a higher ranking). is assumed).

Create two ranges. One is a conservative range for the first 3 months (so that we can build momentum for new hot keywords) and a more aggressive range for the next 9 months.

After setting the conservative range, add the bottom edge to L6 of the sheet and the top edge to M6.paste the formula =round(D3*((RANDBETWEEN($L$6,$M$6)/100)+1),0) Go to column E, row 15 and drag the first three months down to get the forecast for that cell.

Once you have an aggressive range, add low end to the seat L7 and add high end to the M7.paste the formula =round(E6*((RANDBETWEEN($L$7,$M$7)/100)+1),0) Go to column E, row 18 and drag down the next 9 months to get the forecast for that cell.

You now have a forecast of traffic without SEO resources (Column D) and traffic with SEO resources (Column E).

Note: It is recommended to use column D instead of column B for comparison purposes. This is because you’ll likely be reporting to your team by month rather than year, so you’ll want to see a more accurate monthly forecast. Subtracting the number in column D from the number in column E will give you an estimate of his SEO growth that you can share with your stakeholders.

Gain directional insights with SEO predictions

Due to the nature of SEO, this is not an exact science. This data is directional as frequent algorithm and his SERP updates can cause traffic to change in some direction.

It also doesn’t take into account external factors such as planned site reboots or cuts in top-of-funnel ad spend that can impede organic growth of branded keywords.

That said, it’s a reference point for what matters for teams considering whether to invest in SEO in the coming months.

All good SEO professionals know how to paint a picture of data ambiguity, so use those storytelling skills and Excel formulas to support your goals.


The opinions expressed in this article are those of the guest author and not necessarily Search Engine Land. Staff authors are listed here.


What’s New in Search Engine Land

About the author

Adam Tangay

Adam Tanguay is Head of SEO and Content. jordan digital marketing, he joined in February 2019. Former Head of Marketing at Webflow and Head of Organic Growth at Weebly, Adam has developed a successful growth program by combining content strategy, copywriting, technical know-how, and analytical acumen across different disciplines. . organic channel.



Standing Desk Reviews

Leave a Reply

Your email address will not be published. Required fields are marked *