Category Archives: data managament

CRM Adoption: It’s not a Marathon, It’s a Triathlon

Picture this: you have a count-down clock, ticking down with single digits left. Conversion of data has been tested. Training engaged the whole team. You’re ready for go-live….except you’re not. You’re not because Go-Live is, best case, just the middle of the process. And, this is a problem because:

  • Leadership thinks the “go-live” means “project complete”.
  • Finance thinks the fiscal spigot can be turned off.
  • Field officers think they know just how to use the system.
  • A raft of reports, business process re-engineering, and other steps remain.
  • Oh, and you need to see whether the year-end procedures that work in principle will work in reality…in 9-12 months.

Expectation management that starts in #CRMSelection and carries through to #CRMImplementation must be an ongoing part of #CRMAdoption. For starters, system transitions (I often use “transition” or “replacement” to indicate that these changes are more than a conversion, etc.) have very long tails. Even though the volume of work happens in the first 1-2 years, another few years are often necessary to really refine, leverage, and optimize the new system. This means that, as one of my most contented and expert CRM clients experienced in their journey, a 5-year plan and budget is a smart way to go.

After good planning and a reasonable budget, the starting point for solid adoption is basic: great data. Trusted data, converted correctly from the old system. While this seems like a “didn’t go-live cover this” item, many of my clients find either issues for months or change their minds about data codes, locations, applications, etc. such that back-end global changes are necessary.

Reporting is often the epitome of post Go-Live pain point. It is hard for your colleagues to adopt the new database if they cannot get data outputs. My rule of thumb for any system transition is simply that “great reports mean great transitions”. Such reporting requires shared definitions, thoughtful calculations, mastery of new tools, and other benefits to long-term adoption.

Integrations with other systems present another likely post Go-Live adoption. Typically, things like the feed to Finance are ready to roll before conversion is complete.  However, often patient feeds, student feeds, parent feeds, athletics feeds, online engagement tool feeds, etc. may not be in place at Go-Live. One client recently made the mistake of going live without a functioning feed to a high-volume gift generation foundation, only to be crippled by the extra dozen+ batches of gifts to manually handle each day.

Training is another core consideration for effective adoption. For starters, Training is not a spectator sport and should extend permanently after Go-Live. Training options should be varied (in-person, desk-side, computer-based) and be paired with accurate, update documentation. New staff on-boarding should be factored in.

#CRMAdoption is more than a Marathon

Go-Live as the Middle of the Race

I’ve always been a fan of the explanatory power of metaphors and similes, especially sports metaphors. “Crossing the finish line,” “Being a good team member,” “Handing off the ball” all make complicated things clearer (for me at least). So here is a way to sum it up:

Go-Live is more like finishing the cycling leg of a triathlon. You haven’t crossed the finish line yet. The good news is you didn’t drown during #CRMSelection and now #CRMImplementation is mostly complete….but you still have a pesky marathon to run.  Adoption requires all of those items above–data, reporting, integration, training–to be successful. And, too often, organizations go live well before they were ready for it.

Many say that a conversion is a marathon and not a sprint, but to fully transition to a new system, it’s more like a triathlon.

Do you have any good CRM-related metaphors? I’d love to hear ’em. ~Chris

5 Considerations for Successful CRM Implementation

I (well, the whole Zuri team, really) have the good fortune of helping dozens of clients figure out their successful CRM Implementation. Should they stay or should they go? Go where? When? How much will it take? And, what should they do about that athletics/marketing automation/grateful patient/data analytics/[insert here] tool? A well-organized selection process (see some ideas on that here) should have you well-positioned. And, ideally these 5 considerations for successful CRM implementation should be dialed in…but, too often, they remain unresolved after selection and can derail implementation.

