Tutorials

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 »

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 »

Writing Custom Dimension to Google Analytics from Snowflake DB

Like many data geeks, Google Analytics was the thing that 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 Snoflake data warehouse but I’ve been swirling around one that I find particularly interesting. Here’s what …

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

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

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

Updated: August 2018 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- especial those who work in different locations or time zones. On top of that, you can’t beat the free price! There are …

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