Sales pipeline report in Salesforce: a weekly view of open deals
A sales pipeline report built on Salesforce records, grouped by stage, owner and close date, refreshed on a schedule your team sets.
Updated 2025-12-09
Sales pipeline report with Salesforce
A sales pipeline report gives a sales lead one regular view of every open deal, grouped by stage, value, owner and expected close date. When the deals live in Salesforce, the raw material already exists in opportunities, stage history and activity records, but many teams rebuild the summary by hand before each weekly review, copying figures into a spreadsheet. This build reads the opportunity data your organisation holds in Salesforce and assembles that view automatically, so the owner or team lead opens one page instead of preparing one. Most of the effort goes into agreeing what each stage means, since a report is only as clear as the status values beneath it. It also goes into checking fields such as close dates and amounts, which often drift when entries are rushed. The output keeps the pipeline layout your team already discusses, with weighted value shown beside the raw figure and stalled deals flagged.
How it works
Agree the stage definitions with the team and map each Salesforce opportunity stage to a pipeline stage in the report.
Set up an integration user whose profile and sharing rules limit it to the opportunity, account and activity fields the report needs.
Pull open opportunities through the Salesforce REST API or a scheduled report export, then check that owners, amounts and close dates are filled in.
Calculate totals by stage and by owner, show weighted value beside the raw figure, and flag deals with no activity inside the agreed window.
Publish the summary on the refresh schedule the team chooses, display the time of the last update, and have the owner review flagged deals before the weekly meeting.
Frequently asked questions
- What does a sales pipeline report read from Salesforce?
- It reads opportunity records, including stage, amount, owner and expected close date, along with account details and logged activity that shows when a deal was last touched. The exact objects and fields depend on how your organisation has set up Salesforce, so the list is confirmed before any build starts. The first version only reads from Salesforce and does not change any records.
- Is a sales pipeline report safe with Salesforce data?
- Access runs through a dedicated integration user, and its profile and sharing rules decide what the report can see. Records that user cannot open are left out of the totals, which makes the permission check the first thing to review. Credentials are kept in the hosting environment rather than in the report, and the permissions are checked with your administrator before the first run.
- What happens if Salesforce changes?
- Salesforce releases updates on its own schedule, and changes to field names, API versions or licensing can affect the feed. The stage map and field list are written down, so a break can be traced to the step it affects. Comparing the report totals with a standard Salesforce report now and then is a simple way to spot drift early.
- Who owns a sales pipeline report built around Salesforce?
- The business owns the finished report and its settings. A named person on the team should own the stage definitions and the integration user, and approve any change to either. Anyone who renames a stage or moves a field in Salesforce should tell that person first, because the report depends on both. Handover notes list each field and stage so the owner can check them without help.
- How does a sales pipeline report hand work to a person in Salesforce?
- Salesforce stays the system of record, so the report hands work back to people rather than acting on records. A deal that has stalled or lacks a close date appears in a flagged list, and the owner decides what to do in Salesforce, such as updating the opportunity, logging a call or moving the stage. The report never closes or reassigns a deal on its own.
Related
read these nextUp a level
More with Salesforce
- CRM data entry automation for Salesforce
- Customer churn report for Salesforce
- Email to ticket integration for Salesforce
- Lead routing automation for Salesforce
- 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
