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

Data Runs Deep Blog

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
data set configuration error

Up Your Data Studio Game: Why Isn't My Dashboard Working?!

By: Yinyee Wong
Posted in
  • Google Data Studio
  • Data Studio
Article Date
October 30, 2020
Here’s what you usually need: Access to the platforms that is connected to Data Studio. Edit access to the dashboard and data sources. A cool head. Plenty of patience. Lots of breaks (don’t be too hard on yourself here).
Read more about Up Your Data Studio Game: Why Isn't My Dashboard Working?!

Hello Google Analytics 4 Properties!

By: Damion Brown
Posted in
  • Google Analytics
Article Date
October 15, 2020

Today is an exciting day, as the new version of Google Analytics is finally here!

Read more about Hello Google Analytics 4 Properties!
re-aggregating metrics is not supported, data studio

Re-aggregating Auto Aggregate in Google Data Studio

By: Yinyee Wong
Posted in
  • Data Studio
  • Google Data Studio
Article Date
September 30, 2020
There’s little we can do about default aggregation when using Google Analytics data. It’s the three things certain in life, right? Death, taxes, and auto aggregation in Google Analytics data.
Read more about Re-aggregating Auto Aggregate in Google Data Studio
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
emojis in data studio, emojis, data studio

Up Your Data Studio Game: Emojis 🤪🌟

By: Yinyee Wong
Posted in
  • Google Data Studio
  • Data Studio
Article Date
August 31, 2020
We know that colours are a powerful communication tool. Our eyes are drawn to patterns and colours which makes data easier to analyse. With that said, Emojis add another layer of visual communication that sometimes words cannot portray. 
Read more about Up Your Data Studio Game: Emojis 🤪🌟
App plus web knowledge base

App + Web FAQs

By: Nick Hood
Posted in
  • App + Web
Article Date
August 17, 2020

App + Web is here, and we certainly see it as the future of digital analytics.

Read more about App + Web FAQs
Example page feedback widget

Adding a Page Feedback Widget using Google Tag Manager

By: Raj Bhullar
Posted in
  • Google Tag Manager
  • JavaScript
  • Google Analytics
Article Date
July 31, 2020

I’ve been using Google Tag Manager (GTM) for over a year now and its potential never ceases to amaze me. If you haven’t already, I would suggest first reading Max’s blog post from February, “

Read more about Adding a Page Feedback Widget using Google Tag Manager
optional metrics

Up Your Data Studio Game: Optional Metrics

By: Yinyee Wong
Posted in
  • Data Studio
  • Google Data Studio
Article Date
July 30, 2020
It’s amusing how we choose to make metrics optional. That’s not what we want to do, is it? We want everything! All of it!
Read more about Up Your Data Studio Game: Optional Metrics

Pagination

  • Current page 1
  • Page 2
  • Page 3
  • Page 4
  • Page 5
  • Page 6
  • Page 7
  • Page 8
  • Page 9
  • …
  • 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