Thursday, June 17, 2010

How To Analyze Your Twitter Follower Program With the Excel Histogram

How To Twitter Better

With a Histogram in Excel

How’s your Twitter Follower acquisition program going? If you use Twitter as a prospecting tool, you need a convenient system in place to monitor how well your Twitter account(s) are picking up followers.

The Histogram in Excel is a tool custom-made for that job. All you have to do is record the total number of new followers that you pick up every day in Excel and then run a Histogram on that data once per month. You can visually compare Histograms from month to month to know immediately which direction your Twitter Follower Acquisition program is going.

What Is a Histogram?

A Histogram divides a large group of dissimilar objects into many smaller groups of similar objects. Excel allows you to arrange the smaller groups in these two ways:

1) By Size of Objects in Group - You can also arrange the groups by the size of the objects in each group. The group on the left will contain objects of the smallest size. Groups to the right contain objects of progressively larger size. This is the type of group arrangement that will be used to monitor your Twitter Follower Acquisition program:

histograms, histogram in excel, pareto chart, twitter, follow twitter, twitter users, twitter seo, social oomph, tweet adder
Click On Image To See Enlarged View

2) By Number of Objects in Group - You can arrange the groups into a Pareto chart. In this case, the groups are arranged by the number of objects in each group. The group with the largest number of objects appears on the left side of the Pareto chart. Groups to the right get progressively smaller:
histograms, histogram in excel, pareto chart, twitter, follow twitter, twitter users, twitter seo, social oomph, tweet adder

The embedded video below will provide step-by-step instructions on how to use the Histogram in Excel to monitor your Twitter Follower Acquisition program. Here is the video:

Here is a Step-By-Step Video Showing How to Determine If Your Twitter Follower Acquisition Program Is Getting Better Or Worse By Using An Excel Histogram:
(Is Your Sound Turned On?)

you pick on all of your Twitter accounts every day. It is most convenient to record these daily figures on an Excel spreadsheet as follows:
. The Histogram will divide the overall group of daily follower pickup numbers into many smaller groups that have similar numbers of daily followers picked. The Excel Histogram will produce a number of smaller groups with containing objects (days) of similar size (number of followers picked up in a day). The groups are then arranged on a chart. The groups can be arranged by the size of the objects in the groups or by the number of objects in the groups (a Pareto chart). In this case, the groups will be arranged by the size of objects in the groups. Here is an example of such a Histogram:

histograms, histogram in excel, pareto chart, twitter, follow twitter, twitter users, twitter seo, social oomph, tweet adder

each month. Here is an example of a monthly comparison:

histograms, histogram in excel, pareto chart, twitter, follow twitter, twitter users, twitter seo, social oomph, tweet adder

histograms, histogram in excel, pareto chart, twitter, follow twitter, twitter users, twitter seo, social oomph, tweet adder

You can clearly see that April’s Twitter Follower Acquisition program did significantly better than May’s. Something must have happened between April and May which hurt the Follower Acquisition program. The Twitter account owner needs to figure out what happened that caused the decline. The Excel Histogram makes this comparison quick, easy, and accurate.

Some Tips About Using Twitter for Customer Acquisition

I use Twitter quite a lot for prospecting. I currently have 9 Twitter accounts and, at the time of this writing, acquire about 300 new followers total per day. That’s not so many but I keep it conservative to avoid attracting Twitter’s attention. Here’s what has worked for me so far:

. After a Twitter account has acquired 2,000 followers, the 10% Rule applies. The number of people you follow can’t exceed the number of people who follow you by 10%. In other words, if one of your Twitter accounts has reached 2,000 followers, don’t allow the Follows sent out plus the FollowBacks to exceed 200, until more people begin to follow you or you unfollow a few people. It is best to try to keep your tff (Twitter Following / Follower) ratio to be just a tiny bit under 1.10. I use TweetAdder to automatically keep my tff ratio 1.09 or lower for my Twitter accounts that have more than 2,000 followers.

Don’t unfollow anyone for at least one whole day after you begin following them. Twitter views this as churn. That’s a label you don’t want from Twitter. You’d be better off if you never unfollow anyone for at least 2 days, preferably 3. TweetAdder handles this for me pretty easily. The attached TweetAdder video shows how this is done.

If you need to set up more than 10 Twitter accounts, Google “proxy IP address” or “proxy IP server” to find out how. This limit is why I have only 9 Twitter accounts. I’ve heard of people with many more accounts, but it’s risky unless you really know what you’re doing.

. If you have set up multiple Twitter accounts based on derivatives of the same gmail account (,, and j.oejohnson@gmail all forward to the same email account but can be used to set up separate Twitter accounts), be aware that if any of those accounts are suspended, all of the accounts will be suspended.

If you are using a tweet automation tool, it is best to tweet no more often than hourly and limit to 10 per day total per account. I use SocialOomph to automate my Tweets at regular hourly intervals during certain times of the day.

 If you have multiple Twitter accounts and use an automation tool to Tweet at regular intervals, makes sure that no accounts are tweeting the same thing at the same time. In the past, I’ve had a few Twitter accounts suspended for this reason. I’m much more careful now when I’m setting up the timing, intervals, tweet content, and tweet rotation on SocialOomph. All accounts tweet at different times and with different tweets. The attached SocialOomph video shows how this works.

If you are using Twitter for prospecting, consider automating at least some parts of your Twitter interaction. If you are trying to achieve large numbers of Twitter followers, automation is almost mandatory. I’ve had good luck with the following 3 tools: TweetAdder, SocialOomph, and Here is a little description of each and how I use it, along with a video so you can take a look at how I use these tools.

