Analytics
1.6K members online now
1.6K members online now
Ask questions about filter set-up and issues with using filters in Google Analytics reports
 
Guide Me
star_border
Reply

Filter by country including rest of the world

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi all!

I'm trying to build a report which includes just a few countries, but I want that the percentage is calculated on the total (including countries which are excluded by the filter). Example: I want to know the % number of Sessions from US and UK compared to the total.

Right now if I add as filter "United States|UK" I get something like:

"US 80% UK 20%"

I want to know the percentage on the overall number of Sessions so:

"US 20% UK 5%"

Ideally the best report would be:

"US 20% UK 5% Other countries 75%"

Is it possible to achieve something like that with Google Analytics?

Thanks

1 Expert replyverified_user

Re: Filter by country including rest of the world

A T
Participant ✭ ✭ ✭
# 2
A T
Participant ✭ ✭ ✭
Its better if you use custom segments.

Re: Filter by country including rest of the world

Rising Star
# 3
Rising Star
Carla,

You can use segments as AT points out but you will still have to do some math and include all users in addition to your custom segment. Alternatively you could create two dashboard widgets one filtered for the countries in question and one that is not (or do this in data studio).

Lastly, you could use the API and pull the data into Google Sheets using the GA plugin and call all data, then just the countries you want and do this in a calculation.

https://developers.google.com/analytics/solutions/google-analytics-spreadsheet-add-on


Best,

Theo Bennett
Analytics Evangelist at MoreVisibility | Contact Me
Connect on LinkedIn