Incremental Logs - Column Details

Incremental Logs - Column Details

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.

How to Access

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.]

How to Use This Page

  1. Find the log type you selected in the Data Export action. The headings on this page use the same names and the same groups (Transactional, Marketing) as the app.
  2. Create the target table in your database with the columns in that log type's table. Keep the column names as listed and choose a data type in your database that matches the Column Type and Column Length.
  3. Activate the flow. Each run writes the rows for that log type to the target table.

How to read the tables

  • Column Name is the exact name Dengage writes. Use it as the column name in your target table.
  • Column Type is the data type of the exported value: STRING (text), INTEGER (whole number), BOOLEAN (true/false) or TIMESTAMP (date and time). Map each one to the matching type in your database.
  • Column Length is the maximum number of characters a STRING value can have. MAX means the value has no fixed limit, so use your database's largest text type for that column (for example, message contents and JSON payloads). N/A means the type has no length (INTEGER, BOOLEAN and TIMESTAMP columns).
  • If you export the same log type to more than one target, create the table with the same structure in each target.

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

Transactional log types cover messages sent through the transactional channels (Email, SMS, Push) and the panel audit log.

Panel Audit Logs

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

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
email 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

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

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
email STRING 255
event_type STRING 2
event_date TIMESTAMP N/A

Push Events

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

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

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

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

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
email 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

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

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

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

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
email STRING 255
gsm STRING 20
start_date TIMESTAMP N/A
end_date TIMESTAMP N/A
created_at TIMESTAMP N/A

Onsite Events

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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