Two scheduled file imports put profit by day and profit by SKU next to the ad spend you already report on.
Overview
Profitscaler is not where you build custom reports. Whatever you already report in should carry profit too, sitting beside the spend, so nobody has to hold two numbers from two tools in their head and hope they were calculated the same way.
How it works
Two read-only CSV endpoints per store. One is a row per day — orders, revenue, net revenue, cost of goods, kickback, shipping, fees, profit. The other is a row per SKU per day, with quantity, net revenue, allocated costs and GP2. The two reconcile exactly: the sum of GP2 for a day equals that day's profit, because order totals are derived from the lines rather than calculated separately. Each store has its own report key, which you can rotate without touching your container.
How to configure
In Funnel, add a File import data source.
Paste the orders URL from your Profitscaler settings and set it to import daily.
Repeat with the products URL as a second source.
Join on date, and on SKU for the product-level source.

