08 Sep 2008 01:26 am

circles of loveLet’s have some fun, and a break from all the tough work of . . . well . . . . work.

It has been an incredible eight months since I wrote about my book Web Analytics: An Hour A Day, clearly I am not doing enough SSP (shameless self promotion)! This blog gets a nice amount of traffic each day, I should be “pimping” the book all the time!!

All kidding aside, I had been meaning to update you all about the progress of the book and I have just been too swamped.

In this post I want to share with you how the book is doing in its tiny mission to change the world, news about the translations and finally some reader pictures! The last one to me is such a delight, please keep ‘em coming.

Financial / Donation Update.

Some of you might know that 100% of my proceeds from sales of my book are donated to charity. Two in fact, Doctors Without Borders and The Smile Train.

The main reason for that the book came from this blog and this blog is a labor of love and a way to give back a little bit to the Web Analytics community. Hence my wonderful wife and I decide to donate everything to charity with the thought that if this blog is monetized then that could be for a good cause.

Wiley pays us and Jennie and I promptly send a personal chq to the charities.

We got our first royalty chq from Wiley in Nov ‘07 and it was for $18,000. That was a lot of books (on a very low first time author commission!), so a bit surprise and also of course joy.little-engine-that-could-1

We got our second royalty chq in June ‘08 (this post is late!) and it was for $10,000!

This was also a surprise, I did not think a) there was that much demand for a web analytics book and hence b) there would still be such momentum.

I owe all of you who own the book a huge thanks!

There is one other nice thing this time around, my employer matches personal philanthropic donations up to a max of $3,000 each year. So the charities can also benefit from that sweet gesture.

This time around each charity will thus get $6,500 each.

In 11 months of sales Web Analytics: An Hour A Day has raised a total of US $31,000.

There is no way my personal finances would have ever allowed me to donate that much money. I wish I could put into words how gratified I am from this outcome.

Translations Galore!

This is another fun development.

In July the book was published in Portuguese!

web analytics an hour a day-portuguese

The book is a bit thinner than the English version, but every bit as good as the English version! :)

In August the book was published in Korean!!

wahour korean

The Korean edition was translated by Jeanie Jung (youzin) who herself is an accomplished author, and its her book that you see behind our web analytics book.

I have to admit that the Korean version is my favorite, the book is heavy (!), it uses very high quality paper and the cover itself has a great texture. Awesome job by the Acorn Publishing Company.

You have to get a Korean version even if you don’t speak Korean, it will make a great show piece. :)

Next up are the Chinese and Russian versions of the book. They are expected to be published in October. The Japanese version will be published early next year.

Could anything make a small first time author happier?

The nice thing about international editions is that it is all about spread of the knowledge (the royalties are quite tiny). Hello world! :)

Reviews & Kind Words.

My goal for the book was for it to do well enough that readers would write 75 reviews on Amazon. The US website has 60 reviews thus far which is so great. Amazon.co.uk has 6 reviews, and Amazon.ca has 1. Most reviews are quite kind, which is so nice.

If you have read the book and have a few minutes to spare perhaps you could add a review ? Thanks so much.

book reviewThe book also shows up in interesting place, which to me is always fun.

The other day it was listed by The Reader’s Advisor Online in a blog post [Planes, Trains, and Lanes] where they tried to spot patterns in their data when they categorized readers they spotted by age and gender.

Web Analytics: An Hour A Day showed up in the 20-something Men category, along with John Grisham’s Playing for Pizza! There’s a doozie!!

It was also happy moment when I noticed the book was on The Personal MBA’s 77 Best Business Books.

You see my own MBA is in Finance and MIS so it was nice to see the book listed as one of nine books in the Finance & Analysis category.

If you have seen a review some place fun could you please let me know?

Pictures: People, Places & Analytics!

When the book launched I had requested the readers to send me picture of the book, either with them or at a interesting place or …. really anything was fair game. I still get interesting pictures and here are some of the latest ones.