TweetAdder TweetAdder automates the following tasks for me:

1) Automates Follows sent and Follow-Backs for each account.

2) Automatically keeps my tff ratio at 1.09 for all of my accounts with more than 2,000 follows.

3) Automatically unfollows anyone who doesn’t follow me back within a time limit that I specify. I usually keep that time limit at 3 days for all accounts.

4) Provides a “safelist” of accounts I’m following that won’t be unfollowed.

5) Creates a “who to follow” list for each account based on any of the following criteria that I specify: Tweet keywords, Profile data, Location, Followers of another user, and Users followed by another user.

6) Allows for completely different settings on each of my Twitter accounts.

7) Can be used to automate tweets but I find that SocialOomph is the best tool for that.

8) Can be used to automatically send replies and direct messages, but I avoid doing this because can come across as “spammy” to recipients.

9) It’s quite easy to use and very intuitive. I probably spend 15 minutes total daily on all 9 of my Twitter account making little adjustments here and there, and then, with the push of 2 buttons, all automated tasks of all accounts run all the way to completion.

Here’s a video to show you how I use TweetAdder to manage Follows and Unfollows for all of my accounts:

Here is a Step-By-Step Video Showing How to Use TweetAdder To Add 300 New Followers to Your Twitter Program Every Day:
(Is Your Sound Turned On?)

If you are interested in TweetAdder, you can click here to check it out. It has a free trial. If you find it useful, there are 4 pay versions that can be purchased with a one-time fee as follows at the time of this writing: Managing 1 Twitter profile - $55, managing 5 Twitter profiles - $74, managing 10 profiles $110, and managing unlimited profiles - $187. I’ve purchased the unlimited version, but I’m only using it to manage 9 Twitter profiles at the moment.

I’ve also heard that another similar tool called Hummingbird does a great job at managing Follows and Unfollows, but I don’t have experience with it so I can’t provide any insight into it. I can say that TweetAdder has done a very fine job for me so far and I’m now averaging about 300 new followers a day with not much effort on my part.

– SocialOomph works great to automate Tweets for all of my accounts. SocialOomph has so many uses that I probably haven’t tapped into even 30% of its functionality, but here’s what it does for me:

1) Schedules tweets for any Twitter account that will continuously repeat themselves at any interval 24 hours or greater that I specify. This makes SocialOomph a real Set-And-Forget tool, if you want that.

2) Creates a series of Tweets that I specify which will be sent out on a rotating basis at the same time every day (or at any interval 24 hours or greater). I use this function to prevent any of my Twitter accounts from sending out the same Tweet at the same time every day.

3) Auto-follows anyone who follows me.

4) Has a very good URL shortening service, but I’ve using for a long time and have had good results with so I’ll stick with

Here is a short video showing how I use SocialOomph set up a rotating series of Tweets that will be sent out by one of my Twitter accounts at the same time everyday:

Here is a Step-By-Step Video Showing How to Use SocialOomph To Automate Your Twitter Tweets and Get More Followers:
(Is Your Sound Turned On?)

If you are interested in using SocialOomph, click here to try a free version. The free version, however, does not provide the service of recurring tweets, which is the main reason that I like and use SocialOomph. Maybe I’m just lazy but I just love “Set and Forget.” You can easily upgrade from the free version to the pay version.

The pay version of SociaOomph costs $29.97 per month at the time of this writing. I’ve been using the pay version of SocialOomph exclusively to automate recurring and rotating Tweets for all of my Twitter accounts and it’s worked very well so far. Here is a link to SocialOomph if you are interested. – is not only great for creating very short URLs but it also provides excellent analytics. I use Google Analytics tracking data to monitor anything happening on my site, but offsite, I use to track clicks. I exclusively use to track offsite clicks so all of the click-through information is maintained in one place.

To Sum It All Up:

The Excel Histogram is a fast and accurate analysis tool that will immediately tell you whether your Twitter Follower Acquisition Program is improving or not.

A great combination to build a larger Twitter following includes TweetAdder, SocialOomph, and


7) Don't let different accounts Tweet the same thing at the same time.

6) Tweet no more often then hourly and 10X per day.

5) Take care if you use derivatives of the same gmail account

4) Don’t set up more than 10 Twitter accounts from 1 IP address.

3) Wait at least 2 to 3 days to unfollow anyone.

2) Keep your Following / Follower Ratio to 1.10

1) Limit follows to 350 per account per day.

The maximum allowable number of new Follows per day per account is 1,000. This includes Follows sent out and Follow-Backs. Your best bet is to stay way below this limit to avoid triggering Twitter’s attention. If you limit the daily Follows sent out by any single account to 350 or less, you should have no problem. I use TweetAdder to automatically keep Follows plus Follow-Backs within this limit.

First and foremost, play it safe.

Try to stay under Twitter’s radar by not being too aggressive in acquiring new followers. Twitter will suspend accounts if any of its limits are breached. It is now becoming harder and harder to get a suspended account reinstated. The larger of a Twitter following you have, the more you have to lose if Twitter suspends one or more of your accounts. It is probably best to stay well within the limits of the following rules:

3) Record each monthly Histogram on an Excel spreadsheet and then compare them

2) Run a monthly Histogram on this data

1) Record the total combined number of new followers

Steps To Using the Histogram to Monitor Your Twitter Follower Acquisition program:

Excel Master Series Blog Directory

Statistical Topics and Articles In Each Topic

No comments:

Post a Comment