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.
Sample rows
preview · 8 of 150 rows · all 19 columns| transaction_idstring | product_categorystring | shipping_distance_kmfloat | offset_appliedboolean | sustainability_certificationstring | transaction_datetimedatetime | customer_idstring | product_idstring | quantityinteger | carbon_footprint_total_kgfloat | carbon_footprint_product_kgfloat | carbon_footprint_shipping_kgfloat | carbon_footprint_packaging_kgfloat | shipping_methodstring | origin_countrystring | destination_countrystring | destination_citystring | offset_amount_kgfloat | transaction_value_usdfloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TXN00001 | electronics | 250 | true | EnergyStar | 2024-06-02T13:45:00Z | CUST0001 | PROD-electronics-101 | 2 | 6.3 | 4.2 | 1.7 | 0.4 | standard | USA | USA | San Diego | 6.3 | 298.99 |
| TXN00002 | apparel | 1200 | false | FairTrade | 2024-06-04T09:15:00Z | CUST0002 | PROD-apparel-201 | 5 | 9.8 | 6.4 | 2.8 | 0.6 | express | Bangladesh | UK | Manchester | 0 | 145.5 |
| TXN00003 | food | 0 | true | USDA Organic | 2024-06-05T15:11:00Z | CUST0003 | PROD-food-301 | 12 | 7.2 | 6.5 | 0.5 | 0.2 | pickup | USA | USA | Houston | 7.2 | 82.3 |
| TXN00004 | books | 480 | false | blank | 2024-06-08T18:22:00Z | CUST0004 | PROD-books-401 | 3 | 3.4 | 2.6 | 0.6 | 0.2 | standard | USA | USA | Chicago | 0 | 52.95 |
| TXN00005 | home_goods | 1600 | false | blank | 2024-06-10T20:40:00Z | CUST0005 | PROD-home_goods-501 | 1 | 2.9 | 2.1 | 0.7 | 0.1 | overnight | Italy | France | Paris | 0 | 119.99 |
| TXN00006 | toys | 680 | false | blank | 2024-06-11T10:25:00Z | CUST0006 | PROD-toys-601 | 7 | 14.6 | 11.9 | 2.2 | 0.5 | standard | China | Germany | Hamburg | 0 | 89.75 |
| TXN00007 | sports | 2400 | true | blank | 2024-06-12T08:05:00Z | CUST0007 | PROD-sports-701 | 3 | 8.6 | 7.1 | 1.2 | 0.3 | express | USA | Canada | Toronto | 8.6 | 178.55 |
| TXN00008 | electronics | 9000 | false | EPEAT | 2024-06-13T19:00:00Z | CUST0008 | PROD-electronics-102 | 1 | 20.2 | 17.9 | 1.8 | 0.5 | overnight | Japan | USA | Seattle | 0 | 499.99 |
| TXN00009 | apparel | 800 | false | OEKO-TEX | 2024-06-14T11:20:00Z | CUST0009 | PROD-apparel-202 | 14 | 13.7 | 10.6 | 2.7 | 0.4 | standard | Vietnam | Australia | Sydney | 0 | 249.6 |
| TXN00010 | food | 0 | true | FairTrade | 2024-06-15T08:55:00Z | CUST0010 | PROD-food-302 | 1 | 0.9 | 0.7 | 0.1 | 0.1 | pickup | UK | UK | London | 0.9 | 8.5 |
| TXN00011 | books | 1650 | false | blank | 2024-06-03T16:32:00Z | CUST0011 | PROD-books-402 | 6 | 6.3 | 5.5 | 0.6 | 0.2 | express | India | Netherlands | Amsterdam | 0 | 42 |
| TXN00012 | home_goods | 2100 | false | blank | 2024-06-01T11:13:00Z | CUST0012 | PROD-home_goods-502 | 4 | 7.5 | 6.2 | 1.2 | 0.1 | overnight | Germany | Italy | Rome | 0 | 224.99 |
| TXN00013 | toys | 90 | false | blank | 2024-06-07T13:50:00Z | CUST0013 | PROD-toys-602 | 2 | 1.7 | 1.3 | 0.3 | 0.1 | standard | USA | USA | Dallas | 0 | 19.99 |
| TXN00014 | sports | 980 | true | blank | 2024-06-05T21:25:00Z | CUST0014 | PROD-sports-702 | 8 | 16.7 | 13.6 | 2.7 | 0.4 | express | Brazil | USA | Miami | 16.7 | 295 |
| TXN00015 | electronics | 12000 | true | CarbonNeutral | 2024-06-09T07:10:00Z | CUST0015 | PROD-electronics-103 | 100 | 850.5 | 790 | 55 | 5.5 | overnight | China | USA | New York | 850.5 | 10999 |
| TXN00016 | apparel | 110 | false | blank | 2024-06-12T19:30:00Z | CUST0016 | PROD-apparel-203 | 2 | 2.1 | 1.6 | 0.4 | 0.1 | standard | India | India | Delhi | 0 | 39.99 |
| TXN00017 | food | 0 | true | Rainforest Alliance | 2024-06-11T08:45:00Z | CUST0017 | PROD-food-303 | 20 | 13.5 | 11.8 | 1.3 | 0.4 | pickup | Mexico | Mexico | Guadalajara | 13.5 | 199.99 |
| TXN00018 | books | 3100 | false | blank | 2024-06-06T23:55:00Z | CUST0018 | PROD-books-403 | 500 | 400.2 | 370 | 28 | 2.2 | express | UK | USA | Boston | 0 | 3550 |
| TXN00019 | home_goods | 0 | true | blank | 2024-06-03T14:05:00Z | CUST0019 | PROD-home_goods-503 | 1 | 1.25 | 1 | 0.2 | 0.05 | pickup | USA | USA | Phoenix | 1.25 | 29.99 |
| TXN00020 | toys | 0 | false | blank | 2024-06-14T17:50:00Z | CUST0020 | PROD-toys-603 | 1 | 0.8 | 0.7 | 0.1 | 0 | pickup | Canada | Canada | Montreal | 0 | 14.99 |
What the 150 rows show
from the 150-row sampleElectronics (product category) stands out: mean shipping_
- 41%offset_
applied = true - 317.9median shipping_
distance_ km - 5shipping methods
- 16origin countries
- 18destination countries
- 6.5median quantity
Median 317.9, from 0.0 to 21,000.
- string 9
- integer 1
- float 7
- datetime 1
- boolean 1
Columns
19 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
transaction_id | string | Unique identifier for each e-commerce transactionunique | TXN00001 |
customer_id | string | Unique identifier for the customer making the transaction | CUST0001 |
product_id | string | Unique identifier for the product purchased | PROD-electronics-101 |
product_category | string | Category of the product purchased (e.g., electronics, apparel)7 categories | electronics |
shipping_method | string | Method of shipping used for the transaction (e.g., standard, express, overnight)standard · express · overnight · pickup · other | standard |
origin_country | string | Country from which the product was shipped | USA |
destination_country | string | Country to which the product was shipped | USA |
destination_city | string | City to which the product was shippedoptional | San Diego |
sustainability_certification | string | Certification or label indicating sustainability of the product or process (e.g., FSC, CarbonNeutral)10 certifications · optional | EnergyStar |
| Numbers 8 columns | |||
quantity | integer | Number of units of the product purchased in the transaction1 or more | 2 |
carbon_footprint_total_kg | float | Total estimated carbon footprint in kilograms CO2e for the transaction0 or more | 6.3 |
carbon_footprint_product_kg | float | Estimated carbon footprint in kilograms CO2e attributed to the product(s) purchased0 or more | 4.2 |
carbon_footprint_shipping_kg | float | Estimated carbon footprint in kilograms CO2e attributed to shipping and delivery0 or more | 1.7 |
carbon_footprint_packaging_kg | float | Estimated carbon footprint in kilograms CO2e attributed to packaging materials0 or more | 0.4 |
shipping_distance_km | float | Estimated shipping distance in kilometers for the transaction0 or more · optional | 250 |
offset_amount_kg | float | Amount of carbon offset applied in kilograms CO2e0 or more · optional | 6.3 |
transaction_value_usd | float | Total monetary value of the transaction in USD0 or more | 298.99 |
| Dates and times 1 column | |||
transaction_datetime | datetime | Date and time when the transaction occurred | 2024-06-02T13:45:00Z |
| True or false 1 column | |||
offset_applied | boolean | Indicates if carbon offset was applied to this transaction | true |
Use it for
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.
- Transactions150TXN00001250electron…TXN000021200apparelTXN000030food
A software demo
Believable transactions with transaction_
datetime, customer_ id and product_ id to fill a screen in front of a buyer.
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.
- 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.
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