Jump to content
  • Google Analytics and Spotfire


    Google Analytics is the most widely used tool to analyze web traffic usage today. It's data on pageviews and conversions provide demographic breakdowns of everything happening across your web properties.

    With Spotfire it's easy to blend Google Analytics data with data from other sources to answer more questions than what is possible with only Google Analytics data.With Spotfire Cloud or an on premises setup, it's easy to share these insights with thousands of colleagues, so they too can take action based on data driven decisons.

    We have created a Youtube video for a quick overview of how it works and more detailed instructions below.



    Getting started with Google Analytics on Spotfire on premises

    The guide for Spotfire Cloud below can be followed for Spotfire on premises as well, but for on premises you might need to configure the Google Analytics API. If this is needed you will receive Error 400: redirect_uri_mismatch. Both the Google Analytics API and Spotfire preferences need to be configured. They are both described in the Spotfire Server installation guide here.

    Getting started with Google Analytics on Spotfire Cloud

    Go to https://spotfire.cloud.tibco.com and login. Register for a 30 day trial if needed.

    Once logged in click on New Analysis:

    Click on the Google Analytics data source:

    1.png.8f0b574b56796f65eee23b0abb02e6f3.png
    Login to Google and allow Spotfire to access offline data.

    2.png.a03d974a4912f75329aa0f41e9788ca7.pnggoogle2.png.8afc0418a99715ce0c710cfad55af228.png

    Select a Google Analytics view.

    The Google Analytics data loading Ui is now presented.

    3.png.58c4c12d734a9fb924d874b067188b32.png
    From here it's easy to:

    • Search for metrics and dimensions.
    • Add them to your view by ticking their check box.
    • Select a date range, optionally with no end date to allow the latest data to be loaded ech time the analysis is opened.
    • Filter data by Segment.
    • Preview data.
    • Edit column names or remove columns by clicking the pen icon.

    4.png.1eeb2d4d5101694aac9f984cbbef5570.png
    You could also let Spotfire ask end users to specify a date range using prompts.

    5.png.c4f21a8b3cf3715841caa23185e8f845.png
    End users are then presented with the corresponding ptompt before data is loaded.

    6.png.2bfab0cfe52a81862723f53ce737d227.png
    Note

    The number of dimensions and metrics that can be added is limited by Google Analytics.

    The Date dimension is automatically added. Remove it if it's not needed.

    The amount of data increases rapidly with the number of dimensions selected.

    When you are ready to save the analysis, review how you prefer data to be loaded in the Source View:

    7.thumb.png.c6d85bdc65b3f7b24d287c4984050535.png
    Note:

    "Always new data" is default which means no data is stored in the analysis file. Each time the analysis is opened data will be loaded from Google Analytics.

    New data when possible stores the latest data set in the analysis file but it's only used if the data source can't be reached or if the user decides to skip data loading when opening the analysis file by selecting the "Use stored data" option:

    The Source View is also where data can be refreshed manually.

    The above is also available for on premises users holding a Business Author license.

    Analyzing Google Analytics data using the Spotfire Windows client with Spotfire Cloud

    The Spotfire Windows client, Spotfire Analyst, is available for both cloud and on premises users.

    Download Spotfire Analyst from https://spotfire.cloud.tibco.com/tsc/#!/downloads

    Review the system requirements and install Spotfire Analyst on a Windows machine.

    Launch Spotfire Analyst and open your Gogle Analytics analysis file by selecting Open From Library (also available from the File menu):


    User Feedback

    Recommended Comments

    There are no comments to display.


×
×
  • Create New...