Overview

Yotpo Conversions (Purchases) refers to the number of conversions that followed a verified visit in Yotpo SMS and Email.

📘

Yotpo Conversions = Number of Conversions 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:

Conversions (Purchases) = SUM(purchases) --> Email/SMS table
Yotpo = where channel = 'smsbump'

Insights and Actions

Yotpo Conversions (Purchases) reveal how many sales your SMS & Email campaigns generate, providing a direct indicator of channel effectiveness:

• Measure Campaign Success: Track conversions daily to see which messages, segments, or offers drive the most purchases and replicate winning tactics.
• Refine Audience Targeting: Compare conversion counts across audience segments to focus future sends on groups with the highest purchase propensity.
• Align Spend with Results: Pair conversion trends with spend data to ensure budget is concentrated on campaigns that deliver strong sales outcomes.

Related Metrics

• Yotpo Conversion Value (CV): Shows the total revenue from purchases, helping you assess whether higher conversion counts translate into more sales dollars.
• Yotpo Spend: Provides the cost side of your campaigns, enabling calculation of cost-per-conversion and overall return.
• Yotpo Delivered Messages: Indicates how many messages reached recipients, allowing you to gauge the effectiveness of your delivery rate on conversion performance.

Example Use

Prompt

How many Yotpo-reported conversions were in the last 30 days?

Response

Query

SELECT
  SUM(est.purchases) AS total_conversions
FROM
  email_sms_table AS est
WHERE
  est.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1;