Attribute lookups
Oracle Audience Segmentation allows you to look up values for non-system attributes with the string or text data type. When Viewing data object records in the Data viewer, this allows you to select attribute values from a list instead of manually entering them. Oracle Audience Segmentation comes with ready-to-use lookups for many attributes.
Attribute lookups are also available when Creating segments. Learn more about Segmentation attribute lookups.
Important: Data that is imported with the Near real-time API can't be used for configuring lookup values. To ensure that data is used for lookup values, use the Streaming API or an ingest job to import the data.
Benefits of using attribute lookups
Enabling lookup for attributes can benefit your organization in the following ways:
-
Optimizes the process of using the Data viewer to view data object records by eliminating the need to manually enter attribute values when setting up filter conditions.
-
By selecting attribute values rather than manually entering them, this eliminates the possibility of a user incorrectly entering an attribute value (entering F instead of Female).
-
Gives you visibility into all available values for an attribute, up to a maximum of 200.
Example: You can use lookup values for the State attribute. You want to view records for residents of Arizona, California, and Florida. When you add the State attribute as a filter, you'll select Matches and use the drop-down list for the attribute's input field to select the three states. This eliminates the need for you to know the exact values (state abbreviations) to successfully retrieve the appropriate records.
Enabling attribute lookups
Review the following for enabling attribute lookups.
-
The attribute must have the string or text data type. Learn more about Data types.
-
You should only enable lookup for attributes with a limited number of unique values, such as Country or State. This is not recommended for attributes with a high number of unique values, such as First name. Enabling lookup for attributes with a high number of unique values can negatively affect the performance of the data warehouse job and the time needed for it to run and complete.
-
To enable lookup for an attribute, follow the steps for Managing attributes and select Enable Lookup. To view this option, you need the Data master or Data engineer User role.
-
After enabling or disabling lookup, you will need to Publish changes and then run the Data warehouse job from the Data feeds page to view the change.
-
When using the Data viewer, lookups are available for the Matches , Does not match, Contains, and Does not contain operators. Learn more about Viewing data object records.
-
The attribute must have a Data density greater than 0%.
After enabling lookup for an attribute:
-
Lookup values will be calculated when the Data warehouse job runs.
-
To ensure quick response time, lookup values are cached for seven days. After seven days, the cache expires.
-
New lookup values will be accessible immediately after the Data warehouse job run.
Segmentation attribute lookups