Google Analytics 4

Google Analytics 4 (GA4) is an advanced analytics property introduced by Google which collects event-based data from both websites and apps.

The Universal Analytics will no longer be supported by Google from July 1, 2023, and GA4 is soon going to be the default analytics tool by Google.

It has many features that would help you better understand your customers and their journey. GA4 uses event-based data instead of session-based, and includes various privacy controls including cookieless measurement. It also offers predictive capabilities without complex models and ofcourse, direct integrations to media platforms among others.

Connecting to GA4 Account

Mammoth allows you to connect to Google account and get the data into Mammoth.

  1. Select API & Databases from the ‘Add Data’ menu and click on Google Analytics 4.

  2. Click on New Connection and log in into your Google account.

    Google Analytics login

    Fig. 32 Sign into your Google account

  3. Next, select the desired account.

    Google Analytics profile

    Fig. 33 Choose the account

  4. Once your Google account is connected with Mammoth, you will be presented with a list of tables and views in that database.

    • Select the desired table to get a preview.

    • Write your own SQL query or run a test query and preview the result.

    • Click on Next .

After you have selected the table you want to work on, you get options to schedule the data imports as discussed below.

Scheduling your Data Pulls

You can start retrieving the data now or at a specific time according to your choice. You can also schedule the data pull in order to get the latest data from your Database at a certain time interval - just once, daily, weekly or monthly.

On every data pull from your Database, you also have options to - Replace all data, Add new data since last pull, and Replace with new data since last pull.

On choosing Add new data since last pull or Replace with new data since last pull option, you will get an option to choose a unique sequence column. Using this column, on refresh, Mammoth will pick up all the rows that have greater value in this column than the previous data pull.