Do you have a budget to get this done? This looks like fairly simple custom code using the REST API from any number of scripting languages. My Social Media Analytics Research Toolkit has some Perl scripts that will dump a list of a Twitter user's contacts (followers + followings) and a Twitter user's most recent 3200 tweets in CSV format. Given the small number of users you're tracking about, it wouldn't be that difficult to make a driver script to automate your reports.

My scripts are on Github at

https://github.com/znmeb/SUSE-Studio-Appliances/tree/master/SMART-at-znmeb/Desktop/Demos/
--
M. Edward (Ed) Borasky
http://borasky-research.net http://twitter.com/znmeb

"A mathematician is a device for turning coffee into theorems." - Paul Erdos


Quoting rogerdodger <rl_wh...@hotmail.com>:

Hi folks - I'm a user rather than a developer so not even sure I
should be here.  If I need to head off somewhere else let me know
where but my attempts to find what I need on the bit of the Twitter
site dealing with APIs has foundered on jargon (theirs) and ignorance
(mine).

What I'd like to do is download data to an Excel spreadsheet about a
sub-set of Twitter users on a regular (probably monthly) basis.  For
each of the set of users (about 250 at present, maximum of 500/660 as
more of them - they're a finite number of public organisations - start
tweeting) I would like to export on a set day each period the four
counts shown on the user profile i.e.

No. Tweets
No. following
No. followers
No. listed.

Once I've got those four data items into a spreadsheet I intend to
produce tabular and graphical summaries of activity for individual
users and for the whole set of users, showing trends over time.

I could obviously visit each user's profile and cut and paste the data
but life is short.  Is there something that will allow me to do this
automatically without becoming the technical expert I will never be.

My thanks for any help received.

Roger

--
Twitter developer documentation and resources: http://dev.twitter.com/doc
API updates via Twitter: http://twitter.com/twitterapi
Issues/Enhancements Tracker: http://code.google.com/p/twitter-api/issues/list
Change your membership to this group: http://groups.google.com/group/twitter-development-talk




--
Twitter developer documentation and resources: http://dev.twitter.com/doc
API updates via Twitter: http://twitter.com/twitterapi
Issues/Enhancements Tracker: http://code.google.com/p/twitter-api/issues/list
Change your membership to this group: 
http://groups.google.com/group/twitter-development-talk

Reply via email to