The Scenario
You ran 12 UTM-tagged campaigns last quarter — Google paid search, LinkedIn sponsored posts, three email drops, a podcast sponsorship, and a handful of partner referrals. They all drove some traffic. You have no idea which ones drove traffic that actually did anything.
The quarterly performance deck is due Friday. Your director has specifically asked for ROI by campaign, which means you need visitors per campaign, bounce rate, and conversions — all from Plausible — joined against the spend data already sitting in your Campaign Performance sheet.
The bad version:
- Open Plausible, navigate to UTM campaigns, and find the breakdown shows all campaigns mixed together in one list with no way to filter by quarter without manually adjusting the date picker.
- Export the CSV, which gives you campaign name, visitors, and one or two other metrics — but UTM source and medium are in separate columns and your internal campaign naming convention doesn't match what the UTM strings actually say.
- Spend an afternoon cross-referencing campaign labels between Plausible's export and your spend tracker, building VLOOKUP formulas that break whenever a campaign name has an apostrophe or trailing space.
Friday is in two days. The deck has 14 other slides that also need numbers.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It queries Plausible's UTM campaign breakdown and writes the results directly into your sheet — then you can join, calculate, and flag in the same prompt.
Open the Campaign Performance sheet and run this prompt:
Query Plausible for a UTM campaign breakdown for the past 90 days and write campaign name (A), visitors (B), and bounce rate (C) into the Campaign Performance sheet
What You Get
- Column A: UTM campaign value as Plausible received it (e.g., q1-google-brand, email-april-drop)
- Column B: unique visitors attributed to that campaign
- Column C: bounce rate for that campaign's visitors
- All campaigns returned, sorted descending by visitors
What If the Data Is Not Quite Ready
You need UTM source and medium alongside campaign name for a full attribution view
Query Plausible for UTM campaign data for the past 90 days — write utm_campaign (A), utm_source (B), utm_medium (C), visitors (D), and bounce rate (E) into the Campaign Performance sheet
You want to join Plausible visitors against spend and calculate cost per visitor
Query Plausible for UTM campaign breakdown for the past 90 days — write campaign name (A) and visitors (B) — then in column C do a VLOOKUP against the Spend tab where column A is campaign name and column B is spend, and in column D calculate cost per visitor as C divided by B
You want to flag campaigns with bounce rate over 60% as inefficient
Query Plausible for UTM campaigns for the last 90 days — write campaign (A), visitors (B), bounce rate (C) — then in column D flag any campaign where bounce rate exceeds 0.60 with the label High bounce — consider pausing
Pull all UTM data, join spend, calculate ROI, flag underperformers, and summarize in one shot
Query Plausible for UTM campaign breakdown for Q1 — write campaign (A), visitors (B), bounce rate (C) — VLOOKUP spend from Campaign Budget tab into column D — calculate cost per visitor in E — flag campaigns where cost per visitor exceeds 8 in column F as Over budget — then write a summary in cell H1: total campaigns analyzed, number flagged, and the campaign with the lowest cost per visitor
One prompt, one pass, deck-ready by Wednesday night.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with your campaign spend tracker — then ask it to pull your Plausible UTM breakdown for last quarter and join it to your costs. For related reads, see the hub overview or the spoke on referrer source breakdown.