Data Studio
2.2K members online now
2.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Data Studio geographical reference by nation/regions

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello, I would like to implement a geomap of Italy, and divide data (number of requests) by regions (all the data is listed in a google sheet document). Is there a way to implement it?
Right now I can only set the map by continent in the "zoom area" section. I guess italian regions must be named in english. Any suggestions?

 

EDIT: in the source edit section I can assign "region" to the specific column, but It shows an US map instead of Italy

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Paolo D
October 2016

Data Studio geographical reference by nation/regions

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Yes, I tested the geo report inside analytics too: It can only display per-city data in the map, not region-data. So I guess italian regions are still not implemented yet.

 

View solution in original post

Data Studio geographical reference by nation/regions

[ Edited ]
Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

If your data source is Google Analytics you could do this:

try selecting "city" in the dimension and in zoom area select Country > IT

 

If your data source is Google Sheets, could you share a small sample data of 4-5 rows\\

You could use REGEXP_MATCH to rename English names to Italian.

 

Thanks.

 

 

Data Studio geographical reference by nation/regions

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

An excerpt of the sheet is at this link: https://docs.google.com/spreadsheets/d/1drYciRCWro8d-iE4Cw7n7nZIzNugPCeSwyZ3LhbkIB0/edit?usp=sharing

 

Column F represents the regions, extracted directly from Analytics.

 

In Datastudio I cannot set the F column as "geographic data" type > "region". It returns me an error like "the data could be invalid". 

In the zoom area I can see lots of world countries, but "IT" isn't on the list actually!

 

Data Studio geographical reference by nation/regions

Top Contributor
# 4
Top Contributor

Patience, geo reports are still very much US-centric.

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan
Marked as Best Answer.
Solution
Accepted by topic author Paolo D
October 2016

Data Studio geographical reference by nation/regions

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Yes, I tested the geo report inside analytics too: It can only display per-city data in the map, not region-data. So I guess italian regions are still not implemented yet.