Remember that you are the jockey, the driver and the visionary. The best horse cannot win the race without the jockey – it is important to believe in your business and live by example through the core values of your business. An entrepreneur should show commitment, determination, leadership, tolerance of risk, creativity, self-reliance and the ability to adapt to excel.
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.
The effectiveness of geo-targeting is only going to further improve as mobile use grows and location data becomes more accurate and available. The Local Search Association (LSA) just released data that found that, for the first time, mobile devices surpassed PC use in search for local businesses and services. As I reported last month, the majority of searches (52%) for local information on mobile devices occur either in the car or away from home or work.
Region-specific marketing is currently utilized in a variety of marketing campaigns. A fairly basic marketing concept can be used, but it is presented to a location or market that has shown a demand for that specific product or service. This can be a certain State, City, neighborhood or even a specific building. Programs like Google Adwords lets you target these specific locations and tailor your marketing. On a more broad scale, you can target a certain demographic based on their language.
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.”
Both geo-fencing and geo-targeting can be done on mobile, tablet, computer, or even gaming devices with internet access.  When it comes to deciding which is best for your marketing, think of who your target customer is. If you are interested in advertising to a population of all ages and all interests, geo-fencing is perfect for you. If you are only interested in hitting only a specific consumer demographic that is more niche, then you should be doing geo-targeting.

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!
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.
You have now reached the final step of creating a keyword strategy: keyword research. Quality keyword research is as essential as doing market research for marketing strategy. By the same token, forming a keyword strategy for B2B marketing and SEO needs heavy research as well. When doing keyword research, there are three important factors to remember:
AdWords may suggest keywords based on your website content. Feel free to use them for inspiration, but also consider the many different ways you and your customers talk about your business and be sure those turns of phrase are reflected in your keywords. Start by creating a list of about 10 “head terms”—the concepts from which everything else you do follows.
Take advantage of location extensions and call extensions to make it as easy as possible for local prospects to contact and reach you. When location extensions are enabled for your search ads, prospects in your specified, targeted areas will see your street address. A call extension, alternatively, provides either your phone number or a direct link to a phone line. Landing pages are often referred to as the leakiest part of the marketing funnel, and extensions such as these help cut out the middle ground and prevent the lead leakage.
Funny thing is we’re not seeing users click on the extension itself very often – slightly more often than we’d see for sitelinks, but not by much – maybe 15 percent of total clicks, albeit not necessarily on the extension itself. It may be the way that we’ve set it up (we say chat with a live expert rather than text us), so that may have skewed the behavior.
The assumptions that a competitor's managers hold about their firm and their industry help to define the moves that they will consider. For example, if in the past the industry introduced a new type of product that failed, the industry executives may assume that there is no market for the product. Such assumptions are not always accurate and if incorrect may present opportunities. For example, new entrants may have the opportunity to introduce a product similar to a previously unsuccessful one without retaliation because incumbant firms may not take their threat seriously. Honda was able to enter the U.S. motorcycle market with a small motorbike because U.S. manufacturers had assumed that there was no market for small bikes based on their past experience.
Research: These searchers are further down the funnel than informational searchers. They’ve already decided that they want to buy a product, but they haven’t quite decided which one is best. They’re looking for more information, so product keywords usually include words such as "review", “top 10”, “comparison”. And while it may look like spam to you, a word like “cheap” can actually help turn researchers into conversions.
In internet marketing and geomarketing, the delivery of different content based on the geographical geolocation and other personal information is automated.[3] A good example is the Ace Hardware website at www.acehardware.com. The company utilizes geolocation software to power the “My Local Ace” section of its website. Based on a site visitor’s location, the website's online locator service can show the visitor how many stores are in their area, as well as a city-level locator map to help the customer find the store closest to their address.[4]
Once you know your target audience, you can easily aim your advertisements towards areas where your target audience would be. Bonobos, an online male clothing store, did a great job of this when they were launching their Guide Shops pop-ups. The “store” would serve purely as a try on and styling area. Once you ordered clothes, they’d be sent to your house directly.
Now, to figure out state and postal code involves a more complex process. At the ‎core though, the geolocation services build up a network of servers from which ‎they can send out pings, or connection requests, and known physical locations of ‎public entities like universities and government office IPs.  Eventually, with enough ‎data, the geolocation company has the capability to triangulate any IP on the web.   ‎

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: When a visitor sticks around on your site for a minute or less, you can consider their stay to be negligible. When a visit exceeds that amount of time, the visitor has more potential for becoming a client and an increased chance of converting on your calls-to-action. If a visitor spends a considerable amount of time on your website, they are likely to come back or to take action on conversion areas you have included in your site (call-to-actions, downloads, contact forms, etc.).
So, fellow marketers, the secret is out—now you know that the key to really driving your conversion rate isn’t in minor copy or bidding adjustments. The true PPC CRO best practices require you to use negative keywords and to target keywords that your bottom-of-the-funnel prospects are searching for—including those that are pricing and service-oriented. You want to use high-converting ad formats, such as Google Shopping Campaigns and video ads, to capture the attention of your audience and engage them. Your landing pages should be designed well, easily browsable, and have fast loading times. It’s also important to personalize your ads so that your potential customers feel like you’re speaking directly to them, which also helps humanize your brand. Finally, use retargeting to remarket your products and services to previously interested visitors to your website, enticing them back and convert. 
Not every keyword is worth ranking for. This may seem obvious, but it’s an important lesson for search marketers to learn. Often times we can get caught falling down the rabbit hole or chasing the long tail dragon to boost our rankings without thinking of the time and resources it takes to rank for these terms. Especially for highly competitive, high-volume keywords – it simply isn’t worth the time and effort it might take to get onto page one.
Next, indicate with a check mark which of your competitors has which features. Features are fairly straightforward, either a product has a feature or it doesn't. Benefits, on the other hand, are not as simple and should only be recorded based on customer feedback. For example, company B may claim in their company literature that their copier is fast, but a user may feel otherwise. Or, company B may indeed have a copier that by industry standards is fast, but you may have a copier that's even faster. 
Your competitor analysis framework should give your stakeholders an overview of how the playing field looks. A side-by-side comparison with top competitors helps teams strategize better, plan business growth and provide a clearer vision for the organization. When creating a competitive analysis, you should first consider defining the criteria for the comparison. Common high-level pieces are company information, description, products or services, strengths and weaknesses and market-fit.
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.)  
That would work but I would prefer to keep the data consistent and use Majestic or Ahrefs instead in that case. The template formulas can be adjusted to work with either tool. Sometimes, I will combine the data from all 3 tools to increase the amount of backlinks in the analysis but that takes a little bit more work and formatting to get it to work properly.
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.

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.  


