We are a travel company with our own custom-built registration system. It's a MySQL database with a Laravel/PHP front-end, where customer bookings are made, kept, and updated by customers and/or company staff.
The customer-facing side of the registration system is at bookings.chooseachallenge.com
Project Aim To integrate the Reg System database with the CRM platform Brevo (formerly sendinblue) so that user records in the Reg system are reflected in real-time in Brevo.
Project Objectives
To ensure that the attributes in the reg system customer (pax) booking records have corresponding attributes in Brevo. To set up the integration so that any verified user (one who has verified their email address after receiving the confirmation email) appears in Brevo with the correct status e.g. ‘Incomplete’ if they have not yet registered. Their status in Brevo must be updated as soon as it updates in the registration system. The code is stable and continues to operate correctly for the long term The code should be hosted on our Google Cloud account Some attributes such as CONTACT_TYPE will not have a contact-specific field but will instead need to be pulled from the information for the event with which the pax is associated
Project Tasks
Produce a definitive list of attributes (i.e. fields) required in Brevo for that platform to effectively mirror the participant records in the reg system database (Reg Brevo Integration Attributes.xlsx). Note: The list must cover all fields that could be used as part of marketing, sales, cx and ops activities. Define attributes in Brevo to match the definitive list. Remove all attributes not used. Create Brevo list ‘Current Active Pax’ in the Operations folder. This list should contain records of all pax with a future trip date. Note: Need to work out which statuses should be included on here Add field to event set-up with Event status close schedule. Create ‘Past Pax’ list on Brevo. Code should move pax from ‘Current Active Pax’ to ‘Past Pax’ once event status is changed to closed.This List should contain records of all pax with a past trip date. Create custom code to sync reg system users (except admin users) to correct Brevo Lists when user record is created (starts with incomplete registration) and updates immediately if any defined attribute changes. Create log to help enable future debugging
Moderate-Detail 3D Rendering -- 2 Category: 3D Animation, 3D Design, 3D Modelling, 3D Rendering, 3ds Max, Blender, Cinema 4D, Maya Budget: min $50 USD
18-Oct-2025 22:00 GMT
Luxurious Dual Logo & Brandboard Category: Adobe Illustrator, Photoshop, Branding, Design Thinking, Digital Design, Graphic Design, Logo Design, Packaging Design, Print Design, Typography Budget: $30 - $250 USD
18-Oct-2025 21:57 GMT
Gestão Contínua de Facebook Category: Analytics, Article Writing, Content Creation, Digital Marketing, Facebook Marketing, Internet Marketing, Social Media Management, Social Media Marketing Budget: $15 - $25 USD
18-Oct-2025 21:57 GMT
3D HEY SHOP Logo Recreation Category: 2D Drawing, 2D Layout, 3D Animation, 3D Modelling, Adobe Illustrator, Branding, Graphic Design, Logo Design, Vector Design Budget: $10 - $30 USD
18-Oct-2025 21:54 GMT
Android App Play Store Launch Category: Android, Android App Development, Graphic Design, Java, Marketing Strategy, Mobile App Development, Software Architecture Budget: €250 - €750 EUR
18-Oct-2025 21:53 GMT
Custom Mobile App Development Category: Android, Android App Development, Android SDK, Flutter, IOS Development, IPhone, Mobile App Development, React Native, Transcription, User Interface / IA Budget: $30 - $250 AUD
18-Oct-2025 21:53 GMT
Podcast Social Media Growth Manager Category: Content Creation, Content Marketing, Content Writing, Facebook Ads, Facebook Marketing, Graphic Design, Social Media Management, Social Media Marketing Budget: $30 - $250 USD
Google Ads Tracking & Optimization Category: Advertising, Conversion Rate Optimization, Digital Marketing, Google Ads, Internet Marketing, Link Building, Search Engine Marketing (SEM), SEO Budget: €30 - €250 EUR
18-Oct-2025 21:44 GMT
Campañas TikTok Ads y Pixel Category: Advertising, Conversion Rate Optimization, Digital Marketing, Google Adwords, Graphic Design, Photoshop, Social Media Marketing, Web Design Budget: $10 - $30 USD
18-Oct-2025 21:44 GMT
Campaña Marketing para Gimnasio Category: Content Creation, Digital Marketing, Email Marketing, Internet Marketing, Marketing, SEO, Social Media Marketing, Spanish Translator Budget: €250 - €750 EUR
Two-Family Village Floor Plan Category: 2D Drafting, 2D Layout, Architecture, AutoCAD, Building Architecture, CAD / CAM, Drafting, SketchUp Budget: ₹600 - ₹1500 INR
18-Oct-2025 21:34 GMT
Daily social Media management needed Category: Facebook Marketing, Google Plus, Social Media Marketing, Social Networking, Twitter Budget: $8 - $15 USD