The Scenario
Three weeks ago someone on the growth team noticed that signups were down even though traffic was flat. The hypothesis: users were dropping out somewhere between the pricing page and the checkout. Nobody has pulled the exit page data to confirm it.
You've inherited the task. Pull the top 20 exit pages for the last 30 days — page path, total exits, exit rate — into a Google Sheet so the product team can see where users are leaving the funnel.
The bad version:
- Open Plausible, find the Exit Pages breakdown, and screenshot the table — then realize the product team needs actual data they can sort and filter, not a screenshot.
- Try to export it as CSV, find the export doesn't include exit rate (only total exits), so you'd have to calculate rate from total exits divided by total pageviews per page — which requires a second query.
- Build the formula manually, realize you need pageviews per page from a different Plausible breakdown, run two separate exports, paste both into the same sheet, write a VLOOKUP, and discover the page paths are formatted differently across the two exports so half the matches fail.
The product team is meeting about funnel improvements tomorrow morning. The analysis isn't started.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It queries Plausible's exit-page breakdown — including exit rate — and writes it directly into your specified range.
Open the Exit Pages sheet and run this prompt:
Query Plausible for an exit-page breakdown for the last 30 days and write page path (A), exits (B), and exit rate (C) into the Exit Pages sheet — sort descending by exit rate
What You Get
- Column A: page path (e.g., /pricing, /checkout/step-2, /account/settings)
- Column B: total exits from that page in the last 30 days
- Column C: exit rate as a decimal (e.g., 0.42 for 42% of sessions exiting from this page)
- Sorted descending by exit rate so the biggest funnel leaks surface first
What If the Data Is Not Quite Ready
You want to flag pages with exit rates above 50% for immediate review
Query Plausible for exit page data for the last 30 days — write page path (A), exits (B), exit rate (C) — then in column D flag any page where exit rate exceeds 0.50 with the label Critical leak
You want to compare exit rates against the same pages last month
Query Plausible for exit pages for the current month — write page path (A), exit rate (B) — then in column C VLOOKUP against the Last Month tab to pull last month's exit rate for the same path, and in column D calculate the change in exit rate
You need to cross-reference exit pages with your funnel step definitions
Query Plausible for top 30 exit pages by exit rate for the last 30 days — write page path (A), exits (B), exit rate (C) — then in column D VLOOKUP against the Funnel Map tab where column A is page path and column B is funnel step name (e.g., Step 3 — Checkout), so the team can see which funnel step each exit page corresponds to
Pull exit data, flag critical leaks, join to funnel map, and write a diagnosis in one shot
Query Plausible for top 20 exit pages by exit rate for the last 30 days — write page path (A), exits (B), exit rate (C) — flag pages above 50% exit rate in column D as Critical — VLOOKUP funnel step name from the Funnel Map tab into column E — then in cell G1 write a summary: which funnel step has the highest average exit rate and how many critical leak pages it contains
One prompt, one analysis, ready for tomorrow's product meeting.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet where your product or funnel data lives — then ask it to pull your Plausible exit page data for the last 30 days, sorted by exit rate. For related reads, see the hub overview or the spoke on landing page entry data.