Monday, October 5, 2009

How Do You Measure SharePoint - Metrics for Business Users

It goes without saying, if you can’t measure it you can’t manage it. This is not always so easy on SharePoint from a business user perspective. It’s easier for the server administrators as they can measure uptime, total users, space used etc. But how do business users put SharePoint on their balanced scorecards?

The trick is to have measured from the beginning. It is much harder to measure benefit when you are months or years into your project. If you are, don’t worry; just keep this in mind for future sites on SharePoint. But sites are never “finished”, so you could start from today if you need to.

When determining metrics, you’ll need to demonstrate that your site / project is meeting and supporting business objectives. Management are going to want to know how SharePoint is adding value. Ask yourself, if someone had to justify to you why you should continue to invest in SharePoint (whether by upgrades, resources, enterprise licensing, training or 3rd party tools), what would you want to hear?

There are two aspects to take into consideration, quantitative (numeric information), and qualitative (non numeric information). In other words, the number of clients that have visited your site (quantitative), and their current happiness level by the survey they completed (qualitative).

Don’t give quantitative accounts without a bottom line to demonstrate the time / money savings, for example : “I used to have to email my whole team to get feedback, then collate all the responses, it is much easier now”.

That doesn’t mean much to business decision makers, however : “I used to send email to 15 team members, then have to collate their responses and publish the results to management. I now send one email and the responses are captured by the team members themselves in a custom list saving me 3 hours of work per week. At my current rate of R100 per hour, I effectively save the company R15600 per year on this task alone”. These are metrics management can understand and appreciate.

To do any of this, you first you need to establish a baseline, snapshot where you are now, then decide what you are going to measure and how often. A good idea is to look at your organization or department’s current key performance indicators. Think about how your site impacts or supports these indicators. (If they don’t, maybe you need to rethink your site content and what you are trying to achieve).

Like most things in life, you need balance. Make sure you aren’t spending more time collecting metrics from SharePoint than doing other work. Remember too that realizing that value of SharePoint takes time. Simply installing the product does not constitute a successful project. Company-wide user adoption with the proper use of the functionality using best practices with successful retrieval of information quickly does.

Some things you could measure; if you have more to add, please feel free to comment accordingly. Remember to translate all time saved into a monetary value per week, month and / or year. Obviously depending on what you are responsible for in SharePoint will affect what you are going to report on, Site Owners will be different to Site Collection Administrators and those responsible for the entire implementation.

• Site stats – take a screen dump of the usage analysis on your site every month. It is available out of box under Site Actions – Site Settings – Modify All Settings. This will show how effective your site is in disseminating information as well as identify dormancy.

• Put a hit counter onto your site, (out of box SharePoint Designer web component). Take screen dumps every month so you can monitor increased visits. When you report, mention you reached X number of people in the space of X months. Keep track of the stats per month and do some nice graphs at the end of the year to impress your decision makers.

• Take screen dumps every time you change the look and feel and note how long it took to achieve each one. Management tend to hugely under-estimate how long it takes to do things on SharePoint, you need to prove what you have been up to. Also say how you’ve improved the site with each version – you did it in response to a survey on the content for example.

• How long it took to retrieve the right documentation from a file share as opposed to now on SharePoint.

