This site uses cookies and other tracking technologies to make possible your usage of the website, assist with navigation and your ability to provide feedback, analyse your use of our products and services, assist with our promotional and marketing efforts, and provide better user experience.

By using the website, you agree to our Privacy policy

Accept and continue

Report a bug

Cancel
1999
SEO 7 min read April 12, 2019

How To Hack Your Competitors' Content Plan: Step-By-Step Guide

New script from Serpstat which collects data from API
How To Hack Your Competitors' Content Plan: Step-By-Step Guide

Andrey Belousov
Growth Hacking Specialist at Serpstat
The competitor analysis can be really exhausting, especially when it comes to creating the content plan. Read this guide to know how you can accomplish this tedious task faster and benefit from the experience of your competitors.
You're definitely familiar with a cliché scene in action movies when the protagonist sits in front of his computer and types incomprehensible signs and codes on the screen. Everyone knows what that means: he has to fulfill a mission-impossible, on which the life of at least one city depends. What if I tell you about a secret tool that will allow you to put yourself in this situation and become a hacker?
If you're an active Serpstat user, you know how extensive the API capabilities of our tool are. Anyway, today I'm talking about a new script that takes your SEO and content marketing tasks to a new level. This free utility lets you simultaneously analyze multiple competitors for a set of parameters and discover new opportunities for your website or blog.
Please note that the script is in alpha-version. We're still working on it, so I can't yet guarantee the 100% result.

What are the advantages of the script?

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)
Why do you need this data? Using this analysis, you can create content that attracts traffic and is the most profitable. Also, these topics are completely new to your website.

How to create a content plan using batch analysis of your competitors?

Determine your competitors

If you know your competitors, you can skip this step. But to increase your chances, I recommend you to check your assumptions. To do this:
1
Open the Serpstat main page and enter your website or important keywords.
2
Go to the Competitors section.
3
Voilà! All your competitors are obvious.
4
Check and complete your previous list of competitors.

Set the growth hacking script

To run competitor batch analysis, you should make some settings to the script:
1
Open the script page and enter your personal token (you can find it in your Serpstat profile.)
      2
      Select the appropriate region. For example, click on + United States.
      3
      Select the method Domain Keywords Match SDK.
      4
      Add the list of competitors.
      5
      Enter your domain to exclude results from your website.
      6
      Determine the maximum number of lines (Max Rows) and search volume of the keywords (Frequency). Depending on the results, you can vary these parameters. Be prepared that the more domains you examine at the same time, the slower the report loads.
      7
      If necessary, you can add negative keywords or vice versa.
      8
      Click on the button Load data.

      Find topics that generate the most traffic

      After the report loads, you can continue editing your data and preparing for analysis.
      If you analyze big domains, you should set more lines for the analysis (Max Rows)
      Open the SQL tab in the report, group by URLs, and click Evaluate SQL.
      Download the table in the desired format:
      You can take a closer look at the competitor data and analyze it. The most important is the first column, which shows which URLs of your competitors are the most popular. Study these pages carefully, and you can find and fill in the weak spots on your website.

      • TOP keyword: a search query that generates the most traffic for the corresponding page. This search term indicates the main topic of the article.
      • Keywords and ALL_Keywords: Keywords for which the page appeared in the search results.
      • Traffic: The potential traffic that the page gets. This added value depends on the number and search volume of the keywords for which a particular page ranks.
      • Cost: shows how high the costs for the contextual advertising are; it is calculated according to the formula: PPC * Traffic.
      You can choose pages that promise maximum results with minimal effort. Since our task is to find the topics for the articles that attract the most visitors, note the Traffic column. Filter the results by the required columns and find topics that are relevant to your website.

      Why should you pay attention to your goals?

      Before you create the content on the topics found, think carefully about whether they match your goals and fit your target audience. Ask yourself the following questions:
      1
      Will this article be interesting and helpful for my readers?
      2
      Does it fit the positioning of my company (blog, product, etc?)
      3
      Is the mention of the services or products in this article appropriate?
      If the answers are yes, use suggested topics. Do you still have questions about the script? Write a comment, please!

      Learn how to get the most out of Serpstat

      Want to get a personal demo, trial period or bunch of successful use cases?

      Send a request and our expert will contact you ;)

      Rate the article on a five-point scale

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

      Recommended posts

      Subscribe to our newsletter
      Keep up to date with our latest news, events and blog posts!

      Поделитесь статьей с вашими друзьями

      Sign In Free Sign Up

      You’ve reached your query limit.

      Or email
      Forgot password?
      Or email
      Back To Login

      Don’t worry! Just fill in your email and we’ll send over your password.

      Are you sure?

      Awesome!

      To complete your registration you need to enter your phone number

      Back

      We sent confirmation code to your phone number

      Your phone Resend code Queries left

      Something went wrong.

      Contact our support team
      Or confirm the registration using the Telegram bot Follow this link
      Please pick the project to work on

      Personal demonstration

      Serpstat is all about saving time, and we want to save yours! One of our specialists will contact you and discuss options going forward.

      These may include a personal demonstration, a trial period, comprehensive training articles & webinar recordings, and custom advice from a Serpstat specialist. It is our goal to make you feel comfortable while using Serpstat.

      Name
      Email
      Phone
      We are glad of your comment

      Upgrade your plan

      Upgrade your plan

      Export is not available for your account. Please upgrade to Plan A or higher to get access to the tool. Learn more

      Sign Up Free

      Спасибо, мы с вами свяжемся в ближайшее время

      Invite
      View Editing

      E-mail
      Message
      Optional
      E-mail
      Message
      Optional

      You have run out of limits

      You have reached the limit for the number of created projects. You cannot create new projects unless you increase the limits or delete existing projects.

      I want more limits

      Christmas is a time for miracles.

      You are almost on the finish line of our Christmas quest. The last brick of your lego-promocode is left on the way up 55% discount.

      Did not find previous lego-bricks? Fill the form anyway.

      Name
      Email
      Phone