<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Malika Sharma on Medium]]></title>
        <description><![CDATA[Stories by Malika Sharma on Medium]]></description>
        <link>https://medium.com/@Malika_Sharma?source=rss-931d8cb6a756------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*gQfw3vsUJw182uLN.jpeg</url>
            <title>Stories by Malika Sharma on Medium</title>
            <link>https://medium.com/@Malika_Sharma?source=rss-931d8cb6a756------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 10:57:47 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@Malika_Sharma/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Competitors Backlinks Analysis [5 Steps] To Find Hidden Gems]]></title>
            <link>https://medium.com/@Malika_Sharma/by-6522f7d7d55e?source=rss-931d8cb6a756------2</link>
            <guid isPermaLink="false">https://medium.com/p/6522f7d7d55e</guid>
            <category><![CDATA[startup]]></category>
            <category><![CDATA[seo]]></category>
            <category><![CDATA[link-building]]></category>
            <dc:creator><![CDATA[Malika Sharma]]></dc:creator>
            <pubDate>Wed, 20 Apr 2016 04:03:27 GMT</pubDate>
            <atom:updated>2016-04-26T10:52:43.915Z</atom:updated>
            <content:encoded><![CDATA[<p>Majority of the times, if you have a website, you would like to see your website ranking well in Google. You work on your On Page SEO and Off Page SEO to make the website optimised as much as you can for the first page rankings.</p><p>Maybe you are doing everything right and keeping the search engine bots and users happy. Your content is being easily crawled and the user experience is good too! So far, it’s going good from your end but there is only one problem in this whole process — You haven’t been able to reach the first page of Google. Your traffic hasn’t improved much because not a lot of people are finding it organically on Google.</p><h3>How would you know what it takes to be on first page of Google?</h3><p>One of the first things to do when you are thinking of gaining higher rankings is to analyse your competition that is ranking well. Competitor analysis can provide valuable insight on your competitors SEO efforts and you will most likely get some new ideas to improve your SEO. Of course, they are doing something that you aren’t as they are on page 1 but you are not.</p><p>If you would like better rankings and more traffic from search engines, keep on reading!</p><p>In this post, I am going to talk about method I use with tools you can use for FREE to get backlinks data and use this data to analyse your competition!</p><p><strong><em>Here is the step by step process that I follow to find out where my competitors are getting backlinks from</em></strong></p><p>When I started my career 9 years ago, I was only focusing on ‘gaining’ links and not keeping in mind the quality of the links I was gaining. Everybody was talking about reverse engineering but I had no idea how to do that!</p><p>After all these years, I have developed a method that you can copy to find out what your competitors are doing to gain backlinks. You can copy the exact method and start building links for your clients today!</p><h3>Step 1 — Identify Your Competitors</h3><p>This is the very first step where I prefer selecting only <strong>ONE</strong> keyword at a time. Having one keyword helps you narrow down your analysis and get more specific. Select a keyword that is considered as one of the main keywords for your website.</p><p>Put your keyword in Google and select first 3 (you can chose more if you want) organic listings from page 1. These websites are your competition for your chosen keyword on Google and you would want to be on these spots if you want to gain more organic traffic, needless to say — leads! Note down these websites on a document (word, notepad etc.) on your computer.</p><h3>Step 2 — Gain All The Backlinks You Can</h3><p>For the purpose of this analysis, I am using a real life example so I could explain the process better. Unfortunately, I wouldn’t reveal the company name or its competitor’s name to maintain privacy. However, you will find everything you need to do this competitor analysis.</p><p>The website I have chosen is sitting on position 12 which puts it on page 2 of Google.</p><p>1. <strong>Domain level analysis</strong> — We will use the competitors you chose in Step 1 and perform a domain level backlinks analysis. This means that the backlinks data we will pull is for the whole domain, instead of the page. The reason behind this is that we would like to work on all the backlinks that we can to find opportunities. There could be very good backlinks linking to the root domain, and not to the internal page, that you would like to know.</p><p>2. <strong>Pull Backlinks</strong> — Grab all the backlinks you can for these competitors as well as your own/client’s website using backlink tool. We will use our/clients backlinks data at the end. For now, let’s focus on the competitors backlinks.</p><p><strong>The tools that you would want to use for this purpose are -</strong></p><p>· Open Site Explorer (Ensure you select ‘only external’)</p><p>· SEO Toolbar</p><p>· SEOSpyGlass</p><p>· OpenLinkProfiler</p><p>· Ahrefs</p><p>· MajesticSEO</p><p>Don’t stop yourself at these tools. You can use other tools and utilize their data as well — the more the merrier!</p><p>You would notice that some of the above mentioned are paid tools but for you can always sign up for the free trial, which lets you use the tool so that you could test it and decide if you want to buy the tool at a later stage. I have always used a trial version before making a decision on buying because trial version is as good a paid version and you can really see if it’s worth buying or not.</p><h3>Step 3 — Create A Master Backlinks Sheet</h3><p>1. Now is the time to start using excel sheets to convert data into useful data! <a href="http://www.malikasharma.co.nz/free-competitor-analysis-guide"><strong>Download the excel sheet with the same format and formulas that I use all the time here.</strong></a> The excel sheet has all the instructions mentioned so you can store the sheet on your computer and use the instructions from within the excel sheet.</p><p>2. After downloading the excel sheet, put all the competitor backlinks that you have extracted from the tools in column ‘All Backlinks’ of this excel sheet. Only pull the backlinks and leave out any other information. Here is what it looks like for me at this step -</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/309/1*9By8kgbvrjMsfpEFMLC5nQ.png" /></figure><h3>Step 4 — Letting Excel Give You All That You Need</h3><ol><li><strong>Getting rid of http:// and www.</strong> — Select the whole ‘<strong>All Backlinks’ </strong>column</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/294/1*tOQStHqFNw3OdnhdvB5gXg.png" /></figure><p>Now click on <strong>Find &amp; Select </strong>and then <strong>Replace</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/278/1*N13o0ZFIA5IB_1Xje0Xu6Q.png" /></figure><p>Type <strong>http:// </strong>and hit <strong>Replace All</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/352/1*g1J_Gmx0w89DPLFoiArn4g.png" /></figure><p>After this step, you will notice that the URLs are now without <a href="http://./"><strong>http://</strong>.</a> Repeat the process to get rid of <strong>www. </strong>as well.</p><p><strong>The final output of this step should leave you with URLs looking like this -</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/214/1*3jq76OqQxzVlXlM0W5OkjA.png" /></figure><p><strong>2.</strong> <strong>Pull domains — </strong>Create a column called <strong>‘Clean Domains’ </strong>where you will get just the domain name after applying this formula <strong>=LEFT(A2,SEARCH(“/”,A2))</strong></p><p>Select the B2 column and apply the aforementioned formula on it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/437/1*6LjjNTuJ9m4zUt19oN1xIw.png" /></figure><p>Once you have copy pasted the formula in B2, hit enter. This is how it should look now –</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/469/1*ZaksGsuqyRJ-msXVzfFY9A.png" /></figure><p>Click and drag from the bottom right end -</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/461/1*rbML-tfPKYt5kwR_PAZw6Q.png" /></figure><p>After successfully doing this, you will have a column of just domain names from where the backlinks are coming. My sheet looks like this –</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/420/1*TGQ69Gf6qkUcYuuRYmIknw.png" /></figure><p>Apply filter on your columns and use ‘<strong>sort A to Z’</strong> on your ‘<strong>Clean Domains’</strong>.</p><p>Note: If you haven’t downloaded the excel sheet, here is the link again — <a href="http://www.malikasharma.co.nz/free-competitor-analysis-guide"><strong>Download the excel sheet with the same format and formulas that I use all the time here</strong></a></p><p>3. <strong>Removing duplicates — </strong>When looking at backlink profiles and working with backlinks data, you will notice that one website can send a lot of backlinks to another site. We don’t need each URL from the website that points out link to another website, which is why we will further filter the data.</p><p>Create another column called<strong> ‘Dup/Unique’. </strong>Use the formula<strong> =IF(B3=B2,”dup”,”unique”) </strong>that will give us values as<strong> ‘dup’ </strong>(denoting duplicate domain) and<strong> ‘unique’ </strong>(denoting unique domain).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/662/1*eS9PJwfIzmnkvNqq7-LmRg.png" /></figure><p>4. <strong>Filter out duplicates — </strong>From the filter on<strong> Dup/Unique </strong>select only<strong> ‘‘unique’ </strong>value to get the domains that are unique.</p><p>You now have all the unique domains from where your competitors are getting backlinks! This is a good data as you can use this for reverse engineering and try getting backlinks from these sources.</p><p>To make the whole process even easier, you should compare these unique domains with your (client’s) domain name. Remember in the beginning, we pulled data for our website (client’s) website? Well for me, I selected a random website on position 12th that I selected for the purposes of this post. :)</p><h3>Step 5 — Finding Gems By Removing The Dust</h3><p><strong>1.</strong> <strong>Finding uniques within your client’s backlinks profile</strong></p><p>We will repeat the above process but only with your clients) backlink profile (in my case, the website on 12th position I chose.</p><p>Create a new excel sheet (create a copy of the one that you downloaded) and get the All Backlinks column with the list of all your clients backlinks. Then create the second column, Clean Domains where you will pull domains from the column All Backlinks. Now create the column Dup/Unique to find duplicate and unique domains. Uncheck dup and you will be left with only unique domains from your client’s backlink profile now.</p><p><strong>2.</strong> <strong>Finding domain names from where your competitors have gained backlinks but you haven’t, TILL YET!</strong></p><p>Create a new excel sheet (copy the one you downloaded) and ignore the first<strong> column All Backlinks. </strong>Put unique domains from your competitors’ backlinks analysis and your client’s backlinks analysis in<strong> Clean Domains. </strong>Now, apply filter and <strong>Sort A to Z </strong>the column<strong> Clean Domains. </strong>In <strong>Dup/Unique</strong>, if the formula is already applied it should give the unique domains. If the formula is not applied then apply the formula you applied previously for your competitors’ backlinks.</p><p>What are you left with? You now have the domains that are linking to your competitors. All this data is now available for you that you can use for your clients website.</p><p>How much time it took to find potential opportunities by reverse engineering?</p><p>Less than half an hour. Once you get a hang of using these formulas for excel, it gets much easier and faster to find backlinks opportunities for your website.</p><p>I have used this exact method to help achieve better rankings for websites and create a ‘<strong>plan of attack</strong>’ for months going forward after the analysis. I have been able to plan SEO activities to carry out for the whole year based on the findings from this analysis.</p><p>Hope you enjoyed this and will be able to utilize this to find backlinks opportunities. You can use the same method even if you have paid tools and if your tool doesn’t have the capability to find websites that your competitors are getting links from but you aren’t!</p><p>Thank you!</p><p>-Malika</p><p><strong>P.S. </strong><a href="http://www.malikasharma.co.nz/free-competitor-analysis-guide"><strong>To Download the excel sheet and a PDF version of this post, click here.</strong></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6522f7d7d55e" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>