November 2021 Summaries

Self-service analytics platforms, such as PostHog, Mixpanel, and Amplitude, have gained popularity for empowering all members of an organization to independently analyze product and user data without needing SQL skills, contrasting with traditional centralized analytics teams that handle data analysis services. These platforms provide tools and access to data while ensuring user privacy and security, offering advantages like democratization of data, a single source of truth, increased efficiency, and faster decision-making. In contrast, centralized analytics teams can face challenges such as inefficiencies, lack of context, and communication barriers. Despite the capabilities of self-service analytics, tools like Google Analytics may not offer the depth needed for comprehensive user behavior analysis, leading organizations to explore alternatives like PostHog, which offers a broader range of features and the option for self-hosting to maintain data security and compliance.

PostHog is launching a Give Back Friday campaign to support the open-source community by donating $5 for every GitHub star received on their repository between Black Friday and Cyber Monday, up to a total of $50,000. The funds will be distributed equally among seven chosen open-source projects that PostHog utilizes or values for their contributions to their team and product. The selected projects include Rrweb, Graphile/Worker, Django REST framework, KeePass, Piscina, All-contributors, and Alex. This initiative aims to celebrate and support open-source efforts while also engaging PostHog's community in a meaningful way. Through this campaign, PostHog hopes to foster community involvement, build trust, and potentially increase their visibility on platforms like GitHub Trending, all while maintaining transparency and discretion over the donation process.

Product engagement is a crucial determinant of business retention and revenue, surpassing mere financial metrics in indicating long-term sustainability. Understanding and measuring customer engagement through specific metrics can significantly inform product development strategies and enhance user retention. These metrics include active users, stickiness, and adoption, providing insights into user behavior and preferences. Tools like PostHog offer valuable analytics capabilities, allowing businesses to track user interactions, understand feature adoption, and gauge overall satisfaction. By focusing on these engagement metrics, companies can refine their product offerings, ensure they meet customer needs, and ultimately nurture users into brand advocates.

PostHog 1.30.0 introduces a faster user interface, automatic conversion signal detection through correlation analysis, and the ability to save insights for future use, alongside a completely revamped recordings playback experience. This release marks the deprecation of Postgres-based deployments in favor of ClickHouse-backed installations, urging users to migrate for continued updates and features. The new release features an intuitive UI redesign, codenamed Lemonade, and a performance enhancement known as Turbo Mode, which significantly improves page navigation speed. Correlation analysis, a premium feature, allows users to uncover insights into conversion behaviors, while saved insights facilitate better collaboration by allowing team members to view and filter insights. The recordings feature now offers a more efficient search and playback experience, and the update includes several performance improvements, such as faster query handling and reduced frontend build times. The community played a vital role in this release, with contributions from several members and open roles for those interested in joining the PostHog team.

PostHog has rebranded its plugins as apps and integrated them into its core event ingestion system, with a focus on facilitating rapid feature deployment without heavy engineering investment. While plugins are widely used among self-hosted users—75.6% of whom use them, with 23.5% utilizing plugins beyond GeoIP—only a small fraction of PostHog Cloud users engage with plugins besides GeoIP, due to previous restrictions on plugin availability. The Timestamp Parser and User Agent plugin are among the most popular, with the latter being a community contribution. Plugins, especially export plugins, are crucial for larger enterprise customers, enabling data exports to warehouses like BigQuery. Despite their importance, the plugin system requires significant enhancements to increase adoption and improve user experience, particularly on PostHog Cloud. Future efforts are aimed at addressing bugs and enhancing extensibility, although these are not immediate priorities compared to core product development.

A dramatic month unfolded for the writer's family after their 16-month-old daughter was diagnosed with retinoblastoma, a rare eye cancer, leading to a whirlwind of medical appointments and treatments, including surgery and chemotherapy. Despite the challenges, including the removal of one eye and the potential return of the cancer, the family remains hopeful about saving her seeing eye with a 66% chance of success. Concurrently, the writer balances personal challenges with professional growth at PostHog, emphasizing the company's success in surpassing goals for their self-hosted and cloud products. With around 100 paying customers on PostHog Cloud and 8,000 companies deployed, the focus is on accelerating growth for their open-source and Scale products while enhancing their enterprise offerings. The strategy involves leveraging organic growth, implementing a scorecard to gauge high-quality signups, and refining their pricing and adoption model, particularly for large enterprises that value data control. The writer remains committed to not letting the personal challenges impede opportunities at PostHog and is determined to continue building and expanding the company's reach.

PostHog's transition from Postgres to ClickHouse, shared at the OSA Con 2021, highlights their journey in seeking a scalable, real-time database solution to accommodate their growing user base and data demands. Initially developed on Postgres for its relational data handling and ease of deployment via Heroku, PostHog faced performance declines as user adoption soared. This led them to explore a range of OLAP solutions, ultimately selecting ClickHouse for its speed, simplicity, and SQL-like interface. Despite challenges such as handling mutations and index complexities, the migration significantly improved real-time data processing and future-proofing capabilities, allowing PostHog to maintain swift performance and expand features seamlessly. The process involved parallel deployment with feature flags to manage the transition smoothly. Looking ahead, PostHog plans to deepen its integration with ClickHouse by exploring function-building at the source and experimenting with new engines to enhance data quality and operational efficiency further.