For me, this is what’s been frustrating historically.
- Attribution is too blunt. I can see spend and revenue, but not which products or bundles are carrying the account after fees and shipping.
- Inputs drift. COGS changes, shipping rates change, discounting changes, and the sheet becomes less accurate over time.
- The number is too slow to act on. I might do a P&L at month-end, but I’ve already spent 3-4 weeks on a bad campaign or a low-margin SKU.
Personally, I’d want a simple daily view by product and channel, with a clear “confidence” level on the data. Even a rough number is better than a perfect spreadsheet that only gets touched once a month, assuming it’s obvious what’s included and what isn’t.
Are you thinking of pulling in blended profit at the store level, or trying to get to true contribution margin by product and campaign?