“Now that the “algos” are perfected, they can be used for accounts as small as 100$ monthly ad spend. While it’s difficult for the small guys to access machine learning on their own, agencies who are servicing SMBs should use tools like ours to manage, optimize and scale multiple accounts. Google Channel Partners, Publishers and Resellers that service hundreds of small-business PPC accounts benefit from our machine learning technology already.”

L’Oreal did something similar when it used geolocation technology to create a virtual art exhibit that allowed attendees to uncover the art and feel as though they were right there looking at it. Brands can also use geolocation technology in mobile apps that include gamification aspects to engage a user more fully in a particular product or service.
To more effectively drive traffic to their stores, they pushed out a 10% discount on any in-store purchase when customers provided their email. This not only drove traffic to their new shops, it also helped them construct lists for each store that they could later use for store promotions. By targeting these specific users in areas near their stores and then promoting to in-store audiences, an e-commerce site successfully made the move to store fronts. Read the full evo case study here!

Great question. You could adjust the formulas but I find it easier to highlight the full report (after it is populated with your data) then copy it and paste "values only" this way none of the formulas break. Then go into the navigation of google sheets and select "Data" then "Filter". You will now have filtering options on all of the headings. Then you can simple select your website and uncheck "Yes" so you only see the domains that do not link to you. Give that a shot and let me know if it works for you.
Your CompetitorsYou probably see the owner of a rival organization at trade shows, association meetings, and perhaps even socially. You can garner a great deal of information through a simple, friendly conversation. People like to talk about themselves and share their success stories and concerns with business associates. Assign someone to check the competitions' Web sites regularly for pertinent changes and news. (And take a good look at your own: Do you say anything there that you'd just as soon not have your competitors see?)  
"My favorite part about voice search is just how clear the intent is in the query. For example, if I typed in 'hotels in the Bahamas', you’d have no idea whether I was looking for a romantic getaway, a singles trip or a family vacation. Chances are the results would be different for each. But if I asked Cortana, 'which are the best family-friendly hotels in the Bahamas,' then a far more targeted result could be served.
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.
Export the weighted list back to your spreadsheet and combine it with the others in Excel. Then use the data tools to sort the list by ‘Priority’ – this is a score based on the difficulty, traffic, opportunity and your score. This tells you which keywords you should be targeting in descending order of attractiveness. Suddenly, you’ve turned more than 1,000 keywords into a usable list of a few dozen. Using the same example for wines:
Great question. You could adjust the formulas but I find it easier to highlight the full report (after it is populated with your data) then copy it and paste "values only" this way none of the formulas break. Then go into the navigation of google sheets and select "Data" then "Filter". You will now have filtering options on all of the headings. Then you can simple select your website and uncheck "Yes" so you only see the domains that do not link to you. Give that a shot and let me know if it works for you.
In reality, even profitability focused campaigns will have limits when it comes to budget, so our focus is often maximizing profitability within the budget we have allotted. This can mean bringing in fewer conversions at a lower cost per acquisition (CPA) and eliminating elements of campaigns that are under performing compared to your acceptable conversion goal. Mining search query reports, establishing negative keywords, bidding down on keywords with high CPA’s or no conversions are all techniques we employ in order to maximize our profitability within the parameters given.
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.
Test putting the location in the ad copy. If you’re a local business, there’s a chance that people want to find you locally. Who cares about a tire repair shop in Massachusetts if you’re in Denver? Because of this, putting the location in your ad copy can give you an edge. If necessary, run multiple campaigns with each specifying the individual location.<
Use Google Keyword Planner and your list of potential search ideas to create a list of terms/phrases that align with your brand and that, ideally, aren’t highly competitive. Google ranks competitiveness in Keyword Planner, seen above. You can also get an idea of how competitive a keyword search is by looking at the price of the suggested Adwords bid. Competitive search terms are typically much harder to rank for.
The assumptions that a competitor's managers hold about their firm and their industry help to define the moves that they will consider. For example, if in the past the industry introduced a new type of product that failed, the industry executives may assume that there is no market for the product. Such assumptions are not always accurate and if incorrect may present opportunities. For example, new entrants may have the opportunity to introduce a product similar to a previously unsuccessful one without retaliation because incumbant firms may not take their threat seriously. Honda was able to enter the U.S. motorcycle market with a small motorbike because U.S. manufacturers had assumed that there was no market for small bikes based on their past experience.
Limiting your organization to direct competitors only might lead you to a very narrow view of the market. This framework allows you to evaluate companies that aren’t just your direct competitors but companies that could easily move into your turf. You want to consider companies that aren’t currently in your category but could potentially leverage their product or technology in your space.

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:


WooRank is a freemium tool that provides an “instant website review.” Without a premium account, you are only allowed to generate a limited number of free reports, but you are able to view previously generated reports. Also, the tool currently offers a 7-day unlimited free trial, which gives you access to unlimited reviews. If you’re interested in purchasing a plan, the cheapest one is $49/month.

It’s easy to notice what your competition is doing wrong, but what about the things they’re doing right? In order to compete, you must dissect all aspects of your competition by completing a SWOT analysis.  What are their customers happy about? What are they complaining about? Use this opportunity to dive into some qualitative competitor analysis. Go online and gather YouTube and Facebook comments, check out conversations on Twitter. If you can interact with your competitors’ customers face-to-face, go out and talk to them. You can use all of this information to your advantage.


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]

HubSpot also has a campaign tool that allows you to associate keyword phrases, related blog posts, emails and landing pages with a particular campaign so you can get a better idea of the overall performance. If a particular set of keywords doesn't seem to be bringing in new site visits or converting leads to customers, it might be time to search for alternatives.  
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.  
If not, you’ll need to determine how close to being profitable you are. If it would only take one or two more sales or leads to turn a profit, it’s time to start optimizing your PPC campaign so you can cross that threshold sooner rather than later. Start adjusting your landing page (perhaps with the help of A/B testing), your ad text, and your keyword strategy until you find a winning combination.

Keyword research is a time consuming and continuous activity. Create your list of core keywords at the time of campaign planning and you should constantly refine and expand your keyword list for long-tail, low cost and highly relevant keywords. Another important step in keyword research is to review high cost, under performing keywords. Remove these keywords from your list.
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.
Keyword research is a time consuming and continuous activity. Create your list of core keywords at the time of campaign planning and you should constantly refine and expand your keyword list for long-tail, low cost and highly relevant keywords. Another important step in keyword research is to review high cost, under performing keywords. Remove these keywords from your list.
Estimated Costs: Creating content to adequately target specific keywords will require varying amounts of time, money, and effort. In some situations, you might find that targeting a certain keyword also allows you to SEO your landing page at the same time. So be on the lookout for shortcuts that might make ranking for a keyword more cost-efficient than it would otherwise be. That’s how you can find real money-makers!
Gather Competitive Information Secondary sources of information are recommended as an excellent starting point for developing a competitive and industry analysis. Secondary sources include information developed for a specific purpose but subsequently made available for public access and thus alternative uses. For example, books are secondary sources of information as are articles published in journals. Marketing reports offered for sale to the general public also are considered secondary sources. Although, they have been created for a purpose other than your current need, they are still excellent sources of information and data. With the ever increasing speed of document identification and retrieval through electronic means, secondary sources are not only an inexpensive source of information but are readily available soon after publication. Sources of information include:
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).
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.
×