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.
This is a great list! I especially appreciate the sample set of pages you recommended - oftentimes we ask clients we're onboarding who they consider to be their competitors, but once we start digging into their sites we see they're not necessarily "search" competitors or the sites just aren't that similar to be regarded as such in the search engine's eyes. At least these pages can help weed out any sites that just aren't built out to be similar to a client or are way ahead, so you can get an accurate comparison!
It’s actually ideal to use just one keyword per ad group. This is known as a single keyword ad group (SKAG). Try using this strategy, even for large accounts, with 80 percent of keywords that get or you expect to get the most traffic. You should most definitely employ this strategy for keywords that are getting the dreaded “Rarely shown due to low quality score” warning.
It’s all about repeated exposure—while your previous site visitors browse other websites, your retargeting provider will show them ads for your services and products. Using retargeting, you can entice visitors back to your website and effectively convert these digital window shoppers into customers for your business. In fact, potential customers who are retargeted with display ads are 70 percent more likely to convert. Now, doesn’t that sound nice?
Say our real estate marketing business really starts to blow up. We make a few new hires and start to divide Manhattan up into regions, with each new employee responsible for a new section. Each one is responsible for marketing within their region. We can easily carve out an “excluded” area within any local awareness region to, for example, exclude a particular zip code that we’re not responsible for from our ad’s targeting. That lets us save money by not targeting customers that we don’t really want to be attracting:

Add in geolocation, and you get geotargeting, a technique that has proved highly beneficial to local small businesses, especially restaurants, retail shops, and service providers. While that’s great, what happens if you’re a large corporation running national campaigns? As a CMO, you can still use geotargeting to increase the return on your marketing investments.


In order to run a business smoothly, you need to do a lot of things. These things include doing a certain analysis. You forecast your profitability, decide what combination of resources to use, assign the work order to different employees and so on. The business does a SWOT analysis which is basically finding out the strengths and weaknesses of the company. It also manages to identify possible threats and opportunities the business might face due to external factors. Doing such things will help you to form a marketing strategy. With this strategy, you will look to run your business.

Geo-targeting (sometimes spelled geotargeting or geo targeting) involves detecting a user’s location, and serving them communications based on that location. Those communications might be ads or other content, like an email or geo-targeted push notification. Geo-targeted communications are delivered most commonly through text or push, and might also come when you open a certain app or social media site. The benefit of geo-targeting services are simple: enhanced personalization.
What is the main messaging of their marketing materials? What common customer problems or goals do they often refer to? Let’s say you’re a pet sitter going through a rival business’ brochure. There is a huge difference between a brochure emphasizing frequent real-time online updates, and another brochure emphasizing pet pampering and grooming. The group of clients who are attracted by frequent real-time online updates are often focused on the safety and welfare of their pets, while those looking for more pampering and grooming services are focused on comfort and appearance.
The benefit of clearly describing a strategy for your PPC campaign is that it can inform the creative, particularly when it comes to building PPC adverts with our various elements: header, ad copy, ad extensions – where does everything go? Great advertising is built on great creative, so spend as much time crafting solid messages as you do on the strategic elements of the campaign. This chapter looks at how you can craft the best ad creative to communicate your message.

Example 1: Say your business focuses on skin care. Your keywords might center around the idea: “how proper skin care can improve your health.” You would then begin looking for a keyword theme that sums up the idea of skin care relating to health. The takeaway message is that your business has a goal, and the right keywords will relay this goal to site visitors in a clear, concise way.
When I was working on my own startup, Complete Seating, we did this for OpenTable. I spent at least a night a week working as a host. What was most interesting was all of the other tools that they needed to get their job done: hardwired phone, discussions with waiters, discussions with the kitchen, POS access, and more. We saw some key differentiation with automating the communication through SMS and phone before a guest got to the restaurant. They were really powerful in showing how OpenTable was just a digitization of the maitre d book.

Beacons aren’t designed to know you’re you, where you were a moment ago, or where you’re going next. By and large, they’re just little stationary computers that react: when your device moves near the beacon itself, it triggers a ping, and your app—if you have an app with notifications enabled for the beacon’s particular location—goes to work communicating with you. When you move out of that beacon’s range, it’s basically a done deal.


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.
When you conduct your competitive analysis, it's worth analyzing the sales models of your competitors. In his article Three SaaS Sales Models, Joel York describes the three most common SaaS sales models based on the relationship between price and product complexity. Companies with low priced and low-complexity products must focus on developing a self-service option so they can maintain a healthy relationship between customer acquisition cost (CAC) and customer lifetime value (CLV). Slack, Trello, Dropbox, GitHub are all low-price, low-complexity products.

