Overview

Yotpo Conversion Value (Yotpo CV, Yotpo Total Revenue) refers to the total revenue generated in Yotpo SMS and Email.

📘

Yotpo CV = Total Conversion Value from Yotpo

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

Detailed Breakdown

The formula above is derived from the following components:

Conversion Value (CV) = SUM(conversion_value) --> Email/SMS table
Yotpo = where channel = 'smsbump'

Insights and Actions

Yotpo Conversion Value (CV) shows the total revenue driven by your Yotpo SMS & Email campaigns, helping you gauge their direct impact on sales:

• Track Revenue Trends: Monitor CV over time to see if campaign tweaks (e.g., new offers, segments) increase revenue, doubling down on high-performing strategies.
• Optimize Send Strategy: Compare CV by send time, audience, or message type to pinpoint when and to whom campaigns generate the most revenue.
• Maximize Budget Efficiency: Pair CV with spend to identify campaigns delivering strong returns and reduce investment in low-yield initiatives.

Related Metrics

• Yotpo Spend: Provides the cost side of your campaigns, enabling ROI analysis when compared with CV.
• Yotpo Purchases: Shows the number of conversions behind the revenue, letting you calculate metrics like Average Order Value for deeper insight.
• Yotpo Delivered Messages: Indicates how many messages successfully reached recipients, helping connect deliverability to revenue outcomes.

Example Use

Prompt

What's my Yotpo-reported conversion value over the past 30 days?

Response

Query

SELECT
  SUM(pjt.channel_reported_conversion_value) AS yotpo_reported_conversion_value
FROM
  pixel_joined_tvf () AS pjt
WHERE
  pjt.channel = 'smsbump'
  AND pjt.model = 'Triple Attribution'
  AND pjt.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1;