Configure Storeback Attributes

Storeback saves the value that Detect calculates for a derived attribute to a database table, so that a later lookup can read the value back.

Note:
This feature will be available starting with version 26.1.0.IF02

Storeback is an option on a derived attribute in a feed's enrichment settings. When you turn Storeback on, Detect saves the value it calculates for the attribute to a database table. Detect links each row to a key attribute, such as AUDIENCE_KEY or MSISDN, so that a lookup-based enrichment can read the value back later.

Detect writes the value when it processes a feed event. Each stored record has an ATTRIBUTE_NAME, an ATTRIBUTE_VALUE, and an ATTRIBUTE_TYPE column.

To read a stored value back, add a lookup attribute for it: select the Key Attribute and the Lookup Table, then pick the stored attribute from the list. For example, to read back a value that a derived attribute stored, select the same key attribute that the derived attribute used, for example AUDIENCE_KEY, choose UD_PROFILE_STOREBACK as the Lookup Table, and then pick the stored attribute from Lookup Table Attributes. For the general steps, see Configure Enrichments.

Configuring storeback

  1. Go to Aggregates and Enrichments, select a feed, then go to Enrichments
  2. Edit an existing enrichment or Add new enrichment, and got to Derived Attributes and click + Derived Attributes.
  3. Enter an Attribute Name.
  4. Select the Type of Attribute. Storeback works with both types:
    • Expression-based: choose a data type and enter an expression, for example transactionAmount>4000.
    • Enrichment function-based: choose a function and its parameters, for example toUpperCase. You do not need to specify a data type for the storeback attribute; Detect automatically sets it to the return type of the enrichment function.
  5. Set Storeback? to Yes. Three more fields appear:
    • Key Attribute: the ID that the stored value is linked to, for example AUDIENCE_KEY, or CustomerID.
    • Storeback Attribute: enter the storeback attribute name.
  6. Click Add Attribute and save the enrichment.