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.
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
- Go to Aggregates and Enrichments, select a feed, then go to Enrichments
- Edit an existing enrichment or Add new enrichment, and got to Derived Attributes and click + Derived Attributes.
- Enter an Attribute Name.
- 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.
- Expression-based: choose a data type and enter an expression, for example
- Set Storeback? to Yes. Three more fields appear:
- Key Attribute: the ID that the stored value is linked to, for example
AUDIENCE_KEY, orCustomerID. - Storeback Attribute: enter the storeback attribute name.
- Key Attribute: the ID that the stored value is linked to, for example
- Click Add Attribute and save the enrichment.