Campaigns

Returns all campaigns in the account. Use filters to narrow results by campaign Id, status, or type.

Select

The connector 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 connector.

Id supports the following operator: =
Channel supports the following operator: =

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

SELECT * FROM Campaigns Where Id = 'campaignMessageId'
SELECT * FROM Campaigns Where Channel = 'email'

Insert

Klaviyo allows creating new Campaigns. The following query creates a Campaign that targets the lists: NewsletterSubscribers and RecentBuyers.

INSERT INTO Campaigns(Name, IncludedAudience, CampaignMessage) Values ('My Campaign', '["NewsletterSubscribers", "RecentBuyers"]', 'campaignMessageAggregate')

Update

Klaviyo allows Updating a Campaign.

UPDATE Campaigns SET Name = 'Updated Campaign Name' Where ID = '01K2HQYQ309GDXVH0WM75V12YZ'

Delete

A campaign can be deleted by providing the Id of the record you want to delete

DELETE from Campaigns Where Id = '01K2HQYQ309GDXVH0WM75V12YZ'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True			The unique identifier for the campaign. Use this value to retrieve or reference a specific campaign record.
Channel	String	True			Specifies the delivery channel used for the campaign, such as email, SMS, or push notification. A channel filter is required when listing campaigns. The allowed values are email, sms, mobile_push.
Name	String	False			The display name of the campaign used for identification in Klaviyo.
Status	String	True			Indicates the current state of the campaign, such as draft, scheduled, or sent.
Archived	Bool	True			Indicates whether the campaign has been archived. Archived campaigns are no longer active but remain available for reference.
ExcludedAudience	String	False			Lists the audiences or segments excluded from receiving this campaign.
IncludedAudience	String	False			Lists the audiences or segments included in the campaign's recipient group.
CreatedAt	Datetime	True			The date and time when the campaign was created in Klaviyo.
ScheduledAt	Datetime	True			The date and time when the campaign was scheduled for delivery.
UpdatedAt	Datetime	True			The date and time when the campaign was last updated, either manually by a user or automatically by the system.
SendTime	Datetime	True			The date and time when the campaign is scheduled to be sent. Returns null if the campaign has not yet been scheduled.
UseSmartSending	Bool	False			Indicates whether Smart Sending is enabled for the campaign. Smart Sending helps prevent subscribers from receiving too many messages in a short period.
SendStrategyDatetime	Datetime	False			Specifies the date and time defined for the send strategy, which determines when the campaign is delivered.
SendStrategyMethod	String	False			Indicates the method used to schedule campaign delivery. Possible values include static, smart_send_time, throttled, immediate, ab_test_campaign, or unsupported.
SendStrategyIsLocal	Bool	False			Indicates whether the campaign should be delivered using the recipient's local time zone rather than a fixed global send time.
SendStrategySendPastRecipientsImmediately	Bool	False			Determines whether recipients in time zones where the scheduled local time has already passed should receive the campaign immediately. Applicable only for local send configurations.
SendStrategyThrottlePercentage	Integer	False			Specifies the percentage of recipients per hour to send the campaign to when throttling is enabled. This controls the pacing of message delivery.
IsTrackingClicks	Bool	False			Indicates whether click tracking is enabled for the campaign. When disabled, the system defaults to the account's tracking settings.
IsTrackingOpens	Bool	False			Indicates whether open tracking is enabled for the campaign. When disabled, the system defaults to the account's tracking settings.
CampaignMessage	String	False			Specifies the message or messages associated with the campaign. This field is required when inserting a new campaign record.

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

Build 25.0.9434