Data Report Guide - Message History Export

Kelsey Seale

June 10, 2025 14:11

Your message history holds a rich source of data. Export your message history from the Messages tab and selecting "Exports." Learn more about exporting your message history here.

You will receive an email with a spreadsheet. Here is a breakdown of the columns and the information found in each.

Screenshot 2025-06-10 at 10.25.37 AM.png

Column Information

message_id

A unique ID for each message—useful for tracking or referencing specific communications.

* Messages with the same template_id will still have a unique message_id because they are associated with a specific contact.

participant_id

Unique signalvine_id for each contact/user—helps tie messages to individuals.

template_id

- Messages sent in the platform have unique template IDs.
- Program messages created with the template will have the same ID.
- Quick messages sent from the platform will have the same ID.

msg_direction

Indicates who sent it: Sent (you) or Received (the contact).

sent_type

How the message was sent: via a program template, quick send, autoresponder, ad hoc, or handler.

- Quick: Anything sent from the “Send” or “Send to current result” in the platform.
- Program: Messages sent using the message template.
- Autoresponder: Messages sent from the autoresponder.
- Ad hoc: Messages sent in the message history / conversation. Individual conversations with contacts.
- Handler: n/a: Automated key-word responses built into a program messages. (i.e. "Respond Yes or No."

body

The content of the message with merge fields already populated.

media

MMS content (if any) associated with the message.

time

The timestamp of the message in your local timezone (ISO format).

2025-05-13T20:42:50.352Z

May 13, 2025 at 8:42pm.