Overview

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

📘

Yotpo Unsubscribed = Total number of unsubscribes reported by Yotpo

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
Yotpo = where channel = 'smsbump'

Insights and Actions

Yotpo Unsubscribed tracks the number of recipients who opt out of your SMS & Email lists, signaling audience fatigue and message relevance:

• Monitor List Health: Keep an eye on unsubscribe spikes after specific sends to identify content or frequency issues that drive opt-outs.
• Refine Segmentation: Compare unsubscribe rates across segments; high churn in a group may indicate poor targeting or misaligned offers.
• Test Send Cadence: If unsubscribes trend upward, test reduced frequency or alternate channel mixes to improve retention without losing engagement.

Related Metrics

• Yotpo Sent Messages: Shows total messages sent, helping correlate send volume with unsubscribe trends.
• Yotpo Delivered Messages: Indicates how many messages actually reached inboxes; high delivery with high unsubscribes may point to content concerns.
• Yotpo Purchases: Provides context on sales generated; if purchases drop alongside rising unsubscribes, it’s time to adjust messaging strategy.

Example Use

Prompt

How many people unsubscribed from Yotpo in the last 90 days?

Response

Query

SELECT
  COALESCE(SUM(est.unsubscribed), 0) AS yotpo_total_unsubscribes
FROM
  email_sms_table AS est
WHERE
  est.channel = 'smsbump'
  AND est.event_date BETWEEN CURRENT_DATE() - 90 AND CURRENT_DATE()  - 1;