Docs

Google Analytics 4 Raw Events Extractor

What is Google Analytics 4 Extractor?

Google Analytics 4 is an analytics service to measure traffic and engagement across your websites and apps. It collects event-based data from both websites and apps.

Google Analytics 4 Direct data extractor by Electrik.AI is designed to export Google Analytics 4 raw events data and load it directly into your database/data warehouse. You do not need to have a BigQuery account to export your GA4 Raw Events data. And you no longer need to bother about unnesting the raw events data or about merging the multiple events_YYYYMMDD tables.

With Electrik.AI’s Google Analytics 4, you can get daily report in the data warehouse or database of your choice. Electrik.AI makes it easy to get the data you want so that you can focus on analysis and reporting.

How to set up Analytics for a website and/or app

How to add a Google Analytics 4 Direct Connection in Electrik.AI?

Follow these steps to connect your Google Analytics 4 Direct connection to Electrik.AI

Step 1:  Ensure you have following prerequisites to create a Google Analytics 4 Direct Connection in Electrik.AI

  1. Access to Google Analytics 4 account
  2. Google Analytics 4 Account User Id and Password.
  3. Google Analytics 4 Raw Events details.

Step 2: Sign-in into your Electrik.AI account

Step 3: Select IO in Electrik.AI dashboard

Select IO in ElectrikAI Dashboard - ElectrikAI

Step 4: Select the Connections tab in the left most panel and click on “Add” button.

Select the Connections tab in the left most panel Conn - ElectrikAI

Step 5: The Source default tab is selected just click on “Google Analytics 4 Direct” connection.

The Source default tab is selected just click on Google Analytics 4 Direct connection - ElectrikAI

Step 6: Enter your Google Analytics 4 User Id and Password.

Conn-Step 6 Enter your Google Search Console User Id and Password - ElectrikAI

Step 7: Allow Electrik.AI to view Google Account Data for your GA4 Raw Events.

Conn Step 7 Allow Electrik.AI to view Google Account Data for your GA4 property - ElectrikAI

Step 8: Choose your analytics account and raw events for which you want to Extract data.

Conn Step 8 Choose your analytics account and property for which you want to Extract data - ElectrikAI

Step 9: Click on Save button on the top right corner of the screen.

Conn Step 9 Click on Save button on the top right corner of the screen - ElectrikAI

Congratulations, you have successfully created a “Google Analytics 4 Direct” Connection in Electrik.AI

Congratulations, you have successfully created a “Google Analytics 4 Direct” Connection - ElectrikAI

What are the supported Data Destinations?

Electrik.AI supports the following databases and Data Warehouse to export Google Analytics 4 Data. It is important to note that Electrik.AI itself is not a destination. A destination is required to export data from various marketing data sources using Electrik.AI

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI

How to export Google Analytics 4 Data?

Electrik.AI creates a data flow (or ETL process) that exports Google Analytics 4 data to a target database or data warehouse or data base. This process runs daily at scheduled time and exports data for the previous day.

Follow these steps to create a Data Flow from Google Analytics 4 Direct to Google BigQuery

Step 1: Ensure you have the following prerequisites.

  1. Access to Google Analytics 4 account
  2. Google Analytics Account 4 User Id and Password.
  3. Google Analytics 4 Raw Events details.
  4. Access to a Database of your choice (PostgreSQL, MySQL, Azure SQL)
  5. Database Connection Details such as Host, Port, DB Name, DB User.

Step 2: Sign-in into your Electrik.AI account.
Step 3: Select IO in Electrik.AI dashboard

Select IO in ElectrikAI Dashboard - ElectrikAI

Step 4: Select the Connections Icon in the left most panel and Click on Add button to create a Google Analytics 4 Direct Data Extractor Flow.

Select the Connections Icon in the left most panel Flow - ElectrikAI

Step 5: Select Google Analytics 4 Direct Connection present in the list of available sources.

Select Google Analytics 4 BigQuery (Service Account) Connection present in the list of available sources - ElectrikAI

Step 6: Select your existing Google Analytics 4 Direct connection in Electrik.AI.

Flow-Step 6 Select your existing Google Analytics 4 Direct connection - ElectrikAI

To configure a new connection, refer to this link.

Step 7: Click on a destination of your choice from list of available destinations.

In this example we are choosing BigQuery.

Flow Click on a destination of your choice from list of available destinations - ElectrikAI

Step 8: Click on a destination of your choice from list of available destinations.

Flow-Step 8 Click on a destination of your choice from list of available destinations - ElectrikAI

 Step 9: Review the Data Source, Data Destination, Database Schema, Provide Success Notification Email, Failure Notification Email. Click “Save and Proceed” to continue.

Flow Step9 Review the Data Source Data Destination Database Schema - ElectrikAI

Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.
Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.
Note: By Default, Electrik.AI uses the signed-in user’s Email Id.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

Congratulations, GA4 Direct Flow is created - ElectrikAI

You have now successfully setup Google Analytics 4 Direct to BigQuery flow in Electrik.AI

You have now successfully setup Google Analytics 4 Direct to BigQuery - ElectrikAI

Your Google Analytics 4 data will start loading after 24 hours in your Google BigQuery Dataset.

Your Google Analytics data will start loading after 24 hours in your Google BigQuery Dataset - ElectrikAI