Page Content: The days of minimum keyword density are gone. The number of times you use a keyword is really determined by the length of your content. If you are creating unique, quality content your will naturally use your keyword throughout your page. Sprinkle latent semantic keywords throughout your content to strengthen the page’s topical relevance.

Strategy is more than a bundle of cultivated tactics. When we onboard a new client, we have a whole arsenal of tools to use and reports to run that help us understand the account better. It is easy for us to pat ourselves on the back and say “this is a good strategy for learning the account!” Pardon my language when I say: That ain’t no heckin’ strategy.
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.
Stadiums, airports, universities, and malls are examples of specific venues that can be targeted in order to reach specific interest groups. Stadiums provide a great opportunity to focus on specific short engagement events with an audience defined by that event. They often host fans from two specific cities or schools or fans of a specific music genre that is heavy in one demographic. A band like One Direction, for example, is likely to attract school-age female fans.
SpyFu displays side-by-side data on your competitors' paid and organic search results, so you can easily see where it's more cost-effective to bid on a particular keyword as opposed to trying to rank for  it organically. That way you can use your time more efficiently by writing content around those keywords that drive a lot of traffic but are more expensive to bid on.
Typically, VCs make just one bet in a product category to avoid cannibalizing their investments. You are either an Uber or Lyft investor. This is a commonly accepted view in the Valley. If you see a VC’s name missing from the category you’re competing in, they might be a good candidate to approach for fundraising. They missed the chance to invest in your competitor, but now they have the opportunity to work with you.
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.
You cannot expect your employees to stick to their schedules and stay organised if the person at the top doesn’t do the same. As the leader of your start-up, you need to set an example for your staff, which means that you have to be the most organised person in the company. While it is important to ensure your employees follow suit, try not to be too overbearing about how they choose to organise their days.
Geo-Targeting content is simple and beneficial to most websites, advertisers and publishers, as well anyone using PPC campaigns or SEO. Not only does it enable you to match the most relevant content to your visitor, Geo Targeting also serves as an excellent basis for experimenting with traffic to optimize your funnels. Some ideas were presented here that may be tested, but the options are virtually limitless.
“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.”

Another way to define a perimeter is not by distance, but by time. A company named iGeolise developed a platform they call TravelTime, an API that allows mobile apps and sites to search by time rather than distance. This could be useful for a condo unit near downtown looking to attract workers with very long commutes, or a restaurant targeting hotel patrons within a 10-minute walking distance.
Customer preference of products is only part of the analysis. There are internal operational factors which can provide a competitive edge as well. Your competitors' products may not have the high quality of yours, but they might offer free delivery; or their employees might be extremely motivated and committed to gaining market share. You need to learn how they are doing on the inside. Some factors to consider:
Truly awesome stuff Zee! For those involved in doing competitive analysis for Local SEO, I would also add GMB Completion/Optimization, and NAP Profile Quantitiy/Quality (which can be checked via MozLocal and Majestic SEO). The conversion part of your analysis that you laid out is especially important in my opinion. Thank you for writing and sharing your insight!
Make a list of product features and benefits in order of importance, and prepare a table to show whether or not each of your competitors fulfill them.For example, Medium-sized companies that purchase copier machines may look for the following product benefits and features when making buying decisions: Competing Company: A B C D Features: 1. Auto paper feed 2. Auto enlarge or reduce 3. Collates 4. Staples 5. 24 Hour Repair Service 6. Warranty Benefits: 1. Easy to operate 2. Saves money 3. Good print quality 4. Dependable 5. Fast Price: $ Other factors you may want to evaluate include:
Whether you’ve heard a little about PPC marketing and are curious to learn more, or you already know that you want to use PPC to market your business, but aren’t sure where to start, you’ve come to the right place! This is the first lesson in PPC University, a set of three guided courses that will teach you everything you need to know about PPC and how to make it work for you.
The Java program is fairly intuitive, with easy-to-navigate tabs. Additionally, you can export any or all of the data into Excel for further analysis. So say you're using Optify, Moz, or RavenSEO to monitor your links or rankings for specific keywords -- you could simply create a .csv file from your spreadsheet, make a few adjustments for the proper formatting, and upload it to those tools.
×