Message Services product

The Message Services product focuses on email and SMS data, offering insights into message performance and user engagement. It is pivotal for optimizing communication strategies and measuring campaign effectiveness.

Some use cases are:

• Enhancing communication strategy with performance insights
• Calculating engagement metrics for emails and SMS

email_click

Tenant column:tenant_id
Description: The table contains data related to messaging events, capturing details such as the tenant, message identifiers, and user interactions. It includes information on the type and category of events, timestamps for when events occurred, and metadata like IP addresses and user agents. This data can be used for analyzing messaging performance, tracking user engagement, and troubleshooting delivery issues.

Column name	Type
tenant_id	STRING
message_id	STRING
email	STRING
event	STRING
type	STRING
category	STRING
event_timestamp	STRING
contact_id	STRING
delivery_id	STRING
ip_address	STRING
url	STRING
user_agent	STRING
link_id	STRING
kafka_timestamp	TIMESTAMP
write_timestamp	TIMESTAMP

email_bounce

Tenant column:tenant_id
Description: The table contains data related to email events, including information about message delivery, bounces, and associated metadata. Use cases include tracking email performance, analyzing bounce reasons, and understanding user engagement through event timestamps. The data can help in optimizing email campaigns and improving communication strategies.

Column name	Type
tenant_id	STRING
message_id	STRING
email	STRING
event	STRING
type	STRING
reason	STRING
bounce_type	STRING
event_timestamp	STRING
contact_id	STRING
delivery_id	STRING
ip_address	STRING
message_class	STRING
send_time	STRING
kafka_timestamp	TIMESTAMP
write_timestamp	TIMESTAMP

message_base

Tenant column:tenant_id
Description: The table contains data related to messaging activities within the system. It includes details such as the message ID, recipient count, and status of each message. This data can be used to analyze messaging performance, track automation activities, and understand the effectiveness of different marketing groups. Additionally, timestamps for various events provide insights into the timing of message sends and their scheduling.

Column name	Type
tenant_id	STRING
message_id	STRING
name	STRING
subject	STRING
automation_definition_id	STRING
automation_activity_definition_id	STRING
content_id	STRING
sendout_id	STRING
marketing_group_id	STRING
is_transactional	BOOLEAN
recipient_count	LONG
status	STRING
created_time	TIMESTAMP
scheduled_send_time	TIMESTAMP
last_scheduled_send_time	TIMESTAMP
payload_timestamp	TIMESTAMP
enqueued_time	TIMESTAMP
message_type	STRING
event_ts	TIMESTAMP