Data view prerequisites

For the stitching validation measurement plan, you need to ensure you have all the required dimensions and metrics from your stitched dataset defined in a data view. You need to verify that both stitchedID.id and stitchedId.namespace.code fields are added as dimensions. While the stitched dataset is an exact copy of the original dataset, the stitching process adds these two new columns to the dataset:

  • Use stitchedID.namespace.code to define a Stitched Namespace dimension. This dimension contains the namespace of the identity that the row was elevated to, for example Email, Phone. Or the namespace the stitching process fallbacks to, such as ECID.
    Stitched namespace dimension

  • Use stitchedID.id to define a Stitched ID value dimension. This dimension contains the raw value of the identity. For example: hashed email, hashed phone, ECID. This value is used with Stitched Namespace.
    Stitched ID dimension

Furthermore, you need to add two stitching metrics that are based on the presence of values in a dimension.

  1. Use the field that contains the Person ID from the stitched dataset to configure a metric that defines whether a Person ID is set. Add this Person ID even if you are using graph-based stitching as the Person ID helps to establish a baseline. In case the Person ID is not contained within the dataset, your baseline is 0%.

    In the example below, personalEmail.address serves as the identity and is used to create the ** _Email set** metric.
    Email set metric

  2. Use stitchedID.namespae.code field to create an Email stitched namespace dimension. Ensure you specify Include Exclude values component settings, so you only consider values of the namespace you are trying to elevate rows of data to.

    1. Select Set include/exclude values.
    2. Select If all criteria are met as the Match.
    3. Specify Equals email as the Criteria to select events that have been elevated to the Email namespace.

    Email stiched namespace metric

Stitched dimensions

With both of these dimensions added to the data view, use Freeform tables in Analysis Workspace to check the data that each dimension has.

In the Stitched Namespace dimension table, you typically see two rows for each dataset. One row that represents when the stitching process had to use the fallback method (ECID). The other row shows events associated with the desired identity namespace (email).

For the Stitched ID dimension table, you see the raw values that are coming from the events. In this table, you see that values oscillate between the persistent id and the desired Person ID.

Check stiched dimensions

Device-centric or Person-centric reporting

When you create a connection, you have to define what field or identity is used for the Person ID. For instance, on a web dataset, if you choose a device id as the Person ID, then you create device centric reports and lose the ability to join this data with other offline channels. If you select a cross-channel field or identity, for example email, you lose out on any unauthenticated events. To understand this impact, you need to figure out how much of the traffic is unauthenticated and how much of the traffic is authenticated.

  1. Create a calculated metric Unauthenticated events over total. Define the rule in the rule builder like below:
    Unauthenticated events over total

  2. Create a calculated metric Email authentication rate, based on the _Email set metric that you defined earlier. Define the rule in the rule builder like below:
    Email authentication rate

  3. Use the Unauthenticated events over total calculated metric, together with the Email authentication rate calculated metric, to create a Donut visualization. The visualization shows the number of events in the dataset that are unauthenticated and are authenticated.

    Identification details