Skip to Content

Turning Manual Reporting into Automated Insights

Replacing manual group and subscriber calculations with consistent, automated monthly statistics


This project focused on improving how a membership-based nonprofit tracks the size and composition of its network. The goal was to eliminate recurring manual calculations, establish reliable month-end group statistics, and incorporate subscriber counts into an automated reporting process.

1

Examine the Reporting Process 

  • Reviewed the reports, case records, and calculations used to produce monthly group totals
  • Identified limitations in reconstructing accurate figures through manual calculations
  • Clarified the group categories and additional subscriber statistics the organization needed to track
2

Refine the Data Structure 

  • Established distinct metrics for group types and subscriber categories
  • Designed a monthly snapshot record to preserve calculated totals as historical data
  • Retained legacy reporting fields while introducing a clearer structure for current metrics
3

Automate and Distribute 

  • Implemented scheduled Salesforce automation to calculate group and subscriber statistics
  • Configured monthly snapshots to be captured shortly after midnight on the first day of each month
  • Automated email distribution so designated recipients receive the statistics without manual preparation

Refine


Challenge

A membership-based nonprofit needed dependable monthly statistics about the groups and subscribers in its network. While Salesforce contained much of the necessary information, producing accurate group totals required a recurring process of gathering records and calculating the figures manually.


Determining how many groups belonged in each category at the end of a month wasn't as simple as running a single report. The process involved consulting multiple reports, reviewing case records, and performing calculations to arrive at reasonably accurate figures.


Several aspects of the process made it cumbersome:


  • Group totals had to be reconstructed from multiple sources rather than captured automatically
  • Manual calculations introduced opportunities for errors and inconsistencies
  • Preparing the statistics was a recurring interruption that had to be remembered and completed each month
  • The organization also needed to begin tracking subscriber counts alongside its established group statistics


The challenge was to make these recurring measurements more dependable without requiring someone to assemble the figures by hand each month.


Insight

The key to improving the process was establishing a consistent record of group and subscriber totals at a specific point in time.


Salesforce maintained the records necessary to calculate those figures, but the manual process depended on interpreting current information and reconstructing the previous month's totals. Once another month had passed and records continued to change, those earlier figures were not necessarily straightforward to reproduce.


A better approach was to calculate the required statistics at a scheduled time and preserve the results in a dedicated monthly record.


Salesforce offers a standard Reporting Snapshots feature for preserving historical report data, but the organization's requirements went beyond capturing the results of a single report. Multiple calculations needed to be brought together into one monthly record, with the completed statistics distributed automatically. A custom solution would provide greater control over how those figures were calculated, stored, and delivered.


Solution

A monthly snapshot system was designed and implemented within Salesforce using a custom Snapshot Metric object, Apex to calculate the statistics, and Salesforce Flow to coordinate snapshot creation and email distribution. A scheduled Flow runs the process automatically each month, while an on-demand option allows authorized staff to generate a snapshot manually when needed.


The system tracks several distinct categories of groups along with corresponding totals. It also captures subscriber counts for members and designated contact categories.


The solution includes:


  • Defined calculations: Group and subscriber totals are calculated from Salesforce records using established criteria for each metric
  • Historical snapshots: A dedicated Snapshot Metric record stores the calculated figures for each reporting period
  • Scheduled automation: The process runs shortly after midnight on the first day of each month, capturing the previous month's closing statistics
  • Historical continuity: Legacy fields are retained separately from the current metrics to preserve previously recorded information
  • Automatic distribution: The monthly statistics are emailed to designated recipients without requiring someone to prepare and send them manually


The design separates the ongoing operational records from the historical statistics used for reporting. Rather than relying on the current state of Salesforce records to reconstruct an earlier month, each completed snapshot provides a record of the figures calculated for that reporting period.


Result

The automated monthly snapshot system is now in production, replacing the manual preparation of group and subscriber statistics with a consistent, scheduled process.


  • Group and subscriber totals are calculated automatically each month
  • Results are recorded at a consistent point in the reporting cycle
  • Historical snapshots are preserved for reference and comparison
  • The risk of manual calculation errors has been eliminated from the monthly statistics preparation process
  • Designated recipients receive the statistics automatically by email


These monthly statistics no longer require someone to run reports, reconcile figures, or assemble and distribute the results. The entire process happens automatically, from calculation through delivery.


View More Case Studies