The Scenario
You are a content strategist at a media company. The editorial meeting is Thursday. Your editor wants to know which posts are actually driving repeat visits and which ones are dead weight — based on real GoSquared data, not gut feel.
You have 90 days of traffic data sitting in GoSquared. But the dashboard shows you a rolling view, not a ranked export you can analyze. You need the top pages by visit count for the last 90 days in a sheet, with enough detail to build a chart and a recommendation slide.
The bad version:
- You screenshot the GoSquared dashboard and try to read it into a table by hand
- You find there is no clean CSV export for top-pages data
- You start copying and pasting URLs and numbers from the dashboard into a sheet, row by row
- Fifty pages in you realize you sorted by pageviews, not unique visits, and have to start over
- Thursday morning arrives and you are still building the chart.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads GoSquared analytics through the API, so you do not have to copy-paste from the dashboard or figure out the export format.
Open the SheetXAI sidebar and type:
Get the top 50 pages by visit count from GoSquared for the last 90 days and put them in this sheet with columns for page URL and visit count. Sort by visit count descending.
SheetXAI calls the GoSquared trends API with a 90-day date range, fetches the top-pages breakdown, and writes the results into the sheet. You have a ranked list of 50 URLs and their visit counts in under a minute.
What You Get
A sorted table of your top-performing content, ready for analysis:
- Page URL column — the full path for each page, linkable
- Visit count column — total visits over the 90-day window
- Sorted by visit count descending — so your highest-traffic content is always at the top
This is the input your editorial recommendations are built on. With the data in a sheet, you can add a Repeat Visit Rate column with a formula, overlay it with your publish dates from another tab, or paste it directly into the Wednesday editorial deck.
If you want traffic broken down by source at the same time, ask SheetXAI to add a second table below the top-pages list. One prompt can include multiple API calls and write the results to different areas of the same sheet.
What If the Data Is Not Quite Ready
Traffic data from GoSquared does not always land in the shape you need for your specific report.
When you need a rolling 30-day window instead of 90
Your editor changed the brief. She wants last month only, not the full quarter.
Get the top 50 pages by visit count from GoSquared for the last 30 days only. Write page URL and visit count into this sheet, sorted by visit count descending.
When you also need the traffic source breakdown
You want to know which pages attract organic visitors versus paid traffic — not just total visit count.
Pull the GoSquared traffic source breakdown for last month — direct, organic, social, and referral — and create a summary table in this sheet with columns for source, visitor count, and percentage of total. Then, below that, list the top 20 pages by organic visit count for the same period.
When page URLs need cleaning before analysis
GoSquared sometimes tracks query-string variants of the same page as separate URLs. You want canonical URLs, not a hundred variations of one article.
Get the top 100 pages by visit count from GoSquared for the last 90 days. Strip any query parameters from the URLs — everything after the ? — and consolidate rows where the cleaned URL is the same by summing their visit counts. Write the deduplicated table into this sheet, sorted by combined visit count descending.
When you need the full picture: source + top pages + trend by week
Your editor wants the complete brief, not just the top-pages list. She wants to know where traffic is coming from, which content is growing, and whether the trend is up or down.
Pull three things from GoSquared for the last 90 days and write them into separate sections of this sheet: (1) traffic source breakdown — direct, organic, social, referral — with visitor counts; (2) top 30 pages by visit count with URL and count; (3) weekly visit totals for the past 13 weeks. Label each section with a bold header row.
The pattern: one prompt, multiple API calls, one sheet. No dashboard screenshots.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull your GoSquared traffic data into any open sheet. The GoSquared integration is included in every SheetXAI plan. See also how to pull UTM campaign performance into a Sheet or the GoSquared in Google Sheets overview.