Case Study

Case study scenarios from previous clients demonstrating how they’ve used my virtual assistant services. Hopefully you will find some inspiration here.

Case Study #1: Data Entry

L had several binders containing signup sheets with contact details of people who’d attended his events or used his services. He wanted them collated so he could add them to his CRM and mailing list.  After discussing his needs, we decided on an Excel file which he could easily import into a variety of programs either as an Excel file, or as a CSV file. 

The data entry included Names, Telephone Numbers (both landline & mobile), Email Addresses, Websites and Postal Addresses including Street, Suburb, State and Postcode.  Most of this information was on the sheet. Sometimes, I needed to do some additional research to locate the suburb and postcode information when only the street address had been supplied.

We stored the file in a Dropbox folder for ease of access. And within a couple of days, the data entry was completed.  At that point, L had an accurate list he could easily import into any system he needed to, and by storing it in Dropbox we could both work on it whenever necessary and if there were any problems or corruption of the file we could revert to an earlier version.

All up it took around 1-2 hours of work per 100 records, which included combining multiple entries for the same person to get as many details as possible, typing, checking Suburbs & Postcodes where necessary and quality checking.

#2: Email

A runs a global niche directory and membership site and needed someone to help with new memberships and to follow up with people who submit a membership request but don’t complete the process. 

We created an email address which all membership emails would be sent to, as well as payment notifications from PayPal.  We both receive the emails, and I, add them to our membership list, check whether the membership fee has been paid,  send them a welcome email and add them to our Membership mailing list.  I also keep track of incomplete applications and follow up after several days.  Other things I do include invoicing, chasing up website addresses and troubleshooting technical problems with information supplied by our clients, occasionally making minor edits to images,  proofreading the monthly email newsletter

Case Study - Sharyn Munro Virtual Assistance

Case Study #3: Document Formatting

Company C had recently changed their name and corporate branding.  As a result they had around 300 documents ranging from 1 to 40 pages long all needing to be changed to display the new logo; new fonts; styles; and have new headers and footers applied. I also had to check for mentions of the previous company name within the documents and change it to the new company name.

#4: General Administration

K owns two businesses, a restaurant in one town and a function venue in another city a short distance away.  She needed help keeping on top of all the administration and getting both venues organised.  Our first priority was finding a solution to telephone calls going unanswered in the function centre. Although I don’t provide a phone answering service, I got quotes in from several other Virtual Assistants who do. I summarized the proposals and gave my client a rundown on what was covered in each proposal.  Once she’d chosen a VA, I managed the process and was a trouble-shooter for problems on either side.

Other issues she faced which I was able to help with were: invoicing and back account reconciliation; staff recruitment; developing a procedure manual; creating feedback surveys; creating and updating a Facebook page; sourcing accommodation for interstate trips; sourcing content and photos to create a monthly newsletter; as well as other general administrative tasks.

Case Study #5: Typing

J had written out his family history and wanted it typed up so he could send it to his family. Hhe had over 100 pages of handwritten text which he’d produced over a several years. In a little over 10 hours I typed up the notes. Then I submitted them to him for review and made the few corrections necessary. Finally, he received a copy in both PDF and Word on CD and via Email.