Average number of contacts per list
SQL query for Brevo
Calculate the average number of contacts per list.
SELECT AVG(contact_count) FROM (SELECT list_id, COUNT(*) AS contact_count FROM contacts GROUP BY list_id) AS contact_counts
Brevo data model
Lists
Folders
Sms Campaigns
Whatsapp Campaigns
Email Campaigns
Contacts
Attributes
Campaign Statistics
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