Build Business Smart.

How Data Analytics Can Help NGOs Fulfill Their Social Mission

NGOs, also known as non-profits here in the U.S., fulfill a very important role as they seek to accomplish social good. They are in a unique position that allows them to see social need and react to it in ways that often times have more impact than other organization’s efforts could. Vault is looking to apply the science and art of measurement and data analytics to help NGOs accomplish their various missions, and we believe that if applied correctly, analytics can make a huge difference in NGO effectiveness

We’ve broken down the process of how to use analytics for NGOs into three categories, summarized below. We feel that it presents a systematic and practical approach to foster performance management and measurement in these organizations.

Measurement

The first hurdle that must be crossed is that of measurement, of taking the time and effort to measure work and progress and collect it in a database for further analysis and presentation. There are several reasons why it is important for an NGO to measure its efforts:

-Make sure time, effort, and money are being used where they need to be
-Gain ability to prove that you are accomplishing and fulfilling your social mission
-Gain ability to show that donor and sponsor funding is being used effectively

There are a few things to keep in mind when implementing a measurement strategy. First – it is important to not only measure the end goal, but also the incremental steps that lead up to that goal. Let’s say your organization’s mission is to decrease the number of diabetics within a specific demographic in your community. Measuring the % decrease in diabetes withing this population over a given time period is great, but it doesn’t tell the whole story. Ask yourself, what are the incremental steps leading up to the lowered diabetes rates? Perhaps one is the amount of exercise the average person in the demographic is getting on a daily basis. Perhaps another is the amount of sweets or fatty foods the average person is consuming per day. As you attack these issues that lead to diabetes, measure the improvement in these areas. Then people get the whole story of where your efforts have helped reduce each aspect of the larger problem – and you can find out which efforts are the most effective at getting rid of this problem.

Second – make sure and measure regression rates. Too often we stop the measurement once the problem is solved – once we have lowered the diabetes rate, in this case. But how many of those people, after we stopped working with them, have regressed into having diabetes? This is sometimes an alarmingly high number, and when regression rates are high, that means all the work we performed to lower the diabetes rate in the first place has gone to waste. If you see through measurement that the regression level is high, it’s time to implement some strategies and efforts into keeping the solution in place – that is, not losing ground once you’ve attained it. It’s often a lot easier to keep the problem gone than to go back and fix it again. This allows you to really fulfill your mission, in a lasting sense. It wastes less resources because you retain the ground you’ve gained. And donors and sponsors will be excited by the fact that you can show that your solution is a long lasting one.

Analytics

Once we have measurement strategies in place, now we have lots of data on our hands. Analytics is the process by which we extract useful intelligence from this data. There are many methods of doing this, whether it be through visual analysis techniques, statistics, predictive models, etc. (specific ways on how to do these types of analysis will be the topic of subsequent posts) Many people think that analytics is a task that is beyond their abilities, but many times even simple analysis will result in sufficient intelligence that you can use to do your work smarter.

One of the most important things to remember in doing analysis is the principle of segmentation. This means looking at the data in smaller pieces, rather than in aggregate. For instance, if you want to know who your most effective workers are, break down the data to show you the hours each worker put in, and the changes in the incremental metrics we discussed above that occurred as a result of their work. Maybe you want to know which types of donors consistently give high sums to support your work – break them down by demographics, or by income, or by age, or any other variables to get a view of what your ideal donor looks like. Then you can target more of these kinds of people in your donation campaigns.

Presentation

Not to be forgotten is the element of presentation. Once you have the data and all the analysis, you need to be able to present the intelligence you’ve found to others in a way that they understand, and in a way that will cause a change in their behavior. The intelligence from the analytics is there so that you can be more effective in your work; however, if no one understands it, nothing will change and it will be useless. There are a few easy guidelines to follow in presenting analytical information so that it sticks:

- Relate the numbers to something people understand (Just saying the number 416 can be somewhat abstract, but if you say instead “the number of people that fit in a Boeing 747″ the number becomes real and concrete)
- Only show the necessary elements of analysis to get your point across (many times you’ll have to go through a lot of analysis to get a few golden nuggets of intelligence, and our tendency is to want to show off all of the work we did to get there. The problem is, the process is not important to the people you are talking to. What’s important is the results and intelligence, so just focus on that.)
- Keep it simple (showing too many variables on a graph, or just plain too many graphs, causes more confusion that it does clarity)
- Relate the analysis back to what concerns your constituents (Your focus should always be on solving the problem, and the analysis is only important insofar as it helps you to do that. Focus on what solves the problem for the constituents)

Hopefully this small outline gives you a framework that you can use in thinking about how to implement analytics into your organization. In the coming posts we’ll be discussing more in depth how to do each of these three points.

What do you think? Is this information helpful?

How to Quickly Uncover Leads in Google Analytics Data

If you are running Google Analytics, then inside your data you already have a list of leads visiting your site. Who’s going to complain about getting a quick list of sales leads interested in what you have to offer? The following video describes how to get these leads; we’ve also provided an excel spreadsheet download that will make the process even faster, as explained in the video. Good luck finding those leads!
Excel Icon
Download Free Lead Filter

 

