Excel Add-In for Klaviyo

Build 25.0.9434

Events

Lists all event data recorded in the account, such as customer activities and engagement actions.

Select

The add-in uses the Klaviyo API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.

  • Id supports the following operator: =
  • Datetime supports the following operators: >=, >, <=, <
  • Timestamp supports the following operators: >=, >, <=, <
  • MetricId supports the following operator: =
  • ProfileId supports the following operator: =

For example, the following queries are processed server-side:

SELECT * FROM Events WHERE Id = 'event-1'
SELECT * FROM Events WHERE Datetime >= '2025-04-06'

Columns

Name Type References Description
Id [KEY] String The unique identifier for the event record within Klaviyo.
Datetime Datetime The date and time when the event occurred, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS+hh:mm).
Timestamp Int The event timestamp represented as the number of seconds since the Unix epoch.
UUID String A unique universal identifier for the event. This value can be used as a pagination cursor to retrieve subsequent event records.
MetricId String

Metrics.Id

The unique identifier of the metric associated with the event. Use this value to retrieve all events for a specific metric.
ProfileId String

Profiles.Id

The unique identifier of the profile associated with the event. Use this value to retrieve all events generated by a specific profile.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434