Ice Cream Sales Analytics Set (EU)
RTLICE903· 1.0M records · 49 tables · v1.0.2 · Updated 2026-08-20
Retail Ice Cream and Frozen Desserts Dataset API
Overview
This dataset follows the modelled Fioralume Frozen Desserts Europe across a longitudinal European operating history. It connects multi-currency product and price masters to daily weather, channel locations, anonymous customer segments, order lines, payments, promotions, campaign performance, inventory, production batches, food-quality checks, cold-chain shipments, temperature events, returns, waste, labour, sustainability, reconciled monthly finance and leakage-safe sales forecasts. Price differences are decomposed into country price position, currency conversion, tax, channel margin, distribution burden and promotion, allowing analysts to explain why the same product reaches different shelf prices and margins across Europe. The package supports trend reporting, demand planning, assortment optimisation, channel strategy, pricing, promotion effectiveness, route economics and operational forecasting without representing a real company or observed transaction.
Analytics
Four entries from the packaged tables, with the performance the dataset records for them. Every value below is read from the shipped files.
Vanilla Bean VelvetICP0001classic dairy
134.6MUnits sold
EUR 487,149kRevenue
51.4%Margin
EUR 5.4List price
Units, thousandsSalesRevenue
1 / 4
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| icecream_countries | 12 |
| icecream_seasons | 4 |
| icecream_months | 120 |
| icecream_calendar_days | 3,652 |
| icecream_markets | 36 |
| icecream_sales_channels | 8 |
| icecream_locations | 120 |
| icecream_warehouses | 12 |
| icecream_products | 32 |
| icecream_product_variants | 48 |
| icecream_product_media | 32 |
| icecream_ingredients | 24 |
| icecream_product_ingredients | 185 |
| icecream_product_nutrition | 32 |
| icecream_customer_segments | 8 |
| icecream_customers | 18,000 |
| icecream_campaigns | 240 |
| icecream_promotions | 480 |
| icecream_events | 480 |
| icecream_exchange_rates_monthly | 600 |
| icecream_price_lists | 50,688 |
| icecream_distribution_costs_monthly | 11,520 |
| icecream_sales_targets_monthly | 11,520 |
| icecream_sales_orders | 87,034 |
| icecream_sales_order_lines | 288,859 |
| icecream_payments | 87,034 |
| icecream_returns | 8,024 |
| icecream_weekly_location_performance | 62,760 |
| icecream_ecommerce_funnel_daily | 43,824 |
| icecream_inventory_monthly | 69,120 |
| icecream_production_batches | 9,600 |
| icecream_batch_quality_tests | 19,200 |
| icecream_cold_chain_shipments | 9,600 |
| icecream_shipment_temperature_events | 38,400 |
| icecream_waste_events | 8,400 |
| icecream_customer_feedback | 10,000 |
| icecream_loyalty_activity | 21,304 |
| icecream_campaign_performance_weekly | 960 |
| icecream_monthly_country_channel_sales | 11,520 |
| icecream_monthly_product_sales | 46,080 |
| icecream_monthly_financials | 1,440 |
| icecream_forecast_features | 11,520 |
| icecream_sales_forecasts | 11,520 |
| icecream_supplier_deliveries | 8,400 |
| icecream_store_labour_monthly | 14,400 |
| icecream_operational_incidents | 2,400 |
| icecream_sustainability_monthly | 1,440 |
| icecream_country_year_economics | 132 |
| icecream_daily_weather | 43,824 |
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.
icecream_countries· Rows: 12
| Column | Type | Description |
|---|---|---|
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| country_name | varchar(24) | Human-readable country name; company, product, location, campaign and account names are modelled where applicable. |
| currency | varchar(16) | currency; ISO-style currency code or its declared exchange-rate role. |
| vat_rate_pct | numeric(5,1) | vat rate expressed as a percentage. |
| price_index | numeric(5,2) | price index; see currency and unit columns for interpretation. |
| distribution_index | numeric(5,2) | Distribution index for the icecream record. |
+6 more columns in icecream_countries. The full schema ships with the download.
icecream_seasons· Rows: 4
| Column | Type | Description |
|---|---|---|
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| season_name | varchar(16) | Human-readable season name; company, product, location, campaign and account names are modelled where applicable. |
| month_numbers | varchar(16) | Pipe-delimited calendar month numbers assigned to the meteorological season. |
| demand_index | numeric(5,2) | Demand index for the icecream record. |
| temperature_sensitivity | numeric(5,2) | temperature sensitivity in degrees Celsius or its declared categorical band. |
| description | varchar(128) | Description for the icecream record. |
icecream_months· Rows: 120
| Column | Type | Description |
|---|---|---|
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| year_month | varchar(16) | Year month for the icecream record. |
| calendar_year | integer | Calendar year for the icecream record. |
| month_number | varchar(8) | Month number for the icecream record. |
| month_name | varchar(16) | Human-readable month name; company, product, location, campaign and account names are modelled where applicable. |
| quarter_number | varchar(8) | Quarter number for the icecream record. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
+7 more columns in icecream_months. The full schema ships with the download.
icecream_calendar_days· Rows: 3,652
| Column | Type | Description |
|---|---|---|
| calendar_date | varchar(16) | calendar date as an ISO 8601 calendar date. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| calendar_year | integer | Calendar year for the icecream record. |
| quarter_number | varchar(8) | Quarter number for the icecream record. |
| month_number | varchar(8) | Month number for the icecream record. |
| day_of_month | integer | Day of month for the icecream record. |
+8 more columns in icecream_calendar_days. The full schema ships with the download.
icecream_markets· Rows: 36
| Column | Type | Description |
|---|---|---|
| market_id | varchar(8) | Stable identifier for market; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| country_name | varchar(24) | Human-readable country name; company, product, location, campaign and account names are modelled where applicable. |
| city | varchar(16) | City for the icecream record. |
| administrative_area | varchar(40) | Administrative area for the icecream record. |
| market_tier | varchar(24) | Market tier for the icecream record. |
+3 more columns in icecream_markets. The full schema ships with the download.
icecream_sales_channels· Rows: 8
| Column | Type | Description |
|---|---|---|
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
| channel_code | varchar(32) | Stable code for channel. |
| channel_name | varchar(40) | Human-readable channel name; company, product, location, campaign and account names are modelled where applicable. |
| channel_group | varchar(24) | Channel group for the icecream record. |
| margin_index | numeric(5,2) | Margin index for the icecream record. |
| quantity_index | numeric(5,1) | quantity index as a non-negative unit quantity. |
| demand_weight | integer | Demand weight for the icecream record. |
+2 more columns in icecream_sales_channels. The full schema ships with the download.
icecream_locations· Rows: 120
| Column | Type | Description |
|---|---|---|
| location_id | varchar(16) | Stable identifier for location; use it for declared joins. |
| location_name | varchar(56) | Human-readable location name; company, product, location, campaign and account names are modelled where applicable. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| market_id | varchar(8) | Stable identifier for market; use it for declared joins. |
| city | varchar(16) | City for the icecream record. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
+7 more columns in icecream_locations. The full schema ships with the download.
icecream_warehouses· Rows: 12
| Column | Type | Description |
|---|---|---|
| warehouse_id | varchar(8) | Stable identifier for warehouse; use it for declared joins. |
| warehouse_name | varchar(48) | Human-readable warehouse name; company, product, location, campaign and account names are modelled where applicable. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| market_id | varchar(8) | Stable identifier for market; use it for declared joins. |
| city | varchar(16) | City for the icecream record. |
| storage_capacity_pallets | integer | Storage capacity pallets for the icecream record. |
+5 more columns in icecream_warehouses. The full schema ships with the download.
icecream_products· Rows: 32
| Column | Type | Description |
|---|---|---|
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| product_name | varchar(40) | Human-readable product name; company, product, location, campaign and account names are modelled where applicable. |
| product_family | varchar(24) | Product family for the icecream record. |
| flavour_code | varchar(24) | Stable code for flavour. |
| format_code | varchar(16) | Stable code for format. |
| standard_pack_ml | integer | Standard pack ml for the icecream record. |
| base_list_price_eur | numeric(5,1) | base list price in euros. |
+6 more columns in icecream_products. The full schema ships with the download.
icecream_product_variants· Rows: 48
| Column | Type | Description |
|---|---|---|
| variant_id | varchar(16) | Stable identifier for variant; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| variant_name | varchar(48) | Human-readable variant name; company, product, location, campaign and account names are modelled where applicable. |
| pack_size_ml | integer | Pack size ml for the icecream record. |
| pack_type | varchar(16) | Pack type for the icecream record. |
| units_per_case | integer | Units per case for the icecream record. |
| case_volume_litres | numeric(6,2) | case volume in litres. |
+8 more columns in icecream_product_variants. The full schema ships with the download.
icecream_product_media· Rows: 32
| Column | Type | Description |
|---|---|---|
| product_media_id | varchar(16) | Stable identifier for product media; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| packshot_svg_file | varchar(32) | Dataset-relative path to the product transparent-background SVG packshot. |
| packshot_png_file | varchar(32) | Dataset-relative path to the product 1200 by 1200 transparent-background PNG packshot. |
| image_width_px | integer | Image width px for the icecream record. |
| image_height_px | integer | Image height px for the icecream record. |
| transparent_background_flag | boolean | Boolean indicator for transparent background. |
+2 more columns in icecream_product_media. The full schema ships with the download.
icecream_ingredients· Rows: 24
| Column | Type | Description |
|---|---|---|
| ingredient_id | varchar(8) | Stable identifier for ingredient; use it for declared joins. |
| ingredient_name | varchar(32) | Human-readable ingredient name; company, product, location, campaign and account names are modelled where applicable. |
| ingredient_group | varchar(16) | Ingredient group for the icecream record. |
| purchase_unit | varchar(16) | Purchase unit for the icecream record. |
| baseline_unit_cost_eur | numeric(6,2) | baseline unit cost in euros. |
icecream_product_ingredients· Rows: 185
| Column | Type | Description |
|---|---|---|
| product_ingredient_id | varchar(16) | Stable identifier for product ingredient; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| ingredient_id | varchar(8) | Stable identifier for ingredient; use it for declared joins. |
| ingredient_name | varchar(32) | Human-readable ingredient name; company, product, location, campaign and account names are modelled where applicable. |
| recipe_sequence | integer | Recipe sequence for the icecream record. |
| quantity_per_standard_pack | numeric(8,2) | quantity per standard pack as a non-negative unit quantity. |
| quantity_unit | varchar(16) | quantity unit as a non-negative unit quantity. |
+3 more columns in icecream_product_ingredients. The full schema ships with the download.
icecream_product_nutrition· Rows: 32
| Column | Type | Description |
|---|---|---|
| nutrition_id | varchar(16) | Stable identifier for nutrition; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| serving_size_ml | integer | Serving size ml for the icecream record. |
| energy_kcal_per_serving | integer | Energy kcal per serving for the icecream record. |
| fat_g_per_serving | numeric(5,1) | Fat g per serving for the icecream record. |
| saturated_fat_g_per_serving | numeric(4,1) | Saturated fat g per serving for the icecream record. |
| carbohydrate_g_per_serving | numeric(5,1) | Carbohydrate g per serving for the icecream record. |
+9 more columns in icecream_product_nutrition. The full schema ships with the download.
icecream_customer_segments· Rows: 8
| Column | Type | Description |
|---|---|---|
| segment_id | varchar(8) | Stable identifier for segment; use it for declared joins. |
| segment_code | varchar(24) | Stable code for segment. |
| segment_name | varchar(40) | Human-readable segment name; company, product, location, campaign and account names are modelled where applicable. |
| customer_type | varchar(16) | Customer type for the icecream record. |
| basket_value_index | numeric(6,2) | Basket value index for the icecream record. |
| retention_probability | numeric(5,2) | Retention probability for the icecream record. |
icecream_customers· Rows: 18,000
| Column | Type | Description |
|---|---|---|
| customer_id | varchar(16) | Stable identifier for customer; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| segment_id | varchar(8) | Stable identifier for segment; use it for declared joins. |
| segment_code | varchar(24) | Stable code for segment. |
| customer_type | varchar(16) | Customer type for the icecream record. |
| joined_on | date | joined on as an ISO 8601 calendar date. |
+9 more columns in icecream_customers. The full schema ships with the download.
icecream_campaigns· Rows: 240
| Column | Type | Description |
|---|---|---|
| campaign_id | varchar(16) | Stable identifier for campaign; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| campaign_name | varchar(56) | Human-readable campaign name; company, product, location, campaign and account names are modelled where applicable. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
| objective_code | varchar(24) | Stable code for objective. |
| audience_segment_code | varchar(24) | Stable code for audience segment. |
+6 more columns in icecream_campaigns. The full schema ships with the download.
icecream_promotions· Rows: 480
| Column | Type | Description |
|---|---|---|
| promotion_id | varchar(16) | Stable identifier for promotion; use it for declared joins. |
| campaign_id | varchar(16) | Stable identifier for campaign; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| promotion_mechanic | varchar(24) | Promotion mechanic for the icecream record. |
+7 more columns in icecream_promotions. The full schema ships with the download.
icecream_events· Rows: 480
| Column | Type | Description |
|---|---|---|
| event_id | varchar(16) | Stable identifier for event; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| event_name | varchar(40) | Human-readable event name; company, product, location, campaign and account names are modelled where applicable. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| market_id | varchar(8) | Stable identifier for market; use it for declared joins. |
| event_type | varchar(24) | Event type for the icecream record. |
+7 more columns in icecream_events. The full schema ships with the download.
icecream_exchange_rates_monthly· Rows: 600
| Column | Type | Description |
|---|---|---|
| exchange_rate_id | varchar(16) | Stable identifier for exchange rate; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| rate_month | varchar(16) | Rate month for the icecream record. |
| base_currency | varchar(16) | base currency; ISO-style currency code or its declared exchange-rate role. |
| quote_currency | varchar(16) | quote currency; ISO-style currency code or its declared exchange-rate role. |
| local_currency_per_eur | numeric(9,5) | Number of local-currency units for one euro under the dataset monthly rate convention. |
| rate_source | varchar(24) | Rate source for the icecream record. |
+2 more columns in icecream_exchange_rates_monthly. The full schema ships with the download.
icecream_price_lists· Rows: 50,688
| Column | Type | Description |
|---|---|---|
| price_id | varchar(16) | Stable identifier for price; use it for declared joins. |
| price_year | integer | price year; see currency and unit columns for interpretation. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
| channel_code | varchar(32) | Stable code for channel. |
| variant_id | varchar(16) | Stable identifier for variant; use it for declared joins. |
+15 more columns in icecream_price_lists. The full schema ships with the download.
icecream_distribution_costs_monthly· Rows: 11,520
| Column | Type | Description |
|---|---|---|
| distribution_cost_id | varchar(16) | Stable identifier for distribution cost; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
| channel_code | varchar(32) | Stable code for channel. |
+8 more columns in icecream_distribution_costs_monthly. The full schema ships with the download.
icecream_sales_targets_monthly· Rows: 11,520
| Column | Type | Description |
|---|---|---|
| sales_target_id | varchar(16) | Stable identifier for sales target; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
| channel_code | varchar(32) | Stable code for channel. |
+7 more columns in icecream_sales_targets_monthly. The full schema ships with the download.
icecream_sales_orders· Rows: 87,034
| Column | Type | Description |
|---|---|---|
| order_id | varchar(16) | Stable identifier for order; use it for declared joins. |
| order_date | date | order date as an ISO 8601 calendar date. |
| order_time_local | varchar(16) | order time in the row transaction currency. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
+26 more columns in icecream_sales_orders. The full schema ships with the download.
icecream_sales_order_lines· Rows: 288,859
| Column | Type | Description |
|---|---|---|
| order_line_id | varchar(16) | Stable identifier for order line; use it for declared joins. |
| order_id | varchar(16) | Stable identifier for order; use it for declared joins. |
| line_number | varchar(8) | Line number for the icecream record. |
| order_date | date | order date as an ISO 8601 calendar date. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
+25 more columns in icecream_sales_order_lines. The full schema ships with the download.
icecream_payments· Rows: 87,034
| Column | Type | Description |
|---|---|---|
| payment_id | varchar(16) | Stable identifier for payment; use it for declared joins. |
| order_id | varchar(16) | Stable identifier for order; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
| payment_method | varchar(32) | Payment method for the icecream record. |
| payment_status | varchar(24) | payment status in the declared lifecycle or operational status vocabulary. |
+8 more columns in icecream_payments. The full schema ships with the download.
icecream_returns· Rows: 8,024
| Column | Type | Description |
|---|---|---|
| return_id | varchar(16) | Stable identifier for return; use it for declared joins. |
| order_line_id | varchar(16) | Stable identifier for order line; use it for declared joins. |
| order_id | varchar(16) | Stable identifier for order; use it for declared joins. |
| return_date | date | return date as an ISO 8601 calendar date. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
+6 more columns in icecream_returns. The full schema ships with the download.
icecream_weekly_location_performance· Rows: 62,760
| Column | Type | Description |
|---|---|---|
| location_week_id | varchar(16) | Stable identifier for location week; use it for declared joins. |
| location_id | varchar(16) | Stable identifier for location; use it for declared joins. |
| week_start_date | date | week start date as an ISO 8601 calendar date. |
| week_end_date | date | week end date as an ISO 8601 calendar date. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
+12 more columns in icecream_weekly_location_performance. The full schema ships with the download.
icecream_ecommerce_funnel_daily· Rows: 43,824
| Column | Type | Description |
|---|---|---|
| funnel_day_id | varchar(16) | Stable identifier for funnel day; use it for declared joins. |
| calendar_date | varchar(16) | calendar date as an ISO 8601 calendar date. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| sessions | integer | Sessions for the icecream record. |
+12 more columns in icecream_ecommerce_funnel_daily. The full schema ships with the download.
icecream_inventory_monthly· Rows: 69,120
| Column | Type | Description |
|---|---|---|
| inventory_record_id | varchar(16) | Stable identifier for inventory record; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| warehouse_id | varchar(8) | Stable identifier for warehouse; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| variant_id | varchar(16) | Stable identifier for variant; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
+11 more columns in icecream_inventory_monthly. The full schema ships with the download.
icecream_production_batches· Rows: 9,600
| Column | Type | Description |
|---|---|---|
| batch_id | varchar(16) | Stable identifier for batch; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| production_date | date | production date as an ISO 8601 calendar date. |
| plant_code | varchar(8) | Stable code for plant. |
| production_line_code | varchar(8) | Stable code for production line. |
+10 more columns in icecream_production_batches. The full schema ships with the download.
icecream_batch_quality_tests· Rows: 19,200
| Column | Type | Description |
|---|---|---|
| quality_test_id | varchar(16) | Stable identifier for quality test; use it for declared joins. |
| batch_id | varchar(16) | Stable identifier for batch; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| test_date | date | test date as an ISO 8601 calendar date. |
| test_code | varchar(32) | Stable code for test. |
| test_name | varchar(24) | Human-readable test name; company, product, location, campaign and account names are modelled where applicable. |
+7 more columns in icecream_batch_quality_tests. The full schema ships with the download.
icecream_cold_chain_shipments· Rows: 9,600
| Column | Type | Description |
|---|---|---|
| shipment_id | varchar(16) | Stable identifier for shipment; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| warehouse_id | varchar(8) | Stable identifier for warehouse; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| location_id | varchar(16) | Stable identifier for location; use it for declared joins. |
+13 more columns in icecream_cold_chain_shipments. The full schema ships with the download.
icecream_shipment_temperature_events· Rows: 38,400
| Column | Type | Description |
|---|---|---|
| temperature_event_id | varchar(16) | Stable identifier for temperature event; use it for declared joins. |
| shipment_id | varchar(16) | Stable identifier for shipment; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| reading_sequence | integer | Reading sequence for the icecream record. |
| reading_timestamp | varchar(32) | Reading timestamp for the icecream record. |
| journey_stage | varchar(24) | Journey stage for the icecream record. |
| temperature_c | numeric(5,1) | temperature in degrees Celsius. |
+6 more columns in icecream_shipment_temperature_events. The full schema ships with the download.
icecream_waste_events· Rows: 8,400
| Column | Type | Description |
|---|---|---|
| waste_event_id | varchar(16) | Stable identifier for waste event; use it for declared joins. |
| waste_date | date | waste date as an ISO 8601 calendar date. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| location_id | varchar(16) | Stable identifier for location; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
+6 more columns in icecream_waste_events. The full schema ships with the download.
icecream_customer_feedback· Rows: 10,000
| Column | Type | Description |
|---|---|---|
| feedback_id | varchar(16) | Stable identifier for feedback; use it for declared joins. |
| order_id | varchar(16) | Stable identifier for order; use it for declared joins. |
| customer_id | varchar(16) | Stable identifier for customer; use it for declared joins. |
| feedback_date | date | feedback date as an ISO 8601 calendar date. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
+9 more columns in icecream_customer_feedback. The full schema ships with the download.
icecream_loyalty_activity· Rows: 21,304
| Column | Type | Description |
|---|---|---|
| loyalty_activity_id | varchar(16) | Stable identifier for loyalty activity; use it for declared joins. |
| customer_id | varchar(16) | Stable identifier for customer; use it for declared joins. |
| order_id | varchar(16) | Stable identifier for order; use it for declared joins. |
| activity_date | date | activity date as an ISO 8601 calendar date. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| activity_type | varchar(16) | Activity type for the icecream record. |
+5 more columns in icecream_loyalty_activity. The full schema ships with the download.
icecream_campaign_performance_weekly· Rows: 960
| Column | Type | Description |
|---|---|---|
| campaign_week_id | varchar(16) | Stable identifier for campaign week; use it for declared joins. |
| campaign_id | varchar(16) | Stable identifier for campaign; use it for declared joins. |
| week_start_date | date | week start date as an ISO 8601 calendar date. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
| spend_eur | numeric(8,2) | spend in euros. |
| reach | integer | Reach for the icecream record. |
+8 more columns in icecream_campaign_performance_weekly. The full schema ships with the download.
icecream_monthly_country_channel_sales· Rows: 11,520
| Column | Type | Description |
|---|---|---|
| country_channel_sales_id | varchar(16) | Stable identifier for country channel sales; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| month_index | integer | Month index for the icecream record. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| country_name | varchar(24) | Human-readable country name; company, product, location, campaign and account names are modelled where applicable. |
+21 more columns in icecream_monthly_country_channel_sales. The full schema ships with the download.
icecream_monthly_product_sales· Rows: 46,080
| Column | Type | Description |
|---|---|---|
| monthly_product_sales_id | varchar(16) | Stable identifier for monthly product sales; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| product_name | varchar(40) | Human-readable product name; company, product, location, campaign and account names are modelled where applicable. |
+13 more columns in icecream_monthly_product_sales. The full schema ships with the download.
icecream_monthly_financials· Rows: 1,440
| Column | Type | Description |
|---|---|---|
| monthly_financial_id | varchar(16) | Stable identifier for monthly financial; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| currency | varchar(16) | currency; ISO-style currency code or its declared exchange-rate role. |
| net_revenue_eur | numeric(10,2) | net revenue in euros. |
+11 more columns in icecream_monthly_financials. The full schema ships with the download.
icecream_forecast_features· Rows: 11,520
| Column | Type | Description |
|---|---|---|
| forecast_feature_id | varchar(16) | Stable identifier for forecast feature; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
| channel_code | varchar(32) | Stable code for channel. |
+16 more columns in icecream_forecast_features. The full schema ships with the download.
icecream_sales_forecasts· Rows: 11,520
| Column | Type | Description |
|---|---|---|
| sales_forecast_id | varchar(16) | Stable identifier for sales forecast; use it for declared joins. |
| forecast_feature_id | varchar(16) | Stable identifier for forecast feature; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
| forecast_created_on | date | forecast created on as an ISO 8601 calendar date. |
| model_version | varchar(24) | Model version for the icecream record. |
+10 more columns in icecream_sales_forecasts. The full schema ships with the download.
icecream_supplier_deliveries· Rows: 8,400
| Column | Type | Description |
|---|---|---|
| supplier_delivery_id | varchar(16) | Stable identifier for supplier delivery; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| ingredient_id | varchar(8) | Stable identifier for ingredient; use it for declared joins. |
| warehouse_id | varchar(8) | Stable identifier for warehouse; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| supplier_code | varchar(16) | Stable code for supplier. |
| purchase_order_date | date | purchase order date as an ISO 8601 calendar date. |
+9 more columns in icecream_supplier_deliveries. The full schema ships with the download.
icecream_store_labour_monthly· Rows: 14,400
| Column | Type | Description |
|---|---|---|
| store_labour_id | varchar(16) | Stable identifier for store labour; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| location_id | varchar(16) | Stable identifier for location; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
| full_time_equivalent | numeric(5,2) | Full time equivalent for the icecream record. |
+7 more columns in icecream_store_labour_monthly. The full schema ships with the download.
icecream_operational_incidents· Rows: 2,400
| Column | Type | Description |
|---|---|---|
| incident_id | varchar(16) | Stable identifier for incident; use it for declared joins. |
| incident_date | date | incident date as an ISO 8601 calendar date. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| location_id | varchar(16) | Stable identifier for location; use it for declared joins. |
| warehouse_id | varchar(8) | Stable identifier for warehouse; use it for declared joins. |
+9 more columns in icecream_operational_incidents. The full schema ships with the download.
icecream_sustainability_monthly· Rows: 1,440
| Column | Type | Description |
|---|---|---|
| sustainability_id | varchar(16) | Stable identifier for sustainability; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| units_sold | integer | Units sold for the icecream record. |
| electricity_kwh | numeric(9,2) | Electricity kwh for the icecream record. |
| renewable_energy_share_pct | numeric(6,2) | renewable energy share expressed as a percentage. |
+8 more columns in icecream_sustainability_monthly. The full schema ships with the download.
icecream_country_year_economics· Rows: 132
| Column | Type | Description |
|---|---|---|
| country_year_economic_id | varchar(16) | Stable identifier for country year economic; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| calendar_year | integer | Calendar year for the icecream record. |
| consumer_spending_index | numeric(7,2) | Consumer spending index for the icecream record. |
| food_price_index | numeric(7,2) | food price index; see currency and unit columns for interpretation. |
| disposable_income_index | numeric(7,2) | Disposable income index for the icecream record. |
+4 more columns in icecream_country_year_economics. The full schema ships with the download.
icecream_daily_weather· Rows: 43,824
| Column | Type | Description |
|---|---|---|
| daily_weather_id | varchar(16) | Stable identifier for daily weather; use it for declared joins. |
| calendar_date | varchar(16) | calendar date as an ISO 8601 calendar date. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| average_temperature_c | numeric(5,1) | average temperature in degrees Celsius. |
+8 more columns in icecream_daily_weather. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| month_id | season_id | country_code | country_name | channel_code | channel_name | orders | units | net_sales_eur | gross_margin_eur | gross_margin_pct | target_attainment_pct |
|---|---|---|---|---|---|---|---|---|---|---|---|
| M201607 | SUM | IT | Italy | owned_store | Company-Owned Store | 30 | 143 | 712.28 | 379.23 | 55.62 | 101.17 |
| M201607 | SUM | IT | Italy | ecommerce_delivery | E-commerce and Direct Delivery | 25 | 124 | 670.27 | 329.52 | 50.11 | 106.16 |
| M201607 | SUM | IT | Italy | supermarket_grocery | Supermarket and Grocery | 41 | 4132 | 15445.58 | 6595.56 | 43.17 | 108.11 |
Version History
| v1.0.2 | 2026-08-20 | Restores the product renders to the download and changes no data at all, because 1.0.1 shipped without them in error. |
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