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.

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.
1. More Powerful Personalization, Targeting and Campaign Analysis Capabilities: The capability for ever-more-specific PPC ad personalization and targeting (plus re-targeting) is available, but underused. You can, of course, target demographics and persona characteristics like age or income, customer type or purchase history/level (existing, repeat, prospect), sales funnel position, company role (for B2B ads) and more. Beyond these basics, you can now map the customer journey, learn how the visitor came to you and/or see much of the path taken to buy. This “attribution” insight can significantly improve the ROI of your 2018 campaigns; you’ll see what’s working and what isn’t, for better PPC strategies.
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.

a) Look for any gaps ("0's") on you score sheet and try to fix them. Yes, to an extent–an "ideal" score would be all "4s" down your brand's column. However, that's not always possible and highly unlikely. That said, it might not be the most pertinent thing to address technical SEO issues if you can see that your area of greatest weakness is, for instance, building an audience. Look for the greatest difference in performance between your brand and your competitors, which will illuminate what their main legs-up are.
Geotargeting is the practice of delivering content to a consumer — via mobile or web — using geographic location information about that individual. At a basic level, a business can restrict its reach to consumers only located in a defined geographic area such as a state or a city. But location often provides much deeper, more meaningful and identifiable traits that tell you what a person wants, needs or is interested in.
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.)
For example, it’s important to look at the response based on urban, suburban or rural locations. Someone living in northern Indiana may consider driving 25 miles to your store to be no big deal. Most customers or prospects could make the drive in less than half an hour and, therefore, they will visit your store. However, if the prospects live in the River North neighborhood of Chicago, they aren’t going to want to go to your store in Wrigleyville because that’s going to take 50 minutes.
In writing the summary and the presentation for the competitive analysis that I did for this collaborative note-taking app, the competitive analysis matrix helped me a lot. I drafted a document with all of the high-level takeaways from this analysis and answered all of the questions that were set as goals. For the presentation, I shared the document with the client, which helped both the client and me to finalize the features, the flows and the end requirements for the product.

All sorts of companies in all sorts of industries can make use of geo-targeting.  By refining the ad copy to include the city name and a reference to the current weather – for example, including the words “start sleeping cooler” in an ad during periods of hot weather – Purple Mattress, an ecommerce bedding brand has been able to generate higher click-through rates by online shoppers. In an effort to update its aging "Let's Go Places" campaign,  Toyota incorporated city-specific information into each of its Google ads, encouraging consumers to go to places and attractions near them.  Whole Foods targeted ads to the smartphones of consumers visiting nearby supermarkets, encouraging them to come to a nearby Whole Foods nearby exchange for better deals.

Informational: These keywords represent the very beginning of the conversion process, and are not very likely to convert on the first visit. If you’re running a branding campaign you’ll want to be sure to include informational keywords on your list. If you’ve got a conversion goal, you still can’t afford to ignore these keywords as they make up the majority of searches. Informational keywords often use words/phrases like "how to", “do I need” and “where to find”. Consider these leads to be converted later via your website or a retargeting campaign.


