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.
This section serves as a summary and analysis for all of the research you've done so far. You'll review all the aspects of your competition's business and determine whether they are strengths or weaknesses. List their strengths and advantages under "Strengths" in the worksheet. Note down how equipped you are to deal with these strengths. Can you do better than them or would it serve you better to outdo them elsewhere?

We at Moz custom-built the Keyword Explorer tool from the ground up to help streamline and improve how you discover and prioritize keywords. Keyword Explorer provides accurate monthly search volume data, an idea of how difficult it will be to rank for your keyword, estimated click-through rate, and a score representing your potential to rank. It also suggests related keywords for you to research. Because it cuts out a great deal of manual work and is free to try, we recommend starting there.
Funny thing is we’re not seeing users click on the extension itself very often – slightly more often than we’d see for sitelinks, but not by much – maybe 15 percent of total clicks, albeit not necessarily on the extension itself. It may be the way that we’ve set it up (we say chat with a live expert rather than text us), so that may have skewed the behavior.
You can search for these types of competitors online (by doing a simple web search), or you can directly ask your current and potential customers what they are using already. You can also look for your direct and indirect competitors on websites such as Crunchbase and Product Hunt, and you can search for them in the Google Play and the iOS App Store.
WooRank is a freemium tool that provides an “instant website review.” Without a premium account, you are only allowed to generate a limited number of free reports, but you are able to view previously generated reports. Also, the tool currently offers a 7-day unlimited free trial, which gives you access to unlimited reviews. If you’re interested in purchasing a plan, the cheapest one is $49/month.
Dmitry single-handedly grew a startup from zero to 40 million page views through PR & SEO and got acquired by Google. He has translated his know-how into an SEO and PR coaching program PRThatConverts and a 'PR on a shoestring' pitching service and software JustReachOut which is used by 4,000+ professionals and entrepreneurs to pitch relevant influencers and bloggers to get featured in press every single day. In his spare time he writes about SEO and PR on his blog CriminallyProlific.
Once you have caught the attention of people with your ad and they click on it, you want to make sure that you direct them to a customized landing page that specifically relates to what they just clicked on. Many small businesses make the mistake of sending them to their website homepage, but this isn’t the best tactic to convert visitors. Instead, you need to design landing pages that reflect the keywords from the PPC ad, show the product or service solution that your new visitors were searching Google for, and have a prominent, clear call to action like “Book Now” or “Buy Now”.
And so on and so on. The point of this step isn't to come up with your final list of keyword phrases -- you just want to end up with a brain dump of phrases you think potential customers might use to search for content related to that particular topic bucket. We'll narrow the lists down later in the process so you don't have something too unwieldy.
Your costs can be lower when you stay away from national campaigns that take a more shotgun approach to your social media advertising efforts. Instead, geotargeting will enable you to conduct regional-, state- and city-level campaigns that will improve your results. That’s because this approach helps to tighten your campaign’s boundaries around your company’s physical location.
Using geo-targeting, you use smart marketing tactics. A great example of a successful use of area segmenting is evo, an e-commerce sporting goods store. When they took the leap to open up three brick and mortar stores. Their first step was to send out an email blast for a $200 shopping trip to users in the area. Though the campaign had a 58% conversion on mobile users, the campaign wasn’t as effective at driving traffic to their store fronts.
Both geo-fencing and geo-targeting can be done on mobile, tablet, computer, or even gaming devices with internet access.  When it comes to deciding which is best for your marketing, think of who your target customer is. If you are interested in advertising to a population of all ages and all interests, geo-fencing is perfect for you. If you are only interested in hitting only a specific consumer demographic that is more niche, then you should be doing geo-targeting.

