Klaviyo Percent of Revenue

Overview

Klaviyo Percent of Revenue refers to the percent of total order revenue that comes from Klaviyo.

📘

Klaviyo % of Revenue = Klaviyo CV / Total Order Revenue

The calculation is based on data from the Email/SMS and Orders tables.

Detailed Breakdown

The formula above is derived from the following components:

Conversion Value (CV) = SUM(conversion_value) --> Email/SMS table
Klaviyo = where channel = 'klaviyo'
Order Revenue = SUM(order_revenue) --> Orders table

Insights and Actions

Klaviyo Percent of Revenue shows how much of your total revenue is generated through Klaviyo's combined email flows and campaigns. Tracking this metric helps optimize your email and SMS strategy for maximum impact:

• Maximize Klaviyo’s Impact: Continuously monitor how much revenue Klaviyo contributes to ensure your email and SMS strategy drives significant returns across both flows and campaigns.
• Identify Trends and Seasonality: Track seasonal spikes in Klaviyo-driven revenue to better time and plan future campaigns and flows around high-impact periods.
• Optimize Content Across Channels: Evaluate the overall effectiveness of your messaging across Klaviyo emails and SMS to refine and enhance content, ensuring it resonates with your audience and increases conversions.
• Strategic Budgeting: If Klaviyo consistently accounts for a large share of revenue, consider increasing investment in email and SMS marketing to further boost performance.

Example Use

Prompt

What percent of my total order revenue over the last 7 days is from Klaviyo?

Response

Query

SQL

WITH
  total_rev AS (
    SELECT
      SUM(ot.order_revenue) AS total_revenue
    FROM
      orders_table AS ot
    WHERE
      ot.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1
  ),
  klaviyo_rev AS (
    SELECT
      SUM(est.conversion_value) AS klaviyo_revenue
    FROM
      email_sms_table AS est
    WHERE
      est.channel = 'klaviyo'
      AND est.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1
  )
SELECT
  COALESCE(kr.klaviyo_revenue / tr.total_revenue, 0) AS percentage_klaviyo_revenue
FROM
  klaviyo_rev AS kr,
  total_rev AS tr;