Tableau Connector for HubSpot

Build 25.0.9434

EngagementsEmails

Retrieves all email engagement records in HubSpot for analyzing customer email interactions.

SELECT

When selecting Email Engagements, filtering can be applied to columns marked as "Filterable." For these columns, the only supported server-side operator is =. 

SELECT * FROM EngagementsEmails WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42';
SELECT * FROM EngagementsEmails WHERE Archived = TRUE;

INSERT


INSERT INTO EngagementsEmails ([Activity date], [Email Direction], [Attached Video Opened], [Attached Video Watched], [Email send status], [Email subject], [Email body], [UpdatedAt])
VALUES (CURRENT_TIMESTAMP(), 'EMAIL', TRUE, TRUE, 'BOUNCED', 'subject', 'text', CURRENT_TIMESTAMP() )

UPDATE


UPDATE EngagementsEmails SET [Email body] = 'Updated email body', [Email send status] = 'FAILED' WHERE ID = '11896047040'

DELETE


DELETE FROM EngagementsEmails WHERE ID = '11896047040'

Columns

Name Type ReadOnly References Filterable Description
Id [KEY] Long False True

Unique identifier for the email engagement record.

Archived Bool True True

Indicates whether the engagement record has been archived.

CreatedAt Datetime True False

The timestamp when the email engagement was originally created.

UpdatedAt Datetime True False

The timestamp when the email engagement was last updated.

Business units String False False

The business units this email record is associated with.

AtMentioned Owner Ids String False False

User IDs of owners who were mentioned within the body of the email engagement.

Attached file IDs String False False

A list of IDs for files attached to the email.

Body preview String True False

A truncated text-only preview of the email body content.

HTML Body Preview String True False

A truncated preview of the email body in HTML format.

Body Preview Truncated Bool True False

Indicates whether the body preview shown has been truncated.

Activity created by String True False

Identifier of the user who created the email engagement.

Created by user ID Decimal True False

User ID of the creator of this email engagement. Automatically set by HubSpot.

Create date Datetime True False

The timestamp representing when the email engagement was created.

Email direction and unique ID String True False

A combined value of the email's direction and its unique message ID.

Attached Video String False False

The ID of a video file attached to the email, if present.

Attached Video Name String False False

The name of the video file attached to the email, if present.

Attached Video Opened Bool False False

Indicates whether the attached video was opened by the recipient.

Attached Video Watched Bool False False

Indicates whether the attached video was watched by the recipient.

Email BCC Address String True False

Comma-separated email addresses of the BCC recipients.

Email BCC First Name String True False

Comma-separated first names of the BCC recipients.

Email BCC Last Name String True False

Comma-separated last names of the BCC recipients.

Email BCC String True False

Raw header string for BCC recipients from the email metadata.

Email Bounce Error Detail Message String False False

Detailed message explaining why the email bounced, if applicable.

Email Bounce Error Detail Status Code Decimal False False

The SMTP status code corresponding to the bounce error.

Email CC Address String True False

Comma-separated email addresses of the CC recipients.

Email CC First Name String True False

Comma-separated first names of the CC recipients.

Email CC Last Name String True False

Comma-separated last names of the CC recipients.

Email CC String True False

Raw header string for CC recipients from the email metadata.

Email Direction String False False

Direction of the email—indicates whether it was incoming or outgoing.

Encoded Email Associations Request String True False

Encoded string representing association requests for the email engagement.

Error Message String False False

Message detailing any error that occurred during email send processing.

Email Send Id String True False

The unique ID of the email send event as tracked by the system.

Email From Address String True False

The email address that the email was sent from.

Email From First Name String True False

First name of the sender of the email.

Email From Last Name String True False

Last name of the sender of the email.

Email From String True False

Raw header value representing the sender in the original email metadata.

Email Headers String False False

Raw metadata containing sender and recipient header information for the email.

Email body String False False

The body content of the email composed and sent from within HubSpot.

Logged From String False False

