The Scenario
A client report is due Friday. The client runs paid and organic campaigns across six channels and wants to know — for this quarter's 15 campaign links — which referrers and UTM sources are actually sending traffic. You've been promising "we have the data, it's in Linkly." Now you need to get it into a workbook in a format that looks like analysis, not a raw API dump.
The bad version:
- Open Linkly, navigate to the first link's analytics, click into the referrer breakdown, read the numbers, type them into the workbook
- Repeat for the UTM source breakdown of the same link
- Repeat for the other 14 links — 30 trips through the Linkly UI total, each with its own set of tabs and filter panels
- Discover halfway through that the referrer "t.co" and "twitter.com" appear separately and you need to decide how to handle that before the client sees the workbook
Three hours of data transcription is not analysis. The client is paying for the interpretation, not the collection.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the link IDs you have, pulls the referrer and UTM source breakdowns from Linkly's API, and writes the results into the workbook — organized the way a client report needs them.
Get Linkly click analytics for my workspace grouped by referrer for the last 30 days and write the referrer domain and click count into this workbook
What You Get
- One row per referrer domain: referrer in column A, click count in column B, sorted by click count descending
- Direct traffic appears as "(direct)" rather than a blank, so the row is labeled
- The date range covers exactly the last 30 days — no manual date selection
- If a referrer appears in multiple formats (t.co and twitter.com both pointing to the same platform), they appear as separate rows so you can decide how to consolidate them
What If the Data Is Not Quite Ready
You need both referrer and UTM source breakdowns side by side
The client slide has two panels: one for referrers, one for UTM sources.
Pull Linkly click counts grouped by referrer for the last 30 days and write referrer and click count into columns A and B; then pull click counts grouped by UTM source for the same period and write UTM source and click count into columns D and E — both starting at row 2
The breakdown should be per link, not aggregated across the workspace
Column A has 15 link IDs. The client wants to know which referrers drove traffic to each specific link.
For each Linkly link ID in column A, pull click analytics grouped by referrer for the last 60 days and write the link ID, referrer, and click count into columns C, D, and E — one row per referrer per link
You want to consolidate t.co and twitter.com into a single "Twitter / X" row
Referrer normalization is a judgment call, but you can ask SheetXAI to apply a specific mapping.
Pull Linkly click analytics grouped by referrer for the last 30 days, consolidate "t.co" and "twitter.com" into a single "Twitter / X" referrer, and write the consolidated referrer and click count into columns A and B sorted by click count descending
Per-link breakdown, UTM source too, consolidated referrers, and ranked — all in one
For each Linkly link ID in column A, pull click analytics for the last 60 days grouped by referrer (consolidate t.co and twitter.com as Twitter / X) and by UTM source; write link ID, referrer, referrer clicks, UTM source, and UTM source clicks into columns C through G — one row per referrer per link, sorted within each link by referrer click count descending
The client gets a workbook they can read without a decoder ring.
Try It
Open a workbook with your Linkly link IDs and the date range in mind, then Get the 7-day free trial of SheetXAI and ask it to pull the referrer breakdown. For geographic breakdowns instead of traffic sources, see pulling click analytics by country or platform. And the hub overview has every Linkly + Excel workflow in one place.