Stitch Scores table¶
The Stitch Scores table has all scores generated by Stitch, including scores that are not associated with an Amperity ID. Use this table to help understand why records are not associated with an Amperity ID.
Use with Stitch QA¶
Use the Stitch Scores table to understand why blocking used (or did not use) a foreign key or separation key to block (or unblock) two records.
Compare records¶
Use a query similar to the following to compare scores for two records:
SELECT * FROM Stitch_Scores
WHERE source1 = 'Table_Name' AND pk1 = '123abc456def'
AND source2 = 'Table_Name' AND pk1 = '789ghi012jkl'
where the values of pk1 and pk2 are for the records you want to compare.
Add table¶
A passthrough table adds a domain table to your database. Passthrough domain tables often have a field for the Amperity ID, but otherwise are the same as the fields in the source domain table.
To add the Stitch Scores table
From the Database Editor, click Add Table.
Name the table “Stitch_Scores”.
Set the build mode to Passthrough, and then select Stitch Scores.
Hide the table from the Segment Editor by verifying that Show in VSE? is unselected.
Click Activate to update the customer 360 database with your changes.
Column reference¶
The Stitch Scores table contains the following columns:
Column name |
Data type |
Description |
||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Amperity ID1 |
String |
The unique identifier assigned to clusters of customer profiles that all represent the same individual. The Amperity ID does not replace primary, foreign, or other unique customer keys, but exists alongside them within unified profiles. The Amperity ID for the first of two compared records. Note The Amperity ID is a universally unique identifier (UUID) that is 36 characters spread across five groups separated by hyphens: 8-4-4-4-12. For example: 123e4567-e89b-12d3-a456-426614174000
|
||||||||||||||
Amperity ID2 |
String |
The Amperity ID for the second of two compared records. |
||||||||||||||
Match Category |
String |
A match category is a classifier that applies to an individual record-pair within a cluster of record-pairs. The match category is the result of this classification.
|
||||||||||||||
Match Type |
String |
The score. Possible values: “scored”, “scored_transitive”, and “trivial_duplicate”. |
||||||||||||||
PK1 |
String |
|||||||||||||||
PK2 |
String |
|||||||||||||||
Score |
Float |
A score has a value from “0.0” to “5.0” that represents the combined score assigned to the record pair by Stitch. A score has two parts: the score is on the left side and the score’s strength is on the right. The record pair score correlates to the match category, which is a classifier applied by Amperity to individual record pairs. The record pair score corresponds to the classification:
The record pair strength represents the strength of the record pair score. It is a two digit number. For example: .31 is a lower strength and .93 is a higher strength. |
||||||||||||||
Source1 |
String |
|||||||||||||||
Source2 |
String |