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 — not assumptions based on industry benchmarks, real numbers from your site.
Specifically: the split between desktop, mobile, and tablet visitors, and the top 5 browsers, for the past 60 days. She wants it in a Google Sheet so she can add notes next to each row.
You've never exported device or browser data from Plausible before. You're not sure how.
The bad version:
- Open Plausible, find the Device breakdown in the sidebar, read the percentages — but you need counts, not just percentages, and the export button only appears on some views.
- Navigate separately to the Browser breakdown, write down the top browsers and their visitor counts on a sticky note, then close the tab.
- Open a blank sheet, create a two-section layout (device type on the left, browser on the right), enter the numbers by hand, realize you missed the mobile percentage, go back to Plausible, and reconcile what you wrote down with what the dashboard is currently showing.
The UX lead needs this before end of day. You've already spent 35 minutes on what should have been a 3-minute lookup.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It can call both the device and browser breakdowns from Plausible in one step and write them side by side in your sheet.
Open the sheet and run this prompt:
Query Plausible for a device-type breakdown for the past 60 days and write device type (A), visitors (B), and percentage of total (C) — then query the browser breakdown for the same period and write browser name (E), visitors (F), and percentage of total (G) in the same sheet
What You Get
- Columns A-C: device types (Desktop, Mobile, Tablet), visitors per type, share of total
- Columns E-G: browser names (Chrome, Safari, Firefox, Edge, etc.), visitors per browser, share of total
- Both datasets on the same sheet, side by side, for the UX lead to annotate directly
- All returned values from 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 tight
Query Plausible for device breakdown (past 60 days) and write device type (A), visitors (B), percentage (C) — then query browser breakdown and limit to top 5 by visitors, writing browser (E), visitors (F), percentage (G)
You want to add a column flagging browsers below 5% share as Low priority
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 want to break down mobile visitors further by operating system
Query Plausible for a device-type breakdown for the past 60 days and write device type (A), visitors (B), share (C) — then query the OS breakdown for the same period and write 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 summarize the 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 type and browser combination covers over 60% of visitors
All the data the QA team needs, annotated and summarized, in one pass.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet where you track UX or performance 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.