Accessing data from Google Analytics

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

Prerequisites

You must have access to a Google Analytics account.

The Google Analytics connector must be enabled for use in web clients. For instructions on how do this, see the topic Enabling Google Connectors in Spotfire Web Clients in the TIBCO Spotfire® Analyst User's Guide available on the TIBCO Product Documentation site.

Procedure

  1. On the authoring bar, click Files and data .
  2. In the Files and data flyout, click Connect to and select Google Analytics.
  3. 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.
  4. Follow the login instructions in the dialogs that are displayed. That is, choose or add an account, provide credentials when necessary, and allow access.
  5. 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.
  6. Click Continue.
  7. 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.
  8. Select the metrics and dimensions of interest.
    Note: You can select a maximum of ten metrics and seven 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.
  9. 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.
  10. 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.
  11. Click OK.
    The selected data is added to the summary view in the flyout.
  12. 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.

The Load data from Google Analytics dialog

In this example, data will be loaded from My Account > My Property > My View 1. This data will become a data table when loaded into Spotfire. The left side of the dialog shows the available Metrics and Dimensions divided into categories. The category named Session has been expanded, and two metrics have been selected, Sessions and Avg. Session Duration. In the right part of the dialog, all the selected metrics and dimensions are listed; in this case four metrics and five dimensions. Each metric and dimension will become a column in the new data table. To rename columns, click on the pencil icon. In the lower right part of the dialog, All Users has been selected as the Segment and Last 30 days as the Date range.

Tips

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

By default, the name of the data table is made up of the names of the selected account, property, and view. In this example, the name of the data table is My Account - My Property - My View 1. To change the name of the data table, click the settings icon to the right of the name. In the popover, you can change which view to load data from and you can rename the data table.

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