AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
2.7K members online now
2.7K members online now
Ask questions about Data Studio
Guide Me

Google Data Studio does not recognize Italian City

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm creating a Data Studio report using Google Spreadsheet as a data source.
I've already create a Geo Map based on italian regions, and after many attemps I've managed to do that, normalizing all my values to the italian names of regions such as "Piemonte", "Lazio" and setting the field as "Region Code" ecc..
Now I want to give user more detailed Geo Map, based on provinces (ie "Milano", "Siena", "Napoli") but the widget does not show the data.
I've tried to use two letter province (MI, SI, NA) or extended name like above, or even the AdWords Criteria ID, also creating a funcion field with the function TOCITY(X, 'CRITERIA_ID') but nothing.
How can I accomplish my purpose?