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.
Evaluate your competitors by placing them in strategic groups according to how directly they compete for a share of the customer's dollar. For each competitor or strategic group, list their product or service, its profitability, growth pattern, marketing objectives and assumptions, current and past strategies, organizational and cost structure, strengths and weaknesses, and size (in sales) of the competitor's business. Answer questions such as:
It is dependent on the pre-analysis of the entire IP address space. There are more than 4 billion possible IP addresses, and detailed analysis of each of them is a Herculean task, especially in light of the fact that IP addresses are constantly being assigned, allocated, reallocated, moved and changed due to routers being moved,[6] enterprises being assigned IP addresses or moving, and networks being built or changed. In order to keep up with these changes, complex algorithms, bandwidth measurement and mapping technology, and finely tuned delivery mechanisms are necessary.[7] Once all of the IP space is analyzed, each address must be periodically updated to reflect changes in the IP address information, without invading a user's privacy. This process is similar in scale to the task of Web spidering.
Keyword Competition tools can make things much easier on your keyword strategy. Some tools include the Adwords Keyword Planner  (you can tailor this for B2B) and MozBar. Google Adwords help you discover and compare new keywords. MozBar helps you check keyword competition against other B2B business sites. Some tools must be purchased, such as Long Tail Pro. This tool identifies profitable long tail keywords focused on your content.

Ever heard the saying that a picture is worth 1,000 words? Well, a video is worth 1.8 million, and YouTube is the best place to promote your video ad to an engaged audience. One of the most popular YouTube ad formats, TrueView ads, play before other videos on the site and allow users the option to skip after five seconds (and you don’t have to pay if a viewer skips your ad!). Since there is less competition on YouTube compared to other search engines, your brand has a massive opportunity to reach and convert a ton of consumers across a variety of different demographics.

Geography can also be used to predict desirable demographics and information about users in that area. Neighborhoods can often be delineated by residents’ income bracket, age, ethnicity, education, and many other demographics or interests. Politicians often draw district boundaries into areas of common political constituencies that also predict demographics or common values.
Benchmarking is the important key factor for any marketing campaign. You should always keep an eye on your competitors. How their ads are appearing, what keywords they are using and plan your strategy accordingly. Never create ads, which looks similar to your competitor’s ads. You should smartly design your ad copy, which should look better than your competitor’s ad.
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.
In the last year, Google and Bing have both indicated a shift to entity-based search results as part of their evolution. Google has unscored this point with rich snippets and Knowledge Graph, and Bing has now upped the ante on personal search results with Bing Snapshots. Find out how you can adopt strategies to stay ahead of the curve in the new world of semantic search results.

Twitter is also a great place to get guidance about what's popular as it relates to your search terms. Just type a word or phrase into the search bar and see what trending topics come up. You can also use social media monitoring tools like Hootsuite, which allows you to create a stream based on a particular phrase and monitor mentions of it, or TweetReach, which gives you a similar quick analysis. 
What is PPC (pay-per-click) marketing? Pay-per-click marketing is a way of using search engine advertising to generate clicks to your website, rather than “earning” those clicks organically. You know those sponsored ads you often see at the top of Google’s search results page, marked with a yellow label? That’s pay-per-click advertising (specifically Google AdWords PPC, which we’ll talk about below).

The Java program is fairly intuitive, with easy-to-navigate tabs. Additionally, you can export any or all of the data into Excel for further analysis. So say you're using Optify, Moz, or RavenSEO to monitor your links or rankings for specific keywords -- you could simply create a .csv file from your spreadsheet, make a few adjustments for the proper formatting, and upload it to those tools.
×