The Scenario
You are a content strategist at a media company. The editorial meeting is Thursday. Your editor wants to know which posts drive repeat visits — based on real GoSquared data, not gut feel.
You have 90 days of traffic data in GoSquared. But the dashboard shows a rolling view, not a ranked export you can analyze. You need the top pages by visit count for the last 90 days in an Excel workbook, ready for 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 export for top-pages data in Excel format
- You copy and paste URLs and numbers from the dashboard into the workbook, 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 Excel workbook that reads GoSquared analytics through the API, so you do not have to copy-paste from the dashboard.
Open the SheetXAI sidebar and type:
Get the top 50 pages by visit count from GoSquared for the last 90 days and write them into the Top Pages tab of this workbook with columns for page URL and visit count. Sort by visit count descending.
SheetXAI calls the GoSquared trends API with a 90-day range, fetches the top-pages breakdown, and writes it into the Top Pages tab. You have a ranked list before lunch.
What You Get
A sorted table of your top-performing content, ready for analysis:
- Page URL column — the full path for each page
- Visit count column — total visits over the 90-day window
- Sorted by visit count descending — highest-traffic content at the top
With the data in a workbook, analysis is fast. Add a Repeat Visit Rate column with a formula, overlay publish dates from another tab, or paste the table directly into your editorial deck.
What If the Data Is Not Quite Ready
Traffic data from GoSquared does not always arrive in the shape your report needs.
When you need last 30 days instead of 90
Your editor changed the brief. She wants last month only.
Get the top 50 pages by visit count from GoSquared for the last 30 days. Write page URL and visit count into the Top Pages tab of this workbook, 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.
Pull the GoSquared traffic source breakdown for last month — direct, organic, social, and referral — and write a summary table into the Sources tab of this workbook with columns for source, visitor count, and percentage of total. Then write the top 20 pages by organic visit count into the Organic tab for the same period.
When page URLs need cleaning
GoSquared tracks query-string variants of the same page as separate URLs.
Get the top 100 pages by visit count from GoSquared for the last 90 days. Strip any query parameters from the URLs and consolidate rows where the cleaned URL is the same by summing their visit counts. Write the deduplicated table into the Top Pages tab of this workbook, sorted by combined visit count descending.
When you need the full editorial brief in one operation
Your editor wants the source breakdown, the top pages, and the weekly trend all in one workbook before Thursday.
Pull three things from GoSquared for the last 90 days and write them into separate tabs of this workbook: (1) traffic source breakdown — direct, organic, social, referral — with visitor counts in the Sources tab; (2) top 30 pages by visit count with URL and count in the Top Pages tab; (3) weekly visit totals for the past 13 weeks in the Trends tab. Use a bold header row for each tab.
The pattern: one prompt, multiple API calls, one workbook. No dashboard screenshots.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull your GoSquared traffic data into any Excel workbook. The GoSquared integration is included in every SheetXAI plan. See also how to pull GoSquared UTM campaign performance into an Excel sheet or the GoSquared in Excel overview.