Klaviyo Campaigns Revenue

Overview

Klaviyo Campaigns Revenue refers to the revenue generated from one-off email or SMS marketing campaigns sent through Klaviyo.

πŸ“˜

Klaviyo Campaigns Revenue = Total Revenue from Klaviyo Campaigns

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

Insights and Actions


Example Use

Prompt

Show revenue for Klaviyo campaigns last month

Response

Query

SELECT
  e.channel,
  SUM(e.conversion_value) AS total_revenue
FROM
  email_sms_table AS e
WHERE
  e.channel = 'klaviyo'
  AND e.report_type = 'campaign'
  AND e.event_date BETWEEN DATE_ADD(
    DATE_TRUNC(CURRENT_DATE(), MONTH),
    INTERVAL -1 MONTH
  ) AND DATE_SUB(DATE_TRUNC(CURRENT_DATE(), MONTH), INTERVAL 1 DAY)
GROUP BY
  e.channel;