How Mailmodo automated their reports on Google Sheets using Superjoin

Summary

In a recent conversation with Mailmodo's CEO & Co-founder Aquibur Rahman, we learned about their RevOps automation journey. Mailmodo is an interactive email marketing platform that helps marketers create emails with built-in forms, calendars, and shopping carts - all accessible directly within the email itself. With rapid growth leading to thousands of customers globally across 6 continents and a team of more than 70 members, Mailmodo needed an efficient way to streamline reporting across multiple tools.

Moheet, who oversees the RevOps function, was spending at least 4 hours every week manually gathering and consolidating data from multiple tools like HubSpot, Chargebee, and Google Analytics to create critical reports for the leadership team. This slowed down decision-making. Moheet discovered Superjoin, which enabled Mailmodo to automate their reporting, saving 4-5 hours weekly and providing the leadership team with real-time, accurate insights to make faster, data-driven decisions.

Challenges Faced by Mailmodo

As Mailmodo grew, they encountered several key challenges in reporting:

1. Manual Data Gathering: Moheet had to manually pull data from different sources like Google Analytics, HubSpot, and Chargebee, copy-pasting it into a spreadsheet. "It was taking me around 30 to 45 minutes to bring in all that data, copy paste to Excel sheet, and then crunch this number and then create a report," explains Moheet.

   
   

2. Data Silos: With metrics spread across multiple tools, it was difficult to get a consolidated view of the customer journey and business performance. As Aquib describes, "all of these tools have different data sources, and it has been very difficult for us to stitch that data from different sources."

   
   

3. Inconsistent Definitions: Different departments had their own ways of reporting metrics, making it complex to align the data.

   
   

4. Delayed Decision-Making: The manual reporting process meant the leadership team often had access to outdated information, hindering their ability to make timely, informed decisions.

   
   

5. Resource Constraints: Building a custom reporting solution would have required significant engineering resources, which Mailmodo couldn't spare from their core product development.

How Superjoin resolved these challenges?

Mailmodo chose Superjoin to address these challenges:

1. Seamless Integrations: Superjoin's one-click connectors allowed Mailmodo to integrate their entire RevOps tech stack, enabling them to track "how many visitors were there on the website, how many demos were getting over and how many demos were done... how many new customers we added," as Moheet explains.

   
   

2. Automated Data Collection: Superjoin's scheduled refresh feature automatically pulls data into Google Sheets daily, reducing reporting time from 30-40 minutes to just 1-2 minutes.

   
   

3. Customizable Reporting: Mailmodo could use Google Sheets' functionalities to create custom reports and dashboards that combined data from multiple sources.

   
   

4. Formula Fill-Down: Superjoin's feature ensured reports were updated and consistent without manual adjustments as new data came in.

   
   

5. Responsive Support: Superjoin's customer success team worked closely with Mailmodo to set up and optimize their reporting.

The Impact

By automating their reporting with Superjoin, Mailmodo achieved the following benefits:

1. Saved 4-5 Hours Weekly: The automated reporting process significantly reduced the time spent on manual data aggregation. "Now I spend around 5 to 6 minutes," confirms Moheet. Aquib also mentioned “We used to put manual efforts, on a daily basis, a few hours, which fortunately is now solved with Superjoin”

   
   

2. Faster Decision-Making: Access to real-time, accurate data enabled Mailmodo to identify issues and make improvements to their marketing and sales strategies more quickly.

   
   

3. Resource Optimization: Superjoin's automation freed up Mailmodo's resources, which they could then allocate to core business activities.

   
   

4. Expanded Reporting Use Cases: After initial success, Mailmodo expanded Superjoin's use to other critical reports, such as customer success metrics.

   
   

5. In conclusion, Superjoin transformed Mailmodo's reporting process, enabling them to eliminate data silos, improve data accuracy, and provide the leadership team with timely insights to drive faster, more informed decisions.

Discover how Superjoin can streamline your reporting processes and improve data coordination. Try out Superjoin today on your own or book a demo to automate your data analysis and reporting workflows.