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.
If you're struggling to think of more keywords people might be searching about a specific topic, go to Google.com and take a look at the related search terms that appear when you plug in a keyword. When you type in your phrase and scroll to the bottom of Google's results, you'll notice some suggestions for searches related to your original input. These keywords can spark ideas for other keywords you may want to take into consideration.
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.
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.
Strategic technique used to evaluate outside competitors. The analysis seeks to identify weaknesses and strengths that a company's competitors may have, and then use that information to improve efforts within the company. An effective analysis will first obtain important information from competitors and then based on this information predict how the competitor will react under certain circumstances.
In Keyword Planner, formerly known as the Keyword Tool, you can get search volume and traffic estimates for keywords you're considering. Unfortunately, when Google transitioned from Keyword Tool to Keyword Planner, they stripped out a lot of the more interesting functionality. But you can make up for it a bit if you take the information you learn from Keyword Planner and use Google Trends to fill in some blanks.

Once you've done your research, you want to make sure you're incorporating it into your content marketing strategy every step of the way. One of the best ways to keep yourself and your team on track is to use  a tool that's already integrated with your marketing automation platform. This will give everyone visibility into what keywords your team is using, how they're using them and how your content is performing. 
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.)

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.
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.
Increase Clicks: If you have a niche site that has high quality scores and impression shares, but not enough volume to spend your budget, you will want to increase the traffic sent to your site while maintaining control over click costs. This can be done by increasing bids, expanding your keyword list, improving click through rates and refining ad copy. All of these items can be adjusted/improved upon to help reach your budgeted spend.
Some examples of typical insights from this document would be the average number of referring domains that our competitors have and how that relates to our own backlink profile. If we are ahead of our competitors regarding backlinks, content creation might be the focal point of the campaign. If we are behind our competitors in regards to backlinks, we know that we need to start a link building campaign as soon as possible.
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.
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.
AdvertisingNot only does advertising copy tell you a competitor's price and other product information, it provides an indication of your competitor's entire promotional program and budget. When reading a competitor's advertisement be sure to note the following: publication, frequency, special offers, product features and benefits highlighted. If your competitor suddenly places an advertisement in an industry publication that neither of you are currently selling to, it's an indication that they're trying to reach a new market segment. It's also important to notice the design and tone of your competitor's advertisements. What kind of image do they convey? How does your own image compare? Are their advertisements in color while your own are black-and-white? Even if they're not, a clever advertising campaign can communicate that your competitor is an innovative, fresh company.  
"Since consumers know what they are looking for, you can optimize your content around the core needs and problems your target audience experiences. It is your job to build an SEO strategy by knowing what your customers are looking for. This will allow you to create relevant content that your customers want to read, and as a result, your content will rank higher in Google."
4. Choose keywords based on more than just high search traffic. Depending on which strategy you’re using, branding or conversion, you should not fall into the trap of just looking at search volume when judging which keywords to use. Just because one keyword has a whole lot more searches than another doesn’t necessarily mean it will be a better performing search term. Take the time to analyze other factors that provide more granularity. Here is an example of other factors you may want to look at:
Research: These searchers are further down the funnel than informational searchers. They’ve already decided that they want to buy a product, but they haven’t quite decided which one is best. They’re looking for more information, so product keywords usually include words such as "review", “top 10”, “comparison”. And while it may look like spam to you, a word like “cheap” can actually help turn researchers into conversions.
xAd’s first step was to expand its use of location data. “We wanted to move beyond just the where, and use location data to define the who and the what of audience targeting,” Monica Ho, xAd’s CMO, told GeoMarketing in 2015. After all, while a consumer’s proximity to a Denny’s can be significant, targeting someone who has been to and enjoys their local Denny’s will often prove more successful — whether or not they happen to be near the restaurant at the time they see the ad.
While doing the marketing competitor analysis you have to consider everything in SWOT. For that, you need to assess the external factors. This is where the PEST analysis comes into play. By doing the PEST analysis, you are getting to know how your competitors will react when there is a change. Will they consider that change an opportunity to do better or see it as a threat? This will give you an idea as to how your rivals operate. You can even base your marketing strategy on their ideas. Supposing there is a social change and your competitors cannot deal with it. However, your firm can. So you will try to strategize to take full opportunity of that social change so that you come out better than your opposition.
Quality of linking root domains. Here is where we get to the quality of each site’s LRDs. Using the same LRD data you exported from either Moz’s OSE or Ahrefs, you can bucket each brand’s LRDs by domain authority and count the total LRDs by DA. Log these into this third sheet, and you’ll have a graph that illustrates their overall LRD quality (and will help you grade each domain).
Use the search intent of a keyword to help determine what sort of page it should be used on. Informational keywords should be used on pages optimized for a branding campaign with content such as how to guides or product comparison articles. Avoid using these pages to target more specific in-market keywords. Those searchers have no use for a how-to guide or product comparisons. Use those to target your product pages that include specs, reviews, options and, most importantly, price and the "buy now" button. Of course, the “buy now” button could also be the email sign-up page or contact information form, depending on the type of goals you’re targeting.
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.

The first step in this process is determining who are the top four competitors that we want to use for this analysis. I like to use a mixture of direct business competitors (typically provided by my clients) and online search competitors, which can differ from whom a business identifies as their main competitors. Usually, this discrepancy is due to local business competitors versus those who are paying for online search ads. While your client may be concerned about the similar business down the street, their actual online competitor may be a business from a neighboring town or another state.

×