ToolsBlog

Posthog <> ChatDB

Try it free:Query CSV with SQLData Profiler

Table of Contents

  • Connecting Posthog and ChatDB
  • Analyzing with ChatDB
  • Daily Active Users
  • Top Referring Websites
  • Conclusion

Posthog to ChatDB banner

Hi! 👋 Good to see you!

Here at ChatDB, we use Posthog to track daily and weekly active users, user growth and retention, and website references to ChatDB. With Posthog, we export the data and analyze it using ChatDB!

Posthog is an open-source platform made for your products. They offer many features, but for this, we will be utilizing their Product analysis toolset.

In the following tutorial and demo, we'll show you how you can use ChatDB and Posthog to understand your products and users better.

Connecting Posthog and ChatDB #

  • First things first, you're going to need to set up your product with Posthog and start collecting data.

  • Once you have a dataset you're happy with, we can start to export the data. Exporting your Posthog data to a .csv is simple. Simply find the Insight you want to analyze, hit the ... in the top right corner, then Export -> .csv

  • Next, we're going to need a Postgres or MSSQL database. If you don't already have one, Neon provides free Postgres databases with a large knowledgebase of documentation to answer any questions you may have while creating and importing your .csv files.

  • Finally, we can connect the database to ChatDB and find all of our imported .csv files right in our dashboard!

Imported Databased

Analyzing with ChatDB #

Now that we have our data in ChatDB eager to be queried, let's start exploring!

Daily Active Users #

For any product, Daily Active Users (DAU) is one of the most important metrics to understand how your product is doing. We're going to use ChatDB to find out what our daily active users look like.

Daily Average Users

Here, we can see that we have a current average DAU of 78. The query it gave us also saved us a lot of time, compared to writing it by hand!

SELECT
  AVG(daily_average)
FROM
  (
    SELECT
      (
        "12-Nov-2023" + "13-Nov-2023" + "14-Nov-2023" + "15-Nov-2023" + "16-Nov-2023" + "17-Nov-2023" + "18-Nov-2023" + "19-Nov-2023" + "20-Nov-2023" + "21-Nov-2023" + "22-Nov-2023" + "23-Nov-2023" + "24-Nov-2023" + "25-Nov-2023" + "26-Nov-2023" + "27-Nov-2023" + "28-Nov-2023" + "29-Nov-2023" + "30-Nov-2023" + "1-Dec-2023" + "2-Dec-2023" + "3-Dec-2023" + "4-Dec-2023" + "5-Dec-2023" + "6-Dec-2023" + "7-Dec-2023" + "8-Dec-2023" + "9-Dec-2023" + "10-Dec-2023" + "11-Dec-2023" + "12-Dec-2023"
      ) / 31 AS daily_average
    FROM
      export_daily_active_users_daus
  ) subquery

We can also have ChatDB graph the data for us for an upcoming presentation!

Daily Active Users Graph

This graph not only demonstrates ChatDB's graphing ability but also converts the poorly formatted data Posthog gave us into something usable.

Top Referring Websites #

SEO is another crucial aspect of managing your product. You may also have online social media campaigns or posts on other websites. Lucky for us, Posthog can track which domains refer people to us. We can export this data and analyze it using ChatDB!

First, let's make a pie chart with the data.

Top Referring Websites Chart

We can see here that most of our references are from Google, a good sign our SEO is well-optimized.

Conclusion #

With Posthog and ChatDB, the sky is the limit as to what you can do for your product. Posthog provides excellent logging for your product that can be used with ChatDB to query, analyze, and find trends and patterns.

Follow us on X for updates and sneak peeks into our latest features and for more ways ChatDB can be used to improve your product!

Try the tools from this post

Free and private: your files stay in your browser.

  • Query CSV with SQLRun SQL queries directly on CSV files.
  • Data ProfilerProfile CSV, Parquet, or JSON files with column stats and distributions.

Related posts

Introducing ChatDB Dashboards

We are proud to announce charts and MySQL support!

2024-01-28

Introducing Revamped Charts

Create data visualizations in a couple clicks! Upgrading charting capabilities and the brand new toolbar in ChatDB!

2023-11-14

DuckDB: An Introduction and Common Use Cases

A comprehensive guide to DuckDB, an in-memory analytical database, and its common use cases.

2023-07-15

ChatDB

Free, browser-side data tools. No uploads, no accounts.

Data tools

Reader

  • Parquet Reader and Viewer
  • Excel Viewer and Editor
  • SQLite Viewer
  • Gzip CSV Reader
  • CSV Size Analyzer
  • Parquet Schema Reader
  • Parquet Metadata Reader
  • Data Profiler
  • Image Measure
  • Shapefile Viewer
  • GeoJSON Viewer

Editor

  • CSV Viewer and Editor
  • Excel Viewer and Editor
  • Online Excel Editor
  • CSV Splitter
  • Markdown Editor
  • Image Cropper
  • SVG Editor
  • Screenshot Background Creator
  • Document Scanner
  • Audio Clipper
  • Video Trim & Crop Tool

Converter

  • CSV to Gzip Converter
  • CSV to Parquet Converter
  • Excel to CSV Converter
  • Parquet to CSV Converter
  • JSON to Parquet Converter
  • Parquet to JSON Converter
  • CSV Decompressor
  • CSV to JSON Converter
  • CSV to Markdown Table
  • Image Converter
  • KML to GeoJSON Converter
  • GPX to GeoJSON Converter
  • GeoJSON to KML Converter
  • Shapefile to GeoJSON Converter

Formatter

  • CSV Encoder
  • SQL Formatter
  • JSON Formatter
  • XML Formatter
  • YAML Formatter
  • Dataset README Generator
  • URL Encoder & Decoder
  • Regex Tester

Compressor

  • CSV Compressor
  • CSV to Gzip Converter
  • CSV Decompressor
  • Image Compressor

AI

  • Parquet AI
  • CSV AI
  • Color Palette Generator
  • Extract Image Colors

GIS

  • Lat/Lng Point Finder
  • KML to GeoJSON Converter
  • GPX to GeoJSON Converter
  • GeoJSON to KML Converter
  • Shapefile to GeoJSON Converter
  • Shapefile Viewer
  • GeoJSON Viewer

Image tools

Convert To

  • Convert to JPEG
  • Convert to PNG
  • Convert to WEBP
  • Convert to GIF
  • Convert to BMP
  • Convert to TIFF
  • Convert to ICO
  • Convert to AVIF
  • Convert to FF
  • Convert to HDR
  • Convert to EXR
  • Convert to QOI
  • Convert to TGA
  • Convert to PNM

Edit

  • Image Cropper
  • SVG Editor
  • Screenshot Background Creator
  • Document Scanner

Compress

  • Compress JPG
  • Compress JPEG
  • Compress PNG
  • Compress WEBP
  • Compress GIF

Company

  • All tools
  • Blog
  • Privacy Policy
  • Terms of Service

© 2026 ChatDB. All rights reserved.

v2.4.1