Instead of immediately sponsoring a Search Engine Marketing (SEM) campaign for certain keywords, keep an eye on your competitors for the best moment to do it. An SEM campaign implies a daily expenditure that most companies can’t afford long-term, so they won’t keep it up for long. If you are determined to spend some money on it, don’t just go crazy and then measure your ROI. After 3 – 4 months of watching, you should know if it’s worth it for your business to spend money on search engine ads. For an advanced strategy, try to identify your competitors’ timing for purchasing search engine ads, and try to replace them when they are not actively sponsoring results.
Once you’ve established some broad categories you should now look at direct competitors to your product. These include any company that sells a very similar or identical product or service in the same footprint as your organisation. For example; if your company sells Cable TV service, you would only list your competitors as those offering a similar service that your customers can also purchase. If the competitor’s service does not extend to your company’s geographical footprint, there may be no point including this competitor in your analysis. Their product offering however may be interesting and you may include it in a Product Comparison paper.
Ad scheduling is important for optimizing your ad strategy. You can show your ad whenever a customer searches online or you can show your ad on certain days, or during business hours when you’re there to handle customer inquiries. Your ads give different performance result on different days of the week and different hours of a day. Therefore, have a look at which online days and hours are most suitable for your business and then schedule your ad during these times to increase your exposure. You can also adjust your bid for less performing hours and days.
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.
Using geo-targeting, you use smart marketing tactics. A great example of a successful use of area segmenting is evo, an e-commerce sporting goods store. When they took the leap to open up three brick and mortar stores. Their first step was to send out an email blast for a $200 shopping trip to users in the area. Though the campaign had a 58% conversion on mobile users, the campaign wasn’t as effective at driving traffic to their store fronts.
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.
Geographic targeting allows your ads to appear in the locations that you choose: country, city, areas within a country or city, a radius around a location, or location groups. Geo targeting helps you focus your ad campaign on the locations where you’ll find the right customers, and restrict it in locations where you don’t, which could help increase your ROI. Right geographic region can significantly help you optimize your campaign for better results. Identify countries, states, regions, or areas where your ad campaign can perform well.

When you conduct your competitive analysis, it's worth analyzing the sales models of your competitors. In his article Three SaaS Sales Models, Joel York describes the three most common SaaS sales models based on the relationship between price and product complexity. Companies with low priced and low-complexity products must focus on developing a self-service option so they can maintain a healthy relationship between customer acquisition cost (CAC) and customer lifetime value (CLV). Slack, Trello, Dropbox, GitHub are all low-price, low-complexity products.

The answers remain to be seen, but there’s one no brainer in all of this; one best practice that can dictate any brand’s choices around location-based marketing: ask your users. Explain why you want to target them, tell them how you plan to use their data, and make some commitments about how you won’t use it. Ask for feedback via quick polls, or consider doing some market research on your audience. See what your users most want. Then respect that.
Geofencing hinges on the use of a “fence”—a designated area that a marketer sets. Where geo-targeting allows you to get more granular and include or exclude certain users in the target area (based on demographic, for instance), geofencing is a bit more of a blunt object in that you’ll capture all users who move into a certain area. The purpose of creating a geofence is to target communications in a given zone, in a given context—just like geo-targeting, but with greater accuracy. Retail operators who want to catch the attention of shoppers as they pass by a store, for example, might use geofencing.
As you consider new ideas for your next project or business, give extra credence to the things you believe to be true that others doubt. The most exciting products are created by people with tons of conviction for something that strikes most others as odd. I’ve heard from Joe Gebbia, co-founder of Airbnb, that when he and his co-founder Brian Chesky pitched the idea of having strangers sleeping in your home when you weren’t there, many investors shifted uncomfortably in their seats.
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.

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.
But what is a brand keyword? A brand keyword is the keyword used to search for a company name. The term branding stems from the literal act of branding cattle with a hot brand. You “mark your ownership” by branding a cow. You can “own” a product group too by putting your brand on it. Our brand is “Yoast”. It’s not “WordPress SEO”, nor is it “Google Analytics”. Those are keywords. We have one brand and we’ve slowly moved all our product names to be completely branded too, instead of generic. You might have noticed our WordPress SEO plugin is now called Yoast SEO and the same is true for our Google Analytics plugin, which is called Google Analytics by Yoast.

Understanding which websites already rank for your keyword gives you valuable insight into the competition, and also how hard it will be to rank for the given term. Are there search advertisements running along the top and right-hand side of the organic results? Typically, many search ads means a high-value keyword, and multiple search ads above the organic results often means a highly lucrative and directly conversion-prone keyword.

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).
You may be wondering why these seemingly different strategies are included as one. The reason is that the strategy is the same: Getting the most out of your budget. The only difference is the tactics to achieve that strategy. Sure you may need to look at different metrics and dimensions of your campaigns to maximize your budget, but in the end you achieve the same thing.
Keywords are the crucial foundation for online marketing efforts, and in this course, author Matt Bailey shows how you best structure search engine optimization and pay-per-click plans around the insights you glean from keyword research. He helps you explore the sources for keywords and build a keyword list with research and management tools like Raven Tools, Moz, SEMrush, and Wordtracker. He shows you how to filter and interpret keyword data, observe trends, and better understand the intent of the searcher, and how to develop an informed strategy and implement keywords throughout your site for maximum searchability. Matt also covers how to apply your keyword insights to Google AdWords campaigns and measure the results of your SEO and AdWords efforts.
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.

