Active users in the last month
SQL query for Whatsapp
Count the number of unique phone numbers that have been active in the last month.
SELECT COUNT(DISTINCT phone_number) FROM Phonenumbers WHERE last_activity_date >= DATE_SUB(NOW(), INTERVAL 1 MONTH)
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