skip to main content
Supported data types : Google Analytics data types
 

Try DataDirect Cloud Now

Google Analytics data types

The following table shows how the Google Analytics data types are mapped to the standard SQL types.
Table 4. Google Analytics data types
Google Analytics data type
SQL type
Notes
Array
VARCHAR(255)
Returns the elements of the array, combined together and separated by commas
Boolean
BOOLEAN
CDSType
VARCHAR(18)
Either COST or DIMENSION_WIDENING
Date
DATE
Datetime
TIMESTAMP
Float
DOUBLE
Integer
BIGINT
Long
BIGINT
Metadata Type
VARCHAR(9)
Must be either METRIC or DIMENSION
Percent
DOUBLE
SamplingLevel
VARCHAR(16)
Must be DEFAULT, FASTER, HIGHER_PRECISION
String
VARCHAR(255)
Time
DOUBLE
A duration measured in number of seconds
URL
VARCHAR(255)