Pantheon.io is the leading Drupal & WordPress website hosting company. With over 200,000 hosted sites. And, over 10 BILLION pages served! Pantheon focused on creating high performance hosting, professional development tools for teams and the most successful automated Drupal and WordPress publishing workflows available.
Like other successful SaaS companies, Pantheon needed accurate and timely operational analytics to guide decision-making from tactical sales decisions to board level strategy and investor presentations, including…
- Annual Recurring Revenue
- Customer Churn
- Revenue Churn
- Customer Lifetime Value
- Customer Acquisition Cost
…to name just a few.
So, Pantheon partnered with Telegraph Hill Software to create a data repository to bring together marketing, sales, product, and, client data as the foundation for their analytics platform.
As Telegraph Hill Software’s Interim Chief Data Officer worked with Pantheon managers it was clear that Pantheon had grown large enough that each functional area had developed it’s own systems and semantics. So, the first task was to create a consensus among the leadership of each function regarding definitions of basic terms and the priority and urgency of each aspect of the analytics project. THS consultants led facilitated product design meetings where functional leaders participated in defined ‘agile design’ exercises informed by research of each functions supporting systems.
Source data is drawn from from multiple sources; micro-services withing Pantheon’s platform, Recurly subscription billing, Salesforce CRM and financial reporting systems. The data pipeline process extracts snapshots into a bucket file system. Dynamic schemas can automatically adapt to changes in source schemas and to the contents of JSON blobs from operational systems.
The resulting data store includes time series coding and provenance tracking so that changes to date range data over time can be explained completely.
Account relationship rules inform customer identification and data aggregation so that leadership decisions are based on agreed information.