[And if you have the book I would love to get a picture from you! Please email blog at kaushik dot net. All pictures published here are only after I get the sender's permission.]


karen, autodesk, web analytics an hour a day

A little while back I had given a talk at a Autodesk offsite, the picture above is of everyone who was at the talk. At the very front you can just make out Karen holding a copy of my book (everyone got a copy!).


vernon, web analytics an hour a day

I think Vernon might have purchased the wrong book to improve his golf handicap! But of course I am still very appreciative!! Just kidding.


tomi madeira portugal, web analytics an hour a day

Web Analytics: An Hour A Day on vacation with Tomi at the hills of Monte in Funchal Madeira in Portugal. How pretty! [And I wonder how Tomi got it to stand like that on a downward slope!]


linda bustos, web analytics: an hour a day

Linda Bustos and I “met” through this picture, then did a webinar together, then a video interview and more to come I am sure. See what a book can do? Linda writes the wonderful Canadian ecommerce blog www.getelastic.com.


samuel gemma hugo, web analytics an hour a day

Two beautiful boys (Samuel & Hugo) get a early start on learning about analytics from their hard working mom! Gemma writes the lovely Spanish web analytics blog Dónde está Avinash cuando se le necesita? , I think I like that blog title. :)


wahour korean2

The Korean version of the book on store shelves in Seoul. 26 copies in a shelf that can hold 31. So 5 sold on day one?


web analytics an hour a day-borders bookstore

My 4-year old son Chirag took this picture at a local Borders bookstore.

No matter which bookstore we visit he’ll say “Daddy we are at the library, can we find your book!”. Eliciting both slight embarrassment (he is loud and people turn heads), and I have to admit some pride (when we find the book ). But then he says “this is my daddy’s book!!”, then slightly more embarrassment.


will, web analytics an hour a day

Will in absolutely gorgeous Bend, Oregon. I think he is not too excited that his Dad is making him read about Web Analytics when he would much rather read A Fly Went By (I love that book!). Thanks for posing Will!


web-analytics youzin

Guess who would love a book this much? The author! Well in this case the lovely Jeanie Jung who translated the book into Korean. I don’t think I have this much courage (and I am very shy about my pictures), but this set of pictures made me very happy. Thank you Jeanie!


tim duke, web analytics an hour a day

Tim tweets: “Hit my 40th page of (detailed) notes re: @avinashkaushik’s analytics book. Only 2/3 through.”

I replied to that tweet and a few days later I had the opportunity of seeing Tim’s notes and I have to admit that there is something utterly remarkable about seeing something you created have that much of an impact on someone else. Tim’s notes are meticilous, I could see the concepts he got, and his comments (in different color ink). Quite rewarding for me.


rob snell, craig paddock, web analytics an hour a day

Web Analytics: An Hour A Day has traveled a lot around the world but this is one of my favorites. Craig Paddock, and Rob Snell lugged it all the way from the US to Brazil (inspiring airplane reading I presume :). Here they are at the statue of Christ the Redeemer on top of the Corcovado Mountain in Rio de Janeiro. Craig, thanks for being such a sweetheart!

That was so much fun.

I was a reluctant author. Then it was a lot a lot a lot of work to write a book. But it turned out to be totally worth it. The book’s got stronger legs than I had ever imagined. It has reached so many parts of the world and so many absolutely fantastic people. I feel incredibly lucky.

I want to end this post with my sincerest thanks to all of you, those that have bought Web Analytics: An Hour A Day & to all of you who read this blog. You all make work fun.

Social Bookmarks:

  • co.mments
  • del.icio.us
  • Furl
  • Ma.gnolia
  • Reddit
  • Spurl
  • Google
  • StumbleUpon
  • Sphinn
  • TwitThis
  • Digg
  • Facebook
27 Aug 2008 12:34 am

vortex Save the best for last! Insights for Search is one of the most awesome research tools you’ll use. I promise.

We have learned how to use Trends for Websites to measure core site metrics and identify strengths and weakness of our competitors.

