Docs
Klaviyo Fields List
84 fields · 53 metrics · 31 dimensions
| Field Name | Label | Type | Description | Group |
|---|---|---|---|---|
| Account Info2 fields | ||||
accountId |
Account ID | Dimension | Unique identifier for the Klaviyo account. Use to segment data by account in multi-account setups. | Account Info |
accountName |
Account Name | Dimension | Display name of the Klaviyo account. Useful for identifying the brand or business in reports. | Account Info |
| Campaign14 fields | ||||
campaignArchived |
Campaign Archived | Metric | Indicates whether the email campaign has been archived (true/false). Archived campaigns are hidden from the main list. | Campaign |
campaignChannel |
Campaign Channel | Metric | The delivery channel for the campaign (email or SMS). Use to analyze performance by channel type. | Campaign |
campaignCreatedAt |
Campaign Created At | Dimension | Timestamp when the campaign was first created in Klaviyo. Useful for tracking campaign lifecycle. | Campaign |
campaignId |
Campaign ID | Dimension | Unique identifier for the email or SMS campaign. Use to join with performance metrics. | Campaign |
campaignIgnoreUnsubcribers |
Campaign Ignore Unsubscribers | Metric | Whether the campaign was sent to unsubscribed contacts. Typically used for transactional messages. | Campaign |
campaignIsAddUTM |
Campaign Is Add UTM | Metric | Indicates if UTM tracking parameters are automatically added to links in the campaign. | Campaign |
campaignIsTrackingClicks |
Campaign Is Tracking Clicks | Metric | Whether click tracking is enabled for the campaign. Required for click-through rate metrics. | Campaign |
campaignIsTrackingOpens |
Campaign Is Tracking Opens | Metric | Whether open tracking is enabled for the campaign. Required for open rate metrics. | Campaign |
campaignName |
Campaign Name | Dimension | Display name of the email or SMS campaign. Use for identifying campaigns in reports and analysis. | Campaign |
campaignScheduledAt |
Campaign Scheduled At | Metric | Timestamp when the campaign was scheduled to be sent. May differ from actual send time. | Campaign |
campaignSendTime |
Campaign Send Time | Metric | Actual timestamp when the campaign was sent to recipients. | Campaign |
campaignStatus |
Campaign Status | Dimension | Current status of the campaign (draft scheduled sent cancelled). Use to filter active vs completed campaigns. | Campaign |
campaignUpdatedAt |
Campaign Updated At | Dimension | Timestamp of the last modification to the campaign settings or content. | Campaign |
campaignUseSmartSending |
Campaign Use Smart Sending | Metric | Whether Smart Sending is enabled to prevent over-messaging recipients within a time window. | Campaign |
| Date10 fields | ||||
date |
Date | Dimension | Calendar date of the record. Primary dimension for time-based analysis and trending. | Date |
day_of_week |
Day of week (Mon – Sun) | Metric | Day of the week (Monday through Sunday). Useful for identifying best-performing days for sends. | Date |
hour |
Hour | Metric | Hour of the day (0-23). Analyze optimal send times and engagement patterns by hour. | Date |
month |
Month | Metric | Month of the year (1-12 or January-December). Use for monthly trending and seasonality analysis. | Date |
quarter |
Quarter | Metric | Calendar quarter (Q1-Q4). Use for quarterly business reporting and YoY comparisons. | Date |
week |
Week | Metric | Week number of the year (1-52). Useful for weekly performance tracking. | Date |
year |
Year | Metric | Calendar year. Essential dimension for year-over-year analysis. | Date |
year_month |
Month and year | Metric | Combined month and year (e.g. 2024-01). Standard format for monthly trending. | Date |
year_quarter |
Quarter and year | Metric | Combined quarter and year (e.g. 2024-Q1). Standard format for quarterly reporting. | Date |
year_week |
Week and year | Metric | Combined week and year (e.g. 2024-W01). Standard format for weekly reporting. | Date |
| Event11 fields | ||||
eventCurrency |
Event Currency | Metric | Currency code (USD EUR etc.) for monetary values in the event. Important for revenue reporting. | Event |
eventDateTime |
Event Date Time | Metric | Exact timestamp when the event occurred including time. More granular than date alone. | Event |
eventDeviceType |
Event Device Type | Dimension | Device used when the event occurred (desktop mobile tablet). Key for optimizing responsive design. | Event |
eventFormId |
Event Form ID | Dimension | Unique identifier of the signup form that triggered the event. Use to measure form performance. | Event |
eventFormType |
Event Form Type | Dimension | Type of form (popup flyout embed). Analyze which form types convert best. | Event |
eventId |
Event ID | Dimension | Unique identifier for the specific event instance. Use for deduplication and tracking. | Event |
eventSubject |
Event Subject | Metric | Email subject line associated with the event. Analyze subject line performance. | Event |
eventUUID |
Event UUID | Dimension | Universal unique identifier for the event. Alternative to eventId for cross-system tracking. | Event |
eventUrl |
Event URL | Metric | URL where the event occurred (for web events). Track which pages drive engagement. | Event |
eventUtmMedium |
Event UTM Medium | Metric | UTM medium parameter captured with the event. Attribute events to marketing channels. | Event |
eventUtmSource |
Event UTM Source | Metric | UTM source parameter captured with the event. Identify traffic sources driving events. | Event |
| Flow8 fields | ||||
flowCreatedAt |
Flow Created At | Dimension | Timestamp when the automation flow was first created. | Flow |
flowId |
Flow ID | Dimension | Unique identifier for the automation flow. Use to analyze flow-level performance. | Flow |
flowIsArchived |
Flow Is Archived | Metric | Whether the automation flow has been archived and is no longer active. | Flow |
flowMessageId |
Flow Message ID | Dimension | Unique identifier for a specific message within a flow. Flows can have multiple messages. | Flow |
flowName |
Flow Name | Dimension | Display name of the automation flow (e.g. Welcome Series Abandoned Cart). Key dimension for flow analysis. | Flow |
flowStatus |
Flow Status | Dimension | Current status of the flow (live draft manual). Filter to analyze only active automations. | Flow |
flowTriggerType |
Flow Trigger Type | Dimension | What triggers the flow (list segment metric date). Understand automation entry points. | Flow |
flowUpdatedAt |
Flow Updated At | Dimension | Timestamp of the last modification to the flow configuration. | Flow |
| List4 fields | ||||
listCreatedAt |
List Created At | Dimension | Timestamp when the subscriber list was created in Klaviyo. | List |
listId |
List ID | Dimension | Unique identifier for the subscriber list. Use to segment metrics by list. | List |
listName |
List Name | Dimension | Display name of the subscriber list (e.g. Newsletter VIP Customers). Key dimension for list analysis. | List |
listUpdatedAt |
List Updated At | Dimension | Timestamp of the last modification to the list settings or membership. | List |
| Profile35 fields | ||||
profileAdress1 |
Profile Address 1 | Metric | Primary street address line for the subscriber. Used in personalization and segmentation. | Profile |
profileAdress2 |
Profile Address 2 | Metric | Secondary address line (apartment suite etc.) for the subscriber. | Profile |
profileAverageDaysBetweenOrders |
Profile Average Days Between Orders | Metric | Average number of days between purchases for this customer. Key metric for predicting next purchase. | Profile |
profileAverageOrderValue |
Profile Average Order Value | Metric | Average amount spent per order by this customer. Use for customer value segmentation. | Profile |
profileChurnProbability |
Profile Churn Probability | Metric | Klaviyo’s predicted likelihood (0-100%) that the customer will not purchase again. Target high-risk customers. | Profile |
profileCity |
Profile City | Metric | City where the subscriber is located. Use for geographic segmentation and localization. | Profile |
profileCountry |
Profile Country | Metric | Country where the subscriber is located. Essential for geographic analysis and compliance. | Profile |
profileCountryIcon |
Profile Country Icon | Metric | Country flag emoji or icon for visual display in reports. | Profile |
profileCountryIconUrl |
Profile Country Icon Url | Metric | URL to the country flag image. Use in custom visualizations. | Profile |
profileCreatedAt |
Profile Created At | Dimension | Timestamp when the subscriber profile was first created. Track customer acquisition over time. | Profile |
profileEmail |
Profile Email | Metric | Email address of the subscriber. Primary identifier for email marketing. | Profile |
profileEmailSubscriptions |
Profile Email Subscriptions | Metric | Email subscription status and preferences for the subscriber (subscribed unsubscribed). | Profile |
profileExpectedDateOfNextOrder |
Profile Expected Date Of Next Order | Metric | Klaviyo’s predicted date of the customer’s next purchase. Use for timing campaigns. | Profile |
profileExternalId |
Profile External Id | Dimension | External system identifier for the subscriber. Use to join with CRM or e-commerce data. | Profile |
profileFirstName |
Profile First Name | Dimension | First name of the subscriber. Essential for email personalization. | Profile |
profileHistoricCLV |
Profile Historic CLV | Metric | Total customer lifetime value to date. Sum of all historical purchases. | Profile |
profileHistoricNumberOfOrders |
Profile Historic Number Of Orders | Metric | Total number of orders placed by this customer to date. | Profile |
profileId |
Profile ID | Dimension | Unique Klaviyo identifier for the subscriber profile. Primary key for profile data. | Profile |
profileImage |
Profile Image | Metric | URL to the subscriber’s profile image if available. | Profile |
profileLastEventDate |
Profile Last Event Date | Metric | Timestamp of the most recent activity from this subscriber. Track engagement recency. | Profile |
profileLastName |
Profile Last Name | Dimension | Last name of the subscriber. Use with first name for full personalization. | Profile |
profileLatitude |
Profile Latitude | Metric | Geographic latitude coordinate of the subscriber. Use for advanced location targeting. | Profile |
profileLongitude |
Profile Longitude | Metric | Geographic longitude coordinate of the subscriber. Use for advanced location targeting. | Profile |
profileOrganization |
Profile Organization | Metric | Company or organization name associated with the subscriber. Important for B2B segmentation. | Profile |
profilePhoneNumber |
Profile Phone Number | Metric | Phone number of the subscriber. Required for SMS marketing. | Profile |
profilePredictedCLV |
Profile Predicted CLV | Metric | Klaviyo’s predicted total future customer lifetime value. Target high-value prospects. | Profile |
profilePredictedNumberOfOrders |
Profile Predicted Number Of Orders | Metric | Klaviyo’s predicted number of future orders from this customer. | Profile |
profilePseudonym |
Profile Pseudonym | Metric | Anonymous identifier for the subscriber. Used when full name is not available. | Profile |
profileRegion |
Profile Region | Metric | State province or region where the subscriber is located. | Profile |
profileSMSSubscriptions |
Profile SMS Subscriptions | Metric | SMS subscription status and preferences for the subscriber. | Profile |
profileTimezone |
Profile Timezone | Metric | Timezone of the subscriber. Critical for send time optimization. | Profile |
profileTitle |
Profile Title | Dimension | Job title or honorific for the subscriber. Use for B2B personalization. | Profile |
profileTotalCLV |
Profile Total CLV | Metric | Combined historic and predicted customer lifetime value. Complete view of customer worth. | Profile |
profileUpdatedAt |
Profile Updated At | Dimension | Timestamp of the last modification to the subscriber profile. | Profile |
profileZipCode |
Profile Zip Code | Metric | Postal or ZIP code of the subscriber. Use for geographic and demographic targeting. | Profile |
Power BI