The Scenario
You're a performance marketer preparing for a quarterly business review. The VP asked for a ranked list of the top 50 short link paths on the branded domain by click volume for the last 90 days — she wants to see which content placements the audience actually engaged with before deciding where to allocate next quarter's budget.
Short.io's dashboard shows link performance, but pulling a clean ranked export of just the top 50 paths into Excel requires navigating the UI, sorting by clicks, and manually copying rows — a process that loses formatting, resets pagination, and has caused at least two errors in past reports.
The bad version:
- Sort Short.io's link list by clicks descending
- Copy the top 50 rows one page at a time into Excel
- Realize the sort order shifted when you navigated to the second page and you now have a gap in the ranking
- Reformat the pasted data because Short.io's copy output includes HTML formatting artifacts
The quarterly review is tomorrow morning. Spending tonight formatting a ranked list in Excel is not how you want to end the quarter.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Short.io, retrieves the top-performing paths for your domain and time window, and writes them ranked into the workbook.
Fetch the most popular 50 paths on domain ID 1425403 from Short.io for the last 90 days and populate my Excel sheet with path and total click columns sorted descending
What You Get
- Rank 1 through 50 in column A, path string in column B, total click count in column C
- Pre-sorted descending so the highest-performing path is always in row 1
- No formatting cleanup — the data comes in clean, ready for the QBR deck
What If the Data Is Not Quite Ready
You want top 50 paths but only for links that are currently active
Some high-click paths belong to archived campaigns and shouldn't appear in the current quarter's analysis.
Get the top 50 most-clicked active Short.io link paths on domain ID 1425403 for the last 90 days — exclude archived links — and write the rank, path, and click count into columns A through C
The VP also wants to see the destination URL for each top path
The ranked list alone doesn't tell her what the content was — she needs to see where each path points.
Get the top 50 most-clicked paths on domain ID 1425403 for the last 90 days, retrieve the destination URL for each from Short.io, and write rank in column A, path in column B, destination URL in column C, and click count in column D
You need to compare the last 90 days against the previous 90 days
The QBR narrative requires a growth story — which paths improved, which declined.
Get the top 50 most-clicked Short.io paths on domain ID 1425403 for the previous 90 days and the most recent 90 days — write both side by side in the workbook with path and click count for the earlier period in columns A and B and path and click count for the recent period in columns D and E
Full ranked comparison with destination URLs in one prompt
Get the top 50 short link paths on domain ID 1425403 for the previous 90 days and the last 90 days by click count — for each path retrieve the destination URL — write rank in column A, then earlier period path, URL, and clicks in columns B through D, then recent period path, URL, and clicks in columns F through H
The QBR deck starts from a complete, correctly formatted dataset.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to retrieve the top-performing Short.io paths for your domain and time window. Also see how to export domain analytics broken down by country and referrer, or pull raw click events for intraday traffic analysis.