Klaviyo data reference

A per-tab list of every column SyncRange can export from Klaviyo, with a short description of what each one contains. Use this page when picking columns in the export builder, or when you need to know exactly what a value represents in BigQuery or Google Sheets.

Each tab below notes whether it uses the export date range or always exports a full current snapshot (date range does not apply).

Nested objects are flattened into columns where possible; remaining objects and arrays are exported as JSON text. For configuration steps see Configuring Klaviyo exports.

Profiles - date range
Events - date range
Accounts - full snapshot
Lists - full snapshot
Segments - full snapshot
Email Campaigns - full snapshot
SMS Campaigns - full snapshot
Flows - full snapshot
Metrics - full snapshot
Catalog Items - full snapshot
Catalog Variants - full snapshot
Catalog Categories - full snapshot
Coupons - full snapshot
Coupon Codes - full snapshot
Forms - full snapshot
Images - full snapshot
Tags - full snapshot
Templates - full snapshot
Reviews - full snapshot

Some columns are optional and only appear if you select them in the column picker for that tab. The Date Exported column is added automatically when you include it in your selection.

Profiles

One row per customer profile. Date range: filtered by profile updated timestamp.

Column	Description
Profile ID	Klaviyo profile ID.
Type	Klaviyo JSON:API resource type for this object.
Email	Profile email address.
Phone Number	Profile phone number in E.164 format when available.
External ID	Your external identifier mapped onto the profile or catalog object.
Anonymous ID	Anonymous identifier before identity merge, when present.
First Name	Profile first name.
Last Name	Profile last name.
Organization	Company or organization on the profile.
Title	Job title on the profile when set.
Image	Profile image URL when set.
Created	When the object was created in Klaviyo.
Updated	When the object was last updated in Klaviyo.
Last Event Date	Timestamp of the profile's most recent tracked event.
Location Address 1	Street address line 1.
Location Address 2	Street address line 2.
Location City	City.
Location Region	Region, state, or province.
Location Country	Country.
Location Zip	Postal or ZIP code.
Location Timezone	Inferred timezone for the profile location.
Location Latitude	Latitude when known.
Location Longitude	Longitude when known.
Location IP	Last known IP address when Klaviyo provides it.
Properties	Custom profile properties as JSON.
Subscriptions	Email/SMS subscription and consent details as JSON.
Predictive Analytics	Predictive analytics fields as JSON when available on the account.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Events

One row per tracked event. Date range: filtered by event datetime. Large accounts can produce high volume; prefer narrower ranges or Since last export for incremental syncs.

Column	Description
Event ID	Klaviyo event ID.
Type	Klaviyo JSON:API resource type for this object.
Timestamp	Unix timestamp for the event.
Datetime	Event datetime used for date-range filtering.
UUID	Unique event UUID from Klaviyo.
Event Properties	Event-specific properties as JSON.
Profile ID	Related profile ID when present on the event.
Metric ID	Related metric ID for the event.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Accounts

One row for the authenticated Klaviyo account. Full export each run: always current account metadata; the date range does not apply.

Column	Description
Account ID	Klaviyo account ID.
Type	Klaviyo JSON:API resource type for this object.
Test Account	Whether this is a Klaviyo test account.
Public API Key	Public (site) API key for the account.
Locale	Account locale.
Currency	Default account currency.
Timezone	Account timezone.
Preferred Currency	Preferred reporting currency when set.
Contact Information	Account contact details as JSON.
Industry	Industry classification for the account when set.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Lists

One row per static list. Full export each run: always current lists; the date range does not apply.

Column	Description
List ID	Klaviyo list ID.
Type	Klaviyo JSON:API resource type for this object.
Name	List name.
Created	When the object was created in Klaviyo.
Updated	When the object was last updated in Klaviyo.
Opt-In Process	List opt-in process (for example single or double opt-in).
Profile Count	Number of profiles on the list when returned.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Segments

One row per dynamic segment. Full export each run: always current segments; the date range does not apply.

Column	Description
Segment ID	Klaviyo segment ID.
Type	Klaviyo JSON:API resource type for this object.
Name	Segment name.
Created	When the object was created in Klaviyo.
Updated	When the object was last updated in Klaviyo.
Is Active	Whether the segment is active.
Is Processing	Whether Klaviyo is currently recalculating the segment.
Is Starred	Whether the segment is starred in Klaviyo.
Definition	Segment definition / filter rules as JSON.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Email Campaigns

One row per email campaign (channel filter applied). Full export each run: always current campaigns; the date range does not apply.

Column	Description
Campaign ID	Klaviyo campaign ID.
Type	Klaviyo JSON:API resource type for this object.
Name	Campaign name.
Status	Current status as reported by Klaviyo.
Archived	Whether the campaign or flow is archived.
Audiences	Audience targeting configuration as JSON.
Send Options	Send options as JSON.
Tracking Options	Tracking options as JSON.
Send Strategy	Send strategy as JSON.
Created At	Created timestamp from Klaviyo.
Scheduled At	Scheduled send timestamp when set.
Updated At	Last updated timestamp from Klaviyo.
Send Time	Actual or planned send time when returned.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

SMS Campaigns

One row per SMS campaign (channel filter applied). Full export each run: always current campaigns; the date range does not apply.

Column	Description
Campaign ID	Klaviyo campaign ID.
Type	Klaviyo JSON:API resource type for this object.
Name	Campaign name.
Status	Current status as reported by Klaviyo.
Archived	Whether the campaign or flow is archived.
Audiences	Audience targeting configuration as JSON.
Send Options	Send options as JSON.
Tracking Options	Tracking options as JSON.
Send Strategy	Send strategy as JSON.
Created At	Created timestamp from Klaviyo.
Scheduled At	Scheduled send timestamp when set.
Updated At	Last updated timestamp from Klaviyo.
Send Time	Actual or planned send time when returned.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Flows

