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

You should also take time to ensure that your landing page is designed well, but not just in appearance. Be sure to focus on loading speed and usability as well. Together, all of these elements are crucial to the success of your campaigns. Afterall, you don’t want to spend all your time designing PPC ads only to have your leads bounce right off as soon as they reach your boring or unsightly landing page design—or worse, leave before it even has a chance to load.
Say your e-commerce site focuses on college students. Target promotions to local coffee shops within a couple miles of your store front that students frequent. Students that bring in a receipt from the coffee shop to your brick and mortar store get a special discount. You can push this email campaign to users that are within a 10 mile radius of the coffee shop and your store.
Generic keywords: These are generic words that describe your business as well as other businesses in your niche. They do not necessarily set your business apart from the million other businesses out there and ranking for these keywords is difficult given the immense competition for both paid and organic results. Nevertheless, these terms are likely to be used by your audience in the first stage of searching.
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.
One way to get a good idea of how your target market might view your industry is to just ask them. Using focus groups, questionnaires, and surveys can help you can gather information on popular businesses with products similar to your own. You’ll also get first-hand information of how customers feel about the products that are already on the market.
The key to getting the most successful results from your PPC (pay-per-click) campaigns is developing a strategy that utilizes the many powerful tools at your disposal with Google Adwords. While boosting your clicks and conversions may at first seem like some sort of magical alchemy, there are actually tons of tangible ways to help drive traffic and increase sales. Best of all, Google is constantly adding new tools and refining older ones that you can add to your arsenal.
A logo offers a brief glimpse into a company’s branding language. This section will quickly provide your audience with that value, as the different colors and imagery will give life and organization to your document by separating the competitors’ brands from each other. When it comes to adding your competitors’ logos, make sure to use high-quality images. Including words like “vector” and “high-res” to your Google search will bring in superior results. Make sure your logos are consistent across the board. (Most companies have both with-text and without-text logo variations — double check to make sure it’s the same format for each of your competitors.)  
Competitive analyses for SEO are not something that should be overlooked when planning a digital marketing strategy. This process can help you strategically build unique and complex SEO campaigns based on readily available data and the demand of your market. This analysis will instantly put you ahead of competitors who are following cookie-cutter SEO programs and not diving deep into their industry. Start implementing this process as soon as you can and adjust it based on what is important to your own business or client’s business.

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.
Chesky and Gebbia believed that most people thought hotels were the only option for travelers, but the truth was that renting someone’s extra room was cheaper with an added dose of personalised hospitality – and likely a higher margin business as well. Hyman and Fleiss believed that most people thought they needed to buy the dress they wanted to wear, but the truth was that you didn’t need to own a dress that you only wear a few times. Both teams set out to challenge old customer preferences with modern technology and logic.

According to Nielsen Norman Group’s “User Experience Careers” survey report, 61% of UX professionals prefer to do the competitive analysis for their projects. But what exactly is competitive analysis? In simple language, competitive analysis is nothing but a method to determine how your competitors are performing, what they are offering and how well they are doing it.
As of 2017, there are over 5,000 products in the martech sphere alone competing for business in complex and overlapping ways. Some companies leverage their expertise and resources to enter new markets. Salesforce is a great example; look at the number of martech categories it’s listed in. With so much competition, SaaS companies can't win on features alone; they must win on brand and customer experience.
Let’s start with an easy one: target the areas your business serves. If your restaurant has one location in Chicago, set your search campaigns to only show to searchers in and around Chicago! If you’re an ecommerce site that serves the Pacific Northwest, don’t show your ads outside of Washington, Oregon, Idaho, Montana, and Wyoming. This is the most basic way to ensure that you’re not wasting clicks – and money – on consumers who can’t convert.

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]
Reason: If visitors find your website with a certain keyword but you have a high bounce rate, that’s enough to know that something is not going as it should. Ask yourself and test if it is a problem with content quality, appearance, etc. There is often more than one explanation for a high bounce rate, and there could be more than one solution. If you are totally lost at this point, a feedback session with five potential users might provide some insightful ideas.
Research Access suggests many other ways that geolocation can help improve the market research process. For example, a consumer products company could use geolocation to “understand how frequently a sample of shoppers visits different grocery chains,” or an auto manufacturer could apply it to collect “a sample of minivan-driving moms to better understand how the product is used.” There are a multitude of ways geolocation can help improve understanding and inform strategic direction for companies of all sizes so they can more closely meet their prospective targets’ desires.
Once your ad is displayed, it’s likely to be clicked by only a tiny percentage of people who search for such a broad term, making it less likely to be displayed in the future. And even if you create an ad that’s broad enough for those searchers to reliably click, they’re unlikely to find exactly what they’re looking for on your landing page. You’re paying a lot for poor-quality traffic.
I have often gone on the record with my skepticism toward paid search campaign management software, and I have several reasons for being skeptical. My main concern has been that these tools over promise on features and under deliver on performance. They claim to replace the analyst by using algorithms to optimize campaigns, but in reality they replace the fun piece of the analysts job (improving results) and replace it with the tedious task of managing to get their campaigns to work properly in the software. I have been burned by this sales pitch twice and have written about this in a previous post called “Paid Search Bid Management Tools: Great Investment or Save Your Money?” – so feel free to read that post for more details.
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.
“We’re seeing a lot of attention on our Promote product, a solution for small business owners, that few people realize is powered by automation and machine learning behind the scenes. We’ve partnered with large banks, small business service providers, and more to bring this machine learning martech to small business owners. And we’re not alone. There are many examples of increasingly accessible machine learning tools for small businesses.”

