Hubspot: Email Event Clicks

Description

• Each record represents a CLICK email event.

Supported Data Sources

• HubSpot

Columns

Type	Name	Description
DATETIME	_fivetran_synced	Timestamp of when Fivetran synced a record.
STRING	browser	A JSON object representing the browser which serviced the event. Its comprised of the properties: 'name', 'family', 'producer', 'producer_url', 'type', 'url', 'version'.
STRING	event_id	The ID of the event.
INTEGER	ip_address	The contact's IP address when the event occurred.
STRING	geo_location	A JSON object representing the location where the event occurred. It's comprised of the properties: 'city', 'state', 'country'.
INTEGER	referer_url	The URL of the webpage that linked to the URL clicked. Whether this is provided, and what its value is, is determined by the recipient's email client.
STRING	click_url	The URL within the message that the recipient clicked.
STRING	user_agent	The user agent responsible for the event, e.g. “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.95 Safari/537.36”
DATETIME	created_timestamp	The created timestamp of the event.
INTEGER	email_campaign_id	The ID of the related email campaign.
STRING	recipient_email_address	The email address of the contact related to the event.
DATETIME	email_send_timestamp	The timestamp of the SENT event related to this event.
STRING	email_send_id	The event ID which uniquely identifies the email message's SENT event. If not applicable, this property is omitted.
INTEGER	contact_id	The ID of the related contact.
BOOLEAN	is_contact_deleted	Boolean indicating whether a record has been deleted in Hubspot and/or inferred deleted in Hubspot by Fivetran; _fivetran_deleted and is_deleted fields are equivalent.