The Scenario
You're a data analyst and your head of growth just forwarded you a message at 8 AM: "Can you put together a breakdown of how our branded short domain performed over the last 90 days? I want to see clicks by country, by referrer, and by device. Meeting is at 2 PM."
The problem is that Short.io's dashboard shows these breakdowns in the UI, but it doesn't export them neatly into a spreadsheet. To get country-level data, referrer data, and device data, you'd have to manually pull each report tab, screenshot it, or copy the values by hand into separate sheets.
The bad version:
- Open Short.io and navigate to the Analytics section for your domain, set the date range to the last 90 days
- Screenshot the country breakdown table and manually transcribe the values into a sheet tab named "Country"
- Repeat for referrers — navigate, set the date range again, copy the table, paste into a second tab
- Repeat for browser and OS breakdowns
- By 11:30 AM you have partial data in three tabs with inconsistent formatting and no way to build pivot tables from screenshots
The meeting is in two and a half hours. You haven't started the analysis.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the domain ID you specify, pulls analytics from the Short.io API for the date range you need, and writes each dimension into a separate tab.
Get Short.io domain statistics for domain ID 1425403 for the last 90 days and write the country breakdown, referrer breakdown, browser breakdown, and OS breakdown into separate tabs of my sheet
What You Get
- A "Country" tab with click counts by country for the 90-day period
- A "Referrers" tab with click counts by referrer source
- A "Browsers" tab and an "OS" tab with device-level breakdowns
- All four tabs formatted as tables with consistent column headers, ready for pivot tables or charts without reformatting
What If the Data Is Not Quite Ready
You need a specific date range rather than the last 90 days
The head of growth specified Q1 2026 (January 1 through March 31) for the board deck, not a rolling 90-day window.
Get Short.io domain analytics for domain ID 1425403 for the period January 1 through March 31, 2026 — write the country breakdown, referrer breakdown, browser breakdown, and OS breakdown into separate tabs of my sheet
You want to compare two consecutive 90-day periods side by side
You need to show the growth team whether performance improved quarter over quarter.
Get Short.io domain analytics for domain ID 1425403 for both the period October 1 through December 31, 2025 and January 1 through March 31, 2026 — write each period's country breakdown side by side in a single "Country" tab with column labels marking the period
The head of growth also wants a summary tab
She asked for the raw breakdowns but also a single overview tab with total clicks and top 5 per dimension.
Get Short.io domain analytics for domain ID 1425403 for the last 90 days, write country, referrer, browser, and OS breakdowns into separate tabs, and create a Summary tab showing total clicks and the top 5 entries from each dimension
One-shot: date range plus full multi-tab export plus summary
Get Short.io domain analytics for domain ID 1425403 for Q1 2026 (January 1 through March 31, 2026), write country, referrer, browser, and OS breakdowns into separate labeled tabs, and add a Summary tab with total clicks and top 5 per dimension — format all tabs as tables ready for pivot table creation
Walk into the 2 PM meeting with analysis already in hand.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, tell it which Short.io domain ID you want analytics for and what date range — then ask it to populate the tabs. Also see how to find the top-performing link paths on the same domain, or pull raw clickstream events if you need row-level traffic data.