Ranking formulas create-ranking-formulas

About ranking formulas about-ranking-formulas

Ranking formulas allow you to define rules that will determine which offer should be presented first for a given placement, rather than taking into account the offers’ priority scores.

Ranking formulas are expressed in PQL syntax and can leverage profile attributes, context data and offer attributes. For more on how to use the PQL syntax, refer to the dedicated documentation.

Once a ranking formula has been created, you can assign it to a placement in a decision. For more on this, see Configure offers selection in decisions.

Create a ranking formula create-ranking-formula

To create a ranking formula, follow the steps below:

Ranking formula examples ranking-formula-examples

You can create many different ranking formulas according to your needs. Below are some examples.

Boost offers with certain offer attribute based on profile attribute

If the profile lives in the city corresponding to the offer, then double the priority for all offers in that city.

Ranking formula:

if( offer.characteristics.get("city") = homeAddress.city, offer.rank.priority * 2, offer.rank.priority)

Boost offers where the end date is less than 24 hours from now

Ranking formula:

if( offer.selectionConstraint.endDate occurs <= 24 hours after now, offer.rank.priority * 3, offer.rank.priority)

Boost offers based on the customers propensity to purchase the product being offered

You can boost the score for an offer based on a customer propensity score.

In this example, the instance tenant is _salesvelocity and the profile schema contains a range of scores stored in an array:

Given this, for a profile such as:

{"_salesvelocity": {"individualScoring": [
                    {"core": {
                            "category":"insurance",
                            "propensityScore": 96.9
                        }},
                    {"core": {
                            "category":"personalLoan",
                            "propensityScore": 45.3
                        }},
                    {"core": {
                            "category":"creditCard",
                            "propensityScore": 78.1
                        }}
                    ]}
}

Boost offers based on context data context-data

Journey Optimizer allows you to boost certain offers based on the context data being passed in the call. For example, if the contextData.weather=hot is passed, the priority of all offers with attribute=hot must be boosted. Detailed information on how to pass context data using the Edge Decisioning and Decisioning APIs, refer to this section

Note that when using the Decisioning API, the context data is added to the profile element in the request body, such as in the example below.

"xdm:profiles": [
{
    "xdm:identityMap": {
        "crmid": [
            {
            "xdm:id": "CRMID1"
            }
        ]
    },
    "xdm:contextData": [
        {
            "@type":"_xdm.context.additionalParameters;version=1",
            "xdm:data":{
                "xdm:weather":"hot"
            }
        }
    ]

}],

Here are examples illustrating how to use context data in ranking formulas to boost offers’ priority. Expand each section to get details on the ranking formula’s syntax.