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.

Geographic targeting allows your ads to appear in the locations that you choose: country, city, areas within a country or city, a radius around a location, or location groups. Geo targeting helps you focus your ad campaign on the locations where you’ll find the right customers, and restrict it in locations where you don’t, which could help increase your ROI. Right geographic region can significantly help you optimize your campaign for better results. Identify countries, states, regions, or areas where your ad campaign can perform well.


- Hi, I'm Matt Bailey. Welcome to keyword strategy in depth. Keyword research is the fundamental building block, for all of your on-line marketing efforts. It goes beyond optimizing your website, to enabling a better connection when marketing to your audience, as you are using their language. We'll begin by finding sources for keywords, seeing how search engines deliver different results based on the types of keywords, and building your keyword lists. Next, I'll demonstrate how to effectively sift through the keyword data, in ways that maximize your ability to understand the searcher, and derive their intent. We'll see how to implement your keywords throughout the content of your website. Then, I'll demonstrate how to setup an initial Google AdWords campaign, utilizing your keywords, and avoiding the top five mistakes that companies make in AdWords. I've been marketing online for nearly 20 years, and I love to teach people how to be successful in their own businesses with the tools…
Then how can someone afford to pay $54.20 per click if it does not generate profit? The answer is simple: they are spending that money to build a brand and they are not focused on the profitability on that individual click; they are focused on profitability over time and they most likely have a budget assigned to building that brand. Not having to focus on achieving profit for individual click puts a company at a tremendous advantage for displaying their brand prominently in search results. It also makes it harder for profitability based marketers to compete.
One way to get a good idea of how your target market might view your industry is to just ask them. Using focus groups, questionnaires, and surveys can help you can gather information on popular businesses with products similar to your own. You’ll also get first-hand information of how customers feel about the products that are already on the market.
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.

Having initiated a Geo Targeting conversion experiment, you are faced with an inherent problem: how can you verify that your Geo Targeting works? One option is to ask people that are located worldwide to browse your targeted pages and inform you of the results. Another, far more convenient method, is to use a “global geo proxy network” that allows you to browse the web from different global locations.


Every business can benefit from attracting higher value customers. Whether you’re a real estate company looking for high net worth individuals looking to buy property or a B2B SaaS company looking for a higher average revenue per user (ARPU), attracting customers who will pay you more than others is a powerful way to amplify the growth of your business.
When creating and implementing a digital marketing campaign, you first need to design your keyword strategy. This strategy is more than just finding keywords that will bring you the highest number of visitors. It’s a top-to-bottom concept that will influence how you design your site, select keywords, optimize your pages and measure the success of your campaign.
“The sales cycle is an average of 9-12 months. When a qualified lead enters the funnel, the revenue generated from that lead is an unknown variable that will not be fully identified until several months into the cycle. In order to increase the probability of a PPC lead turning into a viable source of revenue we need to generate leads at a ratio of high ratio of sales quality leads to conversions (roughly 65%). We will continue to test new targeting in order to reach our 20% YoY growth goal at a reasonable average CPA in order to continually grow the account and keep the sales funnel full every month.”
Take Coca Cola and Red Bull for example. They have massive marketing budgets, and the majority of that budget goes into branding and (I am guessing) very little attention is paid to determining the ROI of each individual activity they sponsor. They just know that the more they can build equity in their brand, the more products they will sell. The result? They are some of the most recognizable brands in the world. They are also extremely profitable at the end of the year – they just achieve that profitability differently than what we are used to seeing as direct response marketers.
Your entire PPC campaign is built around keywords, and the most successful AdWords advertisers continuously grow and refine their PPC keyword list (ideally, using a variety of tools, not just Keyword Planner). If you only do keyword research once, when you create your first campaign, you are probably missing out on hundreds of thousands of valuable, long-tail, low-cost and highly relevant keywords that could be driving traffic to your site.
When looking at competitors for the PwC field service operations group there were lots of competitors (including paper printed out and stuck to the wall). What was interesting was that most of the competitors were originally independent companies, but then acquired by larger companies. What was most helpful was looking at how each organization’s strategy changed their end goals. In the case of Field Service Lightning it was originally about the CRM capabilities of SalesForce, but is now about the integration of machine learning for Salesforce’s Einstein.
You should invest in having a well-structured filing system, both in the office and digitally. Use neatly organised folders with clear and relevant names on them for all of your documents, bills and emails. By doing this, you can free up hours of the day to work on important tasks, such as drumming up more business through a new and exciting marketing strategy. You will also be setting an example for your team by having an organised office and computer.
Let’s take the example of a guy, we’ll call him Jerry, who runs a coworking space in the city of Bristol, UK. He’s concerned about his keyword rankings, as seen in WooRank’s SERPs tool. Even his main keywords are only providing ‘+100’ rankings. (If you have used our SERPs tool, you know that this is the number we give to search engine results that rank out of the first ten pages in Google and Bing for a certain query.)
You need to develop tactics to recognise and double down on the deep conviction you have in your gut that nobody else understands. Stop looking for consensus or opportunities that seem obvious and compelling at first glance. Great opportunities never have “great opportunity” in the subject line. Honing your gut instincts and acting upon conviction is a theme of every successful journey.

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:
A competitor's media strategy reveals budget allocation, segmentation and targeting strategy, and selectivity and focus.[13][14] From a tactical perspective, it can also be used to help a manager implement his own media plan. By knowing the competitor's media buy, media selection, frequency, reach, continuity, schedules, and flights, the manager can arrange his own media plan so that they do not coincide.
When looking at competitors for the PwC field service operations group there were lots of competitors (including paper printed out and stuck to the wall). What was interesting was that most of the competitors were originally independent companies, but then acquired by larger companies. What was most helpful was looking at how each organization’s strategy changed their end goals. In the case of Field Service Lightning it was originally about the CRM capabilities of SalesForce, but is now about the integration of machine learning for Salesforce’s Einstein.

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.


