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.
But switching costs, or the cost that a customer incurs as a result of switching products, still exist. Technology can be a driver of higher switching costs. When a product is integrated with multiple systems and APIs, switching to another product becomes increasingly difficult. Such a switch usually results in business interruption and the need to retrain staff, among other unwelcome effects.

We must clearly identify our objectives for the campaign and tie the campaign objectives to business objectives. Your objectives could include raising awareness, increasing engagement, generating conversions, and customer retention. Your objectives will need to be tailored to your specific business and you will want to map your objectives to a typical marketing funnel. This chapter highlights how to identify your objectives to measure success.
SEOptimer is a free SEO Audit Tool that will perform a detailed SEO Analysis across 100 website data points, and provide clear and actionable recommendations for steps you can take to improve your online presence and ultimately rank better in Search Engine Results. SEOptimer is ideal for website owners, website designers and digital agencies who want to improve their own sites or theirs of their clients.
Exhaustive – Your keyword research should include not only the most popular and frequently searched terms in your niche, but also to the long tail of search. Long-tail keywords are more specific and less common, but they add up to account for the majority of search-driven traffic. In addition, they are less competitive, and therefore less expensive.
"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.
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?

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.
Finding the right competitors for my research wasn’t a hard task because I already knew many apps that provided similar features, but I still did a quick search on Google, and the results were a bit surprising — surprising because most of the apps I knew turned out to be more like indirect competitors to the app I was working on; and later, after a bit more searching, I also found the apps that were our direct competitors.

It simplified the ways that an organization can compete into four: cost leadership, differentiation, the focus on cost, and the focus on differentiation. Since the inception of Five Forces there has been a lot of discussion about how helpful the categories are, but it seems to be part of everyone’s strategy and competitive toolbox, especially for MBAs.
In 2017, it’s a requirement for any company to live on the internet. This section gives you and your team easy access to your competitors’ online presence. Include links to the social media channels and webpages your competition has the most activity on. By providing these links, your audience can quickly determine what channels the companies take advantage of the most and how they use them to tell their brand story. Understanding why and how the competition is doing well or not with their online presence will reveal the opportunity.

As the content manager, Annie manages a team of brand journalists and is the driving force behind the content strategy for companies in a wide range of industries, including healthcare, technology and professional services. Relying on interviewing skills she developed in her seven years as a journalist, she uncovers insights about what motivates buyers in these industries and uses that knowledge to shape client websites and editorial calendars.
Your CompetitorsYou probably see the owner of a rival organization at trade shows, association meetings, and perhaps even socially. You can garner a great deal of information through a simple, friendly conversation. People like to talk about themselves and share their success stories and concerns with business associates. Assign someone to check the competitions' Web sites regularly for pertinent changes and news. (And take a good look at your own: Do you say anything there that you'd just as soon not have your competitors see?)  
This is one of the major reasons why organisation in a start-up is essential. You will spend less time procrastinating and more time achieving goals and completing client tasks. Spend time every day organising your digital folders and your physical folders before you start working. This will ensure that there are no distractions throughout the day and you can complete all the important tasks on time and within budget.
The same goes for PPC advertising. Potential customers who are targeted with your PPC ads don’t care about your need to fill your pipeline or your salespeople’s need to meet their quota—the truth is they only care about what’s in it for themselves. Cater to this by crafting your ad copy in the second person, keeping the importance on the consumer and not on your company.
A quality ad account in 2018, according to Google, is an “autopiloted” account; the more options that are delegated to Google Ads, the better. However, even if Google is now able to decide on its own which banner size will fit best on a particular website, it is still your responsibility to provide catchy text, relevant images, and the right keywords.

