Six related files, about 8,000 rows, all linked by brand. The numbers come from the distributor system, the field app, the retailer portals, and the e-commerce export, brought into one place.
brands12 rows
- brand_idtext
- brand_nametext
- categorytext
- subcategorytext
- home_regiontext
- primary_planttext
- launch_yearinteger
- statustext
- source_systemtext
- brand_managertext
- base_annual_net_revenue_crreal
- target_gross_margin_pctreal
- target_contribution_pctreal
- planned_trade_spend_pctreal
monthly_brand_pnl1,032 rows
- brand_idtext
- period_endtext
- fiscal_yearinteger
- fiscal_quartertext
- currencytext
- volume_tonnesreal
- net_revenuereal
- gross_salesreal
- cogsreal
- gross_profitreal
- trade_spendreal
- ad_promo_spendreal
- distribution_costreal
- contributionreal
- budget_net_revenuereal
- budget_contributionreal
- submission_statustext
- submission_datetext
channel_sales4,902 rows
- brand_idtext
- period_endtext
- channeltext
- currencytext
- net_revenuereal
- volume_tonnesreal
- units_soldinteger
- active_outletsinteger
- new_outletsinteger
- lost_outletsinteger
inventory_working_cap1,032 rows
- brand_idtext
- period_endtext
- currencytext
- finished_goodsreal
- raw_pack_materialreal
- days_of_inventoryreal
- receivablesreal
- payablesreal
- working_capitalreal
plant_region1,032 rows
- brand_idtext
- period_endtext
- plant_locationtext
- regiontext
- currencytext
- production_tonnesreal
- capacity_tonnesreal
- utilisation_pctreal
- fill_rate_pctreal
- wastage_pctreal
data_quality_ledger12 rows
- issue_idtext
- filetext
- brand_idtext
- periodtext
- issue_typetext
- descriptiontext
- expected_valuetext
- reported_valuetext
- severitytext