Total number of calls made by each user
SQL query for Aircall
Count the total number of calls made by each user in the Calls table.
SELECT Users.user_id, COUNT(Calls.call_id) AS total_calls_made FROM Users LEFT JOIN Calls ON Users.user_id = Calls.user_id GROUP BY Users.user_id
Aircall data model
Calls
Contacts
Users
Calls Summary
Calls Topics
Calls Sentiments
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