Profile scores facet

Abstract

Guide to how profile scores are mapped from Sitecore 8.x to 9 in xDB Migration Tool.

Format in Sitecore 8.x

In Sitecore 8.x, information about the visitor’s profile scores at the end of the interaction is stored on the interaction in a property named Profiles.

The following is an example of an interaction with the Profiles property:

"Profiles" : {
    "Function" : {
        "Count" : 3,
        "Total" : 22.0,
        "ProfileName" : "Function",
        "Values" : {
            "Building Trust" : 0.0,
            "Call to Action" : 5.0,
            "Create Desire" : 15.0,
            "Define Concept" : 2.0
        },
        "PatternId" : NUUID("62496e17-ce38-416c-8535-6feef6be0476"),
        "PatternLabel" : "Ian"
    }
},

The Profiles property is a dictionary. Each member of the dictionary has a key and a value. The key describes a specific profile score. The value is an object that contains the details of the profile score.

In Sitecore 9, visitor’s profile scores at the end of the interaction are associated with an interaction through an interaction facet:

Facet Name

IpInfo

Facet Type

Sitecore.XConnect.Collection.Model.ProfileScores

The profile scores are stored in a dictionary. The key to the dictionary is the id of the profile. The id itself is not stored in the data from Sitecore 8.x, so a lookup is performed using the profile name.

Facet Property

Description

Scores

Dictionary that contains the profile scores associated with the interaction

Source object

Member of the dictionary located at Profiles on the interaction document

Target object

Sitecore.XConnect.Collection.Model.ProfileScore

Mapping definition

MongoDB to xConnect Interaction Mappings > MongoDB Interaction to xConnect Interaction ProfileScores Facet

Value to write to target object

Property on target object

PatternId from source object

MatchedPatternId

value resolved using ProfileName from source object

ProfileDefinitionId

Total from source object

Score

Count from source object

ScoreCount

Values from source object

Values

The values for each profile score are stored in a dictionary. The key to the dictionary is the id of the profile score. The id itself is not stored in the data from Sitecore 8.x, so a lookup is performed using the profile score name.