Marketing Analytics Links of the Week

News

Mobile marketing analytics news
The worlds largest mobile ad network, InMobi, has just announced new reporting and analytical tools that aim to increase marketing ROI for those pursuing mobile advertising. New abilities include advanced segmentation and filtering, and a better user interface. This move is an important one to watch for anyone wanting to reach a mobile audience.

 

Inbound Calls Analytics
AdTraka, a company that sells telephone conversion tracking systems, has come out with new analytical capabilities that allow companies to know which key-phrases are responsible for telephone inquiry generation. Now you will be able to know which campaigns are the most effective in generating inbound calls, allowing you to focus your efforts and cut unprofitable campaigns.

 

Google Tools

Full Referral URLs from Google Analytics
This article shows you how to use custom filters in Google Analytics so you can track full-referral URL’s. This way, instead of getting a broad picture of what domains are linking to you, you will be able to see specific pages.

 

URL Tracking
Free Google tool to create URLs that can be tracked so that you can measure your marketing campaigns

 

Onsite Targeting with Google Analytics
It appears that in the near future you will be able to serve up customized content to specific we visitors with the use of Google Analytics.

 

Articles

Find the 1% of visitors that count
Interesting study that found that 1% of site visitors generate 20% of all its traffic by sharing its content. Further, these 1% of influencers drive conversions on your site. Find and engage the 1%, and you indirectly engage everyone within that influencers social sphere.

 

Mobile Marketing of Social Media
Kevin Hillstrom suggests that too many people are talking about social media, while mobile marketing is being overlooked. This is unfortunate, as mobile marketing can be easily tracked and is going to be a huge way of advertising in the coming years.

Crowdsourced Analytics: Solving Social Problems with Data

Data can tell a great story. Don’t believe me? Check this out.

But a story is so much better when other people get to contribute, adding their unique take on things. We set out to do just that. We wanted to use data to tell a story, but make it both accessible and interactive. We’ve taken a data set of metrics gathered across every county in the U.S. that can in some way be correlated with diabetes rates. The metrics have different effects according to the region or state counties are found in, so possible ways of looking at the data are endless.

The data visualizations can be found here.

We figure enough people looking at something like this can start to create big changes. Feel free to explore, interact, analyze, and gain insights. What does the data tell you? Share your thoughts/insights below.

Competitive Intelligence in Washington DC to Increase Sales

Below is an interactive visualization of 2010 data from Washington D.C.  By using it, you can find:
1) What products/services agencies in the area are buying
2) Which agencies are buying
3) Who they are paying
You can measure demand, identify potential customers, and find competitors, all in one easy visualization.  All of this information will allow you to increase sales.

To use the interactive features:

Moving the slider bar, the graph will automatically filter to give you only the ranges of money spent you specify

By clicking on one or several of the services in the first graph, the second will automatically filter to show you only those agencies and suppliers that bought and sold in that specific category.

Let us know if this interactive visualization is helpful, and what else you’d like to see in the comments!

Using Analytics for Sales: Internal Data Highlights External Sales Opportunities

Crafting a good sales pitch can be difficult. Getting the right data, hitting the right client pain points, crystallizing why your services are better than the competitors, all takes hard work. Honing your sales pitch to an art takes time, and even with a perfect picture, new clients take time to acquire. One of the best ways we’ve found to build a good sales pitch is to use data you already have.
In the digital world, there is no shortage of data, which translates into no shortage of potential competitive insights and advantages. With databases, data warehouses, corporate intranets, best practice sharing, web analytics, voice of the customer information, and QA or Six Sigma data, you are well-poised for discovering good information.

Finding ways to mash those together into meaningful new understanding is the key. Here’s an example of an analysis we performed for a client. They wanted to know how they could meet more of their current customers’ challenges. This would result in higher client satisfaction, increased revenue (from cross-sells), and could help them in future sales efforts with potential clients.

We took their entire list of current clients and added the following data:
• Industry
• Number of employees
• NAICS/SIC code
• Site locations with latitude/longitude coordinates
• Number of times they had been serviced (grouped by dates)
• Customer satisfaction survey data

This gave us a holistic view of challenges faced by specific industries. To obtain this, we used data from our client’s data warehouse as well as used LinkedIn, Yahoo Finance, Dun & Bradstreet databases, Client websites, and social media. Doing this definitely took work, but it highlighted thousands of dollars worth in future revenue and client retention. See a portion of the analysis below.


This graphic depicts problems our client's customers faced.  The customers are grouped by industry.

 

For example, we quickly saw that the challenges faced by the banking industry were different than those faced by the inorganic chemicals industry. But we also saw that the challenges within industries were relatively the same. All the chemical companies struggled with the same things.

Using insights like these, we were able to pinpoint those clients who were lagging behind their industry peers in dealing with a certain challenge. This created cross-sell opportunities for our client. They were able to take the data and highlight these problems to their customers and show how their solution was solving similar problems for other members in the industry. This not only improved revenue, but also will increase customer satisfaction scores, as well as create more focused sales opportunities in the future.

