Klaviyo Net New Subscribers

Overview

Klaviyo Net New Subscribers represents the net growth in subscribers by calculating the difference between new subscribers and unsubscribes.

📘

Klaviyo Net New Subscribers = Klaviyo Subscribed - Klaviyo Unsubscribed

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
Unsubscribed = SUM(unsubscribed) --> Email/SMS table
Klaviyo = where channel = 'klaviyo'

Insights and Actions

Tracking Klaviyo Net New Subscribers helps monitor your list growth and the overall health of your audience. Here are some ways to use this data:

• Measure Audience Growth: Net new subscribers indicate the success of your subscription efforts and whether your list is growing or shrinking.
• Evaluate Engagement: A high number of unsubscribes relative to new subscribers may signal engagement issues. Consider revising your content strategy to retain more subscribers.
• Optimize Lead Magnets: If your net new subscribers are low, experiment with different incentives or content offerings to attract and retain more subscribers.
• Seasonal Adjustments: Use this metric to monitor how different seasons or campaigns affect your subscription growth, allowing you to plan for future peaks or dips.

Example Use

Prompt

How many net new subscribers were there in Klaviyo over the last 30 days?

Response

Query

SQL

SELECT
  SUM(e.subscribed_to_list) - SUM(e.unsubscribed) AS net_new_subscribers
FROM
  email_sms_table AS e
WHERE
  e.channel = 'klaviyo'
  AND e.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1;