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 — in a spreadsheet their leadership team can read.
GoSquared has been tracking UTM parameters all quarter. But the dashboard shows UTM performance as a live view, not a table structured around combinations of campaign, source, and medium. You need one row per unique combination with visitor counts, formatted as a client-facing report.
The slow version:
- You open the GoSquared traffic section and filter by campaign, record the number, clear, 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 the workbook by hand, one cell at a time
- You spot an error in row 12 and cannot tell if the dashboard number was from 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 Excel workbook 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 the UTM tab of this workbook — 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 combination into the UTM tab. 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 over 60 days
- Sorted by visitor count descending — best-performing campaigns 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 in Excel.
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.
Fetch GoSquared UTM campaign performance for the last 60 days. Write campaign name, source, medium, and visitor count into the UTM tab of this workbook. Add a fifth column — Percentage of Total — showing each row's visitor count as a percentage of total attributed visitors, 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.
Pull GoSquared UTM campaign performance for the last 60 days and write it into the UTM tab with campaign, source, medium, and visitor count. 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 only.
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 the UTM tab of this workbook, 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 campaigns called out, and a one-paragraph summary of where the 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. 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 Excel workbook. The GoSquared integration is included in every SheetXAI plan. See also how to import GoSquared traffic trends into Excel for analysis or the GoSquared in Excel overview.