Instead, SEO now takes a multi-faceted approach where you’re involving different disciplines (i.e. content, email, advertising, social), building a brand (i.e. investing in intangibles, not just conversions), and competing on multiple fronts (i.e. paid search positions, review & aggregation sites like Yelp, TripAdvisor, beefing up your local listings, and more) – all at the same time.


You can also find articles written about companies in local newspapers or on a Nexis file. Online databases are available from soures such as the U.S. Securities and Exchange Commission and Standard & Poor’s and news sources such as PR Newswire, and as we'll explain in this article, you can use search engines to find information on individual companies.

I remember my very first week working at Hanapin Marketing. I was working in a REDBOP group (for information on what REDBOP is, see “super awesome opportunity” in the dictionary and you will find information on Hanapin’s monthly PPC training program) and we were tasked with explaining to the rest of the team the differences between tactics and strategy. Easy peasy. Strategy = plan. Tactics = action.


In this example, competitor #1 is rated higher than competitor #2 on product innovation ability (7 out of 10, compared to 4 out of 10) and distribution networks (6 out of 10), but competitor #2 is rated higher on customer focus (5 out of 10). Overall, competitor #1 is rated slightly higher than competitor #2 (20 out of 40 compared to 15 out of 40). When the success factors are weighted according to their importance, competitor #1 gets a far better rating (4.9 compared to 3.7).
It’s also best to look for those businesses that are of a similar size as yours. For example, if you’re a solo entrepreneur selling handmade potholders online, big chain grocery stores usually aren’t your direct competitors, even if they might carry handmade potholders in their inventory. Instead, look for other small to medium scale producers of handmade potholders and similar kitchen accessories.
City advertising[19] by advertising on web sites with extensive content related to particular cities. Such web sites can connect large city audiences with products/services for sale in those cities. Surfers searching for information about particular cities find adverts at such web sites as a result of city name related searches rather than product/service keyword searches. In this way businesses, e.g. shops, restaurants, can advertise and reach out to consumers located in the real-world localities of their product/service offerings.
Need some keyword strategy help while actually creating your posts? If you use WordPress to manage your site content, the Yoast SEO plugin analyzes each post and offers suggestions for improving page content as you prepare your post for publishing. While it’s not a silver bullet that will guarantee good results, it does offer helpful tips for improving your post once it’s in WordPress.
It’s actually ideal to use just one keyword per ad group. This is known as a single keyword ad group (SKAG). Try using this strategy, even for large accounts, with 80 percent of keywords that get or you expect to get the most traffic. You should most definitely employ this strategy for keywords that are getting the dreaded “Rarely shown due to low quality score” warning.
Geo-Targeting content is simple and beneficial to most websites, advertisers and publishers, as well anyone using PPC campaigns or SEO. Not only does it enable you to match the most relevant content to your visitor, Geo Targeting also serves as an excellent basis for experimenting with traffic to optimize your funnels. Some ideas were presented here that may be tested, but the options are virtually limitless.
Ad scheduling is important for optimizing your ad strategy. You can show your ad whenever a customer searches online or you can show your ad on certain days, or during business hours when you’re there to handle customer inquiries. Your ads give different performance result on different days of the week and different hours of a day. Therefore, have a look at which online days and hours are most suitable for your business and then schedule your ad during these times to increase your exposure. You can also adjust your bid for less performing hours and days.
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.
No, but you will need to have completed keyword research beforehand - and I mean thorough keyword research, not a bullshit download from Google Keyword Planner. You will need to have a handle on the competitive metrics for your target SERP's. If you have no idea how to get these, I strongly encourage you to also check out my course Master Keyword Research.
IT is more cost-effective to target already existing demand to increase your market share for more qualified leads. For more tips on how to prioritize your keyword strategy and your comprehensive search campaigns, check out Directive’s Complete Guide to B2B Marketing and Demand Generation. And be sure to subscribe to our blog for weekly updates on the most innovative industry-leading tactics!

