Browse sources$ls -a sources
Logo of klaviyo
Klaviyo
Enhance marketing strategies with your users' Klaviyo data
Sync your customers' dataFiber pulls data from your customers' Klaviyo accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.
Logo of klaviyo
Logo of klaviyo
Logo of klaviyo
Logo of klaviyo
Logo of klaviyo
Logo of klaviyo
Logo of klaviyo
Logo of klaviyo
Logo of klaviyo
Logo of klaviyo
Fiber
postgres-prod
klaviyo_campaigns
klaviyo_events
klaviyo_flows
Your customers' Klaviyo accounts
Your production database
Meet your new integration toolkit: SQLReplace calls to the Klaviyo API with an interface you already use. Access the data you need straight from your database.
-- Fetch all the Campaigns belonging to the Klaviyo
-- account of a particular user.

SELECT *
FROM fiber.klaviyo_campaign
WHERE account_id = '{user.klaviyo_id}'
-- Fetch all the Campaigns belonging to the Klaviyo
-- account of a particular user.

SELECT *
FROM fiber.klaviyo_campaign
WHERE account_id = '{user.klaviyo_id}'
Code
CREATE TABLE fiber.klaviyo_campaign (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
status TEXT,
updated TEXT,
from_name TEXT,
list_id TEXT,
template JSONB,
status_id TEXT,
object TEXT,
num_recipients INT,
lists JSONB,
is_segmented BOOLEAN,
send_time TEXT,
excluded_lists JSONB,
sent_at TEXT,
campaign_type TEXT,
name TEXT,
created TEXT,
status_label TEXT,
from_email TEXT,
subject TEXT,
message_type TEXT,
template_id TEXT
)
CREATE TABLE fiber.klaviyo_campaign (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
status TEXT,
updated TEXT,
from_name TEXT,
list_id TEXT,
template JSONB,
status_id TEXT,
object TEXT,
num_recipients INT,
lists JSONB,
is_segmented BOOLEAN,
send_time TEXT,
excluded_lists JSONB,
sent_at TEXT,
campaign_type TEXT,
name TEXT,
created TEXT,
status_label TEXT,
from_email TEXT,
subject TEXT,
message_type TEXT,
template_id TEXT
)
Model definition
About this source
Logo of Klaviyo
KlaviyoMarketing automation platform optimizing email and advertising campaigns.klaviyo.com  ↗
Available resources
Missing a resource? We will build it for you.
Similar sources
OAuth
Need help with OAuth for Klaviyo?Handshake ↗ is a Next.js app boilerplate that handles your OAuth with Klaviyo and over 200 other APIs. Setup and deploy within minutes.
Logo of klaviyoIntegrate Klaviyo using Fiber Fiber makes it easy to access third-party data from Klaviyo accounts. Get started in just a few minutes.