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. Sometimes, a stakeholder identifies the competition in the PPC space incorrectly. Competitive analysis helps me learn who the competition actually is and what they are doing to be successful in terms of bidding, keyword targeting and creative messaging. The competitive analysis helps me determine how aggressive I need to be in my account management policies in order to successfully compete in the marketplace.


"Since consumers know what they are looking for, you can optimize your content around the core needs and problems your target audience experiences. It is your job to build an SEO strategy by knowing what your customers are looking for. This will allow you to create relevant content that your customers want to read, and as a result, your content will rank higher in Google."

Other EmployeesYour employees working in other areas of the company also become exposed to competitive information. They interact with others in their industry area and often learn what your rival is doing or hear gossip and rumors. Make sure your entire staff knows they should share any information concerning the competition immediately. Former employees of a competitor can provide you with insight on: your competitor's new products, marketing strategies, how-to improve productivity and employ other resources more effectively, and what your competitor's general working environment is like.  

Tertiary Competition: This category includes businesses that are tangentially related to yours, and really comes in handy when you’re looking to expand your product catalog. These could be related products and services that are trending, as well as businesses that may be beneficial to partner with further down the line. For instance, if you sell jewelry, a tertiary competitor may sell gems and stones.


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.
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.
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.
The strategic rationale of competitor profiling is simple. Superior knowledge of rivals offers a legitimate source of competitive advantage[7]. The raw material of competitive advantage consists of offering superior customer value in the firm’s chosen market. The definitive characteristic of customer value is the adjective, superior. Customer value is defined relative to rival offerings making competitor knowledge an intrinsic component of corporate strategy. Profiling facilitates this strategic objective in three important ways.[8] First, profiling can reveal strategic weaknesses in rivals that the firm may exploit. Second, the proactive stance of competitor profiling will allow the firm to anticipate the strategic response of their rivals to the firm’s planned strategies, the strategies of other competing firms, and changes in the environment. Third, this proactive knowledge will give the firms strategic agility. Offensive strategy can be implemented more quickly in order to exploit opportunities and capitalize on strengths. Similarly, defensive strategy can be employed more deftly in order to counter the threat of rival firms from exploiting the firm’s own weaknesses.[5]

It works like this – if there is an IP address the company wants to locate, they ping ‎it from a few of their servers, for which they already know the location.  A ping is ‎just a way to test if a computer can connect, and how long it takes to do so, but ‎doesn’t transmit any meaningful data.  Then, by looking at the time it takes each ‎server to connect, it can establish a shared point or origin, and thereby physically ‎locate the user.  It uses the public IP locations to validate their approach and check ‎for anomalies in network latency which would lead to bad data.  ‎


When a competitor is identified, have your sales team dive deeper by asking why they are considering switching to your product. If you've already lost the deal, be sure to follow up the with prospect to determine why you lost to your competitor. What services or features attracted the prospect? Was it about price? What's the prospect's impression of your sales process? If they've already made the switch, find out why they made this decision.
Putting each competitor in the right list is a very important part of competitive analysis because the features and functionality in your competitors’ apps are based on exactly what users of those apps want. Let’s assume you put one indirect competitor, XYZ, under the “direct competitors” list and start doing your analysis. While doing the research, you might find some impressive feature in XYZ’s app and decide to add a similar feature in your own app; then, later it turns out that the feature you added is not useful for the users you are targeting. You might end up wasting a lot of energy, time and money building something that is not at all useful. So, be careful when sorting your competitors.
All sorts of companies in all sorts of industries can make use of geo-targeting.  By refining the ad copy to include the city name and a reference to the current weather – for example, including the words “start sleeping cooler” in an ad during periods of hot weather – Purple Mattress, an ecommerce bedding brand has been able to generate higher click-through rates by online shoppers. In an effort to update its aging "Let's Go Places" campaign,  Toyota incorporated city-specific information into each of its Google ads, encouraging consumers to go to places and attractions near them.  Whole Foods targeted ads to the smartphones of consumers visiting nearby supermarkets, encouraging them to come to a nearby Whole Foods nearby exchange for better deals.
Avoid industry research. Industry analysts aren’t good at predicting disruptive companies and cutting-edge trends because such changes occur at the bottom of the market, which is generally not on their radar. Research giants like Forrester and Gartner provide industry consensus after major shifts have already occurred. Plus, they derive their research by analyzing large organizations, so startups won’t find what they’re looking for here.
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.
HubSpot also has a campaign tool that allows you to associate keyword phrases, related blog posts, emails and landing pages with a particular campaign so you can get a better idea of the overall performance. If a particular set of keywords doesn't seem to be bringing in new site visits or converting leads to customers, it might be time to search for alternatives.  
Here’s where artifacts like user personas may come in handy. A persona should clearly outline what potential customers want and how they plan to get it. It’s your job to map their needs to content you create, using the list of keywords as a guideline for topics. That said, since they’re based on assumptions and not real user input, personas shouldn’t be a replacement for user research and testing. If your buying cycle is long and complicated, a customer journey mapping exercise could also help you identify wants and needs during individual steps of the cycle. Software service Autopilot HQ has a great post about how to map content to customer needs throughout their journey. 
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.

