Hi – I’ve read your post with great interest. Not only am I happy for you and your success, it does provide a glimmer of hope to those of us who do have “other” ideas. I, too, have had an idea for a very long time now, but I have no idea how to go about “making it a reality.” I am not a programmer either… though I do know some html… I also remember the old days of having even a web developer holding domains hostage, never mind the site’s entire code. And, yes, that is one of the major things that stops me from even discussing things with a developer. I simply don’t trust them…
"I rarely get excited about SEO and SEM tools...But, when it comes to keyword research it is virtually impossible to produce a quality worksheet without software. When I have to perform the same task for my customers, the process is even more daunting and time consuming...there is now a better way to manage huge keyword lists and this tool is called WordStream."
I want to share how and why I sold the company in order to both educate and inspire potential software entrepreneurs. I certainly don't know everything and obviously companies sell for much more than I sold Long Tail Pro for (I won't be featured in Tech Crunch anytime soon); however, I'm willing to share what I have learned and hopefully that can be beneficial to a few of you.
For the first few months, there was certainly a transition period. However, the new team was able to take over the reigns fairly quickly. A big reason for the quick transition is because I had automated most of the business already. So, the fact that I was stepping away didn't make a huge difference since all the sales, marketing emails, and many other details were already happening on an automated basis.
After the Panda update rolled out, the latent risk in such a strategy could (typically would) vastly exceed the direct cost of the content, as poor pages on one part of a site could drag down the ranking of other pages on the site which targeted different keywords. Some sites have seen their search traffic fall over 90% with their ad revenues falling even faster. Demand Media went from being worth a couple billion to tens of millions of Dollars. ArticlesBase.com sold on Flippa for $80,000, but was making over $500,000 PER MONTH in profit before getting hit by Panda. Many other Panda-torched sites like Suite101 have simply went offline.
6. Filters. On the top area of the main pane, you can find the “Filters”. These will allow you to filter your keyword suggestions list in real time. Just start typing and your list will be filtered accordingly. You can filter for “Keywords” (to only show keywords that include a specific word or words); “Suggested Bid” & “Local Searches” allow you to enter minimum or maximum values; “Advertiser Competition” (this comes in handy, because the higher the competition the more money there is to be made if you target that keyword); “Avg. Amazon Reviews” (a neat feature for those who sell products on Amazon or have an Amazon FBA business — less reviews equal less competition, hence more chances to rank on top of Amazon’s product search pages); “Avg. Keyword Competitiveness” or “KC” is Long Tail Pro’s proprietary metric that calculates how hard it is to rank for a keyword in a range from 0 to 100 — 0 being no competition and 100 impossible to rank for. All of these filter columns can be used to sort the keyword suggestion list as you prefer.
I also want to emphasize that Microsoft Excel and Google Docs perhaps play an equal, if not more important role in keyword research than any of these tools, because at the end of the day, the mountain of data you end up with is of no use if you can’t perform calculations, sort, filter, present or store it in a way that’s best suits the task at hand. Head over to Distilled for a comprehensive Excel for SEOs guide. Alternatively, bug this guy—he’s the Sensei who trains Excel ninjas in the dark of the night.
There is no doubt that there are various keyword research instruments out there, however, many people were often disappointed with many of them because they fail to deliver the expected results. While some of the tools proved to be helpful when you look for specific niche keywords, others were simple failure. You would discover that as time goes on that, it begins to slow down. This affects the efficiency and the speed. This is not the case with Long Tail Pro. It does not only deliver efficient and reliable search results, it does it very fast. You would appreciate the efficiency of the tool when you have watched the demonstration videos and tutorials.
Given you have a good idea of where to start and are fairly confident you are speaking the same language as your client, jump start research by generating related keyphrases and long tail variants with the ever so easy to use Google Autocomplete. This tool makes predictions based on what you are typing that are a reflection of Google search activity.
Once you've entered a keyword, you'll be presented with a range of data: Google Search Volume, Competition, CPC, and Opportunity Score. This data provides advertisers with at-a-glance data that they can use as the basis for their next campaign. No other free keyword tool provides as much free keyword data as WordStream's new and improved Free Keyword Tool. Try it today and see how much easier keyword research can be with WordStream.
When I finally made the decision the get Long Tail Pro way back in December of 2012 – I honestly had no idea how much this one piece of software would impact everything I do online. I knew that it would help me find more and better keywords right off the bat. But I didn’t know exactly how much it would positively affect my ability to actually make money online. I can say with confidence, that Long Tail Pro is the one tool that has made the biggest difference (by far), in my ability to get traffic to websites and actually earn money online.
We hope you found some of these tools useful. It's worth noting that if you don't have any content that suits a particular keyword, you can always create it. Just remember to make sure that the content answers the search query that you're trying to target. For example, somebody searching for the term 'Log Cabins Phoenix' is not going to be satisfied with a page that offers log cabins for sale in New York.
I use Ahrefs to find ideas for keywords to add into content, and content to create around keyword opportunities. I like how Ahrefs shows keyword difficulty, search volume, traffic potential (how much organic search traffic it’s possible to get when you rank #1 for a parent topic keyword) and lets you group keywords together to create lists. It’s really useful.
Analyze Keyword Difficulty – Targeting difficult keywords with the highest competition is not always the best idea. The SEMrush Keyword Difficulty tool helps you determine keywords’ difficulties. By indicating a particular keyword’s percentage of difficulty, this tool helps you estimate how easy it would be to seize your competitors’ organic positions in the SERPs.