How Meetup Madness Utilised Zoho Creator to Optimise Their Event Management System

In the dynamic landscape of technology-driven events, orchestrating seamless experiences requires a sophisticated approach to information management. Meetup Madness, the driving force behind BeerOps – Australia’s largest DevOps and data networking event – recognized the need for a streamlined system to manage sponsors and volunteers. Facing the complexity of organising such a massive gathering, Meetup Madness turned to Zoho Creator for a solution that would improve their event management processes.

As a custom application builder, Zoho Creator allows us to build an intuitive interface to create tailored sponsors and volunteer portals, facilitating efficient data management while leveraging its adaptability to create a dynamic system tailored to Meetup Madness event management needs. In addition to that, the system was also integrated with their Zoho CRM to sync the relevant events, sponsors and volunteers’ data.

The creation of the custom application needs to have a user-friendly interface to ease the adoption of the new systems to external sponsors and volunteers and be easily manageable by the admin users of Meetup Madness. This requires an extensive initial review of the client projects, running through simulations of use cases and functionalities, and a continuous feedback loop between our development team and the Meetup Madness team to ensure a successful implementation of their custom application.

Meetup Madness established itself as a prominent network for emerging technologies since 2012. To reduce manual work and avoid errors during data entry processes in preparation of their events, they decided to utilise Zoho Creator to optimise their event management system following the successful rollout of their Zoho CRM and Zoho Campaign applications.

Meetup Madness specialises in providing networking opportunities in diverse technological fields such as automation, DevOps, and data security. They have built a community base of over 50,000 followers, emphasising their significant reach and influence. The company plays a pivotal role in connecting individuals and groups within the technology sector. They facilitate knowledge sharing and promote professional growth through their events, contributing significantly to the tech community.

“We had to review a million emails from our sponsors and volunteers to get everything in line for our events. We needed a system that will allow sponsors and volunteers to proactively submit any necessary details required to indicate their participation for our events” 

Problem Statement:

Previously, Meetup Madness’ event management, including the tracking of sponsors and volunteers’ activities still involved manual processes using Excel spreadsheets. They had to laboriously review “a million” email replies and send out relevant follow-ups to their sponsors and volunteers after carefully assessing the available information received from them. After reviewing the email correspondences, they also had to update the relevant records manually. 

Throughout a comprehensive technical discovery, some key requirements were discovered: they needed to develop custom portals for their sponsors and volunteers, record the tracking with alerts, determine table floor plan preferences, create slide deck automation, manage their volunteers, and create a form for their data handling. Let’s take a look at the details below. 

Key challenges:

1. Portal Development:

In the realm of portal development, our challenge was to design a user-friendly sponsor portal that facilitates the effortless entry and updates of crucial event details, including wording, QR codes, logos, and attendee information. Navigating the complexity of this task required a delicate balance between simplicity and comprehensiveness in data capture, necessitating meticulous planning to ensure a seamless user experience

2. Record Tracking and Alerts:

Addressing the need for robust record tracking and alerts, we undertook the challenge of implementing a comprehensive tracking system to monitor sponsors and volunteers’ activities while updating records and identifying missing information. Adding an extra layer of complexity, we need to develop a sophisticated notification system to alert sponsors about incomplete records, ensuring a proactive and streamlined approach to data management.

3. Table Floor Plan Preferences:

Tackling the diverse preferences of sponsors in table floor plans, our challenge involved collecting and organising a myriad of sponsor preferences without sacrificing clarity. The complexity arose in creating a flexible system capable of accommodating varied preferences and requirements, ensuring that the table floor plan is built as a flexible system, able to cater to varied preferences and requirement

4. Slide Deck Automation:

Part of the requirement is to create a slide deck automation, our challenge was to programmatically merge sponsor logos, QR codes, and information into a branded slide deck template. Negotiating the creative and technical intricacies, we must overcome the challenge of reflecting each sponsor’s unique identity while adhering to the overall event branding, resulting in a cohesive and visually appealing presentation.

5. Volunteer Management:

For volunteer management, the challenge was to devise a method to initiate a communication and engagement campaign to successfully recruit event volunteers. Addressing the complexity of this task, we need to craft a compelling call-to-action and provide clear FAQ links for volunteers, ensuring a seamless and informative recruitment process.

6. Form Creation and Data Handling:

Delving into form creation and data handling, the challenge encompassed developing comprehensive forms for volunteers and sponsors to provide essential details such as name, mobile number, state, and preferred time slots. The complexity lies in ensuring careful consideration in creating a system that handles both volunteer and sponsor data with efficiency, accuracy, and accessibility, guaranteeing a smooth and secure data collection process.

Recognizing the importance of a strategic and thorough problem evaluation, we need to start by conducting a comprehensive evaluation of the issues faced by the Meetup Madness team. This evaluation serves as the foundation for understanding the intricacies and challenges associated with key aspects of their operations. From portal development to volunteer management, each facet demands a nuanced approach. Through comprehensive user interviews, system assessments, and a keen eye on user experiences, we aim to uncover insights that will pave the way for targeted improvements for the Meetup Madness team.

