Kids Party Entertainment AU – Data-Driven Decision Engine & Dynamic Backend System

Backend engineering for Kids Party Entertainment Australia, building a dynamic decision-making system powered by Google Sheets and Laravel-based backend logic to generate personalized entertainment recommendations based on user inputs such as age, location, budget, and group size.

Overview

This project involved building a data-driven decision engine for Kids Party Entertainment Australia, designed to dynamically generate entertainment recommendations based on structured input parameters.

Instead of static content pages, the system functions as a rule-based backend recommendation engine, where outputs are determined by combinations of user inputs such as:

• Age group
• Number of children
• Location type (home, hall, restaurant, etc.)
• Budget range

The backend processes these inputs and returns highly contextual entertainment suggestions.

🧠 System Concept

At the core of this project is a rule-matching engine powered by Google Sheets as a dynamic data source.

Example rule structure:

These rules are managed externally in Google Sheets, allowing non-technical stakeholders to update logic without deployments.

🧰 Technology Stack

• Backend: Laravel (PHP)
• Data Source: Google Sheets API (dynamic rule engine)
• Database: MySQL (fallback + caching layer)
• API Layer: RESTful JSON API
• Server: NGINX on Linux infrastructure
• Frontend Integration: JavaScript-based dynamic UI rendering
• Architecture Style: Rule-based decision system (data-driven backend)

⚙️ Key Features

🧠 Rule-Based Recommendation Engine

Built a flexible backend system that evaluates multiple input conditions and returns matched results based on structured rules stored in Google Sheets.

📊 Google Sheets as CMS for Logic

Instead of hardcoding business logic, decision rules are managed via Google Sheets, enabling:

• Real-time updates without deployments
• Non-developer control over logic
• Scalable rule expansion

🔄 Multi-Dimensional Filtering System

The engine evaluates multiple parameters simultaneously:

• Age group matching
• Group size segmentation
• Venue context awareness
• Budget threshold logic

This enables highly personalized output generation.

⚡ Dynamic Output Generation

The system returns structured responses such as:

• Entertainment suggestions
• DIY activity recommendations
• Equipment hire options
• Package-based suggestions

All generated dynamically from rule combinations.

🏗 Architecture Design

The system follows a layered architecture:

• UI Layer → User input collection (web form / frontend)
• API Layer → Laravel backend processing engine
• Rule Engine Layer → Google Sheets-based decision matrix
• Cache Layer → MySQL for performance optimization
• Response Layer → JSON output consumed by frontend

🚧 Challenges & Solutions

📉 Complex Conditional Logic

Managing multiple overlapping conditions (age, budget, location, etc.) became complex.

Solution: Designed a structured rule-matching system instead of hardcoded condition trees.

🔄 Non-Technical Content Updates

Business users needed to update logic frequently.

Solution: Integrated Google Sheets as a live rule editor.

⚡ Performance Optimization

Repeated API calls to Google Sheets introduced latency.

Solution: Added caching layer and reduced redundant API requests via backend optimization.

📌 Outcome

The final system successfully transformed a static content structure into a dynamic decision engine, allowing personalized entertainment recommendations to be generated in real time based on user input combinations.

This significantly improved flexibility, scalability, and business control over content logic.

💬 Note

This project demonstrates backend engineering beyond traditional CRUD systems — focusing on rule-based architectures, externalized logic systems, and dynamic content generation pipelines.

🔗 Project

• Website: https://kidspartyentertainment.com.au/