Number of campaigns per channel - Brevo SQL Query - Peliqan

Number of campaigns per channel

SQL query for Brevo

Count the number of campaigns for each channel (WhatsApp, Email, SMS).

SELECT channel, COUNT(*) FROM (SELECT ‘whatsapp’ AS channel FROM whatsapp_campaigns UNION ALL SELECT ’email’ AS channel FROM email_campaigns UNION ALL SELECT ‘sms’ AS channel FROM sms_campaigns) AS all_channels GROUP BY channel

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.