Featured Posts
Introducing Sync Tracking: Enhanced Data Observability and Debugging
Sync Tracking is a powerful new feature in the Observability Toolkit that provides row-level visibility into every record synced in the last 14 days
Announcing Observability Lake: Extend Your Sync Data Retention and Gain Deeper Insights
Observability Lake allows you to use your own cloud storage to retain data, providing extensive historical records and complete visibility into all sync data
Announcing GPT Columns: Clean, Categorize and Enrich in Seconds
Write AI-powered columns to your warehouse without code
How to Export CSV Data from Snowflake | Census
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
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
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
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
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
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
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
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
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.
Building an Account Hierarchy Model | Census
Build your growing SaaS business with Freemium, product-led growth. Of course, wrangling that massive influx of users and making sense of it to help your sales & marketing team can be tricky. Learn how we helped Notion do it.