Top performing reps by call duration - Gong SQL Query - Peliqan

Top performing reps by call duration

SQL query for Gong

Find the top performing reps based on total call duration.

SELECT u.name, SUM(c.duration) as total_duration FROM calls c JOIN users u ON c.user_id = u.id GROUP BY u.name ORDER BY total_duration DESC LIMIT 10

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.