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.
…Well, this is a best practices post, right? It may seem obvious to use the highest converting ad formats in your PPC campaigns to boost their conversion rate, but many marketers don’t actually know what these optimized ads look like—nor that they can do the optimizing themselves even after their ads go live! In this next section, we’ll break down a few important ad formats and options that you should have on your radar and use to maximize your conversion potential:
Once you have caught the attention of people with your ad and they click on it, you want to make sure that you direct them to a customized landing page that specifically relates to what they just clicked on. Many small businesses make the mistake of sending them to their website homepage, but this isn’t the best tactic to convert visitors. Instead, you need to design landing pages that reflect the keywords from the PPC ad, show the product or service solution that your new visitors were searching Google for, and have a prominent, clear call to action like “Book Now” or “Buy Now”.
Google is constantly refining and adding new tools to AdWords, so remaining active with your PPC strategies is critical if you want to beat out your competition. There’s never a set-it-and-forget-it approach that you can take–as much as one might wish–so it’s important that you test, analyze, re-test, and repeat to find out what is working for you and what is not. Also, keep in mind that while some strategies might work wonders for a particular business or industry, they may not be as effective with yours. Experiment with different approaches, but don’t be too quick to abandon ones that don’t show immediate results. Some investments require time to show their return.
Competitor analysis in marketing and strategic management is an assessment of the strengths and weaknesses of current and potential competitors[1]. This analysis provides both an offensive and defensive strategic context to identify opportunities and threats. Profiling combines all of the relevant sources of competitor analysis into one framework in the support of efficient and effective strategy formulation, implementation, monitoring and adjustment.[2]
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.
For example, if a user from a high income neighborhood visits a car dealer’s site or clicks on a paid search display ad, that consumer may be directed to a landing page displaying a luxury vehicle, while consumers located in a lower income area may be targeted with a deal on an economy vehicle. The higher income consumers may be more interested in deals such as cash off or lower interest rates whereas those in lower income brackets may be more receptive to lower monthly payments.
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.
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. 
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.
It simplified the ways that an organization can compete into four: cost leadership, differentiation, the focus on cost, and the focus on differentiation. Since the inception of Five Forces there has been a lot of discussion about how helpful the categories are, but it seems to be part of everyone’s strategy and competitive toolbox, especially for MBAs.

Benchmarking is the important key factor for any marketing campaign. You should always keep an eye on your competitors. How their ads are appearing, what keywords they are using and plan your strategy accordingly. Never create ads, which looks similar to your competitor’s ads. You should smartly design your ad copy, which should look better than your competitor’s ad.
Create different ad groups. Each ad group consists of specific ads that share the same keyword. For example, if you’re a SaaS company, it makes sense to have an ad group for each product category you serve. The SaaS SEO company, MOZ, might have ad groups for keyword research, link building, site audits and web page optimization. Each group consists of different ads for that category.
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.
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?)
The answers remain to be seen, but there’s one no brainer in all of this; one best practice that can dictate any brand’s choices around location-based marketing: ask your users. Explain why you want to target them, tell them how you plan to use their data, and make some commitments about how you won’t use it. Ask for feedback via quick polls, or consider doing some market research on your audience. See what your users most want. Then respect that.
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.
Competitive analyses help you evaluate your competition’s strategies to determine their strengths and weaknesses relative to your brand. When it comes to digital marketing and SEO, however, there are so many ranking factors and best practices to consider that can be hard to know where to begin. Which is why my colleague, Ben Estes, created a competitive analysis checklist (not dissimilar to his wildly popular technical audit checklist) that I’ve souped up for the Moz community.
Google considers your landing page quality as one of the important factor to determine ad quality score. Your landing page is where user redirects when they click your ad. Landing pages with poor content or under construction website pages will give bad experience to your users. Users will not buy from you if you are landing them on an irrelevant page. A well optimize landing page should have complete information about your product and call to action buttons like “Subscribe here” or “Buy Now”. If you are creating multiple ads for your product then you should optimize your landing pages for each ad copy.

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.


