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.
When using the Keyword Explorer, Ahrefs will also produce the "parent topic" of the keyword you looked up, as you can see in the screenshot above, underneath the Keyword Difficulty meter. A keyword's parent topic is a broader keyword with higher search volume than your intended keyword, but likely has the same audience and ranking potential -- giving you more a valuable SEO opportunity when optimizing a particular blog post or webpage.
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.
The same goes for PPC advertising. Potential customers who are targeted with your PPC ads don’t care about your need to fill your pipeline or your salespeople’s need to meet their quota—the truth is they only care about what’s in it for themselves. Cater to this by crafting your ad copy in the second person, keeping the importance on the consumer and not on your company.
Unless you have a budget to conduct formal research, its best to use available resources such as news articles, industry journals, analyst reports, the company’s website, marketing collateral, company reports and so forth. You may also want to do a general blog search to find out what their customers’ and others are saying about the company and the products they offer. Networking events and tradeshows also present great opportunities to collect data about your competitors. Your more loyal customers may also share information with you.
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.
Whether you’ve heard a little about PPC marketing and are curious to learn more, or you already know that you want to use PPC to market your business, but aren’t sure where to start, you’ve come to the right place! This is the first lesson in PPC University, a set of three guided courses that will teach you everything you need to know about PPC and how to make it work for you.
3. Mapping keywords to the right landing pages. One way to insure you get the best results from your keyword campaigns is to make sure there is very high relevance between the keywords you use and the associated landing pages. This is a very important principle. What happens when you click on an organic listing or a PPC add from a SERP (search engine results page) and the content has little to zero keywords on that page that you used to search on? Right, you bolt and head back and click on another link. Make sure your landing pages are optimized to handle your keyword traffic to make them relevant.
Although this process can be tedious and time consuming, it is essential in identifying where your competition may be surpassing you as well as what advantages you have over your competition. Developing takeaways will help identify these strengths and weaknesses. From there, you can improve your marketing plan by putting greater influence on the features your company offers and finding ways to implement features your company doesn’t offer that seem crucial to gaining customers.
HubSpot's marketing automation software has several tools just for this purpose.  The first is the HubSpot keyword tool, which allows you to keep track of keywords you're targeting. Once you've done your research and know which keywords are most likely to perform well, you can import those keywords into the tool. The tool will show you how you're currently ranking for those terms and whether your ranking is moving up or down over time. 
When looking at competitors for the PwC field service operations group there were lots of competitors (including paper printed out and stuck to the wall). What was interesting was that most of the competitors were originally independent companies, but then acquired by larger companies. What was most helpful was looking at how each organization’s strategy changed their end goals. In the case of Field Service Lightning it was originally about the CRM capabilities of SalesForce, but is now about the integration of machine learning for Salesforce’s Einstein.

"Cloaking" via IP delivery works differently from cloaking via "user agent". While IP address spoofing is harder than user-agent spoofing and more reliable, it is also harder to keep the list of IP addresses used by search engines for their crawlers up-to-date. An outdated list with active crawler IP addresses missing enables the search engines to detect the cloaking and may result in a removal of the site from the search engine's index.

Again, keyword strategy does not mean randomly sprinkling certain words throughout your website. In actuality, B2B marketing and SEO need a focused strategy to make a difference. The first step is identifying your optimization intent and tailoring it for B2B marketing and SEO.  Next, create a keyword theme with specified long tail keywords and research them. 
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.
The unique advantage of PPC marketing is that Google (and other ad networks) don’t just reward the highest bidders for that ad space, they reward the highest-quality ads (meaning the ads that are most popular with users). Essentially, Google rewards good performance. The better your ads, the greater your click-through rates and the lower your costs.
Protecting your company with one of the core barriers is smart. Nailing down two barriers is even better. Slack is a great example of a company that has a network effect, having successfully created widespread demand through word-of-mouth referrals and a highly engaging product. It has also invested in building strong relationships with developers. Slack’s developer platform roadmap and its commitment to transparency for developers has helped the company build a strong ecosystem around its product.
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.

The first case is quite simple yet happens often. So for example, you have not sold tandem bikes for years (and had the word “tandem” in a negative list), then you started to sell them again. But your PPC specialist forgot to remove the word from negatives, and now you are left wondering why you are not getting any traffic for this keyword. To avoid this situation, check your negative keyword lists regularly and bring the relevant keywords back to life.
Keywords are the words and phrases that people type into search engines in order to find what they're looking for. By extension, they also describe what a piece of content (or an entire website!) is all about, and they're the words at the heart of on-page optimization. They still play an important role in a site's ability to rank, so by identifying the right words and phrases to target you can have an outsized impact on achieving your SEO goals.
Beacons are little physical objects (under two square inches, in most cases) that can be placed in desired locations. Their sole purpose is to detect you, or more specifically, your device, as you move into their range. The beacons themselves don’t send content. Like geofencing, a signal is triggered when you’re near one, and a server sends a push, text, in-app message, or even an email (though currently, that’s a less likely application for beacons).
You can, for instance, target multiple areas specifically by their zip codes. Let’s say our real estate business explodes and goes nationwide and we want to look for the cheapest places to buy homes in America. We can look up a list of the zip codes with the cheapest homes and enter them as our targeting criteria, giving us a “geo-fence” that spans different communities and states:
Beacons are little physical objects (under two square inches, in most cases) that can be placed in desired locations. Their sole purpose is to detect you, or more specifically, your device, as you move into their range. The beacons themselves don’t send content. Like geofencing, a signal is triggered when you’re near one, and a server sends a push, text, in-app message, or even an email (though currently, that’s a less likely application for beacons).

You should also take time to ensure that your landing page is designed well, but not just in appearance. Be sure to focus on loading speed and usability as well. Together, all of these elements are crucial to the success of your campaigns. Afterall, you don’t want to spend all your time designing PPC ads only to have your leads bounce right off as soon as they reach your boring or unsightly landing page design—or worse, leave before it even has a chance to load.
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.

Geographically targeted ads can increase returns significantly over "blind advertising." On the Internet, clickthrough rates are improved compared with advertisements not targeted by location. The results in a given situation depend on the geographical distribution of potential customers, a variable that requires intensive research to accurately determine.
Best used to reach users who: live or move about in a certain area, for whom you have other data like preferences or demographic info	Best used to find users who: are nearby your store, venue, or service; users who are in your parking lot, or entering a mall, for example	 Best used to reach users who: are in a certain aisle of your store; who are on a certain bus or train; who are moving through a space like a museum

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.

IP delivery for search engine optimization (SEO) is the method of delivering different content to search engine spiders (also known as robots and crawlers) than to human visitors. The determination if the visitor is a known search engine spider is done based on the IP address. SEOs compare the visitor's IP address with their list of IP addresses, which are known to be servers that are owned by a search engine and used to run their crawler applications (spiders). The delivery of different content to search engine spiders than to human visitors is called cloaking and is against most search engines' webmaster guidelines.[8][9][10]
- 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.
Privacy and security concerns are, by many accounts, the one thing holding location based services back from exploding. One of the first backlashes came from Nordstrom customers, when that retailer tracked customers through its physical locations for market research purposes. The word “creepy” was applied at the time, and it’s still a word commonly found in discussions of how location-based marketing can tend to make people feel.
Beyond the city level, your geotargeting on Facebook can further narrow your targeted customers to within miles. For example, a fairly standard radius is 10 miles and closer when you’re targeting a specific product or service in a particular vicinity. If you’re in a more rural setting, you can expand that radius to 20 or 25 miles. Urban areas like Chicago, Los Angeles and New York are targeted within one mile.
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. <<<
×