Brilliant! Only word for the big Lottery take-off
Back to testimonalsNumbers. For a man like Graham Dawson, they need to stack up. Lives, in the simplest of terms, depend upon it.
The ones that stared back at Lincolnshire & Nottinghamshire Air Ambulance Charitable Trusts finance manager from the annual accounts in 2011 didnt make completely encouraging reading.
Raising the £2m-plus a year to keep the service aloft had become an increasingly tough task. Like most charities, public donations were proving harder to come by. Legacies, a vital source of funds, were falling.
But there was a glimmer of light. Merchandise sales and lottery income were on the rise the latter by 28 per cent.
Its against that background that Graham and his team found themselves considering how they were going to recruit new lottery players to the cause. As they did, it wasnt hard to do the calculation. For the ambitious door-to-door canvassing they were planning, their existing Goldmine database needed to be up to the challenge. It wasnt. They needed one that was .
The donorflex team at Patrick House had already met the LNAACT team before Graham called to explore the donorflex Lottery route as Christmas neared last year. In mid-2010, Chief Executive Peter Aldrick and his managers had concluded that they needed a system that could record data across the dashboard donors, donations, members, lottery, Gift Aid and more.
Wed shared time at a couple of Air Ambulance Association conferences and in October, 2010 given an initial demo of the unified database. But the slow-burn approach was about to change dramatically.
By the start of 2012, the two parties had agreed a date for client development consultant Steve Mason to show them just what life with donorflex might look and feel like. By February 2, theyd seen all they needed. Eight days later, the deal was done.
Within three weeks, Steve was working on the Goldmine data and preparing his consultancy report. Data translation and initial training followed a couple of weeks later. By April, they were airborne.
Its not hard to see why Graham had to move so quickly.
Goldmine had been in for eight years, but it wasnt built for the job.
We made it work, and it did work, but very basically, Graham explains. There was no search functionality really. There was no data manipulation.
We had a separate random number generator. We had to manually input all the numbers. That was a good days work, really; working out who was in the draw and who wasnt, whod paid and who hadnt, whod got credit .
The shortcomings didnt end there. On the old system, each member had their own record for every number they played.
At the time, supporters were signing up on at least two chances, he recalls. At least two records, two addresses, two phone numbers for every person . Very quickly, we realised that it just wasnt going to work with canvassing. We should have had donorflex in before we started, but we didnt. So we decided that we needed to move very quickly.
The lottery operation was first on the radar because it could be addressed easily in comparison to the others like merchandise and general fundraising, where there were many data fields to capture.
Weve gone from 15,000 members to 24,000 members in six months. Without donorflex, we couldnt have done that
So, how did implementation go?
Brilliantly, Graham says. Its the only word I can use. All credit to Steve. He did a fantastic job. We looked at the data. You guys took the data and manipulated it. That was a huge help.
Thats not to say there werent anxieties there hasnt been a donorflex Lottery implementation yet where a fear of the new hasnt required a touch of TLC.
For one member of staff there was an anxiety and it didnt surprise me. But the training, the talking through things, really helped her. Were six months down the line and shes using it perfectly fine. Loves it to bits.
When Graham reflects on the successes of those first six months, he doesnt need to look far.
Weve just done a mailing, he says. Through donorflex we took the database, exported it to csv and sent it to the raffle mailing company. That helped us send out 18,550 packs very easily.
Would we have been able to do that before? No, because wed have had lots of duplicate mailings. The time taken to manipulate that data was just unreal whereas, this time, it was just 10 minutes if that to get the data out, email it across to the mailing company and that was it.
But thats not his best statistic. Take his new recruits.
Ive just processed standing orders for the last five business days 850 standing orders. On the old system, wed have typed those in physically. Bear in mind that wed have to type it in for two records, not just one. So, all of a sudden, youre doing 1,700 entries!
That used to take a week: Now, its the click of a button . Weve got it down to 10 minutes. Getting the data off our internet banking software, manipulating it into Excel, take out the ones that arent relevant, import into donorflex, sort the noes out.... Ten minutes. That alone is our biggest saving in time, without a doubt.
Numbers, then. If theyre beginning to stack up like never before in an organisation thats flown in excess of 13,000 missions in its 18-year history, heres one that tops the lot and will play a direct part in the lives that will be saved in the months and years to come.
Weve gone from 15,000 members to 24,000 members in six months, says Graham. Without donorflex, we couldnt have done that.
We work with the key drivers of the UK charity sector.