P&G Product Seasonality Analysis
A traceable analysis of public quarterly data, promotional signals, and category performance across fiscal seasons.
- Context
- Independent public-data study
- Role
- Data model, analytical framework, and report presentation
- Scope
- Five fiscal years · Report and analytical workbook
The project uses P&G’s public quarterly material and other verifiable sources to examine sales differences across quarters, while asking how seasonality, category mix, and marketing signals should be interpreted with restraint.
Analytical approach
A report and a companion workbook were developed together so that every central calculation could be traced to quarterly inputs, formulas, and sources. Quarterly mean comparisons, annual differences, seasonal indices, and product-line performance retain separate definitions instead of being collapsed into one headline.
Governing principle
Seasonal association is not proof of a marketing activity’s causal effect. The report therefore does not convert public sales movement into promotion ROI, nor retain regional share claims without adequate sources. Visual expression—including axis scale, dual-axis units, and truncated baselines—was also treated as part of analytical integrity.
Outcome
The final delivery includes an analytical report and an eight-sheet workbook. Calculations, sources, cross-file wording, charts, and accessibility were examined through several independent review rounds.
Boundary
This is an independent analysis based on public information. It uses no internal P&G sales, campaign-cost, or media-investment data. Its conclusions remain within the seasonal signals that public evidence can support.