Klaviyo Subscribed

subscribed_to_list

Overview

Klaviyo Subscribed refers to the total number of users who newly subscribed to Klaviyo email or SMS lists.

📘

Klaviyo Subscribed = Total number of new subscriptions reported by Klaviyo

The calculation is based on data from the Email/SMS table.

Detailed Breakdown

The formula above is derived from the following components:

Subscribed = SUM(subscribed_to_list) --> Email/SMS table
Klaviyo = where channel = 'klaviyo'

Insights and Actions

Monitoring Klaviyo Subscribed helps assess the growth of your audience and the effectiveness of your subscription campaigns:

• Track Audience Growth: Use subscriber data to measure how well your email and SMS campaigns are attracting new subscribers and growing your lists.
• Evaluate Campaign Performance: Analyze which campaigns or incentives (e.g., discounts, exclusive content) are driving the most new subscriptions.
• Optimize Lead Magnets: If subscription rates are low, consider testing different lead magnets, such as special offers or exclusive content, to boost engagement.
• Segment New Subscribers: Segment your new subscribers based on source or behavior to create personalized welcome sequences that drive long-term engagement.

Example Use

Prompt

How many people subscribed to Klaviyo lists in the last 7 days?

Response

Query

SQL

SELECT
  SUM(est.subscribed_to_list) AS total_subscribers
FROM
  email_sms_table AS est
WHERE
  est.channel = 'klaviyo'
  AND est.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1;