The Scenario
QA testing starts next week. Before your team decides which devices and browsers to prioritize, your UX lead has asked for actual usage data — real numbers from your site, not industry benchmarks.
Specifically: the split between desktop, mobile, and tablet visitors, and the top browsers, for the past 60 days. She wants it in an Excel workbook so she can add notes next to each row and share it with the dev team.
You've never pulled device or browser data from Plausible before.
The bad version:
- Open Plausible, find the Device breakdown, read the percentages — but you need raw visitor counts too, and the export button only appears in certain views.
- Navigate separately to the Browser breakdown, write down the browser names and counts on a notepad.
- Open Excel, create a two-section layout manually, enter all the numbers by hand, realize you missed one mobile percentage, go back to Plausible, and spend 10 minutes reconciling what you wrote down with what the dashboard currently shows.
The UX lead needs this before end of day. You have three other things open and a standup in an hour.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It can call both the device and browser breakdowns from Plausible in one step and write them side by side in your worksheet.
Open the workbook and run this prompt:
Pull visitor counts by device type and by browser from Plausible for the last 2 months and write them side by side into this Excel sheet for a UX audit — device type (A), visitors (B), share (C); browser name (E), visitors (F), share (G)
What You Get
- Columns A-C: device types (Desktop, Mobile, Tablet), unique visitors per type, share of total
- Columns E-G: browser names (Chrome, Safari, Firefox, Edge, etc.), unique visitors per browser, share of total
- Both datasets on the same worksheet, side by side, ready for the UX lead to annotate
- All values returned by Plausible — not capped at a top-5 preview
What If the Data Is Not Quite Ready
You only want the top 5 browsers to keep the layout clean
Query Plausible for device breakdown (past 60 days) and write device type (A), visitors (B), percentage (C) — then query browser breakdown, limit to top 5 by visitors, and write browser (E), visitors (F), percentage (G)
You want to flag low-priority browsers automatically
Query Plausible for device type and browser breakdowns for the past 60 days — write device (A), visitors (B), share (C), browser (E), visitors (F), share (G) — then in column H flag any browser where share is below 5% as Low priority
You also need OS breakdown to inform mobile testing decisions
Query Plausible for device-type breakdown and OS breakdown for the past 60 days — write device type (A), visitors (B), share (C); OS name (E), visitors (F), share (G) so I can see mobile OS distribution alongside device type
Pull device data, browser data, flag priorities, and write a QA recommendation in one shot
Query Plausible for device type breakdown and browser breakdown for the past 60 days — write both side by side — flag any browser or device type below 5% share in a priority column — then write a note in cell I1 summarizing which device and browser combination covers over 60% of visitors and should be the primary QA focus
All the data the QA team needs, flagged and summarized, before the standup ends.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook where you track UX or testing priorities — then ask it to pull your Plausible device and browser breakdown for the last two months. For related reads, see the hub overview or the spoke on cross-site traffic overview.