Article updated: July 18, 2024
Sparkcentral data exports
You can create and download custom .csv file reports of your Sparkcentral data. By reporting on data such as conversations, messages, agents, and contacts, you can perform deep analysis on the performance of specific areas of your service.
Export files include IDs for certain fields, allowing you to link tables for more advanced analysis. For example, the Conversation ID field can be found in both conversation and message export types.
Create data exports
To create an on-demand export, follow these steps:
- Under Analytics, select Exports, and then select On-demand. Under Export type, select an option.
- Use the Time zone, Date range, and Channels filters to narrow the scope of your report.
- Select Generate export. You’ll be notified when the file is available.
- Select the download icon to download the .csv file to your computer.
Export definitions
This export contains all conversations that are resolved for the first time in the selected time range. The export includes one row per conversation, with data that was available for the conversation at the time of the export.
| Header | Description |
|---|---|
| Conversation ID | The unique identifier for the conversation |
| Medium | The social network or messaging service platform where the conversation took place |
| Channel | The channel where the conversation took place |
| Channel Display Name | The custom display name of the channel |
| Contact Profile ID | The unique identifier for the contact |
| Contact Primary Identifier | One of the two identifiers for contacts. Depending on the platform, this could be name, phone number, alias, etc. |
| Contact Secondary Identifier | One of the two identifiers for contacts. Depending on the platform, this could be name, phone number, alias, etc. |
| Created at | When an agent on this team sent the first outbound message. |
| Last Status Change Agent ID | The unique identifier for the agent who made the last status change to the conversation (moved it to Resolved or Pending) |
| Last Status Change Agent Name | The agent who made the last status change to the conversation (moved it to Resolved or Pending) |
| Last Status Change Agent Reference | The agent’s internal ID |
| Last Status Change Team ID | The unique identifier of the team that made the last status change to the conversation (moved it to Resolved or Pending) |
| Last Status Change Team Name | The team that made the last status change to the conversation (moved it to Resolved or Pending) |
| Current Status | The last status of the conversation at the time of the export |
| Resolved By | Whether the conversation was resolved by an agent, a virtual agent, a bulk resolve event, or the system |
| Resolve Reason | The resolve reason selected by the agent |
| Resolve Comment | Any resolve reason comment added by the agent |
| Resolve Trigger | Whether the conversation was resolved by a human agent, a virtual agent, automation, or auto-resolve |
| Resolved At | When the conversation was resolved |
| Resolved Agent ID | The unique identifier of the agent who resolved the conversation |
| Resolved Agent Name | The agent who resolved the conversation |
| Resolved Agent Reference | The agent’s Internal ID |
| Number of Inbound Messages | The total number of messages received from the contact during the conversation |
| Number of Outbound Messages | The total number of messages sent to the contact during the conversation |
| First Response Time (s) | The length of time between the first inbound and first outbound message, or the time between handover from VA/AR to the New queue and the first human agent outbound message |
| Handle Time (s) | The length of time that an agent was actively working on the conversation (lock) |
| No-Reply Time (s) | The length of time that an agent was looking at the conversation (lock) and resolved it without a reply |
| Cherry-Picking Time (s) | The length of time that an agent was looking at the conversation (lock) and did not send a reply |
| Resolution Time (s) | The length of time between the first inbound message and the status change to Resolved |
| Topic IDs | The unique identifiers for topics applied to the conversation |
| Topic Names | The topics applied to the conversation |
| Conversation URL | The URL to the conversation |
| Last Updated | When the last change was made to the conversation |
| Language | The language detected or set in the conversation |
| CSAT Score | The contact’s rating submitted via CSAT survey |
| CSAT Completed Status | The response status of the contact after being sent a CSAT survey |
| CSAT Follow-up Question | Any follow-up survey question sent to the contact |
| CSAT Follow-up Answer | Any follow-up answer received from the contact |
This export contains all conversations with the status New or Pending at the time of the export. The export includes one row per conversation, with data that was available for the conversation at the time of the export.
| Header | Description |
|---|---|
| Conversation ID | The unique identifier for the conversation |
| Medium | The social network or messaging service platform where the conversation took place |
| Channel | The channel where the conversation took place |
| Channel Display Name | The custom display name of the channel |
| Contact Profile ID | The unique identifier for the contact |
| Contact Primary Identifier | One of the two identifiers for contacts. Depending on the platform, this could be name, phone number, alias, etc. |
| Contact Secondary Identifier | One of the two identifiers for contacts. Depending on the platform, this could be name, phone number, alias, etc. |
| Created at | The creation date of the conversation |
| Last Status Change Agent ID | The unique identifier for the agent who made the last status change to the conversation (moved it to Resolved or Pending) |
| Last Status Change Agent Name | The agent who made the last status change to the conversation (moved it to Resolved or Pending) |
| Last Status Change Agent Reference | The agent’s internal ID |
| Last Status Change Team ID | The unique identifier of the team that made the last status change to the conversation (moved it to Resolved or Pending) |
| Last Status Change Team Name | The team that made the last status change to the conversation (moved it to Resolved or Pending) |
| Current Status | The last status of the conversation at the time of the export |
| Resolved By | Whether the conversation was resolved by an agent, a virtual agent, a bulk resolve event, or the system |
| Resolved At | When the conversation was resolved |
| Resolved Agent ID | The unique identifier of the agent who resolved the conversation |
| Resolved Agent Name | The agent who resolved the conversation |
| Resolved Agent Reference | The agent’s Internal ID |
| Number of Inbound Messages | The total number of messages received from the contact during the conversation |
| Number of Outbound Messages | The total number of messages sent to the contact during the conversation |
| First Response Time (s) | The length of time between the first inbound and first outbound message, or the time between handover from VA/AR to the New queue and the first human agent outbound message |
| Handle Time (s) | The length of time that an agent was actively working on the conversation (lock) |
| No-Reply Time (s) | The length of time that an agent was looking at the conversation (lock) and resolved it without a reply |
| Cherry-Picking Time (s) | The length of time that an agent was looking at the conversation (lock) and did not send a reply |
| Resolution Time (s) | The length of time between the first inbound message and the status change to Resolved |
| Topic IDs | The unique identifiers for topics applied to the conversation |
| Topic Names | The topics applied to the conversation |
| Conversation URL | The URL to the conversation |
| Last Updated | When the last change was made to the conversation |
| Language | The language detected or set in the conversation |
This export contains all unique messages created in the selected time range. The export includes one row per message, with data that was available for that message at the time of the export.
| Header | Description |
|---|---|
| Message ID | The unique identifier for the message |
| Created at | When the message was created |
| Conversation ID | The unique identifier for each conversation |
| Medium | The social media or messaging service platform on which the message was sent |
| Channel | The channel on which the message was sent |
| Channel Display Name | The custom display name of the channel |
| Contact Profile ID | The unique identifier for each contact |
| Contact Primary Identifier | One of the two identifiers for contacts. Depending on the platform, this could be name, phone number, alias, etc. |
| Contact Secondary identifier | One of the two identifiers for contacts. Depending on the platform, this could be name, phone number, alias, etc. |
| Message Type | The specific type of message |
| Origin | Where the message was sent from |
| Outbound Message Type | Where the agent outbound was sent from |
| Direction | Where the message came from |
| Agent ID | The unique identifier of the agent who sent the message |
| Agent Name | The agent who sent the message |
| Agent Reference | The agent’s internal ID |
| Team ID | The unique identifier of the team |
| Team Name | The team that the agent who sent the outbound message is a member of |
| Tag IDs | The unique identifier of the tag |
| Tag Names | The tags applied to the message |
| Content | The message content - available only for Twitter content and only for on-demand exports |
| Conversation URL | The URL for this conversation |
| Post URL | The URL for the original post or message in the social network or messaging platform |
| Last Updated | When the message was last updated in the system |
| Deleted At | When the message was deleted from the system |
| System User Type |
The type of message. Values include:
|
This export contains team-level data. Only teams that have at least one outbound message are included in the export. The export includes one row per team, with data that was available at the time of the export.
| Header | Description |
|---|---|
| Created At | The date the team was created |
| Team ID | The unique identifier of the team that has been active |
| Team Name | The team that has been active |
| Resolves with Reply | The total number of conversations resolved by agents on this team with at least one outbound message |
| Resolves without Reply | The total number of conversations resolved by agents on this team without an outbound message |
| Average First Response Time | The average first response time of all conversations handled by agents on this team in the selected time range |
| Average Resolution Time | The average resolution time of all conversations handled by this team in the selected time range |
| Total Handle Time | The total time that agents on this team were actively working on conversations (lock) |
| Total No-Reply Time | The total time that agents on this team were looking at conversations (lock) and resolved them without any reply |
| Total Cherry-Picking Time | The total time that agents on this team were looking at conversations (lock) and did not send any reply |
| Average Handle Time | The average time that agents on this team were actively working on conversations (lock) |
| Contacts Helped | The number of contacts who received at least one message from an agent on this team |
| CSAT with Score 1 | The total number of customer satisfaction surveys returned with a score of 1 during the selected time range |
| CSAT with Score 2 | The total number of customer satisfaction surveys returned with a score of 2 during the selected time range |
| CSAT with Score 3 | The total number of customer satisfaction surveys returned with a score of 3 during the selected time range |
| CSAT with Score 4 | The total number of customer satisfaction surveys returned with a score of 4 during the selected time range |
| CSAT with Score 5 | The total number of customer satisfaction surveys returned with a score of 5 during the selected time range |
| Tags Added | The total number of tags added by this team |
| Topics Added | The total number of topics added by this team |
| Replies | The total number of outbound messages sent by this team |
This export contains all contacts that have at least one message in the selected time range.
| Header | Description |
|---|---|
| Contact Profile ID | The unique identifier for the contact |
| Medium | The social media or messaging service platform on which the contact sent a message |
| Primary Identifier | One of the two identifiers for contacts. Depending on the platform, this could be name, phone number, alias, etc. |
| Secondary Identifier | One of the two identifiers for contacts. Depending on the platform, this could be name, phone number, alias, etc. |
| Created At | The date and time when the Contact sent the first message within the selected time range |
| Number of Conversations | The number of conversations with the contact |
| Number of Inbound Messages | The number of messages sent by the contact |
| Number of Outbound Messages | The number of messages sent to the contact |
| Last Updated | Date and time of the last update to the contact |
This export contains all topics that have at least one application in the selected time range.
| Header | Description |
|---|---|
| Topic ID | The unique identifier for the topic |
| Topic Name | The name of the topic |
| Active | Whether the topic still exists on the Topics page in the Routing and automation section of Admin settings |
| Total Conversations | Total Conversations |
| Total Current Conversations | The count of all conversations that have a topic applied at the moment of the export, within the selected time range |
| Medium | The social network or messaging service platform of the conversation a topic was applied to |
| Channel | The channel of the conversation the topic was applied to |
| Channel Display Name | The custom display name of the channel |
This export contains all tags that have at least one application in the selected time range.
| Header | Description |
|---|---|
| Tag ID | The unique identifier for the tag |
| Tag Name | The name of the tag |
| Active | Whether the tag still exists on the Tags page in the Routing and automation section of Admin settings |
| Total Contacts | The number of contacts that have had a tag applied on one of their messages |
| Total Messages | The total number of messages that have had a tag applied during the selected time range |
| Total Current Messages | The number of messages that have a tag applied during the selected time range at the moment of the export |
| Medium | The social network or messaging service platform of the message the tag was applied to |
| Channel | The channel of the message the tag was applied to |
| Channel Display Name | The custom display name of the channel |
This export contains all agents that have at least one Away or Available state in the selected time range. Note that if a time range starts or ends outside of the selected time frame, it will be included in the report.
| Header | Description |
|---|---|
| User ID | The unique ID for the agent |
| User Name | The name of the agent |
| User Email Address | The email address of the agent |
| Type | The presence type |
| Away State | The custom away state name |
| From | The start date and time |
| To | The end date and time |
| Duration (s) | How long the agent has been in this presence type |
This export contains the metrics collected per agent for a selected time range.
| Header | Description |
|---|---|
| User ID | The unique identifier of the agent |
| User Name | The name of the agent |
| User Email Address | The email address of the agent |
| User Reference | The internal ID of the agent |
| Available Time (s) | The total time the agent has been Available in the selected time range |
| Away Time (s) | The total time the agent has been Away in the selected time range |
| Contacts Helped | The number of contacts that received at least one message from the agent |
| Avg. Handle Time (s) | The average time the agent was actively working on conversations (lock) |
| Handle Time (s) | The total time the agent was actively working on conversations (lock) |
| No-Reply Time (s) | The total time the agent was looking at conversations (lock) and resolved them without replying |
| Cherry-Picking Time (s) | The total time the agent was looking at conversations (lock) and did not send replies |
| Replies | The total number of outbound messages sent by the agent |
| Resolves - With Reply | The total number of conversations resolved by the agent with at least one outbound message |
| Resolves - No Reply | The total number of conversations resolved by the agent without an outbound message |
| Tags Added | The total number of tags added by the agent |
| Topics Added | The total number of topics added by the agent |
| Utilization (%) | The overall utilization percentage for the agent |
| CSAT with Score 1 | The total number of customer satisfaction surveys returned for this agent with a score of 1 during the selected time range |
| CSAT with Score 2 | The total number of customer satisfaction surveys returned for this agent with a score of 2 during the selected time range |
| CSAT with Score 3 | The total number of customer satisfaction surveys returned for this agent with a score of 3 during the selected time range |
| CSAT with Score 4 | The total number of customer satisfaction surveys returned for this agent with a score of 4 during the selected time range |
| CSAT with Score 5 | The total number of customer satisfaction surveys returned for this agent with a score of 5 during the selected time range |
This export contains all responses for which an outbound message was created in the selected time range.
| Header | Description |
|---|---|
| Conversation ID | The unique identifier for the conversation |
| Medium | The social media or messaging service platform where the conversation took place |
| Sender Channel | The channel name where the contact’s message was received |
| Sender Channel Display Name | The custom display name of the channel |
| Contact Profile ID | The unique identifier for the contact |
| Started By | The reason the conversation became visible in the New queue |
| Handover Reason | If “Started by” is “VA_HANDED_OVER_CONVERSATION,” this is the reason there was a handover |
| From | The timestamp of the “Started By” event (the actual timestamp is used to calculate the Response Time) |
| To | The timestamp of the outbound message |
| Agent Response Time (s) | The difference between the “From” and “To” (the time it took an agent to respond to the contact) |
| Replying Agent ID | The unique identifier of the agent who sent the outbound message |
| Replying Agent Name | The name of the agent who sent the outbound message |
| Replying Agent Reference | The agent’s internal ID |
| Inbound Message ID | The unique identifier for the inbound message |
| Outbound Message ID | The unique identifier for the outbound message |
| Conversation URL | The URL to this conversation |
This export contains the metrics collected per virtual agent for a selected time range.
| Header | Description |
|---|---|
| Agent ID | The unique identifier for the virtual agent |
| Agent Name | The name of the virtual agent, as configured in the system |
| Medium | The social media or messaging service platform on which the virtual agent was part of a conversation |
| Channel | The channel on which the virtual agent was part of a conversation |
| Channel Display Name | The custom display name of the channel |
| Total Conversations | The total number of conversations in which the virtual agent sent at least 1 message |
| Handover to Agent | The number of conversations handed over from the virtual agent to a human agent |
| Handover due to Error | The number of conversations handed over because the virtual agent encountered an error |
| Resolved | The number of conversations been resolved by a virtual agent |
| Total Conversations with Topic | The number of topics that the virtual agent applied to conversations |
| Total Messages Tagged | The number of messages that have been tagged overall |
| The number of messages that have been tagged overall | The number of tags that have been applied per message |
This export contains all stored contact attributes that were filled out manually by agents or bots or collected from a CRM. All contacts who sent messages in the selected time range are included.
| Header | Description |
|---|---|
| Contact Profile ID | The unique identifier for the contact |
| Contact Primary Identifier | One of the two identifiers for contacts. Depending on the platform, this could be name, phone number, alias, etc. |
| Contact Secondary Identifier | One of the two identifiers for contacts. Depending on the platform, this could be name, phone number, alias, etc. |
| Attribute ID | The unique identifier for the contact attribute |
| Attribute Name | The name of the contact attribute |
| Attribute Value | The value of the defined contact attribute |
| Attribute Type | The type of contact attribute |
Can't find what you're looking for? We're here to help