Introduction

Swataleem, a non-profit organization dedicated to educating adolescent girls in Kasturba Gandhi Balika Vidyalayas (KGBVs), conducts awareness campaigns to create meaningful impacts. These campaigns often involve interactive voice response system (IVRS) calls to reach groups of students. However, analyzing the success of these campaigns has been a significant challenge. Until recently, Swataleem relied on Excel sheets for analytics, which proved inadequate for their growing needs.

As part of Raghuvartech, a technology firm focused on innovative solutions, I developed a more robust and efficient system for Swataleem. By leveraging Python Flask, Google Cloud, and Looker Studio, we created a solution to automate data collection and provide actionable insights, transforming their workflow. This blog outlines the journey and technical details of this impactful project.

The Challenge

Analyzing the success of IVRS campaigns using Excel sheets presented several limitations:

• Manual Effort: Updating and analyzing data manually was time-consuming and error-prone.
• Lack of Real-Time Insights: Campaign performance metrics were not available instantly, delaying feedback and optimization.
• Complex Data Trends: Identifying trends or actionable insights required extensive manual effort, limiting the scalability of their operations.

Swataleem needed a solution that could automate data collection, integrate seamlessly with Exotel, and provide real-time, visualized insights to enhance their decision-making process.

The Solution

Understanding the Requirements

The project aimed to:

• Collect real-time data from Exotel’s IVRS campaigns.
• Analyze key performance indicators (KPIs) such as call engagement and completion rates.
• Provide actionable insights via interactive dashboards.

Building the Webhook

A Python Flask-based webhook was developed to interact with Exotel’s API and fetch real-time call data. Key steps included:

1. API Integration: Configured the webhook to receive callback data from Exotel.
2. Data Formatting: Parsed and structured the data to match the analytics requirements.
3. Error Handling: Ensured robust error handling to manage incomplete or erroneous data.

Integrating with Google Cloud

To ensure scalability and reliability, the webhook was deployed on Google Cloud using Cloud Run. Benefits included:

• Serverless Architecture: Simplified deployment and management.
• Scalability: Handled varying traffic loads seamlessly.

Visualizing Data with Looker Studio

Looker Studio was chosen to create an interactive dashboard for real-time data visualization. The key metrics included:

• Call engagement rates.
• Call completion trends.
• Drop-off points.

The dashboard enabled Swataleem to:

• Monitor campaign performance instantly.
• Identify areas needing improvement.
• Optimize future campaigns based on actionable insights.

Benefits for Swataleem

The new system brought several improvements:

• Efficiency: Automated data collection reduces manual workload.
• Real-Time Insights: Enabled quicker decision-making.
• Scalability: Supported the analysis of larger campaigns.

By transitioning from Excel sheets to a robust analytics platform, Swataleem significantly enhanced its ability to measure and improve the impact of its campaigns.

Lessons Learned

• User-Centric Design: Understanding Swataleem’s pain points was crucial for developing an effective solution.
• Automation is Key: Automating repetitive tasks frees up valuable resources.
• Data-Driven Decisions: Visualized data provides clarity and drives impactful strategies.

Conclusion

By leveraging technology, Swataleem has transformed its workflow and amplified its impact on education awareness campaigns. This collaboration between Swataleem and Raghuvartech underscores the power of data-driven solutions in addressing social challenges. Together, we’ve taken a step towards empowering education for adolescent girls, and this is just the beginning.

If you’re working on similar challenges or have insights to share, let’s connect and make an impact together!