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.
Sample rows
preview · 8 of 42 rows · all 18 columns| audit_log_idstring | esg_manager_idstring | clicksinteger | renewable_energy_usedboolean | partner_namestring | campaign_idstring | campaign_namestring | channelstring | start_datedate | end_datedate | impressionsinteger | spend_usdfloat | carbon_emissions_kgfloat | sustainable_partnersboolean | eco_certificationstring | esg_manager_namestring | audit_timestampdatetime | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AL-00001 | ESG-001 | 3400 | true | EcoAds Agency | CMP-1001 | Green Spring Launch | social_media | 2024-03-15 | 2024-04-14 | 120000 | 8500.5 | 189.2 | true | Ad Net Zero | Lisa Green | 2024-04-15T11:24:02 | Renewables used for all ad servers. |
| AL-00002 | ESG-002 | 2100 | false | SustainDigital | CMP-1002 | Earth Day Email Blast | 2024-04-01 | 2024-04-22 | 52000 | 4200 | 65.4 | false | blank | Rajiv Patel | 2024-04-23T09:02:10 | Higher carbon due to non-renewable hosting. | |
| AL-00003 | ESG-001 | 2950 | true | EcoFind Partners | CMP-1001 | Green Spring Launch | search | 2024-03-20 | 2024-04-12 | 98000 | 7850.75 | 143.1 | true | Green Mark | Lisa Green | 2024-04-13T15:10:31 | Search partner is Green Mark certified. |
| AL-00004 | ESG-003 | 6200 | false | GreenFrames Studio | CMP-1003 | Eco Product Video Ads | video | 2024-02-10 | 2024-03-05 | 210000 | 13400.9 | 290.6 | true | blank | Marina Lopes | 2024-03-07T16:42:55 | Partner studio is sustainable, but video hosting not on renewables. |
| AL-00005 | ESG-004 | 1100 | true | GreenAffiliates | CMP-1004 | Affiliate Eco Shopping | affiliate | 2024-01-25 | 2024-02-14 | 41000 | 2100.75 | 43.9 | true | EcoMedia Certified | Sophie Walker | 2024-02-15T13:20:15 | Affiliate network is EcoMedia certified. |
| AL-00006 | ESG-002 | 2750 | true | BannerBright | CMP-1005 | Display Sustainability Banner | display | 2024-04-18 | 2024-05-10 | 86000 | 3990 | 110.3 | false | Ad Net Zero | Rajiv Patel | 2024-05-11T10:10:41 | Ad servers on renewables, but partner lacks certification. |
| AL-00007 | ESG-003 | 2100 | false | EcoFind Partners | CMP-1006 | Eco-Friendly Search Ads | search | 2024-02-21 | 2024-03-10 | 74000 | 3550.2 | 90.2 | false | blank | Marina Lopes | 2024-03-11T14:01:27 | No renewables, higher carbon. |
| AL-00008 | ESG-001 | 3150 | true | BannerBright | CMP-1007 | Spring Eco Display | display | 2024-03-27 | 2024-04-19 | 96000 | 4200.5 | 125.7 | true | Green Mark | Lisa Green | 2024-04-20T09:45:33 | Display campaign fully green certified. |
| AL-00009 | ESG-004 | 900 | false | Sustainable Partners Inc. | CMP-1008 | Eco Partner Outreach | other | 2024-03-01 | 2024-03-15 | 31000 | 1700 | 40.4 | true | blank | Sophie Walker | 2024-03-16T11:33:18 | Partner sustainable, but hosting not green. |
| AL-00010 | ESG-003 | 4300 | true | GreenFrames Studio | CMP-1009 | Video Green Initiative | video | 2024-02-05 | 2024-02-24 | 150000 | 9900.35 | 225.8 | true | Green Mark | Marina Lopes | 2024-02-25T12:54:17 | Video campaign certified green. |
| AL-00011 | ESG-002 | 1800 | false | EcoMail Partners | CMP-1010 | Eco Email Test | 2024-03-12 | 2024-03-27 | 54000 | 2450.3 | 62.7 | false | blank | Rajiv Patel | 2024-03-28T17:14:22 | Mail hosting on standard servers. | |
| AL-00012 | ESG-001 | 1200 | true | BannerBright | CMP-1011 | Eco Display 2024 | display | 2024-01-14 | 2024-01-30 | 48000 | 1850.45 | 35.6 | false | Ad Net Zero | Lisa Green | 2024-01-31T08:23:14 | Carbon low due to renewables. |
| AL-00013 | ESG-004 | 950 | false | GreenAffiliates | CMP-1012 | Eco Affiliate Push | affiliate | 2024-01-20 | 2024-02-05 | 39000 | 1920.8 | 40.8 | false | blank | Sophie Walker | 2024-02-06T11:07:16 | Standard hosting, no green efforts. |
| AL-00014 | ESG-002 | 800 | true | blank | CMP-1013 | Eco Email 2 | 2024-04-02 | 2024-04-15 | 32000 | 950.25 | 28.2 | false | Green Mark | Rajiv Patel | 2024-04-16T10:16:23 | Small email test on renewable server. | |
| AL-00015 | ESG-002 | 2150 | false | EcoAds Agency | CMP-1002 | Earth Day Email Blast | social_media | 2024-04-01 | 2024-04-22 | 67000 | 3870.6 | 72.6 | true | blank | Rajiv Patel | 2024-04-23T09:55:41 | Partner agency is sustainable. |
| AL-00016 | ESG-004 | 1600 | true | GreenAffiliates | CMP-1014 | Sustainable Shopping | affiliate | 2024-03-18 | 2024-04-09 | 58000 | 3250.2 | 56.7 | true | EcoMedia Certified | Sophie Walker | 2024-04-10T14:50:12 | All partners certified. |
| AL-00017 | ESG-003 | 3400 | false | EcoFind Partners | CMP-1015 | Eco Search Booster | search | 2024-05-01 | 2024-05-20 | 102000 | 8900.8 | 170.2 | false | blank | Marina Lopes | 2024-05-21T10:34:51 | No green efforts noted. |
| AL-00018 | ESG-003 | 3800 | true | BannerBright | CMP-1003 | Eco Product Video Ads | display | 2024-02-10 | 2024-03-05 | 92000 | 6100 | 120.1 | true | Green Mark | Marina Lopes | 2024-03-07T17:24:19 | Display partner certified. |
| AL-00019 | ESG-001 | 1400 | false | GreenFrames Studio | CMP-1016 | Eco Video Week | video | 2024-04-01 | 2024-04-08 | 47000 | 3200.35 | 53.7 | true | blank | Lisa Green | 2024-04-09T12:01:03 | Partner studio is sustainable. |
| AL-00020 | ESG-004 | 750 | false | EcoMail Partners | CMP-1004 | Affiliate Eco Shopping | 2024-01-25 | 2024-02-14 | 28000 | 850 | 22.6 | false | blank | Sophie Walker | 2024-02-15T14:13:29 | No green hosting. |
What the 42 rows show
from the 42-row sampleESG-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
Median 1,700, from 250 to 6,200.
- string 9
- integer 2
- float 2
- date 2
- datetime 1
- boolean 2
Columns
18 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
audit_log_id | string | Unique identifier for each audit log entryunique | AL-00001 |
campaign_id | string | Unique identifier for the digital marketing campaign | CMP-1001 |
campaign_name | string | Name of the marketing campaign | Green Spring Launch |
channel | string | Marketing channel used (e.g., social media, email, search, display)7 values | social_media |
partner_name | string | Name of the external partner or agency involved in the campaign8 names · optional | EcoAds Agency |
eco_certification | string | Name of any eco-certification(s) associated with the campaign (e.g., Ad Net Zero, Green Mark)3 certifications · optional | Ad Net Zero |
esg_manager_id | string | Identifier for the ESG manager responsible for the campaign audit4 managers | ESG-001 |
esg_manager_name | string | Full name of the ESG manager responsible for the campaign audit4 names · optional | Lisa Green |
notes | string | Additional comments or observations from the auditoptional | All partners certified. |
| Numbers 4 columns | |||
impressions | integer | Total number of ad impressions served in the campaign0 or more · optional | 120000 |
clicks | integer | Total number of ad clicks generated by the campaign0 or more · optional | 3400 |
spend_usd | float | Total spend on the campaign in US dollars0 or more · optional | 8500.5 |
carbon_emissions_kg | float | Estimated carbon emissions (in kilograms CO2e) attributed to the campaign0 or more | 189.2 |
| Dates and times 3 columns | |||
start_date | date | Campaign start date | 2024-03-15 |
end_date | date | Campaign end date | 2024-04-14 |
audit_timestamp | datetime | Timestamp when the audit log entry was created | 2024-04-15T11:24:02 |
| True or false 2 columns | |||
renewable_energy_used | boolean | Indicates if renewable energy was used for campaign delivery | true |
sustainable_partners | boolean | Indicates if all partners involved are certified as sustainableoptional | true |
Use it for
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.
- Audit logs42AL-000013400ESG-001AL-000022100ESG-002AL-000032950ESG-001
A software demo
Believable audit logs with campaign_
id, campaign_ name and channel to fill a screen in front of a buyer.
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.
- 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.
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