The Scenario
You are a paid media manager. The channel attribution report is due to the client by Friday EOD. They want to know which UTM campaigns, sources, and mediums drove the most visitors over the last 60 days — and they want it in a spreadsheet they can send to their leadership team.
GoSquared has been tracking UTM parameters all quarter. The data is in the dashboard. But the dashboard shows UTM performance as a live view, not as an exportable table structured around combinations of campaign, source, and medium. You need one row per unique combination with visitor counts, formatted as a report, not a dashboard screenshot.
The slow version:
- You open the GoSquared traffic section and look for UTM filters
- You filter by campaign, record the number, clear the filter, pick the next campaign, repeat
- Forty combinations in you realize you are cross-referencing source and medium too and the permutations are multiplying
- You paste everything into a sheet by hand, one cell at a time
- You spot an error in row 12 and are not sure if the dashboard number you read was the right date range
- Friday at 4 PM you are still reconciling the table.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads GoSquared UTM data through the API, so you do not have to manually filter and record combinations from the dashboard.
Open the SheetXAI sidebar and type:
Fetch GoSquared UTM campaign performance for the last 60 days and write campaign name, source, medium, and visitor count into this sheet — one row per unique combination, sorted by visitor count descending.
SheetXAI calls the GoSquared API with the 60-day window, fetches the UTM breakdown, and writes one row per source/medium/campaign combination into the sheet. You have the attribution table before lunch.
What You Get
A UTM attribution table structured for client reporting:
- Campaign name column — the UTM campaign parameter
- Source column — the UTM source (google, facebook, newsletter, etc.)
- Medium column — the UTM medium (cpc, email, social, etc.)
- Visitor count column — unique visitors driven by that combination in the 60-day window
- Sorted by visitor count descending — so the best-performing campaigns land at the top
One row per combination means no pivot table required. The client can filter by source, sort by campaign, or pull totals with a SUMIF — whatever their leadership team needs.
What If the Data Is Not Quite Ready
UTM attribution data always needs some interpretation before a client sees it.
When the client wants percentage of total alongside raw counts
Visitor counts alone do not tell the story. They want to know that Facebook drove 31% of attributed traffic, not just 4,200 visitors.
Fetch GoSquared UTM campaign performance for the last 60 days. Write campaign name, source, medium, and visitor count into this sheet. Add a fifth column — Percentage of Total — showing each row's visitor count as a percentage of the total attributed visitors across all UTM combinations, rounded to one decimal place.
When you also need organic and direct for context
The UTM table only covers tagged traffic. The client wants the full picture, including organic and direct.
Pull GoSquared UTM campaign performance for the last 60 days and write it into the UTM tab of this sheet with campaign, source, medium, and visitor count. Then pull the top-level traffic source breakdown — direct, organic, social, paid, referral — for the same period and write it into the Sources tab with source and visitor count.
When the client only cares about paid channels
The client runs paid social and paid search. They want to filter the UTM table down to rows where medium equals cpc or paid-social.
Fetch GoSquared UTM campaign performance for the last 60 days. Filter to rows where the medium is 'cpc' or 'paid-social' only. Write campaign name, source, medium, and visitor count into this sheet, sorted by visitor count descending.
When the client wants a full 60-day attribution analysis with a narrative
Leadership wants the UTM table, the source totals, the top three performing campaigns called out, and a one-paragraph summary of where their paid budget is working.
Pull GoSquared UTM and traffic source data for the last 60 days. Write (1) the full UTM breakdown into the UTM tab, one row per combination; (2) the top-level source totals into the Sources tab; (3) in cell A1 of the Summary tab, write a short paragraph identifying the top three UTM campaigns by visitor count, which source is dominant, and one observation about medium mix. Format the summary as plain prose, no bullet points.
The pattern: pull the UTM data, apply the filter, add the context. The client gets a report, not a raw export.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull your GoSquared UTM data into any sheet with whatever structure your attribution report needs. The GoSquared integration is included in every SheetXAI plan. See also how to import GoSquared traffic trends for analysis or the GoSquared in Google Sheets overview.