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
29 November 2011
Individual Giving Manager – Projects
Director of Operations
Marie Curie Nurses
Marie Curie Hospices
Supporting the Choice to Die at Home
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.
6. Delivery Software
Closer to the
Audit outcome – where did MCCC want to be ?
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
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
2010 in particular is showing signs of early high attrition
To c.25% in recent
Trending towards 20%-30% driven by high proportion of F2F
Yr1 Attrition has increased over recent years: from c.10% pre-2005
Sonar and age also shown to be predictive
2008 Yr1 attrition low at 15% overall: Channel clearly an important factor
Data IQ Autumn 2011 article on Closing the Fundraising Analysis Gap
8 out of 10 charities who expressed a preference
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
10 to 6 are the foundation,5 to 1 are more tangible and impact bottom line!
Step 4 – Targeting
Propensity Modelling (MICRO)
Step 3 – Establish some rules
Step 2 – Communication
Step 1 – MACRO Simple Segmentation
Europe – The Final Countdown