Marketing Campaign Sustainability Metrics
This dataset provides a comprehensive view of the environmental impact and resource usage of marketing campaigns, including energy consumption, carbon emissions, waste generation, and use of recycled materials. It enables organizations to track, benchmark, and optimize the sustainability of their marketing efforts, supporting eco-friendly decision-making and compliance with environmental standards.
Sample rows
preview · 8 of 54 rows · all 19 columns| campaign_idstring | eco_certificationstring | waste_generated_kgfloat | channelstring | campaign_namestring | start_datedate | end_datedate | budget_usdfloat | energy_consumed_kwhfloat | carbon_emissions_kgco2efloat | water_usage_litersfloat | recycled_materials_used_kgfloat | renewable_energy_percentfloat | target_audience_sizeinteger | actual_reachinteger | conversion_countinteger | sustainability_officerstring | data_collected_datedatetime | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MC2024-001 | CarbonNeutral | 0 | Spring Email Blast | 2024-03-15 | 2024-03-29 | 7500 | 52.8 | 18.6 | 130 | 0 | 88.2 | 20000 | 17800 | 1560 | Jennifer Wu | 2024-03-30T09:13:00 | Used renewable electricity for all email servers. | |
| MC2024-002 | ISO 14001 | 12.5 | outdoor | Eco Outdoor Billboard | 2024-04-01 | 2024-04-30 | 18000 | 214.5 | 96.1 | 950 | 8 | 55.1 | 50000 | 42000 | 3400 | GreenOps Team | 2024-05-01T17:45:00 | Billboard printed on recycled paper. |
| MC2024-003 | Green Seal | 0.8 | web | Digital Earth Day Push | 2024-04-18 | 2024-04-22 | 9500 | 64.3 | 23.5 | 195.2 | 0 | 90 | 15000 | 13900 | 1200 | Maya Patel | 2024-04-23T10:34:00 | Green hosting provider used. |
| MC2024-004 | blank | 0 | radio | Radio Spot for Change | 2024-03-20 | 2024-03-27 | 4200 | 35.6 | 11.2 | 78 | 0 | 72.6 | 8000 | 4800 | 300 | Lucas Fernandez | 2024-03-28T14:02:00 | Studio runs on partial renewable sources. |
| MC2024-005 | EcoVadis | 0.2 | social_media | April Social Media Drive | 2024-04-04 | 2024-04-14 | 6200 | 48.2 | 15.9 | 85.7 | 0 | 96.5 | 12000 | 11030 | 810 | Ava Robinson | 2024-04-15T18:46:00 | All content scheduled off-peak hours. |
| MC2024-006 | ISO 14001 | 24.7 | tv | TV Ad - Green Initiative | 2024-04-10 | 2024-04-13 | 35000 | 520 | 180.3 | 2100 | 9.8 | 40.3 | 100000 | 88000 | 7300 | Sean O'Connor | 2024-04-13T23:27:00 | Used LED lighting for studio shoots. |
| MC2024-007 | Forest Stewardship Council | 4.6 | Print Flyer Eco Edition | 2024-03-09 | 2024-03-14 | 2400 | 28.7 | 8 | 420 | 3.7 | 61.2 | 3000 | 2700 | 140 | Emily Zhang | 2024-03-14T07:12:00 | Flyers printed with soy-based ink. | |
| MC2024-008 | Green Seal | 0 | web | Web Banner Blitz | 2024-02-26 | 2024-03-05 | 5200 | 33.2 | 10.1 | 60.3 | 0 | 99.5 | 8000 | 7300 | 350 | Ravi Singh | 2024-03-05T13:03:00 | Banner hosted on carbon-neutral servers. |
| MC2024-009 | blank | 0 | radio | March Radio Outreach | 2024-03-10 | 2024-03-15 | 3700 | 27.5 | 9.5 | 62 | 0 | 80.2 | 6200 | 4800 | 250 | Diana Morales | 2024-03-15T19:11:00 | Studio powered by solar for campaign duration. |
| MC2024-010 | EcoVadis | 0.5 | social_media | Spring Social Media Challenge | 2024-03-21 | 2024-04-02 | 8400 | 57.9 | 19.3 | 105.2 | 0 | 92.8 | 16000 | 14800 | 1010 | Olivia Lee | 2024-04-02T16:43:00 | All posts promoted via organic reach. |
| MC2024-011 | blank | 0 | other | Other: Podcast Partnership | 2024-02-20 | 2024-02-25 | 1700 | 15.6 | 5.7 | 22.4 | 0 | 85.6 | 2200 | 1700 | 90 | Elijah Grant | 2024-02-26T11:54:00 | Episodes recorded in green-certified studio. |
| MC2024-012 | Forest Stewardship Council | 21.2 | Eco Print Magazine | 2024-01-15 | 2024-01-30 | 12500 | 173 | 61.2 | 980 | 15 | 36.4 | 19000 | 15800 | 1000 | Priya Nair | 2024-01-31T07:22:00 | Magazine printed on recycled paper. | |
| MC2024-013 | Green Seal | 0.1 | web | Web Video Rollout | 2024-02-08 | 2024-02-16 | 6900 | 41.7 | 14.9 | 66.5 | 0 | 93.7 | 9000 | 8300 | 570 | Sam Carter | 2024-02-16T15:18:00 | Video streaming via CDN with renewable energy. |
| MC2024-014 | blank | 0 | radio | Radio Morning Ad | 2024-02-10 | 2024-02-12 | 2100 | 18.1 | 6.3 | 27.3 | 0 | 79.8 | 3000 | 2200 | 105 | Victor Wang | 2024-02-12T07:14:00 | Short campaign powered by wind energy. |
| MC2024-015 | ISO 14001 | 29.1 | tv | TV Eco Documentary | 2024-01-26 | 2024-02-03 | 41000 | 620.2 | 224.1 | 2600 | 11.5 | 32.7 | 130000 | 121500 | 9400 | Maria Gomez | 2024-02-04T01:43:00 | Documentary production used local suppliers. |
| MC2024-016 | CarbonNeutral | 8 | outdoor | Outdoor Banner March | 2024-03-03 | 2024-03-24 | 14000 | 150.7 | 63.4 | 800 | 3.4 | 67.4 | 35000 | 32100 | 2600 | Nathan Cole | 2024-03-25T08:37:00 | Banner reused for multiple campaigns. |
| MC2024-017 | CarbonNeutral | 0 | Email Newsletter Q1 | 2024-01-05 | 2024-01-05 | 3900 | 14.4 | 4.2 | 18 | 0 | 99.9 | 7000 | 6800 | 460 | Helen Kim | 2024-01-05T10:08:00 | Newsletter sent via green-certified vendor. | |
| MC2024-018 | EcoVadis | 0 | social_media | Social Media Eco Tips | 2024-02-17 | 2024-02-24 | 5400 | 39.3 | 12.8 | 49.6 | 0 | 97.2 | 8000 | 7200 | 410 | Jamal Brooks | 2024-02-25T20:05:00 | Tips shared using recycled media assets. |
| MC2024-019 | Forest Stewardship Council | 2.1 | Print Brochure - Eco Edition | 2024-01-18 | 2024-01-21 | 1800 | 21.5 | 7 | 120 | 1.8 | 52.6 | 2000 | 1700 | 95 | Miriam Fischer | 2024-01-22T09:33:00 | Printed using 100% recycled paper. | |
| MC2024-020 | CarbonNeutral | 3.4 | outdoor | Outdoor Poster - Green Theme | 2024-02-22 | 2024-03-07 | 9500 | 90.8 | 38.6 | 440 | 2.7 | 70.2 | 17000 | 14900 | 980 | Robert Miller | 2024-03-08T10:29:00 | Poster reused for regional event. |
What the 54 rows show
from the 54-row sample- 4.5median waste_
generated_ kg - 9,500median budget_
usd - 115.5median energy_
consumed_ kwh - 48.9median carbon_
emissions_ kgco2e - 295.0median water_
usage_ liters - 2.5median recycled_
materials_ used_ kg
Median 4.5, from 0.0 to 89.0.
- string 6
- integer 3
- float 7
- date 2
- datetime 1
Columns
19 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 6 columns | |||
campaign_id | string | Unique identifier for the marketing campaignunique | MC2024-001 |
campaign_name | string | Descriptive name of the marketing campaign | Spring Email Blast |
channel | string | Primary marketing channel used (e.g., email, social media, print, TV)8 values | |
eco_certification | string | Eco-certification or sustainability standard achieved (e.g., ISO 14001, CarbonNeutral)6 certifications · optional | CarbonNeutral |
sustainability_officer | string | Name of the sustainability officer or team responsible for the campaign's environmental metricsoptional | Jennifer Wu |
notes | string | Additional notes or comments about the campaign's sustainability effortsoptional | Eco-friendly e-commerce. |
| Numbers 10 columns | |||
budget_usd | float | Total budget allocated to the campaign in USD0 or more · optional | 7500 |
energy_consumed_kwh | float | Total energy consumed by the campaign activities (in kilowatt-hours)0 or more · optional | 52.8 |
carbon_emissions_kgco2e | float | Estimated carbon emissions generated by the campaign (in kilograms CO2 equivalent)0 or more · optional | 18.6 |
water_usage_liters | float | Total water usage associated with the campaign (in liters)0 or more · optional | 130 |
waste_generated_kg | float | Total waste generated by the campaign (in kilograms)0 or more · optional | 0 |
recycled_materials_used_kg | float | Amount of recycled materials used in the campaign (in kilograms)0 or more · optional | 0 |
renewable_energy_percent | float | Percentage of campaign energy sourced from renewable resources0 to 100 · optional | 88.2 |
target_audience_size | integer | Number of individuals targeted by the campaign0 or more · optional | 20000 |
actual_reach | integer | Number of individuals actually reached by the campaign0 or more · optional | 17800 |
conversion_count | integer | Number of conversions (desired actions) resulting from the campaign0 or more · optional | 1560 |
| Dates and times 3 columns | |||
start_date | date | Date when the campaign started | 2024-03-15 |
end_date | date | Date when the campaign endedoptional | 2024-03-29 |
data_collected_date | datetime | Timestamp when the sustainability data was collected or last updated | 2024-03-30T09:13:00 |
Use it for
A marketing dashboard
Waste_
generated_ kg by eco_ certification and a breakdown of channel. Excel, Power BI or Tableau. What pattern can you find in 54 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 54 rows.
- Campaigns54MC2024-0010CarbonNe…MC2024-00212.5ISO 14001MC2024-0030.8Green Se…
A software demo
Believable campaigns with campaign_
name, start_ date and end_ date to fill a screen in front of a buyer.
This dataset54 rows19 columns
Yours1,000 rows19 columns
blueprint · marketing-campaign-sustainability-metrics
Behind this dataset
Same schema. As many rows as you need.
These 54 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 one marketing campaign instance.
- Include metrics on energy usage, material type, and waste generated.
- Capture sustainability scoring based on predefined eco-criteria.
- Record campaign duration and channel type.
- Flag campaigns with sustainability compliance issues.
Open the blueprint in Data Factory
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- marketing-campaign-sustainability-metrics