Identity resolution is only available on Business tier plans. You can use it with or without Customer Studio.
After Hightouch runs identity resolution (IDR) on your graph, Hightouch outputs tables into your warehouse so they can be used for any business need.
Your marketing team can use them for paid campaigns, your sales team for deduplicating outreach efforts, or data scientists for fraud dection.
The output of IDR can also helpful in constructing models or parent models in Hightouch.
Hightouch creates three output tables:
A RESOLVED table (<your_output_table>_resolved) that labels each row from your input tables with a HT_ID representing a profile. This table tells you all the input rows associated with a profile by its HT_ID. The SOURCE is the slug of an input model. The PRIMARY_KEY is the primary key value from the input model. The LATEST_TIMESTAMP is the timestamp of the row from the input model.
HT_ID
SOURCE
PRIMARY_KEY
LATEST_TIMESTAMP
ht1
earl-s-ecommerce-events
1
2024-08-01 12:00:00.000
ht1
earl-s-ecommerce-events
2
2024-08-01 12:05:00.000
ht1
earl-s-ecommerce-events
3
2024-08-01 12:10:00.000
ht1
earl-s-ecommerce-events
4
2024-08-01 12:15:00.000
ht5
earl-s-ecommerce-events
5
2024-08-01 12:20:00.000
ht5
earl-s-ecommerce-events
6
2024-08-01 12:25:00.000
ht5
earl-s-ecommerce-events
7
2024-08-01 12:30:00.000
ht5
earl-s-ecommerce-events
8
2024-08-01 12:35:00.000
ht9
earl-s-ecommerce-events
9
2024-08-01 12:40:00.000
ht9
earl-s-ecommerce-events
10
2024-08-01 12:45:00.000
A RESOLVED_IDENTIFIERS table (<your_output_table>_resolved_identities) includes all the unique identifiers associated with each profile. Each row represents a unique identifiers associated with a profile. COUNT represents the number of times the identifier was seen in an input row, including updated rows if the same row gets seen multiple times due to updates. IDENTIFIER is the type of identifier. VALUE is the identifier value for the profile.
HT_ID
IDENTIFIER
VALUE
INITIAL_ROW_PK
INITIAL_ROW_SOURCE
FIRST_TIMESTAMP
LAST_TIMESTAMP
COUNT
ht1
user_id
user_003
4
earl-s-ecommerce-events
2024-08-01 12:15:00.000
2024-08-01 12:15:00.000
1
ht1
anonymous_id
anon_125
1
earl-s-ecommerce-events
2024-08-01 12:00:00.000
2024-08-01 12:15:00.000
4
ht5
user_id
user_004
8
earl-s-ecommerce-events
2024-08-01 12:35:00.000
2024-08-01 12:35:00.000
1
ht5
anonymous_id
anon_126
5
earl-s-ecommerce-events
2024-08-01 12:20:00.000
2024-08-01 12:35:00.000
4
ht9
anonymous_id
anon_127
9
earl-s-ecommerce-events
2024-08-01 12:40:00.000
2024-08-01 12:45:00.000
2
A UNRESOLVED table (<your_output_table>_unresolved) which lists all the input rows we couldn't process because they primary key of the rows were not unique within the model it came from.