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

landing page vs. country visitors come from

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

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,

 

Stefan

 

 

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
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

https://ga-dev-tools.appspot.com/query-explorer/?start-date=30daysAgo&end-date=yesterday&metrics=ga%...

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 https://ga-dev-tools.appspot.com/spreadsheet-add-on/ while you are there.
_________________________________________________________________________
Director of Marketing | Nehmedia | Partner Profile

View solution in original post

Marked as Best Answer.
Solution
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

https://ga-dev-tools.appspot.com/query-explorer/?start-date=30daysAgo&end-date=yesterday&metrics=ga%...

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 https://ga-dev-tools.appspot.com/spreadsheet-add-on/ while you are there.
_________________________________________________________________________
Director of Marketing | Nehmedia | Partner Profile

Re: landing page vs. country visitors come from

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