Google Analytics Data Types


When you are configuring 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 type mappings applicable when working with Google Analytics.

Metrics

Google Analytics Data Type

Spotfire Data Type

Supported

CURRENCY

Currency

Yes

FLOAT

Real

Yes

PERCENT

Real

Yes

INTEGER

LongInteger

Yes

TIME

TimeSpan

Yes

Dimensions

Google Analytics Data Type

Spotfire Data Type

Supported

STRING

In most cases.

String

 

Yes

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

Yes

STRING

If the dimension is Date.

Date

 

Yes

STRING

If the dimension is Longitude or Latitude.

Real

 

Yes

See also:

Loading Data from Google Analytics

Details on Load data from Google Analytics