Start Exploring Keyword Ideas

Use Serpstat to find the best keywords for your website

Content Marketing April 25, 2019  |  21553   42   2   |  14 min read  – Read later

How To Create A Content Plan + Video Guide

5 Ways To Create A Content Plan
How To Create A Content Plan + Video Guide 16261788181816
Stacy Mine
Editor at Serpstat
The first rule of the content plan is that there isn't the only correct way to gather topics for the content plan. Some experts create it from a list of technical support questions, others advertise for special posts and select questions in comments, others directly ask newsletter subscribers about what they'd like to see in new articles.

In this post, I'll show you the most effective ways to create and/or expand your content plan.

Content matrix

Content matrix is a unique and guaranteed way to diversify your content ideas. I'll show you 5 variants to expand the plan inside the matrix. Let's take as an example a shop which sells coffee. When you have a particular topic — coffee — you can vary your topic ideas as you wish.

Generalize

Here you can slightly get away from the topic. Coffee is a drink, and food and drinks are a part of our lives. You can write how coffee influences your health; coffee and the medicine, etc. The list is endless. Here I gathered some ideas:
How To Create A Content Plan + Video Guide 16261788181817

Detail

You can go deeper: types of coffee trees, ways to make coffee, types of coffee drinks, best local coffee bars… Take any coffee-related topic and go into details. Here are some ideas:
How To Create A Content Plan + Video Guide 16261788181817

Look around

What beverages do people drink besides coffee? What drinks have the same invigorating effect? Pick up the related topics and expand them as you like.
How To Create A Content Plan + Video Guide 16261788181818

Time

Time is the next metric — here you can cover all topics related to the history of drinks: how they were/are produced, outlook on the future.
How To Create A Content Plan + Video Guide 16261788181818

Audience

You can turn any topic to a different audience. This works every time, trust me :)
How To Create A Content Plan + Video Guide 16261788181818

Users' feedback

This way is collective as you should use several means to get a full view. You need to:
1
Look through comments in all your social networks: what users ask, what topics cause hype, what users like and don't like
2
Ask the subscribers of your newsletters, bring them to dialogue, find out what they would be interested to read in your blog
3
Collect the most popular questions to your tech support: it will help you write the most relevant articles for your readers
4
Create posts on social networks with the text "we will answer all your questions," and you'll collect a huge number of topics for your articles.
5
Use pop-ups on your website to ask visitors what content they want to see. This is a quick and effective way to gather insights directly from your audience. You can try ready-made use pop-up templates to launch these interactions faster and without coding.

Keyword analysis

Find your competitors

Let's imagine that we have a new site and we still don't know our competitors. But they certainly have a blog to attract organic traffic. How to find out who they are? Enter the keyword from our semantics into the Serpstat search bar and choose the search engine. You'll automatically go to the Keyword Analysis module. Then select the sectionSEO ResearchandCompetitors. Here you can see the list of competitors' domains.

We can take an online store of pot plants as an example.
How To Create A Content Plan + Video Guide 16261788181819
Some of the sites listed here may not be your direct competitors, even though the given keyword is present in their semantic core. YouTube, online magazines and news sites should not be considered. We are interested in more highly specialized resources. The task at this stage is routine. You need to manually select the five to ten most relevant competitors and keep them in the spreadsheet.

Collect keywords of your competitors

Click on the address of the competitor's domain in the report and find yourself in another section - with a list of search queries. We don't need the whole list of keywords; we'll focus only on those phrases that lead to a specific section of the site - blog or news. To do this, use the filter and select theURLIncludes, enter the required URL in the empty field, and clickApply. Get a list of keywords. You can use them to enrich already published blog posts or as topics for your content plan.
How To Create A Content Plan + Video Guide 16261788181819

Collect headings from Search Questions

The Serpstat service has a special section that contains search suggestions in the form of questions ( how users are looking for them). They are perfect for creating headlines for new articles. Choose one of the keywords you received in the previous report, click on it and go to the sectionContent MarketingSearch Questions. This list contains all interrogative search suggestions concerning the keyword you are looking for. These are the queries that pop up under the search bar as you start typing your query. Serpstat arranges search questions in the list depending on the word. These are questions asked by your target audience on Google, and they can be easily used in content marketing.
How To Create A Content Plan + Video Guide 16261788181819
Voila! We get ready-made headings for posts, divided into groups by question words. Repeat the same with other keywords which you received earlier.
How To Create A Content Plan + Video Guide 16261788181820
Lifehack:not to mess with each keyword individually, you can use the batch export of search questions. To do this, select theBatch exportfilter in theSearch Suggestions, put the list of keywords into the empty field. Then tick the boxonly questionsandwithout toponymsand clickExport.

At this stage, you'll already have a bunch of ideas for your content plan.
How To Create A Content Plan + Video Guide 16261788181820

Find competitors' articles with the highest traffic

If you want to get even more visitors from organic search, analyze the competitors' pages that bring them traffic, and borrow their ideas for articles. Let's return to the competitors of our pot plants website. Go toSEO ResearchTop Pages, set the filterURL Prefix(Starts with URL), enter the address of the necessary section of the competitor site, select the region and clickFind.
How To Create A Content Plan + Video Guide 16261788181821
Wait until the results are loaded, and click onPotential Trafficto sort this indicator in the descending order.

Don't forget that Potential traffic is calculated according to the ratio of real and maximum possible traffic (the latter assumes that the page is in the first position for all phrases), therefore this indicator is indicative.

The first places in the ranking took pages with the highest potential traffic. Copy the topics of these articles to our content plan and return to the report. Then click on the URL of the page and go to the section with a list of search queries for which the page is visible in the search.

