Nonprofit Fundraising Climate Impact Log
This dataset provides detailed tracking of nonprofit fundraising campaigns, individual donations, and their associated climate-related activities and outcomes. It enables organizations to quantify environmental impact, improve transparency, and optimize future campaigns for sustainability and donor engagement. Key features include campaign details, donation transactions, climate activity types, and verified impact metrics.
Sample rows
preview · 8 of 40 rows · all 24 columns| campaign_idstring | climate_impact_metricstring | climate_impact_valuefloat | verified_by_third_partyboolean | climate_activity_location_countrystring | campaign_namestring | campaign_start_datedate | campaign_end_datedate | donation_idstring | donor_idstring | donor_namestring | donor_emailstring | donation_datedatetime | donation_amountfloat | donation_currencystring | climate_activity_idstring | climate_activity_typestring | climate_activity_location_citystring | climate_activity_location_statestring | climate_activity_start_datedate | climate_activity_end_datedate | climate_impact_unitstring | reporting_yearinteger | climate_activity_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CMP001 | trees planted | 400 | true | USA | Green Future Initiative | 2021-03-01 | 2021-06-30 | DON001 | DNR001 | Emily Carter | emily.carter@ | 2021-03-15T10:24:00 | 250 | USD | CA001 | tree planting | Seattle | WA | 2021-03-02 | 2021-06-28 | trees | 2021 | Planted native tree species in local parks. |
| CMP002 | energy generated | 12000 | false | USA | Solar for Schools | 2020-09-01 | 2020-12-10 | DON002 | DNR002 | Rajesh Patel | rajesh.patel@ | 2020-09-11T14:52:00 | 1000 | USD | CA002 | renewable energy | Austin | TX | 2020-09-05 | 2020-12-08 | kWh | 2020 | Installed solar panels on three elementary schools. |
| CMP003 | CO2 reduced | 32.5 | true | Germany | Carbon Offset Drive | 2022-05-05 | 2022-09-01 | DON003 | DNR003 | Monica Rivera | monica.rivera@ | 2022-06-10T09:30:00 | 75 | EUR | CA003 | carbon offset | Berlin | Berlin | 2022-05-06 | 2022-08-25 | tons | 2022 | Offset local business emissions through certified credits. |
| CMP004 | other | 120 | false | USA | Eco Advocacy Month | 2021-11-01 | 2021-11-30 | DON004 | DNR004 | Sarah Kim | sarah.kim@ | 2021-11-05T11:10:00 | 40 | USD | CA004 | advocacy | San Francisco | CA | 2021-11-02 | 2021-11-29 | participants | 2021 | Organized climate rallies and policy workshops. |
| CMP005 | energy generated | 4800 | false | Russia | Clean Energy Access | 2023-02-10 | 2023-06-25 | DON005 | DNR005 | Alexei Ivanov | alexei.ivanov@ | 2023-03-02T18:45:00 | 500 | RUB | CA005 | renewable energy | Krasnodar | Krasnodar Krai | 2023-02-15 | 2023-06-20 | kWh | 2023 | Distributed solar lanterns in rural communities. |
| CMP006 | trees planted | 250 | true | Germany | Urban Forest Project | 2022-03-15 | 2022-07-10 | DON006 | DNR006 | Laura Schmidt | laura.schmidt@ | 2022-03-20T16:20:00 | 150 | EUR | CA006 | tree planting | Hamburg | Hamburg | 2022-03-16 | 2022-07-09 | trees | 2022 | Planted trees in urban neighborhoods. |
| CMP007 | other | 25 | false | USA | Climate Literacy Week | 2021-04-15 | 2021-04-22 | DON007 | DNR007 | Isaac Romero | isaac.romero@ | 2021-04-17T13:35:00 | 60 | USD | CA007 | education | Denver | CO | 2021-04-16 | 2021-04-21 | seminars | 2021 | Hosted climate change seminars in local schools. |
| CMP008 | area restored | 5.2 | true | UK | Wetlands Restoration Fund | 2020-08-01 | 2020-11-30 | DON008 | DNR008 | Yasmine Ahmed | yasmine.ahmed@ | 2020-08-15T10:05:00 | 200 | GBP | CA008 | other | Chelmsford | Essex | 2020-08-03 | 2020-11-25 | hectares | 2020 | Restored natural wetlands in Essex. |
| CMP009 | other | 80 | false | USA | Zero Waste Challenge | 2022-09-01 | 2022-10-15 | DON009 | DNR009 | Megan Lee | megan.lee@ | 2022-09-12T15:00:00 | 35 | USD | CA009 | advocacy | Chicago | IL | 2022-09-02 | 2022-10-14 | stores | 2022 | Launched zero waste campaigns in local stores. |
| CMP010 | CO2 reduced | 14 | true | Italy | Clean Air Action | 2021-01-10 | 2021-03-31 | DON010 | DNR010 | Francesco Rossi | francesco.rossi@ | 2021-02-05T09:15:00 | 150 | EUR | CA010 | carbon offset | Rome | Lazio | 2021-01-12 | 2021-03-30 | tons | 2021 | Purchased offsets for city transport emissions. |
| CMP011 | other | 15 | false | USA | Green Schools Grant | 2023-01-05 | 2023-05-01 | DON011 | DNR011 | Jessica Brown | jessica.brown@ | 2023-01-15T12:40:00 | 350 | USD | CA011 | education | Boston | MA | 2023-01-07 | 2023-04-28 | schools | 2023 | Supported green curriculum in urban schools. |
| CMP012 | trees planted | 1200 | true | Brazil | Reforest the Amazon | 2022-06-01 | 2022-12-31 | DON012 | DNR012 | Ana Souza | ana.souza@ | 2022-07-08T17:25:00 | 1200 | BRL | CA012 | tree planting | Manaus | Amazonas | 2022-06-05 | 2022-12-25 | trees | 2022 | Planted fast-growing native species in the Amazon. |
| CMP013 | area restored | 2.3 | true | USA | Blue Planet Cleanup | 2020-05-01 | 2020-10-01 | DON013 | DNR013 | Logan Stewart | logan.stewart@ | 2020-06-14T10:00:00 | 80 | USD | CA013 | other | San Diego | CA | 2020-05-03 | 2020-09-30 | hectares | 2020 | Cleaned up plastic waste from local beaches. |
| CMP014 | energy generated | 1800 | false | Nigeria | Clean Cooking Solutions | 2021-07-01 | 2021-11-30 | DON014 | DNR014 | Fatima Bello | fatima.bello@ | 2021-09-22T09:50:00 | 220 | NGN | CA014 | renewable energy | Lagos | Lagos | 2021-07-04 | 2021-11-20 | kWh | 2021 | Distributed efficient stoves in local communities. |
| CMP015 | energy generated | 9500 | true | USA | Community Solar Fund | 2022-10-01 | 2023-01-31 | DON015 | DNR015 | George Wang | george.wang@ | 2022-10-10T17:15:00 | 700 | USD | CA015 | renewable energy | Phoenix | AZ | 2022-10-05 | 2023-01-28 | kWh | 2023 | Installed community solar arrays. |
| CMP016 | area restored | 3.6 | false | Mexico | Healthy Rivers Campaign | 2021-05-10 | 2021-09-25 | DON016 | DNR016 | Maria Gonzalez | maria.gonzalez@ | 2021-07-14T08:01:00 | 125 | MXN | CA016 | other | Guadalajara | Jalisco | 2021-05-13 | 2021-09-20 | hectares | 2021 | Removed invasive species from riverbanks. |
| CMP017 | other | 40 | true | Ireland | Climate Policy Advocacy | 2023-03-01 | 2023-05-15 | DON017 | DNR017 | Aiden Murphy | aiden.murphy@ | 2023-04-02T12:30:00 | 90 | EUR | CA017 | advocacy | Dublin | Leinster | 2023-03-03 | 2023-05-10 | meetings | 2023 | Lobbying for stronger climate regulations. |
| CMP018 | trees planted | 180 | false | France | Urban Green Spaces | 2020-04-01 | 2020-07-31 | DON018 | DNR018 | Sophie Dubois | sophie.dubois@ | 2020-05-12T15:12:00 | 80 | EUR | CA018 | tree planting | Paris | Île-de-France | 2020-04-03 | 2020-07-29 | trees | 2020 | Expanded green spaces in city districts. |
| CMP019 | other | 10 | true | USA | Climate Education Forums | 2023-05-01 | 2023-05-31 | DON019 | DNR019 | Hannah Smith | h.smith@ | 2023-05-07T10:45:00 | 55 | USD | CA019 | education | Minneapolis | MN | 2023-05-02 | 2023-05-30 | forums | 2023 | Held public forums on climate science. |
| CMP020 | trees planted | 900 | true | Indonesia | Mangrove Restoration Project | 2021-10-01 | 2022-01-31 | DON020 | DNR020 | Siti Rahman | siti.rahman@ | 2021-11-10T14:00:00 | 180 | IDR | CA020 | tree planting | Surabaya | East Java | 2021-10-03 | 2022-01-28 | trees | 2022 | Restored mangrove forests along coastal areas. |
What the 40 rows show
from the 40-row sample- 50%verified_
by_ third_ party = true - 33.3median climate_
impact_ value - 6climate activity types
- 12donation currencies
- 170median donation_
amount
Median 33.3, from 2.3 to 12,000.
- string 15
- integer 1
- float 2
- date 4
- datetime 1
- boolean 1
Columns
24 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
campaign_id | string | Unique identifier for each fundraising campaignunique | CMP001 |
campaign_name | string | Name of the fundraising campaign | Green Future Initiative |
donation_id | string | Unique identifier for each donation transactionunique | DON001 |
donor_id | string | Unique identifier for the donor | DNR001 |
donor_name | string | Full name of the donoroptional | Emily Carter |
donor_email | string | Email address of the donoroptional | rajesh.patel@ |
donation_currency | string | Currency code of the donation (ISO 4217)12 currencies | USD |
climate_activity_id | string | Unique identifier for the climate-related activity or project | CA001 |
climate_activity_type | string | Type of climate activity (e.g., tree planting, renewable energy, carbon offset)6 values | tree planting |
climate_activity_description | string | Detailed description of the climate-related activityoptional | Planted native tree speci… |
climate_activity_location_city | string | City where the climate activity took placeoptional | Seattle |
climate_activity_location_state | string | State or region where the climate activity took placeoptional | WA |
climate_activity_location_country | string | Country where the climate activity took placeoptional | USA |
climate_impact_metric | string | Type of climate impact measured (e.g., CO2 reduced, trees planted)5 values | trees planted |
climate_impact_unit | string | Unit of measurement for the climate impact (e.g., tons, trees, kWh, hectares) | trees |
| Numbers 3 columns | |||
donation_amount | float | Amount donated in the transaction0.01 or more | 250 |
climate_impact_value | float | Numeric value of the climate impact (e.g., tons of CO2, number of trees)0 or more | 400 |
reporting_year | integer | Year for which the climate impact is reported2,000 to 2,100 | 2021 |
| Dates and times 5 columns | |||
campaign_start_date | date | Start date of the fundraising campaign | 2021-03-01 |
campaign_end_date | date | End date of the fundraising campaign | 2021-06-30 |
donation_date | datetime | Date and time when the donation was made | 2021-03-15T10:24:00 |
climate_activity_start_date | date | Start date of the climate activityoptional | 2021-03-02 |
climate_activity_end_date | date | End date of the climate activityoptional | 2021-06-28 |
| True or false 1 column | |||
verified_by_third_party | boolean | Indicates if the climate impact was verified by a third partyoptional | true |
Use it for
An energy dashboard
The verified_
by_ third_ party rate, climate_ impact_ value by climate_ impact_ metric and a breakdown of climate_ activity_ location_ country. Excel, Power BI or Tableau. Why do 20 of 40 rows have verified_
by_ third_ party = true? A class exercise
Hand out the rows and one question. Everyone works from the same 40 rows.
- Campaigns40CMP001400trees pl…CMP00212000energy g…CMP00332.5CO2 redu…
A software demo
Believable campaigns with campaign_
name, campaign_ start_ date and campaign_ end_ date to fill a screen in front of a buyer.
This dataset40 rows24 columns
Yours1,000 rows24 columnsclimate_activity_location_city: UK only
blueprint · nonprofit-fundraising-climate-impact-log
Behind this dataset
Same schema. As many rows as you need.
These 40 rows came out of a blueprint — 24 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 record must include associated climate-positive actions (e.g., tree planting, carbon offsets).
- Log both donation amounts and estimated emissions reductions per campaign.
- Capture campaign duration, type (virtual/in-person), and region.
- Include post-campaign assessment of environmental outcomes.
- Flag campaigns with missing climate impact data.
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
- nonprofit-fundraising-climate-impact-log