Definition
Reporting Snapshot Source Report is an analytics feature in Salesforce that helps users measure, visualize, and understand their business data. It provides tools for building reports, dashboards, or data explorations that turn raw data into actionable insights.
Real-World Example
When a data analyst at MarketPulse needs to streamline operations, they turn to Reporting Snapshot Source Report to uncover trends and patterns hidden in their CRM data. By configuring Reporting Snapshot Source Report, they create visualizations that tell a clear story about business performance. The executive team uses these insights to adjust strategy mid-quarter and the company exceeds its revenue target by 12%.
Why Reporting Snapshot Source Report Matters
The Reporting Snapshot Source Report is the specific Salesforce report whose results get captured each time a snapshot runs. It defines what data is photographed -- which object, which filters, which groupings, and which summary fields provide the values that are mapped to the target object's fields. The source report must be a Tabular or Summary report (Matrix and Joined reports are not supported), and its column structure must align with the target object's field types. Getting the source report right is the most important step in snapshot configuration because every data quality issue in the snapshot traces back to the source report's design.
As snapshot requirements evolve, the source report becomes a living artifact that needs careful change management. Modifying the source report's filters, removing columns, or changing groupings can break the field mapping to the target object or fundamentally alter what data gets captured -- silently corrupting trend data without any error message. Organizations that treat the source report as a shared, general-purpose report run the highest risk of accidental changes. Best practice is to create dedicated source reports used exclusively for snapshots, clearly named and stored in a restricted folder so that casual users do not inadvertently modify them.
How Organizations Use Reporting Snapshot Source Report
- MarketPulse Analytics — MarketPulse creates a dedicated source report named 'SNAPSHOT - Weekly Pipeline by Stage' that lives in a locked folder only admins can access. The report filters for open opportunities grouped by stage with sum of amount. Because it is isolated from user-facing reports, it has never been accidentally modified in two years of operation.
- DataStream Insights — DataStream's snapshot stopped capturing a critical metric when a well-meaning analyst removed a column from the source report while customizing it for a presentation. The field mapping broke silently, and two months of snapshot data was missing the revenue forecast field before anyone noticed. They now use dedicated source reports in restricted folders.
- Vertex Analytics — Vertex uses a Summary source report grouped by Product Family that feeds a weekly snapshot. When they added a new Product Family, the snapshot automatically captured it because the source report dynamically includes all families. This self-maintaining design ensures new data categories are captured without manual intervention.