One row per automated flow. Full export each run: always current flows; the date range does not apply.

Column	Description
Flow ID	Klaviyo flow ID.
Type	Klaviyo JSON:API resource type for this object.
Name	Flow name.
Status	Current status as reported by Klaviyo.
Archived	Whether the campaign or flow is archived.
Created	When the object was created in Klaviyo.
Updated	When the object was last updated in Klaviyo.
Trigger Type	How the flow is triggered (for example metric, list, segment).
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Metrics

One row per metric available in the account. Full export each run: always current metrics; the date range does not apply.

Column	Description
Metric ID	Klaviyo metric ID.
Type	Klaviyo JSON:API resource type for this object.
Name	Metric name.
Created	When the object was created in Klaviyo.
Updated	When the object was last updated in Klaviyo.
Integration	Source integration metadata as JSON.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Catalog Items

One row per catalog item. Full export each run: always current catalog items; the date range does not apply.

Column	Description
Item ID	Klaviyo catalog item ID.
Type	Klaviyo JSON:API resource type for this object.
External ID	Your external identifier mapped onto the profile or catalog object.
Title	Catalog item or variant title.
Description	Catalog description text.
Price	Price value from the catalog object.
URL	Product or item URL.
Image URL	Full-size image URL.
Published	Whether the catalog object is published.
Created	When the object was created in Klaviyo.
Updated	When the object was last updated in Klaviyo.
Custom Metadata	Custom catalog metadata as JSON.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Catalog Variants

One row per catalog variant. Full export each run: always current variants; the date range does not apply.

Column	Description
Variant ID	Klaviyo catalog variant ID.
Type	Klaviyo JSON:API resource type for this object.
External ID	Your external identifier mapped onto the profile or catalog object.
Title	Catalog item or variant title.
Description	Catalog description text.
SKU	SKU for the variant.
Inventory Policy	Inventory policy for the variant.
Inventory Quantity	Available inventory quantity.
Price	Price value from the catalog object.
URL	Product or item URL.
Image URL	Full-size image URL.
Published	Whether the catalog object is published.
Created	When the object was created in Klaviyo.
Updated	When the object was last updated in Klaviyo.
Custom Metadata	Custom catalog metadata as JSON.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Catalog Categories

One row per catalog category. Full export each run: always current categories; the date range does not apply.

Column	Description
Category ID	Klaviyo catalog category ID.
Type	Klaviyo JSON:API resource type for this object.
External ID	Your external identifier mapped onto the profile or catalog object.
Name	Category name.
Updated	When the object was last updated in Klaviyo.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Coupons

One row per coupon definition. Full export each run: always current coupons; the date range does not apply.

Column	Description
Coupon ID	Klaviyo coupon definition ID.
Type	Klaviyo JSON:API resource type for this object.
External ID	Your external identifier mapped onto the profile or catalog object.
Description	Coupon definition description.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Coupon Codes

One row per individual coupon code. Full export each run: always current codes; the date range does not apply.

Column	Description
Coupon Code ID	Klaviyo coupon code ID.
Type	Klaviyo JSON:API resource type for this object.
Unique Code	The unique coupon code string.
Expires At	Expiration timestamp for the code when set.
Status	Current status as reported by Klaviyo.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Forms

One row per signup or embeddable form. Full export each run: always current forms; the date range does not apply.

Column	Description
Form ID	Klaviyo form ID.
Type	Klaviyo JSON:API resource type for this object.
Name	Form name.
Status	Current status as reported by Klaviyo.
A/B Test	A/B test configuration as JSON when enabled.
Created At	Created timestamp from Klaviyo.
Updated At	Last updated timestamp from Klaviyo.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Images

One row per uploaded image. Full export each run: always current images; the date range does not apply.

Column	Description
Image ID	Klaviyo image ID.
Type	Klaviyo JSON:API resource type for this object.
Name	Image name in the library.
Image URL	Hosted image URL.
Format	Image file format (for example png, jpeg).
Size	Image size metadata from Klaviyo.
Hidden	Whether the image is hidden in the library.
Updated At	Last updated timestamp from Klaviyo.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Column	Description
Tag ID	Klaviyo tag ID.
Type	Klaviyo JSON:API resource type for this object.
Name	Tag name.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Templates

One row per email or message template. Full export each run: always current templates; the date range does not apply. HTML and text bodies can be large; select those columns only when needed.

Column	Description
Template ID	Klaviyo template ID.
Type	Klaviyo JSON:API resource type for this object.
Name	Template name.
Editor Type	Template editor type (for example SYSTEM_DRAGGABLE, CODE).
HTML	Template HTML body.
Text	Template plain-text body.
Created	When the object was created in Klaviyo.
Updated	When the object was last updated in Klaviyo.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Reviews

One row per product review when Klaviyo Reviews is enabled. Full export each run: always current reviews; the date range does not apply. May be empty if Reviews is not enabled on the account.

Column	Description
Review ID	Klaviyo review ID.
Type	Klaviyo JSON:API resource type for this object.
Email	Reviewer email address when available.
Status	Current status as reported by Klaviyo.
Verified	Whether the review is verified.
Created	When the object was created in Klaviyo.
Updated	When the object was last updated in Klaviyo.
Rating	Star rating value.
Title	Review title.
Content	Review body text.
Product	Reviewed product details as JSON.
Author	Review author details as JSON.
Relationships	Related object references as JSON (when Klaviyo returns them).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).