Competitive analysis is a key aspect when in the beginning stages of an SEO campaign. Far too often, I see organizations skip this important step and get right into keyword mapping, optimizing content, or link building. But understanding who our competitors are and seeing where they stand can lead to a far more comprehensive understanding of what our goals should be and reveal gaps or blind spots.
Thanks Ramon! You can easily add more tabs to input more backlink data for additional competitors and then adjust the query formula to use the new tabs. I often increase this to 10, 15 or even 20 competitors for larger clients. The beauty of Google Sheets templates is the ease in which you can make these adjustments. Let me know if you need any help with that.
Quality of linking root domains. Here is where we get to the quality of each site’s LRDs. Using the same LRD data you exported from either Moz’s OSE or Ahrefs, you can bucket each brand’s LRDs by domain authority and count the total LRDs by DA. Log these into this third sheet, and you’ll have a graph that illustrates their overall LRD quality (and will help you grade each domain).
If you want to see what people are talking about at any given moment, there's no better way than to check in with your social media channels. Most of us already do this throughout the day, but if you haven't tapped into your channels for keyword research, you're missing out on valuable insights. Here are just a few things you can uncover by typing a word or phrase into the Facebook search bar:
Privacy and security concerns are, by many accounts, the one thing holding location based services back from exploding. One of the first backlashes came from Nordstrom customers, when that retailer tracked customers through its physical locations for market research purposes. The word “creepy” was applied at the time, and it’s still a word commonly found in discussions of how location-based marketing can tend to make people feel.

Many marketers experience this issue during PPC campaigns: They’re attracting the attention of their audience and driving traffic with their ads, yes—but those website and landing page visits aren’t resulting in the amount of conversions they would have expected. If you are also experiencing this, your ads may be targeting consumers who aren’t quite in the decision stage of their buyer’s journey through the use of too many top-of-the-funnel (TOFU) keywords in your ad copy.
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.

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..
If you don't know the difference between head terms and long-tail keywords, let me explain. Head terms are keywords phrases that are generally shorter and more generic -- they're typically just one to three words in length, depending on who you talk to. Long-tail keywords, on the other hand, are longer keyword phrases usually containing three or more words.

Now the ad servers don’t create this table themselves, they license it from another ‎company like MaxMind or DigitalEnvoy, whose primary business is geolocation ‎data.   This is no enviable task; IP addresses themselves don’t necessarily have an ‎obvious pattern in the way they are assigned like a telephone area code would.  It’s ‎a bit like solving a mystery, and the geolocation companies use a variety of ‎methods to approach the problem.  ‎ /injects>
×