Once you sign, there will seem like a million issues to consider as CRM implementation begins. Of course, things like an effective kick-off week are important. Logistics, understanding current state practices, etc., etc. all matter. But, as the saying goes “some animals are more equal than others”. As your team is wrestling with getting office space and picking an issues management tool (you know, the easy stuff), here are five things that you MUST handle:

  1. Culture. The thought leader Peter Drucker stated that “culture eats your strategy for lunch.” All of the planning in the world can fail if you ignore culture. This means analyzing who has hard and soft power in the process, aligning project components with the right players, and maintaining open communications. This also means including the least engaged (and sometimes most hostile) people.
  2. Gaps. Whatever you buy, no matter how expensive your new CRM, it will have some gaps. Identifying and understanding these is essential to the project’s success. “Gap” may mean some customization that your vendor will build (but has never been done before, may not work, and may push your go-live by 6 months!). “Gap” may mean that Alumni keeps their online engagement tool, despite the potential for moving all functions into one stack. Being thorough and honest here is critical.
  3. Risks. Culture+Gaps=Risks (well, sort of, you get the point). Of course, not all issues, gaps, or obstacles are really risks. You should track those issues that are identifying, under control, and will require time and attention. But, some things are monsters! Will that Dean go rogue? Did the board approve a budget with enough resources? Will your vendor deliver on time and on budget, despite a track record of overages and shortcomings?
  4. Timing. Too fast will kill you and too slow will bore you. For big shop, under a year is a pipe dream (and someone will get fired). Much over two years doesn’t tend to match how organizations function, how long leadership stays in place, campaign targets, and other realities. Dialing in culture, spec’ing the gaps, and protecting against risks will help you determine the right length of time. There is also the small matter of when to get started as key institutional dates and calendar and fiscal year-end realities must be accommodated.
  5. Expectations. When you blend the other four considerations, you will be stuck with countervailing forces…don’t go too fast or too slow…work this into the organization’s calendar that never seems to have a down moment…sell folks on the 360 degree view of CRM knowing it has gaps…persuade folks that technology is key when offline principal and major gifts may drive the bus…which all boils down to managing expectations. A project charter is a great start. Weekly updates, transparency, one-offs with key players, a Champions Committee, and other steps will help. Being disciplined and focused is important. Expectation management cannot be underestimated in successful CRM implementations.

And, one last thought: inherent in all of these considerations is that perhaps most important to success is to be honest. Honest about culture, gaps, risks, timing, and expectations. Because, as we all know, this will be a marathon and not a sprint, it will take a village, and, whenever possible, avoid mirroring the Dilbert cartoons (see below).

Kidding (yourselves) will be counterproductive

5 Thoughts about the (not-so) Fine Print in CRM Selection

Does your organization need to consider a new Constituent Relationship Management (CRM) system? Is CRM Selection on the table? Have you explored the market? Secured responses to an RFP? Conducted demonstrations? Starter or even completed conversion to the shiny new CRM?…. only to find you didn’t get what you needed? Or, you got to the 20 yard-line? Or, you now need to buy another application or two to get whole? Welcome to the club.

Too often in these processes, organizations drink the “sales kool-aid” from vendors, get “wowed” during demonstrations, and are left with an 80% solution, locked in due to fine print during a CRM selection process. Two of my clients are dealing with this issue right now, as in, today...a dozen or so face it each year. My company Zuri winds up parachuting in to way too many problem implementations due in part to these fine print situations.

What’s the solution? How do you protect your organization during the selection process while helping to ensure success long-term? Here are five key considerations:

  1. Bluntness and Discipline. Don’t mince words with your vendors. Record and remind them of what they promised. Stick to your guns, the script, and the schedule. This also means you need to watch out for scope creep so you aren’t the cause of delays, bottlenecks, or wishful thinking.
  2. Zealous Advocacy. Remember that you are your organization’s best line of defense to avoid being sold on sub-par solutions. Ask for the moon. Expect great results. Don’t accept that first or second “no” from a vendor. But, follow the plan that is in place and persuade your colleagues to get on-board.
  3. Red-Lining. Never sign a contract before a careful review. If there are terms that are unclear,  get your red pen out and mark up the document. Watch for broad or simplistic language like “will be completed in a standard fashion”.  Nope! Instead, mark those up to read “…in a fashion accepted by [insert your organization’s name]”.
  4. Skip/Script the Sales Pitch. Bright, shiny sales pitches often get us into this mess. Don’t allow the vendor to show you the sizzle and ignore the steak. Instead, script the vendor’s demonstrations to prove that gift processing, prospecting, direct response, stewardship, and analytics work actually work in the proposed solution.
  5. Heed the Advice of Others. Finally, make sure you listen to what references (or lack thereof) are telling you. A vendor that states “we only share references during the contracting phase” probably have a lot to hide and hope you’re too far down the path with them to pull out. So, make those calls and then circle back to vendors to resolve the gaps in the pitch versus the performance.

