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 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 Snowflake data warehouse, but I’ve been swirling around one that I find particularly interesting. Here’s what I’m thinking. Census, as
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 »
Go search Google for “free tiktok followers” and you will see some brilliant, although dirty #blackhat #SEO. Most of the top ten results belong to a spammer who has hacked into dozens of sites and created fake profiles and uploaded .pdf files to public directories with spun content. That scam is surprising, but what’s particularly
There’s something to learn from black hat SEO tactics for PDF files Read More »
I decided it’s time I’d learn GA4 so I figured I’d implement it net new and figure it out along the way. A couple of things I rely on heavily on my sites are Content Groupings and Custom Dimensions. Luckily, GA4 handles these a lot better than UA—even if they are still a bit cumbersome.
Google Analytics 4 Pageview Custom Dimensions and Content Groupings Read More »
I believe above all else, the role of Growth in an organization is to learn. Of course, the objective is to learn in the service of growth but I believe that the growth role is different than many traditional roles because the role demands that you navigate through a lot of ambiguity to optimize for
(Re) Defining Growth Experiments Read More »
