Average messages per user
SQL query for Whatsapp
Calculate the average number of messages sent per user.
SELECT AVG(message_count) FROM (SELECT phone_number, COUNT(*) AS message_count FROM Messages GROUP BY phone_number) AS message_counts
Whatsapp data model
Phonenumbers
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