Overview

Yotpo Delivered Messages refers to the total number of Yotpo email or SMS message successfully delivered to the targeted recipient.

📘

Yotpo Delivered Messages = Total Successfully Delivered Yotpo Messages

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

Detailed Breakdown

The formula above is derived from the following components:

Delivered Messages = SUM(delivered) --> Email/SMS table
Yotpo = where channel = 'smsbump'

Insights and Actions

Yotpo Delivered Messages indicates how many SMS & Email messages actually reach recipients, revealing list health and deliverability performance:

• Protect List Quality: Compare delivered vs. sent counts to spot rising bounce rates and promptly remove invalid numbers or emails.
• Improve Deliverability: Drops in delivered messages may signal carrier or spam filtering—test content, links, and compliance settings to restore reach.
• Allocate Channel Budget: Evaluate delivery rates across SMS and email to invest in the channel that reliably reaches the most customers.

Related Metrics

• Yotpo Sent Messages: Provides the total messages attempted, allowing you to calculate delivery rate and detect bounce issues.
• Yotpo Clicks: Shows engagement among successfully delivered messages, helping connect deliverability to user interaction.
• Yotpo Unsubscribed: Tracks opt-outs after receipt, revealing whether delivered content resonates or prompts list fatigue.

Example Use

Prompt

How many times were Yotpo messages successfully delivered in the last 7 days?

Response

Query

SELECT
  SUM(est.delivered) AS total_messages_delivered
FROM
  email_sms_table AS est
WHERE
  est.delivered > 0
  AND est.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1;