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)

Suggested data model for customer churn analysis

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation