Last week I wrote about a case study I’m going to talk about and present a few times this month revolving around the geo-centric possibilities of Social Media Marketing augmented by Social Media Monitoring and Action – see Geo-Local Social Media Monitoring and Missed Opportunity of Social Media for the first part of this case study (it was re-tweeted 52 times so far and provoked a fairly vigorous debate about what the case study really ought to focus on).

I proposed that Social Media Marketing, augmented by Social Media Monitoring – is really about lists and action, reaching out by the community manager – and here I’m presenting the second part – the first table of 1 year of tweets collected by Radian6 for Havana Central Restaurant Chain – I will discuss and further refine this chart in the next post on this subject – but I want my readers to think about what I’m presenting now (you can also download the entire spreadsheet here at case study -2).

This chart doesn’t yet filter on actual check-ins to any of the the restaurant locations – is just looks at all the people who tweeted about Havana Central in some way over the last year and how many times they tweeted each month about us.

I sorted by the top tweeters but there were 960 unique Twitter handles that tweeted about the Havana Central over the last year.

What do you think the reward should be for someone that tweets every month – a free drink – a reach out by the community manager to each account?

Working this list?

Isn’t this where the Social Media ROI really is?

Think about it and please comment – and feel free to download the entire list here - case study -2