Hi HN,
Here is the open source repo of the data pipelines built in dbt to model profitability at the level of an order.<p>Covers sources like: Shopify, Facebook Ads, Fedex, Paypal, Manufacturing Costs, VAT etc.<p>Benefits for ecomm - Precise Granular Revenue and Profit analysis at the level of orders. - Template to automate Profits calculation saving you 100s hours of manual work in Excel or GSheet. - Increase ROI on Paid Marketing: By understanding hidden costs like VAT and shipping, you can make smarter decisions on ad spend across different countries.<p>Hope this is useful!