SEO is tough.
It is time consuming and difficult to implement.
This is why I have a free SEO training course and even an SEO tool to help you.
But what if you don't have the time to complete a 21-part training series? Or what if my SEO tool doesn't give you the step-by-step guide you need?
What other options do you have?
Well, today I thought I would make your life easier by sharing 21 of my own worksheets and templates for SEO and content marketing so you can get higher placements in less time and, above all, with less effort.
Let's start with the basics.
In marketing, we use all terms that can be a little confusing.
Sure, you probably know what SEO is and what it means, but what about terms like CPC?
Or more complicated ones like CAC, BANT, LTV or even NPS.
I've created a marketing acronym glossary that explains what each marketing acronym stands for and what it means.
So when you read a marketing blog or book, you now know what these “unusual” acronyms and words mean.
If you want to rank local terms, it's not just keyword optimization. Local search engine optimization has a lot more to offer and a lot has to do with your landing page.
Here's a template that breaks down the anatomy of an optimized local landing page.
The cool thing about this template is that it breaks down the percentage impact of each element on your SEO.
The easiest way to find keywords is to use tools like Ubersuggest.
Just enter a keyword …
You see a report that looks like this …
Then click on "Keyword ideas" in the navigation on the left.
But if you go through the list of thousands of thousands of keywords, how do you know which ones are valuable?
Sure, in general, a keyword with a high "volume" means that it is searched frequently, which is good. And if it has a high “CPC,” it means that advertisers are willing to spend a lot of money advertising this keyword. Again, this is good because the keyword usually generates qualified traffic that leads to purchases.
And if a keyword has a low SD (SEO difficulty), this is also great because the keyword is easier to evaluate.
Ideally, when you are looking for keywords, you want those that meet all three of these requirements.
Just because a keyword doesn't meet all three requirements doesn't mean it isn't good for you and your strategy.
There are actually many hidden gems that don't meet all of these requirements, as marketers don't know they're lucrative.
To help you find the best, I created a 220 profitable keyword cheat sheet. Keywords are broken down that have buyer intentions for all industries.
Now I want you to return to Ubersuggest to do a keyword search and search for keywords that contain some of the terms in my profitable keyword cheat sheet. These are keywords that you want to target.
Seriously, you only spend 5 to 10 minutes searching for keywords. If you do at least 10 searches, you will find gold.
As you do keyword research, you will find that it may be difficult to remember and keep track of all the amazing keywords. This leads me to the Ubersuggest Keyword Planner table.
You can use it to keep track of the keywords you want to focus on first, second, third.
Trust me, it will make your life easier.
The Google algorithm contains over 200 factors.
But let's face it, you won't optimize for each of them because it takes too long.
And even if you have time, where do you start and which one do you fix first?
A simple solution is to enter your URL here.
You will receive a report that looks like this …
If you click on one of the error fields, the order to be corrected is broken down.
You can then click through and get details about each SEO mistake.
And although I strongly recommend you fix your mistakes in the report above (this is a great way to improve your rankings), you don't want to just keep playing defense.
You want to start getting your marketing offended and make sure you're doing things right when you post new pages or make changes to your website.
So I created a SEO Fact Sheet cheat sheet that lists important factors to think about when creating new pages on your website.
It's great to share with your teammates and content authors (and even your developers!) So you can make sure everyone is on the same page.
And don't worry, not all 200 factors are broken down as this would be too overwhelming. It focuses on the important factors you need from day one.
However, if your team wants something more detailed, I also created a thorough 20 page SEO checklist.
Every time my team makes major changes, such as redesigning or changing our site structure, I make sure that this checklist is reviewed to ensure that we at least maintain, if not increase, our rankings.
Upload your content
Content marketing is an important ingredient for more search traffic.
But there is so much content on the web these days. How do you ensure that your content stands out and ranks?
Think of it this way, there are over a billion blogs on the web.
Let that sink.
This is such a large number that approximately 1 blog appears per 7 people.
Do you think we really need more blogs?
Not really … we only need good ones.
One way to improve your content is to use data and research that can be built into your content to create more backlinks.
For example, take a look at this post I made about the future of content marketing. It contains tons of charts and data.
People were so excited that 414 backlinks were generated from 110 referring domains.
PS: If you're wondering how many backlinks you have or part of your content, just enter your URL here.
And best of all, I did everything without sending a contact email.
But of course you probably don't have the time, resources, or team to do the custom research we do.
How do you create content that contains data, amazing insights and research that people love? Well, I created a data source document that makes it easy to find all of the information I just mentioned.
Websites that contain unique data, charts, and research results that you can cite in your content are broken down, so you can of course create more backlinks like me.
And if you really want to upload your content and make sure that it not only increases traffic but above all sales, here are some more templates and worksheets that I have created for you:
- Whips – The WHIPS template divides the cycles that users go through before buying. For example, someone might be a window shopper to buy something from, but maybe not from you. Or they know they have a problem and are just looking for the right solution. Regardless of the situation your potential customers are in, the WHIPS template is broken down for each customer, so you can create the content that suits your needs.
- 20/20 rule book – whether you write your own content or whether you have authors, let them follow the 20/20 rules. It breaks down the 20 rules that your content must follow if you want it to work well. In many cases, you won't follow them all, but your goal is to get as close to 20 as possible.
- Template for creating content – If you want my framework to write blockbuster blog posts, follow the content creation template. It's a 20-page process, but if you use it a couple of times, you'll quickly get the hang of it and find it easy to remember. And I've found that if you use it to write 6 blog posts, people don't even have to look at them by the 7th because they know the steps by heart.
I know my content has grammatical and spelling errors from time to time, but my content is good.
One of the reasons is that I follow the templates and worksheets mentioned above.
But it's because I put a lot of emphasis on editing.
Once you've written content, leave it there for a day. You have time to think about how it can be done better.
And the next day you want to edit it.
Don't worry, it doesn't take a long time to process. I have divided our processing hacks into three worksheets:
- 10 commandments – This worksheet lists the 10 things to look for when editing. If you don't have much time, start with this worksheet, as you can usually get your editing done in less than 30 minutes by following the steps.
- Edit checklist – and if you have someone on your team dedicated to editing, let them fill out this checklist every time they edit content.
- Step-by-step instructions for editing – For those of you who really want to master the machining, here is a 27-page guide that breaks down every step of the machining process. I'm honest with you, it's a little over the top, but it's great if you have someone who is just devoted to editing.
The editing process may be a little overwhelming. If so, stick to the checklist or the 10 commandments.
You can also use this editorial calendar to help you. It is an Excel file, but you can download it for free with Google Sheets.
Fine-tune your content
Anyone who says editing is the last step in content marketing is lying.
Going a step further by fine-tuning small things and making small changes can help your content go viral.
Look, no matter how good a marketer is, you will make mistakes. Even if you make very few, there is always room for improvement.
If you've already posted hundreds (if not thousands of blog posts), don't worry. You can still optimize them.
So let's tweak your content to get that extra traffic.
Every little bit adds up, right?
Here's how I increased my SEO traffic to over 4 million visits a month:
- Heading formula – As David Ogilvy once said, spend 80 cents on the dollar in the heading. And it's true, 8 out of 10 people only read your headline, but only 2 people click through and read the rest of your copy. So follow this swipe file for heading formulas to create amazing headings.
- Constructive criticism – If you have the attitude that you can always improve, you can beat your competition. The moment you think you know everything is the moment you lose. This worksheet shows you how to criticize your own content without being biased. I love criticizing my competitions' articles because it helps me better understand how to beat them.
- WordPress SEO cheat sheet – You are probably using WordPress like me. And if so, optimize your blog with this cheat sheet. It's an Excel file, but you can open it with Google Sheets.
Don't forget to create links
Link building is shit. However, if you don't create links, you won't rank well.
I wish there was another way … but there is none. 🙁
When you create links, you may be wondering if I am building the right or wrong links?
Are my existing links good? Do I have to reject one of them?
For this reason, I have created a link building scorecard. You can use Google Sheets to view it.
It helps you keep track of your links, which are good or bad, and what you need to fix so you can reduce the risk of a Google penalty.
Once you've downloaded the link building scorecard, you'll also want to download these two worksheets:
- Search operators for link building – In this worksheet you will learn how to use advanced search parameters in Google to find new ways of building links. It is simple and yet very effective.
- Outreach templates – Once you've found link options, you'll need to send contact emails to persuade websites to link to you. Here is my outreach template. It contains 24 pages of contact emails that you can use to create additional links.
I know I've given you lots of templates, worksheets, and cheat sheets, but you don't have to use all of them.
Use the ones you need and save the rest for later. This will make your life easier and help you get results faster and in less time.
And if you're wondering how much time you should spend on each task, here is the SEO Taskmaster worksheet.
It includes a breakdown of all SEO tasks you need to perform, how long each task takes, how important it is, and how you can prioritize it because you can't do it all in one day.
What do you think of all these templates? Are you going to use them And what worked for you that I didn't talk about here?