Client
US based eCommerce (Amazon Seller)
Date
Feb 01, 2026
Services
Google BigQuery, Metabase, dbt
Our Role
Data Cloud Storage, Data Engineer, Business Intelligence Developer, Metabase Developer
Highlights
- Tracked gross profit, net profit, and margin % to measure overall business profitability
- Analyzed profit performance by brand and region to identify high-margin segments
- Provided detailed product-level profitability including revenue, COGS, and all Amazon fees
- Compared gross profit vs net profit to evaluate true earnings after operational costs
- Delivered clear visibility into cost structure to support pricing and profit optimization
KPIs & Metrics Tracked
- Gross Profit
- Net Profit
- Gross Margin %
- Net Margin %
- Cost of Goods Sold (COGS)
- Total Amazon Fees