Split split

A Split-type activity lets you split a target into several subsets. The target is constructed with all the received results: all previous activities must thus have finished in order for this activity to be executed.

This activity does not trigger a union of inbound populations. If several transitions land in one split activity, we recommend inserting a Union activity in front of it.

NOTE
Split operations cannot be performed for tables that have different sources. For this purpose, you need to add an Enrichment activity before the Split activity.
  • For an example of the split activity being used, refer to this section.
  • An example illustrating how to use the Split activity to segment the target into different populations using filtering conditions is described in this section.
  • An example showing how to use an instance variable in a Split activity is available in this section.

To configure this activity, define the subset content and label in the Subsets tab, then choose the target dimension in the General tab.

Create subsets create-subsets

To create a subset:

  1. Click the label in the matching field and select the filter to apply.

  2. To filter the inbound population, select the Add a filtering condition option and click the Edit… link.

    Select the type of filter to be applied to the data to include it in this set.

    The process is the same as for a Query-type activity.

    note note
    NOTE
    You can filter the data in a maximum of two external databases (FDA).
  3. You can specify the maximum number of records to be extracted from the target to create the subset. To do this, check the Limit the selected records option and click the Edit… link.

    A wizard lets you choose the selection mode for records of this subset. Learn more.

  4. If you wish, you can add other subsets using the Add button.

    note note
    NOTE
    If the Enable overlapping of output populations option is not checked, subsets are created in the order of the tabs. Use the arrows in the upper right-hand section of this window to move them. If the first subset recovers 70% of the initial population, for example, then the next subset will apply its selection criteria only to the remaining 30%, and so on.

    For each subset created, an outbound transition will be added to the split activity.

    You can choose to generate a single outbound transition (and identify sets using the segment code, for example): to do this, select the Generate subsets in the same table option in the General tab.

    If it is completed, the segment code of each subset is automatically stored in an additional column. This column will be accessible in the personalization fields at delivery level.

Limit the number of subset records limit-the-number-of-subset-records

If you do not wish to use the entire population contained in a subset, you can limit the number of records it will contain.

  1. In the subset edit window, check the Limit the selected records option and click the Edit… link.

  2. Select the limit type for your choice:

    • Activate random sampling: this option takes a random sample of the records. The type of random sampling applied depends on the database engine.

    • Keep only the first records after sorting: this option lets you define a limitation based on one or more sorting orders. If you select the Age field as a sorting criterion and 100 as the limit, only the youngest 100 recipients will be kept.

    • Keep the first ones after sorting (criteria, random): This option combines the two previous options. It lets you define a limitation based on one or more sorting orders then apply a random selection on the first records if some of the records have the same values as the defined criteria.

      For example, if you select the Age field as a sorting criteria, and you then define a limit of 100, but the 2000 youngest recipients in the database are all 18, then 100 recipients will be randomly selected out of those 2000.

  3. If you wish to define sorting criteria, an additional step lets you define the columns and the sorting order.

  4. Then choose the data limitation method.

    There are several ways of doing this:

    • Size (in %): a percentage of records. For example, the configuration below extracts 10% of the total population.

      The percentage applies to the initial population, not the result of the activity.

    • Size (as a % of the segment): a percentage of records relating only to the subsets and not to the initial population.

    • Maximum size: a maximum number of records.

    • By data grouping: you can set a limit on the number of records depending on the values in a specified field of the inbound population. Learn more.

    • By data grouping (in %): you can set a limit on the number of records depending on the values in a specified field of the inbound population using a percentage. Learn more.

    • By data distribution: If your grouping fields have too many values or if you want to avoid entering the values again for each new split activity, Adobe Campaign lets you configure a By data distribution limitation (optional Distributed Marketing module). Learn more.

  5. Click Finish to approve the record selection criteria. The defined configuration is then displayed in the middle window of the editor.

Limit the number of subset records by data grouping limit-the-number-of-subset-records-by-data-grouping

You can limit the number of records by data grouping. This limit can be carried out using a fixed value or a percentage.

For instance, if you select the Language field as a group field, you can define a list of records for each language.

  1. After selecting the data limitation values, select By data grouping or By data grouping (as a %) and click Next.

  2. Then select the grouping field(s) (the Language field for instance) and click Next.

  3. Finally, specify the data grouping thresholds (using the fixed values or percentages depending on the previously selected grouping method). To set the same threshold for every value, for example if you wish to set the number of records for each language to 10, select the All data groupings are the same size option. To set a different limit for every value, select the Limitations by grouping value option. This will allow you to choose a different limitation for English, French, etc.

  4. Click Finish to approve the limitation and return to editing the split activity.

