Oracle® CRM On Demand Marketing Release 5.4.10 |
|
Previous |
Next |
Home > User Guide > Configuring and Administeri... > Configuring Lead Management... > Configuring Derived Attribu...
To configure derived attributes, you have the option of uploading lookup tables or defining derived attribute rules. To determine which method works the best for your situation, see Configuring Derived Attribute Lookups.
To configure a derived attribute rule
Click Admin in the upper-right corner of the screen.
In the Response Management section, click Derived Attribute Rules.
Click New Rule.
There are two ways to derive attribute values: lookup-based and set absolute value.
This rule means: derive the value of attribute X (ZIP or postal code) by looking up attribute Y (city) in the key of a lookup table. For more information on uploading a lookup table, see Configuring Derived Attribute Lookups.
For example, the lookup table for cities and their postal codes in USA might be as follows.
Key | Value |
---|---|
Abbeville | 36310 |
Abernant | 35440 |
Adamsville | 35005 |
Addison | 35540 |
This rule means: set the value of attribute X as a static value that you define in a rule based on another attribute.
For both of the previous examples, you can specify additional conditions that have to be evaluated before deriving the value. The values are derived only if the conditions are true. Conditions are defined using a condition builder, in the same way when defining target list conditions.
To define conditions
Select the profile, profile attributes, and operators from the lists.
Under the Value section, enter the value, and click Save.
If a prospect is associated with an account, and if Sales is in the final stages of closing an opportunity, then you might want to set the Hands off Attribute value to True whenever XYZ Company is listed in the contact record.
To derive the insight category attribute, District, from the demographic category, Country, create a lookup table, such as the following:
Key | Value |
---|---|
Colombia | South America |
Venezuela | South America |
Peru | South America |
Argentina | South America |
You can also accomplish the same derived attribute by defining a rule.
To define an insight category by defining a rule
Define an insight attribute for District.
You can edit, delete or copy a rule by clicking the appropriate icon.
A rule cannot be deleted if it is active. First it must be deactivated and then deleted.