Skip to content
 

Creating A Social Media Value Index

The question of the day is how do you measure social media? It’s the question brimming on every marketers mind as we look at how social media will fit into our current marketing mix. Because let’s face it, if you aren’t looking at social media you might just be left in the dust. So for those of you who are trying to tackle this daunting task, I’ve put together a few tips and a social media value index model that you can use to guide you in the process.

In looking at the #smroi conversations on Twitter recently, one of the big discussions is the ongoing debate of whether or not social media will prove a positive ROI.  In addition, there are many who are using ROI to talk about value rather than an actual monetary return and it is causing confusion about the true value that social media can bring to an organization and how to explain it to stakeholders in a meaningful way.

To get started you need to develop a plan. I’m not a huge believer in the let’s try it and see what happens strategy. Not that you can’t try and see, but the trying it out should lead to a well-defined plan. There are four-steps to creating your plan.

  1. Define Goals and Objectives
  2. Align Strategies to Meet Goals and Objectives
  3. Create Metrics to Measure Success
  4. Develop Execution Plan

As I’ve said in my previous posts, I focus on three core goals. Will you use social media to retain existing customers, generate brand awareness and/or acquire new customers? For social media newcomers, I’d be very cautious about starting a social media plan geared towards acquiring new customers. This takes finesse that comes with experience and I’d wait until you’ve mastered the other two before broaching customer acquisition. Once you have determined what your goal for social media is, you can then start to align strategies with those goals, determine how you will measure if those strategies are successful, and put together a plan for execution. I’m not going to spend much time on those areas in this post, perhaps in a future post if readers are interested. Rather, I’m going to focus on how to create a model to measure success and then give you some ideas on different metrics you can use to build your model.

In order to be able to explain the value of social media to your stakeholders I prefer to use Key Performance Indicators as the term of choice.  Mainly because this is a standard term that people are familiar with and you don’t have to do a lot of explaining about what it means.

So here I’ve defined 10 Key Performance Indicators for social media and I ranked them in importance from 1 to 10. Then I assigned a weight to each ranking.

Click here for the full list. Social Media KPIs

Social Media KPIs
Social Media KPIs
Social Media Monthly Worksheet
Social Media Monthly Worksheet

Then I took the 10 KPIs and put in metrics for how to measure them on a monthly basis. For each one I used a baseline measure of 0-1 either through doing a percent to goal or a ratio. I used a 1,000 point system to determine where I stand on each of the measure and apply the weight to determine how many points each measure received. The actual formula is (Score on 0-1 scale)*(Percent Weight*1000) to determine the number of points that indicator received for the month. To see the full worksheet click here. Social Media Value Index Worksheet

Finally, I took the sum of each KPI score as the total for the Social Media Value Index. This gives you a baseline measure for how the all of your social media activities are performing over time. The closer you get to 1,000 the better closer you are to reaching your goals.

Social Media Value Index Score

Social Media Value Index Score

You can chose any key performance indicator that you believe adds value to the organization. You can also choose more than 10 if you like. I chose to use ROI as one of my KPIs, but on its own I don’t think it tells the whole story, which is why I developed this model. Choosing your KPIs may be the hardest part. So I’ve included some ideas of what you can measure below.

Twitter

  • Number of Followers
  • Number of People You Follow
  • Relevance of Followers (I only follow people that are relevant and use a ratio of followers to those I follow to measure this)
  • Number of Retweets
  • Number of @replies to you/from you (you can do a ratio here also)
  • Number of Clicks on Links Posted
  • Twinfluence metrics
  • Twitter Grade

Social Networks i.e. LinkedIn, Ning, FaceBook, MySpace

  • Number of Connections Made
  • Number of Discussions
  • Number of Comments
  • Number of Groups Participated In
  • Level of Involvement in Groups

Video Sharing/Live Webcasts

  • Number of Monthly Views/Attendees
  • Monthly Average of Views/Attendees
  • Number of Linkbacks to Videos

There are many more I could list here. Joe LaTona did a really nice job of providing a list to start from in his “What Are Your Social Media Goals” post.

Now that you have your plan it’s time to execute, measure, and refine!

I’m interested in hearing your thoughts on how you are measuring, suggestions you have for refining this model and what you would add to the list of possible KPIs.

If you would like a copy of the excel worksheets used to develop the model please email me at nichole@nicholekelly.com and I’ll send you a copy.

7 Comments

  1. Mary Ann Ferguson says:

    Interesting model. I’m curious about how you developed the weights and ranks.

  2. nkelly0623 says:

    Mary Ann,

    To develop the weights and ranks I first went through and determined what I felt were the most important aspects of the mix and assigned the appropriate ranks. I also looked at each and decided which were the most indicative of success and weighted those highest. Once that was done I used my gut-feeling of how much “more” important they were and assigned percentages that I thought best represented that. This will be different for each organization and the KPIs that make up the mix will likely change as well. The hope is that by having a flexible model such as this one, an index can be created regardless of the diversity of company goals across the spectrum. It is by no means a “standard” measure for all organizations that can be compared across the board, rather it represents an individual perspective on the value social media is bringing to a specific organization.

    Thank you for your comment. I’ve also sent you the model per your request.

    Nichole

  3. Sean says:

    Hey Nichole,

    Good to see you posting again :)

    One thing I always focus on for KPIs are integration with other tactics/mediums. For example, how many email opt-ins did I get from active twittering or from my Facebook page, how many white paper downloads/lead captures did I harvest from tweeting, etc.

    Obviously these specific KPIs don’t apply to all models, and obviously you don’t want to use Twitter as a white paper advertising platform. Nevertheless, taking the next step beyond followers or followed, into how that “audience” is actually converting is something I always try to measure.

    Nice piece btw, you sure do save it all up for long, thought-provoking posts.

  4. nkelly0623 says:

    Glad you liked it Sean. I’ve thought about changing my blogs to be shorter posts, more often. But I’m finding that longer, more thought provoking is just more my style! I honestly struggle to have enough time to develop content.

    My concept was to enable exactly what you mention with the KPIs. You select the mix of KPIs that is most useful for your client and/or organization. But there is a model you can use to put some order to it and lessen the confusion.

    Looking forward to seeing you at #IMS09!

    Nichole

  5. Hi Nichole a really excellent piece of work. Its definitely got me thinking about KPI’s for myself. In particular I tend to use blogging and article marketing as part of my SM strategy. I like you find it difficult to write short posts so blogs and articles suit me well.

    So I’d include KPI’s for posts read and number of visitors per month, although I accept that in part this would be impacted by the popularity of the articles.

    I would also question if the number of RSS followers is entirely relevant for me as I’m more interested in registering users email addresses as part of a list building activity

  6. nkelly0623 says:

    Laurence,

    Thank you for your comments. I think the KPI’s would be different for each person and each organization. I tried to build a model that allows for variability and flexibility so this was possible. I recently looked at Radian6 and I really like how they measure engagement by using comments and the amount of re-comments by posters. Have you seen it?

    Nichole

Leave a Reply