1. Portal Development Planning

Throughout the implementation process, the client highlighted the need to connect multiple Event and Deal records in Zoho CRM with a single profile/user in Zoho Creator, incorporating various conditions or rules. This specific requirement demanded our expertise to determine the most effective implementation approach within the Zoho Creator environment, considering specific limitations.

2. Record Tracking Gaps and Notification Systems:

Previous event management experience involves tracking information manually through spreadsheets. These spreadsheets need to be manually updated by Meetup Madness staff as they review information relayed from emails sent from sponsors and volunteers of their events. Any request for additional information must also be conducted manually by the Meetup Madness staff.

3. Flexible Table Floor Plan Preferences:

Managing the table floor plan was very hectic as it’s all managed through spreadsheets and continuous email streams from multiple sponsors. Any updates to their table booking and assignment can be easily missed which can lead to complication prior to the event occurring and even worse, potential confusion at the day of the event.

4. Strategising Creation of Slide Deck Automation

The client  expressed a specific requirement for an integration between Zoho Creator and Google Slides. This integration is intended to automatically pull all data provided by the Sponsor into Google Slides without the need for manual entry. However, as of today, there’s no direct integration between Zoho Creator and Google Slides.

5. Volunteer Management:

This was previously conducted through manual reviews of email communications with numerous volunteers, generating a lot of admin work and potentially leading to staff missing key communication and information submitted by volunteers.

6. Form Creation and Data Handling:

They need a system that allows sponsors and volunteers to proactively update any data and information required from their end. This would reduce a lot of the admin work burden from the Meetup Madness team. Ideally, this would pair with some system notifications that prompts the sponsors and volunteers to update their information for a particular event, freeing the Meetup Madness team to focus on other tasks relevant to the event preparation and management.

By delving into these evaluations, we position ourselves to not only identify existing hurdles but also to craft effective solutions that align with the unique requirements of each component in Meetup Madness’ event management framework.

Using the insights we gained from the evaluated problems, we form the bedrock of our proposed solution plan, ensuring that each facet of the event management process is not only understood but strategically approached for enhancement of the Meetup Madness team’s operations as through the solutions proposed below:

1. Portal Development Planning

To address the challenges in portal development, our first step involves a comprehensive evaluation of user experiences. This includes conducting interviews and surveys to identify pain points users face in entering and updating critical event details such as wording, QR codes, logos, and attendee information. Simultaneously, we will gather feedback on the current portal’s usability and shortcomings. In tandem, we’ll assess the complexity of data capture, aiming to strike the right balance between simplicity and comprehensiveness, necessitating meticulous planning for a seamless user experience before carrying out the implementation.

2. Developing Efficient Record Tracking and Alerts:

In tackling record tracking and alerts, our approach begins with a thorough analysis of the existing tracking system. This involves identifying gaps, inefficiencies, and missing information in the records of sponsors and volunteers. Simultaneously, we assessed the specific requirements for the notification system, delving into potential impacts on user experience and data accuracy. This dual evaluation ensures a comprehensive understanding of the challenges and opportunities for improvement. We tailored a deluge script for both Zoho CRM and Zoho Creator. This script ensures that when a Contact record is associated with multiple Events and has multiple Deals in Zoho CRM, the Events available for selection in Zoho Creator by the profile/user are restricted to those linked with the corresponding Contact in Zoho CRM. 

3. Table Floor Plan Preferences:

Addressing the diverse preferences for table floor plans involves a multi-faceted evaluation. We start by gathering detailed sponsor preferences, ensuring clarity while organising the information. Simultaneously, we assess the need for a flexible system capable of accommodating varied preferences and evolving requirements. This comprehensive evaluation ensures that the table floor plan aligns seamlessly with each sponsor’s unique vision, maintaining both clarity and adaptability. Additionally, we developed another script in Zoho CRM to enforce a condition/rule where the table that can be selected is based on the ticket type in Zoho CRM.

4. Developing Slide Deck Automation:

For this requirement, our process begins with a review of branding guidelines provided by the Meetup Madness team. This involves understanding the intricacies of integrating sponsor logos, QR codes, and information while adhering to the overall event branding. Simultaneously, we assess the creative challenges associated with reflecting each sponsor’s unique identity, carefully navigating both creative and technical considerations for a cohesive and visually appealing presentation.

Taking into account the client’s request to use Google Slides, we leverage our expertise to propose a solution for the integration between Zoho Creator and Google Slides. The approach involved initially integrating Zoho Creator with Zoho CRM, followed by integrating Zoho CRM with Google Slides. This was achieved through the development of a deluge script combined with a custom button. This effort successfully met the client’s requirement for automated Google Slides creation based on data from the Zoho Creator portal.

5. Volunteer Management

Noting the challenges in recruiting volunteers, we conduct a thorough analysis of any communication gaps or barriers that may hinder volunteer engagement. Simultaneously, we review the effectiveness of the call-to-action for volunteer recruitment, analysing response rates and identifying areas for improvement. This dual evaluation ensures a robust understanding of the recruitment challenges and opportunities for enhancing volunteer engagement. 

