Connector for Google Analytics – Features and settings

You can connect to and access data from Google Analytics. On this page, you can find information about the capabilities, available settings, and things to keep in mind when you work with data connections to Google Analytics.

Page content

Connector features

The following functionality is available when you access data with the connector for Google Analytics.


Feature	Supported?
Load methods	Import (in-memory)
Custom queries	No
Stored procedures	No
Custom connection properties	No
Single sign-on with identity provider	No
Authoring in web client	Yes
Included in Spotfire distribution on Linux	Yes

Data source properties

There are no properties for the connection data source when you connect to Google Analytics.

Supported 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. The following are the data types that the Google Analytics connector supports.

Table 1. Google Analytics
Database data type	Spotfire data type
CURRENCY	Currency
INTEGER	LongInteger
FLOAT	Real
PERCENT	Real
TIME	TimeSpan

Table 2. Dimensions
Database 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

Supported functions

Because only imported (in-memory) data is supported for Google Analytics, you can use the functions available in the Spotfire in-memory data engine to work with your Google Analytics data.