Skip to main content

[Freight] Data collection guide

S
Written by Support

Which data should be included in your data collection file

?
General information
The aim of this module is to calculate the impact of your company’s freight during the studied year. The temporal scope of the study is the financial year of your GHG Report.
⚠️ To be processed by Greenly, the data provided must be in French 🇫🇷 or English 🇬🇧

🎯 The data collection file contains two type of data: mandatory and optional data

  • Mandatory data: It is the minimum necessary data to calculate the amount of CO2e related to this regulatory entry’s activities → Without it, no emissions can be computed.

  • Optional data: any additional data will increase the quality and granularity of the analysis, and provide you various areas of analysis.

Advanced module

List of mandatory data:

  • Shipment ID

  • Sequence number

  • Ownership

  • Departure country code (ISO 3166)

  • One among those:

  • Departure coordinates

  • Departure Code (IATA, LOCODE or ZIPCODE)

  • Departure address

  • Arrival country code (ISO 3166)

  • One among those:

  • Arrival coordinates

  • Arrival Code (IATA, LOCODE or ZIPCODE)

  • Arrival address

  • Distance (Put it if you have it! If not, we will calculate it)

  • Distance Unit

  • Weight

  • Weight Unit

  • Type of Freight
    List of optional data:

  • Fuel data (Fuel type, Fuel consumption, Fuel consumption unit)

  • Supplier emissions (will need review to be valid and auditable but can definitely be used)

  • Refrigerated

  • Client / Consignee

  • Shipper name

  • Date

  • Transport mode

End-to-end module

No IATA or LOCODE are supported in the E2E. You need to do an advanced module
List of mandatory data:

  • Date

  • Distance

  • Departure country (ISO 3166 2 letters code)

  • Departure address

  • Arrival address

  • Arrival country (ISO 3166 2 letters code)

  • Type of freight

  • Weight

  • Vehicle ownership (whether leased or owned)

  • Stakeholder (who pays the supplier?)
    List of optional data:

  • All the other columns and fields

Frequent errors in data forma

t
General information

Advanced module

  • Column 1: Weight

  • Weight are aggregated (multiple journey merged in one line)

  • We need unique entries for each journey

  • Column 2: Distance

  • Distances are aggregated (multiple journey merged in one line)

  • We need unique entries for each journey

  • Column 3: Shipment ID

  • Are not unique

  • Column 4:Sequence number

  • Are missing

  • Column 5: Weight Unit

  • Unit are missing

  • Unit are imprecise: tons (short tons or metric tons?)

End-to-end module

  • Column 1: Weight

  • Weight are aggregated (multiple journey merged in one line)

  • We need unique entries for each journey

  • Column 2: Distance

  • Distances are aggregated (multiple journey merged in one line)

  • We need unique entries for each journey

Did this answer your question?