Usage-Based Billing Is Way Too Hard - How the Warehouse Makes It Easy

So, how can organizations flexibly implement the business models that work best for them while accurately and compliantly billing customers?

We believe a warehouse-centric solution is the best approach to address the challenges of implementing usage-based billing.

Engineering resources

Implementing a usage-based billing system has considerable benefits for companies, but historically it has involved orchestrating entire billing teams. Setting up usage-based billing meant significant engineering resources required to build complex and scalable pipelines from the ground up using custom event tracking and legacy data infrastructure tools.

Algolia saw great success in switching from flat-rate pricing to usage-based billing. But as Bernadette Nixon, Algolia’s CEO, explained to VentureBeat, “It looks easy on paper — however, it’s a challenge to bring the automation and transparency to a customer, so they can easily understand. If you are looking to adopt a usage-based pricing model, you have to build it from the ground up…and it takes a lot of engineering and investment to do it the right way.”

Fortunately, now with Hightouch, it has never been easier to implement a usage-based billing system simply by leveraging the power of the data warehouse.

Accuracy

Accuracy is critical for billing systems. Undercounting usage leads to missed revenue, and overcounting usage destroys all customer trust. We spoke with a company that charged users based on the number of properties hosted on their site. The company used a usage-based metering platform that would increment and decrement their usage each time a property was added or removed. At the end of each billing cycle, the company would reconcile this out-of-the-box counter with the number of properties maintained in their own database–unfortunately, there would almost always be a discrepancy.

This was a recurring narrative across many billing teams. Creating a separate source of truth for billing often resulted in reconciliation work. Instead, by leveraging the data warehouse as the source of truth for billing, organizations can ensure that usage and billing data are up-to-date and consistent across all platforms.

Flexibility

As businesses evolve, existing pricing strategies will change and new products will be added. Without a flexible architecture, teams of engineers will always be needed to add new product SKUs or update pricing.

A data warehouse provides unlimited flexibility, enabling data and finance teams to launch and experiment with pricing without dependencies on engineers. Rather than writing custom code or being constrained by out-of-the-box interfaces, finance and data teams can create and update their billable metrics using just SQL.

A warehouse-centric approach provides the ideal infrastructure to flexibly iterate pricing plans. Since event data is persisted in the warehouse, teams can iterate on pricing by backtesting new pricing models on historical data.

Scalability

When building out usage-based billing infrastructure, most teams underestimate how quickly their businesses will grow. Teams then start to drop events, resulting in lost revenue, because they struggle to handle the increased data volumes.

Cloud data warehouses, however, are inherently elastic and scalable.

As volume grows, so does the complexity, scope, and need to send billing metrics to various platforms. When usage overages occur across multiple product lines or customer domains, new invoices will need to be generated, teams will want to be alerted, and customers must be informed. With Hightouch’s catalog of 125+ destinations, teams can pass data to any system they need, so they can scale their pricing model effectively and quickly.

Activate your Warehouse to Implement a Billing System in Minutes

With Hightouch, customers now have a seamless way to implement consumption-based pricing in minutes instead of months of engineering work—and to do so with the assurance that those customer invoices reflect the most accurate and up-to-date usage data.

Using just SQL, automatically sync product usage data you already track in your warehouse into

• Stripe or NetSuite to generate invoices,
• transactional databases to power your customers’ dashboards,
• Slack to alert your teams, and
• Salesforce to inform your go-to-market strategies.

By leveraging usage data directly from your warehouse to automate billing, teams can:

• Meter and aggregate usage data with just SQL
• Generate invoices with accurate usage data in Stripe or NetSuite
• Send consistent billing information to dashboards, Slack, and Salesforce
• Make auditable updates to business models
• Initiate discounts or credits in Stripe or NetSuite
• and much more!

With Hightouch’s easy-to-use user interface, robust integrations, granular permissions, and audit logs, users can seamlessly implement a compliant, secure billing system in minutes, saving headaches and engineering resources.

Without Hightough, we would have had to use valuable engineering time to set up custom endpoints to create financial records. Thanks to Hightouch, we were able to automate sales order and utility rebate invoice creation in under 30 minutes, and our accounting team has a few extra hours each week to focus on value-added work.

James Ayoub

Data Platform Lead

•

Dandelion Energy

How It Works

You can get started in five easy steps.

1. Add your data warehouse to Hightouch as a source.
2. Once you have your warehouse as a source, navigate to the Models tab to create a query to aggregate your usage quantity.
3. Then navigate to the Syncs tab to select the billing destination to which you want to sync your aggregated product usage data.
4. Once published, your aggregated product usage data will sync to your billing destinations, creating a new invoice or updating the number of services or items. This will allow you to generate invoices based on the latest aggregation of usage.
5. You can sync the same aggregated product usage data model to Postgres, Slack, and Salesforce to increase visibility for customers and teammates.

Invoicing example

Check out our playbook on implementing usage-based billing for more details.

Get Started

Learn more about using Hightouch for usage-based billing here or book a demo with one of our experts.