Customer churn report for Salesforce
Build a customer churn report from Salesforce accounts, opportunities and service cases, with lapsed clients listed for the team to review each month.
Updated 2026-05-18
Customer churn report with Salesforce
Many small and mid-sized businesses keep their account history in Salesforce, which makes it a natural place to look for customers who are drifting away. Opportunities that were never renewed, service cases that have gone quiet and accounts with no logged activity all carry signals about churn. The difficulty is that these signals sit in different objects and different reports, so they are rarely read together. A churn report for Salesforce brings them into one view. It counts accounts that have had no activity or open opportunity over a window the owner chooses, and it lists them alongside the case volume and stage history that came before. The output is a plain summary for the team lead, who can decide which accounts deserve a call. The build reads from Salesforce's own records, so the report reflects what the team has actually logged, and it is only as complete as those records are.
How it works
Export accounts, opportunities and service cases from Salesforce as reports or list views, giving the build a dated snapshot to start from.
Agree with the owner what counts as a lapse, such as a set period with no logged activity or open opportunity.
Connect to the Salesforce REST API using an integration user whose permissions cover only the objects the report needs.
Alternatively, use Zapier, Make or Power Automate, which provide prebuilt Salesforce actions for pulling record data on a schedule.
Build the lapse list and monthly summary in the reporting tool the team already uses, keeping each Salesforce record ID so staff can open the account directly.
Review the first few reports with the owner to confirm that closed and paused accounts are handled the way the team expects.
Frequently asked questions
- Can a customer churn report work with Salesforce?
- Yes. Salesforce holds accounts, opportunities and service cases, which are the records a churn report needs. The build reads those records through the Salesforce REST API, using an integration user whose permissions cover the objects involved. Where a team prefers not to write code, an automation platform such as Zapier, Make or Power Automate can pull the same records. Either way, the report depends on consistent logging inside Salesforce.
- What does a customer churn report write to Salesforce?
- By default, nothing. The report reads account, opportunity and case records and produces a summary for the team lead. If the owner later wants reason tags saved against accounts, that becomes a separate write step with its own permissions and an audit trail. Writes should be limited to the named fields, so the integration user never touches records it has no reason to change.
- What does a customer churn report with Salesforce need from me?
- Access to the Salesforce org, along with an integration user and a decision on who should own that user and its permissions. You will also need to agree what counts as an active account, such as a set period with no logged activity or open opportunity. Lapse flags are only as reliable as the activity logged against each account. Finally, name one person to review the flagged accounts each month.
- What does a customer churn report not do with Salesforce?
- It does not explain why a client left. Salesforce records show activity and stage changes, but a reason usually lives in a conversation, which the report cannot read unless someone logs it. It also does not change account owners, close opportunities or send messages to clients. The report can surface a lapse, while the decision about what to do remains with the team.
- Which tools sit between a customer churn report and Salesforce?
- The main options are the Salesforce REST API, a custom script or service that calls it, and automation platforms such as Zapier, Make and Power Automate, which offer prebuilt Salesforce actions. Reports and list views can also be exported to spreadsheet files, which gives Power BI or Airtable a snapshot to display. The choice depends on how often the data should refresh and how much the team wants to maintain.
Related
read these nextUp a level
More with Salesforce
- CRM data entry automation for Salesforce
- Email to ticket integration for Salesforce
- Lead routing automation for Salesforce
- Sales pipeline report in Salesforce: a weekly view of open deals
- Sales research assistant for Salesforce
- AI adoption for Salesforce businesses: training your team on the CRM you already own
- AI strategy for Salesforce teams
- Custom development for Salesforce businesses
- Salesforce product idea: shaping a first version from your own records
- Workflow automation for Salesforce
