Twilio: Message Enhanced

Description

• This model provides additional information of every message sent or received.

Supported Data Sources

• Twilio

Columns

Type	Name	Description
STRING	message_id	The unique identifier for the message.
STRING	messaging_service_id	The unique identifier of the messaging service.
DATETIME	timestamp_sent	The timestamp_sent indicating when the message was sent.
DATE	date_day	The day indicating when the message was sent.
DATE	date_week	The week when the message was sent.
DATE	date_month	The month when the message was sent.
STRING	account_id	The unique identifier of the Account that sent or received the message.
STRING	created_at	The timestamp indicating when the message was created.
STRING	direction	The direction of the message. Can be inbound for incoming messages, outbound-api for messages initiated by a REST API, outbound-call for messages initiated during a call, or outbound-reply for messages initiated in response to an incoming message.
STRING	phone_number	The phone number that sent the message, if the direction was inbound. Or the phone number that received the message, if the direction was outbound.
STRING	body	The text of the message.
INTEGER	num_characters	The number of characters in the message.
INTEGER	num_words	The number of words in the message.
STRING	status	The status of the message. Can be accepted, scheduled, canceled, queued, sending, sent, failed, delivered, undelivered, receiving, received, or read (WhatsApp only).
INTEGER	error_code	The error code associated with the message, if applicable.
INTEGER	error_message	The description of the error_code if your message status is failed or undelivered. If the message was successful, this value is null.
INTEGER	num_media	The number of media (e.g., images, videos) included in the message.
INTEGER	num_segments	The number of segments the message contains. A message body that is too large to be sent in a single SMS message is segmented and charged as multiple messages. Inbound messages over 160 characters are reassembled when the message is received. Note, when using a Messaging Service to send messages, num_segments will always be 0 in Twilio's response to your API request.
DECIMAL	price	The cost of the message.
STRING	price_unit	The currency unit for the message cost.
STRING	updated_at	The timestamp indicating when the message was last updated.
STRING	friendly_name	A human-readable descriptive name for the messaging service.
STRING	inbound_method	The HTTP method Twilio will use to send requests to the inbound request URL of the messaging service.
BOOLEAN	us_app_to_person_registered	Specifies whether to enable or disable routing inbound messages to the messaging service using US App-to-Person (A2P) routing.
BOOLEAN	use_inbound_webhook_on_number	Specifies whether to use inbound webhooks for handling incoming messages to the messaging service.
STRING	use_case	Specifies the intended use case of the messaging service.