1

Hubspot – campaign performance

Question

Measure your campaigns performance with email events

Sources

Hubspot (see full visual schema here)

Results

Query

select
campaigns.name campaign,
email_events.type event,
count(distinct email_events.id) count
from hubspot.email_events email_events
join hubspot.email_campaigns campaigns
 on email_events.email_campaign_id = campaigns.id
group by campaigns.name, email_events.type
order by campaign, count desc