I include specific, real world examples of every type of content in the wild as well as showing you how I design keyword architecture on my sites. I even provide a general model and walk you through exactly how to make decisions on what levels of architecture should get a dedicated URL versus what content should live on parent pages or use JSON/AJAX to not generate new URL's but still provide an ideal user experience.
Are they targeting low, middle, or high income customers? Look at their pricing information, including how they phrase it. If they use words like discounts, sale, affordable, or cheap, then they aren’t targeting the high income crowd. Also look at the marketing materials themselves, whether it’s a brochure or online banner. Are they attention-grabbing or elegant?
This is the most basic way to start your keyword research—so basic, in fact, that it's easy to overlook. Let's say you're  manufacturing solar panels and you want to target businesses that qualify for alternative energy tax credits. Start with a Google search just like your customers would.  You can see which phrases pop up first when you type in "alternative energy tax credits." This should give you a good indication of the most popular searches.

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.
Nick's Keyword Strategy Implementation Guide is a MUST read. All too often you will see an eBook make wild promises about how it can teach you XYZ. When you finally get it the book is filled with fluff that you have seen on a thousand other sites. What set's Nick's guide apart is the STRATEGY. You cannot hope to use keyword effectively on your site in the current state of the internet without a strategy. Nick has put a ton of information on a few pages, folks this book is dense. If you are in B2B, B2C, SaaS, or eCommerce you can benefit from the strategies outlined in this book.
Another method is to track your competitors’ links. Content marketing is often done in unison with link building. Your competitors most likely create content on blogging sites. Within the articles they submit, there are external backlinks that point back to their own websites. Those links can be followed like a trail of breadcrumbs to track what they’ve been up to. Moz and Majestic are tools that are great for doing this. Here’s a look at what Moz found when I looked up Easel.ly, an infographics company.
Unfortunately, I can’t answer all of these questions for you. But I will offer up one solution, and that’s the valuable question of where to begin. Segmenting out an audience is often one of the most important and daunting tasks for a marketer. But the work is worth it. Segmenting visitors into audiences is going to make conversion marketing campaigns more relevant and effective. An easier way to segment is by using something called geo-targeting.
You can use multiple different exclusion zones if you have an extremely particular region that you’re looking to target. The only caveat here is that you have to make sure you’re not being too narrow with your behavioral and demographic targeting. When you focus on too small a region, the size of your audience can get so small that it becomes practically impossible for Facebook to actually deliver your advertisements.
You have now reached the final step of creating a keyword strategy: keyword research. Quality keyword research is as essential as doing market research for marketing strategy. By the same token, forming a keyword strategy for B2B marketing and SEO needs heavy research as well. When doing keyword research, there are three important factors to remember:

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.

