The Scenario
Your content team published 40 articles last quarter. Now it's the Monday of the quarterly content review and someone has asked which pages are actually driving traffic versus which ones are just sitting there. You have hunches. What you don't have is a spreadsheet with the actual numbers.
The content director wants a ranked list: top pages by pageviews, with bounce rate per page so you can flag which ones are getting clicks but not engagement. It needs to be in a shared Google Sheet by noon.
The bad version:
- Open Plausible, navigate to Top Pages, and realize the dashboard only shows 10 at a time — you need 50, which requires scrolling or a plan upgrade check.
- Export the CSV, open it, and find it includes columns you don't need (referrers, session data) mixed in with the columns you do, requiring manual cleanup before anything can be sorted.
- Copy-paste the cleaned range into the right sheet, fix the header row, sort by pageviews descending, and realize you forgot to include bounce rate — so you go back and repeat the export.
The content review starts in 90 minutes. You've spent 45 of them on spreadsheet mechanics.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the sheet you're working in and talks to Plausible Analytics directly — pulling the top-pages breakdown and writing it into your specified columns in one step.
Open the shared sheet and run this prompt:
Query Plausible for a top-pages breakdown for the past 30 days and write page URL (A), visitors (B), pageviews (C), and bounce rate (D) into this sheet — limit to the top 50 pages sorted descending by pageviews
What You Get
- Column A: full page URL path (e.g., /blog/how-to-use-x)
- Column B: unique visitors for that page over 30 days
- Column C: total pageviews
- Column D: bounce rate as a decimal
- 50 rows, already sorted descending by pageviews, no extra columns to delete
What If the Data Is Not Quite Ready
You want to flag high-traffic pages with poor engagement
Query Plausible for the top 50 pages by pageviews in the past 30 days — write page path (A), visitors (B), pageviews (C), bounce rate (D) — then in column E flag any page where bounce rate is above 0.65 with the label Needs attention
You need to compare this month's top pages against last month's
Query Plausible for the top 50 pages by pageviews for the current month and write path (A), pageviews (B) — then in column C do a VLOOKUP against the Last Month tab in column A to show last month's pageview count, and in column D calculate the percentage change
Your page paths use dynamic IDs and you need to group them by category prefix
Query Plausible for the top 100 pages for the last 30 days — write page path (A), pageviews (B), visitors (C) — then in column D extract the first path segment from column A (e.g., /blog/ or /product/) so I can sort by category
Pull, rank, flag, and summarize in one prompt
Query Plausible for the top 50 pages over the last 30 days — write page path (A), visitors (B), pageviews (C), bounce rate (D) — flag any page with bounce rate above 0.70 in column E, then write a summary in cell G1 counting how many flagged pages there are and what their average bounce rate is
One prompt, no intermediate steps — the data lands ranked and annotated, ready for the content review.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet with your content performance tracker — or a blank tab — then ask it to pull your top Plausible pages for the last 30 days. For related reads, see the hub overview or the spoke on exporting landing page entry data.