Marketing Campaign Carbon Footprint Analysis
This dataset provides granular, campaign-level insights into the carbon emissions and energy consumption of digital marketing activities across multiple channels. It enables ESG officers and marketing leaders to benchmark, optimize, and report on the environmental impact of their campaigns, supporting sustainable brand communication and regulatory compliance. Key features include per-channel emissions, performance metrics, and ESG compliance status for robust sustainability analytics.
Sample rows
preview · 8 of 60 rows · all 20 columns| campaign_idstring | channelstring | impressionsinteger | brand_namestring | campaign_namestring | start_datedate | end_datedate | regionstring | clicksinteger | conversionsinteger | total_carbon_emissions_kgco2efloat | carbon_emissions_per_impression_kgco2efloat | carbon_emissions_per_click_kgco2efloat | carbon_emissions_per_conversion_kgco2efloat | energy_consumed_kwhfloat | data_transferred_gbfloat | esg_compliance_statusstring | reporting_periodstring | benchmark_groupstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CMP001 | social_media | 185000 | EcoGlow | Spring Fresh Launch | 2024-03-05 | 2024-03-28 | North America | 8200 | 430 | 620.3 | 0.0034 | 0.0756 | 1.4426 | 1282.5 | 575.3 | compliant | Q1 2024 | industry average | Utilized environmentally friendly ad servers. |
| CMP002 | 43000 | PureNest | Green Living Email Blast | 2024-04-02 | 2024-04-09 | Europe | 3100 | 120 | 88.6 | 0.0021 | 0.0286 | 0.7383 | 210.2 | 92.7 | compliant | 2024-04 | internal target | High open rate; optimized subject lines for engagement. | |
| CMP003 | video | 91000 | SunCharge | Solar Power Video Ad | 2024-02-15 | 2024-03-03 | Asia Pacific | 5900 | 310 | 378.9 | 0.0042 | 0.0642 | 1.2223 | 850.6 | 480.4 | pending | Q1 2024 | industry average | Heavy video streaming contributed to higher emissions. |
| CMP004 | affiliate | 22000 | EcoGlow | Eco Deals Affiliate Push | 2024-03-20 | 2024-04-04 | Latin America | 1700 | 60 | 63.2 | 0.0029 | 0.0372 | 1.0533 | 145.4 | 62.8 | compliant | 2024-03 | internal target | blank |
| CMP005 | display | 48000 | PureNest | PureNest Display Awareness | 2024-01-10 | 2024-02-07 | North America | 2100 | 95 | 101.8 | 0.0021 | 0.0485 | 1.0716 | 243.7 | 110.1 | compliant | Q1 2024 | industry average | Display campaign with reduced frequency capping. |
| CMP006 | search | 65000 | SunCharge | SunCharge Search Boost | 2024-04-15 | 2024-04-28 | Europe | 4900 | 180 | 117.3 | 0.0018 | 0.0239 | 0.6517 | 301.2 | 134.9 | pending | 2024-04 | internal target | Improved keyword targeting. |
| CMP007 | social_media | 210000 | EcoGlow | EcoGlow April Social | 2024-04-01 | 2024-04-30 | Asia Pacific | 9800 | 520 | 742.7 | 0.0035 | 0.0758 | 1.4282 | 1486.3 | 682.7 | compliant | Q2 2024 | industry average | Influencer partnerships increased reach. |
| CMP008 | 37000 | PureNest | PureNest March Email | 2024-03-10 | 2024-03-14 | North America | 3100 | 140 | 77.2 | 0.0021 | 0.0249 | 0.5516 | 183.3 | 81.1 | compliant | 2024-03 | industry average | Short campaign duration; high engagement. | |
| CMP009 | display | 51000 | EcoGlow | EcoGlow Display Q2 | 2024-04-10 | 2024-04-19 | Europe | 2600 | 110 | 106.5 | 0.0021 | 0.041 | 0.9682 | 254.8 | 118.4 | compliant | Q2 2024 | industry average | blank |
| CMP010 | affiliate | 17000 | SunCharge | SunCharge Affiliate Outreach | 2024-02-01 | 2024-02-19 | Asia Pacific | 1400 | 55 | 52.8 | 0.0031 | 0.0377 | 0.96 | 123.1 | 55.6 | compliant | 2024-02 | internal target | Low conversion rate attributed to regional factors. |
| CMP011 | video | 99000 | SunCharge | SunCharge Video Brand | 2024-03-11 | 2024-03-29 | Europe | 6500 | 350 | 410.7 | 0.0041 | 0.0632 | 1.1734 | 924.4 | 521.2 | pending | Q1 2024 | industry average | Creative assets optimized for mobile streaming. |
| CMP012 | search | 59000 | EcoGlow | EcoGlow Search Eco | 2024-04-05 | 2024-04-20 | North America | 4700 | 210 | 110.2 | 0.0019 | 0.0234 | 0.5248 | 283.5 | 127.6 | compliant | 2024-04 | internal target | blank |
| CMP013 | social_media | 154000 | PureNest | PureNest Social Buzz | 2024-03-20 | 2024-04-01 | Europe | 5700 | 320 | 515.8 | 0.0033 | 0.0905 | 1.612 | 1061.2 | 468.3 | compliant | Q1 2024 | industry average | Social buzz driven by UGC. |
| CMP014 | display | 42000 | EcoGlow | EcoGlow Display Impact | 2024-04-15 | 2024-05-02 | Asia Pacific | 1900 | 87 | 95.2 | 0.0023 | 0.0501 | 1.0943 | 228.3 | 102.6 | pending | Q2 2024 | industry average | blank |
| CMP015 | 32000 | SunCharge | SunCharge March Email | 2024-03-01 | 2024-03-12 | Latin America | 2500 | 98 | 75.5 | 0.0024 | 0.0302 | 0.7704 | 176.3 | 75.2 | compliant | 2024-03 | internal target | Local language content increased engagement. | |
| CMP016 | display | 38000 | PureNest | PureNest Display Spring | 2024-03-13 | 2024-03-29 | Europe | 1600 | 70 | 87.2 | 0.0023 | 0.0545 | 1.2457 | 209.3 | 93.7 | pending | Q1 2024 | industry average | blank |
| CMP017 | social_media | 105000 | SunCharge | SunCharge Social April | 2024-04-01 | 2024-04-30 | Latin America | 6300 | 210 | 389.1 | 0.0037 | 0.0618 | 1.8529 | 801.7 | 353.6 | compliant | Q2 2024 | internal target | Targeted local influencers. |
| CMP018 | affiliate | 18000 | EcoGlow | EcoGlow Affiliate Spring | 2024-03-05 | 2024-03-22 | Europe | 1250 | 54 | 48.1 | 0.0027 | 0.0385 | 0.8907 | 111.2 | 50.9 | compliant | 2024-03 | industry average | blank |
| CMP019 | video | 78000 | PureNest | PureNest Video March | 2024-03-04 | 2024-03-25 | North America | 4700 | 190 | 335.2 | 0.0043 | 0.0713 | 1.7642 | 720.9 | 402.1 | pending | Q1 2024 | industry average | Video optimized for low bitrate streaming. |
| CMP020 | search | 57000 | SunCharge | SunCharge Search April | 2024-04-03 | 2024-04-19 | Asia Pacific | 4300 | 185 | 107.6 | 0.0019 | 0.025 | 0.5816 | 276.8 | 124.2 | compliant | Q2 2024 | internal target | blank |
What the 60 rows show
from the 60-row sampleSocial_
- 20,650median impressions
- 2esg compliance statuses
- 2benchmark groups
- 9reporting periods
- 2,100median clicks
- 115median conversions
Median 20,650, from 3,900 to 210,000.
- string 9
- integer 3
- float 6
- date 2
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
campaign_id | string | Unique identifier for the marketing campaign.unique | CMP001 |
campaign_name | string | Name or title of the marketing campaign. | Spring Fresh Launch |
brand_name | string | Name of the brand associated with the campaign. | EcoGlow |
channel | string | Digital channel used for the campaign (e.g., email, social media, search, display, video).7 values | social_media |
region | string | Geographic region or market targeted by the campaign.optional | North America |
esg_compliance_status | string | Status of ESG (Environmental, Social, Governance) compliance for the campaign.compliant · non_compliant · pending · not_applicable · optional | compliant |
reporting_period | string | Reporting period for the campaign (e.g., Q1 2024, 2023-06).9 periods · optional | Q1 2024 |
benchmark_group | string | Benchmark group or segment for comparison (e.g., industry average, internal target).2 groups · optional | industry average |
notes | string | Additional notes or qualitative context about the campaign or its carbon footprint.optional | Utilized environmentally … |
| Numbers 9 columns | |||
impressions | integer | Number of times the campaign content was displayed.0 or more · optional | 185000 |
clicks | integer | Number of clicks generated by the campaign.0 or more · optional | 8200 |
conversions | integer | Number of desired actions (e.g., purchases, sign-ups) resulting from the campaign.0 or more · optional | 430 |
total_carbon_emissions_kgco2e | float | Total carbon emissions generated by the campaign in kilograms of CO2 equivalent.0 or more | 620.3 |
carbon_emissions_per_impression_kgco2e | float | Average carbon emissions per impression in kilograms of CO2 equivalent.0 or more · optional | 0.0034 |
carbon_emissions_per_click_kgco2e | float | Average carbon emissions per click in kilograms of CO2 equivalent.0 or more · optional | 0.0756 |
carbon_emissions_per_conversion_kgco2e | float | Average carbon emissions per conversion in kilograms of CO2 equivalent.0 or more · optional | 1.4426 |
energy_consumed_kwh | float | Total estimated energy consumed by the campaign in kilowatt-hours.0 or more · optional | 1282.5 |
data_transferred_gb | float | Total volume of data transferred (e.g., ad impressions, video streaming) in gigabytes.0 or more · optional | 575.3 |
| Dates and times 2 columns | |||
start_date | date | Start date of the campaign. | 2024-03-05 |
end_date | date | End date of the campaign. | 2024-03-28 |
Use it for
A marketing dashboard
Impressions by channel and a breakdown of brand_
name. Excel, Power BI or Tableau. Why do the 10 social_
media rows have a mean impressions of 101,540? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Campaigns60CMP001185000social_m…CMP00243000emailCMP00391000video
A software demo
Believable campaigns with campaign_
name, brand_ name and start_ date to fill a screen in front of a buyer.
blueprint · marketing-campaign-carbon-footprint-analysis
Behind this dataset
Same schema. As many rows as you need.
These 60 rows came out of a blueprint — 20 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 single campaign and channel
- Carbon emission estimates calculated using media spend and channel energy intensity
- Includes campaign type (email, social, video, display), audience reach, and engagement rate
- Flags campaigns exceeding ESG threshold for review
- Start and end dates must be within current fiscal year
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-carbon-footprint-analysis