Similar insights and opportunities are lurking in your own data. You just need someone to unlock them for you.

What do you think? Using the same data, what other ways could it be analyzed to find insights? How have you found insights in your own corporate data? Share your story.

Twitter Efficiency Metric: Total Retweets /# of Followers

How is it Calculated?

For a given period of time, it’s simply your total retweets (given by Klout, see yesterday’s post) divided by your total number of followers.

Business Goal

This metric points to is how much you are thought of as a thought leader from your follower base. Becoming a thought leader has benefits for virtually any business because it has the effect of gaining the trust of your customers. As this number increases, it shows that you are increasing in thought leadership, as more and more of your followers are retweeting (you can think of it as syndicating) your thoughts, and recognize them as useful or authoritative.

How do you increase it?

Two ways – One, target your audience better. If the people following you are really interested in your business, then it’s easier for them to pay attention to what you say. Two, work at refining your message and the delivery of message. How you say something, and the medium you use, can have a big effect. Do your followers respond better to videos, podcasts, whitepapers, case studies, blog posts, or photos? Do some experimentation to find out what works best for your audience, and link to those things from Twitter.

Twitter Message Amplification Metric: Total # Retweets

How is it Calculated?

It’s just the total number of times that your tweets have been retweeted in a given time period. You can get this one from Klout as well.

total retweets

 

Business Goal
If it’s important for you to reach as many people as possible with your message, this is a good metric. It’s generally good for B2C firms, as the more people that know about your product the more customers you receive. The metric shows message amplification – as the number of retweets goes up, the amount of people that see your message increases dramatically. Since the average Twitter user has a few hundred followers, retweets have the potential of reaching a lot of people. It also shows how interesting or easily sharable your message is, indicated how likely it is to spread by other mediums besides Twitter. Measuring the retweets for specific tweets would also be useful to test and try which messages are the most sticky (for this you can use tweetmeme).

How do you increase it?
You increase this by sending out messages that are useful, valuable, interesting, and targeted to your followers. Another factor is your authority – if people recognize you as a leader in your industry, they are more likely to trust your tweets and retweet them. Retweeting other people’s material (participating in the community) will also help increase your retweets by the law or reciprocity.

Twitter Engagement Metric: Follower Mention %

How is it Calculated?
The amount of followers that have mentioned you with an @ message / Your total number of followers. The easiest way to get this one is by signing up for a free Klout account, and it will automatically be calculated for you.

Twitter Engagement Metric

Twitter Engagement Metric

Business Goal

Follower mention is an excellent engagement metric. It indicates to what extent you are connecting with other users on twitter and developing real relationships. It can also be indicative of how valuable your tweets and content are to others, as the more value they see in what you have to say, the more likely they are to mention you.

If one of your business goals is to become a thought leader in a certain niche, or to build a larger community base of people that trust you and that you can do business with, then this is a good metric to follow. This is a valuable goal for almost any company, but especially for B2B firms, as sales in that situation requires good relationships and high levels of trust. To be sure if this metric is for you, you should probably ask yourself the following questions:

Is my target audience on Twitter? (try checking Twellow or Twitter search)
Are the people that influence my clients and customers on Twitter?
Is building a strong online community important for my businesses success?
Could I find potential partnerships or other opportunities from a Twitter community?
Is user engagement an important part of my brand and business?

How do you increase it?
You increase this metric by being social and helpful to others. An important part of this is reading other people’s tweets so you know who they are and what they are thinking about. Then you can start conversations with them, mention them, ask them questions, retweet them, give referrals to them, etc. Common courtesy also goes a long way; if someone else’s tweets are useful to you, let them know and thank them. And if you are mentioned in that way, be sure and let them know their mention of you is appreciated.

A Case for Analytical Marketing and Metrics

Some people try and debunk the move to analytical marketing. Their arguments are usually that the numbers don’t matter, that it’s impossible to track things such as social media, and that getting caught up in analysis takes you away from what’s really important in marketing. Many of these arguments come simply because the person arguing the point doesn’t understand how to do analytical marketing in a way that produces real insight and real results.

Knowing how to design marketing campaigns that can be tracked and measured requires careful planning and skill. But considering the benefits of being able to know if the marketing money you’re spending is moving the needle, it’s well worth the effort. Data analysis and campaign tracking has the added benefit of allowing you to see otherwise hidden insights so you can make changes to your marketing strategy and gain optimal results. If you are foregoing the use of metrics and analytics, you are stuck in the trees without a view of the forest.

According to your specific business and goals, there are various metrics you can use to help you track your progress and optimize your strategy. Once you know your goals, you can think through which metrics will help you reach them. To this end, the next several posts will be dedicated to goal-based metrics. We will examine specific metrics, what they tell us, how they are calculated, the best ways to implement their tracking, and what business goal they help us achieve. The hope is that you will be able to take some of these metrics and implement them to enhance your own business strategy.