See related
No related articles
Data export of Conversation standard attributes
Last Update: Oct 2024 • Est. Read Time: 8 MINTo check plan availability, see the pricing page.
The reference table below lists the display names, system names, data type, and descriptions for the Conversation standard Klass attributes available in the Kustomer platform. Specifically the attributes available for use in Data Exports.
Note: You can also pull in Customer standard attributes on the Conversation data export.
This table shows the available standard attributes for the Conversation object when running a scheduled or one time data export.
| Display name | System name | Data type | Description |
| ID | id | String | ID associated with this conversation. |
| Subject | subject | String | Conversation subject. |
| External ID | externalId | String | If a conversation was imported or linked to a conversation in an external system, this is the ID of that item in that system. |
| Name | name | String | Conversation name. |
| Preview | preview | String | Preview of the body content for the first message of this conversation. |
| Queue Name | queue.name | String | Queue to which this conversation is assigned. |
| Channels | channels | Array | Channel of the last conversation of this customer. |
| Status | status | String | Current status of this conversation - can be "open', "snoozed", or "done". |
| Snooze Time | snooze.time | Date | Time the snooze will elapse. |
| Snooze Status | snooze.status | String | Status of the snooze - can be "scheduled", "elapsed", or "canceled" |
| Snooze Status At | snooze.statusAt | Date | Date/time the snooze status was applied to this conversation. |
| Message Count | messageCount | Number | Number of messages contained in this conversation. |
| Note Count | noteCount | Number | Number of notes contained in this conversation. |
| Satisfaction | satisfaction | Number | Satisfaction score for this survey. |
| Satisfaction Score | satisfactionLevel.score | Number | Normalized, binary negative/positive (0/1) score for this survey. |
| Satisfaction Rating | satisfactionLevel.rating | Number | Normalized 1-5 rating for this survey. |
| Satisfaction Channel | satisfactionLevel.channel | String | Channel from which the Satisfaction survey was triggered. |
| Satisfaction Created At | satisfactionLevel.createdAt | Date | Date-time when the conversation met the criteria to schedule a Satisfaction survey. |
| Satisfaction Updated At | satisfactionLevel.updatedAt | Date | Date-time this Satisfaction survey was last updated. |
| Satisfaction Sent By | satisfactionLevel.sentBy | String | ID of the user assigned to the conversation when it met the criteria to schedule a Satisfaction survey. |
| Satisfaction Sent By Name | satisfactionLevel.sentBy.name | String | Name of the user assigned to the conversation when it met the criteria to schedule a Satisfaction survey. |
| Satisfaction Sent By Team | satisfactionLevel.sentByTeams | String | ID(s) of the teams of the user assigned to the conversation when it met the criteria to schedule a Satisfaction survey. |
| Satisfaction Sent By Team Name | satisfactionLevel.sentByTeams.name | String | Name(s) of the teams of the user assigned to the conversation when it met the criteria to schedule a Satisfaction survey. |
| Satisfaction Form | satisfactionLevel.form | String | ID of template used in this Satisfaction survey. |
| Satisfaction Form Name | satisfactionLevel.form.name | String | Name of template used in this Satisfaction survey. |
| Satisfaction Scheduled For | satisfactionLevel.scheduledFor | Date | Date-time when this Satisfaction survey is scheduled to be sent to the customer. |
| Satisfaction First Answer | satisfactionLevel.firstAnswer | String | Customer response to the follow-up question on this Satisfaction survey. |
| Satisfaction Answer | satisfactionLevel.answers.answerRaw | String | Raw text of the answer supplied in your follow-up Satisfaction questions when the question type is "Free text" or "Check all that apply" |
| Satisfaction Selections | satisfactionLevel.answers.selectionsRaw | String | Raw text of the answer supplied in your follow-up Satisfaction questions when the question type is "Multiple choice" |
| Satisfaction Status | satisfactionLevel.status | String | Current status of this Satisfaction survey. |
| Satisfaction Form Response | satisfactionLevel.formResponse | String | ID of the response to the satisfaction form |
| Satisfactions Answers Selections | satisfactionLevel.answers.selections | String | Selections of the answers in the response to the satisfaction form. |
| Satisfaction Answers Answer | satisfactionLevel.answers.answer | String | Answers in the response to the satisfaction form |
| Created At | createdAt | Date | Date/time at which this customer was added to your Kustomer instance. |
| Created By | createdBy | String | ID of the user that created the customer associated with this conversation. |
| Updated At | updatedAt | Date | Date/time the customer associated with this conversation's recent location was last updated. |
| Modified At | modifiedAt | Date | Date/time the customer associated with this conversation was last modified (changed by a user). |
| Last Activity At | lastActivityAt | Date | Date/time the conversation last had activity. |
| Deleted | deleted | Boolean | Boolean value of whether or not the customer associated with this conversation has been deleted. |
| Deleted At | deletedAt | Date | Date/time when the customer associated with this conversation was deleted. |
| Imported At | importedAt | Date | Date/time when the customer associated with this conversation was imported from an external system. |
| Tags | tags.name | String | Tag(s) applied to the last conversation of this customer. |
| Sentiment Polarity | sentiment.polarity | Number | Polarity of the sentiment for the last inbound message for the customer associated with this conversation (-1 for unhappy, negative, +1 for postive, happy). |
| Sentiment Confidence | sentiment.confidence | Number | Confidence of the sentiment rating applied to the last inbound message of the customer associated with this conversation (0 for unsure, 100 for positive). |
| SLA Name | sla.name | String | Name of the service level aggreement matched to the conversation. |
| SLA First Response Satisfied At | sla.metrics.firstResponse.satisfiedAt | Date | Date/time the service level agreement for first response was satisfied at. |
| SLA First Response Breach At | sla.metrics.firstResponse.breachAt | Date | Date/time the service level agreement for first response was breached at. |
| SLA Longest Unresponded Message Satisfied At | sla.metrics.longestUnrespondedMessage.satisfiedAt | Date | Date/time the service level agreement for longest unresponded message was satisfied at. |
| SLA Longest Unresponded Message Breach At | sla.metrics.longestUnrespondedMessage.breachAt | Date | Date/time the service level agreement for longest unresponded message was breached at. |
| SLA Total Conversation Open Time Satisfied At | sla.metrics.totalConversationOpenTime.satisfiedAt | Date | Date/time the service level agreement for total conversation open time was satisfied at. |
| SLA Total Conversation Open Time Breach At | sla.metrics.totalConversationOpenTime.breachAt | Date | Date/time the service level agreement for total conversation open time was breached at. |
| SLA Total Customer Wait Time Satisfied At | sla.metrics.totalCustomerWaitTime.satisfiedAt | Date | Date/time the service level agreement for total customer wait time was satisfied at. |
| SLA Total Customer Wait Time Breach At | sla.metrics.totalCustomerWaitTime.breachAt | Date | Date/time the service level agreement for total customer wait time was breached at. |
| SLA Total Customer Wait Time Remaining Time | sla.metrics.totalCustomerWaitTime.remainingTime | Number | Remaining time in SLA Total Customer Wait Time policy in milliseconds. If a user replies and leaves the conversation "Open" or "Snoozed", when the conversation reopens we'll use this value to create a new totalCustomerWaitTime.breachAt entry. |
| SLA Breached | sla.breached | Boolean | Was the service level agreement breached or not? |
| SLA Status | sla.status | String | Current status of the service level agreement. |
| SLA First Breach At | sla.summary.firstBreachAt | Date | Date/time the service level agreement first breached at. |
| SLA Satisfied At | sla.summary.satisfiedAt | Date | Date/time the service level agreement was satisfied at. |
| SLA Matched At | sla.matchedAt | Date | TDate/time the service level agreement was matched at. |
| First Message In ID | firstMessageIn.id | String | ID of the first inbound message on this conversation. |
| First Message In Preview | firstMessageIn.id.preview | String | Preview of the first inbound message sent to this conversation. |
| First Message In Sent At | firstMessageIn.sentAt | Date | Date/time of the first inbound message on this conversation. |
| First Message In Created At | firstMessageIn.createdAt | Date | Date/time the first inbound message on this conversation was created. |
| First Message In Channel | firstMessageIn.channel | String | Channel of the first inbound message on this conversation. |
| First Message In Direction Type | firstMessageIn.directionType | String | First inbound message direction "type". |
| Last Message In ID | lastMessageIn.id | String | ID of the last inbound message on this conversation. |
| Last Message In Sent At | lastMessageIn.sentAt | Date | Date/time of the last inbound message on this customer associated with this conversation. |
| Last Message Out ID | lastMessageOut.id | String | ID of the last outbound message on this conversation. |
| Last Message Out Sent At | lastMessageOut.sentAt | Date | Date/time of the last outbound message on this customer associated with this conversation. |
| Last Message At ID | lastMessageAt.id | String | ID of the last message, inbound or outbound, on this conversation. |
| Last Message At Sent At | lastMessageAt.sentAt | Date | Date/time of the last message, inbound or outbound, on this conversation. |
| Last Message Unresponded To ID | lastMessageUnrespondedTo.id | String | ID of the earliest inbound message on this conversation that has not been followed with an outbound message response. |
| Last Message Unresponded To Sent At | lastMessageUnrespondedTo.sentAt | Date | Date/time of the last inbound message on this conversation that is still awaiting a response. |
| Assigned User | assignedUsers.name | String | Name of the user currently assigned to this conversation. |
| Assigned Team | assignedTeams.name | String | Name of the team(s) currently assigned to this conversation. |
| First Response ID | firstResponse.id | String | ID of the message that was the first response for this conversation. |
| First Response Time | firstResponse.time | Number | Time in milliseconds from when the conversation was created to when the conversation was first responded to - including the time outside of business hours. See "business hours" for more information. |
| First Response Business Time | firstResponse.businessTime | Number | Time in milliseconds from when the conversation was created to when the conversation was first responded to - excluding the time outside of business hours. See "business hours" for more information. |
| First Response Created At | firstResponse.createdAt | Date | Date/time the first response to this conversation was created. |
| First Response Created By | firstResponse.createdBy.name | String | Name of the user that first responded to this conversation. |
| First Response Created By Teams | firstResponse.createdByTeams | String | Name of the user that first responded to this conversation. |
| First Response Assigned Teams Name | firstResponse.assignedTeams.name | String | Assigned team names of the user assigned to the conversation's first outbound message. |
| First Response Assigned User's Name | firstResponse.assignedUsers.name | String | Assigned user of the conversation at the time of sending the first outbound message. |
| First Response Sent At | firstResponse.sentAt | Date | Date/time of this conversation's first outbound response. |
| First Response Time | firstResponse.responseTime | Number | Time milliseconds between the first inbound message from a customer and the first outbound message from a user. |
| Last Response ID | lastResponse.id | String | ID of the message that was the last response for this converastion. |
| Last Response Time | lastResponse.time | Number | Time milliseconds between the last inbound message from teh customer and the last outbound message from a user. |
| Last Response Business Time | lastResponse.businessTime | String | Time milliseconds between the last outbound message and the earliest, unresponded to inbound message from a customer - including the time outside of business hours. |
| Last Response Created At | lastResponse.createdAt | Date | Date/time the last response to this conversation was created. |
| Last Response Created By Name | lastResponse.createdBy.name | String | Name of the user that last responded to this conversation. |
| Last Response Created By Team | lastResponse.createdByTeams | String | ID(s) of the assigned team(s) of the user who last responded to this conversation. |
| Last Response Created By Team Name | lastResponse.createdByTeams.name | String | Assigned team names of the user assigned to the conversation's last outbound message. |
| Last Response Assigned Team | lastResponse.assignedTeams.name | String | Assigned team names of the user assigned to the conversation's last outbound message. |
| Last Response Assigned User | lastResponse.assignedUsers.name | String | Assigned user of the conversation at the time of sending the last outbound message. |
| First Done Time | firstDone.time | Number | ime in milliseconds from when the conversation was created to when the conversation was first marked done - including the time outside of business hours. |
| First Done Business Time | firstDone.businessTime | Number | Time in milliseconds from when the conversation was created to when the conversation was first marked done - excluding the time outside of business hours. |
| First Done Created At | firstDone.createdAt | Date | The date/time this conversation was first marked done. |
| First Done Created By Name | firstDone.createdBy.name | String | Name of the user that first marked this conversation done. |
| First Done Created By Team | firstDone.createdByTeams | String | ID(s) of the assigned team(s) of the user who first marked this conversation done. |
| First Done Assigned Team | firstDone.assignedTeams.name | String | Assigned team names of the user assigned to the conversation at the moment it was first marked done. |
| First Done Assigned User | firstDone.assignedUsers.name | String | Assigned user of the conversation at the moment it was first marked done. |
| First Done Note Count | firstDone.noteCount | Number | Number of notes in the conversation at the moment it was first marked done. |
| First Done Message Count | firstDone.messageCount | Number | Number of messages in the conversation at the moment it was first marked done. |
| First Done Message Count Channel | firstDone.messageCountByChannel | Array | Number of messages in the conversation segmented by channel at the moment it was first marked done. |
| First Done Outbound Message Count | firstDone.outboundMessageCount | Number | Number of outbound messages in the conversation at the moment it was first marked done. |
| First Done Outbound Message Count by Channel | firstDone.outboundMessageCountByChannel | Array | Number of outbound messages in the conversation segmented by channel at the moment it was first marked done. |
| First Done Last Message Direction | firstDone.lastMessageDirection | String | Last message direction at the time the conversation was first marked done (can either be "in" or "out"). |
| First Done Last Message Direction Type | firstDone.lastMessageDirectionType | String | Last message direction at the time the conversation was first marked done (can either be "in" or "out"). |
| Last Done Time | lastDone.time | Number | Time in milliseconds from when the conversation was created to when the conversation was last marked done - including the time outside of business hours. See "business hours" for more information. |
| Last Done Business Time | lastDone.businessTime | Number | Time in milliseconds from when the conversation was created to when the conversation was last marked done - excluding the time outside of business hours. See "business hours" for more information. |
| Last Done Created At | lastDone.createdAt | Date | Date/time this conversation was last marked done. |
| Last Done Created By | lastDone.createdBy.name | String | Name of the user that last marked this conversation done. |
| Last Done Created By Teams | lastDone.createdByTeams | String | ID(s) of the assigned team(s) of the user who last marked this conversation done. |
| Last Done Assigned Teams | lastDone.assignedTeams.name | String | Assigned team names of the user assigned to the conversation at the moment it was last marked done. |
| Last Done Assigned User | lastDone.assignedUsers.name | String | Assigned user of the conversation at the moment it was last marked done. |
| Last Done Note Count | lastDone.noteCount | Number | Number of notes in the conversation at the moment it was last marked done. |
| Last Done Message Count | lastDone.messageCount | Number | Number of messages in the conversation at the moment it was marked done. |
| Last Done Message Count By Channel | lastDone.messageCountByChannel | Array | Number of messages in the conversation segmented by channel at the moment it was marked done. |
| Last Done Outbound Message Count | lastDone.messageCountByChannel | Number | Number of outbound messages in the conversation at the moment it was marked done. |
| Last Done Outbound Message Count By Channel | lastDone.messageCountByChannel | Array | Number of outbound messages in the conversation segmented by channel at the moment it was marked done. |
| Last Done Last Message Direction | lastDone.lastMessageDirection | String | Last message direction at the time the conversation was marked done (can either be "in" or "out"). |
| Last Done Last Message Direction Type | lastDone.lastMessageDirectionType | String | Last message direction "type" at the time the conversation was marked done. |
| Done Count | doneCount | Number | Number of times the conversation has been marked "done". |
| Snooze Count | snoozeCount | Number | Number of times the conversation has been marked "snoozed". |
| Reopen Count | reopenCount | Number | Number of times the conversation has been marked "open" after being marked "done" or "snoozed". |
| Direction | direction | String | Conversation's direction - can be either "in" or "out". |
| Last Message Direction | lastMessageDirection | String | Last message direction at the time the conversation was first marked done (can either be "in" or "out"). |
| Outbound Message Count | outboundMessageCount | Number | Number of outbound messages in the conversation at the moment it was first marked done. |
| Rev | rev | Number | Number of updates made to this conversation. |
| Priority | priority | Number | Priority value assigned to the conversation - see conversation priority for more information. |
| Merged | mergedTarget | Boolean | Was the conversation merged with another conversation. |
| Brand Id | brand.id | String | ID associated with the brand. |
| Brand Name | brand.name | String | Name of the brand associated with the conversation. |