Klaviyo connection for LinkyFlow
LinkyFlow brings Klaviyo ecommerce data into Excel so teams can browse, edit, validate, and publish from the spreadsheet.
Resources
35
Read requests
25
Write actions
50
Documented fields
352
Workflows you can move into Excel
Each resource below maps to a practical spreadsheet workflow. Read actions bring useful columns into Excel; create and edit actions show what can be reviewed in rows before sending changes.
Account
Account
The Klaviyo account this connection reaches: its organisation, sender defaults, address, timezone and currency.
Account
The Klaviyo account this connection reaches: its organisation, sender defaults, address, timezone and currency.
Route: GET /accounts
Excel formula: =LF.klaviyo.accounts("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
test_accountdefault | boolean | — | - |
contact_information | string | — | - |
default_sender_name | string | — | - |
default_sender_email | string | — | - |
website_url | string | — | - |
organization_namedefault | string | — | - |
street_address | string | — | - |
industry | string | — | - |
timezonedefault | string | — | - |
preferred_currencydefault | string | — | - |
public_api_key | string | — | - |
locale | string | — | - |
Analytics
Campaign Values Reports
What each campaign message achieved over a period — recipients, opens, clicks, conversions, revenue —, as Klaviyo sums it.
Campaign Values Reports
What each campaign message achieved over a period — recipients, opens, clicks, conversions, revenue —, as Klaviyo sums it.
Route: GET /campaignValuesReports
Excel formula: =LF.klaviyo.campaignValuesReports("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
campaign_iddefault | id | → campaigns | - |
campaign_message_iddefault | id | — | - |
send_channeldefault | string | — | - |
click_ratedefault | number | — | - |
clicks_uniquedefault | number | — | - |
conversion_valuedefault | number | — | - |
conversionsdefault | number | — | - |
delivereddefault | number | — | - |
open_ratedefault | number | — | - |
opens_uniquedefault | number | — | - |
recipientsdefault | number | — | - |
unsubscribesdefault | number | — | - |
Events
What the account’s profiles did, one event a row: its metric, its profile, its moment and its properties.
Events
What the account’s profiles did, one event a row: its metric, its profile, its moment and its properties.
Route: GET /events
Excel formula: =LF.klaviyo.events("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
timestamp | number | — | - |
event_properties | string | — | - |
datetimedefault | date | — | - |
uuid | string | — | - |
metric_iddefault | id | — | - |
metric | string | — | - |
namedefault | string | — | - |
profile_iddefault | id | — | - |
Track Event
Track Event
Route: POST /mutation/events
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Flow Values Reports
What each flow message achieved over a period — recipients, opens, clicks, conversions, revenue —, as Klaviyo sums it.
Flow Values Reports
What each flow message achieved over a period — recipients, opens, clicks, conversions, revenue —, as Klaviyo sums it.
Route: GET /flowValuesReports
Excel formula: =LF.klaviyo.flowValuesReports("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
flow_iddefault | id | → flows | - |
flow_message_iddefault | id | — | - |
send_channeldefault | string | — | - |
click_ratedefault | number | — | - |
clicks_uniquedefault | number | — | - |
conversion_valuedefault | number | — | - |
conversionsdefault | number | — | - |
delivereddefault | number | — | - |
open_ratedefault | number | — | - |
opens_uniquedefault | number | — | - |
recipientsdefault | number | — | - |
unsubscribesdefault | number | — | - |
Metrics
The kinds of event the account records — Placed Order, Opened Email… — and the integration each comes from.
Used as filter by
Metrics
The kinds of event the account records — Placed Order, Opened Email… — and the integration each comes from.
Route: GET /metrics
Excel formula: =LF.klaviyo.metrics("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
createddefault | date | — | - |
updated | date | — | - |
integration | string | — | - |
namedefault | string | — | - |
category | string | — | - |
Audience
Add Profiles to List
Puts existing profiles on this list, by their ids. It changes no one’s consent: to subscribe a person, subscribe them.
Add Profiles to List
Add Profiles to List
Route: POST /mutation/listAddProfiles
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
List Profiles
The profiles on one list, with when each joined it.
List Profiles
The profiles on one list, with when each joined it.
Route: GET /listProfiles
Excel formula: =LF.klaviyo.listProfiles("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
emaildefault | string | — | - |
phone_numberdefault | string | — | - |
first_namedefault | string | — | - |
last_namedefault | string | — | - |
createddefault | date | — | - |
Lists
The account’s lists: the groups of profiles a campaign is sent to, each with its opt-in process.
Used as filter by
Lists
The account’s lists: the groups of profiles a campaign is sent to, each with its opt-in process.
Route: GET /lists
Excel formula: =LF.klaviyo.lists("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
createddefault | date | — | - |
updated | date | — | - |
opt_in_processdefault | enum | — | - |
Create List
Create List
Route: POST /mutation/lists
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Update List
Update List
Route: PATCH /mutation/lists
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete List
Delete List
Route: DELETE /mutation/lists
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Profiles
The account’s profiles — the people it knows —, their location, custom properties and email and SMS consent.
Used as filter by
Profiles
The account’s profiles — the people it knows —, their location, custom properties and email and SMS consent.
Route: GET /profiles
Excel formula: =LF.klaviyo.profiles("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
emaildefault | string | — | - |
phone_numberdefault | string | — | - |
first_namedefault | string | — | - |
last_namedefault | string | — | - |
createddefault | date | — | - |
Create Profile
Create Profile
Route: POST /mutation/profiles
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Update Profile
Update Profile
Route: PATCH /mutation/profiles
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Remove Profiles from List
Takes profiles off a list: they stay in the account, and no one’s consent changes.
Remove Profiles from List
Remove Profiles from List
Route: POST /mutation/listProfilesRemove
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Segment Profiles
The profiles in one segment, with when each joined it.
Segment Profiles
The profiles in one segment, with when each joined it.
Route: GET /segmentProfiles
Excel formula: =LF.klaviyo.segmentProfiles("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
emaildefault | string | — | - |
phone_numberdefault | string | — | - |
first_namedefault | string | — | - |
last_namedefault | string | — | - |
createddefault | date | — | - |
Segments
The account’s segments: groups of profiles Klaviyo keeps up to date from the conditions that define them.
Used as filter by
Segments
The account’s segments: groups of profiles Klaviyo keeps up to date from the conditions that define them.
Route: GET /segments
Excel formula: =LF.klaviyo.segments("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
definition | string | — | - |
condition_groups | string | — | - |
createddefault | date | — | - |
updated | date | — | - |
is_activedefault | boolean | — | - |
is_processing | boolean | — | - |
is_starred | boolean | — | - |
Create Segment
Create Segment
Route: POST /mutation/segments
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Update Segment
Update Segment
Route: PATCH /mutation/segments
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete Segment
Delete Segment
Route: DELETE /mutation/segments
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Campaigns
Assign Template
Gives this message a copy of a template: later changes to the template do not reach it.
Assign Template
Assign Template
Route: POST /mutation/campaignMessageAssignTemplate
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Campaign Messages
The messages of one campaign: their channel, label, content and template.
Campaign Messages
The messages of one campaign: their channel, label, content and template.
Route: GET /campaignMessages
Excel formula: =LF.klaviyo.campaignMessages("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
campaign_iddefault | id | — | - |
definition | string | — | - |
channeldefault | string | — | - |
labeldefault | string | — | - |
content | string | — | - |
template_id | id | — | - |
template | string | — | - |
name | string | — | - |
send_times | string | — | - |
created_at | date | — | - |
updated_at | date | — | - |
Campaigns
The account’s campaigns — one channel each, email by default —, their audiences, send strategy, status and send time.
Used as filter by
Campaigns
The account’s campaigns — one channel each, email by default —, their audiences, send strategy, status and send time.
Route: GET /campaigns
Excel formula: =LF.klaviyo.campaigns("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
statusdefault | enum | — | - |
archived | boolean | — | - |
audiences | string | — | - |
included | string[] | — | - |
excluded | string[] | — | - |
created_atdefault | date | — | - |
scheduled_at | date | — | - |
updated_at | date | — | - |
send_timedefault | date | — | - |
send_strategy | string | — | - |
method | string | — | - |
datetime | date | — | - |
send_options | string | — | - |
use_smart_sending | boolean | — | - |
tracking_options | string | — | - |
is_tracking_opens | boolean | — | - |
is_tracking_clicks | boolean | — | - |
campaign_message_ids | string[] | — | - |
tag_ids | string[] | — | - |
can_send | boolean | — | - |
can_cancel | boolean | — | - |
Create Campaign
Create Campaign
Route: POST /mutation/campaigns
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Update Campaign
Update Campaign
Route: PATCH /mutation/campaigns
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete Campaign
Delete Campaign
Route: DELETE /mutation/campaigns
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Cancel Campaign Send
Stops a campaign whose send is under way: cancel stops it for good, revert puts it back to draft.
Cancel Campaign Send
Cancel Campaign Send
Route: POST /mutation/campaignCancelSend
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Clone Campaign
Copies this campaign into a new draft.
Clone Campaign
Clone Campaign
Route: POST /mutation/campaignClone
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Send Campaign
Sends this draft campaign by its send strategy — at once, or at the date it names — to every recipient of its audiences. It cannot be recalled.
Send Campaign
Send Campaign
Route: POST /mutation/campaignSend
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Catalog
Catalog Categories
The categories of the account’s own catalog.
Used as filter by
Catalog Categories
The categories of the account’s own catalog.
Route: GET /catalogCategories
Excel formula: =LF.klaviyo.catalogCategories("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
external_iddefault | string | — | - |
namedefault | string | — | - |
updateddefault | date | — | - |
Create Catalog Category
Create Catalog Category
Route: POST /mutation/catalogCategories
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Update Catalog Category
Update Catalog Category
Route: PATCH /mutation/catalogCategories
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete Catalog Category
Delete Catalog Category
Route: DELETE /mutation/catalogCategories
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Catalog Items
The items of the account’s own catalog ($custom), as its messages and product feeds show them. An item synced by a store’s integration is changed in the store.
Used as filter by
Catalog Items
The items of the account’s own catalog ($custom), as its messages and product feeds show them. An item synced by a store’s integration is changed in the store.
Route: GET /catalogItems
Excel formula: =LF.klaviyo.catalogItems("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
external_iddefault | string | — | - |
titledefault | string | — | - |
pricedefault | number | — | - |
publisheddefault | boolean | — | - |
updateddefault | date | — | - |
Create Catalog Item
Create Catalog Item
Route: POST /mutation/catalogItems
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Update Catalog Item
Update Catalog Item
Route: PATCH /mutation/catalogItems
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete Catalog Item
Delete Catalog Item
Route: DELETE /mutation/catalogItems
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Catalog Variants
The variants of the account’s own catalog items: their SKU, price and stock, as its messages show them.
Catalog Variants
The variants of the account’s own catalog items: their SKU, price and stock, as its messages show them.
Route: GET /catalogVariants
Excel formula: =LF.klaviyo.catalogVariants("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
titledefault | string | — | - |
skudefault | string | — | - |
inventory_quantitydefault | number | — | - |
pricedefault | number | — | - |
updateddefault | date | — | - |
item_iddefault | id | → catalogItems | - |
Create Catalog Variant
Create Catalog Variant
Route: POST /mutation/catalogVariants
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Update Catalog Variant
Update Catalog Variant
Route: PATCH /mutation/catalogVariants
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete Catalog Variant
Delete Catalog Variant
Route: DELETE /mutation/catalogVariants
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Consent
Profile Suppressions
The jobs that suppressed profiles — a suppressed profile receives no email marketing, whatever its consent —, and a person suppressed by their email.
Profile Suppressions
The jobs that suppressed profiles — a suppressed profile receives no email marketing, whatever its consent —, and a person suppressed by their email.
Route: GET /profileSuppressions
Excel formula: =LF.klaviyo.profileSuppressions("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
statusdefault | enum | — | - |
created_atdefault | date | — | - |
total_countdefault | number | — | - |
completed_countdefault | number | — | - |
completed_at | date | — | - |
skipped_count | number | — | - |
Suppress Profile
Suppress Profile
Route: POST /mutation/profileSuppressions
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Profile Unsuppressions
The jobs that lifted suppressions a person asked for (USER_SUPPRESSED), and one lifted by their email. An unsubscribe or a bounce is never lifted.
Profile Unsuppressions
The jobs that lifted suppressions a person asked for (USER_SUPPRESSED), and one lifted by their email. An unsubscribe or a bounce is never lifted.
Route: GET /profileUnsuppressions
Excel formula: =LF.klaviyo.profileUnsuppressions("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
statusdefault | enum | — | - |
created_atdefault | date | — | - |
total_countdefault | number | — | - |
completed_countdefault | number | — | - |
completed_at | date | — | - |
skipped_count | number | — | - |
Unsuppress Profile
Unsuppress Profile
Route: POST /mutation/profileUnsuppressions
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Request Profile Deletion
Erases one person and everything Klaviyo holds of them, at their request (GDPR, CCPA): for good, in the background.
Request Profile Deletion
Request Profile Deletion
Route: POST /mutation/dataPrivacyDeletions
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Subscribe Profile
Subscribes one person to email (and SMS) marketing with their consent, on a list when one is named. On a list with double opt-in, Klaviyo first emails them to confirm. Klaviyo applies it in the background.
Subscribe Profile
Subscribe Profile
Route: POST /mutation/profileSubscriptions
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Unsubscribe Profile
Unsubscribes one person from email (and SMS) marketing. With a list named, Klaviyo unsubscribes them everywhere when they are not on it. Klaviyo applies it in the background.
Unsubscribe Profile
Unsubscribe Profile
Route: POST /mutation/profileUnsubscriptions
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Content
Clone Template
Copies this template into a new one.
Clone Template
Clone Template
Route: POST /mutation/templateClone
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Forms
The account’s sign-up forms: their status and whether they run an A/B test. They are designed in Klaviyo.
Forms
The account’s sign-up forms: their status and whether they run an A/B test. They are designed in Klaviyo.
Route: GET /forms
Excel formula: =LF.klaviyo.forms("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
statusdefault | enum | — | - |
ab_test | boolean | — | - |
created_at | date | — | - |
updated_atdefault | date | — | - |
Templates
The account’s email templates: their name, editor and plain text. Their HTML is edited in Klaviyo, and never read into a row.
Templates
The account’s email templates: their name, editor and plain text. Their HTML is edited in Klaviyo, and never read into a row.
Route: GET /templates
Excel formula: =LF.klaviyo.templates("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
editor_typedefault | string | — | - |
text | string | — | - |
created | date | — | - |
updateddefault | date | — | - |
Create Template
Create Template
Route: POST /mutation/templates
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Update Template
Update Template
Route: PATCH /mutation/templates
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete Template
Delete Template
Route: DELETE /mutation/templates
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Coupons
Coupon Codes
The codes of a coupon, or those handed to a profile: their status and expiry. Klaviyo lists them by coupon or by profile.
Coupon Codes
The codes of a coupon, or those handed to a profile: their status and expiry. Klaviyo lists them by coupon or by profile.
Route: GET /couponCodes
Excel formula: =LF.klaviyo.couponCodes("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
unique_codedefault | string | — | - |
expires_atdefault | date | — | - |
statusdefault | enum | — | - |
coupon_iddefault | id | — | - |
coupon | string | — | - |
external_id | string | — | - |
profile_id | id | — | - |
Create Coupon Code
Create Coupon Code
Route: POST /mutation/couponCodes
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Update Coupon Code
Update Coupon Code
Route: PATCH /mutation/couponCodes
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete Coupon Code
Delete Coupon Code
Route: DELETE /mutation/couponCodes
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Coupons
The account’s coupons — each a discount of a store, by its id there —, and how Klaviyo hands out their codes.
Used as filter by
Coupons
The account’s coupons — each a discount of a store, by its id there —, and how Klaviyo hands out their codes.
Route: GET /coupons
Excel formula: =LF.klaviyo.coupons("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
external_iddefault | string | — | - |
descriptiondefault | string | — | - |
monitor_configuration | string | — | - |
assigner_configuration | string | — | - |
used | enum | — | - |
unused_expired | enum | — | - |
Create Coupon
Create Coupon
Route: POST /mutation/coupons
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Update Coupon
Update Coupon
Route: PATCH /mutation/coupons
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete Coupon
Delete Coupon
Route: DELETE /mutation/coupons
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Flows
Flow Actions
The steps of one flow — a message sent, a delay, a split —, each as Klaviyo defines it.
Flow Actions
The steps of one flow — a message sent, a delay, a split —, each as Klaviyo defines it.
Route: GET /flowActions
Excel formula: =LF.klaviyo.flowActions("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
flow_iddefault | id | — | - |
definitiondefault | string | — | - |
flow_message_ids | string[] | — | - |
createddefault | date | — | - |
updated | date | — | - |
Flows
The account’s flows: the automations that message profiles on their own, from a trigger (a list joined, a metric, a date).
Used as filter by
Flows
The account’s flows: the automations that message profiles on their own, from a trigger (a list joined, a metric, a date).
Route: GET /flows
Excel formula: =LF.klaviyo.flows("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
statusdefault | string | — | - |
archived | boolean | — | - |
created | date | — | - |
updateddefault | date | — | - |
trigger_typedefault | enum | — | - |
tag_ids | string[] | — | - |
Change Flow Status
Change Flow Status
Route: PATCH /mutation/flows
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Delete Flow
Delete Flow
Route: DELETE /mutation/flows
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.