Beacons are little physical objects (under two square inches, in most cases) that can be placed in desired locations. Their sole purpose is to detect you, or more specifically, your device, as you move into their range. The beacons themselves don’t send content. Like geofencing, a signal is triggered when you’re near one, and a server sends a push, text, in-app message, or even an email (though currently, that’s a less likely application for beacons).
However, all these are for your own company. Marketing competitor analysis is done with relation to your competitors. That is to say, you do the analysis of your competitor’s firm. In marketing competitor analysis, you assess the strengths and weaknesses of your rivals.  You try to figure out what situations may provide an opportunity for them. Find situations which are likely to become a threat for them as well.
These are usually single-word keywords with insane amounts of search volume and competition (for example, “insurance” or “vitamins”). Because searcher intent is all over the place (someone searching for “insurance” might be looking for a car insurance quote, a list of life insurance companies or a definition of the word), Head Terms usually don’t convert very well.
Ad copy is the actual text that you’ll write for your AdWords, Bing or Facebook ads that will attract people to click on your ad. Search engines like Google are looking to show high quality ads, whose text says something closely related to the actual search in the search engine. So if you own a plant nursery in Montreal and your keyword is “Where to buy shrubs in Montreal,” a good headline for your ad could be: “Are You Looking to Buy Shrubs in Montreal?” Because the headline is relevant to the keyword and the query, it will be considered a more high-quality ad result in the eyes of search engines like Google.

"My favorite part about voice search is just how clear the intent is in the query. For example, if I typed in 'hotels in the Bahamas', you’d have no idea whether I was looking for a romantic getaway, a singles trip or a family vacation. Chances are the results would be different for each. But if I asked Cortana, 'which are the best family-friendly hotels in the Bahamas,' then a far more targeted result could be served.
You may be thinking... Google can index my site and learn what my site is about without keywords now... keywords aren't as important as they used to be... I'm doing fine I don't need any keyword help I have been doing this for years... I said all of those things (and more). The truth of the matter is: as long as we use the written word on line to match intent keywords will be valuable. If you are going to treat yourself to one bit of continuing education this year, this needs to be the one.

Long tail keywords are longer word phrases. They are specific phrases searchers are more likely to use when doing a specified search.  Due to the more tailored nature of long tail keywords, it is important to create a theme around these phrases. Doing so will increase your business’ rank in search engine results. A generic single keyword is not as valuable as multiple keywords that match a user’s search. In short, long tail keywords prove that, as far as B2B SEO goes, less is not always more. Once you’ve compiled a list of “long tail keywords” that describe a certain theme, you can begin conducting your keyword research.


