70% Reduction in Data Ingestion – Lovys

Before:

Lovys’ Data Infrastructure and Governance Hiccups

As a digital native company, data was at the heart of Lovys’ architecture. They approached Spaulding Ridge to help them overcome three main challenges. The first: improve processes to allow their infrastructure to scale and match the fast-growing analytics needs of the business. This stemmed from the need to enable data consumption, storage, and sharing to make informed decisions and understand the impact of their decisions. The second: reduce the high costs being generated from their data extraction and warehousing tools. The third: guarantee a certain level of governance over metric definitions to ensure reliability while reporting on key performance indicators (KPI) for the business.

Solution:

Implementing A Data Flow to Streamline Processes Across Teams

Spaulding Ridge worked as an extended data team to support key use cases such as Marketing, Insurance (Operations) and Finance by leveraging Looker, Big Query, dbt, Airflow, Fivetran, and Hevo. With this advancement, the company unlocked new analytics capabilities.

Spaulding Ridge developed a streamlined process to standardize the structure of Excel files submitted by the finance team, replacing time-consuming manual ingestion and transformation with an automated script, simplifying a task that previously would have sat in the data team’s backlog for over a day.

The insurance team had to send crucial incident information to the Association for Management of Insurance Risk Information (Agira), a professional insurance body, a task that previously was executed manually every two days. Using Looker’s APl, the insurance team now seamlessly delivers up-to-date insurance policy data at near real time directly to the Agira database.

Lastly, the different channel leads from the marketing department would often arrive with different versions of the same KPI for department meetings. Now, thanks to centralized definitions, clear version control and ownership in Looker, the team not only has a single source of truth but can also answer more complex questions that previously went unanswered. For example, they now have a global vision on the total cost of acquisition of a new client (CAC) from the different channels and can calculate the Marketing ROI by combining CAC with lifetime value, delivering insights and control over business operations.