Tools

Google Data Studio

ID googledatastudio

other

With Data Studio, you can easily report on data from a wide variety of sources, without programing. In just a few moments, you can connect to data sets such as: Databases, including BigQuery, MySQL, and PostgreSQL. Google Marketing Platform products, including Google Ads, Analytics, Display & Video 360, Search Ads 360.

Website
https://developers.google.com/datastudio/connector/semantics#semantic-type-detection
Supported types
14

Supported semantic types

IDNameCategoriesCountriesDescription
geopoint Geopoint draft geo global Basic geopoint as coordinates
country Country code or name geo global A country is a distinct territorial body or political entity. It may be an independent sovereign state or part of a larger state,[2] as...
city City PII geo, pii, common global A city is a large human settlement. It can be defined as a permanent and densely settled place with administratively defined boundaries...
datetime Date and time datetime global Date and time of day. The regexp covers the ISO 8601 extended form YYYY-MM-DDThh:mm[:ss[.fff]] with an optional time zone (Z or an...
time Time draft datetime global Time of the day, like 12:00 or 10PM or 11:05 or 18:01:27
address Address (physical location) PII common, pii, geo global Geographic address, commonly consist of postindex, country, area, town, street and building
person_name Chinese person name by known name PII draft persons CN Chinese person name by known name identifier
year Year datetime global A calendar year in western notation like 2022 or 1913
date Date datetime global Calendar date. The regexp covers the ISO 8601 extended form YYYY-MM-DD; other notations, such as DD.MM.YYYY, are patterns of this datatype.
month Month draft datetime global Month as number since start of the year. Could be from 1 to 12
day Chinese day name draft datetime global Chinese day name identifier
dayofweek Day of week draft datetime global Week day name
boolean Boolean common global In computer science, the Boolean data type is a data type that has one of two possible values (usually denoted true and false) which is...
url Uniform Resource Locator (URL) common, internet global Address of a resource on a network that also says how to retrieve it: a scheme such as https, a host, an optional port, a path, a query...

Use this record