170 likes | 253 Views
Mauckingbird Theatre Company. Sophia Bartolini , Caroline Bauer, Tara Donovan, Courtney Herring, Sean McCarthy, Ashley Peraino. Mauckingbird Theatre Company. Theatre located in Philadelphia
E N D
Mauckingbird Theatre Company Sophia Bartolini, Caroline Bauer, Tara Donovan, Courtney Herring, Sean McCarthy, Ashley Peraino
Mauckingbird Theatre Company • Theatre located in Philadelphia “Founded by Reynolds and Mauck, Mauckingbird Theatre Company is committed to producing professional gay-themed theatre, while also exploring classic literature and musical genres and providing affordable productions of infrequently produced works.”
Analysis Approach • Met with Lindsay Mauck to understand current system and to determine client objectives • Involved Lindsay in the process • Project Contract • Frequent updates • Developed user manual for new system • Demonstrated Salesforce tools and capabilities live with Lindsay • Kept up with documentation
Maukingbird’s Current System • Ticket Sales • Online using Tix • Box Office • Phone reservations • Google Docs to track tickets • Contacts • Stored in Excel and on paper • No comprehensive database with all contacts in one place
Mauckingbird’s Wishlist • Ticket Sales: • Track and manage tickets through database • Centralize patron information in database • Contact info • Plays attended and how many • Donation Tracking and Management • Grant/Development Tracking • New Play Submission Tracking
Salesforce System Advantages • Stores currently dispersed contact information of patrons and employees into a centralized database • Reduces the time required to find patron contact information • Easy integration of external applications • Brown Paper Tickets • Provides a record of patron attendance history and donations
Demonstration of Mauckingbird Theatre Salesforce System • www.salesforce.com
Entity Relationship Diagram Leads Lead List Shows Contact List 0 Accounts Contacts Donations
System Context Diagram Client (Door sales/ event setup) Client Leads Contacts Contacts Leads Donations Lead Donations Attendance Reports Campaign Patrons (Online Ticket Orders) Brown Paper Tickets Lead Salesforce Lead
Mauckingbird Theatre Co. Salesforce Data Flow Diagram 1 2 3 Add New Contacts Record Donations Import Brown Paper Tickets Information
1. Add New Contacts 1.1 EE1.1 Data Flow Diagram (cont’d) New Contact Calls/emails Mauckingbird Record Contact Info Contact Master EE1.2 User Converts Lead to Contact
3. Importing Brown Paper Tickets Information Data Flow Diagram (cont’d) EE3 3.1 Brown Paper Tickets Leads Master User initiates Brown Paper Tickets-Salesforce Sync Leads & Show Information imported into Salesforce Brown Paper Tickets Show Master 3.2 Leads Master Write to Campaign and Leads Campaign Master
2. Record Donations Data Flow Diagram (cont’d) 2.1 EE2 Donation is mailed to Mauckingbird Verify if donor exists as contact Contact Master No Yes 1.1 Recurring Donation & Pledge Master Record Contact Info 2.2 Record donation & pledge terms
Opportunities for enhancement • Track and manage grants • Track new submissions for play manuscripts • Add a portal on Mauckingbird’s website for purchasing tickets and patron donations