Yotpo Delivered Messages
delivered
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;
Updated 25 days ago