Data type

Define the kind of data a field holds.

A field's data type tells Data Studio what kind of data to expect when processing that field. A field's type determines how the data appears in your reports, which operations are allowed for it, and which are not. For example, you can't apply an arithmetic function to a Text field, or use a Number field as the date range dimension in a report.

The table below shows the supported field types, along with the kind of data expected as input, and examples of how that data might look in your reports.

Type Expected data Report examples
Number A floating point number. 1,234.56
Percent A floating point number representing a ratio. 61.73%
Duration An integer representing a time duration in seconds. This will be formatted into a standard time display in reports. 01:43:19
Currency A floating point number representing a monetary value. This will be formatted to include the appropriate currency symbol in reports. $1,234.56
Text Zero or more letters, numbers, characters, or symbols.

A1B2C3

Date & Time

An actual calendar date, or an abstract date index. This will be formatted according to the locale, and to the Show As display setting in reports.

Learn more about working with dates.

2018-01-01

Week 1

Boolean

A logical value.

If the data set doesn't provide boolean values, you can create a Boolean field using a calculated field with the CASE statement:

CASE WHEN ... THEN TRUE ELSE FALSE END

true

false

Geo

A value representing a geographic region, such as a country name, latitude and longitude, ISO code, or Google Ads criteria ID.

Learn more about visualizing geographic data.

United Kingdom

51.5074,-0.1278

1006886

URL

An address of a World Wide Web page.

https://datastudio.google.com/
Hyperlink A clickable link to a URL. Hyperlink fields are created by the HYPERLINK function. See an example of Hyperlink fields
Image An image. Image fields are created by the IMAGE function.  
Image Link A clickable image. Image Link fields are created by the HYPERLINK function. See an example of Image Link fields

To change the field type, use the Type drop-down menu in the data source edit page. If the field editing in reports option is enabled for the data source, you can also change field types directly in reports based on this data source.

Was this helpful?
How can we improve it?