Great insight here. This template is meant to serve as a base for further customization. Feel free to build on top of it with metrics and data that you find useful, I would love to see what you come up with. You can actually configure the backlink gap analysis to run for majestic or ahrefs by adjusting the query formula slightly. You bring up a great point about analyzing link data from multiple sources to get a more accurate picture so I would definitely recommend exploring majestic and ahrefs data as well..

Great question. You could adjust the formulas but I find it easier to highlight the full report (after it is populated with your data) then copy it and paste "values only" this way none of the formulas break. Then go into the navigation of google sheets and select "Data" then "Filter". You will now have filtering options on all of the headings. Then you can simple select your website and uncheck "Yes" so you only see the domains that do not link to you. Give that a shot and let me know if it works for you.
More and more consumers are finding businesses online through search engines. How do they find them? By using keywords! Fortunately, you can take advantage of this consumer habit by optimizing your website around the keywords that are relevant to your business and which keywords consumers are using to find you online. This will increase your chances of getting found by people searching with those keywords, which will drive more and better quality traffic to your business’ website.
If your account is currently achieving a return on ad spend (ROAS) of 5, and your goal is to achieve a ROAS of 6, your strategy should focus on efficiency optimizations to improve ROAS. If your account is achieving a ROAS of 5 and your goal is to increase revenue as long as your ROAS is at or above 4 (and you have additional budget to spend), then your strategy will need to focus on growth initiatives.

Title tags appear optimized (editorially). Here is where we can add more context to the overall quality of the sample pages’ titles. Even if they are technically optimized, the titles may not be optimized for distinctiveness or written quality. Note that we are not evaluating keyword targeting, but rather a holistic (and broad) evaluation of how each competitor’s site approaches SEO factors. You should evaluate each page’s titles based on the following:

This data gives us a starting point to build out complex keyword mapping strategy documents that set the tone for our client campaigns. Rather than just starting keyword research by guessing what we think is relevant, we have hundreds of keywords to start with that we know are relevant to the industry. Our keyword research process then aims to dive deeper into these topics to determine the type of content needed to rank well.


It’s easy to get blindsided by our own opinion on “high-quality” content. You might be thinking you have an awesome idea that everyone wants to read about, but how do you know with absolute certainty that it’s really that great? And even if your hunch is spot on and you’ve discovered something truly worth sharing, how do you quantify its value? How do you find the right content marketing keywords?


Unfortunately, whilst digital marketing provides these tools, most advertisers still find themselves in a situation where they don’t know what is working. The ubiquity of search engines in our modern lives has led advertisers to skip straight past considerations for strategy, planning, and measurement and dive straight into tactical marketing efforts like Pay-Per-Click and SEO, where they are as equally unsure if their efforts are delivering a meaningful return for their business.

For example, say you run your own B2B marketing agency. If you’re advertising high-level digital marketing services, you want to make sure that the traffic you get from PPC campaigns only includes quality leads. Using negative keywords like “free” and “cheap” will help you avoid people who are not looking to pay for marketing services. If you only work with clients in the United States, you could also use location-based negative keywords. For example, to avoid keywords like “B2B marketing services in Russia” you could add “Russia” as a negative keyword.
4. Choose keywords based on more than just high search traffic. Depending on which strategy you’re using, branding or conversion, you should not fall into the trap of just looking at search volume when judging which keywords to use. Just because one keyword has a whole lot more searches than another doesn’t necessarily mean it will be a better performing search term. Take the time to analyze other factors that provide more granularity. Here is an example of other factors you may want to look at:
I always tell people to think of their site as a pyramid. Your brand is at the very top, below that is your cornerstone content for your “head: keywords, the keywords you care about the most, below those are dozens – if not hundreds or thousands – of pages, strengthening your site’s structure. I wrote about site structure & SEO over 3 years ago but it still rings true. We wrote about both these topics in our ebook too.
A backlink gap analysis aims to tell us which websites are linking to our competitors, but not to us. This is vital data because it allows us to close the gap between our competitors’ backlink profiles and start boosting our own ranking authority by getting links from websites that already link to competitors. Websites that link to multiple competitors (especially when it is more than three competitors) have a much higher success rate for us when we start reaching out to them and creating content for guest posts.
It’s also best to look for those businesses that are of a similar size as yours. For example, if you’re a solo entrepreneur selling handmade potholders online, big chain grocery stores usually aren’t your direct competitors, even if they might carry handmade potholders in their inventory. Instead, look for other small to medium scale producers of handmade potholders and similar kitchen accessories.
In online environments, ad servers look at a user’s IP address to figure out their ‎location.  Behind the scenes, the ad server maintains a large database that has ‎every IP address already mapped to its country, state, and postal code.  So, when a ‎request comes in, the ad server strips the IP address from the header of the ‎request, queries this table, finds the necessary location data, and then picks an ad ‎that matches that criteria.  ‎
As I consult and train people on Internet marketing, I typically ask whether keyword research is a strategic function or a tactical one. Often people think it’s tactical because of the tedious nature of the work. I submit it is not only strategic but also foundational to all marketing channels you will use. If you take the time up front to outline a killer keyword strategy, you will find your campaigns will be higher performing and more successful. In this column, I will outline seven tips for developing a killer keyword strategy you can use to take your campaigns to a higher level.

Although more and more keywords are getting encrypted by Google every day, another smart way to come up with keyword ideas is to figure out which keywords your website is already getting found for. To do this, you'll need website analytics software like Google Analytics or HubSpot's Sources tool. Drill down into your website's traffic sources, and sift through you organic search traffic bucket to identify the keywords people are using to arrive at your site.


Google Ads operates on a pay-per-click model, in which users bid on keywords and pay for each click on their advertisements. Every time a search is initiated, Google digs into the pool of Ads advertisers and chooses a set of winners to appear in the valuable ad space on its search results page. The “winners” are chosen based on a combination of factors, including the quality and relevance of their keywords and ad campaigns, as well as the size of their keyword bids.
This broken-link checker makes it easy for a publisher or editor to make corrections before a page is live. Think about a site like Wikipedia, for example. The Wikipedia page for the term "marketing" contains a whopping 711 links. Not only was Check My Links able to detect this number in a matter of seconds, but it also found (and highlighted) seven broken links.
×