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 »
As a digital marketer, I use SQL every single day. And looking back on my career so far, it would be fair (though a bit reductive) to say that I could define my career by two distinct periods: before I learned SQL and after I learned SQL. The two periods are distinct for three main
Getting Started with SQL for Marketing (with Facebook Ads Example) Read More »
A personal note: These are my learnings from consulting, being part of a growth team at Postmates, then leading growth at Panoply, so hopefully, it’s insightful. This post has been idling in a Google Doc for weeks because I couldn’t dedicate the time to complete it. So instead of never completing a single long post,
How to Scale Yourself in a Growth Role, Part 1: Your Time Read More »
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 »
You are probably here because you have more SEO data than you know what to do with and precious little time to make sense of it. A framework is exactly what you need. An SEO measurement framework draws the relationships between all the metrics that you collect and the levers that you can pull to
Metrics and Levers of an SEO Measurement Framework Read More »
Freshness matters. It matters to searchers, therefore it matters to search engines, therefore it should matter to you. The best tool to ensure that search engines have your site’s freshest content is your sitemap. This post explains why pinging search engines with your sitemaps is important for SEO and how to optimize the process and
Pinging Search Engines with Your Sitemap Works – Here’s How Read More »
As we all know, the data layer (dataLayer if you’re a nerd) is a great way to provide data about an application, it’s users, and, it’s content to analytics and marketing technologies. But one thing that is underappreciated about the data layer is that it provides context for personalization. There are a number of ways
Adding a Hubspot Data Layer for Personalization and Profit Read More »
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, especially those who work in different locations or time zones. On top of that, you can’t beat the free price! Many projects are complex enough
Dynamic Gantt Charts in Google Sheets + Project Timeline Template Read More »
Keyword stemming is the process of removing all modifiers of a keyword, including prefix, suffix, and pluralization, until only the root of the word remains. For example, “consulting” and “consultant” would be stemmed to the same root, “consult.” This technique is useful for SEO keyword research because it helps to identify and group similar keywords.
What is keyword stemming? Use it … Wisely Read More »
Pssst… have you heard about Google Search Console’s BigQuery integration?? The thing I enjoy most about SEO is thinking at scale. Working at Postmates was fun because sometimes it’s more appropriate to size opportunities on a logarithmic scale than a linear one. But there is a challenge that comes along with that: opportunities scale logarithmically,
SEO with the Google Search Console API and Python Read More »
