Refunds by Sales Channel
Analyze refunds from returns.csv by normalized sales channel, with reusable Run, Change, and Reset workflows, saved grouped results, and a Markdown summary of six returns and 160 in refunds.
About this Model
A returns analysis model that uses returns.csv to normalize sales channels, aggregate refund counts and amounts, save the grouped results, and produce a readable Markdown summary. The default run groups by channel, showing WEB and STORE with three returns and 80 in refunds each, for six returns and 160 overall, including a zero-refund return in the count. A change request updates the existing analysis to break results down by channel and reason while preserving totals and lineage. Reset removes generated analysis artifacts while retaining the original source, folder, specification, and agent hierarchy; a subsequent run restores the default channel-only analysis.
- Normalizes channel values to uppercase while retaining all source columns.
- Groups return counts and refund totals by channel.
- Can update the breakdown in place to include return reason.
- Saves grouped output as Refund Breakdown and summarizes it in Markdown.
- Preserves source lineage from returns.csv through transform, group, and view.
- Reset returns the model to a source-only baseline before clean recreation.