Are you tired of your competition outranking you? Or even worse, seeing them rank for keywords that you don’t even show up for?
In this post, I will teach you, step by step, how to identify keywords your competition is ranking for and how to create content that will outrank them. This approach is so effective that by leveraging it on Quick Sprout over the last 12 months, I’ve been able to increase my search traffic from 160,773 visitors to 280,428 visitors a month.
That’s 119,655 more visitors a month. Or 74% more search traffic per month.
Before we get started, you need to create a list of all your competitors first. Once you have the list with the corresponding URLs, you can put those URLs into SEMrush.
For the sake of this blog post, let’s assume Quick Sprout is your competitor. You would enter www.quicksprout.com into SEMrush.
In the left sidebar, click on the navigation option “Organic Research,” and then click on the “Positions” option.
Make sure the graph is set to the “All” time period option, and then click the “Export” button. At this point, you’ll be given three options.
Click the CSV option. This lets you get a data dump of all your competitor URLs and the keywords they rank for.
Here is what the CSV should look like if you typed in Quick Sprout’s URL.
Once you have your CSV file, you are ready to start analyzing the data.
Analyzing the data
Open the spreadsheet, and delete all columns except keyword, search volume, and URLs.
Now that you’ve removed the unnecessary columns, you need to highlight all of the URLs in the URL column.
Once you select the URLs, right-click, scroll down to the “sort” option, and then click “ascending.”
You’ll get a “Sort Warning” popup on your screen. Select “Expand the selection,” and click “Sort.”
You’ll notice that the homepage URL and the keywords the homepage is targeting will be at the top. Delete the rows that contain the keywords for the homepage URL.
You are doing it because you want to go for long tail phrases as they will drive more total traffic, and they are easier to rank for. Typically, internal pages rank for more long tail phrases than a homepage, which is why you want to delete the rows that contain the homepage URL.
Now you want to select all of the content under the keyword, search volume, and URL columns.
After you have selected the content, scroll up, and select the “Data” navigational option. Then select “Pivot Table.”
You should see a screenshot that looks like the image below. Make sure the data is in the same fields and same order as in the image below.
Click on the blue arrow, then click “By value”, and then “Greater Than.”
Make sure you enter 3,000 for the amount as you only want to target keywords that have enough search volume. The last thing you want to do is focus your efforts on ranking for keywords that only get searched a few hundred times a month.
Keep in mind that search volume doesn’t mean clicks to your site. For example, if you rank number one on Google for a term that has a search volume of 10,000, you’ll be lucky if you capture 20 to 30% of those visitors.
You should now see a CSV file that looks like this.
Now, you see all of the internal URLs on your competitor’s site, the keywords it is ranking for, and the search volume for each keyword.
The keywords that SEMrush shows you are the only ones for which your competition ranks in the top 20 results on Google. These are the keywords you want to go after.
Create new content
Now that you have a list of keywords your competitors are going after, you should look at their content.
Once you do, create your own content, incorporating similar keywords.The key to this process is to make sure your content is better than your competitor’s. If it isn’t, you won’t generate more social shares, links, or traffic.
If you are having trouble with the content creation process, read the following guides:
A great way to ensure that your high-quality content gets seen is to follow the steps in this blog post I wrote. It will ensure that you are getting the exposure you need so that you can outrank your competitor.
It isn’t very difficult to outrank your competition and generate more search traffic than they do. All you have to do is follow the steps above, using SEMrush and the CSV file you export.
Once you do that, make sure you focus on writing and promoting high quality content. It works so well that by following my own advice, I have been able to increase Quick Sprout’s search traffic by 74%.
How else can you generate more search traffic through content marketing?
Is your business a vortex moving forward at 70,000 km/pr or is it standing still?
CrimmCo Helps Businesses Move Forward.
CrimmCo has 4 brands that can help your business achieve VORTEX status. We are best know for our CrimmCoSocial brand which is our social media marketing and management branch. CrimmCoSocial manages your social network by engaging with your fan base and creating unique and engaging content that keeps your customers and future customers coming back for more. This keeps your brand in the forefront of when they are ready to spend money with you. We do the heavy lifting.
CrimmCoWeb is our website design and re-design branch. Here we can create from scratch a custom designed website built for your marketing needs or we can simply enhance your current website to increase traffic and sales. No project is too big or too small. We pride ourselves in building sites that are created based on the needs of our clients. We listen and dig deep to discover what your needs truly are. Our award winning design team is at your disposal and ready to implement a sales driven website based on our extensive interview with you.
CrimmCoSEO is our “look at me” branch. We feel that even the coolest and most elaborate website built on the planet is completely useless if it is invisible. If you are serious about increasing brand awareness and sales, it is imperative that your site is seen by the masses. We can achieve this with our seasoned SEO team. While some might argue that this strategy is expensive and takes time to see results, this is probably the best and most effective way to increase your visibility. We start with on site optimization using local keywords, and then move on to offsite strategies like link building and local citation building. Our team understands what Google is looking for and we deliver for you.
CrimmCoAdmin is our business services branch. Here we offer admin and business management services. If you are a start up company or a small business who could use help keeping things organized and running efficiently, this is the service for you. While we provide excellent support for almost any type of business, we are especially effective with real estate agents and brokers. We have worked with large brokerage firms and know this ins and outs of the sometimes complicated world of real estate. Hiring our support team to do what we do best allows you the freedom to do what you do best. Rest assured that CrimmCoAdmin has your back.
Our Services are completely customizable and scalable. Contact us at 808.214.0884 or Click Here
Hire CrimmCo to create your 70,000 KM/PH business vortex
Mobile phones are changing the world as we see it. There’s no need for us to tell you. Look right and left and you’ll see everybody in the vicinity glued to their smartphones and tablets. People not only rely on their mobile devices to stay connected to others, but use them for a multitude of tasks which includes online shopping and searching for information online. Information like, where can I find my dream house in the locality?
As of 2015, 60% of global mobile consumers use their mobile device as their primary or exclusive internet source. That means that more than half of the visitors to your site come via a mobile device. Even those interested in big purchases like a house, search for listings and prices online through their portable devices. For those working in real estate, these visitors come looking specifically for information. If your website is not optimized for mobile, you can lose a potential client in a matter of seconds. A mobile-friendly site is able to display text and images within a small screen size in an organized way, without the user needing to pinch, zoom or navigate around helplessly to find what they need. In short, if you want to attract and retain online visitors to your site and converting them into a customer, then it is imperative that your site is both mobile and desktop friendly.
One solution to the problem is to assign a separate URL and coding for a desktop version of the site, and separate one for the mobile version. But a more versatile and efficient approach is the Responsive Web Design; officially recommended by Google. The responsive design seamlessly adapts the website according to the device the user is using. According to the search engine company, it allows for your website to be more easily shared and linked to, as well as, helps the Googlebot efficiently crawl and index the content of your site online.
If a person is searching for house listings on his or her phone, that does not mean he is cooking up plans and fantasies but is rather planning to take action. A survey says that 70% of mobile searches lead to online action within an hour. That is almost three times the percentage done on desktops. The reason being that mobile users are mostly on the go and use their phone with the intent of quick action.
If we haven’t convinced you of adopting a responsive web design, perhaps these statistics will:
• 80% of internet users use a smartphone.
• More than 20% of Google searches are done on phones and tablets.
• 61% of people have a better opinion of brands when they offer a good mobile experience.
• In 2012 over half of all local searches were done on a mobile device. That was three years ago…
• Tablet users spend 50% more than PC users.
If you’re ready to invest in a good quality responsive web design to attract all kinds of internet device users, then we can help you. At Crimmco, we are more than capable to help transform your business presence online using the latest technology and methods, so that you and your business are never left behind.