Klaviyo Tables

The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.


Name	Description
CampaignRecipent	Summary information about email recipients for the campaign specified that includes each recipients email, customer ID, and status.
Campaigns	Returns a list of all the campaigns or Single Campaign you've created. The campaigns are returned in reverse sorted order by the time they were created.
Events	Returns a batched timeline of all events in your account.
GlobalExclusions	Get global exclusions or unsubscribes.
GroupListMembers	Gets all of the emails, phone numbers, and push tokens for profiles in a given list
ListAllExculsions	Get all the exclusions for the specified list.
ListDetails	Returns information about a list.
ListMembership	Check if profiles are on a list.
Lists	Returns a listing of all of the lists in an account.
ListSubscriptions	Check if profiles are on a list and not suppressed.
MetricEvents	Returns a batched timeline for one specific metric.
MetricExport	Export event data from Klaviyo, optionally filtering and segmented on available event properties.
MetricPersonEvents	Returns a person's batched timeline for one specific event type.
Metrics	Returns a list of all the metrics.
MetricsPersonEvents	Returns a batched timeline of all events for a person.
Person	Retrieve all the data attributes for a person, based on the Klaviyo Person ID.
Templates	Returns a list of all the email templates you've created. The templates are returned in sorted order by name.