Segment Microsoft Clarity Behavioral Data by Device Into an Excel workbook

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:

1. Open Clarity, switch to the device segmentation view, filter to mobile, export a CSV, open it in Excel, reformat and paste the rage click counts for your twenty pages into the workbook. Then switch Clarity to desktop, export another CSV, repeat.
2. Realize you've been pulling the rage click count but what you actually need is rage clicks as a percentage of sessions per device — which means you also need the session counts for mobile and desktop separately. Two more exports.
3. Spend another hour building the comparison columns across four CSV imports because the device segments landed in separate files and your workbook needs them side by side.

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 Excel workbook. 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 workbook in whatever shape you need, without a CSV export in sight.

Open the Excel workbook 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 Excel 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
• All three device segments arrive in the same workbook sheet, side by side rather than in separate files
• 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 workbook 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 Excel workbook 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 Build a Page Engagement Benchmark Sheet From Microsoft Clarity in an Excel workbook or the Microsoft Clarity integration overview.