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.
Competitive analysis can help frame your own product context, discover other problems your customers have, and even bond the team together against a common foe. For all of these reasons and more you shouldn’t ignore your competition. However, if you don’t properly understand how they impact your organization’s strategy, competitive analysis is simply a waste of time.
Ad scheduling is important for optimizing your ad strategy. You can show your ad whenever a customer searches online or you can show your ad on certain days, or during business hours when you’re there to handle customer inquiries. Your ads give different performance result on different days of the week and different hours of a day. Therefore, have a look at which online days and hours are most suitable for your business and then schedule your ad during these times to increase your exposure. You can also adjust your bid for less performing hours and days.

Newspaper and Magazine ArticlesArticles in newspapers and magazines are a source of information you can use to get an idea of what your competitor is planning for the future, how their organization is run, and what new product information or innovations they have. Journalists may also uncover and reveal unflattering information about your competitor that may prove valuable to you. Be on the lookout for product reviews in magazines; they will reveal a competing product's strengths and weaknesses. Visit a college or public library. The reference librarian will show you how to find pertinent articles online much more quickly and easily than you'll find them by browsing.  
Geo-Targeting allows you to run different campaigns in different locations. Your ads might be served all over the world and vary in their marketing message according to the segment and audience that you approach. Is the marketing message on your site the same as the geo-targeted ad? Experiment with sending traffic from a geo-targeted banner to a geo-targeted landing page (in language, currency, offer, etc) and to a generic page – what converts better?
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.
These days, organic SEO is all about creating the highest quality content that is actionable and informative around a specific topic. While your content will no doubt contain keywords referencing said topic in places like heading tags and body copy, search engines are well-versed at filling in gaps about content topics without needing to be bludgeoned by keywords. Keyword research can never—and should never—be used as a crutch for poor content quality. However, exercises like those described below, can play very important roles in helping you define and measure your content strategy as well as mapping your content topics to real users’ needs. Words matter. 
Ad copy is the actual text that you’ll write for your AdWords, Bing or Facebook ads that will attract people to click on your ad. Search engines like Google are looking to show high quality ads, whose text says something closely related to the actual search in the search engine. So if you own a plant nursery in Montreal and your keyword is “Where to buy shrubs in Montreal,” a good headline for your ad could be: “Are You Looking to Buy Shrubs in Montreal?” Because the headline is relevant to the keyword and the query, it will be considered a more high-quality ad result in the eyes of search engines like Google.
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.
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.
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.

Brands love to be front and center and who can blame them? Essential to becoming a well known brand is achieving awareness and name recognition, and well branded companies tend to do well at drawing in new customers. In the world of search, the best way to build your brand is by showing up in the top position of search results. Preferably you can do this for both organic and paid results, but at the very least you can often buy your way to the top of search results with a high enough Maximum CPC bid. You will also want to enhance your brand even further by adding Sitelinks to your account to showcase the depth of products and services you offer and occupy even more real estate in search results.
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.
Ad text plays an important role in the success of your ads. It is the form of marketing communication that advertisers can use to promote their product or service on search platforms. An effective ad text consists at least one of your core keyword, attractive discounts and promotion and a call to action. The quality score of your ad depends on multiple factors and your ad text is one of them. Your ad text should be unique and appealing. Include discount amount in your ad copy and also add a strong call to action that can compel searchers to click on your ads. Use action words like buy now, order now, resister today or sign up here. Include one of your keyword in your ad text and match your ad to your landing page.
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.
1,000+ keywords: if it’s just you or 2 of you, this is probably more than you can chew off. It’s not hard to gather 1,000 keywords though, so if you’ve got the time, the people and the inspiration, it usually does pay off to write a lot of meaningful content. Do make sure that all those keywords relate to your products or services as otherwise it’s nonsense and make sure that you’re structuring your site well around it.
It’s important to remember that online shoppers are humans, and to treat them as such. The examples below show two versions of the same ad for a fake cyber security business. While version A does provide potential customers with information about the company and the services it offers, it fails to address them as people or speak to the challenges or pain points they might be experiencing.
It’s not easy to find information on market share. Large companies invest millions of dollars to investigate market share but most SaaS companies don’t have such resources. The best shortcut is to conduct a survey with a sample size of 200-300 respondents, asking them what tools and solutions they are using. That’s usually just enough to get a ballpark estimate of market share in the SaaS industry.

