Strategy One

Connect to Google Analytics

Create an OAuth Application in Google

  1. Sign in to https://console.cloud.google.com/apis/credentials.

  2. In the left navigation, click Credentials under APIs & Services.

  3. Click Create credentials and choose OAuth client ID.

  4. Expand the Application type drop-down list and choose Web application.

  5. Type an application Name and click Create.

  6. Copy the Client ID and Client secret values or click Download JSON. You will need Client ID and Client secret for future steps.

  7. Click OK.

  8. Click the application you just created.

  9. Click Add URI and add a Callback URL for Web, Library, or Workstation using the following formats:

    • Web redirect URI: https://<servername>/MicroStrategy/servlet/mstrWeb?evt=3172

    • Library redirect URI: https://<servername>/MicroStrategyLibrary/auth/DIOAuthRedirect.jsp

    • Workstation redirect URI: http://127.0.0.1

  10. Click Save.

Create a Google Analytics Data Source

Prerequisites

You must have the Configure security settings and Create and edit database instances and connections privileges.

Create a New Authentication Service in Workstation

For more information on creating identity and access management (IAM) objects, see Manage OAuth Enterprise Security with Identity and Access Management (IAM) Objects.

  1. Open the Workstation window.

  2. In the Navigation pane, click , next to Enterprise Security.

  3. Choose Gateway Authorization and click Next.

  4. Type a Display Name.

  5. Expand the Select an identity provider drop-down list, choose Google.

  6. In Strategy Configuration, enter the Client ID and Client Secret you copied in Create an OAuth Application in Google.

  7. Click Save.

Connect to Google Drive in Mosaic Studio

  1. Create a Mosaic model or right-click an existing Mosaic model and choose Edit.
  2. In the Sources tab, click Add API Source.

  3. Click Google Analytics.

  4. Type a Name for the data source.

  5. Expand the Authentication Service drop-down list and choose the authentication service you created in Create a New Authentication Service in Workstation.

  6. Optionally click Test.

  7. If the connection is successful, click Save.

Import Data

  1. Click your Google Analytics source and enter your Google Login.

  2. Click Account.

  3. Expand the Version, Account, and Property drop-down lists and specify your Google Analytics account details.

  4. Click OK.

  5. Choose one of the following option to import Google Analytics data:

    1. Import data with a predefined report:

      1. In the left pane, view the Google Analytics reports.

      2. Hover over a report name and click Add.

    2. Import data by editing a predefined report:

      1. In the left pane, view the Google Analytics reports.

      2. Hover over a report name and click Edit.

      3. Choose a Date Range and click Add Table from Query.

    3. Import data with a custom query:

      1. In the top navigation, click Add Custom Query.

      2. Click Query Explorer and generate a custom query in the dialog.

  6. Click Proceed.

  7. View and choose suggestions, view object logical relationships, or automatically create attributes and metrics.

  8. Click Save, Save as, or Publish.

  9. If you Saveor Save as your Mosaic model:

    1. Type a Name and Description.

    2. Choose a Save in folder location.

    3. Optionally, select the check box next to Certify Mosaic Model.