Insights
Google BigQuery data warehouse, SQL queries, and analytics data processing (185 posts)
Explore a topic across our insights
185 results · Page 10 of 11
This week Dan and Dara dig deep into the ABCs of Google Analytics metrics. Defining what they actually mean and their relevance and/or place in the modern technological age.
This week Dan and Dara chat attribution modelling and how/where/if/when it's useful and important to invest in.
If you’re migrating from Universal Analytics to Google Analytics 4, our PIVOT framework provides guidance on what you’ll need to consider at each stage of the process. See our GA4 migration guide.
This week Dan and Dara discuss the PIVOT framework they've been working on to help people 'pivot' to GA4. Clever, very clever...
This week Dan and Dara discuss the questions you can ask yourself to see if you need to consider upgrading to Google Analytics 360 (GA360).
BigQuery is literally the next “Big” thing (with a capital B) in analytics. We explain what it is, how some of our clients are already using it, how much it costs and where you can start.
Flattening tables in Google BigQuery can be painful when doing multiple fields with UNNEST. User-defined functions (UDFs) make life easier and this one will do it for you automatically.
This week Dan and Dara discuss the four things analytics practitioners should consider before rolling out Google Analytics 4 (GA4).
Sometimes less is more; especially when it comes to security access. This simple walkthrough will show you how to use GCP IAM to surface just the parts of your data warehouse to just the right people.
This week Dan and Dara debate the usefulness of the Google Analytics (GA/GA4) Session, and try to see if there is an alternative.
This week Dan and Dara chat about the three key reasons they think we should care about GA4 right now.
Be warned: the risk of sticking with your current Google Analytics implementation may well be greater than any costs associated with the "migration" to GA4.
At Measurelab, we love a bit of data warehousing using BigQuery; in fact, we are obsessed with finding the best approach to managing data warehouses in the most optimal way possible. So in this series, we want to share with you our knowledge and expertise to show what a fantastic and dynamic tool BigQuery is. As you may know, BigQuery has some super powerful features, which allow us to build, manipulate and even run machine learning algorithms within the interface. However, we’re all human, an
There's a surprising number of data feeds and transfers for Google Analytics 4, BigQuery, Data Studio and all its connected accounts and platforms. We set out to map them all to assist with your architecting.
At Measurelab we live and breathe the Google Cloud Platform, so our specialists are experts in Bigquery. We have decided in this series to share our knowledge and take you through some great techniques to maintain your BigQuery data warehouse. So firstly-what is BigQuery? BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. ...and that means? Simply put, BigQuery is a fantastic cloud-based data warehouse in which you can store huge
Why automate data import into Google Analytics A few months back I was granted access to a Google Cloud Source Repository (private Git repositories hosted on Google Cloud part of Google’s Cloud developer tools) that contained Python code and configuration details for automating the extraction of data from a BigQuery table and uploading to Google Analytics as a custom dimension via the Management API on a desired schedule. Choosing the right approach for blog word counts Being primarily a Jav
The new future version of Google Analytics has been announced - now branded as Google Analytics 4. Building on the "App + Web" property that was released last year, this sets the direction for Google Analytics going forwards. It is now the default experiences for all new properties and is where all product developments will be focussed. Google Analytics 3, commonly known as Universal Analytics, was released in October 2012. This next product iteration for Google Analytics is a major step on fro
See what we did there? Okay, so maybe a tad too much on the title. It is catchy, so hey. Firstly - we are pretty chuffed to welcome Lace to our team. She joins us to spearhead our offering in all things DATA science and data engineering, which (to be completely frank) is where all roads point in this analytics game. With the advent of App plus Web (from Google Analytics), and particularly the opportunity to access raw data through BigQuery, this is an exciting place to be right now. Secondly -