Case Background:

In this case study, we have shared highlights of our data visualization project for VohraWoundCare.com

A key objective of VohraWoundCare.com is to receive job applications for the hiring of wound care physicians.

Upon receiving the job applications the recruitment process is handled offline. The entire recruitment process is managed in Lever – lead management system

The organization promotes job openings across multiple job boards. The organization also runs various paid campaigns to generate job applications.

Business Challenges 

The organization needed a system to aggregate the data from various platforms to analyze the performance of the digital efforts.

The organization had 4 different data sources which need to be aggregated:

Google Analytics
Google Analytics includes features that can help users identify trends and patterns in how visitors engage with their websites. Features enable data collection, analysis, monitoring, visualization, reporting and integration with other applications.
Lever
Lever is a top-rated recruiting software that helps talent teams scale recruitment efforts and hire people faster. Lever's real-time apps, easy-to-use interfaces, and applicant tracking system are designed to streamline and simplify hiring processes, enabling employers to focus more on selecting the best candidates.
Digital Marketing platforms
These platforms are used to reach out customers with increasingly conversion-oriented messages across multiple channels as they move down the sales funnel. Ideally, marketing teams will be able to track the role each of these messages and/or channels plays in reaching their ultimate goal.
Job boards spend
A job board is a website that connects job candidates and recruiters. It's a single platform where recruiters and job seekers can both post and search for fresh job openings.

Solution:

Team DataVinci worked with the APIS of Application portal, Lever & Job boards to get all the data into Google Sheets.

To get marketing data, SuperMetrics was utilized. Analytics data was brought in using Google Analytics add-on for Google Sheets.
Applications data contains the marketing channel through which each application was submitted. Data from Applications & Lever was aggregated using the e-mail ID of the users. This stage enables businesses to analyse how the applications are progressing with each marketing effort.
Data from job boards & Lever was aggregated using the e-mail ID of the users. This stage enables business to analyse how the applications are progressing with each job board The cost associated with each stage conversion was also enabled
Data from applications & marketing was aggregated using the e-mail ID of the users. This stage enables business to attribute cost with each application The business was also able to find the effectiveness of various campaigns and calculate ROI
To get marketing data, SuperMetrics was utilized. Analytics data was brought in using Google Analytics add-on for Google Sheets.
User ID view was enabled in Google Analytics Encrypted email Id was utilized as User ID. This aggregation enabled the analysis of user behaviour on the website to discover frictions and drive experiments to optimize the journey.

Final Output:

An automated dashboard with over 31 pages of powerful insights

Impact:

With this project an automated centralized cloud based MIS system free of manual errors was delivered to aggregate data from various data sources.

Here are some key numbers :

240

Saved Hours

33,600

Saved In USD every month

We hope you found this case useful. If you want to discuss any Analytics or CRO project with us, you can use the link below :

Discuss A Project