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.

Dashboard Example (sample data)

Click on the image to open and interact with the dashboard:

Hospital Donations - Healthcare Dashboard

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