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.

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.

Choosing which PPC strategies to deploy will largely depend on the type of business you have and the goals you’d like to achieve. By now, almost all of Google’s above-the-fold search engine result page (SERP) space is PPC advertising, which includes Google Shopping ads and PPC Adwords ads, as well as organic search results. Given this increasingly competitive and limited landscape, it’s important that you use the tools available to get a leg up on the competition. To help you navigate the field, here are 8 of the best PPC strategies your competition is not doing (and that you should be).
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.
CTAs match user intent inferred from content. Here is where you’ll evaluate whether the CTAs match the user intent from the content as well as the CTA language. For instance, if a CTA prompts a user to click “for more information,” and takes them to a subscription page, the visitor will most likely be confused or irritated (and, in reality, will probably leave the site).
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.
b) Compare to your competitors pages and devise a plan to beat them. Sort of–I may want to write a follow up piece to this checklist with what comes next! It may not be realistic for you to go toe-to-toe with Amazon, for instance, if they have more linking root domains than your site does. However, if it's clear that you've got a very poor backlinks profile and your competitors outperform you here across the board, that means it's probably time to start discussing creative link building strategies, or content marketing plans.
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.
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.
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.
Information from an analysis of the competitor's objectives, assumptions, strategy, and capabilities can be compiled into a response profile of possible moves that might be made by the competitor. This profile includes both potential offensive and defensive moves. The specific moves and their expected strength can be estimated using information gleaned from the analysis.
So how is geo-targeting different? Geo-targeting refers to delivering ads to people meeting a specific targeting criteria and who enter inside of a defined radius using the same geo-fencing location technology. The key difference is geo-targeting hones in on specific consumer targeting criteria like demographics, behaviors, interests, as well as where the person is located.  You often need bigger geos to do this since you are not showing the ads to EVERYONE inside the geo-fence, they must also meet the targeting criteria.
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!
Keyword Difficulty (KD). This is a cumulative score that shows you how difficult it will be to rank organically for this keyword. It accounts for the number of competitors within this space as well as the strength of those competitors. If one of your competitors is a government website that gets millions of visits each month, for instance, that will impact your difficulty score. Other factors that impact difficulty include the quality of content your competitors have and how relevant it is to the searcher.  As a best practice, look for keywords with a difficulty score that's no higher than 80.

The purpose of this guide is to provide a simple, actionable approach to building strategic PPC campaigns. Much of this is common sense and our goal with this guide is to lay out a strategic and procedural process allowing you to research and implement PPC campaigns that deliver the goods. In this chapter we teach you everything you need to know about putting your PPC strategy into action to begin converting browsers into buyers.
That said, if you’ve never had to come up with a keyword strategy before, it might seem a bit daunting to generate a list of terms that will drive qualified search traffic to your website. Not to worry. Creating an effective keyword strategy—figuring out which terms you should create content for—isn’t hard. It just involves a little bit of reverse engineering and some research.

Based on your competitor’s marketing message, what kind of customer does the viewer have to be for these messages to appeal to him or her? What is their age range? Where do they have to be located? What's their profession, if any? What other customer demographics can you infer? You're essentially trying to come up with a "buyer persona", a character who best represents the person your competition is trying to reach.
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.
×