Background:

The Sydney Film Festival is a prominent cultural event in Australia, showcasing a diverse range of films from across the globe. The festival's operational complexity required robust data management and seamless integration of various systems to ensure efficient handling of ticket sales, customer relationships, and overall event management.

Challenges:

1. Data Management:

   • The festival had accumulated around 10 million records over the years, including historical data on ticket sales, customer interactions, and event details.

   • Existing data was fragmented across multiple legacy systems, making it difficult to access and analyze comprehensively.

2. System Integration:

   • The festival relied heavily on the Ferve API for ticketing and event management.

   • There was a need to integrate this API with Salesforce to ensure real-time synchronization of Contacts, Accounts, Opportunities, and Opportunity Line Items.

3. Reporting and Analysis:

   • The organization required robust reporting and dashboard capabilities to monitor ticket sales, customer engagement, and event performance.

Solution:

Data Migration

We undertook a comprehensive data migration project to transfer approximately 10 million records into Salesforce. The process included:

• Data Cleansing: Ensuring data accuracy and removing duplicates.

• Data Mapping: Mapping legacy data fields to Salesforce fields to maintain data integrity.

• Data Import: Using Salesforce Data Loader and other ETL tools to import data efficiently into Salesforce.

API Integration

To integrate the Ferve API with Salesforce, we implemented a solution to sync essential data entities such as Contacts, Accounts, Opportunities, and Opportunity Line Items. This involved:

• Custom Development: Creating custom objects and fields in Salesforce to accommodate data from the Ferve API.

• API Integration: Developing middleware to facilitate seamless data exchange between the Ferve API and Salesforce.

• Real-Time Sync: Ensuring real-time synchronization to keep Salesforce data up-to-date with the latest information from the Ferve ticketing system.

Reports & Dashboards:

We created customized reports and dashboards to provide actionable insights into various aspects of the festival’s operations. These included:

• Ticket Sales Reports: Tracking sales performance, revenue generation, and sales trends.

• Customer Engagement Dashboards: Monitoring customer interactions and engagement levels.

• Event Performance Reports: Analyzing the success of individual events and overall festival performance.

Results

• Enhanced Data Management: Migrating 10 million records into Salesforce provided the Sydney Film Festival with a centralized and accessible data repository.

• Seamless Integration: The integration of the Ferve API with Salesforce ensured real-time data synchronization, leading to improved operational efficiency and data accuracy.

• Improved Reporting: The implementation of tailored reports and dashboards enabled the festival to make data-driven decisions, enhancing their ability to manage ticket sales, customer relationships, and event planning effectively.

Conclusion

The successful migration of historical data and integration of the Ferve API with Salesforce has significantly improved the Sydney Film Festival's data management capabilities. The organization now benefits from a unified platform that supports their operational needs, enhances customer engagement, and provides valuable insights through robust reporting and dashboards.

By leveraging Salesforce, the Sydney Film Festival is well-equipped to manage its growing data needs and deliver exceptional experiences to its patrons, ensuring the festival's continued success and growth in the years to come.