# Klaviyo datasets and fields

> The 13 datasets Maven lands from Klaviyo, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/klaviyo

Maven lands 13 datasets from Klaviyo in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the [Klaviyo integration page](https://mavendata.ai/integrations/klaviyo).

## Connection and sync

You connect Klaviyo with API credentials from the Klaviyo account. Maven stores them encrypted.

The first Klaviyo sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 12 months in total. After that, each scheduled sync re-reads the last 3 days, so late changes are picked up.

## Datasets

### Profiles

Klaviyo customer profiles.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| profile ID | Text |
| email | Text |
| phone number | Text |
| created | Timestamp |
| updated | Timestamp |
| subscriptions json | Text |

### Global exclusions

Suppressed profiles from Klaviyo global exclusions.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| profile ID | Text |
| email | Text |
| suppression json | Text |

### Events

Klaviyo events with included metric/attribution context.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| event ID | Text |
| date | Date |
| datetime | Timestamp |
| metric ID | Text |
| metric name | Text |
| profile ID | Text |
| event properties json | Text |

### Events detailed

Detailed Klaviyo events with included relationship payloads.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| event ID | Text |
| date | Date |
| datetime | Timestamp |
| metric ID | Text |
| metric name | Text |
| attributions json | Text |

### Email templates

Klaviyo email templates.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| template ID | Text |
| name | Text |
| created | Timestamp |
| updated | Timestamp |

### Campaigns

Klaviyo campaign entities.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| channel | Text |
| status | Text |
| archived | True/false |
| updated at | Timestamp |

### Campaigns detailed

Klaviyo campaigns with recipient estimates and messages.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| estimated recipient count | Integer |
| campaign messages json | Text |

### Flows

Klaviyo automation flow entities.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| flow ID | Text |
| flow name | Text |
| status | Text |
| archived | True/false |
| updated | Timestamp |

### Metrics

Klaviyo metric/event definitions.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| metric ID | Text |
| metric name | Text |
| integration name | Text |
| updated | Timestamp |

### Lists

Klaviyo lists.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| list ID | Text |
| list name | Text |
| updated | Timestamp |

### Lists detailed

Klaviyo lists with profile counts.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| list ID | Text |
| list name | Text |
| profile count | Integer |

### Campaign values reports

Klaviyo campaign reporting values by conversion metric and period.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| date | Date |
| campaign ID | Text |
| campaign message ID | Text |
| send channel | Text |
| conversion metric ID | Text |
| opens | Number |
| clicks | Number |
| conversions | Number |
| conversion value | Number |
| recipients | Number |

### Flow series reports

Klaviyo flow reporting series by conversion metric and period.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| date | Date |
| flow ID | Text |
| flow message ID | Text |
| send channel | Text |
| conversion metric ID | Text |
| opens | Number |
| clicks | Number |
| conversions | Number |
| conversion value | Number |
| recipients | Number |
