Case Study

Empowering CallHippo with Customized Subscription Analytics using Superjoin

Discover vital insights as CallHippo automates subscription analytics with Chargebee and Google Sheets through Superjoin.

Superjoin x Callhippo

Summary

CallHippo was facing challenges in analyzing SaaS metrics directly impacting growth. It sought Superjoin's assistance to help them automate their customized SaaS metric reports with different segmentations, not available on Chargebee directly. The manual creation of revenue reports from Chargebee was time-consuming and hindered in-depth data analysis. Superjoin's solution automated the process, providing personalized reports and uncovering blind spots, ultimately enhancing CallHippo's efficiency and revenue tracking capabilities by 50%.



What were the challenges faced by the CallHippo team?

Ankit - Callhippo's founder, wanted to analyze revenue metrics deeply. He tried Chartmogul, but the numbers weren't adding up, and he didn't like its limited flexibility. The kind of reporting and depth he needed was only possible on a spreadsheet.

He ended up tracking revenue reports on Google Sheets because of the flexibility Google Sheets offers. However, creating these reports on Google Sheets involved manual tasks such as downloading CSVs from Chargebee and cleaning data before analysing trends. The founder aimed to automate this workflow to focus on uncovering patterns contributing to high churn and low expansion.

The problems stemmed from:

a. Manual Workflows: Downloading CSVs from Chargebee to Google Sheets became a weekly, time-consuming task, taking almost two days to generate reports. The need for in-depth data analysis, not feasible on Chargebee, led them to seek a more flexible solution.

b. Need for Custom Subscription Analytics: Callhippo desired custom reports beyond the capabilities of standard Chargebee or other subscription analytics tools like Chartmogul. They sought a solution, like Superjoin, to automate the creation of bespoke reports and bring them directly to the team.

c. Standard Calculations were not cutting it: Callhippo's usage of Chargebee, while personalized, led to irregularities in data due to specific preferences, such as avoiding invoices paid in INR. With such customisations, standard calculations resulted in inaccurate revenue numbers.


How Superjoin Solved the Problem?

Superjoin connected Google Sheets with Callhippo's Chargebee account enabling seamless real-time integration of Chargebee data and Google Sheets.

Customized Subscription Insights: Superjoin went above and beyond by furnishing Callhippo with a detailed history of each subscription. This involved the historical MRR and meticulous tracking of movements within their MRR over time. 

Automated Personalized Reports: As Callhippo sought to navigate the intricacies of their financial data, Superjoin empowered them to effortlessly generate reports, including a personalized MRR by Plans report, Churn Report, and MRR movement reports. 


Impact on Business


  • Eliminated manual two-day-process per week by automating reports

  • Enabled tracking of revenue growth and Root Cause Analysis (RCA) for business insights

  • Identified revenue blind spots in Chargebee data, leading to a significant discovery of a 15% loss in overall business revenue which wasn't being accounted for earlier.


Conclusion

Superjoin's collaboration with CallHippo transformed their approach to revenue reporting, addressing manual challenges and uncovering crucial business insights. The tailored automation solution improved efficiency, saved time, and enhanced revenue tracking capabilities, making Superjoin a valuable asset to CallHippo's growth strategy.

Explore how Superjoin can streamline your reporting processes, providing personalized solutions for your unique business needs. Try out Superjoin today on your own or book a demo to automate your data analysis and reporting workflows.



Try it now

Gathering all your data has never been simpler.

Install for Free

Automatic Data Pulls

Set Alerts

Visual Data Preview