ID Graph Table

The ID Graph table links all identifiers for a single person into one global_id, combining customer IDs, emails, and Pixel triple_ids across platforms. One row per person.

📋
Table Guide
What You Can Answer With This Table

How many unique people are in my customer base (deduplicated across platforms)? — count distinct global_id

Which identifiers and primary email belong to the same person? — use global_id, customer_ids, primary_email

Before You Query

This table is not time-series. No event_date filter is needed.

customer_ids, emails, and triple_ids are arrays. Use array functions (e.g., has(), arrayExists(), arrayJoin()) when matching against scalar values from other tables.

Key Relationships

Table Join Key Use This Join To
Customers customer_ids to customer_id (array match) Resolve unified identities to known customer profiles
Customer Journey customer_ids to customer_id or triple_ids to triple_id (array match) Analyze behavior paths across identities linked to the same person
Customer Segmentation customer_ids to customer_identity (array match) Connect unified identities to segment membership

When to Use a Different Table

Use Customers table when you need customer profile data such as contact info, geography, or consent without identity stitching. The ID Graph table is for deduplicated identity resolution across customer IDs, emails, and triple IDs.

View the full Triple Whale Data Ontology →

Table	Join Key	Use This Join To
Customers	`customer_ids` to `customer_id` (array match)	Resolve unified identities to known customer profiles
Customer Journey	`customer_ids` to `customer_id` or `triple_ids` to `triple_id` (array match)	Analyze behavior paths across identities linked to the same person
Customer Segmentation	`customer_ids` to `customer_identity` (array match)	Connect unified identities to segment membership

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 5 days ago