6. Form Creation and Data Handling:

To address challenges in form creation and data handling, our approach begins with defining the essential data required from volunteers. We ensure clarity in capturing necessary information without creating unnecessary friction. Simultaneously, we evaluate the efficiency, accuracy, and accessibility of the system handling volunteer data. This dual evaluation ensures a careful consideration of data privacy and security concerns, resulting in a smooth and secure data collection process and we are able to create the relevant forms in Zoho Creator and map them to the relevant modules and fields in Zoho CRM.

Our solutions are meticulously designed to amplify the positive impact, ensuring seamless operations and an unparalleled experience for sponsors, volunteers, and all stakeholders involved and guaranteeing successful future event management for the Meetup Madness team.

The implementation of the proposed solutions for integrating Zoho Creator, Zoho CRM and Google Slides at Meetup Madness was structured to ensure minimal disruption to ongoing operations while maximising the efficiency and effectiveness of the new system. The process was divided into several key phases:

1. Project Kick-off and Planning:

A project kick-off meeting was held to align all stakeholders with the project goals, timelines, and expectations. We developed a detailed project plan, outlining each stage of the implementation, including system integration, workflow automation, data migration, and staff training.

2. System Integration Development

This phase involved designing the API or selecting appropriate integration tools, followed by development, testing, and deployment.

3. System Testing:

Rigorous testing was conducted to identify and rectify any issues, ensuring the integrated system functioned as intended without any data loss or discrepancies.

4. Staff Training and Change Management:

Comprehensive training sessions were conducted for Meetup Madness’s staff, focusing on the operation of the new integrated system and best data management practices. We also took care to apply the relevant change management strategies employed to assist staff in adapting to the new system and to address any concerns or resistance.

5. Custom Button Implementation:

Custom Button was implemented within the integrated system to streamline the Google Slides record creation.

6. Monitoring and Feedback Mechanism:

A system for ongoing monitoring of the integrated system’s performance was established. Regular feedback from staff and clients was solicited to identify areas for further improvement and to ensure the system was meeting its intended objectives.

7. Continuous Improvement and Support:

Based on the feedback and monitoring data, continuous improvement measures were implemented to refine the system’s functionality and efficiency. Ongoing support and maintenance were provided to address any emerging issues or system upgrades. We also assisted with updating existing contacts from their Eventbrite platform to ensure seamless data synchronisation with Zoho Creator.

The implementation phase was characterised by a collaborative approach, ensuring all stakeholders were engaged and informed throughout the process. By following a structured and phased implementation strategy, Meetup Madness successfully integrated Zoho Creator, Zoho CRM and Google Slides, leading to enhanced operational efficiency and improved data management.

The implementation of the integrated system between Zoho Creator, Zoho CRM, and Google Slides at Meetup Madness yielded significant and measurable results, positively impacting various aspects of the business. The key outcomes of this initiative are outlined below:

1. Enhanced Operational Efficiency:

• The automated data synchronisation between Zoho Creator, Zoho CRM and Google Slides led to a marked reduction in manual data entry and associated errors. This streamlined the workflow, allowing staff to focus on more value-added activities.
• Workflow automation in Google Slides record creation reduced the Meetup Madness’s team manual entry in creating a single Google Slides. 

2. Improved Data Accuracy and Consistency:

• The integration resulted in higher data accuracy and consistency across both systems. This reduced discrepancies in client and job information, leading to more reliable and effective service delivery.

3. Increased Staff Productivity and Satisfaction:

• With the reduction in manual and repetitive tasks, staff productivity increased. This also led to improved job satisfaction as employees could engage in more meaningful and less tedious work.

4. Scalability and Growth:

• The new system provided a scalable solution that could accommodate Meetup Madness’s growth. This ensured that as the company expanded, its operational capabilities could efficiently grow in tandem.

5. Cost Savings:

• The increased efficiency and reduction in time spent on manual processes resulted in cost savings for Meetup Madness’s. These savings could be redirected to other strategic business areas.

6. Quantifiable Success Metrics:

• Post-implementation metrics showed a significant reduction in the time required for data management and a decrease in data-related errors. Customer feedback scores also improved, reflecting better service quality.

7. Positive Feedback from Staff and Clients:

• Both staff and clients provided positive feedback on the new system. Staff appreciated the ease of use and reduced workload, while clients noted the improved accuracy and speed of service delivery.

In summary, the integration of Zoho Creator, Zoho CRM and Google Slides at Meetup Madness not only resolved the initial operational challenges but also brought about transformative changes in the company’s efficiency, data management, customer satisfaction, and overall business growth lead. They have recently held a successful “BeerOps” event in Perth and are looking forward to managing more of their events using their custom Zoho Creator portal and implementing additional refinement to the portal to ensure a seamless customer experience. These results underscore the value of investing in integrated technology solutions to address specific business challenges.