Blog

How to Avoid Google Analytics 4 [GA4] BigQuery Export Quota Limit of 1 Million Hits

While the new version of Google Analytics, the GA4, comes with the native BigQuery export feature available in the free version and some of the other quotas aren’t as tight anymore, GA4 still has a fair share of limitations we need to account for.

The limit I’m covering in this post is set on the BigQuery export. More specifically, the GA4 to BigQuery native export feature has a limit of 1 million hits per day. Luckily, there are some ways around it.

Read more »

How Jooble Leverages Digital Analytics Data to Run Their Business and Improve the Job Seekers’ Experience

Through years of working with data, we at Jooble have come to understand the importance of digital analytics. We believe that today it is a must for any online business. In our particular case, it helps address the three main issues: satisfy job seekers’ needs and requests; gain more accurate insights on employers’ struggles; and, last but not least, understand our own benefits and weaknesses and act on them accordingly.

Read more »

Case Study: Building and maintaining a Data Pipeline and Data Warehouse for the Enterprise

At Reflective Data, we’ve worked with companies big and small. This means we have seen all levels of maturity when it comes to the infrastructure and knowledge around data pipelines and data warehouses.

Some of the most challenging projects have been enterprises with quite some infrastructure, legacy pipelines, and of course, opinions. Smaller businesses are just starting to adopt the concept of having all of their data stored in a data warehouse but many enterprises have been doing this for a decade!

Read more »

Measure Long-Term Metrics Like Customer Lifetime Value (LTV) Using Google Analytics

Long-term metrics like customer lifetime value (LTV) and churn can be so much more insightful and lead to better results when optimized for when compared to the more basic metrics like transactions or revenue. Yet, these metrics are often ignored or at least not involved in the analysis and optimization processes enough. One of the reasons is that it’s quite difficult to track them using common analytics and testing tools like Google Analytics and Optimize.

In this article, we are going to explore some of the ways we can leverage Google Analytics to track churn, LTV and other really useful metrics.

Read more »

Case Study: Storing Google Analytics Data Within The European Union or Locally

Data protection and privacy rules are getting tougher all over the world. This is especially true for the European Union and even more so for some specific industries. Including finance, medical and others that handle sensitive information about their users.

While Google Analytics has been making some improvements in the privacy area and is GDPR compliant, this is not enough for many businesses and industries.

At Reflective Data, we’re often working with companies that are under close monitoring of their regulators. To help them out, we’ve built custom solutions that allow storing Google Analytics within the European Union or sometimes even completely locally.

Read more »

Case Study: Solving The Discrepancy Between A/B Testing Tool, Google Analytics and Backend Data For a Large E-Commerce Business

Working with skewed data can be worse than having no data at all. This is why we’re always promoting all sorts of analytics audits and making sure all data sources agree with each other. At the very least, you should know why the numbers in different tools don’t match (i.e. analytics doesn’t include offline sales but backend does).

Our client in this case study contacted us with a quite specific problem. They were running a decent CRO program with 4-6 A/B experiments running every month. The problem they had with the program, though, was that the numbers they saw in their testing tool Optimizely, Google Analytics and backend didn’t match. In fact, there was a ~35% discrepancy overall.

Read more »

A Series of Digital Analytics Related Case Studies Coming Soon

Over the years, we have helped companies of all sizes and from various industries to collect, process and make use of digital data.

Something we should have started doing a long back is sharing the success stories of our clients. We’ve done so many cool things together and for our clients that these stories are definitely worth sharing, and reading.

Read more »

[Medium] Hit-Level Unsampled Google Analytics to BigQuery Without 360

Google Analytics and BigQuery, two tools that both the major players in their respective segments. Yet, there is no way to easily send raw hit-level data from one to another.

In this article, originally posted on medium.com, we’re going to walk through the reasons you might want to access raw Google Analytics data in BigQuery and a few solutions that will get you there.

Read more »