Interact | profile | Audience Levels | [AudienceLevelName] | Offers by Raw SQL
This set of configuration properties enables you to define the table names required for additional Interact features. You are only required to define the table name if you are using the associated feature.
enableOffersByRawSQL
- Description
If set to True, Interact enables the offersBySQL feature for this audience level that allows you to configure SQL code to be executed to create a desired set of candidate offers at runtime.. If False, Interact does not use the offersBySQL feature.
If you set this property to true, you may also configure the Interact | profile | Audience Levels | (Audience Level) | Offers by Raw SQL | SQL Template property to define one or more SQL templates.
- Default value
False
- Valid Values
True | False
cacheSize
- Description
Size of cache used to store results of the OfferBySQL queries. Note that using a cache may have negative impact if query results are unique for most sessions.
- Default value
-1 (off)
- Valid Values
-1 | Value
cacheLifeInMinutes
- Description
If the cache is enabled, this indicates the number of minutes before the system will clear the cache to avoid staleness.
- Default value
-1 (off)
- Valid Values
-1 | Value
defaultSQLTemplate
- Description
The name of the SQL template to use if one is not specified via the API calls.
- Default value
None
- Valid Values
SQL template name