Contact Export
  • 15 Apr 2022
  • 10 Minutes To Read
  • PDF

Contact Export

  • PDF

Use the Contact Export report to get detailed information about individual Contacts. Use this information to dig into underlying data and run your own analysis.

How Data in the report is measured

The Contact Export report is measured using the following:

Grouping

  • Grouped by Contacts. Only compare this report to other Contacts reports.

Time Anchor

  • Data is time anchored using 'queued time' in the UI and API. Some Contacts that have not yet ended may have a "Null" value.

Metrics used for the Contact Export report

Review the definition of each metric and how it's used to calculate data. These are fields you'll see in the CSV download. The columns in the report are only populated either at the start or end of the Contact.

MetricDescriptionComments
Queued AtTimestamp of when the Contact was first queued (inbound) or initiated (outbound).
Customer IDGladly ID for the Customer.
Conversation IDGladly ID for the Conversation.
Contact IDGladly ID for the Contact.
LinkLink to the Conversation that contains the Contact.There may be several Contacts, and the link may not go directly to the specific Contact.
ChannelChannel of the Contact.Options: PHONE_CALL, CHAT, SMS, FB_MESSENGER, TWITTER, WHATSAPP, EMAIL, VOICEMAIL, ABANDONED_CALL. Note that ABANDONED_CALL (now deprecated) is the follow-up item.
DirectionDirection of the Contact. "Inbound" Contacts are those initiated by the Customer, Internal, or External Initiator Types, while "Outbound" Contacts are those initiated by the Agent, Application, or System Initiator Types.Options: INBOUND, OUTBOUND
Contact InitiatorEntity that initiated the Contact.Initiator Type Options: Customer, Agent, Automation (Rules), Internal, External, Application (API), System
Entry PointFor an inbound Contact, the "To" address (phone number, email address, Sidekick ID, etc.) that the Customer reached out to.
Final IVR SelectionFinal selection made in the IVR before the Contact is queued.

Fulfilled TypeCategory of how the Contact was fulfilled. Fulfilled Contacts are limited to Responded (answering the call, replying by message or email) and Canceled ("No reply needed" and Conversation Close). Abandons, Forwards, Calls that leave a voicemail, and Messaging contacts that time out are not included.Options: RESPONDED, CANCELED
StatusThe final status of the Contact.
  • Answered = An Agent responded using the same Channel
  • Abandoned = The Customer abandoned their phone call before connecting with an Agent
  • Unknown = The Contact was an Outbound Contact
  • Unanswered = Either the Customer left a voicemail, was forwarded, or an Agent responded on a different Channel, or an Agent canceled the Contact.

Options: ANSWERED, UNANSWERED, ABANDONED, UNKNOWN

Fulfilled AtTimestamp when the Contact was fulfilled.
Ended AtTimestamp when the Contact was ended.
Agent when EndedAgent assigned when the Contact was ended.

See FAQs below for additional context

