Quarterly Executive KPI Report by Segment

How would you approach designing a dashboard or report for executive stakeholders at Gartner to drive strategic decisions?

Using the supplied Gartner account and engagement tables, write a SQL query that produces a quarterly executive KPI report by client segment. Include only completed engagements from 2025 and calculate the requested metrics from the available data.

Output

1. One row per client segment and quarter with completed engagements.
2. Columns: segment, quarter_start, active_clients, completed_engagements, total_revenue, avg_satisfaction, revenue_growth_pct.
3. Sort by segment ascending, then quarter_start ascending. The first quarter for each segment should have a NULL growth percentage.

Output details

• Count active_clients as distinct account IDs with completed engagements in each segment and quarter.
• Count completed_engagements as qualifying engagement rows, and calculate total_revenue as their revenue sum.
• Round avg_satisfaction to two decimal places.
• Calculate revenue_growth_pct against the previous reported quarter's total_revenue for the same segment.
• Return revenue_growth_pct as NULL when previous revenue is NULL or zero, otherwise round it to two decimal places.
• Sort NULL segment values last while retaining ascending segment and quarter ordering.