Zivver Insights report

Insights report

The Zivver Insights report provides in-depth information about Zivver usage in your organization. The exact significance of every possible entry in the report is explained in the table below:

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, etc.)
original_sender_account_id The account identifier of the user that sent the message. If the message was sent through an access delegation (i.e. via a 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_sent_by_delegated_user A boolean indicating 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_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. Either Revoke or Delete, respectively meaning revoking for only recipients or revoking for everyone.
revoke_type The type of revoke. Either Manual or Scheduled, respectively meaning revoking immediately by user action or upon a schedule previously set by the user or the organization’s policy.
submission_method How the message was submitted to Zivver, either via API or via 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 indicating 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 may have been decrypted without having been opened by the recipient, in case they use a Zivver product that automatically decrypts incoming messages.

Zivver message recipients

zivver_message_recipients contains one row per message recipient. One message may have multiple recipients, meaning that one message may 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 (i.e. via a 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 indicating whether the recipient is a guest recipient
is_internal_recipient A boolean indicating 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 indicating whether the message has been decrypted by this recipient. Every opened message must have been decrypted. A message may have been decrypted without having been opened by the recipient, in 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 per 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 (i.e. via a 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 indicating 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 indicating whether the message was sent securely with Zivver or as a normal email
can_client_send_normal_email A boolean indicating 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 indicating whether the user that sent this message is opted in to log normal emails to Zivver
is_logging_normal_email A boolean indicating 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 indicating 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 may 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 indicating whether the message was sent securely with Zivver or as a normal email
can_client_send_normal_email A boolean indicating 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 indicating whether the user that sent this message is opted in to log normal emails to Zivver
is_logging_normal_email A boolean indicating 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 per 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 may have multiple recipients. Each counts once.
message_recipients_with_preferred_verification_method The number of recipients of Zivver messages using one of the recommended verification methods, i.e. not email verification. One Zivver message may have multiple recipients. Each counts once.
percentage_of_message_recipients_with_preferred_verification_method The % of recipients of Zivver messages that are verified using one of the recommended verification methods
revoked_messages The number of messages revoked

Accounts

accounts contains one row per 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 indicating whether the account has been deleted
is_suspended A boolean indicating whether the account has been suspended
is_admin A boolean indicating whether the account is an admin of the Zivver organization

Was this article helpful?

thumb_up thumb_down