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.
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.
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.
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.
We at SEMrush continuously monitor Google’s updates, as the search engine rarely stands still. While testing the updates that are most likely to impact advertisers, we have come to the conclusion that Google is moving in the direction of “autopiloted” campaigns. The message is clear, the more you delegate to Google Ads’ artificial mind - bids, placements, banner sizes, etc. - the more benefit you and your customers will get from the campaign.
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.
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.
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.
John Boyd, a famous military strategist, thought a lot about how competitors change the way that we strive for our own goals. The concept he popularized around the OODA loop talked about making decisions faster than your competition as a way to win. It was also key to understanding what your competitor values so you can find other ways than fighting directly.
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
This analysis should help you holistically identify areas of opportunity available in your search landscape, without having to guess which “best practice” you should test next. Once you’ve started this competitive analysis, trends among the competition will emerge, and expose niches where your site can improve and potentially outpace your competition.

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.


The best way to see what geotargeting can do for your company is to undertake a test campaign on a site like Facebook employing the parameters that would best access your target audience in various parts of the country. Include the specified area(s) within the ad’s content and launch it to see how it impacts results at your various locations and your online business. From there, you can further expand on what the technique can do, even using it as a recruitment tool to locate new marketing talent to run your next geotargeting campaign.
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.
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.
Tertiary Competition: This category includes businesses that are tangentially related to yours, and really comes in handy when you’re looking to expand your product catalog. These could be related products and services that are trending, as well as businesses that may be beneficial to partner with further down the line. For instance, if you sell jewelry, a tertiary competitor may sell gems and stones.
As UX designers, we should go out there and collect as much data as possible before building a real product. This data will help us to create a solid product that users will want to use, rather than a product we want or imagine. These kinds of products are more likely to succeed in the market. Competitive analysis is one of the ways to get this data and to create a user-friendly product.
Some very general words such as “marketing” or “business” are very competitive, making it harder to rank well for them in search engine results. If you are a small- or medium-sized business, you probably want to choose less competitive keywords, more specifically related to your business (these are commonly referred to as long tail keywords). The greater the volume of searches on a keyword, the more competitive it is. There are a number of different tools you can use to determine thecompetitiveness of a specific keyword as well as suggest and help you brainstorm new keyword ideas.
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.
Keyword competitiveness lets you know which keywords often show up on other websites. This usually means that your keyword strategy concept exists on other sites. For B2B marketing and SEO, keyword competitiveness is a little different. Since keywords and themes are more specific, there’s a lower chance of other sites using the same keywords. Of course, remember that most B2B companies write about similar issues and concepts.
Michiel wrote about Homepage SEO, telling people not to try and rank their homepage for a specific keyword. In the comments there were clearly some misconceptions about how branding relates to your keyword strategy. We’ve been writing a lot about keyword research lately but we’ve not talked about keyword strategy much, so this post elaborates on what these are and how they connect to each other.
This helpful tool scans your backlink profile and turns up a list of contact information for the links and domains you'll need to reach out to for removal. Alternatively, the tool also allows you to export the list if you wish to disavow them using Google's tool. (Essentially, this tool tells Google not to take these links into account when crawling your site.)
×