π
Sales Analytics and Reports
Reports, dashboards, and sales performance analytics
β±οΈ Estimated reading time: 15 minutes
Chapter 13: Sales Reports and Dashboards
Report Types
| Type | Use | Charts |
|---|---|---|
| Tabular | Simple data list | β No |
| Summary | Grouped by fields | β Yes |
| Matrix | Grouped by rows AND columns | β Yes |
| Joined | Multiple data blocks | β Yes |
Custom Report Types
Allow creating reports crossing objects:
- Account with Contacts
- Opportunities with Products
- Custom Object with Related Lists
Dashboard Components
| Component | Best use |
|---|---|
| Bar/Column | Compare categories |
| Line | Trends over time |
| Donut/Pie | Percentage distribution |
| Funnel | Sales pipeline |
| Gauge | KPI vs target |
| Metric | Individual number |
| Table | Top/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