πŸ“Š

Sales Analytics and Reports

Reports, dashboards, and sales performance analytics

⏱️ Estimated reading time: 15 minutes

Chapter 13: Sales Reports and Dashboards

Report Types



TypeUseCharts
TabularSimple data list❌ No
SummaryGrouped by fieldsβœ… Yes
MatrixGrouped by rows AND columnsβœ… Yes
JoinedMultiple data blocksβœ… Yes

Custom Report Types



Allow creating reports crossing objects:
- Account with Contacts
- Opportunities with Products
- Custom Object with Related Lists

Dashboard Components



ComponentBest use
Bar/ColumnCompare categories
LineTrends over time
Donut/PiePercentage distribution
FunnelSales pipeline
GaugeKPI vs target
MetricIndividual number
TableTop/Bottom N records

Dynamic Dashboards


- Dashboard shows data based on who views it
- 'Run as: Logged-in User'
- Each user sees only their own data (respects sharing)
- Vs 'Run as: Specific User' (everyone sees same data)

Collaborative Forecasting Reports


- Forecast by Owner
- Forecast by Territory
- Forecast vs Quota
- Adjustments by Manager

🎯 Key Points

  • βœ“ 4 types: Tabular, Summary, Matrix, Joined
  • βœ“ Only Summary and Matrix support charts
  • βœ“ Dynamic Dashboards show data based on viewer
  • βœ“ Funnel chart = visualize sales pipeline
  • βœ“ Custom Report Types cross related objects