The Scenario
You're a UX director who just wrapped a quarterly design review. The team landed on a list of the top twenty landing pages that need attention, but nobody could agree on whether to prioritize the mobile experience or the desktop experience first. Someone remembered that Clarity segments behavioral data by device. That was two weeks ago. Today you finally have time to pull it, and the design sprint planning session is tomorrow morning.
The bad version:
- Open Clarity, switch to the device segmentation view, filter to mobile, read off rage click counts for each of your twenty pages, type them into a Google Sheet. Then do the same for desktop. Then for tablet, because someone will ask.
- Realize you've been reading the rage click count but what you actually need is rage clicks as a percentage of sessions per device, which requires the session counts too — go back and repeat the process for sessions, for each device type, for all twenty pages.
- Spend another thirty minutes building the comparison columns because the three device segments are now scattered across six different columns that don't line up the way the design team wants to read them.
The sprint starts tomorrow and you've spent the last three hours on data entry instead of synthesis. The whole point of having a behavioral analytics tool is to inform decisions faster, not slower.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that sits inside your Google Sheet. It connects to Microsoft Clarity through its built-in integration and can pull segmented behavioral data — broken out by device type — and write it into your sheet in whatever shape you need.
Open the Google Sheet where you're building your device comparison and type into the SheetXAI sidebar:
Export Clarity data for the past 30 days segmented by device type (mobile, tablet, desktop) and write device type, page URL, session count, rage click count, and dead click count into this sheet — one row per page-device combination
What You Get
- One row per unique page-device pairing, so each URL appears up to three times — once for mobile, once for tablet, once for desktop
- Columns land in the order you specified: device type, URL, sessions, rage clicks, dead clicks
- The data arrives unsorted by default, ready for you to apply whatever filter or pivot your design team needs
- No partial rows — if a page had zero sessions on a given device in the period, it's either absent or flagged rather than written as a row of zeros that skews your averages
What If the Data Is Not Quite Ready
I only care about mobile vs. desktop — tablet isn't in scope for this sprint
Pull Clarity behavioral data for the past 30 days for mobile and desktop sessions only, write page URL, device type, session count, rage clicks, and dead clicks into this sheet sorted by page URL — exclude tablet rows entirely
I want rage click rate as a percentage, not just the raw count
Raw counts are hard to compare across pages with different traffic volumes. Normalize it:
Export Clarity data for the past 30 days segmented by device type, write page URL, device type, sessions, rage clicks, and dead clicks into columns A–E, and in column F write the rage click rate as a percentage of sessions — one row per page-device combination, sorted by rage click rate descending
The sheet already has the page URLs — I want Clarity data matched to them
For each URL in column A, pull Clarity session count, rage click count, and dead click count for the past 30 days segmented by mobile and desktop, and write mobile sessions, mobile rage clicks, desktop sessions, and desktop rage clicks into columns B–E
Get the full device comparison with flagged mobile outliers in one pass
Export Clarity data for the past 30 days segmented by mobile and desktop, write page URL, device type, sessions, rage clicks, dead clicks, and rage click rate (rage clicks ÷ sessions as a percentage) into columns A–F, then in column G write 'mobile priority' for any page where mobile rage click rate exceeds desktop rage click rate by more than 3 percentage points — sort by mobile rage click rate descending
One prompt gets you the data, the rate calculation, and the comparison flag — the design sprint prioritization is already embedded in the output.
The principle: when the decision rule is simple enough to state in a sentence, include it in the prompt so the output is already actionable when it lands.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet you use for responsive design audits or device-level UX tracking — then ask it to pull Clarity's mobile and desktop behavioral data for your top landing pages before tomorrow's sprint. For related tasks, see Export Microsoft Clarity Rage Click Data Into a Google Sheet or the Microsoft Clarity integration overview.