Klaviyo 2025-04-15 Data Model
The connector models entities in the Klaviyo API as an easy-to-use SQL database, using tables, views, and stored procedures. These are defined in schema files, which are simple, easy-to-read text files that define the structure and organization of data. Live connectivity to these objects means any changes to your Klaviyo account are immediately reflected when using the connector.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Klaviyo account.
Common tables include:
| Table | Description |
| Profiles | Manages all customer profiles in the account. |
| Events | Lists all event data recorded in the account, such as customer activities and engagement actions. |
| CampaignStats | Provides performance metrics for campaigns, including data on opens, clicks, and delivery rates. |
| Tags | Lists all tags in the account. |
| Lists | Lists all subscriber lists in the account, including list names, Ids, and subscription settings. |
| Segments | Manages audience segments in the account. |
| Campaigns | Returns all campaigns in the account. Use filters to narrow results by campaign Id, status, or type. |
| Templates | Returns all message templates in the account, including email and SMS templates available for reuse. |
| Metrics | Returns all metrics configured in the account. |
| Flows | Lists all flows in the account, including automation workflows for messages and actions. Supports retrieving and deleting flow records. |
| Webhooks | Lists all webhooks configured in the account. |
| PushTokens | Returns all push notification tokens associated with the account, used to target customer devices for campaigns. |
| CatalogItems | Returns all catalog items in the account, including product details, pricing, and availability information. |
| CatalogItemVariants | Lists all item variants for a given catalog item, including variant attributes such as color or size. |
| CatalogCategories | Lists all product categories configured in the account catalog, including category names, Ids, and metadata. |
| CampaignMessages | Returns all message records associated with a campaign, including message content, type, and delivery details. |
| ProfilesSubscriptions | Lists all subscription data for profiles, including consent status and channel-specific preferences. |
| ProfilesAnalytics | Provides aggregated analytics data for customer profiles, including engagement and purchase activity. |
| SegmentConditions | Lists all conditions that define each segment, including filters and rules applied to segment membership. |
| TagGroups | Lists all tag groups in the account. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including managing cloning existing campaigns, generating schema files, and handling authentication flows.