Dữ liệu
retail_audit_skus.csv
Cleaned and classified SKU records from the retail field audit (Nha Trang 6 Sep 2026; Ho Chi Minh City 16 and 20 Sep 2026; 186 SKUs, 11 stores), source FORM-01.
Các cột
| Cột | Ý nghĩa |
|---|---|
record_id | Stable short row ID assigned by the consolidation step (prefix plus number). |
sku_id | Field SKU ID (from the product log). |
date | Date of the event, price or approval (ISO format where available). |
city | City of the store. |
store | Store. |
channel_type | Retail channel. |
product_name | Product name as sold. |
brand_raw | Brand as logged. |
brand | Cleaned brand. |
origin_raw | Origin as logged. |
category_raw | Category as logged. |
format_raw | Format as logged. |
product_type | Cleaned product type. |
as_sold_form | Form as sold. |
formulation_archetype | Formulation archetype code (A0 to A15). |
primary_protein_source | Main protein source. |
secondary_protein_sources | Other protein sources. |
non_vegan_flag | Non-vegan ingredient flag (e.g. EGG, MILK). |
key_ingredients | Ingredient list (label or OSINT). |
protein_g_per_100 | Protein, g per 100 g or 100 ml. |
protein_unit | Basis of protein value. |
protein_value_basis | Where the protein value came from. |
energy_kcal_per_100 | Energy, kcal per 100. |
fat_g_per_100 | Fat, g per 100. |
carbs_g_per_100 | Carbohydrate, g per 100. |
sodium_mg_per_100 | Sodium, mg per 100. |
price_vnd | Shelf price, VND. |
pack_size | Pack size. |
pack_unit | Pack unit (g or ml). |
price_per_100g_vnd | Price per 100 g or 100 ml, VND (derived). |
price_per_100g_protein_vnd | Price per 100 g of protein, VND (derived). |
price_confidence | Confidence of the price read. |
conv_equiv_price_per_100g_vnd | Price per 100 g of a conventional equivalent, VND. |
chay_vs_conv_price_diff_pct | Difference vs the conventional equivalent, %. |
likely_imported_protein_ingredient | Whether the main protein ingredient is likely imported (Y/N). |
brand_owner | Brand owner. |
ownership_country | Owner country. |
manufacturer | Manufacturer. |
plant_location | Plant location. |
product_group | Product group key (same product across stores). |
data_confidence | Overall confidence in the row. |
source_ids | Source IDs (see sources.csv) supporting the row, separated by semicolons. |
evidence_label | VN-direct (evidence about Vietnam), VN-adjacent (comparable country, transfer assumed) or general. |
confidence | High (primary source read), Medium (reputable secondary or primary read in part) or Low (single claim, press, company marketing). |
notes | Free-text notes from the research agent and, where stated, the consolidation step. |
field_notes_original | Original collector notes. |
| record_id | sku_id | date | city | store | channel_type | product_name | brand_raw | brand | origin_raw | category_raw | format_raw | product_type | as_sold_form | formulation_archetype | primary_protein_source | secondary_protein_sources | non_vegan_flag | key_ingredients | protein_g_per_100 | protein_unit | protein_value_basis | energy_kcal_per_100 | fat_g_per_100 | carbs_g_per_100 | sodium_mg_per_100 | price_vnd | pack_size | pack_unit | price_per_100g_vnd | price_per_100g_protein_vnd | price_confidence | conv_equiv_price_per_100g_vnd | chay_vs_conv_price_diff_pct | likely_imported_protein_ingredient | brand_owner | ownership_country | manufacturer | plant_location | product_group | data_confidence | source_ids | evidence_label | confidence | notes | field_notes_original |
|---|