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
Step 1: Ensure you have following prerequisites to create a Google Analytics 4 Direct Connection in Electrik.AI
- Access to Google Analytics 4 account
- Google Analytics 4 Account User Id and Password.
- Google Analytics 4 Raw Events details.
Step 2: Sign-in into your Electrik.AI account
Step 3: Select IO in Electrik.AI dashboard
Step 4: Select the Connections tab in the left most panel and click on “Add” button.
Step 5: The Source default tab is selected just click on “Google Analytics 4 Direct” connection.
Step 6: Enter your Google Analytics 4 User Id and Password.
Step 7: Allow Electrik.AI to view Google Account Data for your GA4 Raw Events.
Step 8: Choose your analytics account and raw events for which you want to Extract data.
Step 9: Click on Save button on the top right corner of the screen.
Congratulations, you have successfully created a “Google Analytics 4 Direct” Connection in Electrik.AI
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
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.
Step 1: Ensure you have the following prerequisites.
- Access to Google Analytics 4 account
- Google Analytics Account 4 User Id and Password.
- Google Analytics 4 Raw Events details.
- Access to a Database of your choice (PostgreSQL, MySQL, Azure SQL)
- 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
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.
Step 5: Select Google Analytics 4 Direct Connection present in the list of available sources.
Step 6: Select your existing Google Analytics 4 Direct connection in Electrik.AI.
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.
Step 8: Click on a destination of your choice from list of available destinations.
Step 9: Review the Data Source, Data Destination, Database Schema, Provide Success Notification Email, Failure Notification Email. Click “Save and Proceed” to continue.
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.
You have now successfully setup Google Analytics 4 Direct to BigQuery flow in Electrik.AI
Your Google Analytics 4 data will start loading after 24 hours in your Google BigQuery Dataset.