The Scenario
The localization decision has been sitting in a Notion doc for three weeks. The product manager needs one thing before moving forward: actual data on where the visitors are coming from. Not the Plausible dashboard screenshot someone attached to the doc in February — real numbers, current, in a sheet where they can be sorted and compared.
You have 90 days of traffic sitting in Plausible. You need it broken down by country, with visitor counts and share of total, in a Google Sheet that the localization team can filter.
The bad version:
- Open Plausible, navigate to the Countries breakdown, and find it only shows the top 10 by default — you need all countries.
- Export the CSV, which exports fine — but doesn't include the percentage share column you saw in the UI, only raw visitor counts. You have to calculate share manually.
- Paste into the sheet, add a SUM formula in a spare cell, write a percentage column next to visitors, and realize you forgot to include bounce rate — which means starting the export over.
The localization team is waiting. The product manager is sending follow-up pings.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It queries Plausible's country breakdown and writes the results directly into your columns — including calculated fields you ask for in the same prompt.
Open the localization sheet and run this prompt:
Query Plausible for a country breakdown of visitors for the past 90 days and write country name (A), visitor count (B), and percentage of total (C) into this sheet — include all countries, not just the top 10
What You Get
- Column A: country name in full (e.g., United States, Germany, Brazil)
- Column B: unique visitor count for that country over 90 days
- Column C: that country's share of total visitors as a percentage
- All countries returned by Plausible are included — not capped at 10 or 20
- Rows sorted descending by visitor count
What If the Data Is Not Quite Ready
You also need bounce rate per country to assess engagement quality
Query Plausible for a country breakdown for the past 90 days — write country (A), visitors (B), percentage of total (C), and bounce rate (D) into this sheet — include all countries
You want to flag countries that represent over 5% of traffic
Query Plausible for all countries by visitor count for the last 90 days — write country (A), visitors (B), percentage of total (C) — then in column D flag any country where percentage exceeds 5% with the label Priority market
You need to compare this quarter's geographic split to last quarter's
Query Plausible for country visitor counts for the past 90 days — write country (A) and visitors (B) — then in column C do a VLOOKUP against the Q1 Geography tab to pull last quarter's visitor count for the same country, and in column D calculate the percentage change
Pull all countries, calculate share, flag priority markets, and write a top-3 summary in one prompt
Query Plausible for a full country breakdown for the last 90 days — write country (A), visitors (B), share of total (C) — flag any country above 5% in column D as Priority — then in cell F1 write a one-line summary listing the top 3 countries by visitor count and their shares
One prompt, all the data the localization team needs to make the call.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet where you track your audience or localization planning — then ask it to pull your Plausible country breakdown for the last quarter. For related reads, see the hub overview or the spoke on cross-site traffic overview.