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’re an ecommerce business, then you need to be running Google Shopping Campaigns. Consumers use Google’s search engine on a daily basis to find all kinds of products that they need (including yours), and running Google Shopping campaigns can help you connect with them. These campaigns pull product information, such as the product image, price, and merchant name, from your company’s Merchant Center data feed and conveniently display them to the viewer. Because it pulls this data each time a user makes a search inquiry, you can be assured that your product ads are always up to date and accurate (so long as you keep your data feed that way), keeping your potential customer from feeling confused or frustrated.

Why make the same mistakes your competitors have made when you can learn from them? As its name implies, SpyFu is a great way to spy on the competition so you can learn from their failures and more importantly, their successes. When you type in a competitor's URL, you'll be able to see how many keywords they are ranking for organically and even the ad value of those keywords. It also offers good analytics on backlinks driving the most traffic to your competitors' sites so you can see where you might want to  publish guest blogs or be listed. If they are running any paid advertising campaigns, you can even see what campaigns they're running and how much they're spending.  
You have now reached the final step of creating a keyword strategy: keyword research. Quality keyword research is as essential as doing market research for marketing strategy. By the same token, forming a keyword strategy for B2B marketing and SEO needs heavy research as well. When doing keyword research, there are three important factors to remember:
You need a keen understanding of your ideal customer and the market so that when you launch, your product is positioned correctly in the ecosystem of all products and services. Since competition can come from anywhere, you need to catalog your strengths and weaknesses relative to both direct and indirect category leaders (i.e., those adjacent to your core business).
Everyone knows intent behind the search matters. In e-commerce, intent is somewhat easy to see. B2B or, better yet, healthcare, isn't quite as easy. Matching persona intent to keywords requires a bit more thought. In this video, we'll cover how to find intent modifiers during keyword research, how to organize those modifiers into the search funnel, and how to quickly find unique universal results at different levels of the search funnel to utilize.
The Keyword Planner is a free tool, but you'll need to set up a Google AdWords account first if you don't have one already.  Once you're set up and logged in, go to the Tools bar at the top of the home page and you'll find the Keyword Planner there. Click Search for new keyword and ad group ideas. You'll be able to see suggestions in both the Ad group ideas tab and the Keyword ideas tab. You can add new keywords to an ad group by clicking the double arrows >> next to the keyword or remove them by clicking on the ad group and then the X next to that keyword.
Jeff Baum is Director of Services at Hanapin Marketing and a seasoned PPC advertising professional with Hanapin Marketing. a 13 year track record of success in digital advertising. He has developed and implemented strategies to substantially grow revenue and profits for a variety of lead generation and e-commerce businesses. He has also been responsible and accountable for managing hundreds of thousands of dollars in PPC advertising spend per month. Jeff is a recurring writer for Hanapin's blog and PPC Hero.

Whether you’ve heard a little about PPC marketing and are curious to learn more, or you already know that you want to use PPC to market your business, but aren’t sure where to start, you’ve come to the right place! This is the first lesson in PPC University, a set of three guided courses that will teach you everything you need to know about PPC and how to make it work for you.
By looking at them from a customer’s point of view, you are looking at their major strengths and flaws. In other words, you are doing the first part of the SWOT analysis. You think like a customer would. Why would a customer go for their services? Is it because they do things differently or their quality is top notch? Either way these things are like strengths for the competitors. You put yourself in the customer’s shoes and wonder why you would go for them instead of coming to your own company.

It works like this – if there is an IP address the company wants to locate, they ping ‎it from a few of their servers, for which they already know the location.  A ping is ‎just a way to test if a computer can connect, and how long it takes to do so, but ‎doesn’t transmit any meaningful data.  Then, by looking at the time it takes each ‎server to connect, it can establish a shared point or origin, and thereby physically ‎locate the user.  It uses the public IP locations to validate their approach and check ‎for anomalies in network latency which would lead to bad data.  ‎
Geotargeting is the practice of delivering content to a consumer — via mobile or web — using geographic location information about that individual. At a basic level, a business can restrict its reach to consumers only located in a defined geographic area such as a state or a city. But location often provides much deeper, more meaningful and identifiable traits that tell you what a person wants, needs or is interested in.
How do current customers rate the following features of your business compared to your competition.Rate the following as: fair, good or excellent. Our Company / Competition ___________ /__________ Price ___________ /__________ Quality ___________ /__________ Durability ___________ /__________ Image/style ___________ /__________ Value ___________ /__________ Name Recognition ___________ /__________ Customer Service ___________ /__________ Customer Relations ___________ /__________ Location ___________ /__________ Convenience ___________ /__________ Other
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>
×