The Scenario
The growth team's monthly review is tomorrow and someone just asked a reasonable question: which of the Plausible goals are actually converting, and which ones haven't moved in weeks?
You have goals configured in Plausible — demo request, free trial signup, contact form submission, pricing page visit. You've never looked at all of them together in one place. The dashboard shows them one at a time. What you need is a single table: goal name, completions in the last 30 days, conversion rate — so the team can decide which funnel steps to prioritize.
The bad version:
- Click through each goal in the Plausible UI one by one to note the completion count and conversion rate — eight goals means eight page loads and eight manual copy-pastes.
- Build a table in the sheet by hand, type the goal names, enter the numbers, and try to remember whether conversion rate means unique conversions or total — and whether you're looking at 30 days or 28.
- Realize two goals have been renamed in Plausible since you last checked, so three rows in your sheet now have the wrong labels.
The review starts at 9 AM. You're doing this at 8:40.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It can list all goals configured for your Plausible site, query their completion and conversion data, and write the results directly into a table — in one step.
Open the Goals sheet and run this prompt:
List all goals for my Plausible site and then query each goal's completions and conversion rate for the past 30 days — write goal name (A), completions (B), and conversion rate (C) into this sheet
What You Get
- Column A: goal name exactly as configured in Plausible
- Column B: total completions over the last 30 days
- Column C: conversion rate as a decimal (e.g., 0.023 for 2.3%)
- One row per goal, all goals included — not just the ones currently visible in the dashboard view
- No manual clicking through each goal individually
What If the Data Is Not Quite Ready
You want to flag goals with a conversion rate below 1% for review
List all Plausible goals and query 30-day completions and conversion rate — write goal name (A), completions (B), conversion rate (C) — then in column D flag any goal where conversion rate is below 0.01 with the label Below threshold
You want to compare this month's conversion rates to last month's
List all Plausible goals and query completions and conversion rate for the past 30 days — write goal name (A), this month completions (B), this month conversion rate (C) — then in column D do a VLOOKUP against the Last Month tab to pull last month's conversion rate for the same goal, and in column E calculate the change
You want to join goal data to your ad spend per campaign
List all Plausible goals for my site, query 30-day completions and conversion rate — write goal name (A), completions (B), conversion rate (C) — then in column D VLOOKUP against the Campaign Spend tab where goal name maps to campaign label, and in column E calculate cost per conversion as spend divided by completions
Pull all goal data, flag underperformers, and write an executive summary in one shot
List all Plausible goals and query completions and conversion rate for the past 30 days — write goal (A), completions (B), conversion rate (C) — flag goals below 1% conversion in column D as Needs review — then in cell F1 write a summary line: how many goals are below threshold and what the highest-converting goal is
The whole table, annotated and summarized, before the 9 AM meeting actually starts.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet where you track your funnel goals — or create a fresh Goals tab — then ask it to pull all your Plausible goal conversion data for the last 30 days. For related reads, see the hub overview or the spoke on UTM campaign performance.