Import Data from Google Analytics 4

Starting in MicroStrategy ONE Update 11, you can use Google Analytics 4 as part of the new data import experience.

Recognizing Google's decision to stop new data processing in Universal Analytics (UA) starting July 1, 2023 and its transition to Google Analytics 4 (GA4) as the primary measurement solution—with a full deprecation of UA planned for 2024—MicroStrategy has proactively upgraded its integration capabilities. With our enhanced GA4 connector, introduced in version MicroStrategy ONE Update 11 (September 2023), we are ensuring that MicroStrategy users not only maintain continuous access to their vital data sources but also benefit from the advanced features that GA4 offers. Its event-based data model, emphasis on user privacy, and flexible reporting capabilities make it distinct from its predecessor, UA.

For a comprehensive overview of GA4 and its benefits, see Introducing the next generation of Analytics, Google Analytics 4.

The following sections walk you through the steps of seamlessly integrating Google Analytics 4 with MicroStrategy to easily import your data and elevate your reporting and visualization efforts.

• Preconditions

• Set OAuth Configuration with IAM Objects for Google Analytics

• Sign Into Your Google Analytics Account

• Import Data from Google Analytics 4

• Related Topics

Preconditions

Before importing data, certain preconditions, primarily around API configurations, need to be met. This ensures seamless data flow from GA4 to MicroStrategy.

1. Log into the Google Analytics developer zone.

2. Select your project, navigate to Enabled APIs & services, and click ENABLE APIS AND SERVICES. Search for the Google Analytics Data API and Google Analytics Admin API and enable them.

   

3. Make sure the required APIs are enabled for your project.

Set OAuth Configuration with IAM Objects for Google Analytics

Setting up the OAuth configuration ensures that your data is accessed securely and that the integration respects the permissions set in your Google Analytics account.

1. In the Navigation pane, click Data Sources, and find the Google Analytics data source.

2. Right-click the Google Analytics data source to edit it and click Add New Authentication Service.

   

3. Create a new Authentication Service for Google Analytics. Under MicroStrategy Configuration, enter the Client ID and Client Secret and click Save.

   

   See KB483527: How to Configure Google API Data Import Connectors in MicroStrategy Desktop or Workstation for more information about how to configure the Google App.

4. Click Save.

Sign Into Your Google Analytics Account

1. In the Workstation Navigation pane, click next to Datasets.

2. Select your Environment, Project, Data Import Cube, and click OK.

   

3. Find the Google Analytics data source, select it, and enter your Google credentials in the pop-up.

   There is no requirement to configure a separate database instance for Google Analytics. MicroStrategy provides an out-of-the-box (OOTB) database instance. Therefore, you can directly access this section, and choosing Google Analytics leads you straight to Google's authentication page

4. Allow the MicroStrategy app to access your Google account.

   

5. Go back to Workstation.

Import Data from Google Analytics 4

1. Hover over the Google Analytics data source and click Configuration .

2. Select the Version, Account, Property, and click OK.

   

3. You can import Google Analytics data in one of the following ways:

   Click here to import data with a predefined report.

   1. In the left pane, expand the Google Analytics source and browse the reports.

   2. Double-click reports to add them to the right pane.

      

   Click here to import data by editing a predefined report.

   1. Hover over a report and click Edit .

   2. Select a Date Range and click Add Table from Query.

      

   Click here to import data with a custom query.

   1. Hover over the Google Analytics data source and click Add Custom Query .

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

      

   3. Copy the JSON body to the Query Editor pane and select a Date Range, if necessary.

   4. Click Add Table from Query.

4. Click Prepare Data.

5. In the Preview pane, you can view the sample data and adjust the column type.

6. Publish the cube to MicroStrategy with your selected data.

Related Topics

Import Data from Google Analytics

Manage OAuth Enterprise Security with Identity and Access Management (IAM) Objects

KB486151: Enable Google Analytics 4 support in older releases of MicroStrategy 2021 and MicroStrategy ONE, prior to MicroStrategy ONE Update 11