dataeffet
dataeffet
← Back to All Brand Case Studies
Dataeffet OS
8-Figure Hardware$18.4M Annual Run Rate•140+ Active SKUs (US & DE)

How an 8-Figure Power Tool Brand Recovered $340,000/Year in Unreconciled FBA Fees & PPC Waste

Aegis Craft Tools was bleeding $28,000/month across hidden FBA fulfillment dimension shifts and "vampire" search terms. By deploying Dataeffet OS into their own BigQuery warehouse, they automated daily SKU-level P&L and eliminated 20+ hours of weekly spreadsheet accounting.

Annual Net Margin Recovered
+$340,000
Vampire PPC Spend Eliminated
-38.4%
True TACoS Achieved
11.8%
Excel Macros Used
0 (Zero)
The Accounting & Pipeline Flaw

Why Spreadsheets and SaaS Failed Aegis Craft Tools

Standard Seller Central CSV exports could not match ocean freight container invoices to individual ASIN sales, causing Aegis to overspend on PPC for SKUs that were already net-negative after storage fees.

Consequence: Leadership was operating with blind unit economics, paying unnecessary aged inventory fees while running unprofitable PPC campaigns.
Sovereign Medallion Architecture

How the OS Resolved Unit Economics

4-Tier Medallion pipeline (Bronze to Diamond) with separated dbt Silver models that automatically reconcile SP-API ProductFees ledgers against landed container freight quotes.

Result: Client-owned BigQuery warehouse providing automated, deterministic daily net margins and True TACoS without macros.

Pipeline Architecture & SQL Teardown

Aegis OS • dbt Silver Fee Reconciliation View
// Step 1: dbt Silver Transformation Model (Automated Daily Schedule)

SELECT asin, SUM(fba_fee_variance_usd) FROM silver_amazon.reconciled_cogs GROUP BY 1 HAVING SUM(fba_fee_variance_usd) > 500;

-- Output guarantees zero unmapped SP-API transactions
-- Automatically allocates landed ocean freight & 3PL prep costs per ASIN
01. Bronze LayerRaw JSON ledgers ingested from Selling Partner API & Ads API.
02. Silver & Gold Layersdbt models clean data and hardcode landed freight and PPC waste rules.
03. Diamond LayerExecutive AI query engine accessible via natural language terminal.

Build Your Brand's Sovereign
Medallion Data Infrastructure.

Deploy the same 4-Tier Medallion pipeline used by Aegis Craft Tools. Regain absolute control over your Amazon SKU unit economics today.

Select SaaS Tier ($299/mo+) →Run ASIN Audit