A FINAL WORD [top] Schedule a competitive analysis on a regular basis, as you do for inventory and other business functions. Depending on what market you're operating in it could be every two months or once a year. Consider employing a college student for the summer or create student internship positions to fulfill the task. You must remember that your competitive research and analysis is never finished. This is on-going, rather than a one-time process. Your competition can change quickly, new players can emerge tomorrow, the economy may upswing or downswing at any moment. It's only when you clearly understand your competition that you can evaluate your own market position. Only then can you exploit their weaknesses to your competitive advantage and seek to improve your own marketing efforts. CHECKLIST [top] ___ Have you identified your direct and indirect competitors? ___ Do you know how the customers in your target market rate your product in comparison with your cometitors'? ___ Have you compiled the intelligence you have gathered on each competitor in a format that fosters comparison of features and market postions? ___ Do you have strategies for building on your strengths and minimizing your vulnerability where you have weakenesses? Do you have strategies for minimizing the value of your competitors' strengths and taking advantage of their weaknesses? ___ Have you communicated the competitor information and your strategies to every worker who needs to know? In research and development? In production? In marketing and sales? ___ Have you established procedures for keeping your industry and competitor profiles current? RESOURCES [top] Books Competitive Intelligence for the Competitive Edge, by Alan Dutka. (NTC Business Books, 1999). Brief discussions of competitive intelligence activities are followed by extensive real-life case-study examples. Web Sites "Do You REALLY Know What The Competition Is Doing?" by Darrell S. Mockus. Journal of Business Strategy 24:1 (January-February, 2003), 8-10. "Spies Like Us," by Carole Ashkinaze. Business Week (July 12, 2000), F4+. "Face-to-Face: Spies Like Us," by Stephanie L. Gruner. Inc. 20:11 (August 1998), 45 (7). "Spy Away," by Mark Henricks. Entrepreneur 28:3 (March 2000), 98. Fuld and Company. What Is CI?. Society of Competitive Intelligence Professionals. "Competitive Intelligence vs. Espionage," by Fred White. ThomasNet Industrial Newsroom, May 22, 2007. Writer: Susan MaGee All rights reserved. The text of this publication, or any part thereof, may not be reproduced in any manner whatsoever without written permission from the publisher.  
Bonus Trick: Try typing in your basic keyword phrase, followed by every letter of the alphabet, and making a list of those phrases. If your product or service is specific to locations, try typing in those locations to see what kind of search volume exists. (Are alternative energy tax credits more commonly searched in Austin compared with Cleveland?)
“We’re seeing a lot of attention on our Promote product, a solution for small business owners, that few people realize is powered by automation and machine learning behind the scenes. We’ve partnered with large banks, small business service providers, and more to bring this machine learning martech to small business owners. And we’re not alone. There are many examples of increasingly accessible machine learning tools for small businesses.”

We at Moz custom-built the Keyword Explorer tool from the ground up to help streamline and improve how you discover and prioritize keywords. Keyword Explorer provides accurate monthly search volume data, an idea of how difficult it will be to rank for your keyword, estimated click-through rate, and a score representing your potential to rank. It also suggests related keywords for you to research. Because it cuts out a great deal of manual work and is free to try, we recommend starting there.
It's not always about getting visitors to your site, but about getting the right kind of visitors. The usefulness of this intelligence cannot be overstated; with keyword research you can predict shifts in demand, respond to changing market conditions, and produce the products, services, and content that web searchers are actively seeking. In the history of marketing, there has never been such a low barrier to entry in understanding the motivations of consumers in virtually any niche.
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.
×