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.
Every time a search is initiated, Google digs into the pool of bidding AdWords advertisers and chooses a set of winners to appear in the ad space on its search results page. The “winners” are chosen based on a combination of factors, including the quality and relevance of their keywords and ad text, as well as the size of their keyword bids. For example, if WordStream bid on the keyword “PPC software,” our ad might show up in the very top spot on the Google results page.
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. 

And so on and so on. The point of this step isn't to come up with your final list of keyword phrases -- you just want to end up with a brain dump of phrases you think potential customers might use to search for content related to that particular topic bucket. We'll narrow the lists down later in the process so you don't have something too unwieldy.
Megan Malone is a Founding Partner with Vici, and leads our Operations division. Megan has both a radio and digital marketing background working for the Philadelphia Eagles, Beasley Broadcast Group, and Cox Media Group. In her career she has helped plan and implement thousands of digital media campaigns. She holds a certification from Disney Institute’s People Management, and was awarded the top 10 advertisers in Louisville from the American Advertisers Federation.
They differ in many aspects, from gender to age; from organic to paid; from 1024×768 to 320×480 and onwards. More significantly though, people arrive to your site from across the world: from different countries and languages, different currencies and climates, and a whole assortment of cultural expectations. Hence, even if you have a “.com” English only site, you may very well be an international business by default.
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.  
One of the major promises of enterprise PPC management tools is that they employ bidding strategies that will save you all kinds of money by trimming down your cost per click through intelligent bid algorithms. These algorithms often let you adjust bids by just about any variable available in the AdWords/Bing API’s (you can even create calculated metrics) and adjust bids according to these rules in order to reduce costs. What they usually don’t tell you is the best way to set them up or provide algorithms to you that work out of the box. They give you the fishing line, but don’t always teach you to fish. They are a tool, and what we need is a PPC strategy.
John Lincoln is CEO of Ignite Visibility, one of the top digital marketing agencies in the nation and the number 698 fastest growing company in the USA in the 2017 Inc. 5000. As a digital marketing expert and in-demand public speaker, Lincoln is consistently named one of the top influencers in the industry. In 2017, he was the recipient of the Search Engine Land "Search Marketer of the Year" award. Ignite Visibility crafts custom digital marketing strategies for clients, including services in SEO, social media, paid media, email marketing, Amazon and more.
You cannot expect your employees to stick to their schedules and stay organised if the person at the top doesn’t do the same. As the leader of your start-up, you need to set an example for your staff, which means that you have to be the most organised person in the company. While it is important to ensure your employees follow suit, try not to be too overbearing about how they choose to organise their days.

No matter how marketing-savvy your company may be, you can always learn more about your customers, especially when it comes to personalizing your advertising. That’s where geotargeting can again be beneficial. The information received from geolocation can help a brand determine where a consumer is looking so it can better tailor events, products, and services to those consumer interests in the near future.
It’s critically important to ensure you are collecting good data, and to do this you must correctly configure Google Analytics and Google AdWords to share data. It is important that this is customised to your reporting needs and individual objectives as you can then use that data to optimise your campaigns. This chapter outlines how to measure your campaign to enhance your PPC strategy.
2. Define how will you measure success. This is probably one of the most important questions to answer before you begin any campaign. As a consultant, this is one of the first questions I ask a potential client. The answer as you might expect is page one ranking. If your objective is branding only, then this is fine, however, if like most organizations yours is a conversion strategy, then I would caution you to not be so short-sighted. Your objective should be how many conversions you want to achieve for each keyword. Top ranking will help you with visibility, which is a good thing, but if you bring in traffic from that keyword and those visitors do not engage and convert, then why bother? You must set your sights on keywords that convert.

Still in the early phase of rollout, Store Visits is being added to the Adwords Estimated Conversion tool in order to track in-store visits directly from your AdWords account. According to a recent Google study, 32% of offline customers said that location-based search ads led them to visit a store or make a purchase. For businesses with physical stores, this tool could really help to show how your PPC ads are affecting your overall bottom line and marketing initiatives. To be eligible for the feature you must meet the following criteria:


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.
Sales BrochuresSales brochures provide a wealth of product information. You can learn how your competitor is positioning their product and company and what features and benefits they're using to sell their product. Try to obtain all new sales brochures and literature your competitor publishes. Significant changes in the content will indicate that new strategies are being employed.  
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.

“The sales cycle is an average of 9-12 months. When a qualified lead enters the funnel, the revenue generated from that lead is an unknown variable that will not be fully identified until several months into the cycle. In order to increase the probability of a PPC lead turning into a viable source of revenue we need to generate leads at a ratio of high ratio of sales quality leads to conversions (roughly 65%). We will continue to test new targeting in order to reach our 20% YoY growth goal at a reasonable average CPA in order to continually grow the account and keep the sales funnel full every month.”

