Google Analytics Data Types

When you are setting up a connection to an external data source, Spotfire needs to map the data types in the data source to data types in Spotfire. See below for a list of the different data types that Spotfire supports and the applied data type mappings when working with Google Analytics.

Metrics

Google Analytics Data Type	Spotfire Data Type
CURRENCY	Currency
INTEGER	LongInteger
FLOAT	Real
PERCENT	Real
TIME	TimeSpan

Dimensions

Google Analytics Data Type

Spotfire Data Type

STRING

In most cases.

String

STRING

If the dimension is any of the following:

Query Word Count
Hour of Day
Day of the Month
Day of Week
Days Since Last Session
Days to Transaction
Hour
Internal Promotion Position
ISO Week of the Year
ISO Year
ISO Week of ISO Year
Minute
Month of the year
Day Index
Hour Index
Minute Index
Month Index
Week Index
Page Depth
Product List Position
Screen Depth
Count of Sessions
Session Duration
Sessions to Transaction
Week of the Year
Year
Month of Year
Week of Year

Integer

STRING

If the dimension is Date.

Date

STRING

If the dimension is Longitude or Latitude.

Real