Skip to main content
Data Runs Deep Menu

Main navigation

  • Home
  • Who We Are
    • Careers
    • What We're Up To
    • What We Believe In
    • Ethical Policy
  • What We Do
  • Google Marketing Platform
    • Analytics 360
    • Tag Manager 360
    • Salesforce and GA360
    • Google Analytics App+Web
    • Data Studio
    • Optimize
  • Google Cloud Platform
    • Google BigQuery
      • Google BigQuery Training
      • Google Analytics Integration
  • Consulting
    • Strategy
    • Implementation
      • Google Analytics Audit
      • Google Tag Manager Audit
      • Enhanced Ecommerce Implementation
      • Google Tag Manager
    • Analysis
      • Google Data Studio
        • Google Data Studio Case Study - Mona
      • UX Analysis
  • Training
    • Five Day Google Analytics Online Workshop
    • Advanced Google Analytics Training
    • Google Tag Manager Training
    • Google Analytics 360 Training
    • Advanced Analytics Bootcamp
  • Partnerships
    • Conductrics
  • Blog
  • The Flying Beagle
  • Merch
  • Contact

Google BigQuery

Use LAST_VALUE to dynamically offset data in BigQuery

How to re-attribute your conversions to the correct traffic source in BigQuery

By: Corinne Brooker
Posted in
  • Google BigQuery
Article Date
December 04, 2020

We previously did a blog post about identifying session breakage using BigQuery.

Read more about How to re-attribute your conversions to the correct traffic source in BigQuery
Use ROW_NUMBER SQL window function to identify duplicate values in BigQuery

Remove Duplicate Transactions From Your Reporting in BigQuery

By: Corinne Brooker
Posted in
  • Google BigQuery
Article Date
November 20, 2020

A lot of companies report duplicate transactions (and therefore increased revenue) in Google Analytics.

Read more about Remove Duplicate Transactions From Your Reporting in BigQuery
Calculating sub-totals using BigQuery

Cool things you can do using window functions in BigQuery

By: Corinne Brooker
Posted in
  • Google BigQuery
Article Date
September 11, 2020

Lately, I’ve found myself using a number of window functions in BigQuery. They are really handy functions but can be difficult to wrap your head around.

Read more about Cool things you can do using window functions in BigQuery
LEAD function example

Identify Potential Session Breakage Using BigQuery

By: Corinne Brooker
Posted in
  • Google BigQuery
Article Date
May 18, 2020

Google Analytics generally stops tracking a session after 30mins of inactivity. Any activity after that will start a new session.

Read more about Identify Potential Session Breakage Using BigQuery
BigQuery Statement Builder

Use our BigQuery Statement Builder To Better Understand The Behaviours Of Your Customers

By: Corinne Brooker
Posted in
  • Google BigQuery
Article Date
February 22, 2020

Getting started in BigQuery can be daunting. Even with experience writing SQL, there are some platform-specific nuances you need to learn along the way.

Read more about Use our BigQuery Statement Builder To Better Understand The Behaviours Of Your Customers
BigQuery Voucher Google Analytics 360

You Can Have Your GA360 BigQuery Voucher Back (Sort Of)

By: Damion Brown
Posted in
  • Google BigQuery
Article Date
October 22, 2019

Earlier this year, Google discontinued a very popular little addon that was bundled with GA360.

Read more about You Can Have Your GA360 BigQuery Voucher Back (Sort Of)
Consistently selecting randomised rows in BigQuery

How To Consistently Select a Randomly Distributed Sample of Rows From A BigQuery Table

By: Balkan Misirli
Posted in
  • Google Cloud Platform
  • Google BigQuery
  • Google BigQuery Machine Learning BQML
Article Date
July 04, 2019

There are occasions where you would like to randomly select rows from your BigQuery tables; but at the same time like to ensure you keep getting the same set of rows every time you work with the da

Read more about How To Consistently Select a Randomly Distributed Sample of Rows From A BigQuery Table
Calculating What Percentage Of Rows Are In Each Group

How To Calculate Table Level Percentages In BigQuery

By: Balkan Misirli
Posted in
  • Google Cloud Platform
  • Google BigQuery
Article Date
June 26, 2019

In a lot of exploratory queries, you want to know not only how many rows had a certain value but what percentage of all rows in the table this count value represents.

Read more about How To Calculate Table Level Percentages In BigQuery
Google Cloud Next '19

What We’re Excited For Next After Google Cloud Next ‘19

By: Vinoaj Vijeyakumaar
Posted in
  • Google Cloud Platform
  • Google Cloud Next
  • Google Cloud for Marketing
  • Google BigQuery
Article Date
April 15, 2019

I just spent 3 whirlwind days at Google Cloud Next ‘19, Google Cloud Platform’s (GCP) annual global conference, held in sunny San Francisco.

Read more about What We’re Excited For Next After Google Cloud Next ‘19

Detect If Any Daily Tables Are Missing In Your Google Analytics 360 BigQuery Datasets

By: Balkan Misirli
Posted in
  • Google Cloud Platform
  • Google BigQuery
  • Google Analytics
Article Date
April 04, 2019

The Google Analytics 360 (GA360) integration with Google BigQuery produces one partitioned table for each day’s worth of data.

Read more about Detect If Any Daily Tables Are Missing In Your Google Analytics 360 BigQuery Datasets

Pagination

  • Current page 1
  • Page 2
  • Next page Next ›
  • Last page Last »

Get in touch

To find out more, email us on hello@datarunsdeep.com.au or complete a quick contact form.

Get in touch

Talk to us: 1300 737 885

08:30 - 16:30, Monday to Friday. We love to chat

Visit us, we’re at:

Level 8, 313 Little Collins Street Melbourne, VIC 3000

Footer

  • Home
    • Who We Are
      • What We Do
      • What We're Up To
      • Careers
      • Contact
  • Training
    • Google Analytics Training Courses
    • Advanced Google Analytics Training
    • Google Tag Manager Training
  • Consulting
    • Analysis
    • Implementation
    • Strategy
    • Google Analytics Audit
    • Google Tag Manager Audit
  • Google Cloud Partner
  • Google Marketing Platform Sales Partner
  • Bitcoin accepted here
  • Registered Looker Consulting Partner Melbourne
  • Twitter
  • LinkedIn
  • Google Plus
  • Blog RSS feed
Copyright © 2009-2021 Data Runs Deep Pty Ltd. All Rights Reserved. Google Analytics is a trademark of Google Inc.
Website by Marin Sekesan