Pull UTM Campaign Performance From Plausible Into an Excel workbook

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 converted.

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 a cost-per-visitor calculation — all from Plausible — joined against the spend data already sitting in your Excel Campaign Budget worksheet.

The bad version:

• Open Plausible, navigate to UTM campaigns, export the CSV — and find that UTM source and medium are in separate columns that don't match how your internal campaign tracker labels things.
• Spend an afternoon cross-referencing campaign names between the Plausible export and your budget tracker, building INDEX-MATCH formulas that break whenever a campaign name has a trailing space.
• Realize the Q1 date range in Plausible and the Q1 date range in your budget tracker don't align by a few days, so the numbers don't reconcile cleanly.

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 that lives inside your Excel workbook. It queries Plausible's UTM campaign breakdown and writes the results directly into your worksheet — then you can join, calculate, and flag in the same prompt.

Open the Campaign Performance worksheet and run this prompt:

Pull all UTM campaign data from Plausible for Q1 into this Excel sheet — include utm_campaign (A), utm_source (B), utm_medium (C), visitors (D), and bounce rate (E)

What You Get

• Column A: UTM campaign value as received by Plausible
• Column B: UTM source
• Column C: UTM medium
• Column D: unique visitors attributed to that campaign
• Column E: bounce rate for that campaign's visitors
• All campaigns for the period, no manual CSV import

What If the Data Is Not Quite Ready

You need to join visitor data to spend and calculate cost per visitor

Query Plausible for UTM campaign breakdown for Q1 — write campaign name (A) and visitors (B) — then in column C VLOOKUP against the Campaign Budget worksheet 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%

Query Plausible for UTM campaigns for Q1 — 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

You want to aggregate campaign performance by UTM source

Query Plausible for UTM campaign data for Q1 — write campaign (A), source (B), visitors (C) — then in column D use a SUMIF to aggregate total visitors per source across all campaigns from that source, so I can see performance by channel regardless of campaign name variation

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 worksheet 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 before Friday morning.

Try It

Get the 7-day free trial of SheetXAI and open an Excel workbook with your campaign spend tracker — then ask it to pull your Plausible UTM campaign data for last quarter and join it to your costs. For related reads, see the hub overview or the spoke on referrer source breakdown.