380 likes | 598 Views
Analysis Greatest hits – the final countdown. 29 November 2011 Robbie Buscombe Individual Giving Manager – Projects and Operations Steven White Director of Operations. Agenda. The introduction About Marie Curie Cancer Care Data Objectives in 2009 Foundation Audit The final countdown
E N D
Analysis Greatest hits – the final countdown 29 November 2011 Robbie Buscombe Individual Giving Manager – Projects and Operations Steven White Director of Operations
Agenda • The introduction • About Marie Curie Cancer Care • Data Objectives in 2009 • Foundation Audit • The final countdown • The top ten analytical techniques • The future • The music quiz results
About Marie Curie Cancer Care and where we were in 2009 Introduction
About Marie Curie Cancer Care Marie Curie Nurses • The charity is best known for its network of over 2,000 Marie Curie Nurses working in the community to provide end-of-life care, totally free for patients in their own homes. • Last year we cared for more than 31,000 terminally ill patients in the community and in our nine hospices. • There is a Marie Curie Nursing Service available to 96 per cent* of the UK. • We mainly care for people with cancer but we also care for people with other life-limiting illnesses such as dementia, Motor Neurone Disease and heart failure. • To access a Marie Curie Nurse, patients and/or their carers should speak to their GP or District Nurse.
About Marie Curie Cancer Care Marie Curie Hospices • Marie Curie has nine hospices • It is the largest provider of hospice beds outside the NHS • Marie Curie Hospices provide care for patients with cancer and other illnesses and provide support for families and carers, all completely free of charge. Research • Marie Curie’s pioneering programme of palliative care research is showing how we can better care for cancer patients. • The charity has two centres for palliative care research, The Marie Curie Palliative Care Unit in London and The Marie Curie Palliative Care Institute in Liverpool. It also funds seven fundamental scientific research groups which investigate the causes and treatments of cancer.
About Marie Curie Cancer Care Supporting the Choice to Die at Home • Research shows around 65% of people would like to die at home if they had a terminal illness, with a sizeable minority opting for hospice care. However, more than 50% of cancer deaths still occur in hospital, the place people say they would least like to be. • Since 2004 Marie Curie Cancer Care has been campaigning for more patients to be able to make the choice to be cared for & die at home. Funding • Around 70%of the charity’s income comes from the generous support of thousands of individuals, membership organisations and businesses, with the balance of our funds coming from the NHS. • Our services are always free of charge to patients & their families, which means that in 2010-12, we will need to raise more than £140 million. We spend more than £83 million a year on our care and research activities.
Where Individual Giving was in 2009 • Had developed four appeals and Shine On (quarterly supporter newsletter) as core mailing activity • Supported regional and other fundraising departments but did not have access to their data • Had a good base of skills across the organisation to facilitate growth BUT… • Some datasets where not centrally owned (i.e. not on the main database) • Used a complicated RFV selection model – mailing segments with very few supporters • Had no structured selection model for non-core mailings e.g. pledger acquisition mailing • Generally there was a poor understanding of the content/quality of the data and how it could be used • There was a lack of skills across the organisation to handle the required change
Analysis Objectives in 2009 • Due to the recent introduction of the new CARE database, and limited analytical capacity of the previous database, little analysis has been undertaken • Provide some essential basic reporting for Direct Marketing campaigns to enable tactical decisions to be made • Provide a suite of regular reports that can inform (Fundraising Management Team) of the volume, recency, frequency and retention of supporters at a high level • To support the implementation of the MCCC strategic plan (2008-11) by providing robust data on which to base long term investment decisions • Ultimately this analysis should be the first step in developing audience segmentation to support development of MCCC’s Stewardship Strategy
Foundation Audit Spring 2009 – some quotes I’m worried that the strategic thinkers in this organisation don’t know or aren’t involved in the database architecture/structure. Everything is in the database - we just can’t get any information out quickly… I use Excel. Everyone is so focussed on their own detail and work in their own silos. Not allowed to say that things don’t work well. Defensive culture is too positive. The 4 different teams that communicate with my mum have no idea of her overall enthusiasm and value to Marie Curie. We are the least report focused organisation I’ve come across. If we have one record for everyone – people will quickly understand the relevance of the base.
Example of audit – the number of supporters lapsing has exceeded the level of new supporters during the years 2004 to 2007
2. Education Online 1. Hygiene Process 6. Delivery Software 7. Strategy Legacies 5. Tactical Reporting 4. Single Supporter View 3. Fundraising Closer to the Database Audit outcome – where did MCCC want to be ?
Our analysis top ten The Final Countdown
At number 10 – categorisation • SQL roadmap – developing analysis summary tables • Single Supporter View(s) • Financial History Merge • Mailing History Merge • Source Code mapping • Reports (LTV, MASt)
At number 8 – knowledge transfer select contact_number, product, transaction_date, fhd.amount, rank() OVER (PARTITION BY contact_number, product order by transaction_date desc) AS r, row_number() OVER (PARTITION BY contact_number, product order by transaction_date desc) AS w, dense_rank() OVER (PARTITION BY contact_number, product order by transaction_date desc) AS d from financial_history fh join financial_history_details fhd on fh.batch_number = fhd.batch_number and fh.transaction_number = fhd.transaction_number order by contact_number, product, transaction_date desc • Transfer of skills / Mentoring • Examples of training given in 2011 • LTV Insights • Selection briefs • SQL • Updating reporting tools • Advanced Excel • SmartFocus
At number 7 – Response Uplift • RUM modelling looks at populations of the supporter base who respond with different elasticities
At number 6 – Lifetime value • Presented to Chief Executive • Updated in-house • Essential metrics and understanding of performance • But historical and dependent on costs • Introducing Projected LTV …
10 to 6 are prerequisites before we can truly influence the bottom line … what makes the biggest difference are 5 to 1 From Basics To Bottom Line
At number 5 – Projected ROI • Identifies key drivers of long term ROI: • Volume • Cost per acquisition for regular givers • Average Direct debit value • Attrition Rates • Suppression rates & Gift Aid penetration • Feeds these assumptions into a cash flow model: • plus other assumptions around upgrade, reactivation, cross sell, loyalty costs, financial discount rates etc. but we can start simple! • Projects cash flow over 5 year period and shows: • Return on Investment • Breakeven period • Net financial contribution (income – expenditure) • Can be used to compare channels and understand sensitivities to key drivers. Many assumptions can be quantified using LTV outputs
At number 5 – Projected ROI cont. • Shows possible H2H scenario (high churn, high average value). Net income of £2.7m over 5 years and ROI of 2.15 • If Yr1 attrition reduced to 30% then income rises to 3.7m (£1m gain) • If Yr1 attrition rises to 55% then income falls to 1.3m (and 1.6 ROI with breakeven delayed to year 3)
At number 4 – Retention cont. • “The retention tool is fabulous. It allows me to track and monitor no show & attrition rates across all agency & in-house campaigns. This insight into which streams have the best retention & their best cost per acquisition in the long term is consequently a great help for budgeting & strategy.” • “The tool identifies “hotspots” during the donor journey by showing attrition at months 3,6 and 12. This will prove extremely useful when reviewing methods, contents & timings of supporter communications. Monitoring other supporter information such as average gift, age, wealth & other sonar profiles will allow a greater insight into targeting regular givers” 2010 in particular is showing signs of early high attrition To c.25% in recent years Trending towards 20%-30% driven by high proportion of F2F Yr1 Attrition has increased over recent years: from c.10% pre-2005 Predictors Sonar and age also shown to be predictive 2008 Yr1 attrition low at 15% overall: Channel clearly an important factor
At number 3 – prediction models … • “There seems to be little science applied from a segmentation or data modelling standpoint when campaigns are being developed” Data IQ Autumn 2011 article on Closing the Fundraising Analysis Gap 8 out of 10 charities who expressed a preference
Campaign Prediction - Background and objectives • To simplify the SmartFocus selections and time taken to produce the segments - reduce the number of cells (52 segments for XMS 2008 wave 1) • The XMS 2009 selection had 5 segments! • To consider targeting other sub-populations of the database not previously “understood” from a data viewpoint, as likely candidates to respond. • Identified ‘good prospects’ within committed givers and regional supporters • To improve ROI - Analysis of the last 5 XMS mailings had shown: • 11,745 supporters have responded to all 5 mailings! • 23,650 supporters continually being mailed XMS and never responded. Equates to £10k per annum potential saving! • Employment of prediction model has been one factor in helping DM maintain good results. A £200k net contribution gain Vs Budget • To transfer knowledge back to MCCC • Provision of scoring code • Develop the audience selection briefs
Great Daffodil Campaign – Marie Curie’s most heard of campaign Model used Model not used Net Income from Great Daffodil Appeal Mailing has grown substantially in line with the use of the Wood for Trees Scoring Model 26
Strength of model visible across all four major campaigns AWA Warm XMAS WARM Post-model Post-model Pre-model Pre-model CNA WARM (CASH ONLY) GDA WARM Post-model Post-model Pre-model Pre-model
At number 2 – Legacies • A word on the legacy pledger model …
So pop pickers …a recap on our top ten • Single Supporter View / Categorisation • Measurement • Transfer Knowledge • Response Uplift Testing • Lifetime Value • Projected ROI • Retention • Prediction Modelling • Legacies – any science! • Data Integrity 10 to 6 are the foundation,5 to 1 are more tangible and impact bottom line!
What next for analysis Introduction
What next ? • More on … • Projected ROI • Legacies • Simple segmentation + communications overlay • Reviewing the effectiveness of communications
On retention… communications Step 4 – Targeting Propensity Modelling (MICRO) Step 3 – Establish some rules Step 2 – Communication Step 1 – MACRO Simple Segmentation
On acquisition … • Continue to use • Lifetime Value (historic) • Committed Retention • Projected ROI (Future LTV)
Answers to our music quiz And finally…
The artists and titles are … Europe – The Final Countdown • The Foundations – Build Me Up Buttercup • The Housemartins – Build • Supertramp – School • Pink Floyd – Money • Foo Fighters – All My Life • Kaiser Chiefs – I Predict A Riot • The Faces – Stay With Me • ABBA – Knowing Me Knowing You • Wham – Wake Me Up Before You Go-Go • Garbage – The World Is Not Enough
Questions? Thank you…