That last thought is a little self-serving. This sort of CRM Selection counsel is what we do everyday. I’d submit we’re pretty good at it. So, if Zuri can help, drop me a line (and hold me to these same points!). Good luck.

Advancement technology satisfaction survey

Zuri Group and EverTrue recently conducted a thorough survey of advancement users’ satisfaction with their systems. The central finding was that users are unimpressed with their resources. Dissatisfaction with databases, reporting tools, analytics resources, and other important fundraising tools was often 40% or more. And, the typical response for nearly all of the questions was “it’s ok”, which means that “Meh” is the average sentiment among our users. You can check out the report here: The Advancement Technology Landscape 2017 – EverTrue and Zuri Group

Here’s a sample of the report that highlights the challenges faced by our advancement technology environments:

Advancement technology satisfaction
Reporting, a central solution for advancement programs, is failing to meet demands.

The trend for the survey suggests that “common” issues (like gift processing) received better satisfaction scores whereas more innovative and new areas, such as social data management (which only a few companies, like EverTrue, really address) and analytics, received lower satisfaction scores. Some of this may simply be the typically slow technology adoption our industry experiences. However, it is important to move beyond the “we don’t have the money/time” argument and start to examine the roots of these issues and how your institution can begin to improve satisfaction.  Our users clearly want more and better solutions.

 

There are some solutions and some ongoing obstacles to improving the advancement technology landscape. To solve the issue, non-technical tactics like building trust and negotiating expectations are more important than you might think. Delivering on the fundamentals–accurate, complete and timely data–and adopting a PR-style, metrics-driven strategic information management approach will gain some favorable survey points. However, the lack of funding for, and innovative technical solutions to, fundraising applications remain pretty substantial problems. Thus, expectation management will be a critical component of your effectiveness.

What is your team experiencing? How have you improved user satisfaction at your institution? Share your best tips and tricks to help tackle this ongoing challenge.

 

Reversing the Alumni Giving Slide: Hope is Not a Strategy

Fewer than 1-in-10 alumni give back! What are you doing about this? And, how long will it take you?

A slide like this is requires a qualitative paradigm shift, not a quantitative shift
Alumni Participation for 40 years: A slide like this is requires a qualitative paradigm shift, not a quantitative shift

Many in our industry have been pointing to the declining alumni participation rates. This isn’t new; since the 1980’s, the rate has dipped 10%! The alarm that these rates should generate, however, has been muted. The malaise toward this decline is likely due to the increasing average gifts education institutions are concurrently experiencing. Even for engaged or elite institutions, this downward trend is, well, alarming. The CNN Money article highlighting this decline points to multiple degrees across multiple institutions as a cause, as well as overall indebtedness experienced by recent alumni. If this were the case, I wouldn’t be so worried for our long-term health. But, I am. And, you should be, too. Here’s why:

  1. Now or never. If you don’t reach your grads from the last 10 years (often called GOLD—Graduates of the Last Decade), they tend not to be reclaimed. Life and other philanthropic interests just get in the way.
  2. Competition is fierce. As the hyper-successful ALS ice bucket challenge is proving (and Kickstarter, fundme, and other “give-right-now” opportunities reinforce) there are only so many disposable income dollars. Giving is typically 2% of GDP each year; it doesn’t rise or fall much, and, in 2013, Warren Buffett was about 1% all giving in the U.S.! If you wait to engage donors on your timetable, other nonprofits may slide in ahead of you.
  3. Education is changing. The days of “the best four years of your life” as a case for support are changing. Campus-based higher education will not be replaced, but many alums did not and will not really imprint with their alma mater.

Many institutions are trying mightily to change the trend. The costs can be great and the return can be fleeting. A few benefit from tightly knit alumni bases with a culture of philanthropy But if yours doesn’t, you need to act. Given the three reasons for alarm, your annual giving effort must change, potentially radically.

Direct mail? Sure, but no longer on your calendar…move mailings to gain preemptive gifts from those who will be poached by other causes. This point cannot be emphasized enough. Your competition isn’t just the crush of holiday mailings which may drown your year-end mailing; the real competition started yesterday, doesn’t care what your mail house schedule is or how long it takes to get an appeal letter approved, and–by today–may have siphoned hundreds of your donors’ disposable income away through crowdfunding, self-funding sites, slick Facebook apps, and other tools that higher ed has been slower to adopt.

