Your question is Marketing Campaign ROI Framework. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Design a framework to track the ROI of a marketing campaign.
Clarify how you would define campaign success, attribute conversions and revenue across channels, account for acquisition costs and customer lifetime value, and distinguish incremental impact from activity that would have occurred anyway.
Your framework should specify the core KPIs, required data, calculation logic, reporting cadence, segmentation, attribution approach, and guardrails. Explain how you would handle multi-touch journeys, delayed conversions, refunds, overlapping campaigns, and differences between short-term revenue and long-term customer value. Assume the analysis will be implemented using Snowflake tables and dashboards.