Featured Posts
GPT vs Claude: What's The Best AI Model?
Which models are the most performant and cost effective? Which win at what use cases?
27 January 2025
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
27 January 2025
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
6 December 2024
Posts about : Tutorials (5)
The 5 SQL date functions biz ops teams need to know | Census
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.
How to Export CSV Data from Snowflake | Census
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.
Marketing mix modeling: Python tutorial with example dataset | Census
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.
Write to custom contact records w/ the HubSpot API | Census
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.
How to Hack It: Postgres to Google Sheets w/ Python | Census
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).
Essential SQL window functions for business operations | Census
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.
Pipedrive API w/ Python tutorial: Contact records | Census
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.
Intro to Survival Analysis in Python | Census
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.
Your guide to revenue cohort analysis | Census
19 January 2021
Gather insights pertaining to customer churn, lifetime value, product engagement, stickiness, and more with cohort analysis in SQL.
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.