Sandy Hook Promise

Nonprofit Fundraising Implementation

  • Client: Sandy Hook Promise
  • Industry: Nonprofit · Cause & Cure
  • Salesforce products: Nonprofit Success Pack (NPSP)
  • Services: Implementation
  • Previous system: Raiser's Edge / Raiser's Edge NXT (Blackbaud)
  • Partner apps: Apsona
  • Project duration: 3.5 months

Sandy Hook Promise is to honor all victims of gun violence by turning our tragedy into a moment of transformation. By empowering youth to “know the signs” and uniting all people who value the protection of children, we can take meaningful actions in schools, homes, and communities to prevent gun violence and stop the tragic loss of life.

The Why

Sandy Hook Promise tracked contact and meeting information on shared excel documents, but didn’t have a form tool in place directly for authorize.net or PayPal causing data integrity/reconciliation issues. The had tried to use DonorPerfect for programs but failed so all programs had to be moved to Sharepoint, which caused a reactive onboarding process.

Our Solution

  • Migration of data from Raiser’s Edge
  • Migration of SQL export file of 3000 PDF records from Raiser’s Edge into Salesforce
  • Implementation of Apsona Batch Entry tool for gift batch entry and document generation tool, including creation of tax letter and donor acknowledgement templates and training on creation of additional templates
  • Training and template creation with NPSP Import Wizard for regular import of gift data file representing gift data from Benevity, PayPal, CrowdRise, Facebook and Authorize.net.
  • Basic Pardot setup and enablement for marketing team to use to communicate with major donors

Our Results

Arkus and SFDO were in lock step with the Sandy Hook Promise team throughout the entire process, including a lengthy discovery process as there were multiple departments and staff to engage. What started as a small programs to Salesforce project, quickly turned into a full blow, wall-to-wall Salesforce implementation including RE migration for Fundraising, Salsa for Marketing as well as Programs and Policy teams.

Ready to write your own success story? Talk to Arkus or browse more client success stories.