Javascript

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 »

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 »

Scroll to Text Fragments

How to Highlight Text On a Page with “Scroll to Text Fragments”

If you read my blog, you probably know that I am a bit of a geek about URLs. The “Universal Resource Locator” is a fundamental principle of the internet and are responsible for a lot of interesting features of the information superhighway. URLs make it possible to navigate from page to page, to change the …

How to Highlight Text On a Page with “Scroll to Text Fragments” Read More »

Drift Chat Event Tracking with Google Tag Manager – Less Code, More Analytics

The market for website chatbots is growing steadily and with it, there have been a lot of entrants since Intercom lead the way. From Hubspot to Whisbi, each has their own take on it. What I found especially impressive is how Drift has opened up the tech side of their platform. This makes it a really fun marketing technology. Building chatbots …

Drift Chat Event Tracking with Google Tag Manager – Less Code, More Analytics Read More »

Using Hosted JSON-LD Files as applications/ld+json Scripts for SEO

Sometimes it’s just easier to separate concerns. Just like how stylesheets and .js scripts separate the form and function of the page from the presentation of the page, the same can be done with the JSON-LD schematic markup / structured data of the page. This example shows how you can add structured data for SEO …

Using Hosted JSON-LD Files as applications/ld+json Scripts for SEO Read More »

Google Apps Script doGet and doPost Tutorial + 6 Web App Examples

If you are new to Google Apps Script or programming in general, Google Apps Script Web Apps may seem daunting. The good news is that it is easy to understand with a little trial and error. This tutorial will give you 12 recipes to help you get started with the doGet and doPost functions and show …

Google Apps Script doGet and doPost Tutorial + 6 Web App Examples Read More »

9 Pro Tips for GTM Auto Event Tracking and the Click Element Variable

This week I did a Google Tag Manager implementation where I had no control over the site’s source code and no access to the site’s developers. It’s an imperfect situation but luckily, GTM Auto Event Tracking affords a solution that is very effective considering these constraints. This post is meant share a few tips on …

9 Pro Tips for GTM Auto Event Tracking and the Click Element Variable Read More »

Web Addresses Explained: What Every Human Should Know About URLs

If you can remember your elementary school English lessons, you might recall learning how to format postal addresses so you could send a letter or navigate yourself to a particular destination. Today, most of us navigate to Web addresses far more often than street addresses and yet we no sense about how web addresses work, what …

Web Addresses Explained: What Every Human Should Know About URLs Read More »

How to Make a Google Apps Script RESTful API or Service

You know what’s cooler than calling API’s and services with Google Apps Script? Making your own API with Google Apps Script. After playing around with my first REST API with Python and Bottle, I wondered how this could be done even cheaper and quicker; without worrying about the complexities of databases and hosting. When it’s simple …

How to Make a Google Apps Script RESTful API or Service Read More »