The Scenario
You're a data analyst at a media company. Your head of digital strategy wants a comprehensive performance breakdown for the company's branded Short.io domain covering Q1 2026 — clicks by country, clicks by referrer, clicks by browser, clicks by device — and she wants it in a structured Excel workbook she can hand to the editorial team for their content planning session on Friday.
The Short.io dashboard shows these breakdowns visually but doesn't export them into a multi-sheet Excel format. Getting country data, referrer data, and device data into separate organized sheets would require you to copy values manually from three different dashboard views.
The bad version:
- Navigate to Short.io analytics for the domain, set the date range to Q1 2026
- Screenshot or manually transcribe the country breakdown table into a sheet labeled "Country"
- Repeat for referrers, then for browsers, then for OS
- Realize the date range reset between two of the views and one of your tabs covers a slightly different window than the others
The Friday session is a planning meeting. Walking in with screenshots instead of a structured workbook undermines the whole point.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to the Short.io API, pulls analytics for the domain and date range you specify, and populates separate worksheets for each dimension.
Fetch comprehensive analytics for my Short.io domain for Q1 2026 and populate my Excel workbook with separate sheets for clicks by country, clicks by referrer, and clicks by device type
What You Get
- A "Country" sheet with click counts by country for Q1 2026
- A "Referrers" sheet with click counts by referrer source
- A "Browsers" sheet and a "Device" sheet with device-level breakdowns
- All four sheets formatted as tables with consistent headers, ready for the editorial team to filter and analyze without reformatting
What If the Data Is Not Quite Ready
You need a rolling 90-day window rather than a fixed quarter
The editorial team wants a trailing 90-day view, not Q1 specifically.
Get Short.io domain analytics for domain ID 1425403 for the last 90 days from today and write the country breakdown, referrer breakdown, browser breakdown, and OS breakdown into separate sheets of my Excel workbook
The head of strategy wants to compare Q4 2025 and Q1 2026 side by side
She's presenting a "are we growing?" narrative and needs both periods in one view.
Get Short.io domain analytics for domain ID 1425403 for Q4 2025 and Q1 2026 — write each period's country breakdown side by side in a single "Country" sheet with column labels marking the period, and repeat the same side-by-side format for referrers, browsers, and device type
You need a summary sheet with totals and top performers for the executive slide deck
The editorial planning session feeds into a board-level summary and needs an executive-facing overview sheet.
Get Short.io domain analytics for domain ID 1425403 for Q1 2026, write country, referrer, browser, and device breakdowns into separate sheets, and create a Summary sheet showing total clicks and the top 5 entries from each dimension formatted for presentation
One-shot: full multi-sheet export plus executive summary
Get Short.io domain analytics for domain ID 1425403 for Q1 2026, write country, referrer, browser, and OS breakdowns into separate labeled sheets, add a Summary sheet with total clicks and top 5 per dimension, and format all sheets as Excel tables ready for filtering
The Friday planning session starts from a complete, structured dataset.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to pull Short.io domain analytics for your date range and populate the sheets. Also see how to find which specific short link paths drove the most clicks, or pull raw clickstream events if you need row-level traffic data.