We built on that by learning how the Google Ad Planner can help us identify demographic and psychographic attributes of the Visitors to our website, as well as our competitors. Not willing to stop there we also identified specifically how to identify Publishers where our target audiences exist, to aid in our intelligent acquisition efforts.

In the final post in this series we cover Google Insights from Search and go back to good old keywords and mining search behavior by our customers to find actionable insights.

Given the dominance of Search as a acquisition channel, you are going to have fun here.

Do the obvious thing first: Understand “head” keyword trends.

Type in a keyword and check out the trends over time, a quick peek into popularity of the terms you are interested in. . . .

Step One: Type keywords. [I am going to compare volumes for my friend Bryan Eisenberg - Always Be Testing -, Garr Reynolds - Presentation Zen - and myself to see if I can learn anything.]

google insights for search queries

Step Two: View Data.

google insights for search trends

Some quick thoughts.

Bryan’s search traffic has stayed pretty consistent over time, steady over the years even as the “noise” in his unique space, persuasion architecture, has gone up quite a bit. There is a slight lower slope in the last 12 months but overall Bryan has great strength.

Garr shows up on the scene in late 2006 and you can see him stay steady and then in the latter part of last year he announces his book and you can see his plans for world domination take off like a rocket, over Q4 and he is not looking back (except in the last month).

[What do the numbers mean: The numbers on the graph reflect how many searches have been done for a particular term, relative to the total number of searches done on Google over time. More here.]

Remember always look at your data in context, hence the slope of a individual line is important but it is in context to the other lines that it gets to be more fun.

What can I do with this?

Run the graph above, atleast for all your head search terms (top 20 terms that bring most of the traffic) and see if your indexed performance (against competiton) is good or bad.

Notice those three numbers on the graph above (74, 12, 54)? You can even report monthly performance in your Management Dashboards.

You can also use these trends to validate your business strategy, unaided (or aided) brand recall, customer intent. (Or feed your paranoia: Do you matter!)

People how know me know that I love my ThinkPad (greatest laptops in the world!). You also know it used to be owned by IBM and is now Lenovo.

So I wonder how the ThinkPad brand is holding up over time vs the Lenovo brand. . . .

insights for search-lenovo vs thinkpad

Good news on the Lenovo front. From no where the brand has continued to grow strong, as reflected by customer searches, and on a great slope.

Potentially not so great news on the ThinkPad front (me so sad). The brand has continued to erode steadily over time.

This should potentially be worrying because during the same time the business brands of HP and Dell laptops tend to hold steady in terms of search volume (though Dell’s seem to on a slightly over time).

Remember all this data can do is raise questions. It could be that Lenovo is being emphasized over Thinkpad, it could be that the competiton has just stayed steady on message with their brands, it could be a reflection of Lenovo’s search strategy, it could be that Lenovo believes that its core direct business strategy is so strong that the web one is not quite as important.

So what’s wrong? That’s for David to answer (in private I am sure :).

You can also use this kind of data (from Google or another source) to measure what kind of brand equity you have built over time for your core business brands.

Here’s a example: I was embarrassed that I did not know Lenovo did desktops, I recently ran into the ThinkCentre PC’s (”The ultimate business desktop”) on their website.

So I wanted to know if I was the only person in the world who did not know this. Here’s the data. . . .

insights for search-lenovo vs thinkpad vs thinkcentre

Either by design or by fate, it seems that very few people have heard of ThinkCentre PC’s - as measured by people actually typing in either ThinkCentre or Think Centre into www.google.com. That inspite of the fact, you’ll note the orange alphabet markers above, Lenovo has been pumping out press releases and news about the product.

That’s what you can do: interesting analysis about your core head terms. Analysis that helps you index your performance and raise troubling questions.

You can also get a bonus based on this data, for example Seth (who runs search strategy for the green line) probably included this in his annual performance review. . . .

insights for search-turbotax hrblock

: )

Google Insights for Search offers a large free source for all this rich search data, but even if you use paid solutions from Compete or HitWise you should be thinking in terms of similar analyses.

Kick it up a notch: Exploit geographic customer demand trends.

