Close.io (v2017-03-01)

activities & Nested Structures

This table contains nested structures. If you use a data warehouse that doesn't natively support nested structures, some of the attributes listed below may be in a subtable.

These items are marked with a *

Activity Types & Subtables

Depending on the type of activity - EmailThread, for example - you may see subtables, as these record types contain nested data structures.

Append-Only Replication

This table is Append-Only. Whenever an existing row is updated, it will be appended to the end of the table as a new row.

activities Attributes

While we try to include everything Close.io has here, this may not be a full list of attributes. Refer to Close.io's documentation for a full list and description of each attribute.

• Activity ID (id)

• envelope

• properties*

• message_id

• sender*

• date

• subject

• is_autoreply

• from*

• bcc*

• reply_to

• to*

• in_reply_to*

• date_created

• references*

• body_text_quoted*

• need_smtp_credentials

• in_reply_to_id

• updated_by_name

• old_status_label

• transferred_from

• user_id

• updated_by

• cc*

• opportunity_value

• task_assigned_to

• created_by

• status

• email_account_id

• template_id

• transferred_to

• attachments*

• message_ids*

• voicemail_duration

• local_phone

• body_html_quoted*

• opens*

• task_id

• lead_id

• task_assigned_to_name

• body_text

• thread_id

• task_text

• user_name

• note

• source

• import_id

• to*

• recording_url

• date_scheduled

• subject

• body_preview

• created_by_name

• phone

• sender

• duration

• date_sent

• _type

• new_status_label

• opportunity_value_formatted

• opportunity_id

• opens_summary

• new_status_type

• remote_phone

• new_status_id

• contact_id

• body_html

• opportunity_date_won

• opportunity_value_currency

• old_status_type

• bcc*

• organization_id

• old_status_id

• opportunity_confidence

• date_updated

• template_name

• opportunity_value_period

• voicemail_url

• send_attempts *

• direction