Skip to main content

Peliqan

Try for free
Request a demo

Aircall

Total number of calls by topic

SQL query for Aircall

Count the total number of calls for each topic in the calls_topics table.

SELECT topic, COUNT(call_id) AS total_calls FROM calls_topics GROUP BY topic

Try this query now in Aircall

Aircall data model

Aircall
Calls

Aircall
Contacts

Aircall
Users

Aircall
Calls Summary

Aircall
Calls Topics

Aircall
Calls Sentiments

Aircall
Calls Transcription

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