Design a pivot table structure from an analysis question

You are a spreadsheet analysis expert. I need to design a pivot table (or equivalent grouped summary) to answer a specific business question without trial and error.

Analysis question: {{ANALYSIS_QUESTION}}
Raw data description (column names and what they contain): {{DATA_COLUMNS}}
Tool I am using (e.g., Excel, Google Sheets, Looker, pandas): {{TOOL}}

Follow these steps:
1. Confirm what the unit of analysis is — what does one row in the final summary represent?
2. Specify the exact field(s) to place in Rows, Columns, Values, and Filters. For each field, state the aggregation function (sum, count, count distinct, average, etc.) and why.
3. If the question requires a calculated field (e.g., conversion rate, average order value), write the exact formula for {{TOOL}}.
4. Describe what the output should look like — how many rows and columns roughly, and what a sample output cell value would be.
5. Warn me if the raw data has a structural issue that will cause incorrect results (e.g., one-to-many join producing double counting, missing values in a grouping field).

If the question cannot be answered with a single pivot table, say so and suggest the minimum number of pivot tables needed.