Global Beauty and Wellness Consumer Products Analytics Set (WW)
CPGBWC933· 2.7M records · 46 tables · v1.5.0 · Updated 2026-08-18
Retail Beauty and Wellness Consumer Products Dataset API
Overview
CPGBWC933 connects fictional skincare, fragrance and weight-management businesses to an auditable commercial and operating chain. Product launches follow research stage gates, jurisdiction-specific filings, supplier terms, bill-of-materials cost, internal or contract manufacturing, batch quality release, lot expiry, FEFO inventory, country and channel pricing, customer orders and returns. Salespeople join and move through effective-dated teams and territories, while marketing, trade, ambassador and event costs feed product, division and company profitability. Historical records are synthetic calibrations, current-period records are synthetic estimates and later periods are synthetic forecasts. Public regulatory and economic sources provide methodology anchors only; they do not make any generated entity, product, person, identifier or transaction real.
Analytics
Four entries from the packaged tables, with the performance the dataset records for them. Every value below is read from the shipped files.
VELAQORA BARRIER LIPID SERUMADQ-U02Alderquay Dermal Sciences plc
2.6MUnits sold
USD 84MNet sales
52.9%Margin
USD 32.80Unit price
Units, thousandsProductionSalesInventory
1 / 4
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| cpgbwc_products | 168 |
| cpgbwc_years | 12 |
| cpgbwc_periods | 144 |
| cpgbwc_countries | 30 |
| cpgbwc_economic_indices_monthly | 4,320 |
| cpgbwc_company_groups | 4 |
| cpgbwc_legal_entities | 42 |
| cpgbwc_business_divisions | 30 |
| cpgbwc_brands | 16 |
| cpgbwc_facilities | 25 |
| cpgbwc_sales_channels | 8 |
| cpgbwc_routes_to_market | 80 |
| cpgbwc_sales_territories | 80 |
| cpgbwc_sales_teams | 80 |
| cpgbwc_salespeople | 240 |
| cpgbwc_salesperson_assignments | 240 |
| cpgbwc_customers | 160 |
| cpgbwc_suppliers | 24 |
| cpgbwc_materials | 48 |
| cpgbwc_supplier_contracts | 67 |
| cpgbwc_research_programmes | 168 |
| cpgbwc_product_media | 168 |
| cpgbwc_bill_of_materials | 1,470 |
| cpgbwc_research_costs_monthly | 2,581 |
| cpgbwc_regulatory_filings | 1,134 |
| cpgbwc_patent_assets | 112 |
| cpgbwc_product_market_entries | 1,134 |
| cpgbwc_price_lists_monthly | 77,510 |
| cpgbwc_marketing_campaigns | 160 |
| cpgbwc_marketing_spend_monthly | 515 |
| cpgbwc_product_cost_standards_monthly | 12,000 |
| cpgbwc_production_batches | 11,795 |
| cpgbwc_quality_tests | 35,385 |
| cpgbwc_inventory_lots | 11,795 |
| cpgbwc_sales_orders | 348,295 |
| cpgbwc_sales_order_lines | 919,908 |
| cpgbwc_sales_returns | 132,071 |
| cpgbwc_expiry_disposals | 21 |
| cpgbwc_inventory_movements | 1,081,427 |
| cpgbwc_inventory_monthly | 12,672 |
| cpgbwc_salesperson_performance_monthly | 15,214 |
| cpgbwc_product_market_financials_monthly | 72,737 |
| cpgbwc_division_financials_monthly | 4,320 |
| cpgbwc_company_financials_monthly | 576 |
| cpgbwc_company_financials_annual | 48 |
| cpgbwc_methodology_sources | 37 |
Table Relationships
One parent record and seven child tables, each joined back on the same key.
70%
Loading diagram
Schema
Every table ships with typed columns, referential integrity, and documentation.
cpgbwc_products· Rows: 168
| Column | Type | Description |
|---|---|---|
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_products. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_products. |
| brand_id | varchar(8) | Stable identifier for brand; use it for the joins declared for cpgbwc_products. |
| responsible_legal_entity_id | varchar(8) | Stable identifier for responsible legal entity; use it for the joins declared for cpgbwc_products. |
| primary_facility_id | varchar(16) | Stable identifier for primary facility; use it for the joins declared for cpgbwc_products. |
| research_programme_id | varchar(16) | Stable identifier for research programme; use it for the joins declared for cpgbwc_products. |
| product_code | varchar(16) | Controlled or synthetic code for product. |
+16 more columns in cpgbwc_products. The full schema ships with the download.
cpgbwc_years· Rows: 12
| Column | Type | Description |
|---|---|---|
| year_id | varchar(8) | Stable identifier for year; use it for the joins declared for cpgbwc_years. |
| calendar_year | integer | Calendar year for the cpgbwc_years record. |
| period_start | date | Period start for the cpgbwc_years record. |
| period_end | date | Period end for the cpgbwc_years record. |
| source_status | varchar(40) | Evidence status for the row: modelled historical, modelled current year or modelled forecast. |
cpgbwc_periods· Rows: 144
| Column | Type | Description |
|---|---|---|
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_periods. |
| year_id | varchar(8) | Stable identifier for year; use it for the joins declared for cpgbwc_periods. |
| calendar_year | integer | Calendar year for the cpgbwc_periods record. |
| month_number | varchar(8) | Month number for the cpgbwc_periods record. |
| month_name | varchar(16) | Human-readable month name. |
| quarter_number | varchar(8) | Quarter number for the cpgbwc_periods record. |
| period_start | date | Period start for the cpgbwc_periods record. |
+4 more columns in cpgbwc_periods. The full schema ships with the download.
cpgbwc_countries· Rows: 30
| Column | Type | Description |
|---|---|---|
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_countries. |
| country_code | varchar(8) | Controlled or synthetic code for country. |
| country_name | varchar(32) | Human-readable country name. |
| market_region | varchar(24) | Market region for the cpgbwc_countries record. |
| currency_code | varchar(8) | Controlled or synthetic code for currency. |
| reporting_currency_code | varchar(8) | Controlled or synthetic code for reporting currency. |
| vat_or_sales_tax_pct | numeric(5,1) | vat or sales tax expressed as a percentage. |
+4 more columns in cpgbwc_countries. The full schema ships with the download.
cpgbwc_economic_indices_monthly· Rows: 4,320
| Column | Type | Description |
|---|---|---|
| economic_index_id | varchar(24) | Stable identifier for economic index; use it for the joins declared for cpgbwc_economic_indices_monthly. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_economic_indices_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_economic_indices_monthly. |
| consumer_price_index | numeric(9,4) | consumer price index as a modeled index used by the deterministic methodology. |
| producer_price_index | numeric(9,4) | producer price index as a modeled index used by the deterministic methodology. |
| wage_cost_index | numeric(9,4) | wage cost index as a modeled index used by the deterministic methodology. |
| energy_cost_index | numeric(9,4) | energy cost index as a modeled index used by the deterministic methodology. |
+7 more columns in cpgbwc_economic_indices_monthly. The full schema ships with the download.
cpgbwc_company_groups· Rows: 4
| Column | Type | Description |
|---|---|---|
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_company_groups. |
| group_code | varchar(8) | Controlled or synthetic code for group. |
| group_name | varchar(48) | Human-readable group name. |
| headquarters_country_id | varchar(8) | Stable identifier for headquarters country; use it for the joins declared for cpgbwc_company_groups. |
| headquarters_city | varchar(16) | Headquarters city for the cpgbwc_company_groups record. |
| product_domain | varchar(48) | Product domain for the cpgbwc_company_groups record. |
| founding_year | integer | Founding year for the cpgbwc_company_groups record. |
+7 more columns in cpgbwc_company_groups. The full schema ships with the download.
cpgbwc_legal_entities· Rows: 42
| Column | Type | Description |
|---|---|---|
| legal_entity_id | varchar(8) | Stable identifier for legal entity; use it for the joins declared for cpgbwc_legal_entities. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_legal_entities. |
| entity_code | varchar(16) | Controlled or synthetic code for entity. |
| entity_name | varchar(48) | Human-readable entity name. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_legal_entities. |
| city_name | varchar(16) | Human-readable city name. |
| entity_role | varchar(48) | Entity role for the cpgbwc_legal_entities record. |
+6 more columns in cpgbwc_legal_entities. The full schema ships with the download.
cpgbwc_business_divisions· Rows: 30
| Column | Type | Description |
|---|---|---|
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for cpgbwc_business_divisions. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_business_divisions. |
| legal_entity_id | varchar(8) | Stable identifier for legal entity; use it for the joins declared for cpgbwc_business_divisions. |
| division_code | varchar(16) | Controlled or synthetic code for division. |
| division_name | varchar(48) | Human-readable division name. |
| division_type | varchar(32) | Division type for the cpgbwc_business_divisions record. |
| region_name | varchar(24) | Human-readable region name. |
+4 more columns in cpgbwc_business_divisions. The full schema ships with the download.
cpgbwc_brands· Rows: 16
| Column | Type | Description |
|---|---|---|
| brand_id | varchar(8) | Stable identifier for brand; use it for the joins declared for cpgbwc_brands. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_brands. |
| owning_legal_entity_id | varchar(8) | Stable identifier for owning legal entity; use it for the joins declared for cpgbwc_brands. |
| brand_code | varchar(16) | Controlled or synthetic code for brand. |
| brand_name | varchar(16) | Human-readable brand name. |
| brand_positioning | varchar(88) | Brand positioning for the cpgbwc_brands record. |
| target_consumer_segment | varchar(40) | Target consumer segment for the cpgbwc_brands record. |
+4 more columns in cpgbwc_brands. The full schema ships with the download.
cpgbwc_facilities· Rows: 25
| Column | Type | Description |
|---|---|---|
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for cpgbwc_facilities. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_facilities. |
| operating_legal_entity_id | varchar(8) | Stable identifier for operating legal entity; use it for the joins declared for cpgbwc_facilities. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_facilities. |
| facility_code | varchar(16) | Controlled or synthetic code for facility. |
| facility_name | varchar(48) | Human-readable facility name. |
| city_name | varchar(16) | Human-readable city name. |
+9 more columns in cpgbwc_facilities. The full schema ships with the download.
cpgbwc_sales_channels· Rows: 8
| Column | Type | Description |
|---|---|---|
| sales_channel_id | varchar(8) | Stable identifier for sales channel; use it for the joins declared for cpgbwc_sales_channels. |
| channel_code | varchar(8) | Controlled or synthetic code for channel. |
| channel_name | varchar(48) | Human-readable channel name. |
| channel_group | varchar(24) | Channel group for the cpgbwc_sales_channels record. |
| customer_type | varchar(40) | Customer type for the cpgbwc_sales_channels record. |
| standard_margin_pct | integer | standard margin expressed as a percentage. |
| payment_terms_days | integer | payment terms measured in calendar days. |
+2 more columns in cpgbwc_sales_channels. The full schema ships with the download.
cpgbwc_routes_to_market· Rows: 80
| Column | Type | Description |
|---|---|---|
| route_to_market_id | varchar(16) | Stable identifier for route to market; use it for the joins declared for cpgbwc_routes_to_market. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_routes_to_market. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_routes_to_market. |
| sales_channel_id | varchar(8) | Stable identifier for sales channel; use it for the joins declared for cpgbwc_routes_to_market. |
| serving_legal_entity_id | varchar(8) | Stable identifier for serving legal entity; use it for the joins declared for cpgbwc_routes_to_market. |
| primary_facility_id | varchar(16) | Stable identifier for primary facility; use it for the joins declared for cpgbwc_routes_to_market. |
| route_code | varchar(24) | Controlled or synthetic code for route. |
+8 more columns in cpgbwc_routes_to_market. The full schema ships with the download.
cpgbwc_sales_territories· Rows: 80
| Column | Type | Description |
|---|---|---|
| territory_id | varchar(16) | Stable identifier for territory; use it for the joins declared for cpgbwc_sales_territories. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_sales_territories. |
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for cpgbwc_sales_territories. |
| primary_country_id | varchar(8) | Stable identifier for primary country; use it for the joins declared for cpgbwc_sales_territories. |
| territory_code | varchar(8) | Controlled or synthetic code for territory. |
| territory_name | varchar(48) | Human-readable territory name. |
| market_region | varchar(24) | Market region for the cpgbwc_sales_territories record. |
+4 more columns in cpgbwc_sales_territories. The full schema ships with the download.
cpgbwc_sales_teams· Rows: 80
| Column | Type | Description |
|---|---|---|
| sales_team_id | varchar(16) | Stable identifier for sales team; use it for the joins declared for cpgbwc_sales_teams. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_sales_teams. |
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for cpgbwc_sales_teams. |
| territory_id | varchar(16) | Stable identifier for territory; use it for the joins declared for cpgbwc_sales_teams. |
| team_code | varchar(16) | Controlled or synthetic code for team. |
| team_name | varchar(32) | Human-readable team name. |
| sales_model | varchar(24) | sales model as the monetary measure defined for the cpgbwc_sales_teams record. |
+5 more columns in cpgbwc_sales_teams. The full schema ships with the download.
cpgbwc_salespeople· Rows: 240
| Column | Type | Description |
|---|---|---|
| salesperson_id | varchar(16) | Stable identifier for salesperson; use it for the joins declared for cpgbwc_salespeople. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_salespeople. |
| employing_legal_entity_id | varchar(8) | Stable identifier for employing legal entity; use it for the joins declared for cpgbwc_salespeople. |
| home_country_id | varchar(8) | Stable identifier for home country; use it for the joins declared for cpgbwc_salespeople. |
| employee_code | varchar(16) | Controlled or synthetic code for employee. |
| salesperson_name | varchar(32) | Human-readable salesperson name. |
| role_title | varchar(40) | Role title for the cpgbwc_salespeople record. |
+9 more columns in cpgbwc_salespeople. The full schema ships with the download.
cpgbwc_salesperson_assignments· Rows: 240
| Column | Type | Description |
|---|---|---|
| assignment_id | varchar(16) | Stable identifier for assignment; use it for the joins declared for cpgbwc_salesperson_assignments. |
| salesperson_id | varchar(16) | Stable identifier for salesperson; use it for the joins declared for cpgbwc_salesperson_assignments. |
| sales_team_id | varchar(16) | Stable identifier for sales team; use it for the joins declared for cpgbwc_salesperson_assignments. |
| territory_id | varchar(16) | Stable identifier for territory; use it for the joins declared for cpgbwc_salesperson_assignments. |
| assignment_role | varchar(40) | Assignment role for the cpgbwc_salesperson_assignments record. |
| assignment_start | date | Assignment start for the cpgbwc_salesperson_assignments record. |
| assignment_end | date | Assignment end for the cpgbwc_salesperson_assignments record. |
+3 more columns in cpgbwc_salesperson_assignments. The full schema ships with the download.
cpgbwc_customers· Rows: 160
| Column | Type | Description |
|---|---|---|
| customer_id | varchar(16) | Stable identifier for customer; use it for the joins declared for cpgbwc_customers. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_customers. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_customers. |
| sales_channel_id | varchar(8) | Stable identifier for sales channel; use it for the joins declared for cpgbwc_customers. |
| route_to_market_id | varchar(16) | Stable identifier for route to market; use it for the joins declared for cpgbwc_customers. |
| territory_id | varchar(16) | Stable identifier for territory; use it for the joins declared for cpgbwc_customers. |
| customer_code | varchar(16) | Controlled or synthetic code for customer. |
+8 more columns in cpgbwc_customers. The full schema ships with the download.
cpgbwc_suppliers· Rows: 24
| Column | Type | Description |
|---|---|---|
| supplier_id | varchar(8) | Stable identifier for supplier; use it for the joins declared for cpgbwc_suppliers. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_suppliers. |
| supplier_code | varchar(16) | Controlled or synthetic code for supplier. |
| supplier_name | varchar(48) | Human-readable supplier name. |
| supplier_type | varchar(32) | Supplier type for the cpgbwc_suppliers record. |
| qualification_status | varchar(16) | qualification status in the controlled vocabulary documented by the dataset. |
| qualified_from | date | qualified from as an ISO 8601 calendar date. |
+5 more columns in cpgbwc_suppliers. The full schema ships with the download.
cpgbwc_materials· Rows: 48
| Column | Type | Description |
|---|---|---|
| material_id | varchar(8) | Stable identifier for material; use it for the joins declared for cpgbwc_materials. |
| material_code | varchar(32) | Controlled or synthetic code for material. |
| material_name | varchar(56) | Human-readable material name. |
| material_group | varchar(16) | Material group for the cpgbwc_materials record. |
| material_subgroup | varchar(32) | Material subgroup for the cpgbwc_materials record. |
| unit_of_measure | varchar(16) | Unit of measure for the cpgbwc_materials record. |
| quality_grade | varchar(32) | Quality grade for the cpgbwc_materials record. |
+6 more columns in cpgbwc_materials. The full schema ships with the download.
cpgbwc_supplier_contracts· Rows: 67
| Column | Type | Description |
|---|---|---|
| supplier_contract_id | varchar(16) | Stable identifier for supplier contract; use it for the joins declared for cpgbwc_supplier_contracts. |
| supplier_id | varchar(8) | Stable identifier for supplier; use it for the joins declared for cpgbwc_supplier_contracts. |
| material_id | varchar(8) | Stable identifier for material; use it for the joins declared for cpgbwc_supplier_contracts. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_supplier_contracts. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for cpgbwc_supplier_contracts. |
| contract_code | varchar(40) | Controlled or synthetic code for contract. |
| contract_name | varchar(88) | Human-readable contract name. |
+12 more columns in cpgbwc_supplier_contracts. The full schema ships with the download.
cpgbwc_research_programmes· Rows: 168
| Column | Type | Description |
|---|---|---|
| research_programme_id | varchar(16) | Stable identifier for research programme; use it for the joins declared for cpgbwc_research_programmes. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_research_programmes. |
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for cpgbwc_research_programmes. |
| programme_code | varchar(16) | Controlled or synthetic code for programme. |
| programme_name | varchar(72) | Human-readable programme name. |
| research_type | varchar(64) | Research type for the cpgbwc_research_programmes record. |
| intended_product_category | varchar(32) | Intended product category for the cpgbwc_research_programmes record. |
+8 more columns in cpgbwc_research_programmes. The full schema ships with the download.
cpgbwc_product_media· Rows: 168
| Column | Type | Description |
|---|---|---|
| product_media_id | varchar(16) | Stable identifier for product media; use it for the joins declared for cpgbwc_product_media. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_product_media. |
| image_file | varchar(32) | Dataset-relative path to the linked product image. |
| image_format | varchar(16) | Image format for the cpgbwc_product_media record. |
| image_width_px | integer | Image width px for the cpgbwc_product_media record. |
| image_height_px | integer | Image height px for the cpgbwc_product_media record. |
| background_mode | varchar(24) | Image background treatment, with transparent used for catalogue cutouts. |
+5 more columns in cpgbwc_product_media. The full schema ships with the download.
cpgbwc_bill_of_materials· Rows: 1,470
| Column | Type | Description |
|---|---|---|
| bom_item_id | varchar(16) | Stable identifier for bom item; use it for the joins declared for cpgbwc_bill_of_materials. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_bill_of_materials. |
| material_id | varchar(8) | Stable identifier for material; use it for the joins declared for cpgbwc_bill_of_materials. |
| bom_version | varchar(16) | Bom version for the cpgbwc_bill_of_materials record. |
| component_sequence | integer | Component sequence for the cpgbwc_bill_of_materials record. |
| cost_bucket | varchar(24) | cost bucket as the monetary measure defined for the cpgbwc_bill_of_materials record. |
| quantity_per_unit | numeric(10,6) | Quantity per unit for the cpgbwc_bill_of_materials record. |
+5 more columns in cpgbwc_bill_of_materials. The full schema ships with the download.
cpgbwc_research_costs_monthly· Rows: 2,581
| Column | Type | Description |
|---|---|---|
| research_cost_id | varchar(16) | Stable identifier for research cost; use it for the joins declared for cpgbwc_research_costs_monthly. |
| research_programme_id | varchar(16) | Stable identifier for research programme; use it for the joins declared for cpgbwc_research_costs_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_research_costs_monthly. |
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for cpgbwc_research_costs_monthly. |
| cost_category | varchar(48) | cost category as the monetary measure defined for the cpgbwc_research_costs_monthly record. |
| accounting_treatment | varchar(40) | Management and statutory accounting classification applied to the research or development cost. |
| direct_labour_usd | numeric(9,2) | direct labour in United States dollars. |
+7 more columns in cpgbwc_research_costs_monthly. The full schema ships with the download.
cpgbwc_regulatory_filings· Rows: 1,134
| Column | Type | Description |
|---|---|---|
| regulatory_filing_id | varchar(16) | Stable identifier for regulatory filing; use it for the joins declared for cpgbwc_regulatory_filings. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_regulatory_filings. |
| legal_entity_id | varchar(8) | Stable identifier for legal entity; use it for the joins declared for cpgbwc_regulatory_filings. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_regulatory_filings. |
| filing_code | varchar(56) | Controlled or synthetic code for filing. |
| filing_name | varchar(88) | Human-readable filing name. |
| filing_type | varchar(32) | Filing type for the cpgbwc_regulatory_filings record. |
+12 more columns in cpgbwc_regulatory_filings. The full schema ships with the download.
cpgbwc_patent_assets· Rows: 112
| Column | Type | Description |
|---|---|---|
| patent_asset_id | varchar(16) | Stable identifier for patent asset; use it for the joins declared for cpgbwc_patent_assets. |
| research_programme_id | varchar(16) | Stable identifier for research programme; use it for the joins declared for cpgbwc_patent_assets. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_patent_assets. |
| legal_entity_id | varchar(8) | Stable identifier for legal entity; use it for the joins declared for cpgbwc_patent_assets. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_patent_assets. |
| patent_code | varchar(24) | Controlled or synthetic code for patent. |
| patent_name | varchar(96) | Human-readable patent name. |
+10 more columns in cpgbwc_patent_assets. The full schema ships with the download.
cpgbwc_product_market_entries· Rows: 1,134
| Column | Type | Description |
|---|---|---|
| market_entry_id | varchar(16) | Stable identifier for market entry; use it for the joins declared for cpgbwc_product_market_entries. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_product_market_entries. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_product_market_entries. |
| route_to_market_id | varchar(16) | Stable identifier for route to market; use it for the joins declared for cpgbwc_product_market_entries. |
| primary_regulatory_filing_id | varchar(16) | Stable identifier for primary regulatory filing; use it for the joins declared for cpgbwc_product_market_entries. |
| market_entry_code | varchar(16) | Controlled or synthetic code for market entry. |
| market_entry_name | varchar(80) | Human-readable market entry name. |
+6 more columns in cpgbwc_product_market_entries. The full schema ships with the download.
cpgbwc_price_lists_monthly· Rows: 77,510
| Column | Type | Description |
|---|---|---|
| price_list_id | varchar(24) | Stable identifier for price list; use it for the joins declared for cpgbwc_price_lists_monthly. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_price_lists_monthly. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_price_lists_monthly. |
| sales_channel_id | varchar(8) | Stable identifier for sales channel; use it for the joins declared for cpgbwc_price_lists_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_price_lists_monthly. |
| price_currency_code | varchar(8) | Controlled or synthetic code for price currency. |
| list_price_local | numeric(10,2) | list price in the row currency. |
+8 more columns in cpgbwc_price_lists_monthly. The full schema ships with the download.
cpgbwc_marketing_campaigns· Rows: 160
| Column | Type | Description |
|---|---|---|
| campaign_id | varchar(16) | Stable identifier for campaign; use it for the joins declared for cpgbwc_marketing_campaigns. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_marketing_campaigns. |
| brand_id | varchar(8) | Stable identifier for brand; use it for the joins declared for cpgbwc_marketing_campaigns. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_marketing_campaigns. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_marketing_campaigns. |
| sales_channel_id | varchar(8) | Stable identifier for sales channel; use it for the joins declared for cpgbwc_marketing_campaigns. |
| campaign_code | varchar(32) | Controlled or synthetic code for campaign. |
+14 more columns in cpgbwc_marketing_campaigns. The full schema ships with the download.
cpgbwc_marketing_spend_monthly· Rows: 515
| Column | Type | Description |
|---|---|---|
| marketing_spend_id | varchar(16) | Stable identifier for marketing spend; use it for the joins declared for cpgbwc_marketing_spend_monthly. |
| campaign_id | varchar(16) | Stable identifier for campaign; use it for the joins declared for cpgbwc_marketing_spend_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_marketing_spend_monthly. |
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for cpgbwc_marketing_spend_monthly. |
| supplier_id | varchar(8) | Stable identifier for supplier; use it for the joins declared for cpgbwc_marketing_spend_monthly. |
| spend_category | varchar(24) | spend category as the monetary measure defined for the cpgbwc_marketing_spend_monthly record. |
| planned_spend_usd | numeric(10,2) | planned spend in United States dollars. |
+6 more columns in cpgbwc_marketing_spend_monthly. The full schema ships with the download.
cpgbwc_product_cost_standards_monthly· Rows: 12,000
| Column | Type | Description |
|---|---|---|
| cost_standard_id | varchar(24) | Stable identifier for cost standard; use it for the joins declared for cpgbwc_product_cost_standards_monthly. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_product_cost_standards_monthly. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for cpgbwc_product_cost_standards_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_product_cost_standards_monthly. |
| raw_material_cost_usd | numeric(6,2) | raw material cost in United States dollars. |
| primary_packaging_cost_usd | numeric(6,2) | primary packaging cost in United States dollars. |
| secondary_packaging_cost_usd | numeric(5,2) | secondary packaging cost in United States dollars. |
+10 more columns in cpgbwc_product_cost_standards_monthly. The full schema ships with the download.
cpgbwc_production_batches· Rows: 11,795
| Column | Type | Description |
|---|---|---|
| production_batch_id | varchar(16) | Stable identifier for production batch; use it for the joins declared for cpgbwc_production_batches. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_production_batches. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for cpgbwc_production_batches. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_production_batches. |
| cost_standard_id | varchar(24) | Stable identifier for cost standard; use it for the joins declared for cpgbwc_production_batches. |
| batch_code | varchar(32) | Controlled or synthetic code for batch. |
| batch_name | varchar(80) | Human-readable batch name. |
+15 more columns in cpgbwc_production_batches. The full schema ships with the download.
cpgbwc_quality_tests· Rows: 35,385
| Column | Type | Description |
|---|---|---|
| quality_test_id | varchar(16) | Stable identifier for quality test; use it for the joins declared for cpgbwc_quality_tests. |
| production_batch_id | varchar(16) | Stable identifier for production batch; use it for the joins declared for cpgbwc_quality_tests. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_quality_tests. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_quality_tests. |
| test_code | varchar(16) | Controlled or synthetic code for test. |
| test_name | varchar(32) | Human-readable test name. |
| test_type | varchar(16) | Test type for the cpgbwc_quality_tests record. |
+10 more columns in cpgbwc_quality_tests. The full schema ships with the download.
cpgbwc_inventory_lots· Rows: 11,795
| Column | Type | Description |
|---|---|---|
| inventory_lot_id | varchar(16) | Stable identifier for inventory lot; use it for the joins declared for cpgbwc_inventory_lots. |
| production_batch_id | varchar(16) | Stable identifier for production batch; use it for the joins declared for cpgbwc_inventory_lots. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_inventory_lots. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for cpgbwc_inventory_lots. |
| lot_code | varchar(32) | Controlled or synthetic code for lot. |
| lot_name | varchar(80) | Human-readable lot name. |
| manufacture_date | date | manufacture date as an ISO 8601 calendar date. |
+6 more columns in cpgbwc_inventory_lots. The full schema ships with the download.
cpgbwc_sales_orders· Rows: 348,295
| Column | Type | Description |
|---|---|---|
| sales_order_id | varchar(16) | Stable identifier for sales order; use it for the joins declared for cpgbwc_sales_orders. |
| customer_id | varchar(16) | Stable identifier for customer; use it for the joins declared for cpgbwc_sales_orders. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_sales_orders. |
| sales_channel_id | varchar(8) | Stable identifier for sales channel; use it for the joins declared for cpgbwc_sales_orders. |
| route_to_market_id | varchar(16) | Stable identifier for route to market; use it for the joins declared for cpgbwc_sales_orders. |
| territory_id | varchar(16) | Stable identifier for territory; use it for the joins declared for cpgbwc_sales_orders. |
| salesperson_id | varchar(16) | Stable identifier for salesperson; use it for the joins declared for cpgbwc_sales_orders. |
+12 more columns in cpgbwc_sales_orders. The full schema ships with the download.
cpgbwc_sales_order_lines· Rows: 919,908
| Column | Type | Description |
|---|---|---|
| sales_order_line_id | varchar(16) | Stable identifier for sales order line; use it for the joins declared for cpgbwc_sales_order_lines. |
| sales_order_id | varchar(16) | Stable identifier for sales order; use it for the joins declared for cpgbwc_sales_order_lines. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_sales_order_lines. |
| market_entry_id | varchar(16) | Stable identifier for market entry; use it for the joins declared for cpgbwc_sales_order_lines. |
| price_list_id | varchar(24) | Stable identifier for price list; use it for the joins declared for cpgbwc_sales_order_lines. |
| campaign_id | varchar(16) | Stable identifier for campaign; use it for the joins declared for cpgbwc_sales_order_lines. |
| order_line_number | varchar(8) | Order line number for the cpgbwc_sales_order_lines record. |
+10 more columns in cpgbwc_sales_order_lines. The full schema ships with the download.
cpgbwc_sales_returns· Rows: 132,071
| Column | Type | Description |
|---|---|---|
| sales_return_id | varchar(16) | Stable identifier for sales return; use it for the joins declared for cpgbwc_sales_returns. |
| sales_order_line_id | varchar(16) | Stable identifier for sales order line; use it for the joins declared for cpgbwc_sales_returns. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_sales_returns. |
| customer_id | varchar(16) | Stable identifier for customer; use it for the joins declared for cpgbwc_sales_returns. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_sales_returns. |
| return_code | varchar(8) | Controlled or synthetic code for return. |
| return_name | varchar(24) | Human-readable return name. |
+10 more columns in cpgbwc_sales_returns. The full schema ships with the download.
cpgbwc_expiry_disposals· Rows: 21
| Column | Type | Description |
|---|---|---|
| expiry_disposal_id | varchar(16) | Stable identifier for expiry disposal; use it for the joins declared for cpgbwc_expiry_disposals. |
| inventory_lot_id | varchar(16) | Stable identifier for inventory lot; use it for the joins declared for cpgbwc_expiry_disposals. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_expiry_disposals. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for cpgbwc_expiry_disposals. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_expiry_disposals. |
| disposal_code | varchar(8) | Controlled or synthetic code for disposal. |
| disposal_name | varchar(32) | Human-readable disposal name. |
+8 more columns in cpgbwc_expiry_disposals. The full schema ships with the download.
cpgbwc_inventory_movements· Rows: 1,081,427
| Column | Type | Description |
|---|---|---|
| inventory_movement_id | varchar(16) | Stable identifier for inventory movement; use it for the joins declared for cpgbwc_inventory_movements. |
| inventory_lot_id | varchar(16) | Stable identifier for inventory lot; use it for the joins declared for cpgbwc_inventory_movements. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_inventory_movements. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for cpgbwc_inventory_movements. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_inventory_movements. |
| production_batch_id | varchar(16) | Stable identifier for production batch; use it for the joins declared for cpgbwc_inventory_movements. |
| sales_order_line_id | varchar(16) | Stable identifier for sales order line; use it for the joins declared for cpgbwc_inventory_movements. |
+12 more columns in cpgbwc_inventory_movements. The full schema ships with the download.
cpgbwc_inventory_monthly· Rows: 12,672
| Column | Type | Description |
|---|---|---|
| inventory_month_id | varchar(16) | Stable identifier for inventory month; use it for the joins declared for cpgbwc_inventory_monthly. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_inventory_monthly. |
| facility_id | varchar(16) | Stable identifier for facility; use it for the joins declared for cpgbwc_inventory_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_inventory_monthly. |
| opening_units | integer | opening measured in finished-product units. |
| production_receipts_units | integer | production receipts measured in finished-product units. |
| transfer_in_units | integer | transfer in measured in finished-product units. |
+12 more columns in cpgbwc_inventory_monthly. The full schema ships with the download.
cpgbwc_salesperson_performance_monthly· Rows: 15,214
| Column | Type | Description |
|---|---|---|
| salesperson_performance_id | varchar(16) | Stable identifier for salesperson performance; use it for the joins declared for cpgbwc_salesperson_performance_monthly. |
| salesperson_id | varchar(16) | Stable identifier for salesperson; use it for the joins declared for cpgbwc_salesperson_performance_monthly. |
| sales_team_id | varchar(16) | Stable identifier for sales team; use it for the joins declared for cpgbwc_salesperson_performance_monthly. |
| territory_id | varchar(16) | Stable identifier for territory; use it for the joins declared for cpgbwc_salesperson_performance_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_salesperson_performance_monthly. |
| target_net_sales_usd | numeric(12,2) | target net sales in United States dollars. |
| gross_sales_usd | numeric(12,2) | gross sales in United States dollars. |
+12 more columns in cpgbwc_salesperson_performance_monthly. The full schema ships with the download.
cpgbwc_product_market_financials_monthly· Rows: 72,737
| Column | Type | Description |
|---|---|---|
| product_market_financial_id | varchar(16) | Stable identifier for product market financial; use it for the joins declared for cpgbwc_product_market_financials_monthly. |
| product_id | varchar(16) | Stable identifier for product; use it for the joins declared for cpgbwc_product_market_financials_monthly. |
| country_id | varchar(8) | Stable identifier for country; use it for the joins declared for cpgbwc_product_market_financials_monthly. |
| sales_channel_id | varchar(8) | Stable identifier for sales channel; use it for the joins declared for cpgbwc_product_market_financials_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_product_market_financials_monthly. |
| gross_sales_usd | numeric(11,2) | gross sales in United States dollars. |
| on_invoice_discount_usd | numeric(10,2) | on invoice discount in United States dollars. |
+13 more columns in cpgbwc_product_market_financials_monthly. The full schema ships with the download.
cpgbwc_division_financials_monthly· Rows: 4,320
| Column | Type | Description |
|---|---|---|
| division_financial_id | varchar(16) | Stable identifier for division financial; use it for the joins declared for cpgbwc_division_financials_monthly. |
| division_id | varchar(16) | Stable identifier for division; use it for the joins declared for cpgbwc_division_financials_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_division_financials_monthly. |
| net_sales_usd | numeric(12,2) | Gross sales less discounts, rebates and return credits, in United States dollars. |
| cost_of_goods_sold_usd | numeric(12,2) | cost of goods sold in United States dollars. |
| sales_payroll_usd | numeric(10,2) | sales payroll in United States dollars. |
| sales_commission_usd | numeric(11,2) | sales commission in United States dollars. |
+11 more columns in cpgbwc_division_financials_monthly. The full schema ships with the download.
cpgbwc_company_financials_monthly· Rows: 576
| Column | Type | Description |
|---|---|---|
| company_financial_id | varchar(16) | Stable identifier for company financial; use it for the joins declared for cpgbwc_company_financials_monthly. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_company_financials_monthly. |
| period_id | varchar(16) | Stable identifier for period; use it for the joins declared for cpgbwc_company_financials_monthly. |
| gross_sales_usd | numeric(12,2) | gross sales in United States dollars. |
| discounts_usd | numeric(12,2) | discounts in United States dollars. |
| return_credit_usd | numeric(11,2) | return credit in United States dollars. |
| net_sales_usd | numeric(12,2) | Gross sales less discounts, rebates and return credits, in United States dollars. |
+23 more columns in cpgbwc_company_financials_monthly. The full schema ships with the download.
cpgbwc_company_financials_annual· Rows: 48
| Column | Type | Description |
|---|---|---|
| company_annual_financial_id | varchar(16) | Stable identifier for company annual financial; use it for the joins declared for cpgbwc_company_financials_annual. |
| company_group_id | varchar(8) | Stable identifier for company group; use it for the joins declared for cpgbwc_company_financials_annual. |
| year_id | varchar(8) | Stable identifier for year; use it for the joins declared for cpgbwc_company_financials_annual. |
| gross_sales_usd | numeric(13,2) | gross sales in United States dollars. |
| discounts_usd | numeric(13,2) | discounts in United States dollars. |
| return_credit_usd | numeric(11,2) | return credit in United States dollars. |
| net_sales_usd | numeric(13,2) | Gross sales less discounts, rebates and return credits, in United States dollars. |
+18 more columns in cpgbwc_company_financials_annual. The full schema ships with the download.
cpgbwc_methodology_sources· Rows: 37
| Column | Type | Description |
|---|---|---|
| methodology_source_id | varchar(8) | Stable identifier for methodology source; use it for the joins declared for cpgbwc_methodology_sources. |
| source_code | varchar(48) | Controlled or synthetic code for source. |
| source_name | varchar(40) | Human-readable source name. |
| source_organization | varchar(64) | Source organization for the cpgbwc_methodology_sources record. |
| source_title | varchar(112) | Source title for the cpgbwc_methodology_sources record. |
| source_url | varchar(216) | Source url for the cpgbwc_methodology_sources record. |
| source_type | varchar(48) | Source type for the cpgbwc_methodology_sources record. |
+7 more columns in cpgbwc_methodology_sources. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| product_id | company_group_id | brand_id | product_code | product_name | product_category | product_form | package_type | pack_size | pack_unit | lifecycle_status | launch_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| CPG0001 | GRP001 | BRD002 | ADQ-U01 | DERMYNTHA GENTLE CLOUD CLEANSER | cleanser | cleanser | bottle | 150 | ml | discontinued | 2015-01-12 |
| CPG0002 | GRP001 | BRD001 | ADQ-U02 | VELAQORA BARRIER LIPID SERUM | treatment_serum | bar | bottle | 30 | ml | active | 2015-04-12 |
| CPG0003 | GRP001 | BRD003 | ADQ-U03 | OQURELIA DAILY MINERAL SPF 50 | sun_care | finished_consumer_product | bottle | 50 | ml | active | 2015-08-12 |
Version History
| v1.5.0 | 2026-08-18 | Launch stock corrected. The production plan reads a rate smoothed over a year of demand either side of the month, and that window was skipping months a product had no demand in rather than counting them as zero. Before launch it therefore read back the mature rate from the months after launch, and the line ran flat out for a quarter before the product existed. Each SKU opened with about five months of cover it then spent a year working off, which showed as stock climbing while production fell and nothing had yet been sold. Ahead of its first order a product now only builds the launch pipeline, about six weeks of the first month's demand. Finished goods cover falls again from six weeks to under six, and every other series is unchanged: demand, net sales, order volumes, basket shape, lifespans, seasonality and the exact roll-forward. |
Related Datasets
European Skincare Product Operations and Sales Analytics Set (EU)
RetailCPGSKN934 is a deterministic synthetic skincare operations and sales warehouse for fictional London-based Alderquay, linking brands and products to research, regulation, sourcing, production, inventory, customers, sales teams, returns, disposal and profitability across Europe, North America and selected Asian markets.
$299one time
View details FMCG Manufacturing Product Performance Set (EU)
RetailA complete Europe analytical warehouse covering company, plant, product, material, batch, quality, location, channel, customer, shipment, inventory, promotion, sales, return, trade-spend, finance, rating and forecast data.
$199one time
View details FMCG Manufacturing Product Performance Set (US)
RetailA complete United States analytical warehouse covering company, plant, product, material, batch, quality, location, channel, customer, shipment, inventory, promotion, sales, return, trade-spend, finance, rating and forecast data.
$199one time
View details