Global offer table
The global offer table must exist in your profile database. You can create the global offer table, UACI_DefaultOffers by running the aci_usrtab SQL script against your profile database.
The aci_usrtab SQL script is located in the ddl directory in your runtime environment installation directory .
You must define the AudienceLevel, and OfferCode1 fields for each row. The other fields are optional to constrain your offer assignments further or influence the built-in learning at the audience level.
For best performance, you should create an index on this table on the audience level column.
Name | Type | Description |
---|---|---|
AudienceLevel | varchar(64) | (Required) The name of the audience level you assign the default offer to, for example, customer or household. This name must match the audience level as defined in Unica Campaign. |
OfferCode1 |
varchar(64) |
(Required) The offer code for the default offer. If your offer codes are made of multiple fields, you can add the additional columns, for example OfferCode2 and so on. If you are adding this offer to provide a global offer assignment, you must add this offer to the UACI_ICBatchOffers table. |
Score | float | A number to define the marketing score for this offer assignment. |
OverrideTypeID |
int |
If set to 1, if the offer does not exist in the candidate list of offers, add this offer to the list as well as using any score data for the offer. In general, use 1 to provide global offer assignments. If set to 0, null, or any number other than 1, use any data for the offer only if the offer exists in the candidate list of offers. In most cases, a treatment rule or individual assignment will override this setting. |
Predicate |
varchar(4000) |
You can enter expressions in this column as for advanced options for treatment rules. You can use the same variables and macros available to you when writing advanced options for treatment rules. The behavior of this column depends on the value in the EnableStateID column.
Note: To assign score to an offer, the following sequence is considered.
If you want to assign score from the predicate column, then you must leave the score column as null. |
FinalScore | float | A number to override the final score used to order the final list of returned offers. This column is used if you have enabled the built-in learning module. You can implement your own learning to use this column. |
CellCode |
varchar(64) |
The cell code for a deployed interactive segment to which you want to assign this default offer. If your cell codes are made of multiple fields, you can add the additional columns. You must provide a cell code if OverrideTypeID is 0 or null. If you do not include a cell code, the run time environment ignores this row of data. If the OverrideTypeID is 1, you do not have to provide a cell code in this column. If you do not provide a cell code, the runtime environment uses the cell code defined in the DefaultCellCode property for this audience level and table for reporting purposes. |
Zone | varchar(64) | The name of the zone to which you want this offer assignment to apply. If NULL, this applies to all zones. |
EnableStateID |
int |
The value in this column defines the behavior of the Predicate column.
Any row where this column is Null or any value other than 2 or 3 ignores the Predicate column. |
LikelihoodScore | float | This column is used only to influence built-in learning. You can add this column with the aci_scoringfeature ddl. |
AdjExploreScore | float | This column is used only to influence built-in learning. You can add this column with the aci_scoringfeature ddl. |
Suppression Count | int | This field is for Exclusive offer suppression. The field is located on the Strategy page. Once you save the Suppression Count in the Strategy Advance Option for rule then the 'Suppression Count' value is updated in this column, By default the value is 0. |
Max Score | int | By default the value is false(0) and in the Strategy once you select Max score for rule and save the Strategy then the value becomes true(1). |