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 »
I needed to know when a post was posted… I was recently working with a client who had impressive success driving new leads via leadership posts on LinkedIn. We found a reliable relationship between posting and commercial activity, whether in DMs or on their marketing site. The problem was that I wanted to know exactly …
Three Ways to Find the Exact Date of a LinkedIn Post Read More »
At the beginning of every month, Google Search Console sends out its Monthly Search Performance email to site owners. Each month I receive this email, I’m reminded of two things: 1) My site’s performance doesn’t really change much, and 2) These statistics are a great way to demonstrate how to write SQL for the Google …
Google Search Console Monthly Performance Emails in SQL Tutorial Read More »
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 »
Discover the differences between the searchdata_url_impression and searchdata_site_impression tables, and learn how they can help you analyze your site’s performance at different levels of granularity.
In today’s all-or-nothing startup environment, young businesses need to be near-perfect in every aspect to succeed. As startups grow, analytics is the key to success. And yes, data-driven insights can be a game-changer. However, a widespread challenge persists: most startups struggle to integrate analytics seamlessly into their day-to-day business operations. As a founder, you have …
Fostering Collaborative Analytics: A Founder’s Guide Read More »
Finally, I had enough of it. Whenever I turned on my Vitamix, it was all or nothing—high or higher. The variable speed dial stopped working. No matter what speed the Vitamix was set to, I could only choose from high or flip the switch to super turbo. This led to several protein shake explosions (It …
Fix your Vitamix’s variable speed control with $35 and a screwdriver Read More »
When you think of “programming languages for data,” Javascript probably doesn’t even make the list. Yet, if you’re using Dataform, it’s almost impossible to avoid. As you’ll learn in this article, Dataform is Javascript all the way down. Even SQLX files that you write are pretty much just Javascript files under the covers. So shed …
You may have heard about Dataform or even be curious about using it. If so, you’re in the right place. My goal in this post is to introduce the tool and the interesting story and technology behind it. We’ll start with a brief history, then zoom through the context in which it arose, and finally …
How does Dataform work? A primer on the ref function Read More »
Recently, I had a problem with my LG dryer. I could turn it on, and it would run, but the clothes never dried because the dryer didn’t create any heat. On top of that, the cooling indicator light remained on from the beginning of the cycle until the end. It turned out that it was …
LG Dryer not heating and stuck in Cooling Mode? Fix it with $10 & a screwdriver. Read More »
