The Scenario
You manage web analytics for 20 client accounts, all inside one Simple Analytics org. Every month you send each client a one-pager with their site's 30-day visitor count and a comparison to the previous month. The template is in Excel. The data is not.
The previous analyst who set this up left six months ago. Their notes say "just export from Simple Analytics and paste." There is no further documentation.
The bad version:
- Open Simple Analytics, switch to client site 1, note the 30-day visitor count, type it into the workbook
- Switch to site 2, note the count, type it in
- Do that 18 more times, checking that you clicked on the right account for each one — the interface lists sites alphabetically but your workbook is sorted by contract value, so you're hunting back and forth
- On site 14, realize you forgot to check whether this month's 30-day window matches the window you used for the "previous month" comparison column, so those numbers are now off by several days on six of the rows
Twenty sites and 40 data points, entered by hand, once a month, forever. That's not analysis — that's transcription.
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 list all the sites in your account, fetch each one's traffic metrics, and write everything into a single table in one pass.
List all websites in my Simple Analytics account and for each site fetch the last 30-day visitor count — write site name (column A), domain (column B), and 30-day visitor count (column C) into the "Dashboard" sheet starting at row 2, sorted from highest to lowest visitors.
What You Get
- One row per site in your Simple Analytics account
- Column A: the site's display name as it appears in Simple Analytics
- Column B: the domain (e.g., clientsite.com)
- Column C: unique visitor count for the last 30 days
- Sorted descending by visitor count, so the highest-traffic sites are at the top
What If the Data Is Not Quite Ready
You need the previous 30-day period alongside the current one for comparison
List all Simple Analytics websites and for each site fetch the last 30 days and the prior 30 days of unique visitors. Write site name (A), domain (B), current 30-day visitors (C), and prior 30-day visitors (D) into the "Dashboard" sheet starting at row 2, sorted by current visitors descending.
Some sites in your account are internal or staging and should be excluded
List all Simple Analytics websites and fetch the last 30-day visitor count for each. Exclude any site whose domain contains "staging" or "internal". Write site name (A), domain (B), and visitor count (C) into the "Dashboard" sheet starting at row 2.
You need to join the analytics data against an existing client list already in the workbook
Column A of the "Clients" sheet (rows 2 through 21) contains client domain names. For each domain in column A, look up the last 30-day Simple Analytics visitor count for that site and write it into column B. If a domain isn't found in Simple Analytics, write "Not found" in column B.
Pull all sites, add a month-over-month change column, and flag any site that dropped more than 20% in one shot
List all Simple Analytics websites and for each site fetch unique visitors for the last 30 days and the prior 30 days. Write site name (A), domain (B), current visitors (C), prior visitors (D), and month-over-month percentage change (E) into the "Dashboard" sheet starting at row 2. In column F, write "Down 20%+" for any site where the percentage change is below -20%, and leave column F blank otherwise. Sort by column E ascending so the biggest drops appear first.
Cleanup, comparison, flagging, and sorting — one prompt, one pass.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where you build your monthly client traffic reports — ask it to pull all your Simple Analytics sites with their 30-day visitor counts in one go. Then see pulling raw pageview data or the Simple Analytics overview.