Now, evaluate your competition's product or service. How does your product compare to your closest competitor's product? What features and benefits are unique to your product? To theirs? The more unique features and benefits your product has, the stronger your market position will be. For example, if you produce and market an office copying machine that staples collated copies together and your closest competitor doesn't have this feature, you have an advantage. You can then sell the same market segment the benefit of added convenience and time saved. However, your competitor may have developed a feature that you don't have on your copier that gives him/her a selling advantage. 

Svitlana Graves Svitlana Graves is a digital marketer with a focus on conversion optimization. She enjoys combining in-depth customer research with data to conduct smart experiments. At the moment Svitlana is taking clients’ revenues to new levels as part of CRO Team at 3Q Digital. On a personal note, Svitlana loves Latin Dance and foreign languages. She speaks 5 and is learning her 6th.
Best used to reach users who: live or move about in a certain area, for whom you have other data like preferences or demographic info Best used to find users who: are nearby your store, venue, or service; users who are in your parking lot, or entering a mall, for example  Best used to reach users who: are in a certain aisle of your store; who are on a certain bus or train; who are moving through a space like a museum
This is another great way to position yourself as a “go to” for information within a community. Surround your campaigns or newsletters around what’s going on in a specific area. If a town that you have a lot of subscribers from holds an antique fair once a year, use it in your marketing campaign. In your newsletter for that area, include tips and tricks on how to bargain prices, articles about the best booths from the year before and sales surrounding your own products that would speak to that target audience.
In particular, strategy is how the team aligns so that decisions made at any level are likely to be better for the longer term goals of the organization. If you don’t have that alignment, you will be constantly struggling to move the organization ahead, together. A well-executed competitive analysis provides the framing for how your group is the best one to take on the challenges and opportunities ahead.
CTAs match user intent inferred from content. Here is where you’ll evaluate whether the CTAs match the user intent from the content as well as the CTA language. For instance, if a CTA prompts a user to click “for more information,” and takes them to a subscription page, the visitor will most likely be confused or irritated (and, in reality, will probably leave the site).
Has anyone tried to use Changetower (https://changetower.com) to monitor for new competitive keyword changes? I can seem to figure out a way to monitor for specific keywords that my clients wants to get alerted for, just general changes or changes in a certain area of the page… If anyone knows anything about Changetower or another site to recommend for monitoring keywords? Thanks!

Furthermore, 70% of consumers are willing to share their location information if they believe they are getting something of value in return like coupons or loyalty points, according to LSA’s Local Mobile Search Study.  This dynamically moving consumer base is only going to be more receptive to search results and ads that are specific to their location.
For example, it’s important to look at the response based on urban, suburban or rural locations. Someone living in northern Indiana may consider driving 25 miles to your store to be no big deal. Most customers or prospects could make the drive in less than half an hour and, therefore, they will visit your store. However, if the prospects live in the River North neighborhood of Chicago, they aren’t going to want to go to your store in Wrigleyville because that’s going to take 50 minutes.
Using the same keyword phrase over and over within a web page or blog post can actually hurt your ranking score in Google, which can perceive it as spammy. That wasn't your intention, but maybe you just couldn't think of a better word to use in its place. The Latent Semantic Indexing (LSI) Keyword Generator is like a thesaurus for SEO-minded content marketers. It offers keyword suggestions that are semantically linked to your main keyword, meaning they would naturally come up in conversation. Incorporating these keywords into your post allows you to add variety while still retaining SEO power. 
How do current customers rate the following features of your business compared to your competition.Rate the following as: fair, good or excellent. Our Company / Competition ___________ /__________ Price ___________ /__________ Quality ___________ /__________ Durability ___________ /__________ Image/style ___________ /__________ Value ___________ /__________ Name Recognition ___________ /__________ Customer Service ___________ /__________ Customer Relations ___________ /__________ Location ___________ /__________ Convenience ___________ /__________ Other
Tertiary Competition: This category includes businesses that are tangentially related to yours, and really comes in handy when you’re looking to expand your product catalog. These could be related products and services that are trending, as well as businesses that may be beneficial to partner with further down the line. For instance, if you sell jewelry, a tertiary competitor may sell gems and stones.
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.
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.
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.

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).
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.
We constantly sharpen our PPC skills -  by speaking at national search marketing conferences, writing helpful "how-to" blogs for other search marketers,  and consuming daily blogs and news to stay abreast of everthing that this crazy industry throws at us! It's unlikely that your in-house employee(s) can achieve the level of focus and commitment of PPC-Strategies.
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.
×