Skip to main content

Peliqan

Try for free
Request a demo

Gong

Average scorecard completion rate

SQL query for Gong

Calculate the average completion rate of scorecards.

SELECT AVG(completed_scorecards / total_scorecards) * 100 as avg_completion_rate FROM (SELECT user_id, COUNT(DISTINCT scorecard_id) as total_scorecards, COUNT(DISTINCT CASE WHEN completed_at IS NOT NULL THEN scorecard_id END) as completed_scorecards FROM answered_scorecards GROUP BY user_id) as subquery

Try this query now in Gong

Gong data model

Gong
Users

Gong
Scorecards

Gong
Answered Scorecards

Gong
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.

  • 14-day free trial
  • No credit card needed