What's in my ThruTalk csvs?


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 separate in GetThru.app. This guide details ThruTalk exports, we have a separate guide for ThruText exports.


TABLE OF CONTENTS


Campaign Dials exports

The Campaign Dials export 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 details at the time of the export.
  • contact_last_name — Contact's last name details at the time of the export.
  • contact_phone — Contact's phone number details at the time of the export.
  • 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 (asked in the script's default starting question, such as "talked to correct person," "voicemail," etc.).
  • 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.
  • 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.  Check what time it is in UTC right now!

There is a 90-day maximum for Account Campaign Dial reports.


Account All Dials

All Dials is an account-level export and overlaps with the Campaign Dials report detailed above, however, it does not include script results. This report will provide an easy way to generate a high-level view of the percentages of your call results.

  • campaign_id — Unique ID of the Campaign.
  • campaign_name — The campaign name.
  • contact_first_name — Contact's first name details at the time of the export.
  • contact_last_name — Contact's last name details at the time of the export.
  • contact_phone — Contact's phone number details at the time of the export.
  • 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 (asked in the script's default starting question, such as "talked to correct person," "voicemail," etc.).
  • 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 being called with this account. 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 admins information about caller activity. 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.

  • 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.