Connecting Google Analytics

CONTENTS

Home

Connect to Google Analytics

Google Analytics is only supported in Premium and Enterprise Editions

Here’s what you need to connect:

  • View ID
  • Start Date
  • Credentials
bipp supports a maximum of 7 dimensions and 10 measures

Create a Google Analytics Datasource in bipp

  1. Select Datasources from the Home Navigation pane to open the Datasources page.

    Datasource Page

  2. Click New Datasource on the Datasources page.

    New Datasource Page

  3. Enter a Name. For example, TestGoogleAnalytics.

  4. Select GoogleAnalytics for SQL Dialect for your database. bipp creates and enforces the rules for the selected dialect.

    Choose Datasource

  5. Enter the information for your Google Analytics:

    • View_id: The unique ID used to retrieve the Analytics data. You will find this in Google Analytics account settings.information Details
    • Start_date: Start date for fetching Analytics data. Allowed formats are YYYY-MM-DD | today | yesterday | {n}daysAgo (where n is a positive integer)
    • End_date: End date for fetching Analytics data. Allowed formats are YYYY-MM-DD | today | yesterday | {n}daysAgo (where n is a positive integer). If the end date is not provided, then today is considered the end date.
    • Credentials: click Choose File and navigate to the credentials file for the sheet. The credentials file must be set up through the Google API. Refer to Datasource Google Analytics Authorizing Access to Google Analytics.create DataSource
  6. Click Create to add the datasource.

Congratulations! You have successfully created a Google Analytics datasource in bipp.