From Manual CSV Hell to Real-Time Results: Solving the "Registration Crisis" for a Leading UK Literacy Charity
For many Charities and non-profits, the success of a high-profile "Live Event" is often overshadowed by the "Data Hangover" that follows.
Zon Projects recently partnered with a prominent UK literacy charity that facilitates live storytelling events between famous authors and schools. Before our intervention, the team was trapped in a common cycle: hosting brilliant events via Zoom, then spending countless "man-hours" manually cleaning, matching, and uploading CSV files into Salesforce.
It was a tedious game of detective work—trying to figure out which "Teacher Smith" on the spreadsheet matched the "Sarah Smith" already in their database.
The Problem: The "Post-Event" Data Struggle
The native Zoom-to-Salesforce integration simply couldn't handle the nuances of the charity’s data. The result was a recurring administrative nightmare:
Duplicate Bloat: Multiple records for the same schools and teachers cluttered the CRM.
Lost Time: Staff spent days on manual matching instead of mission-critical outreach.
Data Integrity Issues: Manual uploads often led to "broken" relational data, making it hard to track a school's long-term engagement.
The Zon Solution: Real-Time Verification
We didn't just build a form; we built a Guided Registration Journey. By moving the logic into a custom Apex Controller on a Public Sites page, we shifted the data matching to the very start of the process.
The "Find or Create" Workflow:
School Search: Instead of typing a name (and making typos), users use a "Find" button to match their school directly to an existing Account record.
Contact Matching: We use an email-match logic to identify their Contact record in real-time.
Smart Creation: If no match is found, the system presents a "Create" function with strict validation, ensuring that any new data captured is "clean" from the moment it hits Salesforce.
Automatic Association: By passing the Campaign ID through the URL, the system instantly links the registrant to the correct event as a Campaign Member.
The ROI: Saving Hours, Not Just Minutes
By capturing the registration at the source, we eliminated the need for manual uploads entirely. The "nightmare" of post-event matching has been replaced by a system that does the heavy lifting in milliseconds.
For our client, this means their data is always live, always clean, and their team is finally free to focus on their mission—bringing stories to children—rather than fixing spreadsheets.