Scott Dudley

This author has written 32 articles

The Data Whisperer You Need to Meet

Have you ever felt like you're trying to run through treacle with your current data systems? Enter BigQuery, Google's powerhouse data warehouse that makes handling massive datasets feel like a breeze. It's not just another tool; it's the Formula 1 engine in the world of data analysis, designed to put you miles ahead of the competition. BigQuery is part of the Google Cloud suite, known for its serverless, scalable, and cost-effective features that allow for super-fast SQL queries on large scales. Think of it as an upgrade from a dripping tap to a fire hose - quick and powerful. It…

Read more...

The Game-Winning Strategy For Attribution

Understanding marketing attribution isn't just about keeping score; it's about knowing who actually scored the goal and how. For any marketing team, knowing which part of your strategy is converting viewers into customers is crucial. It's like having a star forward in a football match — you want to know who's putting the ball into the net, because that's what ultimately counts. In the marketing world, this is where the 'Last Click' model shines. It credits the last interaction before a conversion, much like crediting the forward who scores the goal. It’s straightforward and eliminates the guesswork about where the…

Read more...

How to Create Awesome Scorecards with Sparkline Graphs in Looker Studio

Discover how to effectively create scorecards with dynamic sparkline graphs in Looker Studio. Scorecards provide a quick overview of key metrics, while sparkline graphs add a valuable historical context to your data. In this tutorial, I'll guide you through the process of creating engaging scorecards with embedded sparkline graphs, enhancing your data visualisation capabilities. Header Outline: I. Introduction II. Understanding Scorecards with Sparkline Graphs III. Preparing Your Data Source A. Accessing Data in Looker Studio B. Structuring Time-Series Data IV. Building a Scorecard in Looker Studio A. Adding Scorecard Components B. Configuring Metrics and Values V. Adding Sparkline Graphs To…

Read more...

How to Create a Geo Map to Visualise Metric Locations in Looker Studio

Discover how to effectively visualise metric locations using geo maps in Looker Studio. Geo maps provide a dynamic and insightful way to understand spatial data and its impact. In this tutorial, we'll guide you through the process of creating engaging geo-maps that bring your metrics to life on the map. Learn step-by-step how to integrate your data, customise map layers, and unlock geographic insights that drive better decision-making. Header Outline: I. Introduction II. Leveraging Geo Maps in Data Visualization III. Building a Geo Map in Google Data Studio A. Adding a Geo Map Component B. Configuring the Geographic Dimension C.…

Read more...

How to Create a Time Series Chart to View Trends in Looker Studio

Are you ready to uncover hidden insights within your data's historical patterns? Creating a time series chart in Looker Studio allows you to unveil trends and fluctuations that are crucial for data-driven decision-making. In this tutorial, I'll introduce you to the world of time series charts and guide you through the steps to create one, helping you harness the power of temporal data visualisation. Header Outline: I. Introduction II. Understanding Time Series Charts III. Setting Up Your Data Source A. Accessing Data and Dimensions B. Preparing Time-Related Data IV. Creating a Time Series Chart A. Adding a Time Dimension B.…

Read more...

How to Set Up Filter Controls in Looker Studio

Do you want to take your data reporting to the next level? Setting up filter controls in Looker Studio is the key to creating highly interactive and user-friendly data reports. In this tutorial, we'll introduce you to the benefits of filter controls and guide you through the process of adding them to your Looker Studio reports, providing your audience with the power to explore data based on their unique preferences and requirements. Header Outline: I. Introduction II. Understanding Filter Controls in Google Data Studio III. Adding Filter Controls to Your Report A. Accessing Your Data Source and Report B. Navigating…

Read more...

How to Create a Field for Percentage of Total in Looker Studio

Are you ready to level up your data visualisation game? Creating a Percentage of Total field in Looker Studio is a valuable technique to highlight the relative contribution of data subsets and gain deeper insights into your data. In this tutorial, we'll show you how to effortlessly add a Percentage of Total field to your Data Studio reports, transforming your raw data into actionable visualisations. Header Outline: I. Introduction II. Understanding Percentage of Total III. Creating a Field for Percentage of Total A. Accessing Data Source and Report B. Adding a Metric C. Adding the "Percent Of Total" to the…

Read more...

How to Connect Google Analytics (GA4) to BigQuery

Do you want to take your data analytics to the next level? Connecting Google Analytics 4 (GA4) to BigQuery is a game-changer that opens up new possibilities for data analysis and reporting. In this tutorial, I'll show you how to establish a seamless connection between GA4 and BigQuery, helping you harness the full potential of your data and drive business growth through data-driven strategies. Header Outline: I. Introduction II. Prerequisites for Integration III. Creating a BigQuery Project IV. Setting Up Data Export in Google Analytics 4 V. Confirming Data Transfer in BigQuery VI. Utilizing GA4 Data in BigQuery A. Querying…

Read more...

How to Change the Data Retention Setting in Google Analytics 4 (GA4)

Data retention is a critical aspect of data management, especially in today's data privacy landscape. By adjusting the data retention setting in Google Analytics 4 (GA4), you can align data storage with your specific business requirements and comply with relevant data privacy regulations. In this tutorial, I'll show you how to change the data retention setting in GA4, giving you the flexibility to manage your data in a way that suits your needs. Header Outline: I. Introduction II. Understanding Data Retention in Google Analytics 4 III. Changing the Data Retention Setting A. Accessing the GA4 Property Settings B. Navigating to…

Read more...

How to Set Up Content Groups in Google Analytics 4 (GA4) using GTM

Do you want to better understand how users engage with specific sections of your website? Setting up content groups in Google Analytics 4 (GA4) using Google Tag Manager (GTM) allows you to categorise your website content into meaningful groups, providing valuable insights into user behaviour and content performance. In this tutorial, I'll walk you through the steps to set up content groups in GA4 using GTM, empowering you to enhance your data analysis and inform your marketing decisions. Header Outline: I. Introduction II. Understanding Content Groups in GA4 III. Setting Up Content Groups in GTM A. Step 1: Create a…

Read more...
Back To Top