|
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)
|