Text Mining Blog Keywords In Rapidminer and Google Analytics

So I finally got around to downloading some keyword data from Google Analytics for the time period of 2/17/11 through 3/17/11 just to see what’s driving my site traffic.  I did a simple text mining process in Rapidminer to build my keyword frequency list (it took me a few minutes) and generated keyword similarities.  Of course I know what is the biggest draw to my site, that would be my tutorials about Rapidminer, BUT what I’m looking for are subtler patterns in the keywords relative to the bounce rates and site visits.

So below are a few charts I generated from one month of keyword data.

The first chart I want to share with you is a bubble chart showing the site visits for a particular keyword vs the bounce rates. In this case the keyword is Rapidmi (a stemmed word for Rapidminer) It’s a bubble chart so the size of the bubbles are set for the frequency of the word Rapidminer relative to the site visit and bounce rate.

Visits vs Bounce rate with RapidMiner keyword

The second chart is visits vs bounce rate but with the keyword Tutorial as the bubble size.

Visits vs Bounce rate with Tutorial keyword

And the last chart is visits vs bounce rate but with the keyword Stock as the bubble size.

Visits vs Bounce rate with Stock keyword

It appears from the above exercise that the keyword Rapidminer and Tutorial drives a lot of traffic but they have a relatively even keyword frequency distribution across the bounce rate, some people bounce immediately while other stick. The keyword Stock has an interesting bounce rate per visit distribution relative to the keyword frequency, its either 100%, 30 to 50% or almost 0%.

What I find fascinating is the stickiness of the keyword frequency Rapidminer and Tutorial relative to the 50% bounce rate and site visits. There’s a strong site visit (45 to 60) component for those keywords in the data, but I knew that already.

I’m attaching the Rapidminer process file in case you want to mine your own keywords (you have to supply your own data).

KeywordSimilarity

]]>

Statistics – An Introduction to R

I’m sure you’ve noticed that I put Google Ad’s back on this site. Don’t worry, I’m doing this on a temporary basis because I want you guys to help support my book habit! I admit, I’m a book junkie.

These ads, in about 1 1/2 month’s time allowed me, to buy Statistics: An Introduction using R and A Beginner’s Guide to R (Use R) with no cost out of my pocket.  I like to read them in my spare time and will use them to extend my capabilities of using R in Rapidminer, and hopefully more video tutorials later.

Thanks for that guys! I appreciate your support.

]]>