Active users
SQL query for SaySimple
Get the list of active users who have sent messages in the last 7 days.
SELECT user_id FROM users WHERE user_id IN (SELECT DISTINCT sender_id FROM messaging_chats WHERE created_at >= NOW() – INTERVAL ‘7 days’);
SaySimple data model
Channels
Tags
Contacts
Labels
Users
Messaging Chats
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