 Welcome to this week's edition of Whiteboard Friday. I'm Tom, Director of Organic Performance at Crowd. Today we're going to talk about SEO forecasting and more specifically how you can do it with digital budgets being more scrutinised than ever. There's a lot more pressure to demonstrate the value of your SEO activity back to your business or your client organisations. So, today we're going to spend some time talking about the process that I go through in order to do that forecasting and demonstrate that value. Now, I will say it's not an exact science. We're effectively trying to predict the future, which is quite difficult, but there are processes that you can go through in order to begin to quantify that predicted SEO value. So, before we kick off, there's a few things that you'll need in terms of data in order to build your forecast. Firstly, 12 months traffic data. So, this is effectively, you know, you can use your analytics platform or you can use Google search console to pull down 12 months worth of organic data by month. Secondly, and most of the time, if you're working within a business or you're working with clients, you will be set a target of what that predicted future SEO performance needs to be. So, that's incredibly important to bring into your forecast as well. Thirdly, the key words that you'll target across the course of your campaign, that's really important to help try and demonstrate the incrementality that you're going to be building for your business or your clients. And then finally, the click-through rate model and somewhat linked to point number three here, click-through rate model allows you to start to reverse engineer by each keyword how much traffic they are driving and by improving those keyword positions how much additional traffic you're going to be driving through to your website. So, those are four things that you'll need before you set out on this journey. What we'll end up with when you've gone through this process is a graph like this. So, effectively, very clear demonstration of what we've achieved over the last 12 month periods from that traffic data that you've got up here and then some different scenarios. So, firstly, your baseline, this is effectively what we think performance will be if we don't do any value-added SEO activity. Then we've got our forecast in the green here. So, using all of that keyword data that you have, what we think the incremental value will be from your SEO activity, improving the positions for those keywords. The black dot is the target that you need to work towards. So, very quickly what you can start to see is where you've got that gap from the keywords that you're targeting against that initial target that you've been set by your business or your client organisation. And that will start to tell you actually there's probably more keywords, more expansion that we need to do within our SEO strategy to close that gap. And then finally, as that year progresses and you progress through your SEO campaign, what the traffic is that you're actually generating and how that tracks against the forecast that you've built. So, this ultimately is what we'll end up with which you can show to your superiors, client organisations to demonstrate the value of your SEO activity. Now, breaking that out into a little bit more detail in order to get this baseline. There's a couple of different methods that you can use in order to get that data. The first is what I call the basic method. So, taking the last 12 months of your organic data that you've got and then you can use Google Trends and you can look at Google Trends to see the brand growth that has been delivered over the last 12 months and you can use that to quantify what we think naturally will happen based on the strength of the brand as measured by Google Trends. So, that's one way that you can build a basic baseline to build a model whereby you've got no SEO activity happening over the next 12 months. The second option which is what I prefer to use is using a time series model. Now, there's lots of different formulas that you can use in Google Sheets in Excel. I've got one down here, it's called the forecast function and effectively what that does is it looks at the data over the last 12 months and it starts to draw parallels from that data and begin to forecast what you think will happen or what you think will happen over the next 12 month period from all of that historic data that you've fed it. This is a really powerful way to get this accurate as possible baseline from your activity. Now, we move on to incrementality. So, how do we begin to influence this green line here? So, there's two things that we must have in order to do this. The keywords that we're targeting as part of our campaign we need to collect with those keywords, the monthly search volume and also the current ranking position, where are those keywords currently ranking in search. Then we need to use Google Search Console to pull down the non-branded click-through rate and that's important because that will start to help us understand how much traffic we're driving from those keywords and as we begin to improve those keyword positions what the incremental traffic will be, which gives us this green line here. An optional metric that we can put in is keyword difficulty. Now, that's useful because if you can understand how difficult it is to target or drive improvements from each of those keywords you know the rate of change that you need to put forward with regards to your increase factors. How quickly are we going to drive incremental ranking performance for those keywords if it's super, super competitive? It's probably going to take us longer to influence those increases. If there's minimal competition on those keywords we'll be able to drive that incrementality a lot quicker. So, now that we've got this graph here which models clicks in terms of how we're driving positive performance over the next 12 months there are further things that we can do to bring in revenue metrics for example, which makes this a much more attractive proposition for finance teams and those in charge of your budgets. So, if you bring in conversion rate and average order value data you can apply that on top of the incremental clicks to understand how much more revenue you're going to be driving from your business or your client organisation. And then with that data you can also begin to calculate the return on investment. So, effectively looking at the incremental revenue that you're driving divided by the cost of investment so how much money are you putting into your SEO activity in order to achieve those results and that calculation will give you an ROI number which is really, really appealing when you're putting this in front of finance teams and budget holders. So, I hope that's been useful. There is a link down here to a worksheet which we've attached to this Whiteboard Friday. It allows you to put in the raw data up here and then from that you'll get a model much like this. So, I hope that's useful. I hope this Whiteboard Friday has been useful and thanks for watching.