Incremental Logs let you send Dengage campaign logs, such as send details, delivery and click events, send target lists and control group contacts, to your own database or FTP server on a daily schedule. You set this up with the Data Export node in an Automated Flow. Each log type is a ready-made template with a fixed set of columns, so you do not map columns yourself. The export writes into a table you create in a database that is defined as a Remote Target.
Supported targets are Google BigQuery, Microsoft SQL, PostgreSQL, Oracle, Amazon Redshift, Amazon S3, FTP and any database you can reach through ODBC, such as MySQL.
Key terms
Navigation Path:
Data Space > Data Flow > Automated Flows
Go to Data Space, then click Data Flow, and open the Automated Flows section.
Here, you can create and configure flows that automatically export incremental logs to external databases via Remote Target.
In the Automated Flows section, click New, then select Automated Flow. Enter a name for your flow, optionally add a description and choose a folder, set the Start Date (Now or Scheduled) and End Date (Never or Scheduled), then click Next to continue.
Drag and drop the Recurring trigger onto the Triggers area of the canvas and click it to open Recurring Settings.
Incremental Logs can only be exported with the Recurring trigger and only when Occurs is set to Daily. Within the daily period you choose how often the export runs:
Click OK to save the trigger.

Incremental Logs require a Daily recurring trigger. Choose Occurs once at or Occurs every.
In the Actions section, drag the Data Export node into the flow. This node defines what data will be exported and where it will be sent. Click the node to configure its settings. You can give the node a name in the Action Name field. The configuration has four steps: Target, Settings, Columns and Summary.
In the configuration window, under Select data source, select Incremental Logs. The screen also shows the maximum export size, which is 7168 MB. Click Next.

Select Incremental Logs as the data source.
When you select Incremental Logs, choose the relevant log type under Transactional or Marketing, depending on the data you want to export. Click the eye icon next to a log type to preview the columns it exports and the column types and lengths your table needs. Click Next to proceed.
Transactional log types
| Log type | What it exports |
|---|---|
| Push Events | Push events such as delivered, clicks and more |
| Push Sends | Send details such as content, token, app and more |
| Push Sends with Tags | Push send details with tags |
| Tag Push Events | Tag push events such as delivered, clicks and more |
| Email Events | Email events such as delivered, sent, opens, clicks and more |
| Email Sends | Send details such as from name, from address, subject and more |
| Email Sends with Tags | Email send details with tags |
| Sms Events | SMS events such as delivered, clicks and more |
| Sms Sends | Send details such as content, gsm, sender name and more |
| Sms Sends with Tags | SMS send details with tags |
| Panel Audit Logs | Panel audit logs |
Marketing log types
| Log type | What it exports |
|---|---|
| Email Events / Push Events / Sms Events / Inapp Events / Onsite Events / WhatsApp Events | Channel events such as delivered, sent, opens, clicks and more |
| Sms Events With Gsm | SMS events with the GSM number |
| Email Sends / Push Sends / Sms Sends / Inapp Sends / Onsite Sends / Whatsapp Sends | Send details for each channel, such as content, sender, subject and more |
| Email Send Targets / Push Send Targets / Sms Send Targets / Inapp Send Targets / Onsite Send Targets / Whatsapp Send Targets | The list of contacts targeted by each send |
| Sms Send Targets With Gsm | SMS send targets with the GSM number |
| Campaign Control Group Contacts | Campaign control group contacts (see Exporting Campaign Control Group Info via Incremental Logs) |
| Tags | Send tags information |
| Uninstalled Devices | Uninstalled device information |
Under Marketing, the Whatsapp Send Targets log type exports the list of contacts targeted by each WhatsApp send, including the contact key and the WhatsApp number the message was sent to. This lets you report, per contact, who received which WhatsApp message, as you can already do for Email, Push, SMS, In-App and Onsite sends. See the Whatsapp Send Targets table under Incremental Logs - Column Details for the columns to create in your database.

Pick a log type and use the eye icon to view its required columns.
Under Select Remote Target, pick the target type and then the specific Remote Target you defined earlier. The target types are:
The same steps apply for all supported database types. Click Next.
In the Settings step, tell Dengage where to write the data:
Click Show Columns to see the columns the selected log type will write, and make sure your table matches. You do not enter connection details here; they come from the Remote Target. Click Next.
The Columns step is skipped for Incremental Logs because the columns are fixed by the template.
The Summary step shows the Data source (the log type), the Target type and the Target Name. Check them and click Export to save the node configuration.
To add more log types to the same flow, drag another Data Export node into the step and repeat steps 3 to 8.
Finally, click Set Job as Active to start the schedule, or Save Job as Draft to keep the flow without running it.
Open the flow and switch to the Job History tab to see each run with its Started On and Completed On times and its status (Completed or Error). The Status toggle at the top of the flow shows whether the flow is active.
Can I export Incremental Logs weekly or monthly? No. Incremental Logs only work with a Recurring trigger set to Daily. Use Occurs once at for one run per day, or Occurs every to run several times a day.
Do I need to map columns? No. Each log type has a fixed column set. Create your table with the columns shown in Column Details and the export writes into it.
Where do I enter the database connection details? On the Remote Target itself (see the Remote Targets page). The Data Export node only asks for the schema or dataset and the table name.
Can I export more than one log type in one flow? Yes. Add one Data Export node per log type to the same flow.
Can I export to a file instead of a database? Yes. Choose FTP export as the remote target. See FTP Export Support for Incremental Logs.
Is there a size limit? The maximum export size is 7168 MB per export.
Source: dev.dengage.com