Client Success
Obagi Medical
Obagi Medical is a specialty pharmaceutical company that develops, markets and sells, and is the leading provider of proprietary topical aesthetic and therapeutic clinically-proven skin care systems in the physician-dispensed market. The systems are designed to prevent and improve the most common and visible skin disorders. The company retained us to build an robust ROI calculator for one of their proprietary skincare systems.
Want to see how we can get your team similar results?
Client Success
Then Just Click The “Apply Now” Button Below And If We Are A Good Fit, A Member Of Our Team Will Reach Out To Setup A Discovery Call
4
Product ROI Calculators Built
100%
12.6x
About
The Client
Obagi Medical is a specialty pharmaceutical company that develops, markets and sells, and is the leading provider of proprietary topical aesthetic and therapeutic clinically-proven skin care systems in the physician-dispensed market. The client retained us to build a robust calculator for one of their proprietary skincare systems to help calculate the ROI based on the following calculations:
- Net Revenue From Treatments
- Feed Optimization
- Health Performance
- ROI Based On Day, Week, Month, and Year
- Calculators Built For Stores and Distributors
- Embed VBA to easily export the reports via PDF
Key Strategies
implemented
1
The main strategy here was to get a clear understanding of all the costs associated with the clients products and services.
2
From here, we worked closely with the marketing and sales team to understand product costs, service costs, average units sold by location, etc.
3
Once learning the insights required, we used advanced data modeling techniques to build a dynamic calculator.
4
The next step was to work with their design team to help create a well designed one page Excel sheet that could be easily saved as a PDF.
5
The last step was to use VBA to allow the sales team to easily click a button to export the file as a PDF that they could easily email the results to potential clients.
