The Scenario
The head of e-commerce got a question from the board: which of the campaigns we sent this year actually drove revenue, and how much per recipient? Not open rates. Revenue per recipient, ranked. The data is in Klaviyo. The problem is that Klaviyo's campaign analytics UI shows totals and rates but does not export a ranked revenue-per-recipient table in a single click — and the board meeting is at 9 AM tomorrow.
The bad version:
- Open the Klaviyo campaigns dashboard, switch to the analytics view, set the date filter to the right quarter, and discover that revenue per recipient is not a default column — you have to calculate it yourself.
- Export the raw campaign stats to a CSV, open it in Excel, add a formula column for revenue divided by recipients, sort descending, and reformat the headers.
- Realize the export only covers campaigns where revenue tracking was enabled and that seven campaigns are missing from the ranked list entirely.
It is 6 PM. The board meeting is in fifteen hours. This is not how you planned to spend the evening.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It calls Klaviyo's query_campaign_values endpoint, does the math, and writes a ranked table into the sheet — all in one pass.
Query Klaviyo campaign analytics values for all email campaigns from Q1 2025 and write campaign name, total revenue, recipients, and revenue per recipient into this sheet sorted by revenue descending
What You Get
- One row per campaign from the specified period.
- Columns contain campaign name, total revenue (numeric), recipient count, and revenue per recipient (calculated).
- The table is sorted descending by revenue so the board slide is a copy-paste away.
What If the Data Is Not Quite Ready
The date range needs to be the last 60 days, not Q1
Fetch Klaviyo campaign value metrics for the past 60 days and populate columns A through D with campaign name, clicks, orders placed, and total revenue
You need to compare revenue per recipient across campaign types
Query Klaviyo campaign analytics for Q1 and Q2 2025, group the results by campaign type (email vs. SMS), and write campaign type, total campaigns, average revenue per recipient, and total orders into columns A through D
Some campaigns are missing revenue data and need a flag
Fetch Klaviyo campaign analytics for the last 90 days, write campaign name, recipients, and revenue into columns A through C, then write "NO REVENUE DATA" in column D for any campaign where the revenue value is null or zero
Full board prep in one shot
Query Klaviyo campaign values for the last 6 months, calculate revenue per recipient for each campaign, sort by that metric descending, write the top 20 into this sheet with campaign name, total revenue, recipients, and revenue per recipient, and flag any campaign in the bottom quartile by writing "REVIEW" in column E
The board does not need to know how the data moved from Klaviyo to the slide. They just need the ranked table.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet before the next leadership meeting, then ask it to pull and rank your Klaviyo campaign revenue in one shot. Also check out how to export campaign performance metrics for a broader campaign overview.