Hubspot email campaigns

Email campagins with detailed delivery statistics

Use case

Marketing

Apps

Hubspot

Created by

Canvas

Each record is Marketo campaign.

Model columns

Column	Description
campaign_id	ID of the campaign.
campaign_name	Name of the campaign.
campaign_type	Type of campaign, either 'batch' or 'trigger'.
created_timestamp	Timestamp when the campaign was created.
description	Description of the campaign
is_active	Whether the campaign is active. Only applicable to trigger campaigns.
program_id	ID of the parent program, if applicable.
program_name	Name of the parent program, if applicable.
updated_timestamp	Timestamp when the campaign was most recently updated.
workspace_name	Name of the parent workspace, if applicable.
count_sends	Count of total sends from related email sends.
count_opens	Count of total opens from related email sends.
count_bounces	Count of total bounces from related email sends.
count_clicks	Count of total clicks from related email sends.
count_deliveries	Count of total deliveries from related email sends.
count_unsubscribes	Count of total unsubscribes from related email sends.
count_unique_opens	Count of unique opens from related email sends.
count_unique_clicks	Count of unique clicks from related email sends.
open_rates_by_sends	Unique email opened divided by total email sent.
click_rates_by_sends	Unique email clicked divided by total email sent.
open_rates_by_deliveries	Unique email opened divided by total email deliveries.
click_rates_by_deliveries	Unique email clicked divided by total email deliveries.