3.4K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
Guide Me

landing page vs. country visitors come from

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭


I'm looking for a way to make a report of website visitors with understanding from what country they come and how many per month. I have come this far:

behaviour > all pages  with secondary dimension country:Schermafbeelding 2016-09-01 om 11.42.22.png


This gives me an overview of all pages and countries + numbers.


I'm hoping to get something like this:  with the numbers being unique visits or overall visits etc.

Schermafbeelding 2016-09-01 om 12.03.23.png


I can also sort by page title which makes it possible to have all pages that have the same title (but different language) clustered.


I have come this far!  I hope someone can help me with the last part?!


Thank you, greetings,





1 Expert replyverified_user
Marked as Best Answer.
Accepted by topic author Stefan Hendriks
September 2016

Re: landing page vs. country visitors come from

Rising Star
# 2
Rising Star
Creating reports like this is best done using the Google Analytics API. There is a great tool called Query Explorer that you can use to play with your live date.

For a report like this, I would do one query per page (one for page one, one for page two, etc) in the API and pump the data to a spreadsheet. Here is a link

add in your authorization, select your account, property, and view and change the filter (you will see it on the page) to whatever pagename you desire.

Again - not a tool to use manually, but you can custom-build a pretty robust report that gives you the data you want in a spreadsheet format. Check out while you are there.
Director of Marketing | Nehmedia | Partner Profile

Re: landing page vs. country visitors come from

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Thank you Philip!