Post

Immerse yourself in the fascinating content of our blog and discover new inspirations!

Configuration of the Google Analytics Connector in MicroStrategy

Click here to move to Polish version.

This article discusses the process of retrieving data from Google Analytics using OAuth2.0 authentication in MicroStrategy. Configuring the OAuth2.0 token is a key step that enables access to data from the Google Analytics platform.

Configuration manual ENG download.

To properly configure access to data in Google Analytics, the following information will be required:

  • Client ID 
  • Client Secret

The process of obtaining them and configuring them is as follows:

1. Go to the website https://console.cloud.google.com/

2 .Create an account using a Gmail address associated with the Google Analytics project.

3. Create a project in the Google Cloud Console.

4. Go to the website https://console.cloud.google.com/apis/dashboard

5. In the menu on the left, select the "Library" tab.

6. Locate and enable the Google Analytics Data API and Google Analytics Admin API.

 

7. Go to the "Credentials" tab in the menu on the left.

8.Select "Create credentials" -> "OAuth client ID".

9.Choose the application type: "Web application".

10.After creation of credentials make sure to copy Client ID and Client Secret

11. http://127.0.0.1/oauth2redirect/google-analytics

12. https://WebServer:PortNumber/WebApplicationName/servlet/mstrWeb?evt=3172
(you need to replace this link with your actual server address and application name)

13. Click "Create".

14. Next, create a Service Account by selecting "Create credentials" -> "Service account".

15. Add the generated service account email (in the format @amplified-ward-number-iam.gserviceaccount.com) in the service settings on the Google Analytics platform:
Go to https://analytics.google.com/analytics/web/ -> "Admin" -> "Property" -> "Property Access Management".

16. Configure the OAuth consent screen in Google Cloud by filling out the form according to your project-specific information.

17. Return to the "Credentials" tab and select the previously created OAuth 2.0 Client.

18. After clicking on the previously created OAuth 2.0 client, information such as the Client ID and Client Secret will appear on the right side. These will be needed to configure the connection to Google Analytics in MicroStrategy Workstation.

MicroStrategy configuration

The final step of the configuration is to edit the data source in MicroStrategy Workstation.

Navigate to the Data Sources tab, then find Google Analytics among the available data sources and select the edit option.

In MicroStrategy Configuration, enter the Client ID and Client Secret one after the other.

With the Connector configured this way, we can finally go to MicroStrategy Web -> Add External Data -> Google Analytics. Then, a window should pop up prompting you to sign in through Google.

After logging in, the Google Analytics Connector works correctly.

Related Tags

Leave a comment