Exporting Data

You can easily export data in your Daisychain account.

Exporting People Data

You can easily export data stored in Daisychain from the People section as CSV files. Here's how:

• Navigate to the People section.

• Optionally, filter your list if you only want to export a subset of your people. (Note that selecting people using checkboxes will not affect who does/doesn't get exported.)

Hit the three dots, and press the "Export" link, and a CSV file will be generated and emailed to you.

Exported CSVs will include columns for:

• A Daisychain ID #

• All standard fields

• All custom fields

• Tags

• Date created

• Date updated

• Latitude and Longitude

• SMS Fields

  • sms_subscribed

  • sms_subscribed_at

  • sms_subscription_source_kind

  • sms_opt_out_at

  • sms_opt_out_reason

• Email Fields

  • email_subscribed

  • email_subscribed_at

  • email_subscription_source_kind

  • email_opt_out_at

  • email_opt_out_reason

Exporting Message Data

You can export your account's SMS message history and opt-out list as CSV files. To access these exports, navigate to Settings > Account > Exports.

You'll see two export options:

All SMS Messages

A complete export of all incoming and outgoing SMS messages for your account. Click the button to generate a CSV file, which will include the following columns:

• id — Unique message ID

• conversation_id — The conversation the message belongs to

• direction — Whether the message is incoming or outgoing

• status — Delivery status (e.g., delivered, undelivered)

• error_code — Error code, if applicable

• external_id — The message ID from the carrier

• from — The sending phone number

• to — The receiving phone number

• body — The message content

• segment_count — Number of SMS segments

• billing_kind — Whether the message was billed as sms or mms

• phone_number_type — The recipient's phone type (e.g., mobile)

• carrier_name — The recipient's carrier

• broadcast_name — The name of the campaign, if the message was part of one

• broadcast_id — The campaign ID, if applicable

• opt_out_reason — If the message triggered an opt-out, the reason

• person_id — The Daisychain person ID associated with the message

• card_id — The card ID, if applicable

• automation_execution_id — The automation execution ID

• automation_id — The automation ID, if applicable

• accepted_at — When the message was accepted by the carrier

• created_at — When the message was created

SMS Opt Outs

A list of all phone numbers currently opted out of receiving SMS messages from your account. This CSV includes:

• phone_number — The opted-out phone number

• created_at — When the opt-out was recorded

---

Let me know if you want any adjustments to the tone, level of detail, or structure.