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.
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.
I mentioned earlier that I recently performed a competitive analysis for a collaborative meeting note-taking feature, to be introduced in the app that I was developing for a client. The goals for my research were very general because innumerable apps all provide this type of functionality, and the product I was working on was in the very early stages of development.

Need some keyword strategy help while actually creating your posts? If you use WordPress to manage your site content, the Yoast SEO plugin analyzes each post and offers suggestions for improving page content as you prepare your post for publishing. While it’s not a silver bullet that will guarantee good results, it does offer helpful tips for improving your post once it’s in WordPress.
Limiting your organization to direct competitors only might lead you to a very narrow view of the market. This framework allows you to evaluate companies that aren’t just your direct competitors but companies that could easily move into your turf. You want to consider companies that aren’t currently in your category but could potentially leverage their product or technology in your space.
You need to develop tactics to recognise and double down on the deep conviction you have in your gut that nobody else understands. Stop looking for consensus or opportunities that seem obvious and compelling at first glance. Great opportunities never have “great opportunity” in the subject line. Honing your gut instincts and acting upon conviction is a theme of every successful journey.
For branding campaigns, your budget is often not an issue. You may have a fixed budget or your budget may be seemingly limitless. It doesn’t matter, because with this strategy the focus is on position; and in most cases only position #1 will do. This is often the easiest strategy to execute for paid search, but it’s also inefficient. The reality is that bidding into the top position in search results is often a waste of money. Google has gone on the record as saying that conversion rates don’t vary much by position, so in many cases all that the first position buys you in paid search is brand awareness (and vanity).
Keyword research is a time consuming and continuous activity. Create your list of core keywords at the time of campaign planning and you should constantly refine and expand your keyword list for long-tail, low cost and highly relevant keywords. Another important step in keyword research is to review high cost, under performing keywords. Remove these keywords from your list.
Sometimes even the most savvy among us can feel like a confused great-granny on a MacBook Pro running Linux when it comes to the newest, latest tech, and how it actually works. Location-based marketing is already happening. All of the available tools provide opportunities to serve highly localized, highly relevant communications to your customers, based on where they are right now. But what exactly are those options, and how do they work?
AdWords may suggest keywords based on your website content. Feel free to use them for inspiration, but also consider the many different ways you and your customers talk about your business and be sure those turns of phrase are reflected in your keywords. Start by creating a list of about 10 “head terms”—the concepts from which everything else you do follows.

The central idea behind geotargeting is that understanding a consumers real-time — or past —location helps marketers achieve the holy grail of delivering the “right message at the right time.” In a simple example, an adult customer visiting car dealerships is likely interested in buying a car, and serving a local Honda ad to this customer more likely to be successful.

Examples like the above support metrics that find geotargeting doubles the performance of all kinds of marketing methods, from email campaigns to paid search. Per data from the Local Search Association’s LSA Insights database, it also doesn’t matter what vertical your business is in.  The click-through rate for geotargeted mobile display ads was higher than the industry benchmark for all verticals.
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:
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]

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).
More importantly, take the time as you conduct your keyword research to segment and categorize your keywords to map to the right landing pages. If the page doesn’t exist on your site yet, then that is your cue to build a new page for that set of keywords. By doing this you will achieve the relevance that will lead to more engaged visitors and higher conversion rates.
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.
Reason: This metric can help you to know if you have well-organized content. Traffic generated from certain keywords can provide good insight into which pages a visitor typically sees as a result of that keyword query. In case you are using Google Analytics for measuring your visits, you can do it within the following path: Traffic sources > Search > Organic > Landing Pages as 1st dimension & 2nd dimension: Keyword.
The primary goal of a competitive analysis is to understand the marketplace and how you can differentiate from other players. At the end of a competitive analysis, you should create a battlecard for each competitor. A competitive battlecard is essentially a quick visual reference for your sales and marketing team, guiding them as they position your organization against competitors.
On the other hand, version B not only communicates the valueof the cyber security business (protecting other business’s data from hackers and cyber attacks), but also acknowledges the potential customer. The copy in version B also addresses the fact that what the viewer is likely looking for in such a company is a sense of security, and caters to that with the words “protect” and “safe”.

Beyond the city level, your geotargeting on Facebook can further narrow your targeted customers to within miles. For example, a fairly standard radius is 10 miles and closer when you’re targeting a specific product or service in a particular vicinity. If you’re in a more rural setting, you can expand that radius to 20 or 25 miles. Urban areas like Chicago, Los Angeles and New York are targeted within one mile.
In order to know which keywords to target, it's essential to not only understand the demand for a given term or phrase, but also the work required to achieve high rankings. If big brands take the top 10 results and you're just starting out on the web, the uphill battle for rankings can take years of effort. This is why it's essential to understand keyword difficulty.
Because of our idea that you should have one brand and several (hundreds) keywords, we’re not big fans of keyword domains at Yoast either. By using a keyword domain you bind your companies past, present and future to a single keyword. And with the abundance of new top level domains (TLDs) now available, you’ll have a very hard time buying all of the TLDs with the same keyword to keep out the competition.
The final and most important metric is conversion. Make sure that you set up your conversion goals within your analytics. That way you can see which keywords are not only driving traffic but out of that traffic what percentage is converting. That is how you can measure keyword success. If you’re not doing this, then it becomes more difficult to identify your highest performing keywords.
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
Knowing your business’ target audience and matching it up with where they live or work helps you find those who might be most interested in your product or service.  For example, a ticket broker might want to advertise NCAA basketball tickets in the state of Kentucky and might think of using Kentucky basketball in its messaging.  However, Louisville basketball would be preferable for any advertising within 50 miles of the city on the Kentucky side of the border and 70 miles into Indiana due to the strength of Louisville’s fan base in those areas.
Many people believe that a competitive analysis is unnecessary because they feel that they have a good handle on who their competition is and what they offer. But a competitive analysis can also be used when trying to break into a new market. By conducting a competitive analysis for an environment you are unfamiliar with, you are able to model a new business that included many features that your competitors are likely to offer as well as some unique ones that may drive customers away from their typical company.
Next up, it’s time to analyze your competition by doing some competitor research. If you want to do a complete competitive analysis, you’ll need to do a deep dive into the background, location, products or services, marketing, sales, and personnel for each competitor you identified. (You can also break out one of these areas and do a real deep dive into it.)
“Now that the “algos” are perfected, they can be used for accounts as small as 100$ monthly ad spend. While it’s difficult for the small guys to access machine learning on their own, agencies who are servicing SMBs should use tools like ours to manage, optimize and scale multiple accounts. Google Channel Partners, Publishers and Resellers that service hundreds of small-business PPC accounts benefit from our machine learning technology already.”
With a clear understanding of our objectives and audience, we can now determine how we want to target our prospects across the AdWords network. There are multiple targeting options available, from location to demographics and display ads to video ads. The trick is to tailor your adverts to deliver the best results based on how your users browse the web. This chapter provides you with the primary elements required to accurately target your campaign.

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.
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.
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.
×