You’ll often find your hottest leads among people who have already encountered your business once. Depending on your industry, it may be unlikely for people to purchase your product the first time they visit. If you’re an e-commerce operation selling lower-ticket items, you may be able to send people directly to a sales page with excellent results. But if you’re like the dishwasher store we invented above, visiting your PPC landing page may be one step in a larger research process for your customers.


But while many marketers understand the value of geotargeting, not many are ‎likely to understand how the technology behind it works.  Having a firm grasp on ‎the technology though is actually critical in this case, as different solutions take ‎different approaches to the problem of determining the physical location of a ‎consumer, and the simplest solution is usually the least accurate.  Just as traditional ‎strategies don’t always translate well to digital, many desktop strategies don’t ‎translate well to mobile.  ‎
Megan Malone is a Founding Partner with Vici, and leads our Operations division. Megan has both a radio and digital marketing background working for the Philadelphia Eagles, Beasley Broadcast Group, and Cox Media Group. In her career she has helped plan and implement thousands of digital media campaigns. She holds a certification from Disney Institute’s People Management, and was awarded the top 10 advertisers in Louisville from the American Advertisers Federation.
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.
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.
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.

Brands love to be front and center and who can blame them? Essential to becoming a well known brand is achieving awareness and name recognition, and well branded companies tend to do well at drawing in new customers. In the world of search, the best way to build your brand is by showing up in the top position of search results. Preferably you can do this for both organic and paid results, but at the very least you can often buy your way to the top of search results with a high enough Maximum CPC bid. You will also want to enhance your brand even further by adding Sitelinks to your account to showcase the depth of products and services you offer and occupy even more real estate in search results.
It’s important to classify your keywords. You should distinguish your most important high level keywords, the ones that have sufficient traffic for your business and connect the best to your business. These are usually more “head” than “tail”. You should only have a few of these keywords for your business. The rest of it are bound to be more down the tail. If you don’t know what I’m talking about, go read up on long tail keywords.
Your campaigns are the foundation of your structure. You will probably only have a few campaigns, which is fine. The less you have, the more manageable it will be. Start small and only expand when it makes sense to. You could have a campaign for each type of chocolate (fair trade, milk, white, dark, vegan) if you were a small chocolate shop for example. You could have a campaign for sale and non-sale items as well. You have to decide what makes sense for your small business.
Lastly, if you have the opportunity, maintain the competitor review and analysis every 6 months. It provides you with an external perspective. Competitive analysis needs to be integrated with other product management and marketing activities. Overly concentrating on what competitors are doing can distract you from remaining focused on your customers.
Use the Keyword Planner to flag any terms on your list that have way too little (or way too much) search volume, and don't help you maintain a healthy mix like we talked about above. But before you delete anything, check out their trend history and projections in Google Trends. You can see whether, say, some low-volume terms might actually be something you should invest in now -- and reap the benefits for later.
As with any Split or Multivariate testing, modification of the visual elements can make a big difference. Similarly, testing different design elements based on the visitor’s location may enlighten about the funnel you’re testing. The way bright colors are interpreted by one culture on side of the planet may be vastly different to another. Think of holiday themes as an example, or national flags as another.
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.

SpyFu displays side-by-side data on your competitors' paid and organic search results, so you can easily see where it's more cost-effective to bid on a particular keyword as opposed to trying to rank for  it organically. That way you can use your time more efficiently by writing content around those keywords that drive a lot of traffic but are more expensive to bid on.


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:
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.

I always tell people to think of their site as a pyramid. Your brand is at the very top, below that is your cornerstone content for your “head: keywords, the keywords you care about the most, below those are dozens – if not hundreds or thousands – of pages, strengthening your site’s structure. I wrote about site structure & SEO over 3 years ago but it still rings true. We wrote about both these topics in our ebook too.
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.
To create a similar chart, start with your website goals and map them to a potential visitor’s goal. For example, you may want to generate more event space inquiries, which means potential visitors to your website would likely be searching for an event space. Now ask yourself: what do people searching for an event space type into Google? If I were looking for this type of product or service, how would I search for it on the web?
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.
- Hi, I'm Matt Bailey. Welcome to keyword strategy in depth. Keyword research is the fundamental building block, for all of your on-line marketing efforts. It goes beyond optimizing your website, to enabling a better connection when marketing to your audience, as you are using their language. We'll begin by finding sources for keywords, seeing how search engines deliver different results based on the types of keywords, and building your keyword lists. Next, I'll demonstrate how to effectively sift through the keyword data, in ways that maximize your ability to understand the searcher, and derive their intent. We'll see how to implement your keywords throughout the content of your website. Then, I'll demonstrate how to setup an initial Google AdWords campaign, utilizing your keywords, and avoiding the top five mistakes that companies make in AdWords. I've been marketing online for nearly 20 years, and I love to teach people how to be successful in their own businesses with the tools, tips, and experience I've learned along the way. Now, let's get started.
A competitor's media strategy reveals budget allocation, segmentation and targeting strategy, and selectivity and focus.[13][14] From a tactical perspective, it can also be used to help a manager implement his own media plan. By knowing the competitor's media buy, media selection, frequency, reach, continuity, schedules, and flights, the manager can arrange his own media plan so that they do not coincide.