Conduct a business download meeting. I meet with key stakeholders to learn everything I can about the business and the industry they compete in. Is the business itself growing or struggling? What about the industry as a whole? I use this time to learn what has worked and not worked from a PPC perspective and to determine if PPC performance goals are realistic and achievable (or if they exist at all).
Keyword competitiveness lets you know which keywords often show up on other websites. This usually means that your keyword strategy concept exists on other sites. For B2B marketing and SEO, keyword competitiveness is a little different. Since keywords and themes are more specific, there’s a lower chance of other sites using the same keywords. Of course, remember that most B2B companies write about similar issues and concepts.
That said, if you’ve never had to come up with a keyword strategy before, it might seem a bit daunting to generate a list of terms that will drive qualified search traffic to your website. Not to worry. Creating an effective keyword strategy—figuring out which terms you should create content for—isn’t hard. It just involves a little bit of reverse engineering and some research.
What’s the difference between your brand and your keywords? Are you using both effectively? Your brand is one of your most important keywords, but it shouldn’t be your only keyword, nor should you have lots of keywords but no brand. There should be a keyword strategy behind the keywords you pick. This post highlights the why of that and explains the basis of the how, then points you to several useful posts for the how.
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.
Then, a few months ago, I was driving around town and the beloved Comedy Attic had a brand new LED Sign. A beautiful high-resolution digital sign manufactured by my client. I had a fangirl moment in my car upon recognizing my client’s name in small letters underneath the sign. Next call I had, I mentioned this moment to the client. I asked when that lead came in. The client looked up The Comedy Attic and divulged the sign was purchased in March 2018. The purchase came from a lead that came into the funnel in July 2016.
Use voice search to your advantage by skewing your ad strategy toward answering questions customers need to know (intent), rather than just including keywords. Search engine AI for voice and mobile search is getting more sophisticated and better at serving results that meet the user’s intent, therefore PPC best practices will be continually refined.
For example, if a user from a high income neighborhood visits a car dealer’s site or clicks on a paid search display ad, that consumer may be directed to a landing page displaying a luxury vehicle, while consumers located in a lower income area may be targeted with a deal on an economy vehicle. The higher income consumers may be more interested in deals such as cash off or lower interest rates whereas those in lower income brackets may be more receptive to lower monthly payments.
Sales BrochuresSales brochures provide a wealth of product information. You can learn how your competitor is positioning their product and company and what features and benefits they're using to sell their product. Try to obtain all new sales brochures and literature your competitor publishes. Significant changes in the content will indicate that new strategies are being employed.  
However, if “cheap renters insurance” doesn’t match your brand, then don’t use a phrase with higher search volume just to get more traffic. You want to attract more qualified leads not just more traffic. If your page more accurately matches a searcher’s intent, lower search volume could actually provide a higher number of qualified leads even though it may not generate as much overall traffic. In other words, if a keyword or search term doesn’t match your brand standards, don’t optimize for it, no matter how much traffic it could potentially drive.

You should always track and monitor the effectiveness of your PPC campaign. You should know what things are working for you in a better way. If you are publishing your ads on the Google search platform using the Google Adwords tool, use Google Analytics to get better insights into searcher’s behavior. You should measure the bounce rate of your website. Bounce rate will tell you how many searchers visited your site but did not perform any action. You should also track CTR and conversion rate of your campaign. This will help you to optimize your PPC campaign and your landing page.
Once you’ve established some broad categories you should now look at direct competitors to your product. These include any company that sells a very similar or identical product or service in the same footprint as your organisation. For example; if your company sells Cable TV service, you would only list your competitors as those offering a similar service that your customers can also purchase. If the competitor’s service does not extend to your company’s geographical footprint, there may be no point including this competitor in your analysis. Their product offering however may be interesting and you may include it in a Product Comparison paper.
A competitive analysis won’t help you with pressing business decisions, such as what product feature to build next. (Never copy your competitors for the sake of it; they could be 100% winging it!) Moreover, if you’re the industry leader, the value of analyzing competitors is limited because you’re the one leading the pack through uncharted territory.

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.
To give you an extra boost, we’re also giving away two landing-page templates designed especially for PPC campaigns. These templates have powered hundreds of successful PPC campaigns, and with a little customization (some coding’s required if you’re not a LeadPages® customer), they can do the same for you. Click below to download them now, and we’ll talk about why they work and how to use them in a bit:
In online environments, ad servers look at a user’s IP address to figure out their ‎location.  Behind the scenes, the ad server maintains a large database that has ‎every IP address already mapped to its country, state, and postal code.  So, when a ‎request comes in, the ad server strips the IP address from the header of the ‎request, queries this table, finds the necessary location data, and then picks an ad ‎that matches that criteria.  ‎
Do they have separate marketing messages for different segments? Sometimes, you might see a stark difference between how your competitor markets their business for one type of customer versus how they present themselves to another type of customer. For example, if you're trying to sell services as a math tutor to high school students who are struggling to pass their math subjects, you'll be making a completely different pitch than you would to those students who need additional help with their SAT math so that they could get into prestigious universities. Your message to the struggling students might be closer to "I'll help you finally pass your math tests!" While your message to the other market will be similar to "I'll help you get into the school of your dreams!" Also, be sure to note if your competitor does something similar with their own customer segments. 
You can set a bid adjustment based on a user’s previous behavior on your site, so if they’ve bought one item, you could increase your bids in your other campaign to promote related accessories or products that they are most likely to be interested when they search on Google. This can also work even if they haven’t made a purchase, but simply browsed for your products.
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).
Comparative user testing to the rescue: you ask the participants to evaluate your website as well as the websites of your top 2 competitors. To avoid biased feedback, try not to disclose which company you are with, and mix up the order in which you show the websites to the participants. Not to overwhelm the participants, limit the number of websites to 3 per person.
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.
Online pay-per-click (PPC) advertising allows almost anyone to create ads. Each time your ad pops up online and someone clicks on it, you pay a small fee. PPC advertising appears in search engines like Google or Bing and on social media platforms such as Facebook, Twitter, LinkedIn, and Pinterest. The point of PPC is to get fresh visitors to discover your business online.
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.
It simplified the ways that an organization can compete into four: cost leadership, differentiation, the focus on cost, and the focus on differentiation. Since the inception of Five Forces there has been a lot of discussion about how helpful the categories are, but it seems to be part of everyone’s strategy and competitive toolbox, especially for MBAs.

