The Scenario
You're a web analyst at a fintech company. It's Thursday afternoon and compliance wants to know where traffic came from during a specific two-hour window yesterday — which countries, which referrers, which devices. A regulatory inquiry is asking questions about a traffic spike that hit the company's branded Short.io domain around 3 PM Wednesday. They need raw event data, not dashboard summaries.
The Short.io UI shows aggregate analytics. What you need is the individual click event log for that specific window — timestamp, country, browser, referrer — so you can confirm whether the spike was organic traffic or something else.
The bad version:
- Try to find a raw event export in the Short.io dashboard — there isn't one in the standard UI
- Navigate to the Short.io API documentation, find the clickstream endpoint, authenticate with the API key, write and run the API call, handle the pagination, parse the JSON output
- Paste the fields manually into an Excel workbook, format the columns, add headers
The compliance team needs this by 5 PM. It's 3:30 PM. The API documentation route is at least two hours if you've never done it before.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Short.io's clickstream endpoint, fetches the events for the window you specify, and writes them into the workbook row by row.
Pull the most recent 500 click events from Short.io domain ID 1425403 and populate my Excel sheet with one row per click event including country, referrer, and device info
What You Get
- One row per click event in the workbook
- Columns for timestamp, country, browser, operating system, and referrer source
- Events in reverse chronological order so the most recent clicks appear first
- Data ready for filtering, sorting, and pivot table analysis without reformatting
What If the Data Is Not Quite Ready
You need events filtered to the specific two-hour compliance window
The spike happened between 3 PM and 5 PM Wednesday — you don't need the full event history for the compliance response.
Fetch raw click events from Short.io domain ID 1425403 for Wednesday between 3 PM and 5 PM UTC and write each event's timestamp, country, browser, OS, and referrer into columns A through E of my Excel workbook
You also need to include the specific short link path that was clicked
The compliance inquiry is asking whether the traffic spike was concentrated on one specific link or distributed across many paths.
Fetch raw click events from Short.io domain ID 1425403 for Wednesday between 3 PM and 5 PM UTC — write each event's timestamp, short link path, country, browser, OS, and referrer into columns A through F, sorted by timestamp descending
You need a summary pivot alongside the raw events for the compliance report
The compliance team wants the raw data as an exhibit but also a clean summary of clicks by country for the executive summary.
Fetch raw click events from Short.io domain ID 1425403 for Wednesday between 3 PM and 5 PM UTC, write the raw events into a sheet named "Raw Events" with timestamp, path, country, browser, OS, referrer — then create a "Summary" sheet with click counts grouped by country sorted descending and click counts grouped by referrer sorted descending
Full compliance evidence package in one shot
Fetch raw click events from Short.io domain ID 1425403 for Wednesday between 2 PM and 6 PM UTC — write each event's timestamp, short link path, country, browser, OS, and referrer into a "Raw Events" sheet — create a Summary sheet with click counts grouped by country in columns A and B, by referrer in columns D and E, and by short link path in columns G and H, all sorted descending by count — add a header row to each summary section with the dimension name and time window
The compliance response is ready before 5 PM with both the exhibit and the executive summary.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to pull the latest raw click events from your Short.io domain for the time window you need. Also see how to export domain analytics broken down by country and referrer for longer-term trend analysis, or find which short link paths are driving the most aggregate traffic.