Zivver Insights
Data export from Zivver Insights
Insights report
The Zivver Insights report provides in-depth information about Zivver usage in your organization.
These tables explain the content of the export that is available on the Insights dashboard.
Zivver messages
zivver_messages contains a row for each Zivver message sent by a user in the organization
| Column | Description |
|---|---|
| zivver_message_id | A unique identifier for the Zivver message |
| conversation_id | A unique identifier for the Zivver conversation that the message appears in |
| sent_at | The date and time at which the message was sent |
| rank_in_conversation | The rank of the message in the conversation (first, second, third, and so on.) |
| original_sender_account_id | The account identifier of the user that sent the message. If the message was sent through an access delegation (functional account), this is the user to which access was delegated. Normally this is NOT the functional account but the user who logged into it. |
| original_sender_organizational_unit_name | The organizational unit of the original sender |
| original_sender_email_domain | The email domain of the original sender |
| is_sent_by_delegated_user | A boolean that indicates whether the message was sent through an access delegation |
| delegated_sender_account_id | The account identifier of the functional account through which the message was sent in case it was sent through an access delegation |
| is_revoked | Whether the message has been revoked |
| revoked_at | When the message was revoked, if applicable |
| revoke_action | What action was taken when revoking the message.
|
| revoke_type | The type of revoke.
|
| submission_method | How the message was submitted to Zivver, through API or our SMTP component |
| zivver_client | Which Zivver client was used to send the message |
| zivver_client_version | What version of the Zivver client was used to send the message |
| total_number_of_attachments | The number of attachments attached to the message |
| total_attachment_size_bytes | The total size of all attachments combined, in bytes |
| total_attachment_size_megabytes | The total size of all attachments combined, in megabytes |
| total_attachment_size_segment | The total size of all attachments combined, divided into discrete segments |
| is_message_to_self | A boolean that indicates whether the message has no recipients other than the sender |
| number_of_recipients | The number of recipients of the message, excluding the sender |
| has_external_recipient | Whether the message had any recipients that are not part of the same organization as the sender, nor on any of its trusted domains |
| is_decrypted_by_any_recipient | Whether the message has been decrypted by at least one recipient. Every opened message must have been decrypted. A message might have been decrypted without having been opened by the recipient. In such case, they use a Zivver product that automatically decrypts incoming messages. |
Zivver message recipients
zivver_message_recipients contains one row for each message recipient. One message can have multiple recipients. That means that one message can correspond to multiple rows in this table.
| Column | Description |
|---|---|
| zivver_message_id | A unique identifier for the Zivver message |
| original_sender_account_id | The account identifier of the user that sent the message. If the message was sent through an access delegation (functional account), this is the user to which access was delegated. Normally this would NOT be the functional account but the user that logged into it. |
| sent_at | The date and time at which the message was sent |
| recipient_account_id | The account identifier of the recipient of the message |
| recipient_account_type | The type of account that the recipient has, either Guest, Personal or Business |
| is_guest_recipient | A boolean that indicates whether the recipient is a guest recipient |
| is_internal_recipient | A boolean that indicates whether the recipient is part of the same organization of the sender, or any of its trusted domains |
| recipient_email_domain | The domain of the recipient |
| verification_method | The verification method used for this recipient |
| is_decrypted | A boolean that indicates whether the message has been decrypted by this recipient. Every opened message must have been decrypted. A message might have been decrypted without having been opened by the recipient. In such case, they use a Zivver product that automatically decrypts incoming messages. |
| decrypted_at | The date and time at which the message was decrypted, if any |
| hours_to_decryption | The number of hours between sending and decryption of the message |
Messages
messages contains a row for each email message. This could be a Zivver message or a non-Zivver message. For non-Zivver messages to appear in this overview, the plug-in setting to log non-Zivver messages must be enabled.
| Column | Description |
|---|---|
| message_id | A unique idenifier for the message |
| sent_at | The date and time at which the message was sent |
| zivver_message_id | A unique identifier for the Zivver message, if the message is a Zivver message |
| original_sender_account_id | The account identifier of the user that sent the message. If the message was sent through an access delegation (functional account), this is the user to which access was delegated. Normally this would NOT be the functional account but the user that logged into it. |
| original_sender_organizational_unit_name | The organizational unit of the original sender |
| original_sender_email_domain | The email domain of the original sender |
| is_delegated | A boolean that indicates whether the message was sent via an access delegation |
| delegated_sender_account_id | The account identifier of the functional account through which the message was sent in case it was sent through an access delegation |
| is_sent_securely | A boolean that indicates whether the message was sent securely with Zivver or as a normal email |
| can_client_send_normal_email | A boolean that indicates whether the client used to send this message can also be used to send normal emails |
| is_opted_in_to_log_normal_email | A boolean that indicates whether the user that sent this message is opted in to log normal emails to Zivver |
| is_logging_normal_email | A boolean that indicates whether both the client also sends normal email AND the sender is opted in to log normal emails to Zivver |
| zivver_client | Which Zivver client was used to send the message |
| zivver_client_version | What version of the Zivver client was used to send the message |
| number_of_attachments | The number of attachments attached to the message |
| is_message_to_self | A boolean that indicates whether the message has no recipients other than the sender |
| number_of_recipients | The number of recipients of the message, excluding the sender |
| has_external_recipient | Whether the message had any recipients that are not part of the same organization as the sender, nor on any of its trusted domains |
| is_rule_triggered | Whether the message has triggered any wordlist or sensitive identifier rules enabled by the organization |
| is_wordlist_rule_triggered | Whether the message has triggered any wordlist rules enabled by the organization |
| is_sensitive_id_rule_triggered | Whether the message has triggered any sensitive identifier rules enabled by the organization |
| number_of_rules_triggereds | The number of triggered wordlist or sensitive identifier rules enabled by the organization |
| number_of_wordlist_rules_triggered | The number of triggered wordlist rules enabled by the organization |
| number_of_sensitive_id_rules_triggered | The number of triggered sensitive identifier rules enabled by the organization |
Message triggered rules
message_triggered_rules contains a row for each rule triggered by a message. Contains only rules enabled by the organization. One message can trigger multiple rules.
| Column | Description |
|---|---|
| message_id | A unique idenifier for the message |
| sent_at | The date and time at which the message was sent |
| zivver_message_id | A unique identifier for the Zivver message, if the message is a Zivver message |
| is_sent_securely | A boolean that indicates whether the message was sent securely with Zivver or as a normal email |
| can_client_send_normal_email | A boolean that indicates whether the client used to send this message can also be used to send normal emails |
| is_opted_in_to_log_normal_email | A boolean that indicates whether the user that sent this message is opted in to log normal emails to Zivver |
| is_logging_normal_email | A boolean that indicates whether both the client also sends normal email AND the sender is opted in to log normal emails to Zivver |
| rule_category | The type of rule, either Sensitive Word List or Sensitive ID |
| rule_identifier | The identifier of the rule triggered, generally the name of the wordlist or identifier |
| violation_level | The violation level set for the triggered business rule, either Suggestion, Warning, or Error |
Sender statistics
sender_statistics contains one row for each account in your organization with key performance metrics over the period selected on the dashboard
| Column | Description |
|---|---|
| original_sender_account_id | The unique identifier of the account |
| email address | The primary email address associated to the account |
| messages_sent_with_zivver, | The number of messages sent with Zivver |
| messages_with_rule_triggered | The number of messages (Zivver or non-Zivver) sent that had at least one rule triggered. Only includes messages where non-Zivver messages were also being logged, to ensure the % sent with Zivver is computed correctly. |
| zivver_messages_with_rule_triggered | The number of Zivver messages sent that had at least one rule triggered. Only includes messages where non-Zivver messages were also being logged, to ensure the % sent with Zivver is computed correctly. |
| percentage_of_messages_with_rule_triggered_sent_with_zivver | The percentage of messages with at least one rule triggered that were sent with Zivver. Only includes messages where non-Zivver messages were also being logged, to ensure the % sent with Zivver is computed correctly. |
| message_recipients | The number of recipients of Zivver messages. One Zivver message can have multiple recipients. Each counts once. |
| message_recipients_with_preferred_verification_method | The number of recipients of Zivver messages who use one of the recommended verification methods. That means not email verification. One Zivver message can have multiple recipients. Each counts once. |
| percentage_of_message_recipients_with_preferred_verification_method | The % of recipients of Zivver messages that are verified with one of the recommended verification methods |
| revoked_messages | The number of messages revoked |
Accounts
accounts contains one row for each account in the organization
| Column | Description |
|---|---|
| account_id | The unique identifier of the account |
| email_address | The primary email address associated to the account |
| is_deleted | A boolean that indicates whether the account has been deleted |
| is_suspended | A boolean that indicates whether the account has been suspended |
| is_admin | A boolean that indicates whether the account is an admin of the Zivver organization |