Klaviyo Campaigns Percent of Revenue

Overview

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

📘

Klaviyo Campaigns % of Revenue = Klaviyo Campaigns 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 Campaigns = where channel = 'klaviyo' AND report_type = 'campaign'
Order Revenue = SUM(order_revenue) --> Orders table

Insights and Actions

Klaviyo Campaigns Percent of Revenue helps you measure the contribution of Klaviyo campaigns to your overall shop revenue, offering insights into the effectiveness of your direct marketing efforts.

• Assess Campaign Impact: Monitor the percentage of revenue from Klaviyo campaigns to understand how impactful your one-time marketing efforts are.
• Optimize Campaign Strategies: Use this metric to identify high-performing campaigns and adjust your marketing strategies to increase their contribution to overall revenue.
• Balance Marketing Channels: Compare the revenue percentage from Klaviyo campaigns with other marketing channels to ensure a balanced and diversified approach.
• Scale Successful Campaigns: Focus on scaling up campaigns that contribute a significant percentage of your revenue, while optimizing or reconsidering underperforming ones.

Example Use

Prompt

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

Response

Query

SQL

WITH
  klaviyo_revenue AS (
    SELECT
      SUM(e.conversion_value) AS total_klaviyo_revenue
    FROM
      email_sms_table AS e
    WHERE
      e.channel = 'klaviyo'
      AND e.report_type = 'campaign'
      AND e.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1
  ),
  total_revenue AS (
    SELECT
      SUM(o.order_revenue) AS total_revenue
    FROM
      orders_table AS o
    WHERE
      o.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1
  )
SELECT
  (k.total_klaviyo_revenue / t.total_revenue) AS klaviyo_revenue_percentage
FROM
  klaviyo_revenue AS k,
  total_revenue AS t;