These key phrases can be used to optimize a future article by clearing the semantics from unnecessary phrases. Do the same with another 5-10 publications of a competitor.

Choose the most popular topics in social networks

The next stage is similar to the previous one - we'll work in the same tabTop Pages. However, this time we'll look at indicatorFB shares. Sort our pages by shares to find the content of competitors which has received the largest number of shares. Be sure to use this technique if you want to get additional traffic from Facebook.
How To Create A Content Plan + Video Guide 16261788181821
Then we follow the link, borrow the topic of the article and return to the report with search queries to match the semantics. In the same way, we process other competitor's popular posts.

API Spreadsheet


I showed how you can do this in Serpstat interface, but you can do it in API spreadsheet. It may sound difficult to you but working with this spreadsheet is very easy. This document is our special development. It was made for you to save your time and efforts and make your routine easy and simple. Check out the article to follow our step-by-step guide!

How to work with the API

1
Copy the file.To begin working with the Serpstat API, make a copy of the file. It is available only in read mode, so make a copy to be able to use it.
How To Create A Content Plan + Video Guide 16261788181822
How To Create A Content Plan + Video Guide 16261788181822
How To Create A Content Plan + Video Guide 16261788181822
How To Create A Content Plan + Video Guide 16261788181823
How To Create A Content Plan + Video Guide 16261788181823
5
Include a list of domains, URLs, and keywords for analysis.On this sheet, you should enter data that will be analyzed in reports. Delete the sample text before inserting the data.

NB!Don't add more than 100 domains, URLs, and keywords at once. This overloads the Google Sheets and can lead to invalid data.
How To Create A Content Plan + Video Guide 16261788181824
6
Choose the API method.In the Serpstat tab choose a method, with which you want to get a report. To save time, you can use several methods at the same time.
NB!You should link it to your Google account and allow access to make the script work correctly.
      7
      Sort results.Reports are delivered in the new spreadsheet. If necessary, you can sort data in the list by all characteristics.
      How To Create A Content Plan + Video Guide 16261788181824
      If you have any more questions, take a look at theAPI guide.

          API Script

          There's also one more way to find content ideas — by using API scipt.
          Mind that this script is our latest development, it is in alpha version, so we'd be very grateful for your feedback and suggestions. This free utility lets you simultaneously analyze multiple competitors for a set of parameters and discover new opportunities for your website or blog. Check this article to know more.
          Among other things, you can now automatically find keywords and topics that bring the most traffic to your competitors and that you don't use on your website. At the end you get the following data:

          • URLs of your competitor' pages that are visited most frequently
          • List of keywords for which this page appears in search results
          • The potential traffic of this site
          • The value of the pages (CPC * Traffic)

          Brainstorm

          One of the most popular methods to collect ideas is brainstorm. Many content experts plan a meeting of the whole department: they gather together and exchange ideas that come to their minds. Many experts use it:
          We hold a content planning meeting at the end of each quarter to plan the next 3 months. Our whole marketing team takes part in the meetings and usually, our customer success team joins as well.
          How To Create A Content Plan + Video Guide 16261788181825
          Judit Pál
          We have a database of topic ideas to cover. We expand these whenever we have a good idea and develop each idea if we can, at the time. This means we've got plenty of ideas to draw from at any given time. For individual content pieces, it depends. The typical OP is for the writer to put together an outline. I'll review and provide suggestions if required.
          How To Create A Content Plan + Video Guide 16261788181825
          Adam Connell
          My team or I build a database of keyword targets, and then we focus on trying to create assets around those targets. My focus is on maximum quality, and I pay little attention to quantity or routinely publishing.
          How To Create A Content Plan + Video Guide 16261788181826
          Nathan Gotch
          The Content Manager is entirely responsible for creating the Content Calendar. This includes researching new keyword opportunities for blog posts as well as other forms of gated content, video content, guest posting, and more.
          How To Create A Content Plan + Video Guide 16261788181826
          Sean Martin

          Publications calendar

          Finally, we make a document with a detailed content plan for the year. Our average frequency of publications is at least one post per week. Topics themselves can be allocated according to weeks, months, etc., — it depends on the marketing strategy you chose. The main thing is trying to alternate between different types of content (reviews, guides, case studies, text + infographics, expert opinions), and also trying to keep approximately the same intervals between publishing posts.

          Video bonus

          Here's a webinar where I tell about creating the content plan and show you how to use API :)

          Speed up your search marketing growth with Serpstat!

          Keyword and backlink opportunities, competitors' online strategy, daily rankings and SEO-related issues.

          A pack of tools for reducing your time on SEO tasks.

          Get free 7-day trial

          Rate the article on a five-point scale

          The article has already been rated by 31 people on average 4.55 out of 5
          Found an error? Select it and press Ctrl + Enter to tell us

          Discover More SEO Tools

          Text Analysis Tool

          Unlock the power of your text data with our advanced Text Analytics Tools

          AI Content Detection

          Ai Content Checker – realize if the text is AI-generated

          AI Text Generator

          Try our AI Content Writer tool and streamline your content creation process

          AI Content Tools

          AI Content Marketing Tools – simplify and optimize the content creation process

          Share this article with your friends

          Are you sure?

          Introducing Serpstat

          Find out about the main features of the service in a convenient way for you!

          Please send a request, and our specialist will offer you education options: a personal demonstration, a trial period, or materials for self-study and increasing expertise — everything for a comfortable start to work with Serpstat.

          Name

          Email

          Phone

          We are glad of your comment
          I agree to Serpstat`s Privacy Policy.

          Thank you, we have saved your new mailing settings.

          Open support chat
          mail pocket flipboard Messenger telegramm