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.

Long-tail keywords: Longer keywords or specific phrases might not be used as search queries as frequently by your audience. In the above example, for instance, it’s likely that a freelancer looking for a coworking place queries ‘coworking bristol’ rather than ‘coworking space in bristol’, however, the traffic generated by all combinations of long-tail keywords can provide your site as much traffic as the short-tail keywords. And why would you risk losing any opportunity you have to be present on search engines? We are not the only ones saying this, HitTail also give facts about long-tail keywords; about 70 percent of queries are long-tail.


In 2017, it’s a requirement for any company to live on the internet. This section gives you and your team easy access to your competitors’ online presence. Include links to the social media channels and webpages your competition has the most activity on. By providing these links, your audience can quickly determine what channels the companies take advantage of the most and how they use them to tell their brand story. Understanding why and how the competition is doing well or not with their online presence will reveal the opportunity.

Try to match the offer you make on your pages (product, service, message, etc) to the visitor’s specific location. This sounds simple but requires careful thought and planning. Measure funnel performance for visitors that are geo-targeted versus a control group – are people finding this “filtration” helpful or confining in a way? Statistically, do visitors that are directly served with local offers differ in behavior than those that are asked to “choose your location”? Test it!

6. Use social media to help provide context for user intent. Another important keyword strategy is to align your social media efforts, especially the “listening” part, to help provide context to your targeted keywords. I have outlined a few ways in this column to infer user intent by keyword but to see the search term used in a tweet or blog will provide a much better context to user intent and usage. You can gauge user wants, needs, and sentiment that will help you as you construct your landing pages with keyword-relevant content.
Features/commentsIn this column, I put all of my comments, some ”star” features I needed to focus on, and the pros and cons of the competitor. I color-coded the cells so that later I (or anyone viewing the matrix) could easily identify the difference between them. For example, I used light yellow for features, light purple for comments, green for pros and red for cons.
For branding campaigns, your budget is often not an issue. You may have a fixed budget or your budget may be seemingly limitless. It doesn’t matter, because with this strategy the focus is on position; and in most cases only position #1 will do. This is often the easiest strategy to execute for paid search, but it’s also inefficient. The reality is that bidding into the top position in search results is often a waste of money. Google has gone on the record as saying that conversion rates don’t vary much by position, so in many cases all that the first position buys you in paid search is brand awareness (and vanity).
Competitive analyses for SEO are not something that should be overlooked when planning a digital marketing strategy. This process can help you strategically build unique and complex SEO campaigns based on readily available data and the demand of your market. This analysis will instantly put you ahead of competitors who are following cookie-cutter SEO programs and not diving deep into their industry. Start implementing this process as soon as you can and adjust it based on what is important to your own business or client’s business.
In the figure below, you can see I have set up a keyword rating spreadsheet. I first gathered keyword data from a keyword tool to populate the orange columns. In this example, I used the Google AdWords Keyword Tool. From there I began looking at each keyword and gave each one a score from one to 10. For some I built a formula to automate the process, which comes in handy with larger keyword lists.
Furthermore, 70% of consumers are willing to share their location information if they believe they are getting something of value in return like coupons or loyalty points, according to LSA’s Local Mobile Search Study.  This dynamically moving consumer base is only going to be more receptive to search results and ads that are specific to their location.

Jeff Baum is Director of Services at Hanapin Marketing and a seasoned PPC advertising professional with Hanapin Marketing. a 13 year track record of success in digital advertising. He has developed and implemented strategies to substantially grow revenue and profits for a variety of lead generation and e-commerce businesses. He has also been responsible and accountable for managing hundreds of thousands of dollars in PPC advertising spend per month. Jeff is a recurring writer for Hanapin's blog and PPC Hero.
There are lots of questions, as yet unanswered. For example, when considering anonymity, is it okay if trackers gather data, but aren’t able to discern exactly who a user is? There are questions of security and privacy, and information one company might share with another. There are questions of choice: should customers always have to opt-in, or can opt-outs work, too? There are questions about who can and can’t be trusted with these services: your company, for example, versus, say, the U.S. government.
Keyword research for PPC can be incredibly time-consuming, but it is also incredibly important. Your entire PPC campaign is built around keywords, and the most successful Google Ads advertisers continuously grow and refine their PPC keyword list. 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.
Geo-targeting refers to the ability for advertisers to place their marketing materials in a specific region or locale. In digital advertising specifically, geo-targeting is just one of many tweaks that an advertiser can make to ensure that its messages and ad campaigns reach a particular customer in a particular market. In addition to geo-targeting, online ads can be targeted by additional demographic information like age, gender, hobbies and so on.

A first step is to try to articulate what market it is that you serve. Who are the customers in this market and what problem, need or want are they experiencing? Which organisations are currently satisfying these needs or wants and how do these organisations differ? If there are multiple products tailored to different market segments try to define the ways in which these products can be grouped together or set apart. Using simple 2×2 matrices (e.g. price vs. functionality) can help to categorise your competitors and help to show what customers are looking for.


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.
Katey Ferenzi has lived and breathed ecommerce for +10 years. In the mid-2000s, she and her husband started their own online business and successfully exited so they may come to Bigcommerce to teach other SMBs how to do the same. Currently, she's consulting for Jasper PIM, a Product Information Management (PIM) solution focused on unifying back-office operations with front-end shopping experiences for mid-market and enterprise businesses looking to scale.
What’s the difference between your brand and your keywords? Are you using both effectively? Your brand is one of your most important keywords, but it shouldn’t be your only keyword, nor should you have lots of keywords but no brand. There should be a keyword strategy behind the keywords you pick. This post highlights the why of that and explains the basis of the how, then points you to several useful posts for the how.