Inbox when EndedInbox assigned when the Contact was ended.
Inbox when First QueuedInbox assigned when the Contact was started/first queued.
Queued-to-Fulfilled TimeDuration of time from first queued to fulfilled.
Queued-to-Ended TimeDuration of time from first queued to ended.
Seconds within (-) or over (+) SLADuration of time between when the Contact was due and when it was fulfilled.Negative values indicate the Contact was fulfilled before it was due, and positive values indicate it was fulfilled after being due.
SLA TargetTarget duration used to calculate the Due At time (from when the Contact is first queued to when it is due).Note that if there is an overlapping contact, this may be overridden
Contact Handle TimeTotal duration of time when any Agent viewed the Customer Profile while the Contact was ongoing.
After Contact TimeTotal duration of time when any Agent viewed the Customer Profile after the Contact has ended, but before the Conversation is closed or before another Contact begins.See Handle Time definition to learn more. 
Talk TimeDuration of time from fulfilled (inbound) or answered (outbound) to ended, minus any time the phone call Contact was on Hold.Only applies to Phone Call Contacts
Hold Time - TotalDuration of time the phone call Contact was on Hold.Only applies to Phone Call Contacts
Hold Time - ManualDuration of time the phone call Contact was on Hold for a manual hold.Only applies to Phone Call Contacts
Hold Time - Warm TransferDuration of time the phone call Contact was on Hold for a warm transfer.Only applies to Phone Call Contacts
Hold Time - Cold TransferDuration of time the phone call Contact was on Hold for a cold transfer.Only applies to Phone Call Contacts
Hold Time - ConferenceDuration of time the phone call Contact was on Hold for attempting a conference call.Only applies to Phone Call Contacts
Messages TotalCount of total messages in the Contact.Only applies to email and messaging Contacts (SMS, Chat, Twitter, etc.). Does not apply to Phone Call and Voicemail Contacts.
Messages from CustomerCount of messages sent by the Customer in the Contact.Only applies to email and messaging Contacts (SMS, Chat, Twitter, etc.). Does not apply to Phone Call and Voicemail Contacts.
Messages from AgentCount of messages sent by an Agent in the Contact.Only applies to email and messaging Contacts (SMS, Chat, Twitter, etc.). Does not apply to Phone Call and Voicemail Contacts.
Messages from RulesCount of messages sent by Rules in the Contact.Only applies to email and messaging Contacts (SMS, Chat, Twitter, etc.). Does not apply to Phone Call and Voicemail Contacts.
Messages from APICount of messages sent by API in the Contact.Only applies to email and messaging Contacts (SMS, Chat, Twitter, etc.). Does not apply to Phone Call and Voicemail Contacts.
Avg. Agent Reply TimeAverage time it took for the Agent to reply throughout the Contact..Only applies to email and messaging Contacts (SMS, Chat, Twitter, etc.). Does not apply to Phone Call and Voicemail Contacts.
Avg. Customer Reply TimeAverage time it took for the Customer to reply throughout the Contact.Only applies to email and messaging Contacts (SMS, Chat, Twitter, etc.). Does not apply to Phone Call and Voicemail Contacts.
Offered AtTimestamp when the Contact was first offered.
Accepted AtTimestamp when the Contact was first accepted.
Answered AtTimestamp when the outbound Phone Call Contact was answered by a Customer.Only applies to outbound Phone Call Contacts
Queued-to-First Accepted TimeDuration from queued to the first time the Contact was accepted.
First Accepted-to-Fulfilled TimeDuration from the first time the Contact was accepted to fulfilled.
Fulfilled-to-Ended TimeDuration from fulfilled to ended.
Fulfilled by Contact ID
Gladly ID for the Contact that fulfilled this Contact (if applicable).
  • Example with different ID: if an outbound phone call Contact fulfills a voicemail Contact, the phone call Contact ID will be shown.
  • Example with same ID: if an Agent responds on chat to a customer's chat message, the chat Contact ID will be listed in its own row.
OfferedCount of times the Contact was offered to Agents.
AcceptedCount of times the Contact was accepted by Agents.
MissedCount of times the Contact was missed by Agents.
DeclinedCount of times the Contact was declined by Agents.
TransferredCount of times the Contact was transferred.
Times On Hold TotalCount of times the Contact was put on Hold, for any reason.Only applies to Phone Call Contacts
Times On Hold - ManualCount of times the Contact was put on Hold for a manual hold.Only applies to Phone Call Contacts
Times On Hold - Warm TransferCount of times the Contact was put on Hold for a warm transfer.Only applies to Phone Call Contacts
Times On Hold - Cold TransferCount of times the Contact was put on Hold for a cold transfer.Only applies to Phone Call Contacts
Times On Hold - ConferenceCount of times the Contact was put on Hold to attempt a conference call.Only applies to Phone Call Contacts
Payment Requests - Completed
Count of payment requests during the Contact that ended as “Completed.”
Payment Requests - Declined
Count of payment requests during the Contact that ended as “Declined.”
Payment Amount - Completed USD
Total amount of payments requested during the Contact that ended as “Completed.”

This metric only captures payment requests in US Dollars.

Payment Amount - Declined USD
Total amount of payments requested during the Contact that ended as “Declined.”This metric only captures payment requests in US Dollars.

Note – For metrics that are durations of time, the report in the UI will show time in d:hh:mm:ss (Days, Hours, Minutes, Seconds) format, while the downloaded CSV will show time in raw Seconds.

How the Contact Export report is filtered

You can filter the report using the following criteria. This is how you start segmenting the data based on what you are trying to learn. You can learn more about filters here.

Date

  • The date filter will correspond to the 'queued time' timestamp.

Channels

  • Indicates the Channel in which Channel the Contact was initiated on. The Channels can include voice, chat, email, SMS, FB Messenger, Twitter, WhatsApp.
  • Voice Channel only includes phone calls and does not include voicemail and abandoned call follow-ups.

Inbox

  • The Inbox column and report filter refer to the Inbox where the Contact was queued in.

How to use the Contact Export report