Limit the number of subset records per data distribution limit-the-number-of-subset-records-per-data-distribution

If your grouping fields contain too large a number of values or if you want to avoid resetting values for every new split activity, Adobe Campaign lets you create a limitation per data distribution. When selecting data limitation values section), select the By data distribution option and select a template from the drop-down menu. Creating a data distribution template is demonstrated below.

For an example of the Local approval activity with a distribution template, refer to this page.

CAUTION
This function is only available with the Distributed Marketing add-on. Please check your license agreement.

The data distribution template lets you limit the number of records using a list of grouping values. To create a data distribution template, apply the following steps:

  1. To create the data distribution template, go to the Resources > Campaign management > Data distribution node and click New.

  2. The General tab lets you enter the label and the execution context of the distribution (targeting dimension, distribution field).

    The following fields need to be entered:

    • Label: label for the distribution template.

    • Targeting dimension: enter the targeting dimension to which the data distribution will be applied, Recipient for instance. This schema must always be compatible with the data used in the targeting workflow.

    • Distribution field: select a field via the targeting dimension. For instance, if you select the Email domain field, the list of recipients will be broken down by domain.

    • Distribution type: select the way the limitation value of the target will be broken down in the Distribution tab: Percentage or Set.

    • Approval storage: if you use a Local approval activity in your targeting workflow, enter the schema in which the approval results will be stored. You must specify one storage schema per targeting schema. If you use the Recipients targeting schema, enter the default Local approval of recipients storage schema.

      In case of a simple limitation by data grouping without local approval, you do not need to enter the Approvals storage field.

  3. If you are using a Local approval activity, enter the Advanced settings for the distribution template:

    The following fields need to be entered:

    • Approve targeted messages: check this option if you want all recipients to be pre-selected from the list of recipients to approve. If this option is unchecked, no recipient will be pre-selected.

      note note
      NOTE
      This option is checked by default.

    • Delivery label: lets you define an expression to display the delivery label in the return notification. The default expression provides information on the standard label of the delivery (compute string). You can modify this expression.

    • Grouping field: this field lets you define the grouping used to display recipients in approval and return notifications.

    • Web Interface: lets you link a web application to the recipient list. In the approval and return notification, each recipient will be clickable and will link to the selected web application. The Parameters field (for example recipientId) lets you configure the additional parameter to be used in the URL and the web application.

  4. The Breakdown tab lets you define the list of distribution values.

    • Value: enter the distribution values.

    • Percentage / Set: enter the record limit (fixed or percentage) linked to each value.

      This column is defined by the Distribution type field within the General tab.

    • Label: enter the label linked to each value.

    • Group or operator: if you are using aLocal approval activity, select the operator or group of operators assigned to each distribution value.

      In case of a simple limitation by data grouping without local approval, you do not need to enter the Group or operator field.

      note caution
      CAUTION
      Make sure the operators have been assigned the appropriate permissions.

Filtering parameters filtering-parameters

Click the General tab to enter the activity label. Select the target and filter dimensions for this split. If necessary, you can change these dimensions for a given subset.

Check the Generate complement option if you wish to exploit the remaining population. The complement is the inbound target minus the union of the subsets. An additional outbound transition will then be added to the activity, as follows:

For this option to work correctly, the inbound data must have a primary key.

For example, if the data is read directly from an external database such as Netezza (which does not support the notion of an index) via a Data loading (RDBMS) activity, the complement generated by the Split activity will be incorrect.

To avoid this, you can drag and drop an Enrichment activity just before the Split activity. In the Enrichment activity, check the Keep all additional data from the main set and specify in the additional data the columns that you want to use for configuring the filters of the Split activity. The data from the inbound transition of the Split activity are then stored locally in a temporary table on the Adobe Campaign server and the complement can be generated correctly.

The Enable overlapping of output populations option lets you manage populations belonging to several subsets:

  • When the box isn’t checked, the split activity makes sure a recipient cannot be present in several output transitions, even if it meets the criteria of several subsets. They will be in the target of the first tab with matching criteria.
  • When the box is checked, the recipients can be found in several subsets if they meet their filter criteria. Adobe Campaign recommends using exclusive criteria.

Input parameters input-parameters

  • tableName
  • schema

Each inbound event must specify a target defined by these parameters.

Output parameters output-parameters

  • tableName
  • schema
  • recCount

This set of three values identifies the target resulting from the exclusion. tableName is the name of the table that records the target identifiers, schema is the schema of the population (usually nms:recipient) and recCount is the number of elements in the table.

The transition associated with the complement has the same parameters.

recommendation-more-help
cffff7e4-091f-472e-87ca-52087599f99d