Accessing data from Google Analytics

If you have a Google Analytics account, you can access and analyze data from Google Analytics in Spotfire.

Before you begin

You must have access to a Google Analytics account.

The Google Analytics connector must be enabled for use in on-premises web clients. See Enabling Google connectors in Spotfire web clients.

Procedure

On the authoring bar, click Files and data .
In the Files and data flyout, click Connect to and select Google Analytics.
In the Google Analytics flyout, click New connection.
- You might have access to shared connections to Google Analytics in the library, which you can open to access a prepared selection of data from the external data source. Shared connections are listed under In library. If you access data from a shared connection, you just log in and click OK.
Follow the login instructions in the dialogs that are displayed. That is, choose or add an account, provide credentials when necessary, and allow access.
In the next dialog that is displayed, select which Google Analytics view you want to load data from.
The selected view will become a data table in Spotfire.
Click Continue.
In the left part of the dialog, all the metrics and dimensions are grouped together in categories. Click on the plus sign next to the category name to expand a category and see the metrics and dimensions.
Select the metrics and dimensions of interest.
You can select a maximum of 10 metrics and 9 dimensions. This is due to a limitation in Google Analytics. Note that some combinations of metrics and dimensions will not be valid. For the latest information about which combinations are valid, see the official documentation for Google Analytics.

The selected metrics and dimensions are added to the list to the right in the dialog.
Optionally, you can change what Segment to load data for. By default, the segment All Users is selected.
System segments are segments that are available to all users of the same account. Custom segments are segments that have been defined by yourself or your company.
Note: It is not possible to select segments when you access data from a Google Analytics project.
Optionally, you can change what Date range to load data for.
By default, the predefined range Last 30 days is selected, but you can change to another predefined range, specify your own range, or select to Let the end user specify range.
Click OK.
The selected data is added to the summary view in the flyout.
In the flyout, you can change the name of the new data table. Click OK when you are satisfied.
The selected metrics and dimensions are loaded into Spotfire.

Tips

To read a description, point to the question mark next to a metric or dimension name.

Tip: You can go back and edit the settings in this dialog from the Data canvas. See Editing a data connection from the data canvas for more information.

Note: When you access Google Analytics data, Spotfire uses the libraries Google.Analytics.Admin.V1Beta and Google.Analytics.Data.V1Beta to call the Google Analytics APIs.

The Load data from Google Analytics dialog

About this task


Option	Description
[Data table name]	Shows the name that will be used as the data table name in Spotfire. By default, the name is built by the selected account, property, and view: `My Account - My Property - My View 1` If you click on the cogwheel, you can change which account, property and view to load data from, and you can give the data table a name that better reflects the data you are loading into Spotfire.
[Search]	Search for metrics and dimensions.
Metrics \| Dimensions	The metrics and dimensions are grouped together in categories. Click on the plus sign next to a category name to expand it and view its metrics and dimensions. Note that the categorization is not the same in Spotfire as in Google Analytics. However, the categorization in Spotfire is controlled by Google Analytics and cannot be changed. Metrics are listed to the left in the expanded category, and dimensions to the right. Each metric and dimension you select will become a column in the new data table. The maximum is 10 metrics and 9 dimensions. This is due to a limitation in Google Analytics. Tip: Click on the question mark next to a metric or dimension name to see a description: Note: Some combinations of metrics and dimensions are not valid, and in most cases, the check boxes will become disabled to prevent invalid combinations. However, there are also cases where it is possible to select an invalid combination, resulting in an error message. The reason might be that a certain metric must be combined with certain dimensions to be valid. Another reason might be that updates in Google Analytics cannot be detected by Spotfire. This is due to a limitation in Google Analytics. Refer to the official Google Analytics documentation for the latest information about valid and invalid combinations.
Remove all	Click to remove all of the selected metrics and dimensions.
	Click the pencil icon to edit the selected metrics or dimensions. You can change the names or remove individual metrics or dimensions.
Selected metrics	Shows the metrics that you have already added.
Selected dimensions	Shows the dimensions that you have already added.
Preview	Click to see a preview of the data that will be loaded.
Segment	Lists all the available segments. There are three groups of segments: System segments are available to all users with access to the current Google Analytics account. Custom segments are defined by you or your company. If a connection is shared with users who do not have access to the custom segment, the segment will appear to them under 'Other segments' if they edit the connection. Other segments are segments used in the current connection, but have been defined by another user or your company. This type of segment is only available as long as you do not edit the connection and change to a system segment or custom segment.
Date range	Lists a number of pre-defined date ranges. You can also specify a custom date range, or select to let the end user choose which date range to load data from.