Placeholder attribute information
Overview
This document explains the different placeholders that have been configured within RPI and how they can be used within selection rules.
The list of placeholders can and will change over time.
About placeholder attributes
Placeholder attributes can be used for two purposes in selection rules:
The primary use case is to use a placeholder attribute as the comparison attribute when creating a compare to attribute criterion. You can then specify a value for the placeholder attribute using the Attribute Placeholders dialog.
The secondary use case is to create a criterion within a selection rule based on a placeholder attribute, and then use the value provided for the placeholder attribute to activate or deactivate an 'OR' statement within the rule.
In both cases, if a selection rule contains placeholder attributes, the Attribute Placeholders dialog can be used at the audience, cell list, and interaction designers to provide placeholder values to use during audience or interaction workflow execution.
Pre-created placeholder attributes
Offer history placeholder attributes
There are a set of placeholder (PH) attributes that have been created to be used in queries that are going against the Offer History (OH) table for either selection or suppression rules. These placeholder attributes are located in RPI/Attributes/Placeholders/Offer History.
PH Offer Activity Name Target: Used for selection based on the Offer Activity Name within Offer History from a previous campaign run.
PH Offer Activity Name Suppression: Used for suppression based on the Offer Activity Name within Offer History from a previous campaign run.
PH OH Start Minutes - Target: Used for a selection rule to select a start time to select records from Offer History for a previously run campaign.
PH OH End Minutes - Target: Used for a selection rule to select an end time to select records from Offer History for a previously run campaign.
PH OH Start Minutes - Suppression: Used for a suppression rule to select a start time to select records from Offer History for a previously run campaign.
PH OH End Minutes - Suppression: Used for a suppression rule to select an end time to select records from Offer History for a previously run campaign.
Lookup table placeholder attributes
This group of placeholder attributes have been created from the different look up tables within the data model. Each of the tables associated with the placeholders will need to be joined to the audience definitions with RPI as they are available. All of these placeholder attributes are derived from a value list using the associated database table.
PH Account Type Code - Account Type Lookup Table
PH Business Unit Code - Business Unit Lookup Table
PH Channel Code - Channel Lookup Table
PH Currency Code - Currency Lookup Table
PH Customer Profile Type Code - Customer Profile Type Lookup Table
PH Event Disposition Code - Event Disposition Lookup Table
PH Geo Region Code - Geo Region Lookup
PH Individual Profile Type Code - Individual Profile Type Lookup
PH Language Code - Language Lookup Table
PH Location Status Code - Location Status Lookup Table
PH Location Type Code - Location Type Lookup Table
PH Loyalty Account Tier Code - Loyalty Account Tier Lookup
PH Payment Type Code - Payment Type Lookup
PH Product Category Code - Product Category Lookup
PH Product Status Code - Product Status Lookup
PH Shipping Type Code - Shipping Type Lookup
PH Transaction Status Detail Code - Transaction Status Detail Lookup
PH Transaction Type Code - Transaction Type Lookup
PH ISO 2 Country Code - Country Lookup
Common placeholders attributes
PH ID: Used for a selection rule to select a given ID within the database using an integer value.
PH String ID: Used for a selection rule to select a given ID within the database using a string value.