Average call duration by user role - Gong SQL Query - Peliqan

Average call duration by user role

SQL query for Gong

Calculate the average call duration for each user role.

SELECT u.role, AVG(c.duration) as avg_duration FROM calls c JOIN users u ON c.user_id = u.id GROUP BY u.role

Gong data model

Users

Scorecards

Answered Scorecards

Calls

Ready to get instant access to all your company data ?

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.