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 »
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 »
I’ve had a few SEO consulting projects lately that have given me a chance to work with many more keywords than anybody should be working within a spreadsheet. When I come across these types of projects, I use the same workflow: bring all the data into a database and run the analyses in SQL. I …
SQL for SEO: A step-by-step keyword analytics tutorial Read More »
A few days ago, Cyrus Shepard posted an example about using Levenstein distance to compute the similarity or dissimilarity (aka the edit distance) between two strings. His example showed how to apply Levenstein 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 Levenstein 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 »
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 Stuck in Cooling Mode and won’t heat? Fix it with $10 & a screwdriver. Read More »
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 »
I’ve been asked for case studies, so I figured I’d create a little series of shorts that are a mashup of growth hacks and case studies. I’ve unimaginatively named them GrowthStudies. Here we go! There aren’t many easy ways to get viral promotion in B2B, But I’ve seen one work consistently. Best of all, it …