Estimated Costs: Creating content to adequately target specific keywords will require varying amounts of time, money, and effort. In some situations, you might find that targeting a certain keyword also allows you to SEO your landing page at the same time. So be on the lookout for shortcuts that might make ranking for a keyword more cost-efficient than it would otherwise be. That’s how you can find real money-makers!
The purpose of this guide is to provide a simple, actionable approach to building strategic PPC campaigns. Much of this is common sense and our goal with this guide is to lay out a strategic and procedural process allowing you to research and implement PPC campaigns that deliver the goods. In this chapter we teach you everything you need to know about putting your PPC strategy into action to begin converting browsers into buyers.
Research Access suggests many other ways that geolocation can help improve the market research process. For example, a consumer products company could use geolocation to “understand how frequently a sample of shoppers visits different grocery chains,” or an auto manufacturer could apply it to collect “a sample of minivan-driving moms to better understand how the product is used.” There are a multitude of ways geolocation can help improve understanding and inform strategic direction for companies of all sizes so they can more closely meet their prospective targets’ desires.
L’Oreal did something similar when it used geolocation technology to create a virtual art exhibit that allowed attendees to uncover the art and feel as though they were right there looking at it. Brands can also use geolocation technology in mobile apps that include gamification aspects to engage a user more fully in a particular product or service.
Another thing to keep in mind is your landing page’s loading speed. Can you remember the last time you waited for a page to load? Probably not. Chances are you exited the page and moved on to something else. That’s the last thing you want when there’s a customer willing to spend money. Speak to your website manager to ensure your landing pages load quickly.

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.
Export the weighted list back to your spreadsheet and combine it with the others in Excel. Then use the data tools to sort the list by ‘Priority’ – this is a score based on the difficulty, traffic, opportunity and your score. This tells you which keywords you should be targeting in descending order of attractiveness. Suddenly, you’ve turned more than 1,000 keywords into a usable list of a few dozen. Using the same example for wines:
Features/commentsIn this column, I put all of my comments, some ”star” features I needed to focus on, and the pros and cons of the competitor. I color-coded the cells so that later I (or anyone viewing the matrix) could easily identify the difference between them. For example, I used light yellow for features, light purple for comments, green for pros and red for cons.
AdvertisingNot only does advertising copy tell you a competitor's price and other product information, it provides an indication of your competitor's entire promotional program and budget. When reading a competitor's advertisement be sure to note the following: publication, frequency, special offers, product features and benefits highlighted. If your competitor suddenly places an advertisement in an industry publication that neither of you are currently selling to, it's an indication that they're trying to reach a new market segment. It's also important to notice the design and tone of your competitor's advertisements. What kind of image do they convey? How does your own image compare? Are their advertisements in color while your own are black-and-white? Even if they're not, a clever advertising campaign can communicate that your competitor is an innovative, fresh company.  
In summary, these are but a few of the examples of how geography plays such an important part in creating customized and targeted marketing campaigns. Consumers respond better to relevant marketing which means that ROI of targeted campaigns will increase. Mobile consumers make geography one of the best ways to target while technology and data make doing so a real advantage to those who use it. Sometimes it takes a little creativity, but it is worth the effort. Especially for the business of local.
With an SEO analysis report from 1&1, you get quick and easy access to all the important facts relating to your website's visibility on search engines like Google and Bing. Ranking highly on search engine results pages (SERPs) is crucial to the success of your website. Since it focuses on achieving higher rankings organically, rather than paying for advertising, search engine optimization has become one of the most important disciplines in modern online marketing. Our site SEO ranking checker immediately shows you where your website is placed, and reveals areas that require further optimization. After receiving your site SEO analysis, you will be well-placed to make all the adjustments necessary for your website to climb the search engine rankings and be more easily found by your target audience.
×