Data Dictionary

Klaviyo Unsubscribed

unsubscribed

Overview

Klaviyo Unsubscribed refers to the total number of users who unsubscribed from Klaviyo email or SMS lists.

📘

Klaviyo Unsubscribed = Total number of unsubscribes 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:

Unsubscribed = SUM(unsubscribed) --> Email/SMS table
Klaviyo = where channel = 'klaviyo'

Insights and Actions

Tracking Klaviyo Unsubscribed helps you monitor audience engagement and evaluate the effectiveness of your email and SMS campaigns:

  • Monitor List Health: Keep an eye on unsubscribe rates to assess how well your audience is responding to your messaging. High unsubscribe rates could signal a need to refine content or frequency.
  • Improve Content Relevance: Use unsubscribe data to identify areas where your email or SMS content may not be resonating with your audience and adjust accordingly.
  • Optimize Campaign Frequency: If spikes in unsubscribes occur after certain campaigns or during certain periods, consider adjusting the frequency of your communications.
  • Analyze Audience Segmentation: Identify patterns in unsubscribes to determine whether certain segments of your audience may require different messaging or targeting strategies.

Example Use

Prompt

How many people unsubscribed from Klaviyo in the last 7 days?

Response

Query

SELECT
  SUM(est.unsubscribed) AS total_unsubscribes
FROM
  email_sms_table AS est
WHERE
  est.channel = 'klaviyo'
  AND est.event_date BETWEEN today () - INTERVAL 7 DAY AND today  () - 1

Updated 3 months ago