Comparing trends over the last four years is just one part of what you can do with Insights for Search. The other large component is your ability to understand them from a worldwide perspective and along geographic segments.

Continuing with the Lenovo theme, let’s try to understand opportunities for the X300 (which I really want!).

I start by trying to understand customer search behavior across different countries for the term lightweight laptop (the blue line is for “ultraportable laptop”, not quite as popular). . . .

insights for search lightweight laptop

Amazingly the US comes in a bit behind the UK in terms of the search index, an obvious market to exploit. But what about rest of the world?

Here you go. . . .

insights for search lightweight laptop worldwide

Sweet. Three countries stand head and shoulders above the rest, as is obvious. It is surprising to me that Japan is hot much more obvious given their obvious propensity for small stuff.

Also notice Philippines and Malaysia show up nicely.

If I were running Lenovo’s search campaigns here is good data for me to profit from: The demand is there, are we showing up in Organic and Paid Search results for these terms?

But it gets better.

You can actually drill down to individual country level and then state level to further understand search behavior.

For that I tried something different.

While the Macbook Air is not a direct competitor to X300 (you see there are Mac people and then there are PC people :) it is possible for us consider understanding its popularity and try to be aggressive and provide the X300 as an option to those folks.

[It is to be noted, perhaps unsurprisingly, that way more people look for the Macbook Air than the X300.]

Here’s the geographic search volume index map for the X300. . . .

geo x300

Significant search volume (indexed) on the coasts, Texas and NYC are strong (and I wonder why North Carolina is strong :)).

So how does that compare to the demand for light weight computing as represented by the Macbook Air?

geo macbook

You see strengths in the same states as the X300, but there is pretty nice demand across the country, all states (except Wyoming, what’s up with people in Wyoming?).

So clearly there is demand, but people are not looking for us. Clearly great opportunities for a aggressive Marketer at Lenovo to exploit this difference and build demand for the X300.

She/He can obviously use Organic or Paid Search on Google. But in those empty states up top for the X300 the Marketer could just as well consider doing TV or Radio or Print or Newspaper or even buy geo targeted banner ads on www.yahoo.com to get the brand out there and get in the face of those people who are looking for light weight computers.

Bottomline: Insights for search exposes customer demand across geography, you can use that data to optimize your online and offline campaigns to benefit from that demand.

It bears saying that this is not some phone survey data by bugging people at dinner time, this is not panel data extrapolated to infinity, these are not online surveys. These are actual queries typed by actual people who are actually looking for you (or your competitors). You can see how it is vastly superior.

Go for gold: Ecosystem: Identify “related terms”, “rising terms”.

As all good SEO girls and boys know it is not all just about the terms you are interested in, it is all also about the ecosystem related terms if you really want to win the search game big (on any search engine online).

I have stressed quite a bit on this blog about moving beyond the top 10 or top 20 (tip of the iceberg) to what’s happening in the massive long list of keywords (below the tip of the iceberg, hidden under the water). Statistical techniques like “what’s changed” are fantastic at this. I am quite pleased that Insights for Search offers a “what’s changed” view as well!

Since we were just working on understanding lightweight laptops, here is the first nice bit of insight from the tool. . . .

lightweight laptops related terms

Two action items.

1) You can ensure, if you are doing SEM, that you are taking into consideration all these related terms to ensure your bidding (or even SEO) portfolio contains the right terms.

2) Every time I find competitors here, and not myself, I feel a bit sad. Clearly in this category Users are typing competitor terms and that is sad (Ok, ok I am religious. Ok, I am happy for them. There. Happy now?)

You can see how this can give you insights across other categories, and customer preferences. Remember our use of Pampers as and example last week in the Ad Planner post? So how is the picture for diapers?

diapers related terms

Someone at P&G should start worrying that cloth diapers is so huge in this category. You can easily see how the numbers above reflect the individual success of Pampers and Huggies (the two big brands here in the US).

Related terms are good to understand. More awesomely awesome are “rising searches”, terms that are not quite yet in the top but are rapidly becoming important in this category.

Here’s the story for our lightweight laptop category. . . .

