#15 When is GA not the answer?
This week Dan and Dara discuss various situations when GA is not the answer. Whether it's navigating gaps in data collection, or forcing types of data analysis that don't quite work.
Daniel Perry-Reed-
Insights
BigQuery and Dataform
187 posts on BigQuery and Dataform
Browse the archive
Explore a topic across our insights
187 results · Page 10 of 11
#11 Is this the end of real data in analytics?
This week Dan and Dara discuss how the access to 'real' data in Google Analytics is becoming more limited due to technology and legislation changes.
Daniel Perry-Reed-
Measured Opinions #10: Better metrics for web measurement
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.
Daniel Perry-Reed-
Measured Opinions #9: Is attribution modelling important?
This week Dan and Dara chat attribution modelling and how/where/if/when it's useful and important to invest in.
Daniel Perry-Reed-
PIVOT: a five-step process for your GA4 migration
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.
George Mendham-
Measured Opinions #7: The GA4 PIVOT framework
This week Dan and Dara discuss the PIVOT framework they've been working on to help people 'pivot' to GA4. Clever, very clever...
Daniel Perry-Reed-
Measured Opinions #6: Do you really need GA360?
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).
Daniel Perry-Reed-
Getting started with Google BigQuery
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.
Lace Rogers-
How to flatten tables with user-defined functions in BigQuery
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.
Lace Rogers-
Measured Opinions #3: What to know before you start with GA4
This week Dan and Dara discuss the four things analytics practitioners should consider before rolling out Google Analytics 4 (GA4).
Daniel Perry-Reed-
How to share access to a single BigQuery dataset with GCP IAM
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.
Liam Grant-
Measured Opinions #2: Is the Session dead?
This week Dan and Dara debate the usefulness of the Google Analytics (GA/GA4) Session, and try to see if there is an alternative.
Daniel Perry-Reed-
Measured Opinions #1: Why should I care about GA4?
This week Dan and Dara chat about the three key reasons they think we should care about GA4 right now.
Daniel Perry-Reed-
Why migrate to GA4? Your data may not be as good as you think
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.
Steven Elliott-
Data warehouse: Repair broken tables in BigQuery
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
Lace Rogers-
How data moves between Google Analytics 4, BigQuery and Data Studio
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.
Daniel Perry-Reed-
Data warehousing: What is BigQuery and how do I get started?
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
Lace Rogers-
Google Analytics data import: automate data import with Python & Cloud functions
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
Victor Sarker-