ID Graph Table

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 belong to the same person? — use global_id to group customer_ids, emails, triple_ids

What is a customer's primary email for outreach? — use 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 What the Join Enables
Customers customer_ids to customer_id (array match) Connect unified identity to customer profiles
Customer Journey customer_ids to customer_id or triple_ids to triple_id (array match) Link identity to on-site behavior paths
Customer Segmentation customer_ids to customer_identity (array match) Connect identity to segment membership

When to Use a Different Table

Need customer profile data (contact info, geography, consent) without identity stitching → Customers table. Customers has one row per platform customer; ID Graph has one row per deduplicated person.

View the full Triple Whale Data Ontology →

Table	Join Key	What the Join Enables
Customers	`customer_ids` to `customer_id` (array match)	Connect unified identity to customer profiles
Customer Journey	`customer_ids` to `customer_id` or `triple_ids` to `triple_id` (array match)	Link identity to on-site behavior paths
Customer Segmentation	`customer_ids` to `customer_identity` (array match)	Connect identity 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 10 days ago