Profiles

Manages all customer profiles in the account.

Select

The connector uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the connector.

Id supports the operator: =, IN
Email supports the operators: =, IN

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

SELECT * FROM Profiles 
WHERE Id = 'profile-id'

SELECT * FROM Profiles 
WHERE Email IN ('[email protected]', '[email protected]', '[email protected]')

Insert

You can create new profiles. For example:

INSERT INTO Profiles 
  (ExternalId, Email, FirstName, LastName, Image, Locale, Address1, City, Country, Ip, Latitude, Longitude, Region, Timezone, Organization, PhoneNumber, Title) 
VALUES 
  ('profiles-external-id', '[email protected]', 'John', 'Doe', 'https://image.com', 'en-US', 'Boston - Usa', 'Boston', 'Massachusetts', 'ip address', 'latitude', 'longitude', 'Boston', 'en-US', 'CDATA', '+12345678901', 'title');

Update

You can update profiles. For example:

UPDATE Profiles 
SET City = 'New York' 
WHERE Id = 'profiles-id'

Delete

You can delete a profile by specifying its Id. For example:

DELETE FROM Profiles 
WHERE Id = 'profiles-id'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True			The unique identifier for the profile, automatically generated by Klaviyo.
ExternalId	String	False			A unique identifier used to associate the Klaviyo profile with a corresponding record in an external system, such as a point-of-sale or CRM platform. The format varies depending on the external system.
Created	Datetime	True			The date and time when the profile was created, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm).
Email	String	False			The email address associated with the profile.
FirstName	String	False			The first name of the individual associated with the profile.
LastName	String	False			The last name of the individual associated with the profile.
Image	String	False			The URL pointing to the location of the individual's profile image.
LastEventDate	Datetime	True			The date and time of the most recent event that triggered an update to the profile, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm).
Locale	String	False			The locale of the profile, formatted according to the Internet Engineering Task Force – Best Current Practice #47 (IETF BCP 47) language tag standard, such as en-US or fr-CA.
Address1	String	False			The first line of the profile's street address.
Address2	String	False			The second line of the profile's street address, if applicable.
City	String	False			The city associated with the profile's address.
Country	String	False			The full country name associated with the profile's address.
Ip	String	False			The IP address most recently associated with the profile.
Latitude	String	False			The latitude coordinate of the profile's location. It is recommended to provide a precision of four decimal places.
Longitude	String	False			The longitude coordinate of the profile's location. It is recommended to provide a precision of four decimal places.
Region	String	False			The region or administrative area within the country, such as a state or province.
Timezone	String	False			The time zone associated with the profile, ideally following the IANA Time Zone Database format (for example, America/New_York).
Zip	String	False			The postal or ZIP code associated with the profile's address.
Organization	String	False			The organization or company name associated with the profile.
PhoneNumber	String	False			The phone number of the individual in E.164 international format.
Title	String	False			The professional title or job role associated with the profile.
Updated	Datetime	True			The date and time when the profile was last updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm).

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

Build 25.0.9454