Export your data
Learn how to export your reporting data to CSV.Articles
Export raw reporting data
Exporting your reporting data to CSV will give you quick access to customer and conversation details for one-off analysis. You can export this data one time or schedule the export to be sent out via email at scheduled times. With the CSV Export you can:Export up to 30 days of data to multiple users.Choose the object you want to export. Define the object attributes you want to export as columns in the CSV.Arrange your attributes in the order you'd like them to appear in your CSV.Note: This feature is designed for one-off or recurring data exports up to a daily frequency. We recommend using our real-time events stream if you’d like to continually export your Kustomer data to an external system, such as Redshift. Please contact us if you’re interested in this feature.Who can access this feature?User typesManagers can export a CSV.In this articleAdd a new exportChoose how often your export runsSelect your data attributesOrder your data and execute your exportManage your exportsAdd a new exportYou can create data exports to help you perform an analysis on your customer data outside of the Kustomer platform.Go to Reportingand then select Data Exports.Select Add Export.Add a name and enter the email addresses of everyone receiving the email containing the link to download the export. You can add up to 50 recipients.Optionally, enter a message.Select whether to export the data once or schedule a recurring export.Choose the data you want to export.Select Save.The recipients will receive an email from Kustomer with your message and a direct link to download the CSV.Choose how often your export runsYou can choose to run your Export Now or Schedule Recurring Export. If you choose to schedule a recurring export, you also have to set how often the export will be sent to your recipients, along with the date of when the export will stop being shared. You can schedule an export to send Daily, Weekly, or Monthly.Note: You can schedule up to 50 exports.The Data Date Range section is where you can specify the date range of the data included in any export. The default value is the current day, and you can export up to the last 30 days worth of data. The default value is EST. These values differ based on the type of export you are running:Export frequencyData date range Current DayPast 30 MinutesPast 60 MinutesPast 24 HoursPast 7 DaysPast 30 daysExport NowXXXXXXSchedule Recurring ExportXXXYou can also specify the time zone for the date range. The dates and timezone you select here are applied to when the object was created. For example, if you select June 1, 2020 - June 10, 2020 EST, the Conversation object type exports will reference and export conversations that were created (createdAt) between 12:00:00AM EST June 1, 2019 and 11:59:59PM EST June 10, 2019.Select your data attributesYou can export data from one of the following objects:Conversation standard attributesConversation Views (Handle Time) standard attributesCustomer standard attributesMessage standard attributesNote standard attributesAfter choosing the object type, select Add Attributes to see a list of properties you can choose to export related to that specific item. In the example below, selecting Conversation from the Object Type drop-down menu lists all of the available conversation attributes. You can export up to 25 attributes. The names in the list are the API names given to the conversation attributes. Where possible, we've also included the Display Name (the label of this field in the UI) as well as Sample Data (an example of how exported data for this attribute should appear) to make it easier for you to pick the correct attribute. For more information about the different attributes available for each item, see our API documentation.Once you select the attributes you want to export, select Save.Order your data and execute your exportAfter selecting the attributes you want to export, you'll see them listed on the Create Data Export page. These values will be your column headers; you can re-order them by dragging and dropping them to your desired location.Now that your export is fully configured, you can either Save & Export (run now) or Save as Draft (store all of your attributes to run at a later date). Once you choose to Save & Export you’ll have to briefly wait for the data to be compiled and emailed to you. This time will depend on how much data you have, so if you have a large support organization, try exporting a single day of data to understand processing times better. Manage your exportsThe Manage Data Exports section of the page allows you to manage both your scheduled and one-time exports.Here, you can view exports that are actively running, in a draft state, paused, or completed. The Drafts tab lists any exports you previously configured yet never run and is where you can execute them. You can also select the menu icon for each export to view additional actions you can take. These actions will differ based on the export's current status. The available actions are:Current statusAvailable actionScheduled ExportsOne-time ExportsActive/RunningEdit, Duplicate, Pause, Deleten/aDraftsEdit, Duplicate, Reactivate, DeleteEdit, Duplicate, Run Now, DeletePaused/CompleteDuplicate, DeleteDuplicateData export of Conversation standard attributes
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 nameSystem nameData typeDescriptionIDidStringID associated with this conversation.SubjectsubjectStringConversation subject.External IDexternalIdStringIf a conversation was imported or linked to a conversation in an external system, this is the ID of that item in that system.NamenameStringConversation name.PreviewpreviewStringPreview of the body content for the first message of this conversation.Queue Namequeue.nameStringQueue to which this conversation is assigned.ChannelschannelsArrayChannel of the last conversation of this customer.StatusstatusStringCurrent status of this conversation - can be "open', "snoozed", or "done".Snooze Timesnooze.timeDateTime the snooze will elapse.Snooze Statussnooze.statusStringStatus of the snooze - can be "scheduled", "elapsed", or "canceled" Snooze Status Atsnooze.statusAtDateDate/time the snooze status was applied to this conversation.Message CountmessageCountNumberNumber of messages contained in this conversation.Note CountnoteCountNumberNumber of notes contained in this conversation.SatisfactionsatisfactionNumberSatisfaction score for this survey.Satisfaction ScoresatisfactionLevel.scoreNumberNormalized, binary negative/positive (0/1) score for this survey.Satisfaction RatingsatisfactionLevel.ratingNumberNormalized 1-5 rating for this survey.Satisfaction ChannelsatisfactionLevel.channelStringChannel from which the Satisfaction survey was triggered.Satisfaction Created AtsatisfactionLevel.createdAtDateDate-time when the conversation met the criteria to schedule a Satisfaction survey.Satisfaction Updated AtsatisfactionLevel.updatedAtDateDate-time this Satisfaction survey was last updated.Satisfaction Sent BysatisfactionLevel.sentByStringID of the user assigned to the conversation when it met the criteria to schedule a Satisfaction survey.Satisfaction Sent By NamesatisfactionLevel.sentBy.nameStringName of the user assigned to the conversation when it met the criteria to schedule a Satisfaction survey.Satisfaction Sent By TeamsatisfactionLevel.sentByTeamsStringID(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 NamesatisfactionLevel.sentByTeams.nameStringName(s) of the teams of the user assigned to the conversation when it met the criteria to schedule a Satisfaction survey.Satisfaction FormsatisfactionLevel.formStringID of template used in this Satisfaction survey.Satisfaction Form NamesatisfactionLevel.form.nameStringName of template used in this Satisfaction survey.Satisfaction Scheduled ForsatisfactionLevel.scheduledForDateDate-time when this Satisfaction survey is scheduled to be sent to the customer.Satisfaction First AnswersatisfactionLevel.firstAnswerStringCustomer response to the follow-up question on this Satisfaction survey.Satisfaction AnswersatisfactionLevel.answers.answerRawStringRaw text of the answer supplied in your follow-up Satisfaction questions when the question type is "Free text" or "Check all that apply"Satisfaction SelectionssatisfactionLevel.answers.selectionsRawStringRaw text of the answer supplied in your follow-up Satisfaction questions when the question type is "Multiple choice"Satisfaction StatussatisfactionLevel.statusStringCurrent status of this Satisfaction survey.Satisfaction Form ResponsesatisfactionLevel.formResponseStringID of the response to the satisfaction formSatisfactions Answers SelectionssatisfactionLevel.answers.selectionsStringSelections of the answers in the response to the satisfaction form.Satisfaction Answers AnswersatisfactionLevel.answers.answerStringAnswers in the response to the satisfaction formCreated AtcreatedAtDateDate/time at which this customer was added to your Kustomer instance.Created BycreatedByStringID of the user that created the customer associated with this conversation.Updated AtupdatedAtDateDate/time the customer associated with this conversation's recent location was last updated.Modified AtmodifiedAtDateDate/time the customer associated with this conversation was last modified (changed by a user).Last Activity AtlastActivityAtDateDate/time the conversation last had activity.DeleteddeletedBooleanBoolean value of whether or not the customer associated with this conversation has been deleted.Deleted AtdeletedAtDateDate/time when the customer associated with this conversation was deleted.Imported AtimportedAtDateDate/time when the customer associated with this conversation was imported from an external system.Tagstags.nameStringTag(s) applied to the last conversation of this customer.Sentiment Polaritysentiment.polarityNumberPolarity of the sentiment for the last inbound message for the customer associated with this conversation (-1 for unhappy, negative, +1 for postive, happy).Sentiment Confidencesentiment.confidenceNumberConfidence of the sentiment rating applied to the last inbound message of the customer associated with this conversation (0 for unsure, 100 for positive).SLA Namesla.nameStringName of the service level aggreement matched to the conversation.SLA First Response Satisfied Atsla.metrics.firstResponse.satisfiedAtDateDate/time the service level agreement for first response was satisfied at.SLA First Response Breach Atsla.metrics.firstResponse.breachAtDateDate/time the service level agreement for first response was breached at.SLA Longest Unresponded Message Satisfied Atsla.metrics.longestUnrespondedMessage.satisfiedAtDateDate/time the service level agreement for longest unresponded message was satisfied at.SLA Longest Unresponded Message Breach Atsla.metrics.longestUnrespondedMessage.breachAtDateDate/time the service level agreement for longest unresponded message was breached at.SLA Total Conversation Open Time Satisfied Atsla.metrics.totalConversationOpenTime.satisfiedAtDateDate/time the service level agreement for total conversation open time was satisfied at.SLA Total Conversation Open Time Breach Atsla.metrics.totalConversationOpenTime.breachAtDateDate/time the service level agreement for total conversation open time was breached at.SLA Total Customer Wait Time Satisfied Atsla.metrics.totalCustomerWaitTime.satisfiedAtDateDate/time the service level agreement for total customer wait time was satisfied at. SLA Total Customer Wait Time Breach Atsla.metrics.totalCustomerWaitTime.breachAtDateDate/time the service level agreement for total customer wait time was breached at.SLA Total Customer Wait Time Remaining Timesla.metrics.totalCustomerWaitTime.remainingTimeNumberRemaining 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 Breachedsla.breachedBooleanWas the service level agreement breached or not?SLA Statussla.statusStringCurrent status of the service level agreement.SLA First Breach Atsla.summary.firstBreachAtDateDate/time the service level agreement first breached at. SLA Satisfied Atsla.summary.satisfiedAtDateDate/time the service level agreement was satisfied at.SLA Matched Atsla.matchedAtDateTDate/time the service level agreement was matched at.First Message In IDfirstMessageIn.idStringID of the first inbound message on this conversation.First Message In PreviewfirstMessageIn.id.previewStringPreview of the first inbound message sent to this conversation.First Message In Sent AtfirstMessageIn.sentAtDateDate/time of the first inbound message on this conversation.First Message In Created AtfirstMessageIn.createdAtDateDate/time the first inbound message on this conversation was created.First Message In ChannelfirstMessageIn.channelStringChannel of the first inbound message on this conversation.First Message In Direction TypefirstMessageIn.directionTypeStringFirst inbound message direction "type".Last Message In IDlastMessageIn.idStringID of the last inbound message on this conversation.Last Message In Sent AtlastMessageIn.sentAtDateDate/time of the last inbound message on this customer associated with this conversation.Last Message Out IDlastMessageOut.idStringID of the last outbound message on this conversation.Last Message Out Sent AtlastMessageOut.sentAtDateDate/time of the last outbound message on this customer associated with this conversation.Last Message At IDlastMessageAt.idStringID of the last message, inbound or outbound, on this conversation.Last Message At Sent AtlastMessageAt.sentAtDateDate/time of the last message, inbound or outbound, on this conversation.Last Message Unresponded To IDlastMessageUnrespondedTo.idStringID of the earliest inbound message on this conversation that has not been followed with an outbound message response.Last Message Unresponded To Sent AtlastMessageUnrespondedTo.sentAtDateDate/time of the last inbound message on this conversation that is still awaiting a response.Assigned User assignedUsers.nameStringName of the user currently assigned to this conversation.Assigned TeamassignedTeams.nameStringName of the team(s) currently assigned to this conversation.First Response IDfirstResponse.idStringID of the message that was the first response for this conversation.First Response TimefirstResponse.timeNumberTime 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 TimefirstResponse.businessTimeNumberTime 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 AtfirstResponse.createdAtDateDate/time the first response to this conversation was created.First Response Created ByfirstResponse.createdBy.nameStringName of the user that first responded to this conversation.First Response Created By TeamsfirstResponse.createdByTeamsStringName of the user that first responded to this conversation.First Response Assigned Teams NamefirstResponse.assignedTeams.nameStringAssigned team names of the user assigned to the conversation's first outbound message.First Response Assigned User's NamefirstResponse.assignedUsers.nameStringAssigned user of the conversation at the time of sending the first outbound message.First Response Sent AtfirstResponse.sentAtDateDate/time of this conversation's first outbound response.First Response TimefirstResponse.responseTimeNumberTime milliseconds between the first inbound message from a customer and the first outbound message from a user.Last Response IDlastResponse.idStringID of the message that was the last response for this converastion.Last Response TimelastResponse.timeNumberTime milliseconds between the last inbound message from teh customer and the last outbound message from a user.Last Response Business TimelastResponse.businessTimeStringTime 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 AtlastResponse.createdAtDateDate/time the last response to this conversation was created.Last Response Created By NamelastResponse.createdBy.nameStringName of the user that last responded to this conversation.Last Response Created By TeamlastResponse.createdByTeamsStringID(s) of the assigned team(s) of the user who last responded to this conversation.Last Response Created By Team NamelastResponse.createdByTeams.nameStringAssigned team names of the user assigned to the conversation's last outbound message.Last Response Assigned TeamlastResponse.assignedTeams.nameStringAssigned team names of the user assigned to the conversation's last outbound message.Last Response Assigned UserlastResponse.assignedUsers.nameStringAssigned user of the conversation at the time of sending the last outbound message.First Done TimefirstDone.timeNumberime 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 TimefirstDone.businessTimeNumberTime 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 AtfirstDone.createdAtDateThe date/time this conversation was first marked done.First Done Created By NamefirstDone.createdBy.nameStringName of the user that first marked this conversation done.First Done Created By Team firstDone.createdByTeamsStringID(s) of the assigned team(s) of the user who first marked this conversation done.First Done Assigned Team firstDone.assignedTeams.nameStringAssigned team names of the user assigned to the conversation at the moment it was first marked done.First Done Assigned User firstDone.assignedUsers.nameStringAssigned user of the conversation at the moment it was first marked done.First Done Note CountfirstDone.noteCountNumberNumber of notes in the conversation at the moment it was first marked done.First Done Message CountfirstDone.messageCountNumberNumber of messages in the conversation at the moment it was first marked done.First Done Message Count ChannelfirstDone.messageCountByChannelArrayNumber of messages in the conversation segmented by channel at the moment it was first marked done.First Done Outbound Message CountfirstDone.outboundMessageCountNumberNumber of outbound messages in the conversation at the moment it was first marked done.First Done Outbound Message Count by ChannelfirstDone.outboundMessageCountByChannelArrayNumber of outbound messages in the conversation segmented by channel at the moment it was first marked done.First Done Last Message DirectionfirstDone.lastMessageDirectionStringLast message direction at the time the conversation was first marked done (can either be "in" or "out").First Done Last Message Direction TypefirstDone.lastMessageDirectionTypeStringLast message direction at the time the conversation was first marked done (can either be "in" or "out").Last Done TimelastDone.timeNumberTime 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 TimelastDone.businessTimeNumberTime 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 AtlastDone.createdAtDateDate/time this conversation was last marked done.Last Done Created BylastDone.createdBy.nameStringName of the user that last marked this conversation done.Last Done Created By TeamslastDone.createdByTeamsStringID(s) of the assigned team(s) of the user who last marked this conversation done.Last Done Assigned TeamslastDone.assignedTeams.nameStringAssigned team names of the user assigned to the conversation at the moment it was last marked done.Last Done Assigned UserlastDone.assignedUsers.nameStringAssigned user of the conversation at the moment it was last marked done.Last Done Note CountlastDone.noteCountNumberNumber of notes in the conversation at the moment it was last marked done.Last Done Message CountlastDone.messageCountNumberNumber of messages in the conversation at the moment it was marked done.Last Done Message Count By ChannellastDone.messageCountByChannelArrayNumber of messages in the conversation segmented by channel at the moment it was marked done.Last Done Outbound Message CountlastDone.messageCountByChannelNumberNumber of outbound messages in the conversation at the moment it was marked done.Last Done Outbound Message Count By ChannellastDone.messageCountByChannelArrayNumber of outbound messages in the conversation segmented by channel at the moment it was marked done.Last Done Last Message DirectionlastDone.lastMessageDirectionStringLast message direction at the time the conversation was marked done (can either be "in" or "out").Last Done Last Message Direction TypelastDone.lastMessageDirectionTypeStringLast message direction "type" at the time the conversation was marked done.Done CountdoneCountNumberNumber of times the conversation has been marked "done".Snooze CountsnoozeCountNumberNumber of times the conversation has been marked "snoozed".Reopen CountreopenCountNumberNumber of times the conversation has been marked "open" after being marked "done" or "snoozed".DirectiondirectionStringConversation's direction - can be either "in" or "out".Last Message DirectionlastMessageDirectionStringLast message direction at the time the conversation was first marked done (can either be "in" or "out").Outbound Message CountoutboundMessageCountNumberNumber of outbound messages in the conversation at the moment it was first marked done.RevrevNumberNumber of updates made to this conversation.PrioritypriorityNumberPriority value assigned to the conversation - see conversation priority for more information.Merged mergedTargetBooleanWas the conversation merged with another conversation.Brand Idbrand.idStringID associated with the brand.Brand Namebrand.nameStringName of the brand associated with the conversation.Data export of Conversation Views (Handle Time) standard attributes
The reference table below lists the display names, system names, data type, and descriptions for the Conversation View (Handle Time) standard Klass attributes available in the Kustomer platform. These are the attributes available for use in Data Exports.This table shows the available standard attributes for the Conversation object when running a scheduled or one time data export, specifically when tracking handle time.Display nameSystem nameData typeDescriptionConversation IDconversation.idStringID associated with this conversation.Conversation Nameconversation.nameStringConversation name.Conversation Created Atconversation.createdAtDateDate/time this conversation view event was created. View events are created at the conclusion of a view session.Conversation Created Byconversation.createdByStringID of the user that created the customer associated with this conversation.Conversation Updated Atconversation.updatedAtDateDate/time the customer associated with this conversation's recent location was last updated.Conversation Updated Byconversation.updatedByStringID of the user that updated the customer associated with this conversation.CustomercustomerStringID of the customer associated with this conversation.Customer Display namecustomer.displayNameStringName of the customer associated with this conversation.Created AtcreatedAtDateDate/time at which this conversation view event was created.Created BycreatedByStringID of the user who created this view session.Created By NamecreatedBy.nameStringName of the user who created this conversation view event.Created By TeamscreatedByTeamsStringID(s) of the assigned team(s) of the user who created this conversation view event.Created By Teams NamecreatedByTeams.nameStringName of the team that created this conversation view event.Assigned UsersassignedUsersStringName(s) of the user(s) assigned to this conversation view event.Assigned Users NameassignedUsers.nameStringName of the user currently assigned to this conversation.Assigned TeamsassignedTeamsStringID('s) of the team(s) assigned to this conversation.Assigned Teams NameassignedTeams.nameStringName of the team(s) currently assigned to this conversation.Message AtmessageAtDateDate/time the message was added to this conversation.Message TimemessageTimeNumberTotal time in seconds the reply editor is open on this conversation.Handle AthandleAtDateTime the user began viewing this conversation.Handle TimehandleTimeNumberCombined time in seconds of all view events on this conversation.ChannelschannelsArrayChannel or channels of communication for this conversation. If omni-channel, ordering should follow the order in which the channel was used.Data export of Customer standard attributes
The reference table below lists the display names, system names, data type, and descriptions for the Customer standard Klass attributes available in the Kustomer platform. Specifically the attributes available for use in Data Exports.This table shows the available standard attributes for the Customer object when running a scheduled or one time data export.Display nameSystem nameData typeDescriptionIDidStringID associated with this customer.NamenameStringName associated with this customer.Display NamedisplayNameStringDisplay name associated with this customer.Display ColordisplayColorStringSystem-generated color given to a customer whose name has not been added by a user or inferred from conversation data.Display IcondisplayIconStringSystem-generated name given to a customer whose name has not been added by a user or inferred from conversation data.External IDexternalIDStringID of this customer in an external application, if applicable.External IDsexternalIdsStringArray of ID's of this customer in an external application, if applicable.First NamefirstNameStringFirst name of a customer.Last NamelastNameStringLast name of a customer.Shared External IDssharedExternalIdsStringID of this customer in an external application, if applicable, that is shared with another customer.Signed Up AtsignedUpAtDateDate and time this customer signed up at.Avatar URLavatarUrlStringURL for the avatar image of this customer.UsernameusernameStringExternal username this customer uses for an organization.Emailsemails.emailStringEmail address(es) of a customer.Shared EmailssharedEmails.emailStringEmail address(es) of this customer that is shared with another customer.Phonesphones.phoneNumberPhone number(s) of a customer.Shared PhonessharedPhones.phoneNumberPhone number(s) of this customer that is shared with another customer.Facebook IDs NamefacebookIds.nameStringFacebook handle of this customer.Socialssocials.usernameStringSocial media handle of this customer.Shared SocialssharedSocials.usernameStringSocial media handle of this customer that is shared with another customer.Websitesurls.urlStringWebsite associated with a customer.Locations Typelocations.typeStringType of the location for this customer. Can be 'home', 'work', or 'other'.Locations Namelocations.nameStringName of the location for this customer.Locations Addresslocations.addressStringPrimary full address information for this customer.Locations Address 2locations.address2StringSecondary full address information for this customer.Locations Address 3locations.address3StringTertiary full address information for this customer.Locations Latitudelocations.latitudeNumberLatitude coordinate for this customer.Locations Longitudelocations.longitudeNumberLongitude coordinate for this customer.Locations Country Codelocations.countryCodeNumberCountry code for this customer.Locations Country Namelocations.countryNameStringCountry name for this customer.Locations Region Codelocations.regionCodeStringRegion code for this customer.Locations Region Namelocations.regionNameStringRegion naMe for this customer.Locations City Namelocations.cityNameStringThe city name of the primary address for this customer.Locations Zip Codelocations.zipCodeNumberZip code of the primary address for this customer.Locations Area Codelocations.areaCodeNumberArea code of the primary address for this customer.Active Users EmailactiveUsers.emailStringEmail address of the active users for this customer. Watchers Emailwatchers.emailStringEmail address of the user that is following this customer. Recent Location TyperecentLocation.location.typeStringType for this customer's most recent location. Can be 'home', 'work', or 'other'.Recent Location NamerecentLocation.location.nameStringName of this customer's most recent location.Recent Location AddressrecentLocation.location.addressStringPrimary full address of this customer's most recent location.Recent Location Address 2recentLocation.location.address2StringSecondary full address of this customer's most recent location. Recent Location Address 3recentLocation.location.address3StringTertiary full address of this customer's most recent location.Recent Location LatituderecentLocation.location.latitudeNumberLatitude coordinate of this customer's most recent location.Recent Location LongituderecentLocation.location.longitudeNumberLongitude coordinate of this customer's most recent location.Recent Location Country CoderecentLocation.location.countryCodeNumberCountry code of this customer's most recent location.Recent Location Country NamerecentLocation.location.countryNameStringCountry name of this customer's most recent location.Recent Location Region CoderecentLocation.location.regionCodeStringThe region code of this customer's most recent location.Recent Location Region NamerecentLocation.location.regionNameStringRegion name of this customer's most recent location.Recent Location City NamerecentLocation.location.cityNameStringCity name of this customer's most recent location.Recent Location Zip CoderecentLocation.location.zipCodeNumberZip code of this customer's most recent location.Recent Location Area CoderecentLocation.location.areaCodeNumberArea code of the customer's most recent location.Recent Location Updated AtrecentLocation.updatedAtDateDate/time this customer's recent location was last updated.LocalelocaleStringLocation derived, default language associated with this customer.Time ZonetimezoneStringTimezone associated with this customer.BirthdaybirthdayAtDateBirthday associated with this customer.GendergenderStringGender associated with this customer.PresencepresenceStringCreated AtcreatedAtDateTDate/time this customer was created.Created BycreatedByStringThe name of the user that created this customer.Updated AtupdatedAtDateDate/time this customer's recent location was last updated.Modified AtmodifiedAtDateDate/time this customer was last modified (changed by a user).Last Seen AtlastSeenAtDateLast Activity AtlastActivityAtDateDate/time this customer last had activity.Last Customer ActivitylastCustomerActivityAtDateDeleteddeletedBooleanBoolean value of whether a customer has been deleted.Deleted At deletedAtDateDate/time when the customer was deleted.Imported AtimportedAtDateDate/time when the customer was imported from another system.Last Message In ChannellastMessageIn.channelStringChannel of the last inbound message on this customer.Last Message In Sent AtlastMessageIn.sentAtDateDate/time of the last inbound message on this customer.Companycompany.idStringCompany ID of the customer's companyCompany Namecompany.nameStringName of the customer's companyLast Message In Sentiment PolaritylastMessageIn.sentiment.polarityNumberPolarity of the sentiment of the last inbound message (-1 for unhappy, negative, +1 for postive, happy).Last Message In Sentiment ConfidencelastMessageIn.sentiment.confidenceNumberConfidence of the sentiment rating applied to the last inbound message (0 for unsure, 100 for positive).Last Message Out Sent AtlastMessageOut.sentAtDateDate/time of the last outbound message on this customer.Last Message Unresponded To Sent AtlastMessageUnrespondedTo.sentAtDateDate/time of the last inbound message on this customer that is still awaiting a response.Last Message Unresponded To ChannellastMessageUnrespondedTo.channelStringChannel of the last inbound message on this customer that is still awaiting a response.Last Message AtlastMessageAtDateDate/time of the last message on this customer.Last Conversation IDlastConversation.idStringID of the last conversation associated with this customer.Last Conversation ChannelslastConversation.channelsStringChannel of the last conversation with this customer.Last Conversation Tags NamelastConversation.tags.nameStringTag(s) associated with the last conversation with this customer.Last Conversation Sentiment PolaritylastConversation.sentiment.polarityNumberPolarity of the sentiment of the last entire conversation (-1 for unhappy, negative, +1 for positive, happy).Last Conversation Sentiment ConfidencelastConversation.sentiment.confidenceNumberConfidence of the sentiment rating applied to the last conversation with this customer (0 for unsure, 100 for positive).Conversation Counts AllconversationCounts.allNumberTotal count of all conversations for this customer.Conversation Counts DoneconversationCounts.doneNumberTotal count of all conversations in the "done" status for this customer.Conversation Counts OpenconversationCounts.openNumberTotal count of all conversations in the "open" status for this customer.Conversation Counts SnoozedconversationCounts.snoozedNumberTotal count of all conversations in the "snoozed" status for this customer.Preview IDpreview.idStringPreview Channelpreview.channelStringPreview Subjectpreview.subjectStringPreview Textpreview.textStringPreview Typepreview.typeStringTags Nametags.nameStringTag(s) associated with the last conversation with this customer.Sentiment Polaritysentiment.polarityNumberPolarity of the sentiment of the last inbound message (-1 for unhappy, negative, +1 for positive, happy).Sentiment Confidencesentiment.confidenceNumberConfidence of the sentiment rating applied to the last inbound message (0 for unsure, 100 for positive).Progressive StatusprogressiveStatusStringVerifiedverifiedBooleanHas this customer been verified.RevrevNumberNumber of updates made to this customer.Whatsapp Phonewhatsapps.phoneStringWhatsapp number associated with this customer.Data export of Message standard attributes
The reference table below lists the display names, system names, data type, and descriptions for the Message standard Klass attributes available in the Kustomer platform. Specifically the attributes available for use in Data Exports.This table shows the available standard attributes for the Message object when running a scheduled or one time data export.Display nameSystem nameData typeDescriptionIDidStringID associated with this message the Kustomer application.External IDexternal.idStringThird party application ID for this message if applicable.ChannelchannelStringChannel of this message.AppappStringApplication origin of this message (chat, Gmail, form).SizesizeNumberNumber of characters in this message.DirectiondirectionStringMessage direction (can either be "in" or "out").Direction TypedirectionTypeStringSpecific message direction "type".Location Typelocation.typeStringType of the location for this message.Location Namelocation.nameStringName of the location for this message.Location Addresslocation.addressStringPrimary full address information for this message.Location Address 2location.address2StringSecondary full address information for this message.Location Address 3location.address3StringTertiary full address information for this message.Location Latitudelocation.latitudeNumberLatitude coordinate for this message.Location Longitudelocation.longitudeNumberLongitude coordinate for this message.Location Country Codelocation.countryCodeNumberCountry code for this message.Location Country Namelocation.countryNameStringCountry name for this message.Location Region Codelocation.regionCodeNumberRegion code for this message.Location Region Namelocation.regionNameStringRegion name for this message.Location City Namelocation.cityNameStringCity name of the primary address for this message.Location Zip Codelocation.zipCodeNumberZip code of the primary address for this message.Location Area Codelocation.areaCodeNumberArea code of the primary address for this message.PreviewpreviewStringPreview of the body content for this message.SubjectsubjectStringSubject line, or initial body content of this message.Sentiment Polaritysentiment.polarityNumberPolarity of the sentiment for this message (-1 for unhappy, negative, +1 for positive, happy).Sentiment Confidencesentiment.confidenceStringConfidence of the sentiment rating applied to this message (0 for unsure, 100 for positive).MetametaStringArray of meta-data associated with this message.StatusstatusStringCurrent status of this message.Response TimeresponseTimeNumberTime in milliseconds from when this message was created to when this message was first responded to - including the time outside business hours. See "business hours" for more information.Response Business TimeresponseBusinessTimeNumberTime in milliseconds from when this message was created to when this message was first responded to - excluding the time outside business hours. See "business hours" for more information.Assigned Teams NameassignedTeams.nameStringName of the team(s) assigned to the conversation this message is a part of.Assigned Users NameassignedUsers.nameStringName of the user(s) assigned to the conversation this message is a part of.ErrorerrorStringArray of error details associate with this message.Error AterrorAtDateDate/time this message experienced an error.Sent AtsentAtDateDate/time this message was sent.Created AtcreatedAtDateDate/time this message was created.Created BycreatedByStringID of the user that created this message.Updated AtupdatedAtDateDate/time this message was last updated.Modified AtmodifiedAtDateDate/time this message was last modified (changed by a user).DeleteddeletedBooleanBoolean value of whether this message has been deleted.Deleted AtdeletedAtDateDate/time when the message was deleted.Imported AtimportedAtDateDate/time when the message was imported from a third party application if applicable.Created By TeamscreatedByTeamsStringID(s) of the assigned team(s) of the user who created this message.Conversation IDconversation.idStringConversation ID associated with this message in the Kustomer application.Data export of Note standard attributes
The reference table below lists the display names, system names, data type, and descriptions for the Note standard Klass attributes available in the Kustomer platform. Specifically the attributes available for use in Data Exports.This table shows the available standard attributes for the Note object when running a scheduled or one time data export.Display nameSystem nameData typeDescriptionIDidStringID associated with this note the Kustomer application.External IDexternalIDStringThird party application id for this note if applicable.Created AtcreatedAtDateDate/time this note was created.Created BycreatedByStringID of the user that created this note.Updated AtupdatedAtDateDate/time this note was last updated.Modified BymodifiedByStringID of the user that modified this note.BodybodyStringMessage body content for this note.Modified AtmodifiedAtDateDate/time this note was last modified (changed by a user).DeleteddeletedBooleanBoolean value of whether this note has been deleted.Deleted AtdeletedAtDateDate/time when the note was deleted.Imported AtimportedAtDateDate/time when the note was imported from a third party application.Customer Emailcustomer.emails.emailStringEmail address of the customer associated with this note.
Still need help? Contact Us