The Scenario
You are a growth analyst. Your VP of marketing wants to know how the "Placed Order" event has trended by day and by acquisition channel over the last 30 days — specifically, are UTM source breakdowns showing different conversion patterns? You know Klaviyo tracks this. You need the data in a Google Sheet so you can build the attribution table and feed it into the weekly growth review.
The bad version:
- Log into Klaviyo's analytics section and look for a custom metric breakdown by UTM source. Find that the UI aggregates at the metric level but does not let you group by an arbitrary event property in the standard reports view.
- Export what you can — a time-series of "Placed Order" event counts — and realize the export has no UTM dimension at all.
- Try to recreate the UTM breakdown by pulling separate reports for each campaign tag individually, merge them in Excel, and spend two hours on something that should have been a query.
The data is in Klaviyo. The UI is not built for the question you are asking.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It calls Klaviyo's metric aggregate query endpoint, which supports custom grouping by event properties, and writes the result directly into the sheet.
Query Klaviyo metric aggregates for the "Placed Order" event over the last 30 days, grouped by date, and write the date and event count into columns A and B
What You Get
- One row per date, covering the last 30 days.
- Column A contains the date, column B contains the "Placed Order" event count for that day.
- The data is ready for a chart or a pivot table without any reformatting.
What If the Data Is Not Quite Ready
You need the UTM source breakdown, not just the daily total
Query Klaviyo metric aggregates for the "Placed Order" event over the last 30 days, grouped by UTM source, and write UTM source and event count into columns A and B
You need a different event and a different date range
Fetch Klaviyo metric aggregates for "Started Checkout" events from January through March 2025, group by week, and write week start date and count into this sheet
You need to compare two events side by side
Query Klaviyo metric aggregates for both "Placed Order" and "Started Checkout" events over the last 30 days, grouped by date — write date into column A, Placed Order count into column B, and Started Checkout count into column C so I can calculate a conversion rate
Full channel attribution table in one pass
Query Klaviyo metric aggregates for the "Placed Order" event for the last 30 days, grouped by UTM source; also query "Started Checkout" grouped by UTM source for the same period; join them by UTM source and write UTM source, checkouts, orders, and conversion rate (orders/checkouts) into columns A through D, sorted by orders descending
The weekly growth review gets real attribution data instead of a manually assembled approximation.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet before the next growth review, then ask it to pull the metric aggregates you need from Klaviyo in one shot. Also check out how to pull campaign revenue attribution to add campaign-level data to the same analysis.