Marketing Campaign Carbon Audit Log
This dataset provides detailed, activity-level carbon audit logs for marketing campaigns across multiple channels, including estimated emissions, cost, audience size, and ESG reporting status. Designed for sustainability specialists, it enables transparent climate reporting, strategy optimization, and identification of low-impact marketing opportunities.
Sample rows
preview · 8 of 60 rows · all 20 columns| audit_idstring | activity_typestring | estimated_emissions_kg_co2efloat | esg_reportedboolean | campaign_idstring | campaign_namestring | activity_idstring | channelstring | activity_descriptionstring | start_datedate | end_datedate | emission_calculation_methodstring | data_sourcestring | activity_cost_usdfloat | audience_sizeinteger | low_impact_flagboolean | created_atdatetime | updated_atdatetime | auditor_namestring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AUD-1A9B2C8D | social_media | 15.2 | true | CMP-0234 | EcoSpring Launch | ACT-1120 | Paid Facebook ads for launch awareness | 2024-03-01 | 2024-03-07 | GHG Protocol | internal logs | 1200.5 | 25000 | false | 2024-03-08T09:15:00 | 2024-03-09T10:45:00 | Sara Martinez | High engagement, standard campaign reporting | |
| AUD-1A2B3C4D | 1.1 | true | CMP-0235 | Green Future Initiative | ACT-1121 | Mailchimp | Email blast to subscribers | 2024-03-05 | 2024-03-05 | DEFRA 2023 | vendor report | 350 | 8500 | true | 2024-03-05T12:30:00 | 2024-03-05T13:00:00 | Oliver Chen | Minimal emissions, marked low impact | |
| AUD-7F9G2K4L | event | 45 | true | CMP-0234 | EcoSpring Launch | ACT-1122 | Local Hall | Sustainability seminar event | 2024-03-10 | 2024-03-10 | GHG Protocol | internal logs | 3000 | 200 | false | 2024-03-11T08:10:00 | 2024-03-11T09:00:00 | Sara Martinez | Venue required transportation, higher footprint |
| AUD-5H1J2K3L | digital_ad | 7.4 | false | CMP-0236 | ZeroWaste Challenge | ACT-1123 | AdWords campaign for zero waste awareness | 2024-02-20 | 2024-02-28 | DEFRA 2023 | vendor report | 950 | 12000 | true | 2024-02-29T13:20:00 | 2024-02-29T13:45:00 | Amit Gupta | Efficient targeting reduced emissions | |
| AUD-4T6R8Y2U | 28.6 | true | CMP-0237 | Clean Energy Week | ACT-1124 | Local Newspaper | Full-page advertorial | 2024-03-15 | 2024-03-15 | GHG Protocol | vendor report | 2200 | 10000 | false | 2024-03-16T10:00:00 | 2024-03-16T10:30:00 | Linda Evans | Print media generally higher impact | |
| AUD-9U7Y5T3R | event | 72.3 | true | CMP-0238 | Renewables Roadshow | ACT-1125 | Convention Center | Multi-day expo | 2024-03-20 | 2024-03-22 | GHG Protocol | internal logs | 8000 | 1800 | false | 2024-03-23T09:35:00 | 2024-03-23T10:00:00 | Oliver Chen | Travel emissions significant |
| AUD-2X3C4V5B | video | 3.8 | false | CMP-0236 | ZeroWaste Challenge | ACT-1126 | YouTube | Promotional video for challenge launch | 2024-02-21 | 2024-02-21 | DEFRA 2023 | internal logs | 700 | 4000 | true | 2024-02-22T14:00:00 | 2024-02-22T14:21:00 | Amit Gupta | Short format video, limited reach |
| AUD-6K8M2N1P | 0.7 | false | CMP-0239 | Climate Action Month | ACT-1127 | SendGrid | Automated email outreach | 2024-04-01 | 2024-04-01 | GHG Protocol | vendor report | 200 | 5000 | true | 2024-04-01T17:55:00 | 2024-04-01T18:01:00 | Linda Evans | Single day, low impact | |
| AUD-7L4P2O9Q | social_media | 4.1 | true | CMP-0239 | Climate Action Month | ACT-1128 | Organic posts and stories | 2024-04-02 | 2024-04-06 | DEFRA 2023 | internal logs | 300 | 6500 | true | 2024-04-07T09:00:00 | 2024-04-07T09:11:00 | Sara Martinez | Organic reach, efficient | |
| AUD-8Q9W1E3R | digital_ad | 5.7 | true | CMP-0240 | BluePlanet Media Blast | ACT-1129 | Sponsored tweets for campaign | 2024-03-10 | 2024-03-12 | GHG Protocol | vendor report | 800 | 18000 | true | 2024-03-13T13:45:00 | 2024-03-13T14:00:00 | Linda Evans | Good performance, flagged low impact | |
| AUD-3C6V2B4N | 32 | true | CMP-0241 | Solar Choices | ACT-1130 | National Magazine | Magazine advertorial | 2024-03-18 | 2024-03-18 | DEFRA 2023 | vendor report | 3400 | 25000 | false | 2024-03-19T16:00:00 | 2024-03-19T16:10:00 | Oliver Chen | National coverage, higher emissions | |
| AUD-2M4L8K6J | video | 2.3 | false | CMP-0242 | Plastic Free Push | ACT-1131 | TikTok | Short-form influencer video | 2024-03-22 | 2024-03-22 | GHG Protocol | internal logs | 1200 | 9500 | true | 2024-03-23T11:00:00 | 2024-03-23T11:19:00 | Amit Gupta | Influencer partnership, low impact |
| AUD-1Q2W3E4R | social_media | 3.1 | false | CMP-0242 | Plastic Free Push | ACT-1132 | Professional network engagement | 2024-03-23 | 2024-03-24 | DEFRA 2023 | internal logs | 480 | 3500 | true | 2024-03-25T08:00:00 | 2024-03-25T08:15:00 | Linda Evans | Corporate audience, flagged low impact | |
| AUD-8U6Y4T2R | event | 50.2 | true | CMP-0243 | Green Mobility Sprint | ACT-1133 | Green Expo Center | Electric vehicle showcase | 2024-04-05 | 2024-04-06 | GHG Protocol | vendor report | 4500 | 1200 | false | 2024-04-07T10:00:00 | 2024-04-07T10:18:00 | Sara Martinez | Event required travel |
| AUD-7M5N3B1V | digital_ad | 6.8 | false | CMP-0243 | Green Mobility Sprint | ACT-1134 | Search ads for sprint promotion | 2024-04-03 | 2024-04-05 | DEFRA 2023 | internal logs | 1000 | 9000 | true | 2024-04-06T11:00:00 | 2024-04-06T11:22:00 | Oliver Chen | Efficient ad targeting | |
| AUD-4P3O2I1U | 0.9 | false | CMP-0244 | Green Mobility Sprint | ACT-1135 | Outlook | Personalized campaign emails | 2024-04-03 | 2024-04-03 | GHG Protocol | vendor report | 210 | 3200 | true | 2024-04-03T16:00:00 | 2024-04-03T16:16:00 | Linda Evans | Low cost and emissions | |
| AUD-5F6G7H8J | video | 3 | true | CMP-0245 | EcoSpring Launch | ACT-1136 | Live video Q&A | 2024-03-11 | 2024-03-11 | DEFRA 2023 | internal logs | 800 | 5500 | true | 2024-03-12T12:00:00 | 2024-03-12T12:18:00 | Amit Gupta | Live streaming, low footprint | |
| AUD-9H8J7K6L | event | 12.5 | true | CMP-0245 | EcoSpring Launch | ACT-1137 | Park Pavilion | Outdoor launch event | 2024-03-13 | 2024-03-13 | GHG Protocol | vendor report | 2500 | 300 | true | 2024-03-14T09:00:00 | 2024-03-14T09:14:00 | Sara Martinez | Outdoor venue, reduced emissions |
| AUD-8K7J6H5G | 17.9 | false | CMP-0246 | Clean Energy Week | ACT-1138 | Regional Magazine | Half-page advertorial | 2024-03-12 | 2024-03-12 | DEFRA 2023 | vendor report | 1100 | 7000 | false | 2024-03-13T10:00:00 | 2024-03-13T10:07:00 | Linda Evans | Regional focus | |
| AUD-7N6B5V4C | social_media | 2.9 | false | CMP-0246 | Clean Energy Week | ACT-1139 | Event hashtag campaign | 2024-03-16 | 2024-03-17 | GHG Protocol | internal logs | 350 | 10500 | true | 2024-03-18T08:00:00 | 2024-03-18T08:13:00 | Amit Gupta | Viral reach, low emissions |
What the 60 rows show
from the 60-row sampleEvent (activity type) stands out: mean estimated_
- 60%esg_
reported = true - 8.0median estimated_
emissions_ kg_ co2e - 4emission calculation methods
- 4data sources
- 16auditor names
- 895.0median activity_
cost_ usd
Median 8.0, from 0.50 to 112.5.
- string 11
- integer 1
- float 2
- date 2
- datetime 2
- boolean 2
Columns
20 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
audit_id | string | Unique identifier for each carbon audit log entryunique | AUD-1A9B2C8D |
campaign_id | string | Unique identifier for the marketing campaign | CMP-0234 |
campaign_name | string | Name of the marketing campaign | EcoSpring Launch |
activity_id | string | Unique identifier for the specific campaign activity | ACT-1120 |
activity_type | string | Type of marketing activity (e.g., email, social media, print, event)7 values | social_media |
channel | string | Marketing channel used for the activity (e.g., Facebook, Google, TV, Radio) | |
activity_description | string | Detailed description of the campaign activityoptional | Full-page advertorial |
emission_calculation_method | string | Method or standard used to estimate emissions (e.g., GHG Protocol, DEFRA)4 methods · optional | GHG Protocol |
data_source | string | Source of data used for emission estimation (e.g., internal logs, vendor report)4 sources · optional | internal logs |
auditor_name | string | Name of the person or system responsible for the audit entryoptional | Sara Martinez |
notes | string | Additional notes or comments about the audit entryoptional | Single day, low impact |
| Numbers 3 columns | |||
estimated_emissions_kg_co2e | float | Estimated carbon emissions in kilograms of CO2 equivalent for the activity0 or more | 15.2 |
activity_cost_usd | float | Cost of the campaign activity in USD0 or more · optional | 1200.5 |
audience_size | integer | Number of people reached or targeted by the activity0 or more · optional | 25000 |
| Dates and times 4 columns | |||
start_date | date | Start date of the campaign activity | 2024-03-01 |
end_date | date | End date of the campaign activityoptional | 2024-03-07 |
created_at | datetime | Timestamp when the audit log entry was created | 2024-03-08T09:15:00 |
updated_at | datetime | Timestamp when the audit log entry was last updatedoptional | 2024-03-09T10:45:00 |
| True or false 2 columns | |||
esg_reported | boolean | Indicates if this activity's emissions have been included in ESG reporting | true |
low_impact_flag | boolean | Flag indicating if the activity is considered low carbon impactoptional | false |
Use it for
A marketing dashboard
The esg_
reported rate, estimated_ emissions_ kg_ co2e by activity_ type and a breakdown of campaign_ id. Excel, Power BI or Tableau. Why do the 11 event rows have a mean estimated_
emissions_ kg_ co2e of 32.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Audits60AUD-1A9B2C8D15.2social_m…AUD-1A2B3C4D1.1emailAUD-5H1J2K3L7.4digital_…
A software demo
Believable audits with campaign_
id, campaign_ name and activity_ id to fill a screen in front of a buyer.
This dataset60 rows20 columns
Yours1,000 rows20 columns
blueprint · marketing-campaign-carbon-audit-log
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.
Rules it was built with
- Each campaign must record channel, activity type, estimated emissions (kg CO2e), and duration
- Campaigns spanning multiple channels must allocate emissions per channel
- Emissions calculations use standardized factors per channel/activity
- Campaigns missing emission data must be flagged for review
- Include campaign owner and sustainability goal alignment per record
- Only campaigns run within the last 12 months are included
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-carbon-audit-log