Message Exports 


Message exports include full-text message details for all incoming and outgoing messages. Message exports are available as a campaign export, an account export, or a nightly S3 export. This report includes the following data:


  • timestamp — The time the message was sent. All timestamps are tracked in UTC time.
  • message_id — Unique ID of the message.
  • message_direction — Indicates if the message was incoming, outgoing, incoming media (MMS), voicemail, or call.
  • message_body — Full body of the message or link to media.
  • sender_first_name Message sender's first name associated with their ThruText profile (outgoing only).
  • sender_last_name — Message sender's last name associated with their ThruText profile (outgoing only).
  • sender_phone Message sender's phone number associated with their ThruText profile (outgoing only).
  • sender_email — Message sender's email associated with their ThruText profile (outgoing only).
  • campaign_id Unique ID of the campaign.
  • campaign_name The campaign name.
  • conversation_id — Unique ID of the conversation.
  • conversation_phone — The outgoing phone number used to send the text message from your campaign.
  • contact_id — Unique ID of the contact (this is a unique value for a contact phone + organization account).
  • 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
  • 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.



Survey Exports


Survey exports include your survey questions, the campaigns they are attached to, and the survey response data collected by texters. Survey exports are available as a campaign export, an account export, or a nightly S3 export. This report includes the following data:


  • campaign_id — Unique ID of the campaign.
  • campaign_name — The campaign name. 
  • conversation_id — Unique ID of the conversation. 
  • survey_id — Unique ID of the survey question.
  • survey_question — The survey question.   
  • survey_type — Indicates if the survey question is yes/no, multiple choice (pick one), check box (pick many), or freeform.   
  • response — Response collected for that contact.   
  • contact_id — Unique ID of the contact (this is a unique value for a contact phone + organization account).   
  • 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
  • updated_at — The timestamp of the most recent data collection. All timestamps are tracked in UTC time. 
  • sync_status — Indicates if a survey status is no_sync, syncing, synced, or failed.
  • 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.



Campaign Exports

Campaign exports give you an overview of the campaigns across your account. Campaign exports are only available as an account-level export This report includes the following data:


  • campaign_id — Unique ID of the campaign.
  • campaign_name — The campaign name.   
  • campaign_status — Indicates if a campaign status is active, archived, or paused. 
  • campaign_start_date — The start date and time of the campaign. All campaigns with a "start date" within the date range designated will be included in the report. Admins can pull one week of campaigns at a time.
  • campaign_end_date — The end date and time of the campaign.  
  • campaign_archived_at — The timestamp when of when a campaign was archived.
  • campaign_tags — Lists any tags on the campaign.
  • Conversation Status Counts:
    • initial_sent_count — The total un-started conversations remaining on the campaign at the time of the export.  
    • initial_sent_count — The total initial messages sent on the campaign at the time of the export.  
    • needs_reply_count — The total conversations with an incoming message last on the thread (but not in an archived status) at the time of the export.  
    • replied_count — The total conversations where the contact replied at the time of the export.    
    • complete_count — The total number of archived conversations at the time of the export.    
  • opted_out_contacts_count — The total number of contacts on that campaign who were opt outed out at the time of the export. Note, because opt outs are account-wide, this does not denote if the contact was opted on via this particular campaign    
  • total_outgoing_messages_count — The total number of outgoing messages sent on the campaign.   
  • conversations_count — The total conversations on the campaign.  



Conversation Exports


Conversation exports include every conversation in a campaign with outgoing / incoming message details as well as the assignee for each conversation. Conversation exports are only available as a campaign-level export. This report includes the following data:


  • campaign_id — Unique ID of the campaign.
  • campaign_name — The campaign name. 
  • conversation_id — Unique ID of the conversation. 
  • conversation_phone     — The outgoing phone number used to send the text message from your campaign.
  • contact_id     — Unique ID of the contact (this is a unique value for a contact phone + organization account).     
  • 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.
  • contact_opted_out     — Indicates if the contact phone was opted out at the time of the export.
  • assignee_first_name     — The first name of the person assigned the conversation at the time of export.
  • assignee_last_name     — The last name of the person assigned the conversation at the time of export. 
  • assignee_phone     — The phone number of the person assigned the conversation at the time of export.  
  • assignee_email     — The email of the person assigned the conversation at the time of export.    
  • outgoing_messages     — The number of outgoing messages sent in the conversation thread at the time of export.    
  • incoming_messages     — The number of incoming messages received in the conversation thread at the time of export.      
  • incoming_calls     — The number of incoming calls received in the conversation thread at the time of export.      
  • incoming_voicemails     — The number of incoming voicemails left in the conversation thread at the time of export.      
  • incoming_media     — The number of media message (MMS) received in the conversation thread at the time of export.      
  • 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.



Opt Out Exports


Opt out exports will produce a CSV of every opt out across your organization. Opt out exports are available as an account export or a nightly s3 export. This report will include the following data:


  • timestamp — The time the message was sent. All timestamps are tracked in UTC time.
  • contact_id — Unique ID of the contact (this is a unique value for a contact phone + organization account).   
  • 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
  • conversation_id        — The unique ID of the conversation.  
  • note        — Indicates who collected the opt out and how (either through a campaign or via a tool within the admin opt out management page).   
  • 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.


User Exports


User exports will produce a CSV of every user across your organization. User exports are only available as an account-level export. This report includes the following data:


  • first_name — User's first name associated with their ThruText profile.
  • last_name — User's last name associated with their ThruText profile.  
  • phone — User's phone number associated with their ThruText profile.  
  • email — User's email associated with their ThruText profile.  
  • role — Indicates the role assigned to the user on your organization's account – message sender, moderator, or admin.
  • created_at — The date the user joined your organization. All timestamps are tracked in UTC time.
  • last_updated — A timestamp of the last time the user updated their ThruText profile. All timestamps are tracked in UTC time. 


*Uniquely identifying custom fields that are included in export files are determined by the account admins. For more on setting up unique identifiers, see our user guide on Custom Fields.