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.   ‎
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).
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.
Think about what else is around you. Don’t just think about where you are; think about what’s around you. Are you a restaurant near a stadium or an airport? Encourage people to stop by after the big game, before that Ed Sheeran concert, or for a graduation celebration in your ad copy. If you’re a boutique fitness studio, advertise to people who are health-conscious and attending the farmer’s market nearby. Put these suggestions into your copy to increase in-store events.

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

Let’s start with an easy one: target the areas your business serves. If your restaurant has one location in Chicago, set your search campaigns to only show to searchers in and around Chicago! If you’re an ecommerce site that serves the Pacific Northwest, don’t show your ads outside of Washington, Oregon, Idaho, Montana, and Wyoming. This is the most basic way to ensure that you’re not wasting clicks – and money – on consumers who can’t convert.
For both teams, first reactions from people were often strongly negative. I cringe to think what focus groups would have done with these ideas. But, Chesky and Gebbia, and Hyman and Fleiss, were undeterred. To these founders, their ideas were obvious and they set out to find investors and employees who got the vision when most everyone else did not.
Gather Competitive Information Secondary sources of information are recommended as an excellent starting point for developing a competitive and industry analysis. Secondary sources include information developed for a specific purpose but subsequently made available for public access and thus alternative uses. For example, books are secondary sources of information as are articles published in journals. Marketing reports offered for sale to the general public also are considered secondary sources. Although, they have been created for a purpose other than your current need, they are still excellent sources of information and data. With the ever increasing speed of document identification and retrieval through electronic means, secondary sources are not only an inexpensive source of information but are readily available soon after publication. Sources of information include:
It’s easy to get blindsided by our own opinion on “high-quality” content. You might be thinking you have an awesome idea that everyone wants to read about, but how do you know with absolute certainty that it’s really that great? And even if your hunch is spot on and you’ve discovered something truly worth sharing, how do you quantify its value? How do you find the right content marketing keywords?

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.
Attribution. Use attribution data to prove the influence of PPC on conversions either cross-channel or within the channel. For instance, you might learn that certain campaigns don’t convert well, and the instinct is to turn them off. However, if they lead to conversions in other campaigns, you’ll want to allocate budget to keep the conversion path open.
If you’re an ecommerce business, then you need to be running Google Shopping Campaigns. Consumers use Google’s search engine on a daily basis to find all kinds of products that they need (including yours), and running Google Shopping campaigns can help you connect with them. These campaigns pull product information, such as the product image, price, and merchant name, from your company’s Merchant Center data feed and conveniently display them to the viewer. Because it pulls this data each time a user makes a search inquiry, you can be assured that your product ads are always up to date and accurate (so long as you keep your data feed that way), keeping your potential customer from feeling confused or frustrated.
It’s good for searchers – Research indicates that searchers click on paid search ads more often than any other form of digital advertising. This means that people really don’t mind being advertised to, provided that the products and services advertised actually fit the searcher’s needs. And because we use search engines when we’re looking for products and services, the results, including the ads, are generally highly relevant to what we’re looking for. Plus, Google has developed an excellent formula for ensuring that PPC ads meet the user’s needs.
Thanks Ramon! You can easily add more tabs to input more backlink data for additional competitors and then adjust the query formula to use the new tabs. I often increase this to 10, 15 or even 20 competitors for larger clients. The beauty of Google Sheets templates is the ease in which you can make these adjustments. Let me know if you need any help with that.
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.
If your account is currently achieving a return on ad spend (ROAS) of 5, and your goal is to achieve a ROAS of 6, your strategy should focus on efficiency optimizations to improve ROAS. If your account is achieving a ROAS of 5 and your goal is to increase revenue as long as your ROAS is at or above 4 (and you have additional budget to spend), then your strategy will need to focus on growth initiatives.
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. 
Geo-Fencing refers to drawing a virtual barrier around a location using your devices global positioning system (GPS) or Internet Protocol (IP) address, which is just like your virtual address.  Ads inside of geo-fenced areas can be seen on computer, tablet, or mobile devices as potential customers are browsing the web.  Technically, geo-fencing can be any size radius from a particular location, anywhere from a mile to state-wide.  But most people when they are referring to geo-fencing are looking for a very tight radius around a location.   A misconception with geo-fencing is that once inside the fence you receive push notifications, or text messages to the device, which is not accurate.   What geo-fencing does instead is show ads to the person inside the geo-fenced radius if they are browsing the web, to alert them of a local deal or the distance you are from a particular store location.
The risk to this approach is that it isn’t always terribly accurate beyond the city to ‎zip code level.  If, for example, you were to use MaxMind’s demo service to locate ‎your own IP, it will likely show you perhaps a mile away from your actual address, ‎likely at the nearest network node, the point at which your computer connects to ‎your ISP’s network infrastructure.   ‎