People are no longer shocked to find elements of personalization embedded into various aspects of advertising, and in fact, have even come to expect it. Think about it this way: When it comes to marketing emails, which are you more likely to open and read—the one addressed to “Dear Customer” featuring generic copy on topics that aren’t relevant to you? Or are you more likely to engage with the email addressed to your name that includes links to blog posts relevant to the industry you work in, as well as items you might like based on your previous purchases? That’s right—you’re going to open and read the email that’s tailored to you.
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.
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:
But switching costs, or the cost that a customer incurs as a result of switching products, still exist. Technology can be a driver of higher switching costs. When a product is integrated with multiple systems and APIs, switching to another product becomes increasingly difficult. Such a switch usually results in business interruption and the need to retrain staff, among other unwelcome effects.

There are various platforms available for PPC ads like Google, Yahoo, Bing and social media channels like Facebook. Choose wisely your platform and plan your ad campaign strategy, according to it. Google is the most effective and famous platform for PPC campaigns. Google Adwords is an advertising interface provided by Google, which is used to plan and publish Google ads. Similarly, Bing ads and Facebook ads provide all required interfaces for an effective PPC campaign.
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.

A quality ad account in 2018, according to Google, is an “autopiloted” account; the more options that are delegated to Google Ads, the better. However, even if Google is now able to decide on its own which banner size will fit best on a particular website, it is still your responsibility to provide catchy text, relevant images, and the right keywords.
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.
Keyword strategies are essential to developing winning search engine marketing campaigns. Your keyword strategy should involve selecting high-performing keywords that drive relevant traffic to your business. Choosing the right keywords for advertising can make all the difference in your campaigns, determining how well your advertisements rank on Google and other search engine 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:
Competitive analysis can help frame your own product context, discover other problems your customers have, and even bond the team together against a common foe. For all of these reasons and more you shouldn’t ignore your competition. However, if you don’t properly understand how they impact your organization’s strategy, competitive analysis is simply a waste of time.

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:
PPC-Strategies' expertise and knowledge of the search engine landscape can help you attract more qualified customers to your website...guaranteed.  Whether you are new to online marketing or have already tried pay per click and other forms of promotion, our precision-crafted advertising strategies will improve your online visibility and customer engagement.

To do this, you want to analyze your analytics frequently by keyword and observe visitors’ behavior when they come to your website or landing page. Don’t fixate on just traffic alone. How much time are they spending on your site? What is the average number of pages they are viewing? What is the bounce rate? A high bounce rate like 80 percent will tell you that most of your visitors leave your site immediately upon landing on your site. They’re not engaged and see no content clues they arrived at their desired destination. This can be fixed by making changes to your landing pages as long as they are relevant to the keywords that brought them there.


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.
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.
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.).
This can mean simply using pictures from the surrounding area or structuring the landing page around a theme that is relevant. A great example of this is Grubhub. If you access their site from Boston, you get completely different suggestions and images than you do if you access it from San Francisco. Not only does this engage the user on a personal level, it also draws them in to the page, keeping them clicking for longer.
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.
The first case is quite simple yet happens often. So for example, you have not sold tandem bikes for years (and had the word “tandem” in a negative list), then you started to sell them again. But your PPC specialist forgot to remove the word from negatives, and now you are left wondering why you are not getting any traffic for this keyword. To avoid this situation, check your negative keyword lists regularly and bring the relevant keywords back to life.
Thanks for a great read. The holy grail of marketing is the ability to link advertising directly to consumer purchases. Increasingly, geo-targeted campaigns are making this dream a reality. 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. Facebook, Snapchat, Instagram, etc., are all offering these services.
Some publishers and networks have even developed performance-based marketing plans based on geo-targeted ads. Ads and marketing are only placed and paid for when there have been proven results to show that this venture is worth it. It has always been very effective to target a certain demographic based off of their age, gender, or career. This can be taken even further by taking a look at certain locations and what demographics reside there. Website data can be used to determine what geographic locations are most frequently perusing a site and that area can be targeted as well.
Don’t base your whole strategy on chasing volume though. Pay attention to the competition column in the keyword research tools. Even though these tools use pay-per-click (PPC) data to determine competitiveness and suggested bid, you can still extrapolate this data for organic search. High competition and suggested bid is a strong indication that there’s money to be made off of these keywords, as advertisers generally won’t bid high CPCs on poorly performing keywords.
If you want more traffic from the search engines, follow the steps from the SEO analysis report. The SEO Analyzer point out all of the problem you may have on you website and supply with tips how to fix them. Use wisely and remember not to over-optimize the page, as it may look that the page is created for search engines. Our SEO Analyzer is the most advanced and fastest analyzer on the web.
×