Phonathon? Yep, except work harder to get cell phones and build a texting-based strategy.

Social media? Of course, but don’t expect “ice bucket” results. Instead, start with data and analysis, identify and engage well-networked alumni and ask them to tweet, like, and post on your behalf.

Peer-to-Peer? Many in higher ed have great success with “class agent” models. These need more sophisticated tools to support more wired alumni groups. Excel files emailed on an occasional basis are not going to do it for most alums who want to help.

Email? Yep. But, as with cell phone and direct mail, data quality and targeting must be improved.

If you don’t have the budget or the base to tackle the issue, there is a less palatable option—change your focus. We all know US News & World Report is a beast that must be fed. However, only sizable percentage gains will likely affect your institution’s positioning. With your data, annual giving avenues, and donor behaviors, is a 20% gain at all feasible? How much will that pull up your ranking? Most will find that this is a stretch goal, at best. So, dive headlong into retention and upgrades as parallel measures of success. Bring up average gifts…literally by generating larger averages and tactically in board presentations and as metrics.

The future of education may be so different than anticipated that any predictions will be way off. However, this doesn’t mean that preparation and reinvention should be postponed. In fact, because we don’t know what’s coming, we must immediately tackle the sliding participation of our young alumni while working diligently to retain or reclaim more seasoned alumni.

Hope is not a strategy so get going in changing your approach to changing alumni behaviors.

3 Analytics Challenges: Context, Endogeneity and Spurious Results

Donor Analytics ContextAn interesting visual depiction of spurious correlation (check it out here) reminded me of my grad school days and the rigor with which I would build hypotheses. Rather than let R, SPSS, or Excel correlate away and then proclaim some amazing finding, I started from the reasons and results I expected to validate with data. The difference is, all too often, that the former approach tells you very little due to endogeneity, spurious results, and the lack of context.

Some organizations–Google is known for this–will say “don’t worry about the why”. Some have referred to this approach as “theory-free“, a nice euphemism to indicate how little long-term value we might find in these correlations. Now, for consumer behavior where Big Data is truly present  perhaps this works. But, data points are rarely available for nonprofit analytics in the same way as, say, Target and Wal-Mart have data…although there are new options underway, like David Lawson’s newsci.co.

And, if you talk with a gift officer who’s been disappointed with predictive modeling results, you see a different picture. From that vantage point, the analytics results are frequently devoid of context. The result confirm what we already knew (“these prospects look rich! they live in a nice neighborhood!”) or reflect a pattern we already see (“they gave last year! let’s ask them again!”). Yet, modeling doesn’t typically improve relationships with prospects.

A big culprit: Context. Donor context is critical in building relationships. And, context is quite challenging to incorporate into modeling. The following are real examples of discussions about potential prospects surfaced by a context-free model:

  • “Sure, Jane looks promising, but we don’t have a phone number to reach her and no volunteer connection, so how likely is it she’s approachable?”
  • “Absolutely, Ed looks great, but did you know he just filed for divorce?”

The solution to this issue isn’t to cast off analytics. It’s to improve it. Start with and add in theory. Guard against spurious results. Don’t elevate an endogenous variable as meaningful. And, most of all, our industry needs resources that can actually add context to results. As a student of philanthropy, I am anxiously awaiting the time when our new science of analytics better delivers on the hype and improves our understanding of donor behaviors, while avoiding endogeneity and spurious results.

Are you using Infographics as reporting tools? You should be.

During National Business Intelligence (BI) Month, a number of top-notch infographics have caught my eye. These handy visuals are really reports, depicting data and details germane to a topic. But, they are also much more. They provide guidance about how to use the data. They tell a story. They provide business process guidance. In short, they’re quite helpful and you should be looking into how these can help your fundraising efforts.

I should note that I know this topic is not new. Infographics have been around for years and some folks have declared them irrelevant or unhelpful. However, any visualization of information that tells the story you need told can be valuable, so infographics likely have utility in your shop.

BWF Analytics Infographic

For example, our firm created a handy infographic (on the right) to present data from a survey we conducted on analytics. This image is really many reports in one. It presents the data in a logical order. In general, it is a useful guide to the topic of fundraising analytics, benchmarking for staff, and related information.

