# Twilio: Message Enhanced

## Description

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

## Supported Data Sources

* <img src="https://fivetran.com/integrations/twilio/resources/twilio.svg" alt="" data-size="line"> 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.                                                                                                                                                                                                                                                                                                                          |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/twilio-message-enhanced.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