The other option is to follow up with page visitors outside of AdWords. To do this, you’ll want to create an opt-in page (like the templates above) that offers visitors something of value in exchange for their email address or other contact information. Our dishwasher vendor could offer a free guide on the best way to prolong the life of your dishwasher.

Overall score: Finally, you simply add up the scores and divide by the number of columns you have. This will give you an overall score. Then you can sort your keyword list by overall score and voilà, your keywords that are likely to perform the best for you bubble up to the top. You can weight each column if you like based on which factors are most important to you.
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.
Every company has those dreaded competitors they cannot stand, no matter what you do they are always using your ideas and taking your potential customers. Whether you are a local, national, or international company there is probably someone in your company, specifically the sales and marketing teams, that can quickly rattle off your top competitors as well as what differentiates them from you.
Repeat this exercise for as many topic buckets as you have. And remember, if you're having trouble coming up with relevant search terms, you can always head on over to your employees on the front lines -- like Sales or Services -- and ask them what types of terms their prospects and customers use, or common questions they have. Those are often great starting points for keyword research.

As I consult and train people on Internet marketing, I typically ask whether keyword research is a strategic function or a tactical one. Often people think it’s tactical because of the tedious nature of the work. I submit it is not only strategic but also foundational to all marketing channels you will use. If you take the time up front to outline a killer keyword strategy, you will find your campaigns will be higher performing and more successful. In this column, I will outline seven tips for developing a killer keyword strategy you can use to take your campaigns to a higher level.
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.
This is a particularly useful strategy for local businesses (or any business that takes calls, really) to target people who are likely to call them directly from a search query. With Call Extensions you can easily add a click-to-call button to your mobile ads and phone numbers to your desktop ads. Additionally, you can track customers who make calls from your website using Website Call Conversions.
Using SKAGs will help you improve your overall quality score, which will also improve the effectiveness of your PPC campaigns. In order to get the best possible quality score, you need to make sure that your user experience is consistent. For instance, your ad, keyword, and landing page should all match and seamlessly flow together. This is why using just one keyword per ad group is so helpful. It allows you to ensure that your ad and landing page perfectly align with the ad keyword. If you use multiple keywords, especially more than 15, it’s unlikely that you’ll be able to thoroughly represent all those keywords in your ad and landing page.
A company rarely competes against just one competitor. In fact, in many cases, the biggest competition in the SaaS and tech industries is coming from indirect competitors. These competitors hold a commanding position in their core market, allowing them to expand into different industries and verticals. Who would have thought that Uber and Google would become die-hard competitors in the autonomous car market? As I wrote previously in my analysis of sales enablement and acceleration industry, it is almost impossible to distinguish direct and indirect competitors. In many SaaS verticals everyone competes with everyone.
Now as searchers start to gather information, they begin to refine their search and start using more specific terms. Then finally they begin to use very specific terms. They have switched from information gathering to a transactional mode. If someone searches on the term “canon eos mark III,” what does that suggest about their intent? That they have done their research and are ready to buy. So do you send them to your home page? Absolutely not. You need to send them to your product page that has the product, its features, maybe related products, the price, and most importantly the “buy now” button. They don’t need more information; they’re probably price shopping and are looking for a trusted source with the best price.
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:
Your conclusion should be presented to other business stakeholders especially when you’ve decided the next steps. For example, you may alter your Product Roadmap as a result of the competitor analysis. Sales and marketing teams may benefit from summaries that contrast your product with key competitors and emphasise your product’s strengths so that they can take this message to market.
One of the major promises of enterprise PPC management tools is that they employ bidding strategies that will save you all kinds of money by trimming down your cost per click through intelligent bid algorithms. These algorithms often let you adjust bids by just about any variable available in the AdWords/Bing API’s (you can even create calculated metrics) and adjust bids according to these rules in order to reduce costs. What they usually don’t tell you is the best way to set them up or provide algorithms to you that work out of the box. They give you the fishing line, but don’t always teach you to fish. They are a tool, and what we need is a PPC strategy.
On the other hand, version B not only communicates the valueof the cyber security business (protecting other business’s data from hackers and cyber attacks), but also acknowledges the potential customer. The copy in version B also addresses the fact that what the viewer is likely looking for in such a company is a sense of security, and caters to that with the words “protect” and “safe”.
Use Google Keyword Planner and your list of potential search ideas to create a list of terms/phrases that align with your brand and that, ideally, aren’t highly competitive. Google ranks competitiveness in Keyword Planner, seen above. You can also get an idea of how competitive a keyword search is by looking at the price of the suggested Adwords bid. Competitive search terms are typically much harder to rank for.

