Using a Geo Map with a Google Sheet in Data Studio
I have a Data Studio Report. The Data Source for this report is a Google Sheet. One of the columns in this Sheet is called "Location". I want to put data in this column that I can show in a Geo Map. I can't seem to figure out what to put in this column to use as the dimension for the Geo Map.
I tried using the Geographical IDs available here. However, I didn't have any success with that. For example, For "New York, NY", I tried using the following values in the column:
- New York
- New York, NY
What am I missing? What should I be using?
Thank you for your help
Re: Using a Geo Map with a Google Sheet in Data Studio
I was able to get this working successfully from Google sheets to populate into data studio maps.
Several options seem to work with the maps:
In the type Geo we can specify the following options with corresponding values in the Google Sheets
Country - Country Name - e.g. United States
Country Code - ISO Country Code - e.g. US
Region - State Name - e.g. Texas
Region Code - State ISO Code - e.g. US-TX
City - City Name - e.g. Chicago
The only one I haven't had any luck with are the Metro ID which appear to be the 6 digit DMA region codes listed in the list you referenced above. When put in Plain text format Datastudio seems to recognise the format but not display any data on the map which shows the regions. Numeric format doesn't seem to be recognised at all (with a bank map). Strangely this seems to be working as a Metro ID coming from GA but I can't get it working from Sheets.
So if you want a country, state or city it works well, but DMA region is playing hard to get.