The Scenario
The SEO and paid teams had a disagreement last week. Paid argues the new landing pages they built are outperforming the blog. SEO says the opposite. Neither team has the actual entry-page data to settle it — just dashboard screenshots that show different things depending on who you ask.
Your job today is to pull the real numbers: which pages are driving the most first sessions, what their bounce rates look like, and how that splits between SEO-structured URLs and paid landing page paths. It needs to go into the shared Google Sheet by end of day so both teams can look at the same data.
The bad version:
- Open Plausible, navigate to Entry Pages in the sidebar, and find it defaults to a top-10 view — you need 50 to capture the full picture.
- Export the CSV, which has entry page paths but no clear label for which paths belong to which team's initiative, so you have to manually tag each URL.
- Paste the CSV into a new tab, add a column for team ownership, hand-tag 50 rows based on URL pattern, and realize you mistagged three blog posts that were recently redirected to the paid landing page domain.
Both teams are waiting. The meeting where you'll be asked to present this is at 4 PM.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It queries Plausible's entry-page breakdown and writes it directly into your specified columns — then you can add tagging logic in the same prompt.
Open the Landing Pages sheet and run this prompt:
Query Plausible for an entry-page breakdown for the past 30 days and write page path (A), sessions (B), visitors (C), and bounce rate (D) into the Landing Pages sheet — limit to the top 50 pages
What You Get
- Column A: entry page path (e.g., /landing/free-trial, /blog/how-to-use-x)
- Column B: number of sessions that started on that page
- Column C: unique visitors who entered through that page
- Column D: bounce rate for entries from that page
- Top 50 by sessions, sorted descending
What If the Data Is Not Quite Ready
You need to tag pages by team based on URL pattern
Query Plausible for entry pages for the last 30 days — write page path (A), sessions (B), visitors (C), bounce rate (D) — then in column E write Paid if the path starts with /landing/ or /lp/, and SEO for all other paths
You want to see average session depth (pageviews per session) added as a column
Query Plausible for top 50 entry pages for the past 30 days — write page path (A), sessions (B), visitors (C), bounce rate (D) — then in column E calculate pageviews per session by dividing total pageviews for that page by sessions, using data from a second Plausible query for the same pages
You need to compare this month's entry page sessions to last month's for the same pages
Query Plausible for top 50 entry pages for the current month — write page path (A), sessions (B) — then in column C VLOOKUP against the Last Month tab to pull last month's sessions for the same page path, and in column D calculate the percentage change
Pull entry page data, tag by team, flag high-bounce pages, and write a verdict in one shot
Query Plausible for top 50 entry pages over the last 30 days — write page path (A), sessions (B), bounce rate (C) — tag each path in column D as Paid or SEO based on whether it starts with /landing/ — flag any page with bounce rate above 0.65 in column E as High bounce — then in cell G1 write a summary comparing average bounce rate for Paid vs SEO entries
The data, tagged and summarized, ready for the 4 PM meeting.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet where you track landing page or SEO performance — then ask it to pull your Plausible entry-page breakdown for the last 30 days. For related reads, see the hub overview or the spoke on top-pages report.