Geo-targeting in the most traditional sense uses IP addresses to figure out where users are. Every internet-connected device has a unique IP. It’s like an address for your computer, tablet, phone, or wearable. The first three digits provide a country code. The digits after that indicate specific areas within a country, down to state, city, and postal code. To learn more about the tech behind geo-targeting, geoedge.com is a good source.

Successful online advertising requires ongoing work and optimisation to improve performance and results. Maximising output and reducing input is critical. You must clearly outline the business objectives, goals, and audiences for each campaign. This chapter outlines our PPC model which considers objectives, goals, audience, and targeting to ensure your PPC is based on a solid strategy with clear measures in place to analyse and improve as you go.
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.
From my experience, you don’t need complex algorithms to save money with paid search. You don’t need a crazy PPC management tool to trim down costs for campaigns. You need only employ one of 3 core paid search strategies in order to succeed in your PPC campaigns: 1) Maximize your budget, 2) Improve Branding by showing up in a top position and 3) Maximize your profit potential.
You can also find articles written about companies in local newspapers or on a Nexis file. Online databases are available from soures such as the U.S. Securities and Exchange Commission and Standard & Poor’s and news sources such as PR Newswire, and as we'll explain in this article, you can use search engines to find information on individual companies.
There are a variety of benefits to incorporating ad customizers into your PPC ads, such as the ability to create a sense of urgency in your target audience and drive clicks. But the biggest boost that ad customizers can provide is that they improve the relevance of your ads, thus improving your quality score. You can also adjust such ad elements as color, size, inventory and stock details, pricing, and seasonal sales to capture the eyes of potential customers.
By keeping your company organised, you will be better able to keep your employees on track, making it easier for them to finish tasks on time. This is because they will not be spending time searching for important documents that have been filed in the wrong folder (or not even filed at all) but rather focusing on completing tasks and building your profit as a company.
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.
Ad extension provides extra benefits for your PPC advertising. Use these extensions to enhance your ad and to show additional information with your ad, like an address, phone number, store rating, or additional webpage links. Ad extension ensures high CTR because they make your ad more relevant and prominent. It also improve your quality score. Google says “If two competing ads have the same bid and quality, then the ad with the more relevant extensions will most likely appear in a higher position than the other.”
For many of you reading this post, you may wonder why these other strategies exist at all. Shouldn’t people only be paying for clicks that directly impact their ability to generate revenue and ultimately profit? I struggled with this concept early in my career, but ultimately came to the conclusion that not every single marketing activity can be direct response.
Conduct a thorough account audit and gap analysis. Audits are time-consuming and tedious, but they’re absolutely necessary. I use the account audit to understand underlying drivers of performance and to determine whether work being done in the account is in alignment with business goals. Uncovering the strengths, weaknesses and opportunities provides critical information I need to form my guiding principle for account management.
Use the Keyword Planner to flag any terms on your list that have way too little (or way too much) search volume, and don't help you maintain a healthy mix like we talked about above. But before you delete anything, check out their trend history and projections in Google Trends. You can see whether, say, some low-volume terms might actually be something you should invest in now -- and reap the benefits for later.

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.

