Migrating off Daasity to an owned data stack

We migrated First Day off Daasity, their all-in-one platform, to an owned data stack — unifying every source, including the ones with no easy way to get the data out.

First Day Retail & EcommerceHealth & wellnessSubscription heavy

Great partner that can help you achieve your goals while understanding the business, tech and need for agility

Yoed Negri
Yoed NegriVP AI, Data & Technology, First Day
Migrating off Daasity to an owned data stack
Results in numbers
24Data sources unified

Marketplaces, logistics, ads, email, SMS and support in one warehouse.

10Custom integrations built

Retail partners, logistics, OMS, subscriptions and ad platforms — all with no managed connector.

$108KSaved on ETL costs

Per year, from our optimization and sync strategies.

The problem

An all-in-one platform that couldn't keep up

Missing connectors. Inaccurate data. Slow dashboards. No real ownership of their own data. First Day had outgrown Daasity — hitting every one of the typical issues brands run into with all-in-one platforms once they reach a certain stage.

The challenges

Preserving every bit of historical data through the move — even though it was never truly theirs to own, and much of it sat behind strict API limits.

The sheer number of connectors to unify — order management, logistics, marketplaces, ads, email, SMS and support — many with no managed connector and no easy way to get the data out.

Wrangling notoriously messy marketplace data from Amazon Seller and Target.

Some sources were very expensive to sync at scale.

The solution

We became First Day's external data team and migrated them off Daasity, replacing the all-in-one platform with an owned analytics stack — piping every platform into BigQuery, building custom integrations for the sources no one else could reach, and turning it all into dashboards the whole team could trust, without a long, disruptive migration.

01

Centralized warehouse

We piped every First Day platform — marketplaces, ads, email, SMS, support and logistics — into a single BigQuery warehouse via Fivetran.

02

Custom integrations

For platforms with no managed connector, we built custom Fivetran Connector SDK integrations — Jazz OMS (logistics), Vibe CTV, Northbeam and Stay AI — handling async APIs, bot protection and deep pagination.

03

Taming marketplace data

We modeled the notoriously messy Amazon Seller and Target data into clean, reconciled orders, refunds and settlements.

04

Cost-efficient syncs

For the sources that were expensive to sync, we found creative ways to move the data — tuning sync frequency, scope and strategy — to keep First Day's costs down without sacrificing freshness.

05

Modeling & metrics

We modeled the raw feeds into the numbers the team runs on — net sales, margin, retention and channel performance — defined once and trusted everywhere.

06

Dashboards & insights

We built automated dashboards and act as their embedded analyst team, surfacing the decisions that matter.

First Day Data Architecture
Google Analytics 4Amazon SellerQuickbooksEmail, SMS & SupportPaid AdsRetail PartnersRJW LogisticsJazz OMSNorthbeamStay AIFivetranCustom APIintegrationdbtGoogleBigQueryOmniSlackSOURCESEXTRACT & LOADDATA TRANSFORMATIONDATA WAREHOUSEDATA VISUALIZATIONALERTS
Email, SMS & Support: Klaviyo, Attentive, Alia SMS, Gorgias
Paid Ads: Google Ads, Meta Ads, Microsoft Ads, TikTok Ads, Snapchat Ads, Reddit Ads, Amazon Ads, AppLovin, Vibe
Retail Partners: Target, Walmart, Meijer, Vitamin Shoppe
The impact

First Day now runs on a single source of truth that spans every channel — including the marketplace and logistics data that used to be out of reach — on a stack they own and can extend as they grow.

Have a project in mind?

Let's talk

Book a free 30-minute consultation to discuss your current challenges, explore where you'd like to be in 6 months, and see if we're the right fit.

Book a free consultation