What's in my ThruTalk csvs?


ThruTalk offers several export types that help you review your calling activity, contact details, and results. Whether you're managing a campaign, tracking individual caller performance, or maintaining your Do Not Call list, these exports give you the data you need to stay organized and compliant. When an export is created in ThruTalk, a csv is generated. This article details every column in each csv for exports from ThruTalk.


ThruTalk and ThruText exports are managed separately in GetThru. This guide focuses on ThruTalk exports, which cover data from phone campaigns. For texting data, check out our separate guide to ThruText Exports.


TABLE OF CONTENTS


Understanding Account-Level vs. Campaign-Level Exports

Before diving into each export type, it’s helpful to understand the difference between account-level and campaign-level exports:

  • Campaign-Level Exports give you data for a single campaign. These exports are best when you want a snapshot of all activity for one campaign. For more information on these exports, see ThruTalk Campaign Exports. 
  • Account-Level Exports provide a broader view across multiple campaigns. Use these reports to track overall call outcomes or caller performance across multiple campaigns. For details on these exports, see Account-Level ThruTalk Exports. 

Choosing the right export depends on whether you’re analyzing a specific campaign or reviewing across your entire account.


Campaign Dials Exports

The Campaign Dials export helps you track all outbound call attempts made during a campaign. It can be run at the account level or campaign level and gives you an overview of dials made.


This report includes the following data:

  • contact_first_name — Contact's first name.
  • contact_last_name — Contact's last name.
  • contact_phone — Contact's phone number.
  • date_dialed — The date the dials were completed in UTC.
  • time_dialed_est — The date/time that the dials were completed in ET. 
  • call_duration — The amount of time the caller and contact were connected to speak with each other, measured in seconds. 
  • caller_first_name — Caller's first name associated with their GetThru profile. If caller_first_name and caller_last_name are blank, this is an automated call result.
  • caller_last_name — Caller's last name associated with their GetThru profile.
  • caller_phone — This is the phone number used by the campaign to dial that contact.
  • result — The call's outcome is based on the answer to the first question in your calling script. To understand each call outcome in your exports, see our guide, Call Results.
  • sync_status — The VAN syncing status of each contact in the campaign. Successful syncing will have a synced status, failed syncing will have a failed status, or if not using a VAN-enabled script (or syncing is not yet enabled for the account), it will have a status of no_sync. Learn how syncing works and what each sync status means in Sync Calling Results for ThruTalk. 
  • custom field 1 — Determined by the account's designated custom fields. For details on how custom fields appear in reports, check out our guide on Custom Fields. 
  • custom field 2 — Determined by the account's designated custom fields.
  • custom field 3 — Determined by the account's designated custom fields.
  • Script question(s) — The survey question title and response to each question are included in the script.


NOTE - The time picker is in UTC, which is -4-5 compared to ET. Need help comparing time zones? Use this UTC Time Converter to check current UTC time.


Account All Dials

The Account All Dials export shows call outcomes across all campaigns, without including script responses. It’s helpful when you want a high-level overview of calling activity.

  • campaign_id — Unique ID of the Campaign.
  • campaign_name — The campaign name.
  • contact_first_name — Contact's first name.
  • contact_last_name — Contact's last name.
  • contact_phone — Contact's phone number.
  • date_dialed — The date the dials were completed in UTC.
  • time_dialed_est — The date/time that the dials were completed in ET. 
  • call_duration — The amount of time the caller and contact were connected to speak with each other, measured in seconds. 
  • caller_first_name — Caller's first name associated with their GetThru profile. If caller_first_name and caller_last_name are blank, this is an automated call result.
  • caller_last_name — Caller's last name associated with their GetThru profile.
  • caller_phone — This is the phone number used by the campaign to dial that contact.
  • result — The outcome from the call based on the answer to the first question in your calling script.
  • sync_status — The VAN syncing status of each contact in the campaign. Successful syncing will have a synced status, failed syncing will have a failed status, or if not using a VAN-enabled script (or syncing is not yet enabled for the account), it will have a status of no_sync.
  • custom field 1 — Determined by the account's designated custom fields.
  • custom field 2 — Determined by the account's designated custom fields.
  • custom field 3 — Determined by the account's designated custom fields.


Do Not Call Export

The Do Not Call export lists all contacts that have been blocked from future calling. Use this report to review or audit who’s been added to your account’s DNC list and when. It helps ensure your campaign stays compliant with calling restrictions. This report includes the following data:

  • First Name — The first name of the contact removed from calling.
  • Last Name — The last name of the contact removed from calling.
  • Phone — The phone number of the contact removed from calling.
  • Added to Do Not Call On — The date and time (UTC) that the contact was added to the DNC list.
  • custom field 1 — Determined by the account's designated custom fields.
  • custom field 2 — Determined by the account's designated custom fields.
  • custom field 3 — Determined by the account's designated custom fields.


NOTE - To include the custom fields columns in a Do Not Call export, generate your export from the Exports page and not the Do Not Call page.


Caller Activity Details Report

The Caller Activity Details report gives you insight into individual caller performance. For full details on this report format, see the Caller Activity Details Report guide. This report includes the following data:

  • caller_first_name — The caller's first name.
  • caller_last_name —  The caller's last name.
  • caller_phone_number — The phone number on the caller's user profile.
  • caller_email — The email on the caller's user profile.
  • Script Call Results indicated by the caller
    • correct_persons — The total number of times that this caller indicated they were speaking with the correct person.
    • wrong_numbers — The total number of times that this caller indicated that this was the wrong number for the contact.
    • moved — The total number of times that this caller indicated that a contact had moved.
    • refused — The total number of times that this caller indicated that a contact refused the call.
    • no_contact — The total number of times that this caller indicated that they were not able to connect with a contact.
    • deceased — The total number of times that this caller indicated that a contact was deceased.
    • voicemail_received — The total number of times that this caller indicated that they encountered a voicemail.
    • deliverability_error — The total number of times that this caller indicated that there was a deliverability error.
  • in_call_time — The amount of time that this caller was in calls.


PatchThru Calls

The PatchThru Calls export provides information about the success of a PatchThru call and which contact connected to which target. This is available at the campaign level. To learn more about PatchThru and how it works, visit PatchThru Step-by-Step for Admins. 

  • contact_first_name — First name of the contact.
  • contact_last_name — Last name of the contact.
  • contact_phone — Phone number dialed for this contact.
  • time_dialed_est — The date/time of the dial, in ET.
  • patch_thru_connection_outcome — 'success', 'failure' or 'unknown', depending on the PatchThru connection.
  • patch_thru_duration — How long the contact was connected in a successful PatchThru call. If the call failed, this cell will be blank.
  • patch_thru_target — The full name of the PatchThru target from the phone number directory.
  • patch_thru_target_phone — Phone number of the PatchThru target.
  • patch_thru_target_title — Title of the PatchThru target.
  • patch_thru_target_district — District of the PatchThru target. 
  • patch_thru_target_state — State of the PatchThru target
  • caller_first_name — First name of the caller.
  • caller_last_name — Last name of the caller.

NOTE - If you are interested in setting up an s3 bucket for campaign dials, caller activity details reports, do not call reports, and patchthru reports, please follow the instructions in our guide, Nightly S3 Export Delivery.