Even national marketing campaigns can benefit from geo-targeting, as regional differences create opportunities to test multiple messages and refine them as a campaign continues. Geo-targeted experiments has been used successfully by businesses, charities and even political campaigns. Factoring out cultural and ethnic variations, there are still subtle regional differences in something as universal as language. A campaign for donations might be better served by using a “donate” button in one area and a “support” button in another. Similarly, customers might respond differently to the phrase “book your trip” than they do to “buy your ticket” or “schedule your trip.” The same goes for the look and feel of the advertising copy and other content.

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.

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?)
Another thing you need to do in order to maximize the effectiveness of your PPC campaigns is increase the quality and relevancy of your landing page content and user experience. These two elements have a big influence on whether or not leads will convert between your PPC ads and landing pages. A poorly designed or irrelevant landing page is a sure way to tank conversion rates.
More specifically, who gets to appear on the page and where is based on an advertiser’s Ad Rank, a metric calculated by multiplying two key factors – CPC Bid (the highest amount an advertiser is willing to spend) and Quality Score (a value that takes into account your click-through rate, relevance, and landing page quality, among other factors). In turn, your Quality Score affects your actual cost per click, or CPC.
Knowing your business’ target audience and matching it up with where they live or work helps you find those who might be most interested in your product or service.  For example, a ticket broker might want to advertise NCAA basketball tickets in the state of Kentucky and might think of using Kentucky basketball in its messaging.  However, Louisville basketball would be preferable for any advertising within 50 miles of the city on the Kentucky side of the border and 70 miles into Indiana due to the strength of Louisville’s fan base in those areas.
If you want to see what people are talking about at any given moment, there's no better way than to check in with your social media channels. Most of us already do this throughout the day, but if you haven't tapped into your channels for keyword research, you're missing out on valuable insights. Here are just a few things you can uncover by typing a word or phrase into the Facebook search bar:
As a manager, this may take the form of believing that people with less experience but lots of initiative tend to outperform experts. It may mean looking past the traditional resume. As an entrepreneur, this may be a conviction that some social stigma, like sleeping in someone else’s home (Airbnb), wearing someone else’s dress (Rent the Runway) or persistently sharing your location with all your friends (FourSquare), will lessen over time and eventually disappear.
If you’re aiming for a steady cost per conversions (also known as Cost Per Acquisition) average, despite the potential challenge in calculating those costs, then Conversion Optimizer may be of help. This strategy works by setting a target Cost per Conversion at campaign level, and then AdWords uses your historical conversion data to optimize your bidding strategy to reach your targeted average.
Evaluate your competitor's price. Just because you have the same products as other businesses, doesn't mean everyone has the same price. Your own production costs greatly impact your pricing. If your price for a similar product is higher than your competitor's, then your market position is weaker; and if it's lower, then your competitive position is better.A temporary price decrease by a competitor might indicate nothing more serious than a transient need to move excess inventory. However, a trend of lowered prices may indicate that your competition is doing it to gain market share and improve production costs. It could also mean your rival is in financial trouble and has been forced to lower prices. It's in this type of situation that rumors and gossip become helpful. If there are rumors that a company is in financial trouble and you discover price fluctuations, it's more likely that there are problems. Be sure your analysis includes product/service charges added to the purchase price, such as installation or additional equipment required.
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

The jockey does not have to be the manager of all the operations and support functions of your business, but it is your duty as founder of the business to ensure that the fundamentals are in place. Institute controls by identifying strengths and weaknesses in yourself and your team. Then implement solutions to avoid any pitfalls or risks in your business.

Getting your site to rank on Google is not as simple as plugging a keyword into a website and hoping for the best. In short, placing them into an intentional keyword strategy is just the beginning. By definition, keywords are words or phrases that describe and sum up a central idea pertinent to your business and marketing strategy. Keyword strategy means using keywords in your business and ad campaigns to attract your target market audience. When it comes to B2B marketing, keyword strategy is necessary to draw in your target audience. As B2B marketing is not the typical Buyer-to-customer setup, your keyword strategy needs a B2B marketing and relations spin. For example, if your business were looking to bring in ordinary customers, your keyword strategy might look like this:

Future Competition. In your competitive analysis, you need to make a few predictions about what the competition is going to look like in the future. Competitors are constantly coming and going in the marketplace. Ask yourself: Who are my competitors likely to be? If you are introducing a new widget, how long before the competition catches on? Forecasting future competition will give your potential investors the confidence in the long term viability of your business.Barriers to Entry. Companies whose competitive edge depends on new technology, new manufacturing techniques or access to new markets need to be aware of the common barriers new competition faces when trying to gain entry into the marketplace. They include:
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.
If you’re aiming for a steady cost per conversions (also known as Cost Per Acquisition) average, despite the potential challenge in calculating those costs, then Conversion Optimizer may be of help. This strategy works by setting a target Cost per Conversion at campaign level, and then AdWords uses your historical conversion data to optimize your bidding strategy to reach your targeted average.
Small businesses typically don’t have the budget or the amount of data necessary to take advantage of the benefits machine learning offers PPC marketers. If they’re not using a marketing agency to manage PPC that gives them access to machine learning optimization, they can also sign up directly. Acquisio’s Promote product was designed for small business owners to use with a monthly subscription model, simplifying ad creation and set up while allowing ad spend amounts as low as $100 using machine learning optimization. They explain in a past post about the small-business-machine-learning conundrum.

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.

×