Tutorials

Gen AI Classification

Using ChatGPT in Google Sheets for Classification (custom function included)

Leave a Comment / Google Apps Script, Google Spreadsheets, Tutorials /

Classification is the generative AI-based pattern I use most frequently. Why? Three reasons: It’s perfect for tackling big tasks where 80% accuracy on 100% of cases is better than 100% accuracy on just 20%. This week alone, I’ve used classification to: Since Google Sheets is one of my go-to tools for small/quick data problems, I […]

Using ChatGPT in Google Sheets for Classification (custom function included) Read More »

Longtail Query Analysis in BigQuery using Levenshtein Distance

Leave a Comment / BigQuery, SEO, SQL, Tutorials /

A few days ago, Cyrus Shepard posted an example about using Levenshtein distance to compute the similarity or dissimilarity (aka the edit distance) between two strings. His example showed how to apply Levenshtein distance in Google Sheets in the context of written content, but it inspired me to demonstrate another common application: query similarity.  Since

Longtail Query Analysis in BigQuery using Levenshtein Distance Read More »

How to check if your LinkedIn Insight Tag Pixel Is Working

Leave a Comment / Google Tag Manager, Javascript, Linkedin, Tutorials /

You’ve just added your LinkedIn Insight Tag to your website, and you want to see if it’s working. If you read Linkedin’s documentation, they will offer up this advice:  “You can check the status in Campaign Manager by navigating to Account Assets → Insight Tag. Once the Insight Tag is installed on your website and

How to check if your LinkedIn Insight Tag Pixel Is Working Read More »

Google Search Console to BigQuery: The Complete Guide to GSC Bulk Export

7 Comments / BigQuery, Google Search Console, SEO, SQL, Tutorials /

You may have heard the hype about integrating Google Search Console and Google BigQuery using the new Bulk Export feature. If you’re like me, you recognize the power of analyzing SEO data with SQL or the BI tool of your choice (you’ve probably heard of Looker and Looker Studio.) Or you might be thinking to

Google Search Console to BigQuery: The Complete Guide to GSC Bulk Export Read More »

Writing Custom Dimension to Google Analytics from Snowflake DB

1 Comment / Google Analytics, Tutorials /

Like many data geeks, Google Analytics first sparked my curiosity. Last week, Census released our Google Analytics integration. I could write a long list of game-changing applications for creating custom dimensions in Google Analytics from data in a Snowflake data warehouse, but I’ve been swirling around one that I find particularly interesting. Here’s what I’m thinking. Census, as

Writing Custom Dimension to Google Analytics from Snowflake DB Read More »

Intro to SQL User-Defined Functions: A Redshift UDF Tutorial

Leave a Comment / Tutorials /

As a data analyst, your credibility is as valuable as your analytical skills. And to maintain your credibility, it’s important to be able to answer questions correctly and consistently. That’s why you must be careful to integrate reproducibility into your SQL analyses. This tutorial is going to show you how you can use Redshift User

Intro to SQL User-Defined Functions: A Redshift UDF Tutorial Read More »

Dynamic Gantt Charts in Google Sheets + Project Timeline Template

45 Comments / Google Spreadsheets, Tutorials /

Google Docs and Gantt charts are a perfect match. Google Spreadsheets offers the ability to share and update spreadsheets in real-time, which is a major benefit for any project team, especially those who work in different locations or time zones. On top of that, you can’t beat the free price! Many projects are complex enough

Dynamic Gantt Charts in Google Sheets + Project Timeline Template Read More »

CONTACT
CONTACT