Analytics full events export
Edited

Overview

The Full events export is one of two export types when you export an Analytics view. The exported file contains one line for each activity that occurred and its corresponding details for the selected date range.

All timestamps in the file are formatted as YYYY-MM-DD HH:mm:ss, in the requested user's time zone. Information provided reflects the conversation segment data at the time the export was generated.


Exported events

Full events exports include the following activities:

  1. Inbound

  2. Outbound

  3. Outbound reply (outbound message that is a reply)

  4. Archive / Reopen

  5. Reminder

  6. Trash / Restore

  7. Assign / Unassign

  8. Tag / Untag

  9. Move

  10. Comment

  11. Mention

  12. Snooze


Exported fields

  1. Activity ID*: Internal Front ID of the activity.

  2. Type: Describes what activity occurred (see list above).

  3. Source: Where is the activity coming from.

  4. Message ID*: Internal Front ID of the message.

  5. Conversation ID*: Internal Front ID of the conversation.

  6. Segment: Segment of the conversation.

  7. Segment start: The date and time of the first activity for any new segment.

  8. Segment end:

    • If segment is currently open: The date and time the segment is expected to close (moved to inactive state). This date can change if additional activities are added to the segment.

    • If segment is closed: The date and time the segment closed.

  9. DirectionInbound or Outbound.

  10. Status: Current status of the conversation: Archived or Open.

  11. Status at activity time: Status of the conversation immediately after the activity was recorded. If a conversation was originally Open and the activity is Archived, the status at activity time would read Archived.

  12. Inbox: Name of the inbox where the message currently lives. If the message appeared in multiple inboxes, the activity will appear one time for each inbox value.

  13. Inbox API ID: External Front ID of the inbox.

  14. Inbox at activity time: List of inboxes where the message lived immediately after the activity was recorded. If the message appeared in multiple inboxes, the activity will appear one time for each inbox value. If the activity represents a move from one inbox to another, the ending inbox is recorded.

  15. Inbox API IDs at activity time: External Front IDs for the list of inboxes where the message lived immediately after the activity was recorded.

  16. Previous inbox IDs: External Front IDs for the list of inboxes where the message lived prior to when the activity was recorded.

  17. Message date: Represents the date of an activity, not only messages. The date range filter is tied to this field. Formatted as YYYY-MM-DD HH:mm:ss, in the requested user's time zone.

  18. Autoreply: Indicates whether this message is an automated reply, 1 is yes, 0 is no

  19. Reaction time: Time (in seconds) taken to assign/reassign an inbound message to another teammate (not to self), send a reply, or archive

  20. Total reply time: Duration (in seconds) that a contact was kept waiting for a reply from the team during a conversation segment.

  21. Handle time: Duration (in seconds) between starting a draft in a conversation and sending a reply.

  22. Response time: Duration (in seconds) between an inbound message and the next outbound message in the same conversation. Corresponds to Reply time in analytics reports.

  23. Stage resolution time: Average time (in seconds) from the start of a conversation segment to the last resolution. Data is only available for conversations in inboxes with conversation stages enabled.

  24. Replies to resolution: Average number of outbound replies for resolved conversation segments. Data is only available for conversations in inboxes with conversation stages enabled.

  25. Attributed to: Username of the teammate involved, or for inbounds, the teammate that responded to or archived the message. Note that in case of assignments made by rules, the field is left blank.

  26. Assignee: Username of the teammate who was the assignee for this conversation.

  27. Author: Username of the teammate who replied to the email.

  28. Contact name: Contact's first & last name.

  29. Contact handle: Contact's email address, twitter handle, or phone number (depending on the source of the message).

  30. Account names: Account the contact is linked to.

  31. To: Email address of the recipient.

  32. CC: Email address of those CC'ed on the email.

  33. BCC: Email address of those BCC'ed on the email.

  34. Extract: Sample of the message body (200 character limit).

  35. Tags: Tags currently attached to the conversation.

  36. Tag API IDs: External Front IDs of the tags attached to the conversation.

  37. Tags at activity time: Tags attached to the conversation at the time the activity was recorded.

  38. Tag API IDs at activity time: External Front IDs for the tags attached to the conversation at the time the activity was recorded.

  39. Tag application duration: How long a tag was applied to a conversation before being untagged.

  40. Activity API ID: External Front ID of the activity.

  41. Message API ID: External Front ID of the message.

  42. Comment API ID: External Front ID of the comment.

  43. Conversation API ID: External Front ID of the conversation.

  44. Message original ID: Message-id as defined in the email headers of a message (email only).

  45. New conversation: Indicates whether this event is the first of a new conversation or segment, 1 is yes, 0 is no.

  46. First response: Indicates whether this message is the first reply to a new inbound conversation or segment, 1 is yes, 0 is no.

  47. Business hours: Indicates whether the message occurred within business hours, 1 is yes, 0 is no.

  48. Subject: Subject of the conversation.

  49. Account name: Account linked to the contact who provided the CSAT rating.

  50. Survey rating: The CSAT rating selected by the contact.

  51. Survey comment: The CSAT comment provided by the contact.

  52. Segment closed†: Indicates whether the segment is currently closed, 1 is yes, 0 is no.

  53. Segment contains messages†: Indicates whether the segment currently contains messages, 1 is yes, 0 is no.

  54. Last segment activity†: Date and time of the latest activity recorded on this segment.

  55. Added tag: Name of the tag added by the Tag event

  56. Added tag API ID: External Front ID for the tag added by the Tag event

  57. Removed tag: Name of the tag removed by the Untag event

  58. Removed tag API ID: External Front ID for the tag removed by the Untag event

*These columns in the export may be phased out in the future, as they are the Front analytics system's internal identifiers and should pose no impact to customers.

† Data is not available for conversation segments closed prior to Jan 19, 2023.


Pricing

Analytics are available on the Growth plan or above. Some legacy plans may also allow access to this feature.