Twitter is all about an ongoing presence.  You need to know how you or your competitors are fairing in this regard. This report lets you monitor other people (or yourself).

• The number of tweets posted in each 6-hour increment over the past 7-10 days
• The number of Retweets as identified by "RT @screenname" in the message
• Any other mentions of the screenname (replies, references)
• All the tweets, retweets and mentions detail on separate worksheet tabs

Requires Next Analytics for Excel version 3

Download Tweets-Retweets-Mentions.xlsx, open in Microsoft Excel, enter a Twitter screen name in the space provided at the top of the worksheet, and then click Refresh on the Next Analytics menu.

Next Analytics for Excel required to refresh data.

Who is talking about you on Twitter?

Excel Twitter Analytics shows frequency of references. Gives detail about people making references with daily chart of references.

You work hard to establish a presence on Twitter, but who is talking about you and how often? This workbook provides the full detail on one sheet and summarizes the activity on another. Within the summary, you will see:

• The total number of times your screen name has been referenced per day for the past 7-10 days
• A sorted list of the people making those references, plus their daily and period totals
• A chart of daily totals
• A distribution chart of the number of people making a given number of references

Requires Next Analytics for Excel version 3

Download TwitterReferencesAnalysis.xlsx, open in Microsoft Excel, enter a Twitter screen name in the space provided on the TwitterData_actions worksheet, and then click Refresh on the Next Analytics menu.

Next Analytics for Excel required to refresh data.

If you're using Twitter for market research, either to learn what people are saying about your company or your competitors, then you don't have time to read all the Tweets as they arrive. Excel is the perfect environment and this dashboard gives you a nice compact summary, highlighting what's important.

This will save you hours of endless scrolling that browser based viewers require, and reduces eye strain trying to find what's important and ignore what's not.

See the latest tweets in Excel. Make your reading time more efficient.

• what's new since the last time you looked
• quickly scan message in a condensed, easy-to-read format
• embedded links are available as Excel hyperlinks
• icons indicate how many followers, friends and tweets each sender has
• customizable to highlight or hide senders, mentions, retweets or replies

• timeline makes date and time more visible

Download MyDailyTwitter.xlsx, open in Microsoft Excel and then click Refresh on the Next Analytics menu. Read the blog article about how it was made.

This report lets you visualize the words on someone's Twitter timeline (their home screen) to see what people are talking about now!

Download for Excel 2007/2010 or for Excel 2003, enter the screen name of the account you want to analyze and Refresh with Next Analytics. 

The report downloads and analyzes the past week's entries from twitter, and presents the most frequently used words, with the size proportional to the popularity.

This report digs into the friends and followers for a given Twitter identity (screen name), profiling their friends and followers in turn.

You get two lists in Excel showing the Friends and Followers of that person.

• Friends of that person -- ( a list for you to work with )
• Followers of that person -- ( another list)

Learn the details of those friends and followers. This helps you to assess the "quality" of the followers and friends.  For each one, find out counts of THEIR friends and followers.

• For each friend: number of followers and friends
• For each follower: number of followers and friends

You get other lists which are useful because they divide them into segments: 

• a list of friends that are not followers
• a list of followers that are not friends

Why is this report useful?

Clean up your Twitter lists.

Get names for your own network.

Check out your competitors friends and follower lists.

Download this report for Excel 2007/2010 or Excel 2003. Enter the Twitter screen name of interest at the top of the form and Refresh with Next Analytics.

This report shows how easy it is to load information from your Twitter home screen into Excel. Simply load the workbook, enter your creen name and click the Next Analytics Refresh menu.

Download the workbook here FirstImpressions-Twitter.xls

This report automatically downloads and analyzes the Twitter followers for any Twitter screen name (user). Just clicking the Next Analytics refresh menu gets you a full analysis, showing the distributions by time zone, number of followers and number of tweets sent. It also provides a listing of the top 20 with the most followers of their own.

Download this workbook for Excel 2007/2010 or Excel 2003. Refresh with the Next Analytics for Excel add-in.