Tag Archives: information dashboard

How to build a Twitter Empire like Guy Kawasaki–4 simple steps–Infographic

Infographic is at the bottom of this post.

Photo of GuySo, you want to be a Twitter legend like Guy Kawasaki ? You want 250,000 followers. You want to make lots of money and Tweet all day long. Well, the insights in this dashboard won’t turn you into Guy Kawasaki, but they will help you understand the 4 most important things that make Guy such a success on Twitter.

Guy Tweets like a Firehose
Guy tweets about 3 times an hour, generating about 83 Tweets per day. Half of Guy’s Tweets are published between 9am and 6pm, Eastern time. Guy repeats his Tweets 3 times, 8 hours apart because he knows that his repeat Tweets will bring in about 75% of his total clicks. So do what Guy does and repeat your Tweets.

Guy Tweets to be ReTweeted
Just about all of Guy’s Tweets have a link to his website, Alltop.com. Guy publishes lots of interesting content, and his 250,000 followers ReTweet Guy’s stuff about 1,500 times per day. By getting others to ReTweet his Tweets, Guy’s audience spans well beyond his 250,000 followers.

Guy’s optimal time to Tweet for ReTweets is 5pm Eastern. If you’re looking for ReTweets, try Tweeting when Guy does, and also read this. While you’re doing that, make sure you pay attention to Guy’s next attribute.

Guy Tests and Tracks to refine his Twitter Strategy
Guy tested his Tweet repeat strategy before deciding on the 3 repeats, 8 hours apart. Why not go one step further and use Twitter data to predict how many ReTweets Guy’s post will get? I’ve constructed a model showing that that we can predict, based on the first 15 minutes of ReTweets, how many total ReTweets Guy will get from his initial Tweet in the following 24 hours. Guy could use this early indicator to alter his Tweeting strategy for the day, or to shuffle around advertising, or to change his repeat Tweet strategy on the fly. You should do the same.

Guy Tweets Great Content
This is the most important thing of all. Tweet all you want, but if you don’t put out interesting stuff, who will want to follow or ReTweet you?

The data for this analysis were gathered using various APIs (YQL, BackTweet, Twitter Search, and longurlplease). SAS was used to gather and manipulate the data and JMP was used to build the predictive model. The data in this analysis span Guy’s Tweets from the first two weeks of June 2010. Weekend Tweets were excluded.


Single click image for full screen version.
Download a high-resolution pdf of this infographic here.

Not all of Guy’s tweets were used in this analysis. @Replies were excluded, as were tweets which didn’t have a link to Alltop.com.

Customer Insight Dashboard for debt collectors

In today’s economy your collectors need the best customer insights they can get. That means giving them the the right information at the right time in the right format. Forget working off of mainframe green screens, or bolted on front-ends–those tools aren’t made to provide maximum insights to your collectors.

Your collectors need a Customer Insight Dashboard like the one below*. The dashboard shows, in detail, information that your collectors need to maximize their debt collection efforts. Across the top of the dashboard is the customer’s financial trend information and pertinent scores about their risk level and ability to pay you back. Along the left-hand side of the dashboard we provide your collectors with the ability to listen to prior interactions with the customer as well as access information they might use to locate a customer who is avoiding your calls. In addition, your staff could locate customer’s nearby your target customer for aid in tracking them down.


Click image for high resolution version

On the bottom left-hand side of the dashboard your collectors have access to the customer’s most recent credit bureau data. This is a critical component to making sure you get paid first. We’ve parsed the information from the credit bureau to show your collectors which of your customer’s credit card lines they could use to balance transfer their bad debt off of your books and onto your competitors books.

If a picture’s worth a thousand words, an image of the customer’s house or business might be worth $10,000. We find this information very useful to collectors in helping them figure out what makes each customer tick. Your collectors can then use their skills of persuasion and apply the information to help them collect the debt that’s due to you.

Lastly, we show some recent transactions on the customer’s account. Seeing how they spent the money they owe you can also help your collectors be more persuasive in the collections efforts.

A dashboard like the one above could be implemented in your system in a few weeks. The dashboard itself is all done in Excel 2003 (2007 works too) with a $250 add in.

*The data presented in this dashboard are not real. They are provided for illustrated purposes only.