Every time a search is initiated, Google digs into the pool of bidding AdWords advertisers and chooses a set of winners to appear in the ad space on its search results page. The “winners” are chosen based on a combination of factors, including the quality and relevance of their keywords and ad text, as well as the size of their keyword bids. For example, if WordStream bid on the keyword “PPC software,” our ad might show up in the very top spot on the Google results page.

One of the major promises of enterprise PPC management tools is that they employ bidding strategies that will save you all kinds of money by trimming down your cost per click through intelligent bid algorithms. These algorithms often let you adjust bids by just about any variable available in the AdWords/Bing API’s (you can even create calculated metrics) and adjust bids according to these rules in order to reduce costs. What they usually don’t tell you is the best way to set them up or provide algorithms to you that work out of the box. They give you the fishing line, but don’t always teach you to fish. They are a tool, and what we need is a PPC strategy.
Reliable lifts come from knowing your customer and tailoring the value proposition to match that customer’s motivations in a way that no other website will. You can enhance it with a bunch of human behavior principles (liking, scarcity, reciprocity, social proof, consistency etc.). But you have to have the foundation of what makes you unique, in order to get people return to you after they browse around.”
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]

Sales BrochuresSales brochures provide a wealth of product information. You can learn how your competitor is positioning their product and company and what features and benefits they're using to sell their product. Try to obtain all new sales brochures and literature your competitor publishes. Significant changes in the content will indicate that new strategies are being employed.  

A competitor's capabilities can be analyzed according to its strengths and weaknesses in various functional areas, as is done in a SWOT analysis. The competitor's strengths define its capabilities. The analysis can be taken further to evaluate the competitor's ability to increase its capabilities in certain areas. A financial analysis can be performed to reveal its sustainable growth rate.
Svitlana Graves Svitlana Graves is a digital marketer with a focus on conversion optimization. She enjoys combining in-depth customer research with data to conduct smart experiments. At the moment Svitlana is taking clients’ revenues to new levels as part of CRO Team at 3Q Digital. On a personal note, Svitlana loves Latin Dance and foreign languages. She speaks 5 and is learning her 6th.
It’s easy to get blindsided by our own opinion on “high-quality” content. You might be thinking you have an awesome idea that everyone wants to read about, but how do you know with absolute certainty that it’s really that great? And even if your hunch is spot on and you’ve discovered something truly worth sharing, how do you quantify its value? How do you find the right content marketing keywords?

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.
Another easy, yet possibly expensive, way of testing geo-location is using a PPC platform such as AdWords. You can set your campaign targeting to very specific locations and languages, as well as set the destination URLs of your individual ads. Similarly, this will require a set of landing pages for each campaign, but delivers results very quickly. You may be able to run a fast, data rich, and location-based conversion analysis with little more.
More importantly, take the time as you conduct your keyword research to segment and categorize your keywords to map to the right landing pages. If the page doesn’t exist on your site yet, then that is your cue to build a new page for that set of keywords. By doing this you will achieve the relevance that will lead to more engaged visitors and higher conversion rates.
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.
You will likely run into some difficulties along the way, and you may need to develop a hybrid strategy to achieve your goals. For example, I have often broken out campaigns between profitability focused keywords and brand focused keywords in order to satisfy clients. This is especially useful when someone demands visibility for certain keywords but does not give enough budget to achieve that visibility. The same goes for balancing visibility and profit.
Sometimes even the most savvy among us can feel like a confused great-granny on a MacBook Pro running Linux when it comes to the newest, latest tech, and how it actually works. Location-based marketing is already happening. All of the available tools provide opportunities to serve highly localized, highly relevant communications to your customers, based on where they are right now. But what exactly are those options, and how do they work?

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.
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.

With the constant stream of new betas, introduction of format changes (hello Expanded Text Ads!) and a multitude of new targeting methods such as tablet bid modifiers and demographic bidding for search, paid search marketing continues to become more and more complex. Gone are the days when running ad copy tests, adding negative keywords, performing bid adjustments, and launching more targeted ad groups was sufficient to drive account growth. Today’s paid search advertiser must choose from hundreds of available account optimization strategies.
It’s not easy to find information on market share. Large companies invest millions of dollars to investigate market share but most SaaS companies don’t have such resources. The best shortcut is to conduct a survey with a sample size of 200-300 respondents, asking them what tools and solutions they are using. That’s usually just enough to get a ballpark estimate of market share in the SaaS industry.

Great article. This ties in perfectly with the article I just published yesterday. This checklist in conjunction with my competitor analysis, that is more based on keyword and traffic data, will really round out the research stage of your campaign. Taking a deep look at a competitors website just like you would do your own, can be a valuable exercise that drives strategy.
×