Indicates where the email was logged from, such as Gmail, Outlook, or directly within HubSpot.

Media Processing Status String False False

Current processing status of email media content, such as attachments and inline images.

Email is member of forwarded subthread Bool False False

Indicates whether the email belongs to a forwarded subthread conversation.

Message ID String False False

The unique message identifier associated with the email, typically from the email provider.

EmailMigratedViaPortalDataMigration String False False

Indicates if the email was migrated from another HubSpot portal using the DataMigration tool.

Email pending inline image file IDs String False False

IDs of inline image files that are pending processing or upload.

PostSend Status String False False

Status information reflecting the result of the email send event, such as sent, bounced, or dropped.

RecipientDrop Reasons String False False

Reasons why certain email recipients were dropped, listed alongside recipient addresses.

Email Send Event Id String False False

Identifier for the email send event that generated this message.

Email Send Event Id Created Datetime False False

Timestamp of when the email send event ID was created.

Email Sender Address String True False

The address from which the email was sent.

Email Sender First Name String True False

First name of the email sender.

Email Sender Last Name String True False

Last name of the email sender.

Email Sender String True False

Raw header value of the email sender, used for metadata tracking.

Sent Via String False False

The platform or method used to send the email, such as HubSpot, Gmail, or connected integration.

Email send status String False False

Status of the email send event, such as delivered, bounced, or failed.

Email subject String False False

Subject line of the email message.

Text String False False

Plain text version of the email body.

Thread ID String False False

Identifier of the email thread that this message belongs to.

Email To Address String True False

Comma-separated list of email addresses the message was sent to.

Email To First Name String True False

Comma-separated list of first names of the email recipients.

Email To Last Name String True False

Comma-separated list of last names of the email recipients.

Email To String True False

Raw header string for email 'To' recipients.

Tracker Key String False False

Internal tracking key used for logging and analytics of the email.

Validation Skipped String False False

Describes any validation checks that were skipped during email logging.

Engagement Source String False False

The system or workflow that initiated the email engagement.

Engagement Source ID String False False

Identifier of the process or integration that triggered the engagement.

Follow up action String False False

Recommended or defined follow-up action related to the email engagement.

GDPR deleted Bool True False

Indicates whether the email body was cleared in response to a GDPR delete request.

Last modified date Datetime True False

Timestamp of the last modification made to the email engagement record.

Merged object IDs String True False

List of engagement IDs that were merged into this record.

Updated by String True False

User who most recently updated the engagement record.

Record ID Decimal True False

HubSpot-generated unique ID for the email engagement record.

Product name String False False

The name of the product associated with the email, if specified.

Queue Memberships String False False

List of queues that include this email engagement for workflow or routing purposes.

Read Only Object Bool True False

Indicates whether the email engagement record is read-only and cannot be modified.

Activity date Datetime False False

The date the email engagement activity occurred, used for sorting and reporting.

Unique creation key String True False

A unique string used to ensure idempotency when creating this email engagement.

Unique ID String False False

The unique identifier for the email engagement, distinct from the record ID.

Updated by user ID Decimal True False

HubSpot user ID of the person who last updated the record. Set automatically by HubSpot.

User IDs of all notification followers String True False

Comma-separated list of user IDs who opted to follow this record for notifications.

User IDs of all notification unfollowers String True False

Comma-separated list of user IDs who opted out of notifications for this record.

User IDs of all owners String True False

List of user IDs assigned as owners of this engagement.

Owner Assigned Date Datetime True False

Timestamp of the most recent owner assignment for this record. Automatically updated by HubSpot.

Activity assigned to String False False

The user assigned to follow up on this engagement. Can be manually or automatically set.

HubSpot Team String True False

The team name associated with the record owner of this engagement.

All owner ids String True False

All owner property values for this engagement, including custom and default owner fields.

All team ids String True False

Team IDs that correspond to the owner fields of this engagement, both default and custom.

All accessible team ids String True False

All team IDs with access to this engagement, including parent teams in the hierarchy.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434