The brokerage required a seamless, real-time connection between the public-facing search portal and the internal Salesforce environment. Agents needed immediate visibility into client behaviors—such as property views, budget adjustments, and login frequency—to provide timely service, while the marketing team needed an automated way to push agent bios and testimonials to the web without manual coding. The primary challenge was maintaining data integrity across both platforms without the lag of traditional batch processing or the overhead of complex, rigid API integrations that are difficult to update as business requirements evolve.

We architected an event-driven integration framework leveraging Platform Events to facilitate an asynchronous, "publish-and-subscribe" relationship between Salesforce and the website. This solution allows Salesforce to act as the single source of truth for agent profiles (originally User-based, later migrated to the custom People Object), client activity and client testimonials. By utilizing the Salesforce API to digest incoming payloads from the site, we created a "Bi-Sync" ecosystem that captures granular website insights and translates them into actionable data. This architecture is highly extensible; as new business needs arise, I can simply update the Platform Event schema to include new data points without disrupting the existing integration. Key technical milestones included the development of a "Review-to-Web" pipeline that automates the display of agent testimonials, a Web-to-Lead Behavioral Engine that captures granular listing views, area of interest and budget data, and a seamless Object Migration that transitioned agent profile data from the standard User object to a custom People record without disrupting the live site.