The Contact Export report can provide multiple data points based on how you slice and dice the data. Below are a couple of examples:

ScenarioColumn Filter
What Contacts are contributing the most to our handle time averages?
  • Select the desired date range
  • Select a particular Channel or use All Channels
  • Select a particular Inbox or use All Inboxes

Sort the table by Contact Handle Time. Use the Conversation Link column to click on a particular Conversation to get more context.

Voice wait time (queued-to-fulfilled time) is increasing. Which Entry Points or Inboxes are contributing to this increase?
  • Select the desired date range
  • Select a particular Channel or use All Channels
  • Select a particular Inbox or use All Inboxes

Sort the table by Entry Point against a particular Channel. You can do the same for a particular Inbox.


FAQs

'Agent when Ended' metric-specific FAQs:

Does the Contact Export report represent every Agent that had worked on a Contact when it ended?

No. The report does not measure the participation of every Agent that may have worked on a Contact. The 'Agent when Ended' metric represents the Agent assigned the Conversation when the Contact ended and therefore does not necessarily represent all the Agents that may have worked the Contact.

For phone calls, the Contact assignee may not necessarily be the same as the Conversation assignee. This can happen for multiple reasons:

  • A single Profile has 2 ongoing phone calls - these are 2 Contacts and have 2 different assignees.
  • An Agent answered the phone and talked with a Customer, but the Conversation is reassigned either manually or because of routing activities. In this case, the phone call remains assigned to the Agent, but the Conversation is assigned to someone else.

'Agent when Ended' is blank for calls that are marked 'abandoned.'

One potential scenario is if the call is abandoned, it may never get assigned to an Agent as an Agent did not pick up the call, and that is why Contacts Agent When Ended is blank.

'Agent when Ended' is blank for calls marked as 'answered'

"Contacts Agent When Ended" is typically the Conversation's assignee at the time a communication session was ended (not the last Agent who worked on the contact). An exception to this is:

In a handful of these blank columns, the Agent merged the Customer Profile they were working on with another Customer Profile in Gladly. When this occurs, the Agent still remained on the phone with the Customer, but the conversation became unassigned from them, which is why Contacts Agent When Ended is blank. The Agent's work is still captured in the Agent Summary, and Work Sessions reports. They are just not tagged as the "Contacts Agent When Ended" as the merge unassigned the conversation from them. When an Agent merges a Customer Profile, we recommend that they always check the lower-left hand corner of the Conversation to ensure that the new Conversation is still assigned to them.

Exceptions to the above rule, for phone calls specifically, where these two scenarios could occur:

  • A single Profile can have multiple ongoing phone calls. These would be modeled as separate Contacts with separate assignees.
  • An Agent could be on the phone with a Customer, but the Conversation may be routed to another Agent (either manually or because of routing a different Channel). In this case, the phone call remains assigned to the Agent, but the Conversation is assigned to someone else.

How are emails counted in the report?

Emails in this report are counted as sessions and not as individual email Contacts. Use the Inbound Contacts report if you want to report on emails on a per email Contact basis.

How could 'queued to fulfilled' show a negative value?

It can happen when a Conversation also has a phone call. All emails that arrive during a phone call are fulfilled when the phone call completes. The fulfilled timestamp is the one from the phone call.  For example:

  • A Customer calls at 8:05
  • Agent accepts the call at 8:06 ← this is the fulfilled timestamp
  • Customer writes an email at 8:08 ← this is the queued timestamp
  • The call ends at 8:11, which fulfills the email using 8:06 as the fulfilled timestamp. The resulting difference for email between fulfilled at (8:06) and queued at (8:08) is minus 2 minutes.

What does 'fulfilled' mean in this report?

Fulfilled Contacts are limited to Responded and Canceled ("No reply needed" and Conversation Close). Abandons, Forwards, Calls that leave a voicemail, and Messaging Contacts that time out are omitted.

When does a Contact get updated as "fulfilled"?

Fulfillment status is updated when the Contact is ended. If the Contact hasn't ended yet, it will not yet show a Fulfilled At timestamp.

Why does 'SLA Target' sometimes have a negative value?

A negative SLA Target usually means the Contact overlapped with another Contact that has already set the SLA.

I see the 'Fulfillment' type is 'Responded' or 'Canceled,' why is 'Status' showing 'Unanswered'?

This happens when a Contact on one Channel is responded to on a different Channel.

Why is 'Status' showing a 'Null' value?

Because the Contact hasn't ended yet.


Was this article helpful?

What's Next