Overview

Yotpo Spend refers to the total amount of money spent on advertising on Yotpo SMS and Email.

📘

Yotpo Ad Spend = Ad Spend on Yotpo

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

Detailed Breakdown

The formula above is derived from the following components:

Ad Spend = SUM(spend) --> Email/SMS table
Yotpo = where channel = 'smsbump'

Insights and Actions

Yotpo Spend shows the total cost of your SMS & Email campaigns sent through Yotpo, helping you monitor budget allocation and channel efficiency:

• Track Budget Utilization: Review Yotpo spend frequently to stay within budget and quickly spot overspending on under-performing campaigns.
• Align Spend with Revenue: Compare spend against Yotpo Conversion Value to confirm that higher investment drives proportional returns, reallocating funds if ROI lags.
• Optimize Message Strategy: If spend is high but engagement is low, adjust send time, segmentation, or creative to improve performance and reduce wasted spend.

Related Metrics

• Yotpo Conversion Value (CV): Measures the revenue generated from Yotpo campaigns, allowing you to gauge whether spending translates into sales.
• Yotpo Purchases: Shows the number of conversions driven by Yotpo, providing context for how spend impacts customer actions.
• Yotpo Delivered Messages: Tracks how many messages successfully reach recipients, helping assess cost-per-delivered message and deliverability efficiency.

Example Use

Prompt

What's my Yotpo spend for the last 7 days?

Response

Query

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