Every organisation trying to understand its packaging eventually sends suppliers a spreadsheet. Plenty of those spreadsheets come back half completed, in mixed units, with a covering email explaining why the questions do not apply.
That is usually a design fault in the request. The following is the version that works.
The request, field by field
| Field | A useful answer |
|---|---|
| Component name and function | Named separately for each part: tray, film lid, label, outer case, pallet wrap. |
| Component weight | Grams per single component as supplied, not per case or per pallet, stated to a sensible precision. |
| Material and grade | Polymer or fibre type with grade where relevant, for example PET tray, LDPE film, corrugated board, rather than plastic or paper. |
| Coatings, laminates and additives | Any coating, barrier layer, metallisation or wet strength additive, with the layer structure for laminates. |
| Recycled content | Percentage, whether it is post-consumer or pre-consumer, the method used and the document that evidences it. |
| Colour and printing | Colourants, carbon black content and print coverage, all of which affect sortability. |
| Intended end destination | The recycling stream the supplier expects, in a named geography, and the basis for that expectation. |
| Specification revision | Version number and effective date, with a commitment to notify you of changes. |
Why the units matter more than the questions
A weight given per case cannot be compared with a weight given per unit, and neither can be aggregated without knowing the pack count. This is where most packaging datasets fall apart, quietly, after they have been merged.
Specify grams per component, per single unit as supplied, in the request itself, with an example row filled in. A completed example is worth more than a page of instructions.
Reading the answers critically
- A single recycled content percentage covering an entire product range is a marketing figure, not a component figure.
- Recyclable with no geography or stream named tells you nothing you can rely on.
- A material described only as plastic or mixed usually means nobody at the supplier has checked, which is worth knowing.
- A weight identical across several visibly different components suggests an estimate copied across rows.
- A confident answer with no evidence attached is the one most likely to change when you ask for the document.
Treat unknown as unknown
The most damaging habit in packaging data work is filling gaps with zeros so a spreadsheet totals cleanly. A zero is a statement. It says this component contains no recycled content, or weighs nothing, and it will be aggregated, reported and eventually defended.
Keep a distinct unknown state, count how many components sit in it, and track that count down over time. A dataset that admits to being seventy per cent complete is far more useful than one that appears complete and is not.
Make it a condition, not a favour
Data requests sent as an email campaign get email campaign response rates. The same questions attached to supplier onboarding, to a specification sign off and to any change request get answered, because the answer is required before the order proceeds.
That is the single biggest determinant of whether an organisation has usable packaging data in two years.