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 an Excel workbook 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 workbook structure — and open it in Excel as a separate file
- Delete the columns you don't need, rename the ones that are wrong, sort by page URL, copy the 4,000 rows, paste into the right worksheet in your main workbook 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 Excel workbook. It reads the workbook 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 the "Raw Data" 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 the "Raw Data" 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 the "Raw Data" 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 the "Raw Data" sheet. 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 into the "Raw Data" sheet. 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 an Excel workbook 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.