If your competitors are using a social network that you may not be on, it's worth learning more about how that platform may be able to help your business, too. To determine if a new social media platform is worth your time, check your competitor's engagement rates on those sites. First, visit the following sites to see if your competition has an account on these platforms:
As you consider new ideas for your next project or business, give extra credence to the things you believe to be true that others doubt. The most exciting products are created by people with tons of conviction for something that strikes most others as odd. I’ve heard from Joe Gebbia, co-founder of Airbnb, that when he and his co-founder Brian Chesky pitched the idea of having strangers sleeping in your home when you weren’t there, many investors shifted uncomfortably in their seats.
After years of working with relatively inexpensive homes in rural areas, we’re looking to break into the competitive and high-flying Manhattan real estate market. Referrals and word of mouth have been powerful drivers of growth up to this point, but they won’t cut it anymore. We need to get in front of people who are trying to sell their homes in Manhattan, and we decide to run Facebook ads to do it.

The enterprise sales process is reserved for highly complex products sold at a high price. Because enterprise products provide so much value and prospects take longer to evaluate the product, companies must adopt a complex selling process and longer sales cycles. Selling to large enterprises with a high ASP means competing against rivals with high-touch sales models.
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:
When an ad mentions the target customer’s region or city, such as Chicago, this approach has proven to deliver a much better response rate than running a national campaign that doesn’t include a location. “It goes back to the messaging aspect,” Fritz explains. “Your geolocation ad targeting is much more effective. That’s because it connects more deeply with prospective customers than a generic advertisement. You are running a social advertisement that is very specific to someone in a particular place. This could be Cleveland, New York City, Miami, Dallas, Los Angeles, or whatever area you have targeted.”
4. Choose keywords based on more than just high search traffic. Depending on which strategy you’re using, branding or conversion, you should not fall into the trap of just looking at search volume when judging which keywords to use. Just because one keyword has a whole lot more searches than another doesn’t necessarily mean it will be a better performing search term. Take the time to analyze other factors that provide more granularity. Here is an example of other factors you may want to look at:
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:
Ego and assumptions led me to choose the wrong keywords for my own site. How did I spend three years optimizing my site and building links to finally crack the top three for six critical keywords, only to find out that I wasted all that time? However, in spite of targeting the wrong words, Seer grew the business. In this presentation, Will shows you the mistakes made and share with you the approaches that can help you build content that gets you thanked.
Twitter is also a great place to get guidance about what's popular as it relates to your search terms. Just type a word or phrase into the search bar and see what trending topics come up. You can also use social media monitoring tools like Hootsuite, which allows you to create a stream based on a particular phrase and monitor mentions of it, or TweetReach, which gives you a similar quick analysis. 
Use voice search to your advantage by skewing your ad strategy toward answering questions customers need to know (intent), rather than just including keywords. Search engine AI for voice and mobile search is getting more sophisticated and better at serving results that meet the user’s intent, therefore PPC best practices will be continually refined.
Annual ReportsIf your competitor is a publicly-held company, many of its reports to the U.S. Securities and Exchange Commission are available on the SEC-Edgar Web site. Annual reports provide financial information, including sales volume, revenue increases, and their total market share. 10-K reports provide still more detail, and are supplemented by the quarterly 10-Qs. 8-Ks show significant events such as acquisitions and board membership changes when they occur between 10-K and 10-Q filings. Annual reports from privately-held corporations are sometimes available through friends, relatives, and business acquaintances who own stock in a competitor's company.  
What’s the difference between your brand and your keywords? Are you using both effectively? Your brand is one of your most important keywords, but it shouldn’t be your only keyword, nor should you have lots of keywords but no brand. There should be a keyword strategy behind the keywords you pick. This post highlights the why of that and explains the basis of the how, then points you to several useful posts for the how.

There are various platforms available for PPC ads like Google, Yahoo, Bing and social media channels like Facebook. Choose wisely your platform and plan your ad campaign strategy, according to it. Google is the most effective and famous platform for PPC campaigns. Google Adwords is an advertising interface provided by Google, which is used to plan and publish Google ads. Similarly, Bing ads and Facebook ads provide all required interfaces for an effective PPC campaign.

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.

×