If you want to become a better UX, interaction, visual (UI) or product designer, there are a lot of sources from which you can learn — articles, books, online courses. I often check the following few: Smashing Magazine, InVision blog, Interaction Design Foundation, NN Group and UX Mastery. These websites have a very good collection of articles on the topics of UI and UX design and UX research.
In particular, strategy is how the team aligns so that decisions made at any level are likely to be better for the longer term goals of the organization. If you don’t have that alignment, you will be constantly struggling to move the organization ahead, together. A well-executed competitive analysis provides the framing for how your group is the best one to take on the challenges and opportunities ahead.
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.
Conduct a business download meeting. I meet with key stakeholders to learn everything I can about the business and the industry they compete in. Is the business itself growing or struggling? What about the industry as a whole? I use this time to learn what has worked and not worked from a PPC perspective and to determine if PPC performance goals are realistic and achievable (or if they exist at all).
Do they have separate marketing messages for different segments? Sometimes, you might see a stark difference between how your competitor markets their business for one type of customer versus how they present themselves to another type of customer. For example, if you're trying to sell services as a math tutor to high school students who are struggling to pass their math subjects, you'll be making a completely different pitch than you would to those students who need additional help with their SAT math so that they could get into prestigious universities. Your message to the struggling students might be closer to "I'll help you finally pass your math tests!" While your message to the other market will be similar to "I'll help you get into the school of your dreams!" Also, be sure to note if your competitor does something similar with their own customer segments. 
Say our real estate marketing business really starts to blow up. We make a few new hires and start to divide Manhattan up into regions, with each new employee responsible for a new section. Each one is responsible for marketing within their region. We can easily carve out an “excluded” area within any local awareness region to, for example, exclude a particular zip code that we’re not responsible for from our ad’s targeting. That lets us save money by not targeting customers that we don’t really want to be attracting:
So, fellow marketers, the secret is out—now you know that the key to really driving your conversion rate isn’t in minor copy or bidding adjustments. The true PPC CRO best practices require you to use negative keywords and to target keywords that your bottom-of-the-funnel prospects are searching for—including those that are pricing and service-oriented. You want to use high-converting ad formats, such as Google Shopping Campaigns and video ads, to capture the attention of your audience and engage them. Your landing pages should be designed well, easily browsable, and have fast loading times. It’s also important to personalize your ads so that your potential customers feel like you’re speaking directly to them, which also helps humanize your brand. Finally, use retargeting to remarket your products and services to previously interested visitors to your website, enticing them back and convert. 
He is the co-founder of Neil Patel Digital. The Wall Street Journal calls him a top influencer on the web, Forbes says he is one of the top 10 marketers, and Entrepreneur Magazine says he created one of the 100 most brilliant companies. Neil is a New York Times bestselling author and was recognized as a top 100 entrepreneur under the age of 30 by President Obama and a top 100 entrepreneur under the age of 35 by the United Nations.

Now, to figure out state and postal code involves a more complex process. At the ‎core though, the geolocation services build up a network of servers from which ‎they can send out pings, or connection requests, and known physical locations of ‎public entities like universities and government office IPs.  Eventually, with enough ‎data, the geolocation company has the capability to triangulate any IP on the web.   ‎

Geo-Targeting content is simple and beneficial to most websites, advertisers and publishers, as well anyone using PPC campaigns or SEO. Not only does it enable you to match the most relevant content to your visitor, Geo Targeting also serves as an excellent basis for experimenting with traffic to optimize your funnels. Some ideas were presented here that may be tested, but the options are virtually limitless.
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.
×