The Scenario
The founder asked for a breakdown of which pages drive the most return visits. Not aggregated stats — raw pageview events, with URLs and referrers, so you can do the actual analysis yourself. You have Simple Analytics. The data is there. The founder wants a Google Sheet with the last 30 days of raw pageview records by Friday.
It's Wednesday afternoon and you've got two other things on the list that are higher priority.
The bad version:
- Open Simple Analytics, navigate to the export section, select "raw data," pick a 30-day range, wait for the export to generate
- Download the CSV — which comes with columns you don't need, in an order that doesn't match any existing sheet structure — and open it
- Delete the columns you don't need, rename the ones that are wrong, sort by page URL, paste the 4,000 rows into the Sheet and hope the column widths are readable
- Realize the timestamp column is in UTC and your founder wants it in Pacific time, which means a helper column with a formula on every row
Being a startup means you're supposed to be doing analysis, not column wrangling.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet and — through its Simple Analytics integration — can pull raw pageview data directly into the columns you specify, without you touching a CSV.
Export all Simple Analytics raw pageview data for sheetxai.com from the last 30 days and put page URL (column A), referrer (column B), and timestamp (column C) into this sheet starting at row 2.
What You Get
- One row per raw pageview event from the last 30 days
- Column A: the full page URL for each view
- Column B: the referrer URL, or blank if direct traffic
- Column C: the event timestamp in ISO 8601 format
- Rows sorted by timestamp ascending, most recent at the bottom
What If the Data Is Not Quite Ready
You only want pageviews from a specific page or section
Export all Simple Analytics raw pageview data for sheetxai.com from the last 30 days filtered to only rows where the page URL contains "/blog" — put page URL (A), referrer (B), and timestamp (C) into this sheet starting at row 2.
The timestamp needs to be in a different timezone
Export Simple Analytics raw pageview data for sheetxai.com for the last 30 days. Put page URL (A), referrer (B), and timestamp converted to US/Pacific time (C) into this sheet starting at row 2.
You need to separate direct traffic from referred traffic into two columns
Export Simple Analytics raw pageview data for sheetxai.com for the last 30 days. Put page URL in column A and timestamp in column B. In column C, write the referrer domain if there is one, and write "direct" if the referrer is empty.
Pull the raw data, flag the top 10 pages by view count, and convert timestamps — all at once
Export Simple Analytics raw pageview data for sheetxai.com for the last 30 days. Put page URL (A), referrer domain or "direct" (B), and timestamp in Pacific time (C) starting at row 2. Then in column D, count how many times each page URL appears across all rows and write that count. Finally, in column E, write "Top 10" for any row whose page URL is one of the 10 most-viewed pages, and leave column E blank otherwise.
One prompt does the export, the timezone conversion, the frequency count, and the ranking flag together.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet where you're doing page-level traffic analysis — ask it to export the last 30 days of Simple Analytics raw pageview data filtered to the section you care about. Then see pulling aggregated traffic stats or the Simple Analytics overview.