Average sentiment score per user
SQL query for Aircall
Calculate the average sentiment score for each user in the calls_sentiments table.
SELECT user_id, AVG(sentiment_score) AS avg_sentiment_score FROM calls_sentiments GROUP BY 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