Remote Agency ESG Impact Tracker
This dataset provides a comprehensive view of the environmental impact of marketing agencies with remote and hybrid teams, tracking key ESG metrics such as energy usage, carbon footprint, travel avoided, and digital collaboration across projects. It enables ESG analysts and operations managers to monitor sustainability progress, report on actionable initiatives, and identify opportunities for further improvement.
Sample rows
preview · 8 of 80 rows · all 19 columns| agency_idstring | remote_team_percentagefloat | agency_namestring | team_idstring | team_namestring | project_idstring | project_namestring | project_start_datedate | project_end_datedate | team_sizeinteger | energy_usage_kwhfloat | carbon_footprint_kgco2efloat | travel_avoided_kmfloat | digital_collaboration_hoursfloat | esg_action_takenstring | esg_action_datedate | improvement_opportunitystring | analyst_idstring | analyst_namestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AGENCY001 | 87.5 | GreenWave Marketing | TEAM001 | EcoRemote | PROJ001 | Sustainable Launch | 2023-01-15 | 2023-03-28 | 8 | 320.4 | 75.1 | 540.2 | 210 | Switched to renewable energy suppliers | 2023-02-10 | Implement stricter recycling protocols | ANALYST001 | Tania Lin |
| AGENCY002 | 66.7 | BrightEarth Agency | TEAM002 | HybridForce | PROJ002 | Digital CleanUp | 2022-11-05 | 2022-12-22 | 6 | 175.8 | 42.6 | 385 | 122.5 | Reduced server standby times | 2022-11-24 | Promote sustainable travel incentives | ANALYST002 | Matthew Ray |
| AGENCY003 | 90 | ImpactEdge Media | TEAM003 | VirtuCrew | PROJ003 | EcoBrand Awareness | 2023-04-10 | 2023-06-19 | 10 | 475.2 | 101.8 | 700 | 330 | Paperless campaign workflow | 2023-05-01 | Expand remote onboarding resources | ANALYST003 | Jenna Moss |
| AGENCY004 | 71.4 | EcoPulse Solutions | TEAM004 | RemoteVision | PROJ004 | Low Impact Outreach | 2023-02-01 | 2023-04-08 | 7 | 243.6 | 60.7 | 440 | 185 | Carbon offset purchase | 2023-03-03 | Increase virtual training sessions | ANALYST004 | Ethan Wells |
| AGENCY005 | 77.8 | Sustainix Media | TEAM005 | Hybrid Impact | PROJ005 | Green Content Drive | 2023-05-15 | 2023-07-20 | 9 | 378.9 | 89.5 | 620 | 280 | Switched to cloud-based collaboration | 2023-06-02 | Monitor individual energy usage | ANALYST005 | Priya Singhal |
| AGENCY006 | 100 | BlueSky Agency | TEAM006 | CloudSync | PROJ006 | Virtual Outreach | 2022-08-22 | 2022-10-15 | 5 | 112.3 | 28.9 | 320 | 90.5 | Remote-only project kickoff | 2022-08-25 | Adopt green web hosting | ANALYST006 | Luis Martinez |
| AGENCY007 | 62.5 | NextGen Marketing | TEAM007 | HybridStream | PROJ007 | Eco Messaging Push | 2023-06-05 | 2023-07-30 | 8 | 295.1 | 70.2 | 410 | 170 | Reduced digital ad footprints | 2023-06-18 | Improve remote ergonomics | ANALYST007 | Chioma Okoye |
| AGENCY008 | 85.7 | PulsePoint Creative | TEAM008 | GreenSync | PROJ008 | Renewable Awareness | 2022-12-09 | 2023-02-16 | 7 | 228 | 52.3 | 505 | 160 | Shifted to digital-only client meetings | 2023-01-12 | Automate reporting tools | ANALYST008 | Andrea Voss |
| AGENCY009 | 83.3 | EcoSphere Media | TEAM009 | RemoteMinds | PROJ009 | Green Influence | 2023-03-18 | 2023-05-02 | 6 | 182.4 | 41.7 | 390 | 120 | Promoted low-carbon content strategies | 2023-04-10 | Improve team diversity | ANALYST009 | Simon Lee |
| AGENCY010 | 54.5 | GreenSpark Agency | TEAM010 | EcoConnect | PROJ010 | Hybrid Expansion | 2023-02-27 | 2023-04-10 | 11 | 495.2 | 119.3 | 700 | 340 | Hybrid work policy update | 2023-03-07 | Expand remote training modules | ANALYST010 | Miranda Chen |
| AGENCY011 | 88.9 | EcoPulse Solutions | TEAM011 | VirtuCrew | PROJ011 | Impactful Campaign | 2023-05-04 | 2023-07-11 | 9 | 395.7 | 92.1 | 655 | 290 | Paperless invoicing | 2023-06-09 | Review team communication tools | ANALYST003 | Jenna Moss |
| AGENCY012 | 83.3 | BrightEarth Agency | TEAM012 | EcoRemote | PROJ012 | EcoPartner Connect | 2022-09-18 | 2022-12-02 | 6 | 176.7 | 38.2 | 375 | 115 | Digital-first partner onboarding | 2022-10-20 | Standardize remote meeting protocols | ANALYST002 | Matthew Ray |
| AGENCY013 | 75 | ImpactEdge Media | TEAM013 | RemoteVision | PROJ013 | Greener Messaging | 2023-01-24 | 2023-03-15 | 8 | 325 | 80.3 | 510 | 200 | Low-impact video sharing | 2023-02-18 | Boost digital security | ANALYST004 | Ethan Wells |
| AGENCY014 | 71.4 | Sustainix Media | TEAM014 | CloudSync | PROJ014 | Hybrid Campaign | 2023-02-15 | 2023-04-01 | 7 | 249.2 | 63.9 | 430 | 170 | Digital-only feedback sessions | 2023-03-03 | Encourage energy-saving habits | ANALYST006 | Luis Martinez |
| AGENCY015 | 80 | BlueSky Agency | TEAM015 | Hybrid Impact | PROJ015 | Eco Strategy Push | 2022-11-20 | 2023-01-08 | 10 | 410.5 | 98.3 | 690 | 320 | Virtual brainstorming sessions | 2022-12-05 | Enhance team digital literacy | ANALYST005 | Priya Singhal |
| AGENCY016 | 100 | NextGen Marketing | TEAM016 | HybridForce | PROJ016 | Remote Expansion | 2023-03-29 | 2023-05-15 | 9 | 388.2 | 86.7 | 760 | 250 | Zero travel project launch | 2023-04-11 | Expand eco-friendly onboarding | ANALYST007 | Chioma Okoye |
| AGENCY017 | 62.5 | PulsePoint Creative | TEAM017 | EcoConnect | PROJ017 | Carbon Neutral Push | 2023-04-08 | 2023-05-30 | 8 | 295.8 | 67.9 | 430 | 175 | Carbon offset initiative | 2023-04-29 | Promote green commuting | ANALYST008 | Andrea Voss |
| AGENCY018 | 81.8 | EcoSphere Media | TEAM018 | GreenSync | PROJ018 | Sustainability Drive | 2023-05-21 | 2023-07-02 | 11 | 501.3 | 122.4 | 810 | 390 | Implemented recycling program | 2023-06-13 | Develop green guides for clients | ANALYST009 | Simon Lee |
| AGENCY019 | 58.3 | GreenSpark Agency | TEAM019 | VirtuCrew | PROJ019 | Hybrid Engagement | 2022-07-14 | 2022-09-20 | 12 | 520.7 | 130.1 | 825 | 410 | Updated hybrid work policies | 2022-08-10 | Launch remote wellness programs | ANALYST010 | Miranda Chen |
| AGENCY020 | 88.9 | EcoPulse Solutions | TEAM020 | EcoRemote | PROJ020 | Sustainable Partnership | 2023-06-19 | 2023-08-01 | 9 | 395 | 90.7 | 680 | 265 | Transitioned to remote-first onboarding | 2023-07-10 | Develop team carbon tracking app | ANALYST003 | Jenna Moss |
What the 80 rows show
from the 80-row sample- 77.8median remote_
team_ percentage - 9median team_
size - 391.0median energy_
usage_ kwh - 95.8median carbon_
footprint_ kgco2e - 705.0median travel_
avoided_ km - 182.7median digital_
collaboration_ hours
Median 77.8, from 39.5 to 100.0.
- string 10
- integer 1
- float 5
- date 3
Columns
19 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
agency_id | string | Unique identifier for the marketing agencyunique | AGENCY001 |
agency_name | string | Name of the marketing agency | GreenWave Marketing |
team_id | string | Unique identifier for the remote or hybrid team within the agencyunique | TEAM001 |
team_name | string | Name of the remote or hybrid team | EcoRemote |
project_id | string | Unique identifier for the projectunique | PROJ001 |
project_name | string | Name of the project | Sustainable Launch |
esg_action_taken | string | Description of the main ESG action or initiative taken for the projectoptional | Carbon offset purchase |
improvement_opportunity | string | Description of identified opportunity for further ESG improvementoptional | Adopt green web hosting |
analyst_id | string | Unique identifier for the ESG analyst or operations manager responsible for the project | ANALYST001 |
analyst_name | string | Name of the ESG analyst or operations manager | Tania Lin |
| Numbers 6 columns | |||
team_size | integer | Number of team members working on the project1 or more | 8 |
remote_team_percentage | float | Percentage of team members working remotely0 to 100 | 87.5 |
energy_usage_kwh | float | Total energy usage (in kWh) attributed to the project by the team0 or more | 320.4 |
carbon_footprint_kgco2e | float | Total carbon footprint (in kg CO2 equivalent) for the project0 or more | 75.1 |
travel_avoided_km | float | Total kilometers of travel avoided due to remote or hybrid work for the project0 or more · optional | 540.2 |
digital_collaboration_hours | float | Total hours spent on digital collaboration tools (e.g., video calls, chat, shared docs)0 or more · optional | 210 |
| Dates and times 3 columns | |||
project_start_date | date | Start date of the project | 2023-01-15 |
project_end_date | date | End date of the projectoptional | 2023-03-28 |
esg_action_date | date | Date when the main ESG action or initiative was implementedoptional | 2023-02-10 |
Use it for
A marketing dashboard
Remote_
team_ percentage. Excel, Power BI or Tableau. What pattern can you find in 80 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 80 rows.
- Agencies80AGENCY00187.5AGENCY00266.7AGENCY00390
A software demo
Believable agencies with agency_
name, team_ id and team_ name to fill a screen in front of a buyer.
This dataset80 rows19 columns
Yours1,000 rows19 columns
blueprint · remote-agency-esg-impact-tracker
Behind this dataset
Same schema. As many rows as you need.
These 80 rows came out of a blueprint — 19 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 row represents one project or campaign executed by a remote team.
- Energy consumption is calculated based on reported hours and estimated device usage.
- Travel avoided is measured by comparing virtual meetings to estimated in-person alternatives.
- Carbon footprint is computed using standard emission factors for remote work.
- Digital collaboration tools usage is tracked for compliance and efficiency reporting.
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
- remote-agency-esg-impact-tracker