The metrics you provide here will depend on the depth of your research. Be sure to keep it consistent by including criteria that can be answered for all competitors. Providing specific, additional information for just one competitor will give your document a bias. As far as gathering publicly available information, here are the first places to look. For company size, LinkedIn is a great resource for discovering the approximate number of employees. Financial details? Check Yahoo Finance and Wikipedia for relevant information. Want to get an idea of their website’s traffic and ranking score? Search on Alexa. More Free Resources: AngelList, Crunchbase
This section serves as a summary and analysis for all of the research you've done so far. You'll review all the aspects of your competition's business and determine whether they are strengths or weaknesses. List their strengths and advantages under "Strengths" in the worksheet. Note down how equipped you are to deal with these strengths. Can you do better than them or would it serve you better to outdo them elsewhere?
With the constant stream of new betas, introduction of format changes (hello Expanded Text Ads!) and a multitude of new targeting methods such as tablet bid modifiers and demographic bidding for search, paid search marketing continues to become more and more complex. Gone are the days when running ad copy tests, adding negative keywords, performing bid adjustments, and launching more targeted ad groups was sufficient to drive account growth. Today’s paid search advertiser must choose from hundreds of available account optimization strategies.
Geotargeting in geomarketing and internet marketing is the method of determining the geolocation of a website visitor and delivering different content to that visitor based on their location. This includes country, region/state, city, metro code/zip code, organization, IP address, ISP or other criteria.[1] A common usage of geo targeting is found in online advertising, as well as internet television with sites such as iPlayer and Hulu. In these circumstances, content is often restricted to users geolocated in specific countries; this approach serves as a means of implementing digital rights management. Use of proxy servers and virtual private networks may give a false location.[2]
A first step is to try to articulate what market it is that you serve. Who are the customers in this market and what problem, need or want are they experiencing? Which organisations are currently satisfying these needs or wants and how do these organisations differ? If there are multiple products tailored to different market segments try to define the ways in which these products can be grouped together or set apart. Using simple 2×2 matrices (e.g. price vs. functionality) can help to categorise your competitors and help to show what customers are looking for.
SpyFu displays side-by-side data on your competitors' paid and organic search results, so you can easily see where it's more cost-effective to bid on a particular keyword as opposed to trying to rank for  it organically. That way you can use your time more efficiently by writing content around those keywords that drive a lot of traffic but are more expensive to bid on.
Reason: When a visitor sticks around on your site for a minute or less, you can consider their stay to be negligible. When a visit exceeds that amount of time, the visitor has more potential for becoming a client and an increased chance of converting on your calls-to-action. If a visitor spends a considerable amount of time on your website, they are likely to come back or to take action on conversion areas you have included in your site (call-to-actions, downloads, contact forms, etc.).
Once you have a short list of keywords, create separate pieces of valuable, high-quality content, each optimized for an individual term on the list. Through the process outlined above, you aligned keywords with searcher intent. You ostensibly know what searchers commonly put into search engines to find content related to your business goals. Now, your content should actually meet those searchers’ needs. In fact, it should be your goal to create the best, most actionable content to answer a specific question a target user might have as possible.
The secondary and tertiary groups are both your indirect competition.Their products may not be the same as yours, but could satisfy the same need or solve the same problem. You should primarily focus on your direct competitors, but you should watch your indirect competitors. These businesses may move into another group as your business, or theirs, grows and expand product offerings.
You and your competitors are competing for the attention of potential customers. That’s why it's useful to know how your competitors use social media channels and paid acquisition channels to reach their target audience. While digital channels are key in today’s marketplace, you also need to pay attention to offline channels like events, meetups, conferences, and direct mail. This is where the face-to-face interactions occur that are often the key to establishing connections and sealing deals. You can usually find out information about offline events by visiting the “Events” section of your competitors’ websites and also searching for their names in relation to conferences and events on the wider web.
In the figure below, you can see I have set up a keyword rating spreadsheet. I first gathered keyword data from a keyword tool to populate the orange columns. In this example, I used the Google AdWords Keyword Tool. From there I began looking at each keyword and gave each one a score from one to 10. For some I built a formula to automate the process, which comes in handy with larger keyword lists.
A competitor's capabilities can be analyzed according to its strengths and weaknesses in various functional areas, as is done in a SWOT analysis. The competitor's strengths define its capabilities. The analysis can be taken further to evaluate the competitor's ability to increase its capabilities in certain areas. A financial analysis can be performed to reveal its sustainable growth rate.
Protecting your company with one of the core barriers is smart. Nailing down two barriers is even better. Slack is a great example of a company that has a network effect, having successfully created widespread demand through word-of-mouth referrals and a highly engaging product. It has also invested in building strong relationships with developers. Slack’s developer platform roadmap and its commitment to transparency for developers has helped the company build a strong ecosystem around its product.
Like most advertising techniques, geo-targeting predates the internet. Local papers, radio and television programs have long been used to reach customers in a particular region with ads. These advertisements were customized for the local audiences where possible, a process that we now call optimization. Digital technology has simply made this practice more widespread. The major innovation that has increased the effectiveness of geo-targeting is the addition of other data points beyond simple location.
Bluetooth technology is less expensive than GPS and WiFi. However, while bluetooth makes beacons great, it’s also their downside, as many folks keep bluetooth turned off when they’re moving around in the world. To understand the tech in greater detail, Estimote, a beacon vendor, does a good job of explaining the physics and math of how beacons work.
If your competitors tend to blog three times a week compared to your one article every two weeks, it will be beneficial for your company to start generating more traffic to your site by blogging more frequently about relevant topics. Don't just blog because you want to add more content, it won't generate more traffic if the content your adding isn't remarkable.
Competitive analyses help you evaluate your competition’s strategies to determine their strengths and weaknesses relative to your brand. When it comes to digital marketing and SEO, however, there are so many ranking factors and best practices to consider that can be hard to know where to begin. Which is why my colleague, Ben Estes, created a competitive analysis checklist (not dissimilar to his wildly popular technical audit checklist) that I’ve souped up for the Moz community.
Geotargeting in geomarketing and internet marketing is the method of determining the geolocation of a website visitor and delivering different content to that visitor based on their location. This includes country, region/state, city, metro code/zip code, organization, IP address, ISP or other criteria.[1] A common usage of geo targeting is found in online advertising, as well as internet television with sites such as iPlayer and Hulu. In these circumstances, content is often restricted to users geolocated in specific countries; this approach serves as a means of implementing digital rights management. Use of proxy servers and virtual private networks may give a false location.[2]
Although this process can be tedious and time consuming, it is essential in identifying where your competition may be surpassing you as well as what advantages you have over your competition. Developing takeaways will help identify these strengths and weaknesses. From there, you can improve your marketing plan by putting greater influence on the features your company offers and finding ways to implement features your company doesn’t offer that seem crucial to gaining customers.