2. Voice Search Comes into Its Own: It’s time to start optimizing your ads for voice search: The ease of use and prevalence of virtual assistants like Siri and Alexa, as well as Google’s Voice Search (“OK Google…”) make using vocal search utterly quick and convenient. Voice search accounted for 20 percent of mobile searches in 2016, according to a Kleiner Perkins study quoted by CNN. Amazon’s Echo and Google’s Home are on many Christmas Wish Lists this year. Grab the voice searcher’s attention by using the first person question format in your ads and content. Most voice searches are geographically specific, so use correct and popular names for your local neighborhood(s), city, county, and region in your PPC ads.
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.
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.”

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:
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:
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. 
It can be easy to go down a deep rabbit hole with this process. There are thousands of blog posts with helpful hints (you’re reading one right now), and hundreds of tools that can potentially improve or otherwise streamline the process of researching keywords and devising a smart keyword strategy. That’s why we advise you keep things simple for starters. You can always layer on complexity as you gain experience. More than anything, good SEO efforts revolve around creating content experiments, measuring them, then doing more of what works and less of what doesn’t. Simpler is often better, especially if you are resource constrained. A good content governance strategy should dictate that you take on only as much as your resources allow.
John Boyd, a famous military strategist, thought a lot about how competitors change the way that we strive for our own goals. The concept he popularized around the OODA loop talked about making decisions faster than your competition as a way to win. It was also key to understanding what your competitor values so you can find other ways than fighting directly.
According to Nielsen Norman Group’s “User Experience Careers” survey report, 61% of UX professionals prefer to do the competitive analysis for their projects. But what exactly is competitive analysis? In simple language, competitive analysis is nothing but a method to determine how your competitors are performing, what they are offering and how well they are doing it.

It has also become remarkably difficult to distinguish direct competitors from indirect threats - and when you do, you find competition often comes from surprising places. In fact, competition in the SaaS and tech industries is increasingly coming from indirect competitors, whose core technology enables them to invade adjacent verticals and industries.
Informational: These keywords represent the very beginning of the conversion process, and are not very likely to convert on the first visit. If you’re running a branding campaign you’ll want to be sure to include informational keywords on your list. If you’ve got a conversion goal, you still can’t afford to ignore these keywords as they make up the majority of searches. Informational keywords often use words/phrases like "how to", “do I need” and “where to find”. Consider these leads to be converted later via your website or a retargeting campaign.
If you want to become a better UX, interaction, visual (UI) or product designer, there are a lot of sources from which you can learn — articles, books, online courses. I often check the following few: Smashing Magazine, InVision blog, Interaction Design Foundation, NN Group and UX Mastery. These websites have a very good collection of articles on the topics of UI and UX design and UX research.
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.
Reason: If visitors find your website with a certain keyword but you have a high bounce rate, that’s enough to know that something is not going as it should. Ask yourself and test if it is a problem with content quality, appearance, etc. There is often more than one explanation for a high bounce rate, and there could be more than one solution. If you are totally lost at this point, a feedback session with five potential users might provide some insightful ideas.
Once your campaign is established you must review the analytics data and look for ways to optimise the campaign. Setting clear goals and measurements are absolutely critical to allow the campaign to be reviewed against each stated goal, in which you will consider ad performance, keyword performance, ad placement performance, campaign structure, and campaign targeting. This chapter highlights how to analyse and optimise your PPC campaign for success.
There are some general negative keywords that should be added to almost any campaign, such as “free”, “jobs” “training”, as people searching for these terms are not likely to be looking to buy your product. Keywords like “review” and “opinions” can also be useful, as they will reduce the number of window shoppers who aren’t necessarily looking to buy now. But you’ll also want to research negative keywords specific to your business or audience. For example, if you are an optometrist, you’ll want to use words like “wine”, as you aren’t looking for customers in search of “wine glasses.
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.
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.
That’s right. Unfortunately, all those slight tweaks to your ad copy and bidding strategies actually do very little in terms of turning leads into customers. So, what exactly should you do to PPC campaigns to maximize conversion potential? Don’t fret—there are actually quite a few things, and we’re going to teach you about each one of them. Below, check out the strategies you should be focusing on to achieve ultimate results.
† By submitting this information, you provide express written consent to Web.com and our affiliates ("Web.com") sending you future information, contacting you for telemarketing purposes using the information (including any phone numbers) you have or will provide us, and monitoring and recording these communications to assure the quality of service or for other reasons. This means Web.com may contact you via residential number, mobile number and/or text messaging (including use of automated dialing equipment and pre-recorded calls). You are not required to give your consent as a condition of making a purchase with Web.com. Additional information can be found in our Privacy Policy. Click here to remove your consent.
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.
Yes, that sounds like it would be awesome. Another great update would be to add a script that populates the spreadsheet automatically from a file structure containing the downloads (organic KWs and Links) to save copying and pasting everything. I’m going to have a chat with a friend in the Analytics space to see if he can help. Will share any successful output.
×