What's in my ThruTalk csv?


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.

If you are interested in setting up an s3 bucket, please follow the instructions in our guide, Nightly S3 Export Delivery.


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.