This page lists the columns that each Incremental Logs log type exports. When you export Incremental Logs with the Data Export action in an Automated Flow, Dengage writes the rows to the target table in your database or to the file on your FTP server using exactly these column names, types and lengths. Use this page to create the target tables before you activate the flow.
The log types are grouped the same way as in the app: Transactional log types for transactional sends and events, and Marketing log types for campaign sends, events, send targets, tags, control group contacts and uninstalled devices. For the export steps, see Exporting Incremental Logs to Databases via Remote Target and FTP Export Support for Incremental Logs.
Navigation Path: Data Space > Data Flow > Automated Flows
Go to Data Space, then click Data Flow, and open the Automated Flows section. Open an Automated Flow, add the Data Export action, select Incremental Logs as the data source and click Next. The log types listed on this page appear under the Transactional and Marketing groups on the template selection step. Select the log type you want to export, then continue with the remote target and file settings.
[Image placeholder: Incremental Logs template selection in the Data Export action, Transactional and Marketing groups expanded. Alt text: Incremental Logs template selection in the Data Export action of an Automated Flow, with the Transactional and Marketing groups expanded. Caption: Choose the log type under Transactional or Marketing; the columns for each log type are listed on this page.]
Log types ending with "with Tags" or "With Gsm" contain the same columns as the base log type plus one extra column (tag_string or gsm). Both variants are listed in full below.
Transactional log types cover messages sent through the transactional channels (Email, SMS, Push) and the panel audit log.
Panel Audit Logs: Exports the panel audit logs: each row records a panel action with the user who made it, the request URL, the request and response payloads and the IP address.
| Column Name | Column Type | Column Length |
|---|---|---|
| log_id | STRING | 36 |
| request_time | TIMESTAMP | N/A |
| user_id | INTEGER | N/A |
| user_name | STRING | 150 |
| name | STRING | 400 |
| action_name | STRING | 1000 |
| request_url | STRING | 1000 |
| request_json | STRING | MAX |
| response_json | STRING | MAX |
| ip_address | STRING | 50 |
Email Sends: Exports send details for transactional emails: subject, recipient address, from name, from address, content and whether open and click tracking were enabled.
| Column Name | Column Type | Column Length |
|---|---|---|
| row_id | INTEGER | N/A |
| transaction_id | STRING | 36 |
| group_id | STRING | 36 |
| subject | STRING | 1000 |
| STRING | 255 | |
| content_id | INTEGER | N/A |
| track_open | BOOLEAN | N/A |
| track_click | BOOLEAN | N/A |
| rcpt_type | INTEGER | N/A |
| from_name | STRING | 300 |
| from_address | STRING | 255 |
| created_at | TIMESTAMP | N/A |
| created_by | INTEGER | N/A |
| contents | STRING | MAX |
| is_fallback_message | BOOLEAN | N/A |
Push Sends: Exports send details for transactional push notifications: device token, application, content, request and relay times and fallback channel information.
| Column Name | Column Type | Column Length |
|---|---|---|
| row_id | INTEGER | N/A |
| transaction_id | STRING | 36 |
| token | STRING | 256 |
| app_id | INTEGER | N/A |
| content_id | INTEGER | N/A |
| request_time | TIMESTAMP | N/A |
| relay_time | TIMESTAMP | N/A |
| created_by | INTEGER | N/A |
| contents | STRING | MAX |
| tag_send_id | INTEGER | N/A |
| group_id | STRING | 36 |
| fallback_channel | STRING | 10 |
| fallback_channel_payload | STRING | MAX |
| is_fallback_message | BOOLEAN | N/A |
Email Events: Exports transactional email events, with the recipient address, event type and event date.
| Column Name | Column Type | Column Length |
|---|---|---|
| log_id | INTEGER | N/A |
| group_id | STRING | 36 |
| transaction_id | STRING | 36 |
| STRING | 255 | |
| event_type | STRING | 2 |
| event_date | TIMESTAMP | N/A |
Push Events: Exports transactional push events, with the device token, application, event type, event date and the clicked button.
| Column Name | Column Type | Column Length |
|---|---|---|
| log_id | INTEGER | N/A |
| transaction_id | STRING | 36 |
| token | STRING | 256 |
| app_id | INTEGER | N/A |
| event_type | STRING | 2 |
| event_date | TIMESTAMP | N/A |
| button_id | STRING | 36 |
| tag_send_id | INTEGER | N/A |
| group_id | STRING | 36 |
Sms Events: Exports transactional SMS events, with the phone number, partner message ID, event type, event reason and event date.
| Column Name | Column Type | Column Length |
|---|---|---|
| log_id | INTEGER | N/A |
| transaction_id | STRING | 36 |
| partner_msg_id | STRING | 100 |
| gsm | STRING | 20 |
| event_type | STRING | 2 |
| event_reason | STRING | 100 |
| event_date | TIMESTAMP | N/A |
Sms Sends: Exports send details for transactional SMS messages: phone number, content, partner name, sender name and whether the message was an OTP or a fallback message.
| Column Name | Column Type | Column Length |
|---|---|---|
| row_id | INTEGER | N/A |
| transaction_id | STRING | 36 |
| group_id | STRING | 36 |
| gsm | STRING | 20 |
| content_id | INTEGER | N/A |
| track_click | BOOLEAN | N/A |
| is_otp | BOOLEAN | N/A |
| created_at | TIMESTAMP | N/A |
| created_by | INTEGER | N/A |
| contents | STRING | MAX |
| partner_name | STRING | 50 |
| sender_name | STRING | 100 |
| is_fallback_message | BOOLEAN | N/A |
Tag Push Events: Exports tag push events, with the device token, application, event type, event date and the clicked button.
| Column Name | Column Type | Column Length |
|---|---|---|
| log_id | INTEGER | N/A |
| transaction_id | STRING | 36 |
| token | STRING | 256 |
| app_id | INTEGER | N/A |
| event_type | STRING | 2 |
| event_date | TIMESTAMP | N/A |
| button_id | STRING | 36 |
| tag_send_id | INTEGER | N/A |
| group_id | STRING | 36 |
Email Sends with Tags: Same columns as Email Sends, plus the tag_string column that holds the send tags attached to the message.
| Column Name | Column Type | Column Length |
|---|---|---|
| row_id | INTEGER | N/A |
| transaction_id | STRING | 36 |
| group_id | STRING | 36 |
| subject | STRING | 1000 |
| STRING | 255 | |
| content_id | INTEGER | N/A |
| track_open | BOOLEAN | N/A |
| track_click | BOOLEAN | N/A |
| rcpt_type | INTEGER | N/A |
| from_name | STRING | 300 |
| from_address | STRING | 255 |
| created_at | TIMESTAMP | N/A |
| created_by | INTEGER | N/A |
| contents | STRING | MAX |
| is_fallback_message | BOOLEAN | N/A |
| tag_string | STRING | MAX |
Sms Sends with Tags: Same columns as Sms Sends, plus the tag_string column that holds the send tags attached to the message.
| Column Name | Column Type | Column Length |
|---|---|---|
| row_id | INTEGER | N/A |
| transaction_id | STRING | 36 |
| group_id | STRING | 36 |
| gsm | STRING | 20 |
| content_id | INTEGER | N/A |
| track_click | BOOLEAN | N/A |
| is_otp | BOOLEAN | N/A |
| created_at | TIMESTAMP | N/A |
| created_by | INTEGER | N/A |
| contents | STRING | MAX |
| partner_name | STRING | 50 |
| sender_name | STRING | 100 |
| is_fallback_message | BOOLEAN | N/A |
| tag_string | STRING | MAX |
Push Sends with Tags: Same columns as Push Sends, plus the tag_string column that holds the send tags attached to the message.
| Column Name | Column Type | Column Length |
|---|---|---|
| row_id | INTEGER | N/A |
| transaction_id | STRING | 36 |
| token | STRING | 256 |
| app_id | INTEGER | N/A |
| content_id | INTEGER | N/A |
| request_time | TIMESTAMP | N/A |
| relay_time | TIMESTAMP | N/A |
| created_by | INTEGER | N/A |
| contents | STRING | MAX |
| tag_send_id | INTEGER | N/A |
| group_id | STRING | 36 |
| fallback_channel | STRING | 10 |
| fallback_channel_payload | STRING | MAX |
| is_fallback_message | BOOLEAN | N/A |
| tag_string | STRING | MAX |
Marketing log types cover campaign sends and events for Email, Push, SMS, In-App, Onsite and WhatsApp, the contacts targeted by each send, send tags, campaign control group contacts and uninstalled devices.
Campaign Control Group Contacts: Exports the contacts that were placed in a campaign's control group, with the job, flow type, send ID and the campaign's start and end dates. For how to use this log type, see Exporting Campaign Control Group Info via Incremental Logs.
| Column Name | Column Type | Column Length |
|---|---|---|
| job_id | INTEGER | N/A |
| job_name | STRING | 100 |
| flow_type | STRING | 20 |
| send_id | INTEGER | N/A |
| public_id | STRING | |
| contact_key | STRING | 255 |
| STRING | 255 | |
| gsm | STRING | 20 |
| start_date | TIMESTAMP | N/A |
| end_date | TIMESTAMP | N/A |
| created_at | TIMESTAMP | N/A |
Onsite Events: Exports onsite events, with the event type, event date, IP address and the device, OS and browser details.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| log_id | INTEGER | N/A |
| event_date | TIMESTAMP | N/A |
| event_type | STRING | 2 |
| ip_address | STRING | 50 |
| device_type | STRING | 100 |
| device | STRING | 100 |
| device_brand | STRING | 100 |
| device_model | STRING | 100 |
| os | STRING | 100 |
| os_version | STRING | 100 |
| browser | STRING | 100 |
Tags: Exports the send tag definitions: tag ID, name, category and who created or last updated each tag and when.
| Column Name | Column Type | Column Length |
|---|---|---|
| tag_id | INTEGER | N/A |
| tag_name | STRING | 100 |
| tag_category | STRING | 15 |
| created_at | TIMESTAMP | N/A |
| created_by | INTEGER | N/A |
| updated_at | TIMESTAMP | N/A |
| updated_by | INTEGER | N/A |
Email Send Targets: Exports the list of contacts targeted by each email send: the send (msg_id), the contact key and the time the target row was created.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| contact_key | STRING | 255 |
| created_at | TIMESTAMP | N/A |
Push Send Targets: Exports the list of contacts and devices targeted by each push send: the send (msg_id), the device application, the device ID and the contact key.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| device_app | STRING | 100 |
| device_id | STRING | 100 |
| contact_key | STRING | 255 |
| created_at | TIMESTAMP | N/A |
Sms Send Targets: Exports the list of contacts targeted by each SMS send: the send (msg_id), the contact key and the time the target row was created.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| contact_key | STRING | 255 |
| created_at | TIMESTAMP | N/A |
Whatsapp Send Targets: Exports the list of contacts targeted by each WhatsApp send: the send (msg_id), the contact key and the WhatsApp number the message was sent to.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| contact_key | STRING | 255 |
| whatsapp_number | STRING | 20 |
| created_at | TIMESTAMP | N/A |
Email Sends: Exports one row per email send with its name, status, type, delivery date, the selected, prepared, relayed and blacklisted counts, the campaign it belongs to and its tags.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| name | STRING | 150 |
| status | STRING | 15 |
| type | STRING | 10 |
| delivery_date | TIMESTAMP | N/A |
| selected_count | INTEGER | N/A |
| prepared_count | INTEGER | N/A |
| relayed_count | INTEGER | N/A |
| blacklisted_count | INTEGER | N/A |
| campaign_id | STRING | 36 |
| campaign_name | STRING | 100 |
| campaign_type | STRING | 20 |
| tag_string | STRING | MAX |
Push Sends: Exports one row per push send with its name, status, type, delivery date, the selected, prepared, relayed and blacklisted counts, the campaign it belongs to and its tags.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| name | STRING | 150 |
| status | STRING | 15 |
| type | STRING | 10 |
| delivery_date | TIMESTAMP | N/A |
| selected_count | INTEGER | N/A |
| prepared_count | INTEGER | N/A |
| relayed_count | INTEGER | N/A |
| blacklisted_count | INTEGER | N/A |
| campaign_id | STRING | 36 |
| campaign_name | STRING | 100 |
| campaign_type | STRING | 20 |
| tag_string | STRING | MAX |
Sms Sends: Exports one row per SMS send with its name, status, type, delivery date, the selected, prepared, relayed and blacklisted counts, the campaign it belongs to and its tags.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| name | STRING | 150 |
| status | STRING | 15 |
| type | STRING | 10 |
| delivery_date | TIMESTAMP | N/A |
| selected_count | INTEGER | N/A |
| prepared_count | INTEGER | N/A |
| relayed_count | INTEGER | N/A |
| blacklisted_count | INTEGER | N/A |
| campaign_id | STRING | 36 |
| campaign_name | STRING | 100 |
| campaign_type | STRING | 20 |
| tag_string | STRING | 10 |
Email Events: Exports marketing email events, with the device, OS and browser details and the bounce code and bounce text for bounced messages.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| log_id | INTEGER | N/A |
| event_date | TIMESTAMP | N/A |
| event_type | STRING | 2 |
| ip_address | STRING | 50 |
| device_type | STRING | 100 |
| device | STRING | 100 |
| device_brand | STRING | 100 |
| device_model | STRING | 100 |
| os | STRING | 100 |
| os_version | STRING | 100 |
| browser | STRING | 100 |
| bounce_code | STRING | 11 |
| bounce_text | STRING | 1024 |
Push Events: Exports marketing push events, with the device, OS and browser details and the bounce text and bounce category for failed deliveries.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| log_id | INTEGER | N/A |
| event_date | TIMESTAMP | N/A |
| event_type | STRING | 2 |
| ip_address | STRING | 50 |
| device_type | STRING | 100 |
| device | STRING | 100 |
| device_brand | STRING | 100 |
| device_model | STRING | 100 |
| os | STRING | 100 |
| os_version | STRING | 100 |
| browser | STRING | 100 |
| bounce_text | STRING | 1024 |
| bounce_category | STRING | 11 |
Sms Events: Exports marketing SMS events, with the event type, event date and the bounce text for failed deliveries.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| log_id | INTEGER | N/A |
| event_date | TIMESTAMP | N/A |
| event_type | STRING | 2 |
| bounce_text | STRING | 100 |
Inapp Events: Exports in-app events, with the event type, event date, IP address and the device, OS and browser details.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| log_id | INTEGER | N/A |
| event_date | TIMESTAMP | N/A |
| event_type | STRING | 2 |
| ip_address | STRING | 15 |
| device_type | STRING | 100 |
| device | STRING | 100 |
| device_brand | STRING | 100 |
| device_model | STRING | 100 |
| os | STRING | 100 |
| os_version | STRING | 100 |
| browser | STRING | 100 |
Inapp Sends: Exports one row per in-app send with its name, status, type, delivery date, the selected, prepared, relayed and blacklisted counts, the campaign it belongs to and its tags.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| name | STRING | 150 |
| status | STRING | 15 |
| type | STRING | 10 |
| delivery_date | TIMESTAMP | N/A |
| selected_count | INTEGER | N/A |
| prepared_count | INTEGER | N/A |
| relayed_count | INTEGER | N/A |
| blacklisted_count | INTEGER | N/A |
| campaign_id | STRING | 36 |
| campaign_name | STRING | 100 |
| campaign_type | STRING | 20 |
| tag_string | STRING | MAX |
Onsite Sends: Exports one row per onsite send with its name, status, type, delivery date, the selected, prepared, relayed and blacklisted counts, the campaign it belongs to and its tags.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| name | STRING | 150 |
| status | STRING | 15 |
| type | STRING | 10 |
| delivery_date | TIMESTAMP | N/A |
| selected_count | INTEGER | N/A |
| prepared_count | INTEGER | N/A |
| relayed_count | INTEGER | N/A |
| blacklisted_count | INTEGER | N/A |
| campaign_id | STRING | 36 |
| campaign_name | STRING | 100 |
| campaign_type | STRING | 20 |
| tag_string | STRING | MAX |
Inapp Send Targets: Exports the list of contacts targeted by each in-app send: the send (msg_id), the contact key and the time the target row was created.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| contact_key | STRING | 255 |
| created_at | TIMESTAMP | N/A |
Onsite Send Targets: Exports the list of contacts targeted by each onsite send: the send (msg_id), the contact key and the time the target row was created.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| contact_key | STRING | 255 |
| created_at | TIMESTAMP | N/A |
Sms Send Targets With Gsm: Same as Sms Send Targets, plus the gsm column that holds the phone number the SMS was sent to.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| contact_key | STRING | 255 |
| gsm | STRING | 20 |
| created_at | TIMESTAMP | N/A |
Whatsapp Events: Exports WhatsApp events with the event type, event date and the bounce text and bounce category for failed deliveries.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| log_id | INTEGER | N/A |
| event_date | TIMESTAMP | N/A |
| event_type | STRING | 2 |
| bounce_text | STRING | 1024 |
| bounce_category | STRING | 11 |
Sms Events With Gsm: Same as Sms Events, plus the gsm column that holds the phone number the event belongs to.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| msg_id | INTEGER | N/A |
| log_id | INTEGER | N/A |
| event_date | TIMESTAMP | N/A |
| event_type | STRING | 2 |
| bounce_text | STRING | 100 |
| gsm | STRING | 20 |
Whatsapp Sends: Exports one row per WhatsApp send with its name, status, type, delivery date, the selected, prepared, relayed and blacklisted counts, the campaign it belongs to and its tags.
| Column Name | Column Type | Column Length |
|---|---|---|
| id | STRING | 36 |
| id_int | INTEGER | N/A |
| name | STRING | 150 |
| status | STRING | 15 |
| type | STRING | 10 |
| delivery_date | TIMESTAMP | N/A |
| selected_count | INTEGER | N/A |
| prepared_count | INTEGER | N/A |
| relayed_count | INTEGER | N/A |
| blacklisted_count | INTEGER | N/A |
| campaign_id | STRING | 36 |
| campaign_name | STRING | 100 |
| campaign_type | STRING | 20 |
| tag_string | STRING | MAX |
Uninstalled Devices: Exports the devices that uninstalled your application, with the uninstall date, device and token details, app and SDK versions, permissions, last activity date, time zone, language and country.
| Column Name | Column Type | Column Length |
|---|---|---|
| uninstall_date | TIMESTAMP | N/A |
| device_id_int | INTEGER | N/A |
| device_id | STRING | 100 |
| contact_key | STRING | 255 |
| token_status | STRING | 1 |
| token_permission | BOOLEAN | N/A |
| app_id | INTEGER | N/A |
| device_type | STRING | 1 |
| device_brand | STRING | 100 |
| device_model | STRING | 100 |
| device_name | STRING | 150 |
| carrier_name | STRING | 255 |
| os_version | STRING | 100 |
| app_version | STRING | 100 |
| sdk_version | STRING | 20 |
| browser | STRING | 100 |
| last_activity_date | TIMESTAMP | N/A |
| is_token_engaged | BOOLEAN | N/A |
| tracking_permission | BOOLEAN | N/A |
| token_type | STRING | 1 |
| timezone | STRING | 100 |
| language | STRING | 20 |
| country | STRING | 50 |
| token | STRING | 256 |
Source: dev.dengage.com