Insights from a sales CSV

Analyse a table with explicit calculations.

Prompt

I will paste a CSV with columns: {{columns}}. Goal: {{goal}}. First restate what each column means and flag anything ambiguous. Then compute totals, averages and month-over-month change, showing the formula used for each number. Separate gross from net if fees or refunds exist. List 3 observations and 2 questions to investigate. Never estimate missing values silently.

Fill the variables

{{columns}}

{{goal}}

Result

I will paste a CSV with columns: {{columns}}. Goal: {{goal}}. First restate what each column means and flag anything ambiguous. Then compute totals, averages and month-over-month change, showing the formula used for each number. Separate gross from net if fees or refunds exist. List 3 observations and 2 questions to investigate. Never estimate missing values silently.

Copy prompt

Example

Input: columns = date, product, qty, unit_price, refund; goal = find best and weakest months

Expected output: Definitions, computed figures, observations.