Keywords are the words and phrases that people type into search engines in order to find what they're looking for. By extension, they also describe what a piece of content (or an entire website!) is all about, and they're the words at the heart of on-page optimization. They still play an important role in a site's ability to rank, so by identifying the right words and phrases to target you can have an outsized impact on achieving your SEO goals.
Also, click on the “CTR” checkbox at the top of the graph. That will display a line graph overlay that displays your click-through rate for search. If you see that it’s dropped recently, it might be a good idea to check your meta description tags to make sure that they haven’t changed. It’s possible that people aren’t as “tempted’ to click on your link in search results because there’s not a very good description of the page contents.
Don’t base your whole strategy on chasing volume though. Pay attention to the competition column in the keyword research tools. Even though these tools use pay-per-click (PPC) data to determine competitiveness and suggested bid, you can still extrapolate this data for organic search. High competition and suggested bid is a strong indication that there’s money to be made off of these keywords, as advertisers generally won’t bid high CPCs on poorly performing keywords.
As a start-up, you likely have a lot of competition in your industry. This means that you need to stay organised in order to keep ahead of the curve. By being more organised, you will be able to meet client briefs on time and keep to your schedule. Organisation is important for your start-up because it saves you time, stops you from procrastinating and keeps your employees on track. With improved customer service due to your efficiency, you will soon find your business growing in leaps and bounds.
A company rarely competes against just one competitor. In fact, in many cases, the biggest competition in the SaaS and tech industries is coming from indirect competitors. These competitors hold a commanding position in their core market, allowing them to expand into different industries and verticals. Who would have thought that Uber and Google would become die-hard competitors in the autonomous car market? As I wrote previously in my analysis of sales enablement and acceleration industry, it is almost impossible to distinguish direct and indirect competitors. In many SaaS verticals everyone competes with everyone.
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.
Knowledge of a competitor's objectives facilitates a better prediction of the competitor's reaction to different competitive moves. For example, a competitor that is focused on reaching short-term financial goals might not be willing to spend much money responding to a competitive attack. Rather, such a competitor might favor focusing on the products that hold positions that better can be defended. On the other hand, a company that has no short term profitability objectives might be willing to participate in destructive price competition in which neither firm earns a profit.

To create a similar chart, start with your website goals and map them to a potential visitor’s goal. For example, you may want to generate more event space inquiries, which means potential visitors to your website would likely be searching for an event space. Now ask yourself: what do people searching for an event space type into Google? If I were looking for this type of product or service, how would I search for it on the web?
Even national marketing campaigns can benefit from geo-targeting, as regional differences create opportunities to test multiple messages and refine them as a campaign continues. Geo-targeted experiments has been used successfully by businesses, charities and even political campaigns. Factoring out cultural and ethnic variations, there are still subtle regional differences in something as universal as language. A campaign for donations might be better served by using a “donate” button in one area and a “support” button in another. Similarly, customers might respond differently to the phrase “book your trip” than they do to “buy your ticket” or “schedule your trip.” The same goes for the look and feel of the advertising copy and other content.
Choosing landing pages for your keywords is an important element of your keyword strategy, and can be critical for both your SEO and your user experience. Look at it this way: When you click through to a site that really isn’t relevant to your search, what do you do? You most likely leave that page after a few seconds and likely won’t consider it in the future. So having poorly optimized landing pages can cost you sales. But they’ll also damage your SEO efforts, making it hard to rank.
Choosing which PPC strategies to deploy will largely depend on the type of business you have and the goals you’d like to achieve. By now, almost all of Google’s above-the-fold search engine result page (SERP) space is PPC advertising, which includes Google Shopping ads and PPC Adwords ads, as well as organic search results. Given this increasingly competitive and limited landscape, it’s important that you use the tools available to get a leg up on the competition. To help you navigate the field, here are 8 of the best PPC strategies your competition is not doing (and that you should be).
Every company has those dreaded competitors they cannot stand, no matter what you do they are always using your ideas and taking your potential customers. Whether you are a local, national, or international company there is probably someone in your company, specifically the sales and marketing teams, that can quickly rattle off your top competitors as well as what differentiates them from you.
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.
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!
Steve Webb is an SEO audit specialist at Web Gnomes. He received his Ph.D. from Georgia Tech, where he published dozens of articles on Internet-related topics. Professionally, Steve has worked for Google and various other Internet startups, and he's passionate about sharing his knowledge and experiences with others. You can find him on Twitter, Google+, and LinkedIn.

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

Use these consumer characteristics to time and target your marketing. For example, airports on weekdays are a great source of business travelers looking for high-end restaurants, while weekends and Spring Break bring more leisure visitors and families looking for more casual dining options. Likewise, dance clubs and bars can benefit by promoting 18 and over events targeted at universities whose student bodies are largely between the ages of 18-21. These are just a few examples of how venues define audiences that can be effectively targeted.


If you want more traffic from the search engines, follow the steps from the SEO analysis report. The SEO Analyzer point out all of the problem you may have on you website and supply with tips how to fix them. Use wisely and remember not to over-optimize the page, as it may look that the page is created for search engines. Our SEO Analyzer is the most advanced and fastest analyzer on the web.
×