After my recent playing around with Wordle, I noticed an advanced feature on Wordle, where you can copy-paste a list of words along with a “weight” defined by numbers.
This sparked an inspiration, and I immediately went to my SEO Booster PRO running on this blog, and exported the 6,027 different search engine queries registered (so far) to a .csv file.
The export contains all the recorded data, not only the search query, the landing page for the query and several other important details, but also the number of visits from that search query.
Old sample export screenshot
I isolated the two columns, Search Query and Visits in Excel, and pasted that into Wordle. I have a lot of experience in Excel from when I was Project Manager in a web agency, which is experience I am happy to have when I need to turn to a spreadsheet application.
To make it easier to see, I removed the registered queries with just one visit, leaving over 5000 other queries. I was surprised to see the amount of visits “shopperpress” has gotten, but I remember being one of the first to blog about that new theme by Mark Fail.
Here is a few pictures that this little exercise produced:
Registered Search Queries by SEO Booster PRO for CleverWP.com
Registered Search Queries by SEO Booster PRO for CleverWP.com
Registered Search Queries by SEO Booster PRO for CleverWP.com
Registered Search Queries by SEO Booster PRO for CleverWP.com
{ 4 comments… read them below or add one }
Cool. I should try that doing for few of my sites. Btw we are waiting for an upgrade for the booster pro eagerly.
SEO booster pro is one of the best wordpress plugins there are made ever!
Thanks!!
Hi Paw, thank you very much for your kind words
SEO plus Visualization. Really cool!