Incremental query incremental-query
Description description
The Incremental query activity allows you to filter and extract a population of elements from the ÃÛ¶¹ÊÓƵ Campaign database. Each time this activity is executed, the results from the previous executions are excluded. This allows you to target only new elements.
You can define Additional data for the targeted population via a dedicated tab. This data is stored in additional columns and can only be used for the workflow in progress.
The activity uses the query editor tool. This tool is detailed in a dedicated section.
Context of use context-of-use
An Incremental query has to be linked to a Scheduler in order to define the execution frequency of the workflow, and therefore the query.
The Processed data tab, which is specific to this activity, allows you to view any results of the activity’s previous executions, if required.
The Incremental query activity can be used for various types of uses:
-
Segmenting individuals to define the target of a message, audience, etc.
-
Exporting data.
You can use an Incremental query activity to regularly export new logs in files. It can be useful for example if you want to use your log data in external reporting or BI tools. A complete example is available in the Exporting logs section.
Related topics
Configuration configuration
-
Drag and drop an Incremental query activity into your workflow.
-
Select the activity, then open it using the
-
If you would like to run a query on a resource other than the profile resource, go to the activity’s Properties tab and select a Resource and a Targeting dimension.
The Resource allows you to refine the filters displayed in the palette whereas the Targeting dimension, contextual with regard to the resource selected, corresponds to the type of population that you would like to obtain (identified profiles, deliveries, data linked to the selected resource, etc.).
-
In the Target tab, run your query by defining and combining rules.
-
In the Processed data tab, choose the incremental mode you want to use for the next executions of the workflow:
-
Use the exclusion of the results of previous executions: the results of previous executions for each new execution are excluded.
-
Use a date field: the next executions only take into account the results having the selected date field greater or equal to the last execution date of the Incremental query activity. You can select any date field pertaining to the resource selected in the Properties tab. This mode has better performance when querying large resources such as log data.
After the first execution of the workflow, you can see in this tab the last execution date that will be used for the next execution. It is automatically updated every time the workflow is executed. You still have the possibility to override this value by manually entering a new one so that it fits your needs.
note note NOTE The Use a date field mode allows more flexibility depending on the date field that is selected. For example, if the selected field corresponds to a modification date, the date field mode will allow you to retrieve data that were recently updated, while the other mode will simply exclude recordings that were already targeted in a previous execution, even if they have been modified since the last execution of the workflow. 
-
-
You can define Additional data for the targeted population via a dedicated tab. This data is stored in additional columns and can only be used for the workflow in progress. In particular, you can add data from the ÃÛ¶¹ÊÓƵ Campaign database tables linked to the query’s targeting dimension. Consult the Enriching data section.
-
Confirm the configuration of your activity and save your workflow.
Enriching data enriching-data
Just as for a query, you can enrich the data from an Incremental query. Consult the Enriching data section.