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 shared Excel workbook so the product team can see where users are leaving the funnel and sort by exit rate to identify the biggest drops.
The bad version:
- Open Plausible, find the Exit Pages breakdown, and discover the export doesn't include exit rate — only total exits — so you'd have to calculate rate yourself using pageviews per page from a second Plausible query.
- Run two separate CSV exports, open both in Excel, build an INDEX-MATCH to join page paths across the two files, and discover the paths are formatted differently (trailing slashes on one, not the other) so half the matches return N/A.
- Fix the path formatting manually for 30 rows, recalculate exit rate in a new column, sort the results, and send the workbook — three hours after you said you'd have it ready.
The product team is meeting about funnel improvements tomorrow morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It queries Plausible's exit-page breakdown — including exit rate — and writes it directly into your specified worksheet.
Open the Exit Pages worksheet and run this prompt:
Pull exit page data from Plausible for the past month and write page path (A), total exits (B), and exit rate (C) into this Excel 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, sorted descending so the biggest funnel leaks surface first
- All returned pages from Plausible, no N/A rows from mismatched path formats
What If the Data Is Not Quite Ready
You want to flag pages with exit rates above 50% immediately
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 worksheet 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 worksheet where column A is page path and column B is funnel step name so the team can see which 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 from the Funnel Map worksheet into column E — then write in cell G1: 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 without a midnight session in the workbook.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook 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.