Hospital Donations

High Level Design

Overview

As many hospitals base their budget on donations, it’s important to track hospital analytics trends to better plan for the next annual budget and to find ways to increase the engagement of the donors and ensure financial stability. If the donated amounts are not expected to change dramatically, it’s more important to analyze the retention level of the donors and find ways to can engage more donors in the program.

Goals

Increase donors base and engagement of existing donors.

Objectives

• Track renewal rates to determine engagement.
• Track acquisition rate vs attrition rate to determine growth in terms of donors base.
• Track campaign effectiveness over time in terms of total amount of donations to enable effective budgeting decisions.
• Assess best donors and state by donated amount in order to create targeted campaigns.

KPI Architecture

Objectives	KPIs	Measures	Data Source
Track renewal rates to determine engagement	Renewal rate	(Count all donors who donated during current year – Count all donors who donated during current year for the first time) / last year donors amount	Excel\KPIs
	2 years renewal rate	Count all donors who donated during last two years and current year consecutively/Count all donors who donated during last two consecutive years	Excel\KPIs
	3 years renewal rate	Count all donors who donated during last three years and current year consecutively/Count all donors who donated during last three consecutive years	Excel\KPIs
Track acquisition rate vs attrition rate to determine growth in terms of donors base	Acquisition rate	Count all donors who didn’t donate last year but did donate during current year/ last year donors amount	Excel\KPIs
	Attrition rate	Count all donors who donated during current year for the first time/ last year donors amount	Excel\KPIs
	Growth	Acquisition rate-Attrition rate	Calculated
Track campaign effectiveness over time in terms of total amount of donations to enable effective budgeting decisions.	Total donations by campaign	Per campaign Id and Year – total amount of all donors donation	Excel\KPIs; Excel\Campaign
Assess best donors and state by donated amount in order to create targeted campaigns.	Total donations by state	Per state and Year – total amount of all donations	Excel\KPIs; Excel\Donors
	Top 5 donors	Per donor Id and Year – total amount of all donations (presenting only the top 5 donors)	Excel\KPIs; Excel\Donors

Data Modeling (Elasticube Design)