This Q&A session originally appeared as a blog post from TJ Hillinger, Vice President at Avalon Consulting. It was then re-printed in the DMAW Monthly Newsletter. The panel discussion included ROI’s own Gina VanderLoop, Steve Alexander, Principal of Alexander Strategies, Rose Simmonds, Director of Direct Marketing of the League of Women Voters, and John Perell, Director of Direct Response at the Smithsonian Institution.
How do you recognize that it’s time to undertake a database conversion?
Steve: If your current system keeps you from executing your most robust fundraising program, it’s time to move to a new system. For example, if your organization expands into new fundraising channels, but your database system prevents you from maximizing revenue and donor engagement, it’s time to convert.
Sometimes the problem lies with users who have not been appropriately trained. If you have a system that can do what you require, but fundraisers do not understand how to do it, invest in training, not conversion. Also, consider how your current vendor may be able to meet new user demands before you convert. It may be more efficient to make the most of your existing system instead of converting to a new one.
Gina: Necessity is the best and most compelling reason to convert a database—so if your current system is being sunsetted (more and more common these days!) or has reached its capacity to handle your data needs, then it’s time to convert. If your system cannot easily integrate with the communications channels and systems you rely on to effectively achieve your business goals and mission, you must move on.
John: A good reason to convert is if you need a system with greater functionality specifically designed for direct response fundraising, with online CRM and an email platform integrated into the database.
Rose: When your current database system prohibits your organization from meeting its cash flow and business processes, you know it’s time to move on. But don’t move to a new plan just for the shiny new stuff! You’ll regret it.
So you’ve decided to make a move—what comes next?
All four experts agreed that the significance of database conversion could not be overstated.
Rose: Identify all critical players/stakeholders who should be involved in the process—and get their commitment to seeing the project through to the end. Because of the time involved, staff can sometimes change midstream, so use a managing company and an on-staff project manager to oversee the conversion.
Gina: Make sure that your organization’s leadership understands the vision behind choosing a new database system and that they fully back the project and the time and effort that will need to be allocated to make the conversion successful. Your leadership must share that vision with the user community to ensure a smooth transition and enthusiastic user adoption. And make sure you prioritize the areas that drive most of your revenue now and will enable your future growth with a new database system.
Steve: Nail down your reasons for moving the database and create a prioritized list of must-haves to help choose a vendor. A mistake nonprofits often make in the database conversion process is underestimating the time and resources required. So build a project plan, including realistic estimates of human and financial resources needed and contingency budgets for unexpected complications because they will happen. Existing staff cannot oversee a conversion without support while maintaining day-to-day duties. Success is more likely if you make appropriate investments in the transformation. And that can only happen with everyone on board with the project.
John: Do a comprehensive needs assessment when you’re ready to start looking for a new vendor. This is where you need to be a pragmatist—go in with realistic expectations about functionality, cost, and conversion. Because identifying a database and platform that can most closely meet your long-term business needs will prevent the angst of buyer/user remorse,t
In your experience, what is a realistic time frame for a database conversion?
Our experts—all database conversions veterans—have differing conversion time frames experience. But they all agree on one thing: Having realistic expectations and a well-documented process to ensure your goals are met is essential.
Gina: A conversion can be done in six months, but only with a solid and well-documented implementation plan to ensure that vendor and client have a laser focus on the transformation, so they can meet all of the critical milestones that are part of a successful conversion. Strong project managers with excellent communication skills are also vital to on-time delivery. And as are well-set expectations. I feel strongly that the longer a transformation lasts, the more likelihood of unnecessary scope creep. An organization’s staff will lose focus, energy, and enthusiasm for the project (and potentially even quit).
Steve: A balance must be struck between finding the perfect solution and protracting the timeline of a conversion to the point that it becomes a pain point for your organization. Be thorough and careful with your decisions, but avoid procrastinating because decisions are difficult or because you cannot build 100% consensus.
John: Listen to the database vendor—they should be very detailed when scoping out the project and delivering a realistic timeline. Don’t try to cut the timeline short, or you will reap what you sow.
Rose: If you get the right combination of folks, my guesstimate would be that conversion takes at least two years—from the moment you decide to convert, to when the new system is installed and implemented. After implementation, I’d say it takes another year for change management.
Steve: Anticipate delays and plan for them. A steady focus and dedication to completing the project in a reasonable amount of time will result in a better outcome. For example, staff departures can create significant delays and increases in cost. But there’s a shelf life on patience for a conversion. The longer the process takes, the likelier stakeholders will lose confidence in the outcome and tire of waiting.
What else should we consider?
Steve: Few nonprofits have individuals on staff who have gone through a conversion before, much less led one. If you have a team who have navigated or overseen a transformation, these folks will be your biggest asset as you move forward. Call on those with prior experience; do not be afraid to invest in external expertise. Conversion is one of the most important decisions your organization will make.
Gina: Check references! I’ve heard so many industry horror stories about implementations lasting two to three years and going over budget by hundreds of thousands and even millions of dollars. These stories are so familiar—and failed conversion not only impacts your bottom line, it can be disastrous to your marketing programs, the morale and tenure of your employees, and even long-term mission goals. Do your homework now so you don’t get stuck trying to implement a database platform with a company with a lousy track record.
Steve: Form a conversion committee to include finance, development, executives, IT, and your existing vendors. (And never plan to go live during peak fundraising seasons.) and talk it through: If revenue hinges on a perfect conversion, you may assume too much risk.
What is typically the most significant unknown/surprise/unexpected finding regarding a database conversion?
Steve: Database companies often boast that they can integrate with any tool—but it’s best to confirm and validate this well before the conversion happens. The worst surprise is that your new system doesn’t integrate with your other tools. To avoid this, request references from other groups who have successfully integrated with your organization’s tools. Also, tools and functionality referenced during demonstrations of the new database may be difficult or impossible to implement for your program. Ensure your contract includes a complete itemization of every deliverable, and the database company’s team is always available for questions and clarifications.
Also, create a five-year cost estimate for all your vendor options to ensure the conversion cost does not exceed plans and expectations. Have each vendor validate your estimates—and integrate these estimates into your contract. This can help prevent cost overruns down the line.
Gina: Conversions are like a box of chocolates—each is unique, and every one comes with a surprise. We continue to learn from each conversion and continually strive to improve our implementation process.
Having intelligent people on the implementation team helps an organization understand what it has been doing well and how it might do things better and unpack and fully document its new business rules. This makes for a smooth and even fun conversion. Most importantly, during a conversion, the company must be flexible and have a CRM application that can accommodate various unique customization and integration needs.
John: Surprise: Post-conversion clean-up takes longer than you expect! Unknown: The new database impacts functionality in another part of your organization, which affects your expenses (a good example is if the database is more challenging to use than anticipated, thus increasing gift-processing costs). Unexpected finding:Customizations to the database were not fully scoped out because there was not enough money to build the needed functionality. Thoroughly research all items when planning your conversion.
Rose: For me, the biggest surprise is the beautiful time a database conversion takes and the enormous number of details involved.
Can you share an example of a big lesson learned through conversion and how to avoid missteps where possible?
John: Avoid customization, if you can, because it is a slippery slope—it is expensive and does not always work how you expect it to.
Gina: We have learned that it is critical to document the decisions that are being made around business processes as the conversion is happening. If someone from the organization were to leave, these documents are critical in helping a new hire get up to speed on the decisions made during the conversion process. It is essential to look back after a transformation—in the short term and over the long—to understand the business processes and any necessary customizations made to the CRM application to accommodate those processes.
As for avoiding missteps, the most important thing is constant and effective communication, with both the client and the company clearly defining and mutually agreeing upon the roles and responsibilities that each team member will have during the implementation.
Rose: The biggest lesson my team and I learned was that our timeline was unrealistic.
Steve: To me, the biggest lesson learned is that if ownership in the project—the good and challenging aspects—is not shared, conflict can arise as issues crop up, leaving your internal conversion team to complete the work in isolation. Most important to a successful conversion are true transparency and open communication. Engage all stakeholders at regular intervals to ensure expectations are in line with reality. When expectations fall out of step with current events, disappointments can follow, leading to a lack of confidence in the tool before the new system is even brought online.
What do you recommend post-conversion to ensure the transition goes smoothly?
Gina: The job is not done when the new database goes live. The two most essential aspects of post-conversion are user adoption and future growth planning.
User adoption across the organization is critical to the success of a new CRM, and it must be an organizational priority during and after the conversion process. Proper organizational training ensures that the client’s staff knows how to use our application—best accomplished through one-on-one and group training. In terms of future growth, work early on in the relationship with your database company to invest yourself in becoming a part of that company’s user community, understand its product roadmap, and be a voice that helps guide the development of its platform.
Steve: As Gina said, a conversion isn’t over once you’ve gone live, so make that clear throughout the process. If stakeholders assume the hard work is done when you go live, confidence in the system can sour. After the system is up and running, you will need to refine and revisit many of your procedures and business rules. The refinements can continue for another year or two after you go live. It’s valuable that users understand this going into the conversion. And, of course, nothing is more important than training. Training must be mandatory. Users must fully understand how to utilize your new tool.
John: Yes, manage expectations with all staff to make them aware that the post-conversion clean-up will take about a year to complete. This is especially true if you are merging multiple databases into one. I’ve found it best to offer staff numerous/flexible training opportunities. As they start working in the database, there will be many times when they will run into obstacles or questions, so it’s necessary to have a dedicated account person available from the database company to answer all questions that come up.
Rose: Again, ensure you have the right mix of people on the team—stakeholders, users, a database company, etc.
Any other thoughts?
Steve: There’s a balance that needs to be struck between finding the perfect solution and protracting the timeline of a conversion to the point that it becomes a pain point for your organization. Be thorough and careful with your decisions, but avoid procrastination because decisions are complex or you can’t build 100% consensus.
Gina: A database conversion is one of the most important decisions that an organization can undertake. From a marketing standpoint, some have said that a good database—one that helps you do your job better and more efficiently—is a nonprofit organization’s most valuable asset. The conversion process is an excellent opportunity to step back and evaluate your programs and operations, identify weaknesses, and improve upon them. Take advantage of that opportunity.
Any parting thoughts?
John: Relax and sit back. The database conversion process is always a bumpy ride of twists and turns.
Gina: The conversion process is one of the best opportunities to step back and evaluate your programs and processes—and where they are weak—to improve upon them. Take advantage of that opportunity. One of the best things one of my clients recently told me after going through a conversion was that it was one of her most enjoyable experiences. So breathe deep, relax, take your database conversion head-on, and make sure you have fun!