The Incremental query activity allows you to filter and extract a population of elements from the Adobe 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.
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.
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 Processed data tab, choose the incremental mode you want to use for the next executions of the workflow:
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.
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 Adobe Campaign database tables linked to the query's targeting dimension. Consult the Enriching data section.
Just as for a query, you can enrich the data from an Incremental query . Consult the Enriching data section.
The following example shows the configuration of an Incremental query activity which filters the profiles in the Adobe Campaign database that are subscribed to the Running Newsletter service, to send them a welcome email containing a promo code.
An Email delivery activity. The workflow is executed once a week, but you can aggregate the emails sent and the results per month, for example to generate reports over a period of an entire month and not just a single week.
To do this, choose to create a Recurring email here regrouping the emails and the results By month .
Then start the workflow execution. Each week the new subscribers will receive the welcome email with the promo code.
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.