Eco-Friendly Ad Campaign Audit Log

This dataset provides a detailed audit log of digital marketing campaigns, capturing sustainability practices, carbon emissions, and eco-certifications across channels and partners. It empowers ESG managers and marketing teams to monitor, report, and optimize the environmental impact of advertising operations for improved compliance and brand reputation.

  • last updated 1 Feb 2026
  • by GoMask
The brief that made it

Track and report the carbon footprint of digital marketing campaigns for ESG compliance

Sample rows

preview · 8 of 42 rows · all 18 columns
audit_log_idstringesg_manager_idstringclicksintegerrenewable_energy_usedbooleanpartner_namestringcampaign_idstringcampaign_namestringchannelstringstart_datedateend_datedateimpressionsintegerspend_usdfloatcarbon_emissions_kgfloatsustainable_partnersbooleaneco_certificationstringesg_manager_namestringaudit_timestampdatetimenotesstring
AL-00001ESG-0013400trueEcoAds AgencyCMP-1001Green Spring Launchsocial_media2024-03-152024-04-141200008500.5189.2trueAd Net ZeroLisa Green2024-04-15T11:24:02Renewables used for all ad servers.
AL-00002ESG-0022100falseSustainDigitalCMP-1002Earth Day Email Blastemail2024-04-012024-04-2252000420065.4falseblankRajiv Patel2024-04-23T09:02:10Higher carbon due to non-renewable hosting.
AL-00003ESG-0012950trueEcoFind PartnersCMP-1001Green Spring Launchsearch2024-03-202024-04-12980007850.75143.1trueGreen MarkLisa Green2024-04-13T15:10:31Search partner is Green Mark certified.
AL-00004ESG-0036200falseGreenFrames StudioCMP-1003Eco Product Video Adsvideo2024-02-102024-03-0521000013400.9290.6trueblankMarina Lopes2024-03-07T16:42:55Partner studio is sustainable, but video hosting not on renewables.
AL-00005ESG-0041100trueGreenAffiliatesCMP-1004Affiliate Eco Shoppingaffiliate2024-01-252024-02-14410002100.7543.9trueEcoMedia CertifiedSophie Walker2024-02-15T13:20:15Affiliate network is EcoMedia certified.
AL-00006ESG-0022750trueBannerBrightCMP-1005Display Sustainability Bannerdisplay2024-04-182024-05-10860003990110.3falseAd Net ZeroRajiv Patel2024-05-11T10:10:41Ad servers on renewables, but partner lacks certification.
AL-00007ESG-0032100falseEcoFind PartnersCMP-1006Eco-Friendly Search Adssearch2024-02-212024-03-10740003550.290.2falseblankMarina Lopes2024-03-11T14:01:27No renewables, higher carbon.
AL-00008ESG-0013150trueBannerBrightCMP-1007Spring Eco Displaydisplay2024-03-272024-04-19960004200.5125.7trueGreen MarkLisa Green2024-04-20T09:45:33Display campaign fully green certified.

What the 42 rows show

from the 42-row sample

ESG-004 (esg manager id) stands out: mean clicks is 975.5, against 2,253 for the rest.

  • 48%renewable_energy_used = true
  • 1,700median clicks
  • 3eco certifications
  • 4esg manager names
  • 7channels
  • 54,000median impressions
Mean clicks by esg_manager_id42 rows
02,0004,0001,886ESG-00211 rows2,709ESG-00311 rows975.5ESG-00411 rows2,146ESG-0019 rows
clicks42 rows, in bands of 1,000
0714101411510104,0007,000clicks →

Median 1,700, from 250 to 6,200.

partner_name40 rows with a value · 2 left blank
  1. EcoFind Partners8
  2. BannerBright8
  3. GreenFrames Studio6
  4. EcoAds Agency5
  5. GreenAffiliates5
  6. Sustainable Partners Inc.4
  7. EcoMail Partners3
  8. SustainDigital1
18 columns by typefrom the column list below
  • string 9
  • integer 2
  • float 2
  • date 2
  • datetime 1
  • boolean 2

Columns

18 columns in four groups
blueprint · 18 columns
columntypedescriptionexample
Text 9 columns
audit_log_idstringUnique identifier for each audit log entryuniqueAL-00001
campaign_idstringUnique identifier for the digital marketing campaignCMP-1001
campaign_namestringName of the marketing campaignGreen Spring Launch
channelstringMarketing channel used (e.g., social media, email, search, display)7 valuessocial_media
partner_namestringName of the external partner or agency involved in the campaign8 names · optionalEcoAds Agency
eco_certificationstringName of any eco-certification(s) associated with the campaign (e.g., Ad Net Zero, Green Mark)3 certifications · optionalAd Net Zero
esg_manager_idstringIdentifier for the ESG manager responsible for the campaign audit4 managersESG-001
esg_manager_namestringFull name of the ESG manager responsible for the campaign audit4 names · optionalLisa Green
notesstringAdditional comments or observations from the auditoptionalAll partners certified.
Numbers 4 columns
impressionsintegerTotal number of ad impressions served in the campaign0 or more · optional120000
clicksintegerTotal number of ad clicks generated by the campaign0 or more · optional3400
spend_usdfloatTotal spend on the campaign in US dollars0 or more · optional8500.5
carbon_emissions_kgfloatEstimated carbon emissions (in kilograms CO2e) attributed to the campaign0 or more189.2
Dates and times 3 columns
start_datedateCampaign start date2024-03-15
end_datedateCampaign end date2024-04-14
audit_timestampdatetimeTimestamp when the audit log entry was created2024-04-15T11:24:02
True or false 2 columns
renewable_energy_usedbooleanIndicates if renewable energy was used for campaign deliverytrue
sustainable_partnersbooleanIndicates if all partners involved are certified as sustainableoptionaltrue

Use it for

  • renewable ener…48%20 of 42 rowsmean clicks by esg ma…1.9kESG-…2.7kESG-…975.5ESG-…2.1kESG-…

    A marketing dashboard

    The renewable_energy_used rate, clicks by esg_manager_id and a breakdown of partner_name. Excel, Power BI or Tableau.

  • Why do the 11 ESG-004 rows have a mean clicks of 975.5?

    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 audit logs with campaign_id, campaign_name and channel to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset42 rows18 columns
Yours10,000 rows18 columns

blueprint · eco-friendly-ad-campaign-audit-log

Behind this dataset

Same schema. As many rows as you need.

These 42 rows came out of a blueprint — 18 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
  • Record each campaign's launch, platform, duration, and reach.
  • Log estimated emissions for campaign formats (video, display, social, email).
  • Capture use of green-certified ad tech or partners.
  • Flag campaigns exceeding defined carbon thresholds.
  • Include corrective actions for non-compliant campaigns.
  • Store all data for post-campaign ESG reporting.
Rows
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
eco-friendly-ad-campaign-audit-log

What should your data show?

Preview 20 rows free
No signup. No card.