Saturday, November 23, 2024

I’ve Spent 20 Years...

Opinions expressed by Entrepreneur contributors are their own....

Why Donald Trump’s Business-First...

Opinions expressed by Entrepreneur contributors are their own....

This Sommelier’s ‘Laughable’ Idea...

Opinions expressed by Entrepreneur contributors are their own....

How to Start a...

Podcasting is...
HomeDigital MarketingHow to Create...

How to Create an SEO Forecast [Free Template Included] — Whiteboard Friday


So before we kick off, there are 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 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 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 keywords 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. Then, finally, the click-through rate model that’s 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, a very clear demonstration of what we’ve achieved over the last 12-month period 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 organization, and that will start to tell you, actually, there are probably more keywords, more expansion that we need to do within our SEO strategy to close that gap.

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, your client organizations to demonstrate the value of your SEO activity.

Continue reading

Trump names Rollins agriculture secretary for final Cabinet pick

President-elect Donald Trump said Saturday that he will nominate former White House aide Brooke Rollins to be his agriculture secretary, the last of his picks to lead executive agencies and another choice from within his established circle of...

Best Times to Post on YouTube in 2025 [Research]

Despite the rise in popularity of short-form video, I was surprised to discover that YouTube sees the highest usage among social media platforms by video marketers, surpassing TikTok and Instagram. According to HubSpot Blog research, YouTube was the most...

10 Stores Where Coupon Stacking Yields Huge Savings

Many consumers have the best intentions when it comes to using coupons, but only a tiny percentage actually use them. Maybe you don’t need the savings, you don’t have the time, or you...