E-commerce Transaction Carbon Footprint

This dataset provides detailed, transaction-level estimates of carbon footprint for e-commerce purchases, including breakdowns by product, shipping, and packaging. It enables retailers to monitor environmental impact, report on sustainability initiatives, and identify high-impact areas for improvement. The inclusion of offset and certification data supports comprehensive sustainability analysis and reporting.

  • last updated 12 Dec 2025
  • by GoMask
The brief that made it

Tracking and reporting carbon footprint per transaction for sustainability audits

Sample rows

preview · 8 of 150 rows · all 19 columns
transaction_idstringproduct_categorystringshipping_distance_kmfloatoffset_appliedbooleansustainability_certificationstringtransaction_datetimedatetimecustomer_idstringproduct_idstringquantityintegercarbon_footprint_total_kgfloatcarbon_footprint_product_kgfloatcarbon_footprint_shipping_kgfloatcarbon_footprint_packaging_kgfloatshipping_methodstringorigin_countrystringdestination_countrystringdestination_citystringoffset_amount_kgfloattransaction_value_usdfloat
TXN00001electronics250trueEnergyStar2024-06-02T13:45:00ZCUST0001PROD-electronics-10126.34.21.70.4standardUSAUSASan Diego6.3298.99
TXN00002apparel1200falseFairTrade2024-06-04T09:15:00ZCUST0002PROD-apparel-20159.86.42.80.6expressBangladeshUKManchester0145.5
TXN00003food0trueUSDA Organic2024-06-05T15:11:00ZCUST0003PROD-food-301127.26.50.50.2pickupUSAUSAHouston7.282.3
TXN00004books480falseblank2024-06-08T18:22:00ZCUST0004PROD-books-40133.42.60.60.2standardUSAUSAChicago052.95
TXN00005home_goods1600falseblank2024-06-10T20:40:00ZCUST0005PROD-home_goods-50112.92.10.70.1overnightItalyFranceParis0119.99
TXN00006toys680falseblank2024-06-11T10:25:00ZCUST0006PROD-toys-601714.611.92.20.5standardChinaGermanyHamburg089.75
TXN00007sports2400trueblank2024-06-12T08:05:00ZCUST0007PROD-sports-70138.67.11.20.3expressUSACanadaToronto8.6178.55
TXN00008electronics9000falseEPEAT2024-06-13T19:00:00ZCUST0008PROD-electronics-102120.217.91.80.5overnightJapanUSASeattle0499.99

What the 150 rows show

from the 150-row sample

Electronics (product category) stands out: mean shipping_distance_km is 10,099, against 883.8 for the rest.

  • 41%offset_applied = true
  • 317.9median shipping_distance_km
  • 5shipping methods
  • 16origin countries
  • 18destination countries
  • 6.5median quantity
Mean shipping_distance_km by product_category150 rows
010k20k10,099elec…23 ro…975.7appa…23 ro…31.9food23 ro…438.6toys22 ro…446.3books21 ro…1,654home…20 ro…2,054spor…18 ro…
shipping_distance_km150 rows, in bands of 2,500
06513012433921314012.5k22.5kshipping_distance_km →

Median 317.9, from 0.0 to 21,000.

sustainability_certification62 rows with a value · 88 left blank
  1. EnergyStar15
  2. USDA Organic12
  3. FairTrade9
  4. EPEAT6
  5. OEKO-TEX5
  6. FSC5
  7. FairPlay4
  8. Rainforest Alliance3
  9. EU Organic2
  10. CarbonNeutral1
19 columns by typefrom the column list below
  • string 9
  • integer 1
  • float 7
  • datetime 1
  • boolean 1

Columns

19 columns in four groups
blueprint · 19 columns
columntypedescriptionexample
Text 9 columns
transaction_idstringUnique identifier for each e-commerce transactionuniqueTXN00001
customer_idstringUnique identifier for the customer making the transactionCUST0001
product_idstringUnique identifier for the product purchasedPROD-electronics-101
product_categorystringCategory of the product purchased (e.g., electronics, apparel)7 categorieselectronics
shipping_methodstringMethod of shipping used for the transaction (e.g., standard, express, overnight)standard · express · overnight · pickup · otherstandard
origin_countrystringCountry from which the product was shippedUSA
destination_countrystringCountry to which the product was shippedUSA
destination_citystringCity to which the product was shippedoptionalSan Diego
sustainability_certificationstringCertification or label indicating sustainability of the product or process (e.g., FSC, CarbonNeutral)10 certifications · optionalEnergyStar
Numbers 8 columns
quantityintegerNumber of units of the product purchased in the transaction1 or more2
carbon_footprint_total_kgfloatTotal estimated carbon footprint in kilograms CO2e for the transaction0 or more6.3
carbon_footprint_product_kgfloatEstimated carbon footprint in kilograms CO2e attributed to the product(s) purchased0 or more4.2
carbon_footprint_shipping_kgfloatEstimated carbon footprint in kilograms CO2e attributed to shipping and delivery0 or more1.7
carbon_footprint_packaging_kgfloatEstimated carbon footprint in kilograms CO2e attributed to packaging materials0 or more0.4
shipping_distance_kmfloatEstimated shipping distance in kilometers for the transaction0 or more · optional250
offset_amount_kgfloatAmount of carbon offset applied in kilograms CO2e0 or more · optional6.3
transaction_value_usdfloatTotal monetary value of the transaction in USD0 or more298.99
Dates and times 1 column
transaction_datetimedatetimeDate and time when the transaction occurred2024-06-02T13:45:00Z
True or false 1 column
offset_appliedbooleanIndicates if carbon offset was applied to this transactiontrue

Use it for

  • offset applied41%62 of 150 rowsmean shipping distanc…10.1kelec…975.7appa…31.9food438.6toys

    An e-commerce dashboard

    The offset_applied rate, shipping_distance_km by product_category and a breakdown of sustainability_certification. Excel, Power BI or Tableau.

  • Why do the 23 electronics rows have a mean shipping_distance_km of 10,099?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable transactions with transaction_datetime, customer_id and product_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 19 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset150 rows19 columns
Yours1,000 rows19 columnsorigin_country: UK only

blueprint · e-commerce-transaction-carbon-footprint

Behind this dataset

Same schema. As many rows as you need.

These 150 rows came out of a blueprint — 19 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each row represents a completed e-commerce transaction.
  • Assign a calculated carbon footprint (kg CO2e) per transaction based on product type, packaging, and delivery method.
  • Flag transactions using sustainable packaging or carbon-neutral shipping.
  • Include product category, fulfillment location, and recycler participation status for each row.
  • Exclude transactions without sufficient delivery or packaging data.
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
e-commerce-transaction-carbon-footprint

What should your data show?

Preview 20 rows free
No signup. No card.