Payments Platform Creates One Source of Truth into Amazon Redshift to Scale their Insights

The Situation

Today, Instamojo operates 1,000,000 Indian businesses from 29 States and 7 Union Territories with 10+ million customers.

At the core of Instamojo is a platform with multiple interfaces. There’s one interface for payments and more for fraud detection, logistics, and shipping, working capital, support, and marketing.

“We have to be able to understand our customers, how they use our products in order to keep innovating and scaling our impact. That requires data access to many of the data sources our company uses, plus I need the data today.”

Monitoring and analyzing those touchpoints would require from Instamojo to build, maintain and optimize for analytics use a number of SaaS cloud services and that could be hard.

Building the data infrastructure

Ankur successfully piloted Blendo with their product data coming from Mixpanel first, then integrated data sources that spanned all company sectors.

Today, all of Instamojo’s data sources are integrated with Amazon Redshift, maintained and syncing automatically, giving analysts insights on support, product, sales, and marketing sectors.

Ready to use tables in Redshift let Ankur understand Zendesk tickets distribution in their support team. He also uses data from Pipedrive to understand sales and deals and from which channel best deals come from. He also uses his Mixpanel data to dig into product behavior.

“One of the biggest benefits of Blendo is that it helps us get the most out of our data. We focus on critical insights and not building and maintaining code bases for integrations. And I now have a much better view of what’s happening in our company.”

Instamojo uses the following datasets and sources:

• Mixpanel (Product data)
• Zendesk Support (Support data)
• Pipedrive (Sales CRM data)
• Facebook Ads, Google Ads (Advertisement data)
• Zendesk Chat (Support / Chat data)
• Google Sheets
• Webhooks

Everything in our RedShift and BI

According to Ankur, the biggest impact Blendo had was better clarity and insights. “Blendo gives us clarity and insights on our support, sales and product teams”.

But Blendo helps in other ways, as well. Instamojo uses Blendo to:

• Get accurate data: “It helps us to get data consistently, from various sources to Amazon Redshift with no implementation and maintenance pains.”
• Get on-time data: “We do not need to write scripts or manually pull data anymore. Blendo gives us the ability to have on-time delivery of our data.”
• Get Analytics-Ready data: “We have many data sources, where if combined they give us a full view of our company. With analytics-ready data and data models that make sense, we saved tons of time from our analysts.”

“Blendo is indeed one of the best companies I worked with. Especially their support team has been terrific.”