Using negative keywords in PPC campaigns is an often overlooked but highly effective strategy. These are keywords that you add to your campaign that you don’t want to target. Adding negative keywords will let Google know that it should not show your campaigns in searches that include these words. This is a crucial step in order to make sure that you don’t waste money by displaying your ad for irrelevant searches.
Increase Clicks: If you have a niche site that has high quality scores and impression shares, but not enough volume to spend your budget, you will want to increase the traffic sent to your site while maintaining control over click costs. This can be done by increasing bids, expanding your keyword list, improving click through rates and refining ad copy. All of these items can be adjusted/improved upon to help reach your budgeted spend.

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.  
Another method is to track your competitors’ links. Content marketing is often done in unison with link building. Your competitors most likely create content on blogging sites. Within the articles they submit, there are external backlinks that point back to their own websites. Those links can be followed like a trail of breadcrumbs to track what they’ve been up to. Moz and Majestic are tools that are great for doing this. Here’s a look at what Moz found when I looked up Easel.ly, an infographics company.

You’ll often find your hottest leads among people who have already encountered your business once. Depending on your industry, it may be unlikely for people to purchase your product the first time they visit. If you’re an e-commerce operation selling lower-ticket items, you may be able to send people directly to a sales page with excellent results. But if you’re like the dishwasher store we invented above, visiting your PPC landing page may be one step in a larger research process for your customers.
In more sophisticated use cases, geotargeting doesn’t have to be solely based on a consumer’s real-time location. Locations or businesses a customer has visited recently can be a great predictor of interests and intent, so adding targeting based on historical location as well can be key to delivering a captivating, relevant message. Denny’s had great success with this tactic in a campaign with xAd, detailed below.
Competitive analysis is an exercise of comparing your business, product, and service to companies and finding similarities and differences. The most critical part of kicking off a competitive analysis is choosing the right competitors to analyze. Otherwise, you will spend tons of time on competitive research with very limited insight to show for it. In other words, the competitors you select determines how you will perceive your company and the final analysis.
Lastly, if you have the opportunity, maintain the competitor review and analysis every 6 months. It provides you with an external perspective. Competitive analysis needs to be integrated with other product management and marketing activities. Overly concentrating on what competitors are doing can distract you from remaining focused on your customers.
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.

Region-specific marketing is currently utilized in a variety of marketing campaigns. A fairly basic marketing concept can be used, but it is presented to a location or market that has shown a demand for that specific product or service. This can be a certain State, City, neighborhood or even a specific building. Programs like Google Adwords lets you target these specific locations and tailor your marketing. On a more broad scale, you can target a certain demographic based on their language.


For example, say you have a clinic in Des Moines, Iowa. Someone looking at your social media advertising in California isn’t likely to come to your clinic. A geotargeted campaign would help you find social media users that need your clinic and live in your area. And if you have multiple locations, you can run geotargeted social media ads in each area where you want to increase your customer base.
Starting small will also help you devise a repeatable process that can then be applied across a wider range of search terms as your list grows over time. If you really want to go pro, keyword management tools like Moz Keyword Explorer or SEM Rush’s Keyword Magic Tool can help you streamline this entire process and will allow you to create lists that include hundreds of keywords. 
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.

