tag:blogger.com,1999:blog-358638162024-03-14T12:20:10.790+00:00Databases For CharitiesMy views on the database market for charities and NFPs: packages, CRM and bespoke developments. In particular, but not limited to, fundraising and membership.Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.comBlogger165125tag:blogger.com,1999:blog-35863816.post-62734509453718194482018-08-30T18:01:00.000+01:002018-08-30T18:01:02.039+01:00My Books on How to Buy Fundraising Software and CRM Systems: Now Free<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPkxoy_pvrZPuJUI-Jcg46DAIVZygZcnKQvxTZJQMBB_Ku-9z87k80z3KgT-IW6aidE_XRthSRghBrFQp2QU9J93vvsgUw_2ZHNnuo3aIOUZqEyZ_ZBV930Lbmgerr527m1PlN/s1600/FreeHowToBuy.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="415" data-original-width="612" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPkxoy_pvrZPuJUI-Jcg46DAIVZygZcnKQvxTZJQMBB_Ku-9z87k80z3KgT-IW6aidE_XRthSRghBrFQp2QU9J93vvsgUw_2ZHNnuo3aIOUZqEyZ_ZBV930Lbmgerr527m1PlN/s1600/FreeHowToBuy.png" /></a></div>
<br />
In recent years, I have published two books on How to Buy Fundraising Software and Charity CRM Systems. I am now making these free – although if you find them useful (and I hope you do!) then it would be great if you would like to make a donation to either of the two charities detailed on the <a href="https://itforcharities.co.uk/howtobuycrmsystems/" target="_blank">download page</a>.<br />
<br />
Both books contains a collection of tips for charities who want to buy a new fundraising database or CRM system. They are compiled from a number of articles I have published on my blog plus a series of additional tips and in-depth analysis and advice. They cover the basics of procurement (strategic advice, costs, software demos, project management) and delve into more detail on supplier management, considerations about database development, the whole tender process and information on CRM platforms.<br />
<br />
<div class="one_half last">
They are written for people whose day job
is not the procurement of new databases – and you do not have to be
technical to understand it. They are for fundraising managers,
fundraisers, database managers, charity IT staff, those working in
supporter services and indeed for anyone who has been given the
sometimes daunting task of buying a new fundraising database or CRM
system.<br />
<br />
I hope they inspire, assist and enhance your buying process, whether
you are already comfortable with a procurement exercise or even if you
have never managed one before. Think of it as your own consultant seated
by your side as you go along – only at a fraction of the cost! I hope
you find them useful.</div>
<div class="one_half last">
<br />
To download them just visit my website: <a href="https://itforcharities.co.uk/howtobuycrmsystems/" target="_blank">How to Buy Fundraising Software and Charity CRM Systems: Two Free eBooks</a>. <br />
</div>
<div class="one_half last">
<br /></div>
Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-23541026992654759252017-05-14T19:26:00.000+01:002017-05-15T09:31:36.251+01:00GDPR Doesn't Mean You Need a New Database<div style="text-align: left;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqK4OoS8z7-JRspxXam36WXH0_Zbsg7BtzcNvUbS6wwmythvdd3fHp0903WDgSe_K-SlXg06q_y78oqklc_Rk_PRMYKlYYps_q3lVtVTRX-CUvCWaqxyp3EbmVqS0RMZvoPTt8/s1600/hand-in-ok-sign.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="263" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqK4OoS8z7-JRspxXam36WXH0_Zbsg7BtzcNvUbS6wwmythvdd3fHp0903WDgSe_K-SlXg06q_y78oqklc_Rk_PRMYKlYYps_q3lVtVTRX-CUvCWaqxyp3EbmVqS0RMZvoPTt8/s400/hand-in-ok-sign.jpg" width="400" /></a></div>
<br />
Last week, <a href="https://www.civilsociety.co.uk/news/nearly-40-per-cent-of-charities-looking-to-review-crm-systems-ahead-of-gdpr-survey-finds.html" target="_blank">Civil Society reported</a> that "almost 40% of charities are considering reviewing their current CRM system with the launch of the FPS [and] GDPR." My message to such charities is: hang on, wait a minute, do you really need a new CRM system or fundraising database? Buying and implementing a new system is complicated, expensive and takes up plenty of your resources. So before you do that, there are a number of things you should do first:</div>
<ul>
<li>Talk to your current database supplier. This has to be your first course of action. What do they recommend? What are their plans? If you have a "fundraising system/package" such as Raiser's Edge, thankQ, DonorFy etc then such suppliers will still want to be selling their software to other charities now and post-GDPR, so they will need to ensure their systems are
compliant or they won't sell anymore.</li>
<li>If you have a CRM platform (Salesforce, Microsoft Dynamics 365 etc) then you almost certainly will be able to manage FPS and GDPR on them but
of course it could be simple or more complex depending on your current design, if you have access to any IP (Intellectual Property) issues etc. So, again, talk to whichever supplier/business partner implemented your system. And if you don't have any such relationship and your in-house staff don't know how to change your platform then call on a Salesforce/Dynamics specialist developer - there are lots out there.</li>
<li>Talk to other users of the same system that you are using. If the above doesn't get you any joy then talk to other charities who are using the same system as you are. If you've got issues then other organisations will almost certainly be/have been in the same boat as you. Maybe they have already found a solution and can give you some tips; or if not, then maybe you can all get together and put some pressure on the developer to get something done.</li>
<li>Talk to other charities who <i>are</i> ready for FPS/GDPR and ask how
they've done it. Even if they have created a solution in a different system/platform to the one you use, it is quite possible you can learn the concepts of what they have done and see if you can replicate that in your database. You could even look at third-party specialist solutions such as Wood for Trees' <a href="http://www.woodfortrees.net/consentric-permissions-2/" target="_blank">Consentric Permissions</a> or Syrensis' <a href="http://syrenis.com/thepreferencecentre.html" target="_blank">The Preference Centre</a>.</li>
<li>And do talk to a qualified professional about what you <i>really </i>need for FPS and GDPR (i.e. a lawyer, compliance expert, a consultant specialising in this area etc). I have read and seen too much conflicting advice over the previous months and 'data protection' is unfortunately one of those things where many people think they know what is needed but many people don't really... And it is one area which you can't afford to get wrong.</li>
</ul>
<br />
<div class="MsoNormal">
Finally, if it turns out that you must change your current CRM system/fundraising database then don't rush it. Do it
properly, get a formal procurement process in place, implement any new system with a correct timetable and budget; and if necessary keep your FPS/GDPR data in a separate system in a <i>consistent format</i> which you can import into your new system at a later date.</div>
<div class="MsoNormal" style="margin-bottom: 12.0pt;">
<br /></div>
Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com1tag:blogger.com,1999:blog-35863816.post-56283054422787432042017-04-24T12:28:00.000+01:002017-04-25T13:52:24.919+01:00Learning From How a Toyota Supplier Saved $1 million by Updating Its Tech Infrastructure<div style="text-align: center;">
<a data-flickr-embed="true" href="https://www.flickr.com/photos/ste3ve/521083344/" title="Production floor"><img alt="Production floor" height="375" src="https://c1.staticflickr.com/1/209/521083344_00979be561.jpg" width="500" /></a><script async="" charset="utf-8" src="//embedr.flickr.com/assets/client-code.js"></script>
<span style="font-size: small;"><span style="font-family: "georgia" , "times new roman" , serif;"><span style="color: #20124d;"><span style="font-family: "georgia" , "times new roman" , serif;"> </span></span></span></span></div>
<span style="font-size: small;"><span style="font-family: "georgia" , "times new roman" , serif;"><span style="color: #20124d;"><span style="font-family: "georgia" , "times new roman" , serif;">My second</span> <span style="font-family: "georgia" , "times new roman" , serif;">post in an on-g<span style="font-family: "georgia" , "times new roman" , serif;">oing series <span style="font-family: "georgia" , "times new roman" , serif;">of </span></span></span>blogs </span></span></span><span style="font-size: small;"><span style="font-family: "georgia" , "times new roman" , serif;"><span style="color: #20124d;">on lessons we can learn from commercial sector technology implementations.</span></span></span><br />
<hr />
<br />
A recent <a href="http://www.techrepublic.com/article/how-a-toyota-supplier-saved-1-million-by-updating-its-tech-infrastructure/" target="_blank">article on TechRepublic</a> shows how Toyota supplier, AW North Carolina (AWNC) spent $1.2m on new Cisco equipment, which has led to significant savings for them. Few charities will invest that amount in a new CRM system, but some of the approach which AWNC took provides us with very useful ideas for the benefits which charities may get from new CRM implementations, often regardless of size.<br />
<br />
<br />
<span style="color: #20124d;"><i>1) "Downtime at AWNC costs $272,000 an hour, so it's crucial to get systems
up and running as quickly as possible. Any downtime, particularly in
shipping, is incredibly detrimental."</i></span><br />
<br />
Okay, so it's unlikely that a CRM system being down for an hour at a charity would have quite such high costs! However, downtime due to a poor or unsupported system or inadequate IT infrastructure is not always factored in to a charity's view on whether they need a new CRM/fundraising system.<br />
<br />
So consider: what would it mean to your staff if they couldn't access their database for an hour? Probably, it wouldn't be terrible for most fundraisers/staff, they could cope for that time, although Supporter Services would no doubt find it awkward for managing in-coming phone calls. But what about half a day? Now staff will be getting more anxious, a backlog of income processing might build up, supporter services are finding it more difficult and major donor fundraisers can't see their contacts' details. What about a full day? Much harder now: thank you letters might be delayed, management for a forthcoming event becomes much harder, and what would happen if that day happened to be the day when you were due to do your Direct Debit claim?<br />
<br />
So it's not just the cost of a new CRM system - all this needs to be considered when looking at investment.<br />
<br />
<span style="color: #20124d;"><i>2) "As a result of the new technology, AWNC avoided maintenance costs on the old equipment of $1 million in the first nine months the system was in place"</i></span><br />
<br />
Again, unlikely for most charities that they will save $1m in nine months due to replacing a CRM/fundraising system, but I have come across several NFPs who are paying existing suppliers ridiculously high annual maintenance costs for what they are getting, even without upgrades and developments. And/or they have to have specialist, higher paid staff for their current, old system because there are so few people who can support it. So even if it is going to cost you £x to invest in a new CRM system, what are your savings going to be in the first 12 months? (In the next 5 years?) Forget "possible extra income" benefits for a moment, these figures are hard cost savings.<br />
<br />
<span style="color: #20124d;"><i>3) "About 40% of the savings will be ongoing and realized annually."</i></span><br />
<br />
We
forget this sometimes, that savings (and benefits of course) will not
just be the first year, but over the following five to seven years. So
in addition to point (2) above on immediate savings, what other costs
will be lowered or made more efficient by a new system? Lower staff costs?
Or maybe, the same staff costs but those staff being far more
efficient, productive and proactive? Time-savings from quicker
processes? Time-savings (and better productivity) from simpler, quicker
development tools? Development you can do in-house now rather than
having to always go to an expensive software supplier?<br />
<br />
<span style="color: #20124d;"><i>4) "It was very clear... that the infrastructure was not keeping current with where the world had gone." </i></span><br />
<br />
We're
all aware that digital is where fundraising is going. Yes, there will
still be plenty of 'traditional' or offline income coming in for some
years to come, but that appears to be declining, and GDPR/DP issues could be
forcing our hand in terms of reducing direct marketing. There is a point
when you do need to review how and whether your existing
CRM/fundraising system can support you and provide additional benefits
with your future fundraising plans because of changes in the outside
world.<br />
<br />
<i><span style="color: #20124d;">5) "It's common in a manufacturing plant to avoid buying new equipment in a misguided attempt to save money, with IT teams not realizing that the operational costs to troubleshoot problems and the associated downtime in a factory environment can result in even higher costs."</span></i><br />
<br />
I love this! How many of you have suffered from this problem with your antiquated or unsupported fundraising databases?! (And it's kind of reassuring that commercial organisations have this problem too!)<br />
<br />
<span style="color: #20124d;"><i>6) "The big push for last year was solidifying the environment, and this year is all about pushing out into the applications and into the manufacturing space to impact yield inventory." </i></span><br />
<br />
This is just a small point to show that any new CRM implementation does not have to be rolled out to everyone or to manage all potential benefits immediately. Plan for future expansions in the subsequent years after your immediate go-live - you don't need to, and shouldn't try to do everything on day one.<br />
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-59406116309499371342017-03-13T14:11:00.001+00:002017-03-13T14:11:17.349+00:00What we can learn from large, failed IT Projects<div style="text-align: center;">
<a data-flickr-embed="true" href="https://www.flickr.com/photos/brizzlebornandbred/9875338705/" title="HOLMES system (Home Office Large Major Enquiry System)"><img alt="HOLMES system (Home Office Large Major Enquiry System)" height="369" src="https://c1.staticflickr.com/4/3805/9875338705_ca63c4ebf4.jpg" width="500" /></a><script async="" charset="utf-8" src="//embedr.flickr.com/assets/client-code.js"></script> </div>
<span style="font-size: small;"><span style="font-family: "georgia" , "times new roman" , serif;"><span style="color: #20124d;">This is the first blog I am planning </span></span></span><span style="font-size: small;"><span style="font-family: "georgia" , "times new roman" , serif;"><span style="color: #20124d;"><span style="font-size: small;"><span style="font-family: "georgia" , "times new roman" , serif;"><span style="color: #20124d;">in an <span style="font-family: "georgia" , "times new roman" , serif;">occasional series </span></span></span></span>on lessons we can learn – good and bad - from commercial/public sector system implementations<span style="font-family: "georgia" , "times new roman" , serif;">;</span> looking outside the charity sector for best practice and alternative approaches we might take. </span></span></span><br />
<hr />
<br />
On <i>Computing's</i> website last week, there was an interesting article which says how “<a href="http://www.computing.co.uk/ctg/news/3006274/accenture-underestimated-complexity-and-lost-trust-in-failed-national-it-system-for-police-scotland" target="_blank">Accenture 'underestimated the complexity' of failed [£50m] national IT system for Police Scotland</a>”. Whilst this is clearly on a different scale to all NFP CRM projects, there are some good lessons to consider regardless of what size project you are managing.<sup>1</sup> The following are some of the key lessons I think we can take:<br />
<br />
<ul style="text-align: left;">
</ul>
<span style="color: #20124d;"><i>“Early disagreements between Police Scotland and Accenture led to a breakdown in relationships and a loss of trust that never fully recovered”.</i></span><br />
<br />
This is a classic problem and shows <a href="http://blog.itforcharities.co.uk/2014/10/the-importance-of-clientsupplier.html" target="_blank">how important client-supplier relationships are</a> and supplier management for the client. One of the few things we can say with (99%!) certainty is that something will go wrong sometime during any CRM implementation, and therefore if you have set off on the right foot and started developing good relationships with your supplier, then when the beep hits the fan, you should be in a better place to manage such instances far more appropriately.<br />
<br />
<ul>
</ul>
<span style="color: #20124d;"><i>“Within weeks [of the contract award], and despite 18 months of pre-award discussions, Accenture and Police Scotland disagreed about whether the proposed system would deliver the requirements set out in the contract.”</i></span><br />
<br />
First, if you are really arguing about scope and requirements “within weeks” of a contract award, then you have probably not managed the procurement appropriately for your requirements, and/or you are kicking off the project in the wrong way. And/or you have not created an appropriate Business Case pre-project which should have declared what the benefits were which you were expecting, and thus what you were looking for from a system.<br />
<br />
In addition to initiating the implementation correctly, it shows how difficult and yet how important your procurement process and any associated tender (ITT) document can be. You should be able to define the fundamental requirements and scope enough so that you are not arguing so early, but <a href="http://blog.itforcharities.co.uk/2013/12/is-there-any-place-for-long-itt-anymore.html" target="_blank">I am not convinced that a long, complicated ITT document</a> would necessarily mean you would avoid such issues. <br />
<br />
For most CRM projects for charities, the procurement process should be about finding the right supplier, the right business partner for you, and their software/solution is part of that. But I do not think that, for most charities with their resources and needs, that a tender document can be certain to (or even should) cover the whole scope, encompass all functional and non-functional requirements, and do it to such a level that no disagreements will come later.<br />
<br />
There are increasingly good reasons, therefore, especially for larger CRM projects and especially when building on CRM <i>platforms</i>, for doing an initial ‘discovery’ phase after the initial contract award which will spend more, detailed time detailing what is required from the rest of the project: what, when, how and who is responsible. To a certain level at least. And at least so that the client and supplier know more than they did pre-sale and so the supplier can refine and provide more accurate cost/time estimates on the agreed scope/requirements. Even if you are planning an Agile implementation thereafter, this ‘waterfall’ part of the implementation is well worth while.<br />
<br />
<ul>
</ul>
<span style="color: #20124d;"><i>“The programme was complicated and highly ambitious [and] the idea was to merge more than 130 legacy systems.”</i></span><br />
<br />
Any IT/CRM programme where you know it is going to be ‘complicated and highly ambitious’ needs to be thought through more carefully before implementation. Can you really manage such a project in ‘one go’? Should you instead break it down into blocks/smaller sub-projects (regardless of project management methodology), thus considering how some aspects of it could be de-risked and the different blocks made less complex?<br />
<br />
If you are going to merge several/many legacy systems, then this is a wonderful opportunity to break down the implementation into multiple blocks, prototype, do early go-lives for limited users/functionality, learn lessons as you go along. Even if those lessons show the project will be more complex than first thought, then get this lesson sooner rather than later.<br />
<br />
You can still be considering ‘the overall’ project at the same time (e.g. considering how you can do merging/de-duping from each legacy system into one, looking at overall visions/benefits) whilst you are doing one or two of the early migrations.<br />
<br />
<br />
<span style="color: #20124d;"><i>"The two parties had initially believed that the majority of the system could be based on an existing IT system that Accenture had delivered elsewhere. But… as the design and development process developed, it became apparent that Accenture would need to develop significantly more than what had originally been anticipated."</i></span><br />
<br />
If a supplier says the majority of their system can be based on an existing system they have, well, if that is the case, couldn’t you be shown that system up-front? And if so, then both sides could tell far sooner (i.e. pre-sale) if it really is viable to be re-used? Similarly, if it is that good, then couldn’t a simpler ‘fit gap analysis’ help in the first place? If that shows it is a larger gap than expected then, again, find out early.<br />
<br />
If you are buying a CRM system based on a platform and you are being told there is 'an existing system' you can use, then ask for more evidence, do more work on investigations, plan how you are going to run the project accordingly and ideally, consider if the contract can reflect that.<br />
<br />
And if your supplier does not have experience in your sector, with your requirements, then although that certainly does not necessarily mean that they could not do it, it does show that you need to be more careful about the procurement process. <br />
<span style="color: #20124d;"><br /></span>
<br />
<ul>
</ul>
<span style="color: #20124d;"><i>“After Police Scotland tested the system, Accenture estimated that meeting the requirements of the contract would take an additional two-and-a-half years, with the live date pushed back to April 2018, almost four years later than originally planned. [And] Police officers found 12 critical errors that made the system unusable, with 76 defects in total that required more work.”</i></span><br />
<br />
This shows that ideally you do not wait until UAT to test such fundamental issues. Ask how the design is being done earlier. Are there critical factors you can test earlier, even in a waterfall project? An ‘agile’ or iterative approach (even a hybrid waterfall/agile methodology) can also help mitigate some of the risks of doing UAT close to a go-live which might mean that only then will you find issues that could push back go-live so significantly.<br />
<span style="color: #20124d;"><br /></span>
<br />
<ul>
</ul>
<span style="color: #20124d;"><i>“Accenture underestimated the complexity [of the project].”</i></span><br />
<br />
This sums it all up and it is sadly something I have seen on a number of charity CRM implementations by (large and small) suppliers and business partners. Maybe they don’t know your business/sector well enough, maybe they have under-quoted even if they do know it, maybe you as a client didn’t explain the complexity well enough. I hope that all the above points should help mitigate some of this possibility.<br />
<br />
<hr />
<span style="font-size: x-small;">1. I want to emphasise that this blog post is in no way
suggesting that only Accenture have issues such as this! Clearly you
could have the same issues with any supplier. And, of course, I don’t
have any knowledge of this specific project except for what the article
provided – but I do think there are generic points we can learn.</span>Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-28351318758407822002017-02-16T14:46:00.002+00:002017-02-16T17:16:34.848+00:00What Small Charities Need to Know About CRM Systems – 2nd Version<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhabMy_75ohupAq_4HDleaB1Wvm_Ljlv_ayEmYQrxxmwCJ71jgdJzteQH2aeeWreN0zg675oPqIjmScpCaqmCVjpO20q3jtFlYV9h5p_xyvGR_3rdFIT3Ocdp_1VnIUIQzVQAwc/s1600/Small+Charities+CRM+cover+2+small.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhabMy_75ohupAq_4HDleaB1Wvm_Ljlv_ayEmYQrxxmwCJ71jgdJzteQH2aeeWreN0zg675oPqIjmScpCaqmCVjpO20q3jtFlYV9h5p_xyvGR_3rdFIT3Ocdp_1VnIUIQzVQAwc/s1600/Small+Charities+CRM+cover+2+small.png" style="border: #000000 1px solid;" /></a></div>
I have updated my free ebook, <i>What Small Charities Need to Know About CRM Systems</i>. Buying a new CRM system or fundraising database can be a
daunting experience for any NFP organisation, let alone a small charity.
So although I publish a lot of information on my blog which I hope is
useful for all charities, this book contains some points which I think
smaller not-for-profit organisations need to particularly be aware of or specifically
consider. <br />
<br />
As before, this book has been produced for people whose day job is not
the procurement or implementation of new databases – which for small
charities is probably almost everyone! And you do not have to be
technical to understand it. It is for fundraising managers, chief
executives, trustees and fundraisers, but of course I hope it is equally
useful for database staff and charity IT staff too.<br />
<br />
This second version has a brand new section on System Development and
updates throughout the rest of the book to reflect my latest thoughts and the software options now available to the sector. <br />
<br />
<a href="http://www.itforcharities.co.uk/What%20Small%20Charities%20Need%20to%20Know%20About%20CRM%20Systems%20v2.pdf" target="_blank">Click here to download the PDF for free</a>.<br />
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com1tag:blogger.com,1999:blog-35863816.post-36356644109750684792016-12-20T08:30:00.000+00:002016-12-20T08:30:28.697+00:0012 Key Lessons From My Last CRM Project<span style="font-size: large;">On the twelfth day of Christmas, my truelove gave to me... Twelve Key Lessons I Learned From Managing My Last CRM Project </span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibNtP8Z0hduDzBfhqOM0I4mZ8MmKpTXkEaq1NjbIi6NtVDnKGIc2byY9JYyxpSxR240rS3XAKKUTdHQjghz7hVBfEf8eeJuH3DTuSf6ewAIH_buEPsLR-UGXw6SYevEzO5ntk-/s1600/music-515894_640.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="424" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibNtP8Z0hduDzBfhqOM0I4mZ8MmKpTXkEaq1NjbIi6NtVDnKGIc2byY9JYyxpSxR240rS3XAKKUTdHQjghz7hVBfEf8eeJuH3DTuSf6ewAIH_buEPsLR-UGXw6SYevEzO5ntk-/s640/music-515894_640.jpg" width="640" /></a></div>
<br />
I thought I would finish this set of blog posts with a quick-fire set of some of the most important lessons I learned from the last CRM project I managed. Each point really deserves its own dedicated blog post, but I hope they provide a succinct set of tips in themselves:<br />
<br />
<ul>
<li>Configuration not Customisation where possible: I have <a href="http://blog.itforcharities.co.uk/2010/12/implementing-vanilla-crm-systems.html" target="_blank">blogged</a> about this before and it remains true. The more you can Configure and use the software's built-in tools and GUI to configure and define your system, the better. Each bit of Customised code will add cost, time, risk, pain and something you should try to avoid unless you can see real benefits, at least during implementation.</li>
<li>Don't try to re-create your existing database: It is so easy to go down the path of replicating exactly what you do now but just in a new CRM system, when what you should be trying to do is use the functionality and approach and benefits of the new CRM system. If you have bought system X then use it as it was meant to be used. Long-term that will set you up so much better.</li>
<li>Yes, ask users what they want, but then start with a simple base configuration and go from there: i.e. <a href="http://blog.itforcharities.co.uk/2014/06/when-users-dont-know-what-they-want.html" target="_blank">don't try to do every little single thing</a> which users ask for, don't try to change every form on every screen for n different teams, don't bend and change the software in complicated ways when you are still learning and building it. Instead, get the basic requirements, use the software in as simple way as possible to get a starting point and then show the users that - if there are then things which you really have to change then you can consider them at that point or even post-live.</li>
<li>Don’t under-estimate the challenge of data integration: Integration is hard, no matter how you do it. Think of all those external data sources you need to import, that other system you want to share data with/update from your new system. It takes time, effort and money. Some suppliers may have starting points for some things such as JustGiving etc and that's good, but you may still need to change things.</li>
<li>Treat reporting as its own workstream: Reports are always one of the things in a project where you start off with great intentions and then as the project goes on, you can find they slip down the order of priority. I would recommend managing them in a dedicated workstream, with a dedicated member of staff leading on them. Remember: reports are one of the key reasons you have a fundraising/CRM system in the first place!</li>
<li>Work hard at supplier relationships: At some point in your implementation, it is highly likely that something will go wrong and you will need to discuss something painful with your supplier. The better your relationship with your supplier at that point, the more likely you will be able to come to a mutually satisfactory conclusion. It needs work but it's worth it.</li>
<li>Consider a <a href="http://blog.itforcharities.co.uk/2013/10/the-need-for-solution-owner-role-when.html" target="_blank">Product Owner/Solution Owner</a>: In a large CRM project with a significant timeline and budget, consider including a role of Solution Owner (aka Product Owner). This is a role for someone who understands not only the charity's requirements and strategies but also fundraising/charity requirements more generally, as well as CRM software and technology. The reason for this is because the implementation of sophisticated, flexible (and often expensive) CRM software systems is of course not just about the software but about building/configuring and using it with the people and processes in mind - and understanding the whole approach, design, dependencies and implications of design. The role provides a central point of contact for design understanding and fundamental decision making.</li>
<li>You will always need more people on your team: As the project progresses, you will no doubt find that you could do with more people working on your project, although it could be that you don't know all the exact roles when you start the project. So think about this up-front, budget for it and bring on some roles as you go through the project. Ideally, have a budget for future roles but have an agreement with your project board that you can define the actual roles later. And backfill if you can - always good to up-skill both the people you bring on to the project and the staff who step-up to do the BAU whilst those other people are on the CRM team.</li>
<li>Think about the post-live structure of your database support team ahead of time: It could well be that the roles you have in your current database support/CRM team will be different to those which you will need with your new CRM/fundraising system, especially if you are moving from a traditional/proprietary software to a CRM Platform, Think about this as far ahead as possible and make plans.</li>
<li>You can mix-and-match your approaches to cost within the project: There is always the question of whether you should go for a Time and Materials (T and M) or a Fixed Cost budget. In fact, you could mix and match even in the same project. For example, some of the development work might be T and M but the data migration could be a fixed cost. Etc.</li>
<li>Post-Live: Use a Roadmap, not Phases. I will point you to <a href="http://blog.itforcharities.co.uk/2012/04/why-it-is-bad-idea-to-have-phase-2-of.html" target="_blank">my older blog post</a> on this as the principle still stands. I believe that having a roadmap approach to post-live development is far better and more efficient than the concept of Phase 2, Phase 3 etc.</li>
<li>The importance of fun in internal comms: When you are engaging all your users, staff and stakeholders with your regular communications (which you have planned, yes?), then think of the one word which many people would describe such comms. Go on, close your eyes now and do it... Okay, got that word? Was it... "Boring"?! Sorry, that is often how it is! So make your internal comms more fun: whether it is with more innovative emails, interactive demos, screens in the staff room, lunchtime meetings with food, competitions with chocolate... It doesn't matter so much what it is, but try to think what would make you read something you didn't want to read and do that.</li>
</ul>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s1600/12Days.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s400/12Days.png" width="400" /></a></div>
Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-62294438693722752062016-12-19T08:30:00.000+00:002016-12-19T08:30:04.932+00:00Supplier Catchphrase Bingo!<span style="font-size: large;">On the eleventh day of Christmas, my truelove gave to me... Eleven Things Which Suppliers Say at Demos Which You Can Use to Play Supplier Catchphrase Bingo! </span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglGDWFBTuH1tchi_SeHue4A9vdAywiW2MXwYrUjIMjbHmKiJ_EA8x1rnCl-A-ccLmDURE6DdJQ3Mag6RC0i8i3X2PkZpkqi5YJevQU90iOltUeiqmCvW4xjDbxPRfthyqAE_WC/s1600/pipers.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="424" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglGDWFBTuH1tchi_SeHue4A9vdAywiW2MXwYrUjIMjbHmKiJ_EA8x1rnCl-A-ccLmDURE6DdJQ3Mag6RC0i8i3X2PkZpkqi5YJevQU90iOltUeiqmCvW4xjDbxPRfthyqAE_WC/s640/pipers.jpg" width="640" /></a></div>
<br />
So this is mainly for fun but with a serious(ish) message. The next time you have a software demonstration from a supplier or set of suppliers, listen to their spiels and see how many of the following phrases they say which you can tick-off in each presentation...<br />
<br />
<table border="1">
<tbody>
<tr>
<td style="text-align: center;">We offer the best support in the sector</td>
<td style="text-align: center;">Our system provides a 360 degree view</td>
<td style="text-align: center;">We want to be a <i>partner </i>with you</td>
</tr>
<tr>
<td style="text-align: center;">This is a Game Changer</td>
<td style="text-align: center;">You <i>must </i>be in the Cloud</td>
<td style="text-align: center;">Our system is completely Future-Proofed</td>
</tr>
<tr>
<td style="text-align: center;">We’re specialists in sorting out other suppliers' problems</td>
<td style="text-align: center;">You don’t need any documentation</td>
<td style="text-align: center;">(We do) Agile...</td>
</tr>
<tr align="center"><td colspan="3">You should never buy… (e.g.) a CRM Platform/proprietary fundraising software…</td></tr>
<tr align="center"><td colspan="3">X isn’t difficult (e.g. data migration, integration, reconciliation with your finance system, security)</td></tr>
</tbody></table>
<br />
Of course, some suppliers may say some of the above things and genuinely mean them. Some companies of course implement CRM systems using an Agile project methodology and may well do it well (I'm just sceptical of what <i>exactly </i>they mean by that or if it is just a buzzword they are using); some will truly believe that Cloud is best (for them at least); and some may well have sorted out another supplier's "problems" at another charity - but by the time you've met a few, each one of them will be claiming they have sorted out another's problems...<br />
<br />
My point here is not to ridicule suppliers, but to emphasise that they are, understandably, <i>selling </i>to you. You need to ask questions, dig down into specifics, request examples, ask them to show you specific elements of their software, talk to their implementation and support staff, have second meetings and so on and so on.<br />
<br />
And always take with a pinch of salt any company that says their software is completely future-proofed.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s1600/12Days.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s400/12Days.png" width="400" /></a></div>
<br />
<br />
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-2996632360520774282016-12-16T08:30:00.000+00:002017-10-25T11:05:31.058+01:00Ten CRM Case Studies for Charities<span style="font-size: large;">On the tenth day of Christmas, my truelove gave to me... Ten Useful Case Studies of How NFPs Are Using CRM Systems</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRkansSOLh2EcKYzr3nhdcjfIOB5lQqWfN1noMfLMbCnzsk_jmLBUp04pRS7yt1X6Na0o5qPOBte1J1yj-Wm6CkR1xMRVYtI0gLbhzhyspJxBqaIRM6eyjb0psQLb7tCzkPwLT/s1600/jump-with-joy.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="426" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRkansSOLh2EcKYzr3nhdcjfIOB5lQqWfN1noMfLMbCnzsk_jmLBUp04pRS7yt1X6Na0o5qPOBte1J1yj-Wm6CkR1xMRVYtI0gLbhzhyspJxBqaIRM6eyjb0psQLb7tCzkPwLT/s640/jump-with-joy.jpg" width="640" /></a></div>
<br />
Case studies are a useful way to see how charities and the NFP sector have implemented fundraising and CRM systems. The following are ten such examples (in alphabetical order):<br />
<a href="http://www.theaccessgroup.com/solutions/not-for-profit/crm-for-nfp/resources/case-studies/essex-herts-air-ambulance-trust/" target="_blank"></a><br />
<ul>
<li>Access Group: Access thankQ CRM - <a href="http://www.theaccessgroup.com/solutions/not-for-profit/crm-for-nfp/resources/case-studies/essex-herts-air-ambulance-trust/" target="_blank">Essex Herts Air Ambulance</a> </li>
<li>Advanced Computer Software: Care NG - <a href="https://www.oneadvanced.com/globalassets/resources/advanced_case_study_woodlands_trust_web.pdf" target="_blank">Woodland Trust</a> </li>
<li>Advantage NFP - <a href="http://www.advantagenfp.com/resources/Birmingham%20Royal%20Ballet%20-%20case%20study.pdf" target="_blank">Birmingham Royal Ballet</a> </li>
<li>ASI Europe: iMIS20 - <a href="http://www.advsol.com/ASI/IMIS20/resources/clients/IMIS20/Resources/clients/Rethink_Mental_Illness.aspx" target="_blank">Rethink Mental Illness</a></li>
<li>Blackbaud: Raiser's Edge - <a href="https://www.blackbaud.co.uk/notforprofit-resources/case-studies/university-of-glasgow" target="_blank">University of Glasgow</a> </li>
<li>CiviCRM - <a href="https://sf2012.civicrm.org/sites/default/files/slides/CiviCRM%20Implementation.pdf" target="_blank">Bloodwise</a> (ex-LLR)</li>
<li>Donorfy - <a href="https://donorfy.com/blogallposts/success-story-central-london-samaritans" target="_blank">Central London Samaritans</a></li>
<li>Harlequin Software - <a href="http://www.harlequinsoftware.co.uk/greatwood/" target="_blank">Greatwood</a></li>
<li>Microsoft Dynamics CRM - <a href="https://www.youtube.com/watch?v=JSLFvYJosuk" target="_blank">Midlands Air Ambulance</a></li>
<li>Salesforce - <a href="http://www.salesforce.com/uk/customers/stories/camfed.jsp" target="_blank">Camfed</a></li>
</ul>
NB For clarification: this list in no way indicates that these are the ten best or the only ten systems you should consider. There are many more and you can see a more comprehensive list of <a href="http://itforcharities.co.uk/database-software/fundraising-software/" target="_blank">Fundraising Software</a> and <a href="http://itforcharities.co.uk/database-software/crm-software/" target="_blank">CRM Systems</a> on my website.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s1600/12Days.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s400/12Days.png" width="400" /></a></div>
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com2tag:blogger.com,1999:blog-35863816.post-24038433711348247862016-12-15T08:30:00.000+00:002016-12-15T08:30:17.730+00:00Nine Costs to Remember when procuring CRM Systems<span style="font-size: large;">On the ninth day of Christmas, my truelove gave to me... Nine Costs to Remember when procuring CRM Systems </span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHGB60txn2t1hkR4sy9yYGWdUHn1A1TuaFmKrOt6oQUPEyJsf2xYMIgVvV1VnavLM-adX2M3IAdwkDGjwcPikfVCR8Waq8W-KUPmUyMQ3G_ip8eQ-LgQ4YcYVyeEiHNWJrpOAM/s1600/ballet-545323_640.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="404" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHGB60txn2t1hkR4sy9yYGWdUHn1A1TuaFmKrOt6oQUPEyJsf2xYMIgVvV1VnavLM-adX2M3IAdwkDGjwcPikfVCR8Waq8W-KUPmUyMQ3G_ip8eQ-LgQ4YcYVyeEiHNWJrpOAM/s640/ballet-545323_640.jpg" width="640" /></a></div>
<br />
There are many costs which you need to take into account when procuring and then implementing a new CRM System or Fundraising Database. The following are the core costs:<br />
<ul>
<li>Software Licenses: Regardless of the type of license - perpetual vs monthly/annual (subscription) licenses, and concurrent vs named vs unlimited user numbers - you need to make sure you are comparing like-for-like across all your potential options, including any 'core module', additional modules/apps etc. (And that's before you consider and compare actual functionality and benefits.)</li>
<li>Hosting/Storage: This can be different depending on whether you are looking at cloud or on-premise or third-party hosting. It is comparatively simple to cost at an "explicit" level but can be very difficult when looking more deeply. At a simple level, Cloud systems will probably include x Gb of storage with your standard price and then you pay extra for every additional Gb you need. Bear in mind that can add up, especially for larger databases. You will therefore need to work with potential CRM suppliers to calculate how much storage you will need - and then add more to allow for future growth. That can be difficult. With on-premise solutions, the explicit cost is of course the hardware and associated software - but the harder costs are the fact that your internal IT staff will need to maintain that hardware, do upgrades etc, which is why Cloud salespeople say Cloud is so much cheaper. And for on-premise, you should probably also allow for the cost of new servers every n years, depending on your organisation's policy.</li>
<li>Internal Project Team: Except for small database implementations, you will almost certainly need specific costs for an internal project team, back-filling etc. (See Christmas Tip #6 for a few more thoughts on this). Such costs could vary depending on the type of software or supplier you select.</li>
<li>Supplier Professional Services. This has the potential to be a wide range of costs - and one of the highest budgets. For example: consultancy, system design, development and customisation, creating blueprints, report writing, installation, support with UAT, post-live support, project management etc etc. Read another blog post of mine about <a href="http://blog.itforcharities.co.uk/2012/04/how-do-you-compare-like-for-like-on-crm.html" target="_blank">how you can compare suppliers' professional services costs</a> and what to look out for.</li>
<li>Data migration: I have separated these from the rest of the Supplier Professional Services because, for any database larger than a simple spreadsheet, they can be harder to cost up-front, until a supplier has had the chance to look at your existing database in detail. For larger projects, this won't come cheap - do not under-estimate.</li>
<li>Training costs: whether it is internal, using a third-party/contract trainer or using the supplier's staff.</li>
<li>Integration: If your project involves integration of any sort (and it almost certainly will if it is for fundraising), from receiving online donations on your own website or data from JustGiving, through to importing data from fulfilment houses and exporting to finance systems - and more - then these costs can start to add up. I have written several <a href="http://blog.itforcharities.co.uk/search/label/Integration" target="_blank">posts specifically about integration</a> over the years. Bear in mind 'integration' can mean different things to different people and to different suppliers so be careful when comparing costs and approaches. Talk to all suppliers in detail to clarify any uncertainties.</li>
<li>Annual (on-going) Costs: Software Support/Maintenance - Most traditional fundraising package suppliers charge x% per year for software support/maintenance but that often includes future upgrades too. With CRM systems, the business partners you implement the software with will also likely charge annual support costs which will vary depending on whether they are selling a 'template' solution, developing from 'vanilla' etc. And Software licenses - if you are paying on a monthly/annual basis then you will of course continue to pay such costs every year. To compare, annualise them and compare over n years.</li>
<li>Other Costs: Okay, I know this category could include anything but that's the point! I do also want to emphasise that there are any number of other, additional potential costs in a fundraising or CRM implementation, from hardware and workstations, to PAF and banking validation software, other people costs, paying fulfilment houses and other suppliers to change file formats and so on and so on. Find what you need and build them in to your final budget.</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s1600/12Days.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s400/12Days.png" width="400" /></a></div>
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-40263468592789782822016-12-14T08:30:00.000+00:002016-12-14T08:30:07.641+00:00Eight Gartner Building Blocks<span style="font-size: large;">On the eighth day of Christmas, my truelove gave to me... Information on how Charities Could Use Gartner's 8 Building Blocks of CRM Framework </span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPnymu6Vl8M45hwfsaV5IYfbTazuX8zMFm_GKHlOvKkwuzQs10lfDS4d9f6BqZ3YUfnrOOmImft1DAAJSIuBuuZPjUVzH3yAuDktIX5Yo0t8E1fGpO3PJrBHcyNpm1wxx0zhkI/s1600/8Maids.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="136" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPnymu6Vl8M45hwfsaV5IYfbTazuX8zMFm_GKHlOvKkwuzQs10lfDS4d9f6BqZ3YUfnrOOmImft1DAAJSIuBuuZPjUVzH3yAuDktIX5Yo0t8E1fGpO3PJrBHcyNpm1wxx0zhkI/s400/8Maids.png" width="400" /></a></div>
<br />
For larger (and probably also mid-size) charities looking to implement a new CRM system, and who want to understand the implications of CRM other than technology on their organisation, then you could certainly take a look at Gartner's "Eight Building Blocks of CRM" framework.<br />
<br />
This is a toolkit which forms a framework that contains the elements which Gartner define as necessary for a successful CRM initiative: vision, strategy, customer experience, organisational collaboration, processes, information/insight, technology and metrics.They emphasise that all eight building blocks are essential for successful CRM but key is the fact that only one of the eight blocks involves technology, which underlines the importance of viewing CRM as a business strategy.<br />
<br />
I also like Gartner’s Definition of CRM: "CRM is a business strategy with outcomes that optimize profitability, revenue and customer satisfaction by organizing around customer segments, fostering customer-satisfying behaviours and implementing customer-centric processes. CRM technologies should enable greater customer insight, increased customer access, more-effective interactions, and integration throughout all customer channels and back-office enterprise functions." Replace 'customer' with 'supporter' and remove profitability and that's a good definition for charities too.<br />
<br />
I won't go into each building block here - far better for you to read their approach yourself if you are interested. But I will quote one more thing from their report which I also agree with: "True CRM isn’t easy. It requires board-level vision and leadership to drive a “relentless focus on the customer”; otherwise, it will remain fragmented. It involves potentially difficult changes to processes, culture and organization that can make the technology support seem easy." Well said.<br />
<br />
- - -<br />
<br />
<span style="font-size: x-small;">The original Gartner paper is available on <a href="http://www.gartner.com/2_events/crmawards/2006/docs/buildingblocks.pdf" target="_blank">Gartner's website</a>, but you can also find the report as a download on various websites as part of other reports. One example is the <a href="http://www.customerthink.com/files2/Gartner-CRM-Handbook.pdf" target="_blank">CustomerThink website</a>.</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s1600/12Days.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s400/12Days.png" width="400" /></a></div>
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-71659208931832902632016-12-13T08:30:00.000+00:002016-12-13T08:30:08.562+00:00Seven Free Apps for CRM Systems<span style="font-size: large;">On the seventh day of Christmas, my truelove gave to me... 7 free apps/software which can be used with Charity CRM Systems</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWAnBcImB1suzlfmjm7YKJzwNZSXPLisTB0RzTpA3j00uLeUsio7ry-lXwFm1ym0Ve-KeByBfafePkNk4GnmhBEGIaIO-QtxZqHY_Fe3PJbnWdX-tQkOuy2ciB0tcjbnr8t1QI/s1600/swans-1636160_640.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWAnBcImB1suzlfmjm7YKJzwNZSXPLisTB0RzTpA3j00uLeUsio7ry-lXwFm1ym0Ve-KeByBfafePkNk4GnmhBEGIaIO-QtxZqHY_Fe3PJbnWdX-tQkOuy2ciB0tcjbnr8t1QI/s640/swans-1636160_640.jpg" width="640" /></a></div>
<br />
I am always cautious about saying that software is free, because so often there are some sort of costs associated with it, even if the price tag itself is zero. With that caveat in mind, here are some free apps/software which I hope could be useful for CRM and fundraising software implementations:<br />
<br />
<ul>
<li><a href="https://powerbi.microsoft.com/en-us/documentation/powerbi-publisher-for-excel/" target="_blank">Power BI Publisher for Excel</a>: Microsoft's Power BI is a great tool to enhance the visualisation of data. Using it, you can take snapshots of your most important data/insights in Excel, such as PivotTables, charts and ranges and pin them to dashboards in Power BI.</li>
<li>Free <i>Raiser's Edge</i> Plug-ins from <a href="https://www.zeidman.info/" target="_blank">Zeidman Development</a> and <a href="https://www.smartthing.org/" target="_blank">SmartTHING</a>: David Zeidman and Warren Sherliker are both fantastic developers of plug-ins and customisations for The Raiser's Edge. And although they charge for their developments, they also offer some apps and 'lite versions' for free. If you use Raiser's Edge then their websites are both well worth checking out.</li>
<li>Free Salesforce apps: The <a href="https://appexchange.salesforce.com/free" target="_blank">Salesforce AppExchange</a> has lots of free apps, some definitely better and more useful than others, but it's a great resource for Salesforce users. There are email integration tools, dashboard apps, data management apps and more.</li>
<li><a href="http://www.xrmtoolbox.com/" target="_blank">XrmToolbox</a> for Dynamics CRM: If you already use Dynamics then you may know about this add-on already, but if you don't use it or if you are thinking of using Dynamics then this is a wonderful free tool to know about. As it says on the their website, "it is shipped with more than 30 plugins to make administration, customization or configuration tasks easier and less time consuming". Good stuff.</li>
<li><a href="http://itforcharities.co.uk/gift-aid-calculators/" target="_blank">Gift Aid calculator</a> for your website: This is a free piece of Javascript which I designed myself some years ago to show donors how much their donation would be worth with Gift Aid. Anyone is welcome to use, amend and incorporate it as they wish; it is probably used mostly by small-mid size charities who want a quick and easy (if not so beautiful!) solution.</li>
<li>Free CRM Software: <a href="https://civicrm.org/" target="_blank">CiviCRM </a>and <a href="https://www.kindlink.com/" target="_blank">KindLink</a>. CiviCRM is an open source CRM solution for NFPs and KindLink is a recent addition to the charity market for cloud CRM software. However, I urge you to remember that just because the software is free, it does not mean it is zero cost - read my <a href="http://blog.itforcharities.co.uk/2010/06/why-free-software-doesnt-mean-zero-cost.html" target="_blank">specific blog post</a> about this - it's old but still relevant.</li>
<li><a href="https://www.talend.com/products/talend-open-studio" target="_blank">Talend</a> Data Integration software: Talend has an Open Source version (Open Studio) as well as a paid-for commercial version, but the open source version is still extremely powerful. It will help you integrate data between different sources and your CRM system. But be aware it is not simple software - you almost certainly will need a dedicated expert to use it.</li>
</ul>
If you want to recommend any other free software/apps etc then please do add them in the Comments below.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s1600/12Days.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s400/12Days.png" width="400" /></a></div>
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-1131567435447141172016-12-12T08:30:00.000+00:002016-12-12T08:30:07.217+00:00Six roles you need in your CRM project team<span style="font-size: large;">On the sixth day of Christmas, my truelove gave to me... A list of 6 roles needed in larger CRM Implementations</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsFlDML1trPn18xaG9k4xqAoTWqfpL7M5TyEk_-XPXRq1W6Q8bcW1yyPg393vhjIJRbNSnx26eRkBEtEhytF7hB2OmigCl3TVBhqLBWZ215WM9aDXzJbiVK79DG8IhZHATSjOI/s1600/geese-1407208_640.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="425" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsFlDML1trPn18xaG9k4xqAoTWqfpL7M5TyEk_-XPXRq1W6Q8bcW1yyPg393vhjIJRbNSnx26eRkBEtEhytF7hB2OmigCl3TVBhqLBWZ215WM9aDXzJbiVK79DG8IhZHATSjOI/s640/geese-1407208_640.jpg" width="640" /></a></div>
<br />
For larger CRM implementations in particular, the following are six roles which would be very useful. Some of them might not needed immediately when a project kicks-off, but they will be required thereafter.<br />
<br />
<ul>
<li>Project Manager: A good project manager is central to the success of a CRM implementation. They run the project day-to-day and deliver the project, hopefully within the budget and timescales and of the quality required and, importantly, act as the central communication hub to all stakeholders and interested parties.</li>
<li>Solution Architect: This is a role which is becoming more and more important when you are implementing a Salesforce/Dynamics type project where the system design is so crucial. For such projects you should have your own in-house solution architect. They will translate user/business requirements into the (data) architecture for the CRM system at a technical level, and quite likely work alongside your supplier's solution architect.</li>
<li>Business Analyst(s): They will work with your users and Subject Matter Experts (SMEs), extract their business requirements, document them and quite possibly create business/data flows of the processes. They are essential so that you can identify all your needs and processes and will be extremely helpful when it comes to implementing the new CRM.</li>
<li>Data Migration manager: Although this might depend on who is doing the data migration (from the old to the new system) and how it will be done, at the very least you will need a person in your own organisation who really understands the in-depth detail of the existing database so that they can work with the new supplier. At the other extreme, it might be that they need to be even more hands-on in terms of mapping and migrating the data into the new CRM system.</li>
<li>Test Manager: Regardless of your project methodology, you will need to test the build of your new CRM system, the data migration, work with your users and so on. A Test Manager to manage and co-ordinate all this will be invaluable.</li>
<li>Trainer: Someone to train your staff on the new system. The best trainers I have worked with also understand 'the business' and don't just train in a 'press that button' style, but relate the new software to the users' needs and processes. They might even have some BA skills.</li>
</ul>
There are of course other roles such as in-house developers, product manager/solution owner, change manager, report writer, project support staff and so on.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s1600/12Days.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s400/12Days.png" width="400" /></a></div>
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com1tag:blogger.com,1999:blog-35863816.post-13295710010142463732016-12-09T08:30:00.000+00:002016-12-09T08:30:12.096+00:00Five Golden Things Which Underlie CRM Systems<span style="font-size: large;">On the fifth day of Christmas, my truelove gave to me... 5 Golden Rules (which are not about the software)</span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOxyYRHKKmCAi-_RNPf6y7dSnjzQpKJEOGRZkwPJyeugUbXBLEv7pT1McnYZBYz29gjnUxHLAJ8SxsDt0nSS2X3dSP3_uurycM4TMECqv_K6cYUek2iHQ1oPOBdE78SXgKY7-j/s1600/5goldrings.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOxyYRHKKmCAi-_RNPf6y7dSnjzQpKJEOGRZkwPJyeugUbXBLEv7pT1McnYZBYz29gjnUxHLAJ8SxsDt0nSS2X3dSP3_uurycM4TMECqv_K6cYUek2iHQ1oPOBdE78SXgKY7-j/s400/5goldrings.png" width="400" /></a></div>
<br />
Whenever an organisation is reviewing or implementing a database, it is important to understand that it is not just the CRM <i>software</i>/the database which needs to be considered. There are at least five other key factors which influence any CRM system.<br />
<br />
<ul>
<li>Strategy - i.e. your fundraising strategy, management structure, communication strategy etc. This may sound obvious but if your fundamental strategy for fundraising, your communication policies, your IT strategy, even your management structure is not well structured then how can you expect your database to support your requirements. This underlies all aspects of CRM and indeed most technology projects. (And trust me, I have consulted at one or two organisations where some of the above were definitely not in place).</li>
<li>Data: The best CRM system in the world will not be efficient for your use if your data is not up to scratch. You need to consider what data you are recording, how you capture it, data quality issues, data consistency, data integrity across fields and tables and so on. (There are plenty of other posts on this blog about <a href="http://blog.itforcharities.co.uk/search/label/Data" target="_blank">data </a>if you want to read more). Of course, any CRM software needs to be able to store the data you want and manage it well, but these days that should be the case with most contemporary solutions.</li>
<li>Processes: When reviewing/implementing a new fundraising or CRM system, you should review your business processes. In my experience, there are three reasons that any process linked to your CRM software exists:</li>
<ul>
</ul>
<ol>
<li>No-one knows why they are as they are, it is just done that way because it is..; or: </li>
<li>
Because your current computer software makes you do it this way; or:</li>
<li>Because you have thought about it carefully and your current process is the most efficient way to do things. </li>
</ol>
<ul>
<li>Sadly, as much as I wish it was, the third option above is rarely what I find when I talk to charities. So: before you blame any poor database for the situation you might be in with it, have a look at your business processes and decide if they really are setup as best they could be, or whether there is room for improvement. I would bet there is.</li>
</ul>
</ul>
<ul>
<li>People: Are your staff trained on how to use the software? Who by? How is a new starter shown what to do? Do you have enough and the correct database support staff? And if you are going to buy a brand new CRM system, then be aware that your current database staff structure might not necessarily be what you need going forward.</li>
</ul>
All the above are, in my opinion, more important than the software/CRM system itself. i.e. You can have the best software but if you have rubbish data, if your staff aren't trained and supported, if your business processes have not been thought through, then you will find it difficult to get the most out of your CRM system.<br />
<br />
<ul>
<li>I also used to say the same about the final, fifth factor: your IT infrastructure. I would describe how if your server was too old and under-powered, if your internet connection was too slow, then again, your CRM software would suffer. And of course that is still true. But with hardware being so much more affordable and powerful now, with Cloud systems and access to the cloud so much more robust, I hope that this is now rarely such an issue. Of course, it is still important and it can still mean that good software will not work so well, but it is one of those things - given the correct budget - that should be more manageable.</li>
</ul>
If all this sound obvious to you then that's great, I'm delighted. But if you are finding that your current CRM system is not doing what you want, or you are looking at buying a new system then do bear all this in mind.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s1600/12Days.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="73" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s320/12Days.png" width="320" /></a></div>
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-7386079765414241572016-12-08T08:30:00.000+00:002016-12-08T08:30:04.552+00:00Four SAAS Fundraising Software Systems for Smaller Charities<span style="font-size: large;">On the fourth day of Christmas, my truelove gave to me... A list of fundraising software created for the Cloud for small-mid size NFPs.</span><br />
<span style="font-size: large;"> </span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRGARukp9cgTV1icLPyVfIPFvr5JPp925sKCVi7wKT4mKGJcKKPpRoebrf4Bn_jMcJKhwKJoGdkWkxiDozKpGy7M9NV7-wQL2yk35SFSDk8yspgmvmQO_QP-j34W5XORgJhAUz/s1600/songbirds-1244100_640.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="295" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRGARukp9cgTV1icLPyVfIPFvr5JPp925sKCVi7wKT4mKGJcKKPpRoebrf4Bn_jMcJKhwKJoGdkWkxiDozKpGy7M9NV7-wQL2yk35SFSDk8yspgmvmQO_QP-j34W5XORgJhAUz/s400/songbirds-1244100_640.jpg" width="400" /></a></div>
<br />
There are now a number of fundraising systems which have been designed as Software as a Service (SAAS) applications; i.e. they run on browsers, in the Cloud without the need for you to download anything on to your PC. These systems are specifically, proprietary software solutions which have been designed for fundraising and which you can use immediately with their built-in functionality (i.e. as opposed to CRM platforms like Salesforce/Dynamics which can be extended to provide fundraising functionality).<br />
<br />
Here are four such systems (in alphabetical order):<br />
<br />
<a href="http://www.theaccessgroup.com/solutions/not-for-profit/crm-for-nfp/" target="_blank">Access thankQ CRM</a>: The original version of thankQ was created quite some years ago and although you can still install it on your own servers, the latest version can now also be run as a SAAS option. It is functionally rich and a favourite for many users. Of the four systems here, it is probably more oriented to medium-sized charities but plenty of smaller charities have used thankQ over the years.<br />
<br />
<a href="http://donorfy.com/" target="_blank">Donorfy</a>: Donorfy is the newest of these systems and has been designed by Robin Fisk and Ben Brett who originally designed ProgressCRM some years ago. It is a good, clean system with new functionality being added all the time. And even though it was originally designed for smaller charities, it is increasingly being seen as an option for mid-size charities too. And the great news for very small charities is that you can use it with up to 500 constituents for free.<br />
<br />
<a href="http://www.donorperfect.co.uk/" target="_blank">DonorPerfect</a>: DonorPerfect started in the US but has steadily added customers in the UK as well, if not at the same rate as some other systems. It has all the standard fundraising management functionality you would expect and also has a mobile app for iOS and Android. Like the other systems here, although it can be used by smaller NFPs, it can also scale for mid-size charities too.<br />
<br />
<a href="https://www.blackbaud.co.uk/fundraising-crm/etapestry-donor-management.aspx" target="_blank">eTapestry, from Blackbaud</a>: eTapestry has been around for many years now and always as a SAAS application, so its design has grown well. And the last few years have seen a significant increase in its user-base in the UK. There are three versions of it, with more functionality for the higher-end options. It also has new functionality being added over the months.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQpxll2xsj8liaqCTk7bBasacvTrmLFV7TThf6nF-EOjOkcmjP2eK89C20qtRvDDJ09MmU94HpDotdpd__s9DFbHD5l84KBV3u9Ju07TT2msJUV79qQEZBoRt4j3gHCAOfL7Q_/s1600/12Days.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQpxll2xsj8liaqCTk7bBasacvTrmLFV7TThf6nF-EOjOkcmjP2eK89C20qtRvDDJ09MmU94HpDotdpd__s9DFbHD5l84KBV3u9Ju07TT2msJUV79qQEZBoRt4j3gHCAOfL7Q_/s400/12Days.png" width="400" /></a></div>
<br />
<br />
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-84212843557525248312016-12-07T08:30:00.000+00:002016-12-07T08:38:45.281+00:00Three Cartoons With a Useful Message<span style="font-size: large;">On the third day of Christmas, my truelove gave to me... A few things to make me smile and yet <i>still </i>learn about CRM! </span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiM1u2gxjcjqddA_PwLeHj1W4W1aY96BvRnXP6Gq0hU_IwYk5Uc0bxmICx8i3NJG-fy9MbUlAr8-OpbyZRmaYBHZeFYKJU6rS0kgWmSSJLPRo12cg-uQxawulzsQ04Kjb_98Tgt/s1600/hens-1252399_640.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="322" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiM1u2gxjcjqddA_PwLeHj1W4W1aY96BvRnXP6Gq0hU_IwYk5Uc0bxmICx8i3NJG-fy9MbUlAr8-OpbyZRmaYBHZeFYKJU6rS0kgWmSSJLPRo12cg-uQxawulzsQ04Kjb_98Tgt/s400/hens-1252399_640.jpg" width="400" /></a></div>
<br />
It's Christmas and so I feel one of my twelve tips (well maybe two, but the other post comes later...) should have some jollity. So here are three cartoons which I think are funny but they can also be used to explain a useful (serious?!) message:<br />
<br />
1. Dilbert - my favourite cartoon series and I could use a dozen of them to emphasise different aspects of CRM procurement and implementation. But here's the one I have chosen:<br />
<br />
<script src="//urlembed.com/static/js/script.js"></script>
<a class="urlembed" href="http://dilbert.com/strip/2015-04-24"></a>
<br />
<span style="font-size: x-small;">(Just in case the cartoon does not embed properly, then try refreshing the page or <a href="http://dilbert.com/strip/2015-04-24" target="_blank">click here</a> to see the original).</span><br />
<br />
I guess the message is pretty clear! As I often comment on this blog, it doesn't matter how good your software is: if your staff aren't trained, or if processes aren't clear or they are not followed, or if your supplier isn't paying attention to your requirements (and you haven't noticed) then you can have the best CRM System in the world and people can still be the fly in the ointment. <br />
<br />
2. The Cloud. Ah, that wondrous and magical thing, the answer to everything. But...<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEtTUp8Knfn_xOVrLSYWN2sCsfPOomDC6wTOZztuvmyuVSbKloYa389x6TQiSpc3fncrrg0DzIMlCcv96ClNKw6AaGEd4Nvsj11ohlyPRoGcvs7phu3sPBT4aDjnqbB1eA5aA3/s1600/cloud-cartoon.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="296" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEtTUp8Knfn_xOVrLSYWN2sCsfPOomDC6wTOZztuvmyuVSbKloYa389x6TQiSpc3fncrrg0DzIMlCcv96ClNKw6AaGEd4Nvsj11ohlyPRoGcvs7phu3sPBT4aDjnqbB1eA5aA3/s320/cloud-cartoon.jpg" width="320" /></a></div>
<br />
It doesn't mean it is always the right thing to use for everyone every time. Yes, there are tremendous benefits from the Cloud but don't think it always has to be that way. What if you have large volumes of data? What if you already have a well structured and well supported on-premise IT infrastructure? What if the software you like isn't actually cloud-based?! Just make sure that the Cloud is considered as one of your options, not the only option.<br />
<br />
3. Project Management. This cartoon was originally created in the 1960s and rather sadly it is still as pertinent today as it was then!<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIMadw_kGVYVwc2TZHMnWXBQwylo_N9nHTwslX8WO1s4TpI_9EsIqY6DRfpfpT6S9P1Aog_2sa0bhO524yJNz-Si7YkuaMgFnACya8ufzUIr9vYXttxtrXLa9YSKKPstiIsk2A/s1600/Business+Processes+Cartoon+big+text.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIMadw_kGVYVwc2TZHMnWXBQwylo_N9nHTwslX8WO1s4TpI_9EsIqY6DRfpfpT6S9P1Aog_2sa0bhO524yJNz-Si7YkuaMgFnACya8ufzUIr9vYXttxtrXLa9YSKKPstiIsk2A/s400/Business+Processes+Cartoon+big+text.jpg" width="400" /></a></div>
I'll leave it to you to interpret it for your future projects, but the bottom line is that you need business understanding, consistency, documentation (as you can see!) and project management structure, whatever your project management methodology is.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s1600/12Days.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgTZyFiO-KeP1cAQcDqK-LH_QL7qUr5hDW5tprzSBP7E_VUpOAMSqOtJq0dgpOciQcaRQF4Y4bbI14KC_HaTNBE6vJ2xN8An4soJpJlGI8punDemwIu4aQx2EwhXvQcT5FuU71/s400/12Days.png" width="400" /></a></div>
<br />
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com2tag:blogger.com,1999:blog-35863816.post-52414819973233116302016-12-06T08:30:00.000+00:002016-12-06T08:30:00.166+00:00Two CRM Giants - Now Good Options for Larger Charities Too<span style="font-size: large;">On the second day of Christmas, my truelove gave to me... A brief discussion on Microsoft Dynamics 365 and Salesforce.</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqlP2nsnZyhgAeHzTGBik5EITm3-FBUICLbZf7CWXih4lkrAmfAjQFVBg1kbMBp-D5wlDyv-Q2K3q5SyFUeTFhU2G-2koOlVIqa0KrzDoCZiagbxY_qH9q3lxh9L57fjFGGx0F/s1600/pigeons-413073_960_720.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="364" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqlP2nsnZyhgAeHzTGBik5EITm3-FBUICLbZf7CWXih4lkrAmfAjQFVBg1kbMBp-D5wlDyv-Q2K3q5SyFUeTFhU2G-2koOlVIqa0KrzDoCZiagbxY_qH9q3lxh9L57fjFGGx0F/s640/pigeons-413073_960_720.jpg" width="640" /></a></div>
<br />
When I started this blog in 2009, I wrote that I was still reserving judgement on whether Microsoft Dynamics CRM and Salesforce were truly valid options as fundraising systems for charities, especially larger NFP organisations. Since then, I have watched the changes in both systems and there is now little doubt that - implemented well - both platforms now can support charities with their fundraising requirements.<br />
<br />There are good reasons for this: not only has their functionality and configurability improved, and there are now 'NFP templates' which can sit on both platforms, but equally as important (maybe more so), there are increasingly a number of implementation business partners who work with these
platforms who now have got a good understanding of the software <i>and
</i>fundraising – and that was definitely lacking just a few years ago. Of course, both systems also have excellent software licensing costs for charities (not the be-all-and-end-all of any procurement, but it still helps) and they are almost always recognised by key research companies such as Gartner and Forrester as being amongst the top CRM players.<br />
<br />
And although there have been a constant number of small to mid-size charities implementing both systems for fundraising over the last five years, the last couple of years has also seen the first large NFPs go-live with their fundraising implementations on these platforms: first, Barnardo's on Salesforce and then WaterAid on Dynamics. And there are at least a couple of other large charities who I believe should go-live on those platforms in 2017.<br />
<br />
They are also terrifically flexible and configurable, so you can of course use them for more than just fundraising if you want to. Indeed, most implementations of both systems were not for fundraising in their earlier versions.<br />
<br />
Of course, there are still challenges, most notably the concern of cost for large volumes of data if you go on a Cloud version, and performance for large data-sets for some operations should always be considered (Although, <a href="http://blog.itforcharities.co.uk/2014/11/the-new-world-of-cloud-storage-do-you.html" target="_blank">as I have written before</a>, I would question if you do still need <i>all </i>your data online).<br />
<br />
And there is still <a href="http://blog.itforcharities.co.uk/2014/03/salesforce-why-does-one-person-love-it.html" target="_blank">a lot of hype about Salesforce</a> and other CRM Systems (and there are of course <a href="http://blog.itforcharities.co.uk/2014/08/the-crm-alternatives-to-salesforce-and.html" target="_blank">alternative CRM platforms to Dynamics/Salesforce</a>) and so don't just go and buy a CRM blindly. Remember that they are not the only option for fundraising: there are also several very good proprietary software solutions which have been designed specifically for the charity sector. So you do need to decide which is right for your requirements.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8LVtcY1zuZH-XMLaC_2o4eWNr4bYckU7jPCf91aA5ZeEb9Ny3B6IEVWNNJyRULWy_tlxchvrpd5dO_UlB4J6GD3FsW35nhhIWUYLW0lrMkiASHvHWB6H8GzePQexp8CqKjUl3/s1600/12Days.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8LVtcY1zuZH-XMLaC_2o4eWNr4bYckU7jPCf91aA5ZeEb9Ny3B6IEVWNNJyRULWy_tlxchvrpd5dO_UlB4J6GD3FsW35nhhIWUYLW0lrMkiASHvHWB6H8GzePQexp8CqKjUl3/s400/12Days.png" width="400" /></a></div>
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-83450022637470503582016-12-05T08:30:00.000+00:002016-12-05T08:30:22.054+00:00Implement A Single Source of Truth<span style="font-size: large;">On the first day of Christmas, my truelove gave to me... Details on Why a Single Source of Truth is so Important</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEVNZsdUsI8ZU2vk7r1xFJ6CZZvVgAnt00vXSTDfSCXZ6EFgO6nzsU30mW5gm56KjCfQcsLGO4hQSc9XatQKLY_39MSX3ISzFjB7sAtbETpn1wnAjBgkpnAsBtAhh7EG73VwgM/s1600/partridge-in-a-pear-tree.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="356" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEVNZsdUsI8ZU2vk7r1xFJ6CZZvVgAnt00vXSTDfSCXZ6EFgO6nzsU30mW5gm56KjCfQcsLGO4hQSc9XatQKLY_39MSX3ISzFjB7sAtbETpn1wnAjBgkpnAsBtAhh7EG73VwgM/s640/partridge-in-a-pear-tree.jpg" width="640" /></a></div>
<br />
It has always been important for charities to have a ‘single source of truth’ for their core data, but if anything, it will become even more critical in the years ahead. <br />
<br />
What I mean by this is that if you want to know a supporter’s latest address, their most up-to-date communication preferences, who is stewarding them in your charity etc; or if you want to know the average income from your last n appeals, your total registration information for your events; and so on… then you need to know that you can get the correct information by going to one source system. <br />
<br />
If you still have more than one database which stores the same information, multiple spreadsheets which have been created by different users, or if your data integration processes from your website or other data sources are not working, then it is highly likely that you will get a different answer depending who you ask or where you look.<br />
<br />
You need a single source of truth.<br />
<br />
However, do note that this does not mean you necessarily need to have only one database or even the infamous <a href="http://blog.itforcharities.co.uk/2014/07/just-what-heck-is-360-degree-view.html" target="_blank">360 Degree View</a>. You could well have multiple databases but as long as you have a ‘central system’ where your core data is collated then you should be able to get the figures you need. And, of course, you need to ensure that there are not teams in your organisation who have their own spreadsheets “<a href="http://blog.itforcharities.co.uk/2010/04/next-time-someone-says-but-theyre-my.html" target="_blank">because they're my records</a>…”.<br />
<br />
Depending on your database setup, the goal of a single source of truth may not be too difficult - it may be more about consolidating data flows and processes - or it could be much harder f you do have many data repositories and a lack of organisational control/understanding for where data is stored and why. One good option for medium/large organisations is to have a data warehouse where you can collate all your important data and where specialist staff can create reports for your KPIs which everyone will trust and know is right.<br />
<br />
Make this need your first organisational New Year resolution.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8LVtcY1zuZH-XMLaC_2o4eWNr4bYckU7jPCf91aA5ZeEb9Ny3B6IEVWNNJyRULWy_tlxchvrpd5dO_UlB4J6GD3FsW35nhhIWUYLW0lrMkiASHvHWB6H8GzePQexp8CqKjUl3/s1600/12Days.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8LVtcY1zuZH-XMLaC_2o4eWNr4bYckU7jPCf91aA5ZeEb9Ny3B6IEVWNNJyRULWy_tlxchvrpd5dO_UlB4J6GD3FsW35nhhIWUYLW0lrMkiASHvHWB6H8GzePQexp8CqKjUl3/s400/12Days.png" width="400" /></a></div>
Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-76048605786489735232016-12-02T14:39:00.000+00:002016-12-02T14:39:07.951+00:00The 12 Tips of ChRistMas (for charities)<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeL6dY8VeHk0eyoT5OGM3Gxhdnhexx-dUcs-RLjl4hDaVB-ZPxO8q-qm8rr18Y_E_NuMZXT7tZpEbEA-a6uXO6ODl_Nk7sfQPd7gTA4RJfXiAGC5_VmhvkDGnAAi1n-sa12ixC/s1600/12Days.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeL6dY8VeHk0eyoT5OGM3Gxhdnhexx-dUcs-RLjl4hDaVB-ZPxO8q-qm8rr18Y_E_NuMZXT7tZpEbEA-a6uXO6ODl_Nk7sfQPd7gTA4RJfXiAGC5_VmhvkDGnAAi1n-sa12ixC/s1600/12Days.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
Okay, sorry, I know that's a terrible use of an acronym (not even a real use), but, well, somehow the time of year has got to me and I wanted to add my own little bit of festive cheer and provide a few short, sharp blog posts which I hope will take you through the season and into the New Year.<br />
<br />
So, starting next week, I will be providing my 12 Tips of <b>C</b><span style="color: #666666;">h</span><b>R</b><span style="color: #666666;">ist</span><b>M</b><span style="color: #666666;">as</span> (for charities). These will cover procurement tips, implementation thoughts, data, people's roles and even a whole post on how you can have a little bit of fun (ho ho ho) the next time you get a presentation from a CRM or fundraising database supplier. Software demos will never be the same...<br />
<br />
I hope they will be useful. Please do let me know what you think as I start publishing them.<br />
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-21877815753338274892015-02-10T08:00:00.000+00:002015-02-10T08:00:18.239+00:00What Small Charities Need to Know about CRM Systems: Free ebook<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNM5T-LlVV952car1vdzJxfkGQmcnOvRn91SNotsc6URvan0JafpiN3YkS0YAT56wxNOKIkK49tOxPDr_81Lu9DVsPqcsUvEyQuQFQTdIVtULbpIk9YVB834l6dJjbUQ8mWeR_/s1600/Small+Charities+CRM+cover+1+small.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNM5T-LlVV952car1vdzJxfkGQmcnOvRn91SNotsc6URvan0JafpiN3YkS0YAT56wxNOKIkK49tOxPDr_81Lu9DVsPqcsUvEyQuQFQTdIVtULbpIk9YVB834l6dJjbUQ8mWeR_/s1600/Small+Charities+CRM+cover+1+small.png" /></a></div>
I have just published a new, free ebook: What Small Charities Need to Know about CRM Systems. Buying a new CRM system or fundraising database can be a daunting experience for any NFP organisation, let alone a small charity. And although I publish a lot of information on this blog which I hope is useful for all charities, there are some points which I think smaller organisations need to particularly be aware of or specifically consider. So I have brought these issues together into a new, free ebook.<br />
<br />
Which in some ways was quite difficult! Because when I read back over my blog posts, so many more of them are equally appropriate for small charities too! I have therefore limited myself to just twelve areas which I believe should give a small charity a solid understanding of what they need to know about CRM systems and fundraising databases. But if you want to know more, then there's lots more on all my other blog posts.<br />
<br />
<b>Who this Book is Intended For</b><br />
The book has been produced for people whose day job is not the procurement or implementation of new databases - which for small charities is probably almost everyone! And you do not have to be technical to understand it. It is for fundraising managers, chief executives, trustees, fundraisers, office managers, volunteers and those working in supporter services, but of course I hope it is equally useful for database staff and charity IT staff too.<br />
<br />
If there are any points you think I should have included in this book then feel free to add them in the comments below.<br />
<br />
<b>How to Download the Book</b><br />
You can download the book from my website: <a href="http://www.itforcharities.co.uk/free-ebooks/" target="_blank">http://www.itforcharities.co.uk/free-ebooks/</a>.<br />
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com2tag:blogger.com,1999:blog-35863816.post-14829034102151105452015-02-03T08:00:00.000+00:002015-02-03T08:00:17.428+00:00Are charities really ready yet to take full advantage of CRM platforms?<div style="text-align: center;">
<a href="https://www.flickr.com/photos/imagesbywestfall/11377709945" title="ready (or not) by greg westfall, on Flickr"><img alt="ready (or not)" height="333" src="https://farm3.staticflickr.com/2816/11377709945_48785d1f52.jpg" width="500" /></a> </div>
<br />
So often during procurements and marketing pitches, the undoubted benefits of CRM systems are laid out by suppliers for charities. This is understandable and correct - why shouldn't charities know what they could be achieving and the benefits of such platforms. <br />
<br />
However, I sometimes wonder if most charities, or even some are really ready to take full advantage of such technology. I don’t mean from a fundamental or standard operational angle, clearly those systems have every chance of giving charities what they want for the start of any such project. But how many organisations have the people, the time, the resources, the clarity, the strategy, even the budget to really take it a step further after the initial implementation? <br />
<br />
This is not because I don't think that charities don't want to, I'm sure they do, and not because they don't have the vision or understanding. Again, I am sure some charities do and I hope such organisations are getting the tremendous benefits which such systems can bring. But I wonder if that is still done by just a minority of NFP organisations.<br />
<br />
<b>Why not?</b> <br />
If you consider all those factors listed above then the one over-riding thing which I think has the most impact on this is: People. People are the problem and the answer. Because it is the people which make the difference in taking full advantage of CRM platforms.<br />
<br />
Consider skill-sets. Clearly charities have had people supporting their fundraising and similar databases for years but traditional fundraising packages have needed different skill-sets to those which the CRM systems require in order to exploit them to the max. For example, whereas the fundraising packages were in many ways more limited, the CRM systems are almost unlimited in their potential. But to achieve that potential you need someone with Business Analysis skills to be able to find out from the users, the fundraisers not just what they want but to interpret those wishes so that they can be implemented in a CRM system. This is not often something I find in mid-size charities and only sometimes in larger NFPs.<br />
<br />
Then you need developers. Sometimes this will only require comparatively fundamental 'admin' type staff who will simply need to configure a CRM system, but for the more powerful and far-reaching benefits you may need specialist developers who can code the systems and get so much more from them. And this will mean new skills, new programming languages and a new understanding of how to get the most from those advances.<br />
<br />
All that takes management, planning, different team structures and a different sort of approach to the fundraising packages. <br />
<br />
So if you do want and can employ such people, then that means the other factors which will be needed will follow-on: time, budget, strategic vision. If you don't have the right people then there's no need for those other things.<br />
<br />
<b>But it's still not necessarily just that...</b> <br />
There's also one more difference which charities need to adopt, and that's a new mindset. Many database managers of the traditional fundraising systems will sadly have become used to being limited to only being able to work within the constraints of those systems, finding workarounds or paying a lot of money to their supplier and even then waiting to get extra work developed for them - or even having to say No to users when they are asked to provide requested functionality.<br />
<br />
So to find yourself in a position where you could now theoretically say Yes to so many of the things requested by your users is of course exciting, but it also means knowing how to progress such requests. How should you configure or develop the systems? How should you ensure you are definitely doing what is best? (Don't just do what is asked for immediately - question such user requirements to make sure they are definitely what is really wanted and what will achieve the best results. e.g. Don't just add another tick-box field…). Do too much too quickly and you may introduce confusion or not do things properly; too slowly and it won't have the possible impact it could have. Do it without planning and you could find yourself having to unravel things and start again. Do it without understanding of database development and you could end up with a worse system, more unmanageable than that which you started with.<br />
<br />
Don't let any of this stop you from buying and implementing the CRM systems and then developing them. Just make sure you have got the right building blocks in place first. The right people.Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com3tag:blogger.com,1999:blog-35863816.post-41160782650688365172015-01-27T08:00:00.000+00:002015-01-27T08:00:03.653+00:00All CRM systems still need a Database Manager<div style="text-align: center;">
<a href="http://www.flickr.com/photos/ocdqblog/5065103584/" title="Holistic Data Management by ocdqblog, on Flickr"><img alt="Holistic Data Management" src="http://farm5.staticflickr.com/4083/5065103584_2e7b86b5da.jpg" height="400" width="342" /></a> </div>
With the proliferation of the<a href="http://blog.itforcharities.co.uk/2012/01/impact-of-new-crm-systems-on.html" target="_blank"> newer, generic CRM systems into the NFP marketplace</a> (i.e. Salesforce, Microsoft CRM etc), it can be easy for a smaller charity who has never before had the opportunity to use such powerful systems to believe that such systems are so easy to use that they won't even need a "database manager". Please don't believe that. You <i>will </i>need someone, whatever they are called, to manage the database/data to some extent, no matter what size you are.<br />
<br />
Just because you are going to run the new database through your browser - which may indeed make it more user-friendly on some occasions - that doesn't mean that it will be so easy that it will "run itself". Someone in your organisation still needs to "manage" it in one way or another. <br />
<br />
The good news is that with some of these systems (and indeed, some '<a href="http://itforcharities.co.uk/database-software/fundraising-software/" target="_blank">traditional fundraising databases</a>'), such a person doesn't have to be an old-school techie. They possibly won't need to write SQL code, learn a complex report writer or understand entity-relationship diagrams. But they will need to be "data aware" - <i>data savvy</i> as I often call it. In fact, job titles such as "Data Manager" and "Head of Data" are often more accurate and more suitable than "Database Manager" or "Database Administrator".<br />
<br />
This is because someone still needs the following attributes: to be able to understand how data is structured and recorded on the system; to be able to review a new user request and then recommend whether a new field is added or whether new codes should be appended to an existing look-up table; to understand and interpret what benefits the new database can bring to your fundraisers and fundraising. To control duplicate records... Someone still needs to have some level of control so that not every user of the system is adding data (and codes) in any old way they want (because it is so easy to do so now…) And so on.<br />
<br />
Because if you don't have good data, standardised procedures and trained users who understand what they are doing on the database, then don't be surprised if you can't create the reports you need, or you take much longer to segment the database for targeting your donors - or, after a few months of installing the new system, you find your users criticising it because it isn't what they were promised…<br />
<br />
The database - and the data - is the very base of a charity's infrastructure for their information needs. New CRM systems may make data management easier but you still need someone to manage that.Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-20301631710523659342015-01-20T08:00:00.000+00:002015-02-03T14:40:56.002+00:00My New Book: 102 Tips on How to Buy Fundraising Databases and CRM Systems<div class="separator" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em; text-align: center;">
<img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBpzgu8J6jjlL4NL0XyhfSyRK-2hNPbs4JCPYLKhxl_UQA-WZPYd91eYI8p9Rpo5k6hUdoQTU_t6OMhB_r30urwIdYrXUYDSuAw1KcS16k6Y2oenNYgdN2RxFI4obkg3MEg7LH/s1600/102tips-cover+3D-2.png" height="320" width="184" /></div>
I have just published this new book: a collection of 102 tips for charities who want to buy a new fundraising database or CRM system. It is compiled from a number of articles I have published on my blog plus a series of brand new tips and in-depth analysis and advice.<br />
<br />
It is written for people whose day job is not the procurement of new databases - and you do not have to be technical to understand it. It is for fundraising managers, fundraisers, database managers, charity IT staff, those working in supporter services and indeed for anyone who has been given the sometimes daunting task of buying a new fundraising database or CRM system.<br />
<br />
It covers the basics of procurement (strategic advice, costs, software demos, project management) but also delves into more detail on supplier management, considerations about database development, the whole tender process and a chapter dedicated to the 'generic' CRM systems (Microsoft CRM, Salesforce et al) which are challenging the more traditional fundraising database packages.<br />
<br />
It is available as a paperback on Amazon, on Kindle and as a simple, instantly downloadable PDF document. It costs £20 <span style="font-size: large;"><span style="font-size: small;">(+ VAT for UK/EC residents).</span></span><br />
<br />
I hope it inspires, assists and enhances your buying process, whether you are already comfortable with a procurement exercise or even if you have never managed one before. Think of it as your own consultant seated by your side as you go along – only at a fraction of the cost! I hope you find it useful.<br />
<script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+'://platform.twitter.com/widgets.js';fjs.parentNode.insertBefore(js,fjs);}}(document, 'script', 'twitter-wjs');</script>
<br />
<hr />
<span style="font-size: large;"><b>Where to Buy It...</b></span><br />
<span style="font-size: large;"><span style="font-size: small;">The book costs £20 (+ VAT for UK/EC residents), and is available from:</span> <b><br /></b></span><br />
<br />
<table border="0" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 480;">
<tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="padding: 0cm 5.4pt 0cm 5.4pt; width: 142.0pt;" valign="top" width="189"><div class="MsoNormal">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-gdh08xg_1jBEG0RZeJN2SnTwatgNYNbqZ11C2zz8Z_66KbYWIkeQp10SeVG2V7G63WxLOPcSUz8-Pmz-vpQte0oj84YhAJTY8FFQmFARIhtXr5v8maNz4PE87KlIWjb_vYzW/s1600/102tips-cover+3D-2.png" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-gdh08xg_1jBEG0RZeJN2SnTwatgNYNbqZ11C2zz8Z_66KbYWIkeQp10SeVG2V7G63WxLOPcSUz8-Pmz-vpQte0oj84YhAJTY8FFQmFARIhtXr5v8maNz4PE87KlIWjb_vYzW/s1600/102tips-cover+3D-2.png" /></a>Paperback version on<br />
<a data-mce-href="http://www.amazon.co.uk/-Depth-Fundraising-Software-Charity-Systems/dp/1505886635" href="http://www.amazon.co.uk/-Depth-Fundraising-Software-Charity-Systems/dp/1505886635" target="_blank">Amazon UK</a> or <a data-mce-href="http://www.amazon.com/-Depth-Fundraising-Software-Charity-Systems/dp/1505886635" href="http://www.amazon.com/-Depth-Fundraising-Software-Charity-Systems/dp/1505886635" target="_blank">Amazon US</a></div>
</td>
<td style="padding: 0cm 5.4pt 0cm 5.4pt; width: 142.05pt;" valign="top" width="189"><div class="MsoNormal">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiS-UKe1jxtLPjaft8saZ8fS16J2vcXpP1RqpfDPqjDbRBuXLK-_-nlBmifSOv0st1b8ov0CK5ImT4chR2M_0zWzcSeKT27HSE53DWoBbOz7jJlpgnZ4JdBbgqFZuJ8Wf52UZrM/s1600/102tips-cover+kindle.png" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiS-UKe1jxtLPjaft8saZ8fS16J2vcXpP1RqpfDPqjDbRBuXLK-_-nlBmifSOv0st1b8ov0CK5ImT4chR2M_0zWzcSeKT27HSE53DWoBbOz7jJlpgnZ4JdBbgqFZuJ8Wf52UZrM/s1600/102tips-cover+kindle.png" /></a>Kindle version on<br />
<a data-mce-href="http://www.amazon.co.uk/Depth-Fundraising-Software-Charity-Systems-ebook/dp/B00RQNN556" href="http://www.amazon.co.uk/Depth-Fundraising-Software-Charity-Systems-ebook/dp/B00RQNN556" target="_blank">Amazon UK</a> or <a data-mce-href="http://www.amazon.com/Depth-Fundraising-Software-Charity-Systems-ebook/dp/B00RQNN556" href="http://www.amazon.com/Depth-Fundraising-Software-Charity-Systems-ebook/dp/B00RQNN556" target="_blank">Amazon US</a></div>
</td>
<td style="padding: 0cm 5.4pt 0cm 5.4pt; width: 142.05pt;" valign="top" width="189"><div class="MsoNormal">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPYuKP8xT12LNg0bsXjm4IxmbbJsQ8OskKuTo1_5s3nzkOtXprgbCukfbrmw-iFrg_LFeBJJgI24wnLM-1oUJ-pSVw1EGejrk2OKMbo_35bRiyI_qq2ybvghkepeR-sgE_2VN0/s1600/102tips-cover.png" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPYuKP8xT12LNg0bsXjm4IxmbbJsQ8OskKuTo1_5s3nzkOtXprgbCukfbrmw-iFrg_LFeBJJgI24wnLM-1oUJ-pSVw1EGejrk2OKMbo_35bRiyI_qq2ybvghkepeR-sgE_2VN0/s1600/102tips-cover.png" /></a>PDF document - <a href="http://itforcharities.co.uk/102-tips-on-how-to-buy-fundraising-databases-and-crm-systems-purchase-pdf-download/" target="_blank">instant download from my website</a></div>
</td>
</tr>
<tr style="mso-yfti-irow: 1; mso-yfti-lastrow: yes;">
<td style="padding: 0cm 5.4pt 0cm 5.4pt; width: 142.0pt;" valign="top" width="189"><br /></td><td style="padding: 0cm 5.4pt 0cm 5.4pt; width: 142.05pt;" valign="top" width="189"><br /></td><td style="padding: 0cm 5.4pt 0cm 5.4pt; width: 142.05pt;" valign="top" width="189"><br /></td></tr>
</tbody></table>
<br />
<hr />
<br />
<a data-mce-href="http://www.amazon.com/-Depth-Fundraising-Software-Charity-Systems/dp/1505886635" href="http://www.amazon.com/-Depth-Fundraising-Software-Charity-Systems/dp/1505886635" target="_blank"></a><br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-78273171129457221332015-01-19T08:00:00.000+00:002015-01-19T08:00:12.018+00:00Differentiating Suppliers of the Same Software Platform<div style="text-align: center;">
<a href="https://www.flickr.com/photos/nanagyei/10876907354" title="Twins by Nana B Agyei, on Flickr"><img alt="Twins" height="345" src="https://farm4.staticflickr.com/3693/10876907354_9094e5a880.jpg" width="500" /></a> </div>
<br />
An interesting challenge is arising on CRM platforms. With more and more companies producing 'templates' for fundraising and membership solutions on the same platforms (mostly Dynamics and Salesforce), I am finding that I see quite similar looking software from different suppliers. Which leads me to ask myself: if the platforms are that good and are right for my clients, and the software is starting to blur into the same sort of solution, then how do I distinguish between the different offerings?<br />
<br />
<b>First, it's about the supplier</b> <br />
What this shows straight away is the importance and significance of the supplier themselves. i.e. their approach to your project, their empathy with your organisation and staff; the people they employ; their sector knowledge. The added value they can bring to the project and to your organisation. All the usual sort of stuff I discuss frequently on my blog, but with a different level of emphasis because of such a need for comparisons and differentiators.<br />
<br />
And that to me is still the most important thing.<br />
<br />
<b>But it is the software too</b> <br />
There is more you can also do to look at the software more deeply. Even if it looks similar (which it probably will because it will be on the same platform) it will of course be different when you look closer, especially in the areas of fundraising or membership. Some of the specifics you could consider include:<br />
<ul>
<li>How are the companies actually presenting the core data which you want to see? Is it truly intuitive? Is there flexibility in its presentation? Have they understood how fundraisers want to see and use such data?</li>
<li>Look especially more deeply at the most critical parts of the software. For most charities who are doing fundraising this will be the income management. i.e. If a supplier is offering you a solution with some sort of template to manage your cash donations and regular donations, then how have they structured that? Have they used the platform's standard entities? Have they used custom entities? How have they created a system where you can record a pledge and its instalments? How have they created a system which enables you to create a direct debit mandate and then record all the future payments against that? And do they really understand regular giving itself? And how about reporting of this area - that takes some thinking about. This will start to show-up differences and suppliers' comprehension of this crucial area.</li>
<li>What about batch entry of income? What about the data entry of more complicated aspects of some fundraising data - e.g. in memory relationships, corporates and their contacts?</li>
<li>How have they actually coded the system to process direct debits? Can they manage high volumes - not just your current levels but if you increase them too?</li>
<li>Do they understand Gift Aid and how have they linked their system with HMRC's Charities Online?</li>
<li>How have they optimised the more common CRM elements for charities' needs? e.g. opportunities, leads. Have they shown how you major donors and HNWI fundraisers could get the most out of such systems?</li>
</ul>
In addition to all that, you also need to consider how different suppliers are considering the future of your software. Do they see it as a 'product' whereby they will be providing functional upgrades in the future? Or is it just a system which you are buying 'as is' and then build on enhancements as and when you want to? Neither way is right or wrong, it's down to your requirements and wishes. And depending on how you want to develop the system in the future, consider also the intellectual property (IP) aspects of the solutions.<br />
<br />
Finally, you'll notice I haven't mentioned cost. So, yes, cost does of course distinguish and separate suppliers, but it's never as simple as saying that the cheaper solution is the one to go for. There is so much more to cost than that! Have a look at my <a href="http://blog.itforcharities.co.uk/search/label/costs" target="_blank">blogs on cost</a> factors and indeed, everything else about <a href="http://blog.itforcharities.co.uk/search/label/Procurement" target="_blank">procurement</a>.Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-17582352900526097762015-01-12T08:00:00.000+00:002015-01-12T08:00:20.137+00:00My Predictions for NFP CRM Systems in 2015<div style="text-align: center;">
<a href="https://www.flickr.com/photos/adavey/5078246097" title="Fortune Teller by A.Davey, on Flickr"><img alt="Fortune Teller" height="354" src="https://farm5.staticflickr.com/4090/5078246097_03563da043.jpg" width="500" /></a> </div>
<br />
It's that time of year when people predict what's going to happen in the next 12 months and so I thought I would join in. So here goes: these are my predictions for what will happen in the arena of UK NFP fundraising databases and the CRM market in 2015:<br />
<br />
1. The increasing adoption of <a href="http://www.salesforce.com/uk/" target="_blank">Salesforce</a> and <a href="http://www.microsoft.com/en-us/dynamics/crm.aspx" target="_blank">Microsoft CRM Dynamics</a> - especially for the <b>larger charities</b> looking for a new system. In the last 12-18 months, for the tenders for fundraising databases that I know of amongst larger charities, more have been won by a company selling Salesforce or Dynamics - and I think this pattern will continue at the moment. <a href="https://www.blackbaud.co.uk/blackbaud-crm" target="_blank">Blackbaud CRM</a> will also be in the mix but it has not been as successful of late here in the UK (outside the Higher Education sector) and ACS's <a href="http://www.advancedcomputersoftware.com/abs/products/care-ng.php" target="_blank">CareNG</a> does not seem to be competing at the same level as the others right now.<br />
<br />
So at the moment, for larger charities who are also looking for a development platform, I believe Dynamics and Salesforce will top the sales.<br />
<br />
That said, I wouldn't be at all surprised if one or two larger charities implementing CRM systems for fundraising find it tough going. There are still very few sizeable UK charities using such systems for their dedicated fundraising database and I think some may find it takes longer and/or costs more than they expect.<br />
<ul>
<li>As a 'sub-division' prediction on this, I also think that 'templated' versions of Salesforce and Dynamics will grow in popularity - i.e. offerings from third-party suppliers with some built-in charity functionality such as Direct Debit management, Gift Aid etc - both in terms of client adoption and new templates being developed by more companies. Plus Salesforce's own <a href="http://www.salesforcefoundation.org/introducing-ngo-connect/" target="_blank">NGO Connect</a> adaptation could be interesting to watch <i>if </i>it is developed for the UK market.</li>
</ul>
2. The <b>mid-size charit</b>y market for fundraising systems will see a battle between <a href="https://www.blackbaud.co.uk/fundraising-and-relationship-management/raisers-edge-nxt" target="_blank">Raiser's Edge NXT</a> and Access <a href="http://www.theaccessgroup.com/solutions/crm--fundraising.aspx" target="_blank">thankQ CRM</a>. Both Blackbaud and The Access Group are bringing out new products in 2015 as successors to their existing Raiser's Edge and thankQ systems and it will be interesting to see which moves ahead. It looks like The Access Group will release their new offering first so that could give them a head start, but Blackbaud's new technology and financial clout should see them pick up new clients later in the year.<br />
<br />
That said, Raiser's Edge NXT still has some questions hanging over it as I have <a href="http://blog.itforcharities.co.uk/2014/10/raisers-edge-nxt-2-initial-thoughts.html" target="_blank">highlighted before in another blog post</a>, so it will be very interesting to see how that does develop.<br />
<br />
I also believe that <a href="https://civicrm.org/" target="_blank">CiviCRM</a> will win deals amongst mid-size charities but it needs one or two more significant implementations in the UK to really get it to be more widely adopted. (And of course Salesforce and Dynamics will also be an option for this level, but for those organisations with 'pure fundraising' needs there would need to be a good reason to be building from 'vanilla' for such systems - hence, again, my prediction for the growth of CRM fundraising templates.)<br />
<ul>
<li> I also think that Blackbaud's existing Raiser's Edge 7 is not going to disappear for some time. It (like other similar products) still provides solid functionality for charities' operational fundraising requirements, so despite its age and shortcomings it will probably continue to sell for at least this year, and carry on being used for at least the next few years by many existing clients.</li>
</ul>
3. <b>Extensibility </b>will be increasingly more important. In terms of system flexibility, adaptation and development, charities are now moving on from accepting the limitations that the more traditional fundraising databases have offered historically. The goals, wishes and requirements of fundraisers (and therefore the database team too) means that such restrictions are almost certainly no longer acceptable for mid-size/large NFPs.<br />
<br />
Thus the need for the increased power and flexibility of system extensibility has come to the fore. Charities want to be able to change forms and screens, insert entities and fields and add data integrity/business rules etc more easily than they have been able to in the past. And they want to be able to do this themselves, without having to be technical geniuses. But they also want to at least have the option of being able to get down-and-dirty with programming code if they desire to do that and if they are capable of doing so, and to be able to use such code so that they can extend the database beyond what it was originally developed for - but in such a way so that it won't break it in the future when new standard upgrades are released.<br />
<br />
The CRM systems are leading the way in this but the new products from Blackbaud and thankQ are catching-up in some (if not all) areas and some degree of extensibility will no longer be a nice-to-have for new implementations.<br />
<br />
4. Charities will want to <b>integrate </b>their fundraising/CRM database with their website and other data sources more tightly and with more automation… but they will still find it hard. This fundamental need is not new of course; and my point here is really a bit of an 'anti-prediction' in that although I predict the increasing desire for such integration, I still think it is going to be hard for more automated integration apart for those charities who have a decent budget and good in-house technical skills, or for the more 'common' data sources such as JustGiving.<br />
<br />
Ironically, from the point of view of attempting to be Nostradamus, I hope I am wrong about this prediction.<br />
<br />
5. Software companies and salespeople will continue to push <b>Mobile/Social Media/Cloud</b> as their innovations. Which is hardly a radical prediction, is it! After all, this is already happening. And of course these technologies do offer the potential of great benefits and the ability to interact with our fundraising/CRM systems.<br />
<br />
But why I have highlighted this area is because I want to add that you shouldn't follow these trends blindly and you shouldn't be buying a new system <i>just </i>because it offers such capabilities. Instead, work out why or how such technologies could be used with your database. For example, it is not just a matter of recording tweets in your CRM system (I mean, are fundraisers really going to look through hundreds of tweets on a fundraising database?); it is not just about seeing a supporter's Facebook page from within the CRM (although that can offer some speed of access); and it's not just about accessing your database from your mobile/tablet without a good business reason, no matter how flashy the salespeople make that look. Although, yes, mobile access for event fundraisers at an event, for development staff visiting alumni, for member access - absolutely, that sounds good. So do it where it's right to do so - but not just for the sake of it.<br />
<br />
<hr />
<br />
A final note on this: I should add that there are of course many more fundraising databases available (AdvantageNFP, Harlequin, KISSS etc) and CRM systems (Workbooks, SugarCRM etc) - see the <a href="http://itforcharities.co.uk/database-software/" target="_blank">itforcharities website</a> for such lists - and my references to the systems above do not mean that they are necessarily right for you or your particular project. If you do look for a new database then you need to do a proper analysis and procurement exercise and select whichever system and supplier is right for your organisation.<br />
<br />Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0tag:blogger.com,1999:blog-35863816.post-43967268448529584652014-12-15T08:00:00.000+00:002014-12-15T08:00:10.902+00:00How To Tell If a Supplier's Lead Consultant is Right For You<div style="text-align: center;">
<a href="https://www.flickr.com/photos/mrfb/8727714185" title="Matches by MiloszB, on Flickr"><img alt="Matches" height="281" src="https://farm8.staticflickr.com/7348/8727714185_2f4c9dfa53.jpg" width="500" /></a> </div>
<br />
I've written many times how I believe that one of the most important things for any database implementation is <a href="http://blog.itforcharities.co.uk/search/label/Suppliers">the database supplier itself</a>. And within the supplier relationship, one of the most important relationships will be that between your supplier's 'lead consultant' and your staff. So you need to make sure that such a relationship is right for you. And one way to do that is to hold 'mock workshops' during the procurement process.<br />
<br />
In almost all fundraising database and CRM system implementations you are going to have some sort of initial 'discovery phase'. This might be as simple as two or three days with the supplier where they take you through the options, discuss your needs and configure their system with you. Right through to several months of intense work with many workshops, software prototyping sessions, business analysis work and more.<br />
<br />
Personally, I think that this is one of the most important parts of your implementation. Get it right and the subsequent system development will have every chance of going well; get it wrong and you're starting off down the wrong path from the word go. Not good.<br />
<br />
So it therefore leads on naturally that whoever the supplier allocates to work with you as their 'lead consultant' has to be someone who you trust and who is right for you. That job title may go under various guises but essentially it is the person from the supplier who will lead you through the workshops, who will work with you in defining how the systems should be for you, will do a variant of business analysis of some sort, maybe even some project management, and will as a result work very closely with your staff. <br />
<br />
So to find out if a supplier's lead consultant is good and is going to work well with your staff, one thing you can do is hold a 'mock workshop' during your database procurement. By this I mean that you should arrange a session whereby a supplier's lead consultant visits your office and leads a workshop with some of your staff in order that you can assess how that goes. This should be done in the same way that the supplier would do if this was a workshop during your actual implementation. The importance of this is not so much the subject of such a workshop, but more about the approach which the consultant takes, their connection with your staff, the confidence which they do (or don't) bring to your team, and so on. I have done this a few times and it has always been useful. <br />
<br />
I wouldn't suggest doing it with all your potential suppliers and you need to wait until you are some way into the procurement process so that any short-listed suppliers can say who you would be working with if they did win your contract. As such, I would normally do this with, say, just the last two short-listed suppliers when we are getting close to making a decision. It is therefore one of the things we can bring into the final decision process.<br />
<br />
And if you want to take this a step further, then don’t just ask for a mock workshop, but ask the supplier and lead consultant to then go back to their office for a few days/weeks and then return to show you what they would do with the knowledge they have gained from you. E.g. ask them to configure an aspect of their software for you based on the workshop subject, and/or ask them to show what documents they might create from such work. Don't take advantage of a supplier's time if you do do this - i.e. don't expect them to spend many man days customising a complicated part of your system - it should be just enough so that it shows they have put in some effort. <br />
<br />
Yes this is more time and work for you and your staff, and of course for the supplier(s) too, but it is definitely time well spent. It's such a critical part of your project that anything you can do like this to try to improve the chance of success can only help.Ivan Wainewrighthttp://www.blogger.com/profile/12680581084263166735noreply@blogger.com0