The two steps in Dataform execution: Javascript, then SQL statements

Understanding SQLX and Javascript in Dataform

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 …

Understanding SQLX and Javascript in Dataform Read More »

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

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 »

Fostering Collaborative Analytics: A Founder’s Guide

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 »

How to check if your LinkedIn Insight Tag Pixel Is Working

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 »

Linkedin Ads Company targeting

The Complete Linkedin Industry List in 2023 (+ Linked Ads Categories)

As of January 2023, there are 416 industry labels to choose from to categorize a company page. However, Linkedin Ads only allows advertisers to target based on 20 industry segments. Each of these 416 industry labels belongs to one of these 20 industry segments. That discrepancy amounts to a big problem for advertisers who want …

The Complete Linkedin Industry List in 2023 (+ Linked Ads Categories) Read More »

A better way to LISTAGG in Google Sheets (with Pivot Tables)

The SQL LISTAGG function in Snowflake or Redshift (or STRING_AGG in BigQuery) are aggregation functions that condense textual data into easy-to-view reports. Similar to other aggregation functions (like SUM or MAX), these functions aggregate data according to the column names in a GROUP BY clause.  This is a common pattern for rolling up a column …

A better way to LISTAGG in Google Sheets (with Pivot Tables) Read More »