Overview

Yotpo Clicks refers to the total number of unique clicks on links within Yotpo messages.

📘

Yotpo Clicks = Total Clicks in Yotpo Messages

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

Detailed Breakdown

The formula above is derived from the following components:

Clicks = SUM(clicks) --> Email/SMS table
Yotpo = where channel = 'smsbump'

Insights and Actions

Yotpo Clicks shows how many recipients engaged with links in your SMS & Email messages, revealing the effectiveness of your calls-to-action and content:

• Gauge Engagement Quality: Monitor clicks per send to see which subject lines, offers, or creative formats drive the most interest.
• Optimize Send Timing: Compare click counts across send times and days to identify when your audience is most likely to engage.
• Refine Audience Targeting: Segment click data by list or campaign to focus future sends on recipients who consistently interact with your messages.

Related Metrics

• Yotpo Conversions (Purchases): Indicates how many clicks convert into sales, helping you assess the revenue impact of high-engagement campaigns.
• Yotpo Conversion Value (CV): Shows the total revenue generated from those conversions, tying click activity to actual dollars earned.
• Yotpo Sent Messages: Provides context on message volume, allowing you to calculate engagement rates and fine-tune send frequency.

Example Use

Prompt

How many times were Yotpo emails or SMS messages clicked in the last 7 days?

Response

Query

SELECT
  SUM(est.clicks) AS yotpo_total_clicks
FROM
  email_sms_table AS est
WHERE
  est.channel = 'smsbump'
  AND est.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1