Propel

One feature daily—get ready! We're joining Supabase's MEGA Launch Week from 2–6 Dec 2024. What's cooking? ◆ Fresh new UI components for building dashboards ◆ Pipelines to easily ingest events to Propel's Serverless ClickHouse ◆ A huge surprise feature! Don't miss out!

New blog post just dropped: Funnel Analysis in ClickHouse. Need to understand user behavior and optimize your funnels? 🤔💡 Funnel analysis can give you the insights you need by showing how users move through key stages, like viewing a product, adding it to the cart, and making a purchase. But what if you could do this at scale, in real-time, with speed and precision? 🚀 ClickHouse's windowFunnel function is your new best friend! With ClickHouse's performance capabilities, you can track user journeys across a series of events, understand where drop-offs happen, and find opportunities to boost conversion. Our latest blog post breaks down exactly how to perform funnel analysis in ClickHouse, using a fun taco shop example to show how you can: ◆ Track user journeys through different funnel stages ◆ Identify where users drop off ◆ Decide whether to use windowFunnel or sequenceMatch depending on your use case. Whether you're analyzing an online store funnel or any other conversion path, Propel's windowFunnel function is a powerful tool to have in your analytics toolkit. Check out the full blog post here: 👉 https://lnkd.in/gETWkR2T Let me know in the comments if you've tried this approach or if you're curious to implement funnel analysis in your projects. I'd love to hear about it! 👇

Really good technical blog post just dropped on handling real-time updates and deduplication in ClickHouse. The post details how to use the ReplacingMergeTree table engine to keep your data fresh, consistent, and without all the manual headaches. It covers how to: ◆ Set up efficient sorting keys to balance performance and deduplication ◆ Manage real-time updates seamlessly using ReplacingMergeTree ◆ Avoid common pitfalls like inflated row counts and merge timing issues It's all broken down with examples and best practices. 🚀 Read it here: https://lnkd.in/dKkwaVhr

🎙️🦻

What a month! Here are some of the main things that shipped last month: 1️⃣ ClickHouse SQL Interface The new native ClickHouse SQL HTTP interface that lets you query Propel’s Serverless ClickHouse directly. You can use any standard ClickHouse library or SDK to run SELECT and SHOW queries against your data. 2️⃣ New Docs All neatly organized in the following sections: ◆ Serverless ClickHouse ◆ Ingestion ◆ Query APIs ◆ Embeddable UIs 3️⃣ Easier server-side authentication You can now more easily authenticate server-side applications using HTTP Basic Authentication with your Application ID and secret. Super-duper easy. 4️⃣ New GroupBy UI component This is a neat one. The <GroupBy> component is a dropdown to dynamically change the grouping of data for multidimensional analysis in your dashboards. Makes buidling multi-dimensional analysis super easy. 5️⃣ There even more goodies Check out the full changelog 👉 https://lnkd.in/g8aK96Ri

The team shipped our new docs site this week, and I think it's the best presentation of #ClickHouse concepts and Propel features we've ever done! S/O Nico Acosta and Felipe Cadavid for all the hard work migrating from Docusaurus to Mintlify. And thanks to the Mintlify team for building an awesome docs product. 🙌

Our latest Product Updates are out!

💡 ClickHouse Tip of the Day 💡 Flattening DynamoDB JSON data is key for better analytics. Use a Materialized View in ClickHouse to extract top-level keys and make your data more queryable.

💡 ClickHouse Tip of the Day 💡 Need automated cleanup of duplicates? ReplacingMergeTree handles merges in the background—ideal for reducing manual cleanup tasks. 🧹

Progress >>> perfection