Case study · Retail

Our Taap: from manual reporting to a data-driven business.

Our Taap sells premium water-purifier taps to UK households on subscription. Fifty One Degrees started with a two-week credit strategy sprint, then embedded a data scientist to build the data platform the business runs on: a governed warehouse, marketing attribution across 98% of acquisition spend, and automated revenue recognition that reconciles exactly to finance.

Our Taap case study
51.4°N · 0.1°W
Client
Our Taap
Sector
Consumer subscription (water purification)
What we built
Credit strategy, data warehouse, attribution
Stack
BigQuery, Fivetran, dbt, Looker, Claude
Headline result
98% of acquisition spend now attributed
The challenge

A subscription business flying on manual reporting

Our Taap installs premium water-purifier taps in UK homes on a monthly subscription, with credit-checked applications behind every order. The business was growing, but its numbers lived in disconnected systems: Salesforce, BigCommerce, SAP, ad platforms and credit bureau data that never met in one place. Marketing performance was only visible inside one ad platform's own reporting, revenue recognition ran on a manual workbook, and credit strategy decisions lacked a single evidence base. Scaling meant fixing the foundations first.

What we built

The data platform the business now runs on

A credit strategy sprint

A two-week fixed-price sprint analysed Our Taap's own application and credit bureau data, established the real performance baseline, and mapped the commercially viable frontier between acceptance and risk, giving the business an evidence base for its credit engine and a bespoke scorecard design to build towards.

A governed data warehouse

A BigQuery warehouse unifies Salesforce, BigCommerce, GA4, Meta, TikTok, SAP, Experian credit data and public UK datasets covering 1.8 million postcodes. Fivetran handles daily ingestion, dbt runs tested transformations, and nine business-ready mart tables serve reporting across the company.

Marketing attribution that covers the spend

Acquisition spend across Facebook, TikTok and Google, about 98% of the total, is now attributed against real Salesforce orders rather than each ad platform's own conversion counts, so cost per acquisition reflects what actually happened.

Automated revenue recognition

Revenue recognition runs from the warehouse and reconciles exactly to the finance team's existing workbook, validated to the penny against a closed period before anything was switched over.

Reporting the whole business runs on

Looker dashboards and a KPI pack replace the manual reporting cycle. Leadership sees real-time numbers instead of waiting on spreadsheets, every team member works from the same evidence when making strategic decisions, and the effort of producing the numbers has largely gone.

Claude, embedded in the team

A structured Claude enablement programme is rolling out across the business: training sessions delivered, working materials for finance and marketing, and an AI policy in progress, so the team uses AI on real work rather than in theory.

How we built it

Evidence first, infrastructure second, AI third

Start where the risk is

The engagement opened with credit, the part of the business where bad decisions compound, and grounded every recommendation in Our Taap's own bureau and order data.

One source of truth

Every report and model draws from the same governed warehouse, with dbt tests and documented definitions, so marketing, finance and leadership argue about decisions, not numbers.

Validated before switchover

The automated revenue recognition was reconciled to the penny against the finance team's manual workbook for a closed period before the business relied on it.

Enable the team, not just the systems

Claude training and working materials put the new data capability in the hands of the people who use it, in finance, marketing and beyond.

How we work together

A sprint that earned a retainer

Fifty One Degrees started with a fixed-price credit strategy sprint in September 2025. On the strength of that work, Our Taap moved to an ongoing data science retainer from January 2026: an embedded Fifty One Degrees data scientist four days a week, backed by partner-level strategy and oversight.

01
Credit sprint

Two weeks, fixed price: baseline the credit engine, analyse bureau and order data, and map the viable frontier of acceptance and risk.

02
Embed

An embedded data scientist joins the team four days a week under an ongoing retainer, with senior oversight from the firm's partners.

03
Foundations

Build the governed warehouse: daily ingestion from every core system, tested transformations, business-ready marts.

04
Attribution

Connect ad spend to real orders across Facebook, TikTok and Google, covering about 98% of acquisition spend.

05
Automate

Replace manual reporting: automated revenue recognition, Looker dashboards and a KPI pack that give leadership real-time numbers with none of the manual effort.

06
Enable

Roll Claude out across the team with training, working materials and an AI policy, so the capability outlasts any single project.

Outcomes

What the platform delivers

98%
of acquisition spend attributed against real orders, across three ad platforms
8+
data sources unified in one governed BigQuery warehouse
1.8M
UK postcodes enriched with public data for targeting and analysis
What's next

From foundations to growth economics

With the warehouse live and reporting automated, the work turns to growth: sharper conversion signals back to the ad platforms, scoring leads on their likelihood to pass credit checks before spend is committed, and diversifying acquisition beyond a single channel. The foundations exist so that every one of those decisions runs on evidence.

Fifty One Degrees gives Our Taap an embedded data science capability: one partner covering credit strategy, data engineering, marketing attribution and AI enablement, so growth decisions run on evidence rather than intuition.Fifty One Degrees x Our Taap
FAQ
What did Fifty One Degrees build for Our Taap?

A credit strategy grounded in Our Taap's own bureau data, a governed BigQuery data warehouse unifying more than eight sources, marketing attribution across Facebook, TikTok and Google, automated revenue recognition that reconciles exactly to finance, and a Claude enablement programme for the team.

What results has the work delivered?

About 98% of Our Taap's acquisition spend is now attributed against real Salesforce orders rather than ad-platform conversion counts, revenue recognition is automated and validated to the penny against the finance workbook, and leadership reporting runs from one governed warehouse instead of manual spreadsheets. Leadership gets real-time numbers, the whole team makes strategic decisions from the same evidence, and the manual effort of producing the reporting has largely gone.

How does Fifty One Degrees work with Our Taap?

Embedded. After a fixed-price credit strategy sprint in September 2025, Our Taap moved to an ongoing retainer: a Fifty One Degrees data scientist works inside the team four days a week, with partner-level strategy and oversight behind them.

Why does a subscription business need a data warehouse?

Because subscription economics live or die on unit-level truth: what a customer costs to acquire, how they perform on credit, and what they are worth over time. Our Taap's numbers sat in Salesforce, BigCommerce, SAP, ad platforms and credit bureau files that never met. One governed warehouse makes those questions answerable.

Can Fifty One Degrees do this for my business?

Yes. Fifty One Degrees builds data and AI foundations around a business's real systems and decisions. Book a Discovery Call and we will find the highest-value place to start.

See all client work →
Next step

Want your growth decisions running on evidence?

Book a 30-minute Discovery Call and we'll map the data and AI foundations your business needs, from first warehouse to embedded AI.