Run discount and campaign reports

I need the marketing team to see campaign effectiveness now. Run discount and campaign reports for the past 60 days showing discount code usage, per-order discount amounts, number of orders by campaign source, and net revenue after discounts. Break results down by product category and by top five traffic sources, and export a PDF summary for the CMO and a CSV for finance. Deliver by Wednesday morning.

Before I send campaign performance to the CMO, make the report easy to act on. Put the net revenue after discounts and ROI figure at the top, call out any discount codes that lost money, surface the three products where discounts drove the most orders but not margin, and list the two follow-up actions I should recommend to pricing. Make the findings scannable for a one-minute read.

The marketing campaign drove a 40% uplift in orders this month but finance reports a negative margin after discounts. I have the raw sales and discount data but no clear breakdown of which codes caused the loss. Campaigns go into review Friday and the head of growth expects an answer. What is the likely cause, what two analyses give the fastest diagnosis, and which immediate change would reduce risk for the next campaign?

Across quarters we keep launching promotions that raise order volume but erode margin, and each time leadership asks for a post-mortem. Where are we losing credibility and time in this cycle, and what single recurring habit should the marketing and pricing teams adopt to prevent these margin surprises? Give the habit and the first two measurable checks to include in the campaign brief.