lightweight laptops rising terms

Whatever it is that Toshiba and HP are doing in terms of their online and offline campaigns (branding or otherwise) is clearly working because terms with their individual brand names are rapidly rising in customer conscious (and hence them typing into search engines). I

Beyond that at the minimum what this list offers are keyword and key phrases that you might not have considered but you should.

Rising searches to me is also a fantastic way to understand trends that will become mainstream in the future, but currently are just rising. So not only do people want lightweight laptops, they also want them to be small. As an example.

So what about our diaper category?

diapers rising terms

Someone at bumGenius deserves a raise, it is astonishing how much they dominate the tidal wave of rising attention at the moment. Clearly the environmental movement is catching on.

None of the main brands are present there.

Perhaps P&G should buy bumGenius to preserve future revenues. :)

I have to also admit that I had never heard of any of the diaper brands above, a reflection of how some of these trends are so hidden under the radar and then end up surprising Marketers when they hit mainstream. By then it is too late.

Bottomline: Use the data above to identify bleeding edge trends for your industry, key words, ecosystem before it is too late.

Some last goodies: Time Range Trends, Locations & Categories.

Couple more fun things you can do with Insights for Search. You can more view trends for different time periods.

I am going to check the performance of my brand over two years and if I am getting better or worse. . . .

insights for search-time range comparisons

Click Search and. . . .

insights for search-time range comparisons avinash kaushik

No presence in the Jan 2007 time frame (why! :)), and doing much better since then. Doing much better year over year. Happy birthday to me. :)

It is interesting to see the dips over summer. I wonder what causes that (any guesses?).

Do this graph for all your core brand terms, for your category terms, for your performance for your industry “rising terms”. You’ll have insights up the wazoo.

Another example. A real business. From my visit to P&G, year over year performance for one of their biggest worldwide brands (one of their biggest advertising spenders offline) Gillette. . . .

insights for search-time range comparisons gillette

Quite sad.

So much money spent hiring Tiger Woods, Roger Federer and Thierry Henry, so many very nice tv commercials, and so many nice print ads. But online they are doing much worse year over year.

I bet for the cost of airing just five of those TV ads Gillette could easily reverse the trend above, if it really set its heart on winning online.

Switching gears.

You can also do category searches in insights for search.

So what are the terms that are top in the Auto Insurance category in the US?

insights for search location category

And boom!

insights for search location category-auto insurance

Delightful, right?

And don’t forget to look at the Rising Terms, that’s where the real meat is. Motorcycle insurance is rising, travelers and nationwide are both rising brands (good for them!).

Finally you can also do some fun stuff.

I did a search on the “hottest” (rising searches) celebrities (category: entertainment, sub category: celebrities) in New York in the last 30 days to see how much I am in sync with popular culture. . . .

celebrities in new york

Who in the world is Kim Kardashian? I feel lame, I am so out of touch.

Oh here are the ones getting hot in the last 30 days. . . .

rising celebrities in new york

Go Tom Brady and Aishwarya Rai!! And some things are evergreen, go Ms. Anderson! : )

Do I need to explain how you can use this data for business purposes? Think hottest hotels or business schools or computer software or web hosting providers or charitable causes or . . . . well you get the idea.

Agree, pretty damn cool and actionable?

I hope that your have learned how to leverage Insights for Search for your business, but more than that I hope how you can use the techniques in any tool that provides search data (like Compete or HitWise).

Before we close, some helpful links:

Ok your turn now.

What do you think? Was it fun? Did you learn anything new? Did the business cases I used make sense? Have you used the tool, what did you not like about it? Anything obvious that I missed about how to use it? Do you use other tools to get this type of data?

Please share your feedback, ideas, and critique.

Thanks.

PS:
Couple other related posts you might find interesting:

Social Bookmarks:

  • co.mments
  • del.icio.us
  • Furl
  • Ma.gnolia
  • Reddit
  • Spurl
  • Google
  • StumbleUpon
  • Sphinn
  • TwitThis
  • Digg
  • Facebook