ID Graph Table

id_graph_table

The ID Graph table provides a unified view of a single person by linking all identifiers associated with them across Triple Whale—customer IDs from various platforms, emails collected throughout the customer journey, and triple_ids generated by the Triple Pixel. Triple Whale’s identity resolution algorithm stitches these signals into one global_id. Querying this table lets you analyze a customer’s complete identity footprint across sales, marketing, onsite behavior, and attribution.

🚧
Key Concepts
Identity Resolution in Triple Whale

Global Identity Stitching: Customer emails, customer IDs, and Pixel triple_ids are combined into a single global_id representing one person.

Cross-Platform & Intra-Platform Deduplication: Multiple IDs belonging to the same individual—whether from different platforms (e.g., Shopify, Klaviyo, Meta) or multiple accounts within the same platform (e.g., two separate Shopify customer IDs)—are consolidated under one identity.

Primary Email Selection: A single email is selected as the primary_email to support deduplicated outreach and identity-based grouping.

Identity-Aware Analytics: Linking anonymous Pixel activity with known customer records enables more complete lifecycle and behavior analysis.

Privacy-Safe Matching: Matching uses available deterministic or probabilistic signals while respecting platform and privacy constraints.

Using the Global ID Table with Other Tables

Join the Global ID table to customer-based tables (such as Customers, Customer Journey, Customer Segmentation, and Customer Segmentation Analytics) via customer_ids or emails.

This allows you to connect identity-level records to platform-level customer profiles and segmentation attributes.

Common workflows include deduplicating customer lists, linking onsite Pixel activity to known customers, and building unified customer journeys across all identifiers.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Customer IDs	`customer_ids`	repeated string	A list of customer identifiers collected from connected platforms (e.g., Shopify, Meta, Klaviyo) that have been matched as belonging to the same individual and associated with a single `global_id`. Example value: `[5209503793328, 1308703745320]`
Customer Emails	`emails`	repeated string	All email addresses collected across platforms and touchpoints (e.g., checkout, marketing platforms, forms, aliases, historical emails) that have been matched as belonging to the same individual and associated with a single `global_id`. Example value: `[[email protected], [email protected], [email protected]]`
Global ID	`global_id`	string	The identifier assigned by Triple Whale to represent a single individual after probabilistically matching related customer IDs, emails, and Pixel triple_ids across platforms and devices. This is the primary identifier used for identity-level analysis. Example value: `er74f7ca-34bd-4u70-mn90-2a7slh385e19`
Primary Customer Email	`primary_email`	string	A single selected email address associated with the `global_id`, representing the most preferred or consistent email for that individual. Useful for deduplicated outreach and identity-based grouping. Example value: `[email protected]`
Triple Pixel IDs	`triple_ids`	repeated string	A list of identifiers generated by the Triple Pixel that represent visits, sessions, or devices that have been matched as belonging to the same individual and associated with a single `global_id`. Example value: `[eltlok4y634IRw62AZ, olthkk4y294WNw62PL]`

Updated about 7 hours ago