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 …
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 »
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 to run highly targeted …
The Complete LinkedIn Industry List (+ Linked Ads Categories) Read More »
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 »
Company targeting is one of the most unique advertising features of Linkedin Ads. No other advertising platform has access to such an extensive and up-to-date employer-employee data set. For that reason, no other platform can natively support targeting audiences based on their employer. This makes Linkedin Ads an indispensable platform for B2B marketers and the …
Linkedin Ads Company Targeting Options and Statistics for 2023 Read More »
Let’s say you want to create a new email campaign to drive sales. Should you use customer segmentation or personas? What if you want to run an A/B test on a website? Which should you use? It’s time to develop a new feature for your SaaS product… you get the idea. Customer segmentation and personas …
Customer segmentation vs. Personas: When to use and how to choose Read More »
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 »
In the first post in the Minimum Viable Data Stack series, we set up a process to start using SQL to analyze CSV data. We set up a Postgres database instance on a Mac personal computer, uploaded a CSV file, and wrote a query to analyze the data in the CSV file. That’s a good …
Setting up Airbyte ETL: Minimum Viable Data Stack Part II Read More »
“A spreadsheet is just data in single-player mode” Last week I made a mistake. I boldly claimed that “A spreadsheet is just data in single-player mode.” And while I stand by that claim. I didn’t expect to be called to account for it. As it turns out, the post was pretty popular and I think …
From Spreadsheets to SQL: Step One towards the Minimum Viable Data Stack Read More »