It’s good for searchers – Research indicates that searchers click on paid search ads more often than any other form of digital advertising. This means that people really don’t mind being advertised to, provided that the products and services advertised actually fit the searcher’s needs. And because we use search engines when we’re looking for products and services, the results, including the ads, are generally highly relevant to what we’re looking for. Plus, Google has developed an excellent formula for ensuring that PPC ads meet the user’s needs.
Local plumbers can’t provide their services even three counties over (let alone three states over), and a juicy burger wouldn’t exactly hold up well in express shipping. Some businesses rely only on local customers. As a result, they’ll want their PPC campaigns only to appear in the feeds and searches of users who are within a set distance from their home b3ase.
"My favorite part about voice search is just how clear the intent is in the query. For example, if I typed in 'hotels in the Bahamas', you’d have no idea whether I was looking for a romantic getaway, a singles trip or a family vacation. Chances are the results would be different for each. But if I asked Cortana, 'which are the best family-friendly hotels in the Bahamas,' then a far more targeted result could be served.
In the Google Sheets Template, I've provided you with the data points that we'll be collecting, the tools you'll need to do so, and then bucketed the metrics based on similar themes. The data we're trying to collect relates to SEO metrics like domain authority, how much traffic the competition is getting, which keywords are driving that traffic, and the depth of competitors’ backlink profiles. I have built in a few heatmaps for key metrics to help you visualize who's the strongest at a glance.
×