Optimics - Blog

Blog

BigQuery User Export: Insights and Personalisation

Traditionally, obtaining user data for analysis was a complex and time-consuming task. However, Google has simplified this process with the introduction of User Data Export in BigQuery. This feature allows organizations to access valuable data, including audience insights, predictive metrics, and user activity timestamps.

July 4, 2023

3 reasons to use BigQuery as the heart of your data analytics

Analytics, Cloud, Data Architecture

BigQuery is a potent tool that can be used for many reasons. In this article, we will describe the main benefits of considering BigQuery as the heart of your data analytics platform.

June 12, 2023

Universal Analytics, Google Analytics 4, or BigQuery data?

Analytics, Cloud, Data Architecture

Although GA4 and UA are both web analytics tools used primarily for tracking website and app activity, BigQuery is mainly used for storing and analyzing large amounts of data.

May 9, 2023

Google Cloud Platform is not only about BigQuery

Analytics, Cloud

One of the benefits of Google Analytics 4 is that free accounts also can export data to BigQuery. Before you can export data to BigQuery you have to create a Google Cloud Platform (GCP) which is a set of cloud computing services. In this article, we will go through the process of creating a GCP project.

March 29, 2023

The Power of a Cloud Architect: From Code Chaos to System Streamlining

Analytics, Cloud

It started out as a small project. A few lines of code here, a simple database there. Nothing too complicated, nothing that couldn’t be handled by a couple of enthusiastic developers with some spare time on their hands. But as the weeks went by, the project grew. New features were added, the user base expanded, and the data started pouring in. Before long, the once-simple codebase had become a tangled mess of spaghetti code and poorly designed systems. It was slow, inefficient, and prone to crashes. The developers were overwhelmed, and the project was in danger of collapsing under its own weight. That’s when the Cloud Architect stepped in. With a deep understanding of software architecture, a strong grasp of the latest technologies, and a laser focus on scalability and efficiency, the Architect quickly identified the problems with the existing system and set to work designing a solution that would meet the needs of the project.

February 27, 2023

Why connect Google Analytics 4 with BigQuery

Analytics, Cloud, Data Architecture

Much has been written about the pros and cons of Google Analytics 4. However, in this article, we’ll take a look at one of the key features that only 360 accounts can enjoy in Google Analytics Universal. That feature is the export to BigQuery.