Featured Posts

GPT vs Claude: What's The Best AI Model?
GPT vs Claude: What's The Best AI Model?
Which models are the most performant and cost effective? Which win at what use cases?
Ellen Perfect
27 January 2025
Product-Led Growth With Claude: Turning User Events into Customer Insights
Product-Led Growth With Claude: Turning User Events into Customer Insights
Use product usage metrics to predict next best actions with Claude and Census GPT Columns
Julie Beynon
27 January 2025
Unlock Hidden Revenue with AI-Powered Upsell Scoring and Census AI Columns
Unlock Hidden Revenue with AI-Powered Upsell Scoring and Census AI Columns
How to use AI to identify premium customer characteristics and create Upsell Scores for all customers, then sync high potential individuals to marketing channels
Katy Yuan
6 December 2024

Posts about : Tutorials (5)

Tutorials (5)
The 5 SQL date functions biz ops teams need to know | Census
Terence Shin
7 September 2021
Trying to figure out all the different SQL date functions out there? Follow a fictional company to learn 5 functions to help your business ops.
Tutorials (5)
How to Export CSV Data from Snowflake | Census
Trevor Fox
15 July 2021
Here's our guide to moving the data you need from Snowflake to the tools, cloud platforms, and reports you love via CSV.
Tutorials (5)
Marketing mix modeling: Python tutorial with example dataset | Census
Terence Shin
12 July 2021
Data can help turn your marketing from art into measured science. Here's a primer on how you can harness marketing mix modeling in Python to level up your efforts and insights.
Tutorials (5)
Write to custom contact records w/ the HubSpot API | Census
Michel Zurkirchen
7 July 2021
Frustrated you can't leverage all your data in HubSpot? Here's a quick & dirty guide to writing to custom contacts w/ the HubSpot API & Python.
Tutorials (5)
How to Hack It: Postgres to Google Sheets w/ Python | Census
Ollie Glass
1 July 2021
Need to move all your customer data from Postgres into Google Sheets with Python? Here's a quick guide to get from A to B (and a shortcut).
Tutorials (5)
Essential SQL window functions for business operations | Census
Allie Beazell
22 June 2021
Looking to take your SQL skills to the next level (and save some sanity)? It's time to tackle SQL window functions like ROW_NUMBER(), AVG(), and more.
Tutorials (5)
Pipedrive API w/ Python tutorial: Contact records | Census
Allie Beazell
8 June 2021
Want to use Pipedrive as your sales CRM, but need to get data from other sources into it? You can hack it with the Pipedrive API and python.
Tutorials (5)
Intro to Survival Analysis in Python | Census
Allie Beazell
6 May 2021
Survival analysis in Python will help you better understand your customers and organization. Here's what you need to get up to speed.
Tutorials (5)
Your guide to revenue cohort analysis | Census
Sylvain Giuliani
19 January 2021
Gather insights pertaining to customer churn, lifetime value, product engagement, stickiness, and more with cohort analysis in SQL.
Tutorials (5)
Enriching your Snowflake data with external functions | Census
28 October 2020
Now you can enrich your records, like Users in your warehouse, in a snap. With Snowflakes' External Functions, it's simple to do and a breeze to maintain. Here's how.