Overview

Yotpo Sent Messages refers to the total number of messages sent for Yotpo SMS and Email.

📘

Yotpo Sent Messages = Total Messages Sent on Yotpo

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

Detailed Breakdown

The formula above is derived from the following components:

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

Insights and Actions

Yotpo Sent Messages tracks the total number of emails and SMS sent through Yotpo, helping you manage communication frequency and campaign reach:

• Prevent Audience Fatigue: Watch send volume versus list size to avoid over-messaging, which can lead to higher unsubscribe rates and lower engagement.
• Refine Cadence by Performance: Compare sent counts with conversions and revenue to find the optimal send frequency that maximizes sales without excessive costs.
• Segment by Channel Type: Analyze sends separately for SMS and email to tailor frequency, message length, and timing to each channel’s engagement patterns.

Related Metrics

• Yotpo Delivered Messages: Indicates how many sent messages actually reached recipients, highlighting deliverability and provider performance.
• Yotpo Purchases: Shows how many conversions result from your sends, letting you connect message volume to sales outcomes.
• Yotpo Unsubscribed Recipients: Measures list attrition after campaigns, helping assess whether send frequency or content is prompting recipients to opt out.

Example Use

Prompt

How many messages were sent by Yotpo in the last 7 days?

Response

Query

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