Solutions designed with your goals in mind

Fair Needed One Clear Answer: Which Claims Are Actually Worth Pursuing

16 dbt models

Powering claim, loan, and value reporting

3 stages

Claim, loan, and value scoring

2 platforms

Ad spend tied to claim outcomes
"A claims business runs on one question: is this claim actually going to pay out? That answer does not live in any single system. It lies in the connection among the claim, the loan match, and the rules that determine whether it qualifies. Building that connection was the whole job."

At a glance

  • Claims, loans, risk, and marketing data unified into one warehouse, replacing manual reconstruction of every claim's status
  • A single, consistent rulebook for what counts as a "qualified" loan, applied the same way every time
  • Facebook and TikTok spend connected directly to which claims actually convert and qualify

Fair helps people pursue compensation for mis-sold car finance. Every claim moves through the same journey: someone submits a claim, their identity and credit history get checked, their old finance agreements get matched, and those matched loans either qualify for compensation or they don't, depending on the lender and when the loan was taken out.

The problem was not that Fair lacked data. The problem was that the data lived inside a system built for running the product, not for answering business questions. A claim's real status, how many loans were matched to it, and whether those loans actually qualified existed buried inside raw records that changed shape from one claim to the next. Answering a simple question like "how many of this month's claims are actually going to pay out" meant someone manually piecing it together by hand.

The Problem With Not Knowing Which Claims Will Actually Pay

As claim volume grew, so did the cost of not having a fast answer to a few core questions: where are claimants dropping off before they finish, how many loan matches and credit checks belong to each claim, which of those matched loans actually qualify once the real lender and date rules are applied, and is marketing spend bringing in claims that convert or just clicks that don't.

These are not exotic questions. Any claims business at scale needs to answer them daily. But when the underlying claim and loan data lives in a format built for the product rather than for reporting, every one of these questions turns into a manual investigation instead of a number someone can just look up.

Every system Fair relied on, connected into one warehouse:

Domain Sources What we track
Claims and Loans MongoDB(claims, loans, credit pull data) Claim progress, matched loans, credit history checks
Risk Kount Fraud and risk signals per claim
Claims Operations Zoho Claim stage and commission tracking
Marketing Facebook, TikTok Ad spend, clicks, and which claims they actually produced

The data existed everywhere. It just wasn't built to answer business questions in its raw form, so every report meant rebuilding the picture by hand, and no two people rebuilding it got the same answer.

Why the Standard Answer Did Not Fit?

The instinctive move is to hire a data engineer to pull the raw claim and loan records into a report and call it done. That works if the data is simple. It doesn't work when the real business logic, which lenders count, which dates qualify, what a completed identity check actually means, has to be applied the exact same way every single time, or the numbers quietly stop matching each other.

Fair didn't need someone manually reconciling claim data on request. It needed one system that decided, once, what "qualified" means and applied that same definition everywhere, so operations, underwriting, and growth were always looking at the same answer.

What Vero Built?

The approach ran on one rule: raw claim and loan data gets cleaned and standardized first, and every business decision, qualification, risk, claim value, gets built on top of that same clean foundation, never recalculated from scratch each time.

  • Every source, claims, loans, credit checks, fraud signals, claims operations data, and ad spend, now flows automatically into one central warehouse, so nobody is pulling exports by hand
  • Messy, inconsistent claim and loan records get standardized into one clean, consistent shape before any business question gets asked of them
  • The real business rules, which lenders qualify, which dates count, what a completed identity check looks like, are encoded once and applied the same way to every claim, every time
  • Each claim gets an expected value score based on lender, verification status, and how far it has progressed, so the team knows which claims are worth prioritizing before month end
  • Facebook and TikTok spend now traces directly to which claims those campaigns actually produced and whether those claims signed and qualified
  • Live dashboards give operations, case management, and growth their own view, all pulling from the same trusted numbers

Every answer to "is this claim going to pay out" now comes from one place, not from whoever rebuilt the spreadsheet that week.

How the Build Came Together

The work moved in two phases

Phase 1: Getting the foundation right. Every source of claim and loan data, along with risk, claims operations, and marketing data, got connected into one warehouse and cleaned into a consistent shape. This is the unglamorous part that most builds skip, and skipping it is exactly why the numbers stop matching later.

Phase 2: Making the data answer real business questions. With clean data in place, the team built the actual decision layer: which loans qualify, what a claim is worth, which marketing channels produce claims that convert. Dashboards went live on top of that layer for three audiences: day-to-day operations, case quality and prioritization, and growth.

What Changed for the Team

Before, knowing a claim's real status, how many loans matched it, and whether those loans actually qualified meant manually reconstructing it from raw records every time someone asked. Marketing spend and claim outcomes lived in separate systems with no way to connect them.

  • Claim progress, credit checks, and identity verification status are now visible in one place, instead of being manually pieced together
  • Which loans qualify for compensation, and under which lender and date rules, is now applied consistently instead of re-decided by whoever is looking
  • Every claim carries an expected value score, so the team can prioritize the claims most likely to actually pay out
  • Facebook and TikTok spend now shows exactly which claims it produced and whether those claims converted, not just clicks and impressions

Nobody on the team is reconstructing a claim's story from raw records anymore. The system does that once, and everyone works from the same answer.

How the Data Moves

How the Data Moves

Layer Tools
Ingestion AWS Lambda (MongoDB, Zoho API), Fivetran (ad platforms)
Warehouse Amazon Redshift (raw, staging, mart schemas)
Transformation dbt Cloud
Orchestration dbt Cloud scheduler, daily jobs
Risk and Fraud Kount signals, stored in MongoDB
Claims Operations Zoho
Marketing Facebook Ads, TikTok Ads
Dashboards Preset
Solutions designed with your goals in mind
Company Overview
A UK Claims Management Company helping consumers claim compensation on mis-sold PCP and HP car finance agreements from 2007 to 2024, guiding each claim from first submission to a signed, qualified payout.
Arrow to the top of the page button