So, how should you set about creating an infographic?

  1. Determine your topic. Infographics can be great for 40,000 foot ideas as well as minutia, but generally not both.
  2. Find your data. What data do you have to display? What data would you like to go get?
  3. Lay out your story. The visual aspects of this process are important. Do you want the reader to “take it all in”, “follow along”, or just see some useful visual depictions of data and interpretation?
  4. Pick a infographic tool and get going. Many tools are out there. Check out this resource for some good and free tools.

Finally, I thought I’d take some of my own advice (for a change!). Below is the inaugural fundraisingoperations.com infographic. It uses data from a survey I did for my 2011 book An Executive’s Guide to Fundraising Operations. While my effort isn’t as amazing as this awesome college football bowl game pic, I created it in 20 minutes. Have any great infographic examples? Drop your links in the comments. Happy infographic-ing!

Data Quality and Quantity, v2
This pic presents data from Cannon’s 2011 book on fundraising operations, which shows how data quality expectations and perceptions vary.

Get your grateful patient process going

It’s 2013…a lot transpired in recent months that may affect healthcare fundraising. New and different taxes. New and different healthcare provisions. New and (potentially) different court rulings. But, one this hasn’t changed: your organization must get serious about installing and leveraging an effective grateful patient program.

Great grateful patient and family programs have interrelated components–physicians and other care givers, admissions, development, and compliance folks are all in the mix. None of your internal sensitivities should be ignored, but none should be allowed to derail an effort to put a great, HIPAA-compliant process in place. We also know that some parts of a program matter more than others. In particular, physician referrals seem to make the most difference. A robust, end-to-end business process will cement the behaviors needed to capitalize on, or start to create, such referrals.

So, what does a great process look like? Much like great fundraising campaigns, details of the process will vary from organization to organization. I submit that a great process for some could be completely paper-driven and manual while others must be automated to be effective. All of them share key core process and technical components, though. The following diagram depicts each element that must be in place.

Grateful patient process

A few points about this process:

  • Patients can include outpatient and clinic visits, but you might want to start with the smaller data set of in-patients.
  • Nightly screening matters most when there is a subsequent daily review and triggers.
  • In-patient visits are permissible, but a philanthropic culture must be in place first.
  • If you don’t record and analyze the data and activity generated from the process, you are missing a big part of the process.
  • It will take time to yield big results, but some of our clients processes leverage annual giving channels to provide immediate financial benefit, and identify potential major donors.
  • There are dozens of other considerations not covered here but important to the process…so many issues, to be honest, that I joke this should be the subject of my next book.

Your team may not have the technical ability to build real-time data exchanges from the patient database to the screening company to your donor database. If API and SQL are foreign concepts, your process can still be rigorous and daily. However, automating visit ticklers, introduction letters, and other elements of the process, it is typically worth the effort. Ultimately, this business process should generate big-ticket leads while greatly expanding your solicitable constituency.

Remember that developing a business process here is the responsible thing to do. The law allows it and your organization’s competition may already be doing it. If you already have a process in place, could you make it even better? And, if you don’t have a process, now is the time to get going? Get the data, people, and processes in place and start delivering better and better prospects to support you fundraising efforts. Good luck and feel free to share any challenges or successes you’re experiencing.

January is National Business Intelligence Month…

…didn’t you know that? Of course you didn’t. With the holidays, closing some year-end gifts (not to mention the books), and learning an awful lot about Amazon’s post-holiday online return policy, how could you keep up with all of the information being thrown at you. It’s hard enough to have the right information, much less use it effectively. Plus, it’s not really National Business Intelligence Month. I made that part up.

So, why the subterfuge? We need to draw attention to the critical need in the advancement business for more and better reporting and analysis. Some of you already have what you need. Some stopped looking years ago. Some have that “special” report that some poor person spends hours to prepare. But, most of us want better reporting, the kind that actually helps us make decisions about the business and tells us things we otherwise wouldn’t have known.

Better reporting requires a few things. This flow chart shows the way to better reporting. But, even more important than creating reporting is turning it into business intelligence.

Report Development Cycle

Let’s work to get even better data into even more clear reports that drives even better decisions. Let’s stop with the ad hoc, don’t-really-learn-much urgent reporting and develop a thoughtful suite of reporting that allows you to direct the team. Let’s develop shared definitions and expectations, allowing our reports to mean the same thing no matter the audience. So, know that I think about it, let’s make January National Business Intelligence Month. Make sure to put it on your calendar for next year.