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

Gong data model

Table Users

Table Scorecards

Table Answered Scorecards

Table Calls

Magical SQL for Gong with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.