• The number of sub folders you had on a file share compared to SharePoint. (You replaced all sub-folders with metadata effectively making the top level folder the one point of truth for uploading documents, and saving X time for users to get to information, and reduced the number of clicks by X.

• If you work with Excel spreadsheets and converted them to lists on SharePoint, demonstrate how you saved X time collating reports / data from users who before had to fill in the spreadsheet and mail it back, where-after you had to collate that information and send out reports. Say reports took X hours / days / weeks to complete one report, whereas now multiple reports are updated simultaneously by using different views for multiple managers on one list. Reports are now available 24/7 as the team update the list, as opposed to weekly or monthly once someone had compiled them.

• If you are in charge of cleaning up data from file shares or sites on SharePoint, note how many search results turned up a topic as opposed to after cleaning up the data. Mention also how the use of metadata has made for a more effective SharePoint solution as a result.

• Convert single documents in document libraries into wikis and again take note of the amount of clicks saved with anecdote about better use of information.

• If you have a SharePoint community of practice site (which is good idea), and it has how to’s, common errors, and training material; determine how long it took to educate your user base as opposed to after you had the site. So before you had to sit with new users for X time, now you just refer them to your site and the turnaround time has dropped by X time. Users now do self diagnostic by referring to the error repository and how to’s instead of calling the helpdesk or primary administrator – keep track of how call numbers have decreased as users become more confident and able due to your information sharing.

• If you are the SharePoint champion in the organization, have metrics like having to send out minimum 52 emails a year with SharePoint tips or tricks or news, have to host 6 user groups internally to grow the user base and contribute to user adoption, must conduct 3 satisfaction surveys per year – after each one, record how things have improved or declined then make it part of your next scorecard to address the results and how you plan to do that.

• Have a ‘give us feedback’ section on every site – it will encourage staff to participate. Keep stats on how many people did comment compared to X months later – you are contributing to user adoption and encouraging a collaborate environment (not easy when that is not the inherent culture).

• For administrators, monitor the number of sites, space and users – report on the growth per month as well as the activity of the sites. Report on number of dormant sites – then if you are involved in the training of users as well, how many fewer dormant sites there were after your training.

• A big winner is saving on email which costs organizations a fortune. Specify how many mails used to go out with attachments compared to now. You only send hyperlinks to documents on SharePoint, it has prevented many duplications of documentation going around the company and provided one point of truth. Also state that your policy is to only send out summary Alert Me’s from SharePoint thereby also saving the amount of emails going to staff giving them more time to concentrate on their jobs.

• Monitor the number of documents being uploaded. At the end of a given time period, say there was a X% increase of uploaded content, (if the content doesn’t have decent metadata and naming standards this could work against you, so make sure you have educated your teams properly in following best practices).

• Keep track of the number of responses to discussion forums vs surveys and report on how your study showed that either one is a more effective communication tool. Again, report on the number of responses vs the number of staff, do percentages, before and after the baseline.

Determining metrics effectively is dependent on the right approach being taken from the start. Don’t ask what SharePoint can do for you; ask what you can do for SharePoint! In other words, first you need to identify your business issues, analyse your “as is” situation, decide and document the ideal world scenario, think about how departments get information from each other, how well teams collaborate willingly and how information is found. How are you planning on retrieving your information a year-plus from now? Once you have taken all these into factor, apply the right functionality in SharePoint to each process – then measure it.

Here is a list extracted from Essential SharePoint 2007 by Scott Jamison, Mauro Cardarelli and Susan Hanley on what else to measure and how :

Objective : Maximize the reuse of best practices across the enterprise, enabling the organization to replicate successful business practices in all geographies.
Possible Measure : Quantitative – number of downloads of best practices or reusable assets. Qualitative – usage anecdotes where users can describe in quantitative terms how a SharePoint asset that they reused contributed to business objectives.
Capture Frequency : Monthly
Issues and Challenges : Frequent downloads are a proxy for content value, indicating that the content is delivering value to users. Gathering anecdotes is a labour intensive process and may require some creativity to obtain. You may want to consider a success story contest (with prizes) to get SharePoint users to share high-quality success stories.
Target : Look for an upward trend in the number of downloads for new content or portals. Look for steady state activity in more mature environments. Targets should be set based on the maturity of the solution and the strategic importance of the content. Targets for success stories might be based on the total “value” represented in the stories collected and/or the number of stories documented.

Objective : Improve time to market for proposals and contracts.
Possible Measure : Quantitative – average proposal or contract development time.
Capture Frequency : Ideally captured for each proposal or contract then compiled (averages) on a semiannual or annual basis.
Issues and Challenges : This measure will be easiest to capture if it is already a key performance measurement for the enterprise.
Target : Trend downward from baseline. Target might also be a specific percentage of time reduction.

Objective : Reduce training costs for enterprise applications.
Possible Measure : Quantitative – total training costs for enterprise applications.
Capture Frequency : Annual.
Issues and Challenges : Some organizations justify their SharePoint investment solely on the reduction in training costs. The assumption is that most users are not ‘power users’ of enterprise applications. Instead of investing in full training programs for these users, you only need to train them in the use of the portal, not each enterprise application.
Target : Percentage of absolute reduction in training expenses for enterprise applications.

Objective : Provide an organised ‘one stop shop’ for information for SharePoint users that help them reduce information overload.
Possible Measure : Qualitative – usage anecdotes where users can describe in quantitative terms how using SharePoint has improved their productivity.
Capture Frequency : Monthly.
Issues and Challenges : Gathering anecdotes is a labour intensive process and may require some creativity to obtain. Consider using the built-in SharePoint survey capability. Targets for success stories might be based on the total “value” represented in the stories collected and/or the number of stories documented.
Target : Targets for success stories might be based on the total “value” represented in the stories collected and/or the number of stories documented.

To put this into further context, this is an example of what I had on my scorecard last year for one of my duties as SharePoint champion and responsible for the communication of all things SharePoint :

Measure : Prepare and publish newsletters and articles, establish website, participate and present artefacts to business units and interest groups.

Source : Website, emails, surveys, minutes, site usage stats.

Targets : D Performer – 400 people reached, C performer – 600 people reached, B performer – 800 people reached, A performer – 1000 people reached.

Target Dates : Make SharePoint Community of Practise site part of the Get Fit for IT Program (June); Host 5 user groups or knowledge cafes (November); send 8 newsletters (December); conduct 2 satisfaction surveys (December).

Hope this helps.


  1. MAPILab provides a very good SharePoint usage reporting solution: MAPILab Statistics for SharePoint. Detailed reports on visitors, documents, lists, search and more. You can try free trial version or online demo:

  2. During development, 20 companies tested the solution to measure its impact (for the past 4 years), with results showing cultural and business benefits beyond simply helping employees feel appreciated.

  3. The things to which till yet to which I have deal with SharePoint, I can say that SharePoint is amazing product from an end customer's viewpoint provided that one knows what it does well and can separate stories from reality.

  4. i seen lots of post about this topic but here i you described about Metrics for Business Users and this one different from other.and in extra Customer,organization, employee, usability are also very important topic to measure the SharePoint Development.

  5. Great beat ! I would like to apprentice while you amend your site, how could i subscribe for a blog website?

    The account aided me a acceptable deal. I had been a little bit acquainted of this your broadcast offered bright
    clear idea
    My blog post ... directory

  6. Good day! This post coulԁ not be wгitten any bеtter!
    Rеadіng this post reminds me οf my previous
    room mate! He always kept chatting about this. I wіll foгward this post tо him.

    Faіrly certain hе will have a gοod read.
    Manу thаnks for sharіng!
    Also visit my website -

  7. My family every time say that I am killing my time here at net, however I know I am getting
    experience everyday by reading such pleasant posts.
    My page: hotmail inbox

  8. Amazing blog! Is your theme custom made or did you download
    it from somewhere? A theme like yours with a few simple
    adjustements would really make my blog shine. Please let me
    know where you got your design. Appreciate it
    Feel free to visit my page : reverse hotmail

  9. Your style is so unique compared to other folks I've read stuff from. Many thanks for posting when you have the opportunity, Guess I'll just bookmark this page.
    my page :: Fuck-Video.Org

  10. I do not even know the way I finished up here, however I assumed this post
    was once great. I don't know who you are however certainly you're going to a famous blogger in the event you aren't already. Cheers!
    Check out my blog post :

  11. I am no longer certain the place you're getting your information, however great topic. I needs to spend a while studying more or understanding more. Thanks for excellent information I was on the lookout for this info for my mission.
    Also visit my web site abc distributing company

  12. hello there and thank you for your info – I have definitely picked up anything new from right here.
    I did however expertise several technical issues using
    this web site, since I experienced to reload the website many times previous to I could get it to load correctly.
    I had been wondering if your hosting is OK? Not that I am complaining,
    but sluggish loading instances times will very frequently affect your placement in google and
    can damage your quality score if advertising and marketing
    with Adwords. Anyway I am adding this RSS to my email and could
    look out for much more of your respective interesting content.
    Ensure that you update this again very soon.
    Also visit my site - Academy Sports Dallas

  13. Do you mind if I quote a few of your posts as long as I provide credit and sources back to your weblog?
    My website is in the very same area of interest as yours and my visitors would truly benefit from some
    of the information you provide here. Please let me know if this ok with you.

    Appreciate it!
    Feel free to surf my web page ... meratol reviews

  14. Hi would you mind stating which blog platform you're working with? I'm going to start my own blog soon but I'm having a difficult time selecting between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your layout seems different then most blogs and I'm looking for something unique.
    P.S Sorry for being off-topic but I had to ask!
    Take a look at my web blog -

  15. I every time emailed this web site post page to all my associates, as if like to read it next my
    contacts will too.
    Here is my web site :: buy cheap meratol

  16. Some useful suggetions... i was also thinking potentially growth in number of new user requests... trying to analyse amount of time spent by a user on a site - etc.

  17. Hello everyone, it's my first pay a visit at this website, and article is in fact fruitful designed for me, keep up posting these types of content.
    Feel free to surf my blog : Hotmail Sign In Passport Hotmail Sign In Page

  18. Stunning story there. What occurred after? Thanks!
    Here is my page -

  19. It's an remarkable article for all the online users; they will take advantage from it I am sure.

    My blog post - addison\u0027s disease
    Also see my web site ::

  20. Amazing blog! Do you have any recommendations for aspiring writers?
    I'm hoping to start my own website soon but I'm a little lost on everything.
    Would you suggest starting with a free platform like Wordpress or go for a paid option?
    There are so many options out there that I'm completely overwhelmed .. Any recommendations? Many thanks!

    My web blog: rent property

  21. Hello there, just became alert to your blog through Google, and found that it's really informative. I'm going to watch out
    for brussels. I will be grateful if you continue this in future.
    Lots of people will be benefited from your writing.

    my website info

  22. I must thank you for the efforts you've put in writing this blog. I am hoping to see the same high-grade content by you later on as well. In truth, your creative writing abilities has motivated me to get my very own blog now ;)

    my homepage commercial property

  23. Hey! Ѕomeonе in my Mysρace grοup shareԁ this sitе with us
    so I cаmе tο give it a look.
    I'm definitely enjoying the information. I'm book-marking anԁ ωill
    be tweеting this tο my follοwегѕ!
    Excеptіonal blоg and suρегb dеѕіgn.

    Feel fгee to visіt my blog ... best lightweight running shoes

  24. Do you mind if I quote a few of your posts as
    long as I provide credit and sources back to your webpage?
    My blog is in the exact same niche as yours and my visitors would genuinely benefit from some of the information
    you provide here. Please let me know if this okay with you.

    Appreciate it!

    Also visit my homepage :: green tea hawaii

  25. whoah this weblog is magnificent i like reading your articles.
    Stay up the good work! You know, many persons are looking around for
    this information, you can help them greatly.

    Here is my homepage; acura integra ls illumination switch

  26. May I simply say what a comfort to uncover somebody that actually understands what they are
    discussing over the internet. You certainly understand how to bring a problem to
    light and make it important. A lot more people must check this out and
    understand this side of the story. I can't believe you're not more popular because you certainly have the gift.

    My web blog - learn more

  27. They may volunteer differentprices, types of instalment,
    the cost of roofing company can go up to $12 to $15 per foursquare

    Also visit my page; metal roof installation

  28. Wow, incredible blog layout! How long have you been blogging for?
    you make blogging look easy. The overall look of your web site is wonderful, as well
    as the content!

    My web site ... for more

  29. Additiοnally, stars can bе easily іncorpoгated
    with аnother image to create a more cuѕtom аnd
    unique design. Therе tend to be many deѕignѕ that ехist and this apρroach maκes zеroіng іn
    on a partіcular choicе even mοre difficult.
    A tattoo placеd in the boԁy's posterior side is becoming more popular these days.

    Also visit my blog ... tattoo idea

  30. Hі there wοuld you mind letting me knоw which webhоst you're using? I'vе loadeԁ your blοg in 3
    completely different browsers anԁ I must say this blog loads а lοt quickeг then most.

    Cаn you suggеst a good internеt hοsting ρrovidеr at a hоnest pгice?
    Kudos, I appreciate it!

    Also visіt my web-ѕіte :: crear facebook gratis

  31. Hey there I am so thrilled I found your site, I really found
    you by error, while I was searching on Google for something
    else, Anyways I am here now and would just like to say
    many thanks for a remarkable post and a all round enjoyable blog (I also love the theme/design), I don't have time to browse it all at the moment but I have bookmarked it and also added in your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the great job.

    Feel free to visit my web page :: click here for naked men

  32. Thankѕ for the gοοd writeuр.
    It actually used to bе а leisure
    aсcоunt it. Look complex tο mоrе delivered agгeeablе from you!
    Bу the way, hοω could we keеp іn touch?

    Feеl freе tо surf tо my pаge; crear facebook gratis

  33. You don't want to pick something that everyone's heard bad things about, even if this is just because these drugs are more popular.

    In addition, you will get a permanent enlargement in a few months of use.
    Conversely, alternatives like weights or jelqing means decreasing sensitivity in a
    man's libido.

    Here is my web-site - buy vigrx plus

  34. Hello, I do believe your website could be having internet browser compatibility problems.
    Whenever I take a look at your blog in Safari, it looks fine however, if opening in I.
    E., it's got some overlapping issues. I just wanted to give you a quick heads up! Other than that, great blog!

    Feel free to visit my website ... buy virility ex

  35. Whats up this is kind of of off topic but I was wondering
    if blogs use WYSIWYG editors or if you have to manually code with HTML.
    I'm starting a blog soon but have no coding skills so I wanted to get guidance from someone with experience. Any help would be greatly appreciated!

    my web-site; buy provacylprovacyl review

  36. I think that what you typed was actually very reasonable.
    But, what about this? what if you were to write a killer title?
    I mean, I don't wish to tell you how to run your blog, however suppose you added a title that makes people want more? I mean "How Do You Measure SharePoint - Metrics for Business Users" is a little plain. You could peek at Yahoo's home page and see how they create
    article titles to grab people to click. You might try adding a video or a related pic or two
    to get people excited about what you've written. In my opinion, it could make your website a little bit more interesting.

    Feel free to visit my page; longinexx male enhancement

  37. I јust coulԁ not leаvе yоur website prior to suggeѕting that ӏ actuаlly lоveԁ the ѕtandard
    іnformation a person supply for yоur viѕitoгs?
    Is gonna be again steadily to inspect nеw posts

    My webpage - Abrir Cuenta Facebook

  38. Hey there! This is kind of off topic but I need some help from an established
    blog. Is it difficult to set up your own blog?

    I'm not very techincal but I can figure things out pretty fast. I'm
    thinking about creating my own but I'm not sure where to start. Do you have any ideas or suggestions? Cheers

    Here is my webpage - to Lose weight Fast

  39. Hello therе, I ԁo think your wеbsite may be hаνing wеb browser compatibіlitу issues.
    Whenеvеr I look at your website in Safari,
    it looks finе howeѵer ωhen opening in I.
    Ε., it's got some overlapping issues. I just wanted to give you a quick heads up! Other than that, excellent blog!

    Also visit my blog :: facebook cuenta gratis

  40. Gеnerally Ι don't read article on blogs, however I wish to say that this write-up very forced me to check out and do so! Your writing style has been amazed me. Thanks, quite great post.

    Look at my web-site ... crear facebook

  41. rosacea doctor Sweetwater Station

    Here is my blog: Nocona rosacea laser treatment

  42. home remedies tennis elbow tendonitis

    Visit my web blog ... massage techniques tennis elbow

  43. The program comes with full warranty 60 days money back,
    so everyone can actually try this muscle building system
    for a few weeks and see the results without any risk at all.
    Many people wish to increase their lean muscle mass and create
    your toned, developed body that is not only aesthetically attractive, but strong and healthy additionally.
    Whenever upgrades became ready you'll fully grasp this totally free no matter what quantity of money cost to establish them.

    Also visit my web page ... Somanabolic Muscle Maximizer Review

  44. Spot on with this write-up, I actually believe this amazing site needs far more attention.
    I'll probably be returning to see more, thanks for the information!

    Have a look at my homepage:

  45. Why viewers still make use of to read news papers when in this
    technological globe the whole thing is available on net?

    Here is my site ... insane workout

  46. I'm really impressed with your writing skills and also with the layout on your
    blog. Is this a paid theme or did you modify it yourself?
    Either way keep up the excellent quality writing, it's rare to see a great blog like this one these days.

    my page; ()