A company’s slogan, tagline, mission statement and unique value proposition — all of these are important when determining how you stack up against your competitors. What is the company’s key positioning and how does it compare with other companies in this space? How do they describe themselves? This section is your opportunity to include what you feel is valuable descriptive information. 
Because someone who is looking for something that specific is probably a much more qualified searcher for your product or service (presuming you're in the blogging space) than someone looking for something really generic. And because long-tail keywords tend to be more specific, it's usually easier to tell what people who search for those keywords are really looking for. Someone searching for the head term "blogging," on the other hand, could be searching it for a whole host of reasons unrelated to your business.
In this article, I will introduce the subject of competitive analysis, which is basically a method to determine how well your competitors are performing. My aim is to introduce the subject to those of you who are new to the concept. It should be useful if you are new to product design, UX, interaction or digital design, or if you have experience in these fields but have not performed a competitive analysis before.
Evaluate your competitors by placing them in strategic groups according to how directly they compete for a share of the customer's dollar. For each competitor or strategic group, list their product or service, its profitability, growth pattern, marketing objectives and assumptions, current and past strategies, organizational and cost structure, strengths and weaknesses, and size (in sales) of the competitor's business. Answer questions such as:
According to Lathan Fritz, founder of Amerisales, geotargeting doesn’t have to mean getting down to the local level. Larger companies can use geotargeting on a regional basis to locate specific audiences for their marketing campaigns. He knows this firsthand from helping one of his clients, an e-commerce company that sells shipping supplies. Fritz’s company conducts national campaigns for this client, ranking it for search engine optimization terms in Google and running national Facebook campaigns.
To more effectively drive traffic to their stores, they pushed out a 10% discount on any in-store purchase when customers provided their email. This not only drove traffic to their new shops, it also helped them construct lists for each store that they could later use for store promotions. By targeting these specific users in areas near their stores and then promoting to in-store audiences, an e-commerce site successfully made the move to store fronts. Read the full evo case study here!
It's quite likely that no prospect or customer reads your press releases as carefully as your competitors do. Press releases are helpful in understanding a company’s strategic focus. Sometimes PRs show your competitors’ customer count. The About section in a press release shows your competitor's strategic messaging. These two to five sentences are how your competitor wants their customers and prospects to perceive the company and its products.
"We've been experimenting with Quora Ads in a few client accounts and have been intrigued by the (limited) results thus far. One of our clients, Dataquest, is an online platform for learning data science. Their marketing director approached us about Quora Ads a few months ago, and we decided to give it a shot. To be fair, we are still in the middle of the trial run, so the traffic is fairly low, but what we have seen come through is enough to get us excited about it as a new channel. 
Conducting PPC marketing through Google Ads is particularly valuable because, as the most popular search engine, Google gets massive amounts of traffic and therefore delivers the most impressions and clicks to your ads. How often your PPC ads appear depends on which keywords and match types you select. While a number of factors determine how successful your PPC advertising campaign will be, you can achieve a lot by focusing on:
AdWords may suggest keywords based on your website content. Feel free to use them for inspiration, but also consider the many different ways you and your customers talk about your business and be sure those turns of phrase are reflected in your keywords. Start by creating a list of about 10 “head terms”—the concepts from which everything else you do follows.
Exhaustive – Your keyword research should include not only the most popular and frequently searched terms in your niche, but also extend 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.
Location history of a consumer provides a lot of information specific to that person: where they like to shop, what they like to buy, how often they make the trip, and even how they get there. Obtaining this information gives great insight to marketers that enhances the ability to target consumers and deliver relevant, responsive location specific ads and information, even if the consumer is not currently in that area.
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?)  
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.
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.”

Google Ads operates on a pay-per-click model, in which users bid on keywords and pay for each click on their advertisements. Every time a search is initiated, Google digs into the pool of Ads advertisers and chooses a set of winners to appear in the valuable ad space on its search results page. The “winners” are chosen based on a combination of factors, including the quality and relevance of their keywords and ad campaigns, as well as the size of their keyword bids.
John Lincoln is CEO of Ignite Visibility, one of the top digital marketing agencies in the nation and the number 698 fastest growing company in the USA in the 2017 Inc. 5000. As a digital marketing expert and in-demand public speaker, Lincoln is consistently named one of the top influencers in the industry. In 2017, he was the recipient of the Search Engine Land "Search Marketer of the Year" award. Ignite Visibility crafts custom digital marketing strategies for clients, including services in SEO, social media, paid media, email marketing, Amazon and more.
×