Bulk Export Schema Overview

contact_history fields

Field	Description
`organization_id`	Organization ID tied to the record.
`organization_name`	Friendly organization name.
`workspace_id`	Unique workspace identifier.
`workspace_name`	Workspace name.
`contact_history_id`	Unique Identifier.
`campaign_id`	Campaign identifier in Hatch.
`campaign_name`	Campaign name.
`current_lead_source`	Source assigned to the contact (e.g., `integration:salesforce`).
`hatch_contact_id`	Unique contact ID from Hatch.
`contact_status`	Campaign engagement status (`In Progress`, `No Reply`, `Replied`, `Canceled`).
`campaign_stage`	Current stage of the campaign workflow.
`sales_value`	Sales amount associated with the contact (if provided).
`opted_out`	Boolean flag showing whether the contact opted out.
`email`	Contact email.
`phone`	Contact phone number.
`updated_at`	Timestamp when the record was last updated.

Contact status definitions

Hatch calculates contact_status values as campaigns progress. Use these labels to group performance inside your BI tools:

In Progress: The contact is actively moving through automated steps and can still receive follow-ups.
No Reply: Automation completed without a response from the contact.
Replied: The contact responded, so the automation ended and the conversation moved to your team.
Canceled: The contact was removed manually or due to rules (invalid info, opt-out, competing campaign, etc.).

Field	Description
`organization_id`	Organization ID tied to the conversation.
`organization_name`	Organization name.
`workspace_id`	Workspace ID.
`workspace_name`	Workspace name.
`id`	Unique identifier for the message.
`conversation_id`	Conversation identifier.
`contact_id`	Contact identifier for the participant.
`actor_type`	Who sent the message (`contact`, `hatch_user`, automated agent, etc.).
`actor_id`	Unique ID for the actor (user/contact/bot).
`category`	Message category (e.g., `sms`, `email`, `call`).
`type`	Message payload type (text, voicemail drop, etc.).
`direction`	Inbound vs. outbound.
`body`	Message body text (if applicable).
`delivery_status`	Latest delivery status from the provider.
`status_history`	Serialized status change history for troubleshooting delivery failures.
`chatbot_disposition`	The disposition a chatbot applied to the overall conversation (same for each conversation item)
`send_at`	Scheduled send time for delayed/scheduled messages.
`is_scheduled`	Indicates whether the item was scheduled.
`provider_name`	External provider handling delivery (e.g., Twilio).
`provider_message_id`	Provider-specific identifier for the message.
`mongo_id`	Unique database source identifier.
`updated_at`	Timestamp when the message item was last updated.