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.
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.
How do you figure out what keywords your competitors are ranking for, you ask? Aside from manually searching for keywords in an incognito browser and seeing what positions your competitors are in, SEMrush allows you to run a number of free reports that show you the top keywords for the domain you enter. This is a quick way to get a sense of the types of terms your competitors are ranking for.
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.
You can also filter by query, which is useful when looking at branded queries, or when looking at specific words. For example, only show keywords that include the term "SEO". The graph also allows you to spot trends in across the available metrics and compare week-on-week or month-on-month. This can help you to drill down and monitor progression over time, allowing you to answer questions like "have my branded keywords received more clicks in the last month compared to the previous month?", "has the CTR improved?", "did average positions in Google improve?".
Depending on your topic / vertical and your geographic location the search engines may have vastly different search volumes. The tool can only possibly offer approximations. Exact search volumes are hard to find due to vanity searches, click bots, rank checkers, and other forms of automated traffic. Exceptionally valuable search terms may show far greater volume than they actually have due to various competitive commercial forces inflating search volumes due to automated search traffic.
Now that I’ve been using Long Tail Pro for several years to successfully find great keywords – I can confidently tell you that Long Tail Pro will more than pay for itself if you use it properly. Whether you are a blogger, a niche site creator, an affiliate marketer or even just an article writer – doing proper keyword research will help you be more profitable. Doing proper and effective keyword research with Long Tail Pro is super fast and easy. It’s so easy in fact – that it’s not hard at all to offset the cost of the software by putting it to work for you. And I’m going to show you how within this post.
What I really like about them is extensive detail including the keyword difficulty. Ahrefs uses clickstream data to also show how many clicks you will get from the search engine. This is very useful after knowledge graph integration, as many keywords may have huge traffic but they hardly get any clicks from the search engine. Reason being, they get answers directly from the Google search result. Example of one such query is: “birthdate of any celebrity”
I recently decided to go with ahrefs after using spyfu for a couple years and trialing secockpit. I was a moz client for awhile too about a year ago. I found spyfu data to be sketchy (or just plain wrong) fairly often, and moz, I don’t know, just didn’t seem like they were really into supporting what I wanted to know. secockpit was achingly slow for a trickle of data. ahrefs isn’t nearly so graph-y as spyfu, but they are so blazing fast and the data is so deep. I enjoy it a great deal, even if it is spendy.
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…