ESGLens: An LLM-Based RAG Framework for Interactive ESG Report Analysis and Score Prediction
Organizations: Massachusetts Institute of Technology
Abstract
Environmental, Social, and Governance (ESG) reports are central to investment decision-making, yet their length, heterogeneous content, and lack of standardized structure make manual analysis costly and inconsistent. We present ESGLens, a proof-of-concept framework combining retrieval-augmented generation (RAG) with prompt-engineered extraction to automate three tasks: (1)~structured information extraction guided by Global Reporting Initiative (GRI) standards, (2)interactive question-answering with source traceability, and (3)1000 indices (fiscal year 2022). Among three embedding methods (ChatGPT, BERT, RoBERTa) and two regressors (Neural Network, LightGBM), ChatGPT embeddings with a Neural Network achieve a Pearson correlation of 0.48 () against LSEG ground-truth scores -- a modest but statistically meaningful signal given the -report training set and restriction to the environmental pillar. A traceability audit shows that 8 of 10 extracted claims verify against the source document, with two failures attributable to few-shot example leakage. We discuss limitations including dataset size and restriction to environmental indicators, and release the code to support reproducibility.ESG score prediction via regression on LLM-generated embeddings. ESGLens is purpose-built for the domain: a report-processing module segments heterogeneous PDF content into typed chunks (text, tables, charts); a GRI-guided extraction module retrieves and synthesizes information aligned with specific standards; and a scoring module embeds extracted summaries and feeds them to a regression model trained against London Stock Exchange Group (LSEG) reference scores. We evaluate the framework on approximately 300 reports from companies in the QQQ, S&P500, and Russell
Figures & tables
| Prompt | Structure | Result |
| 1 | Instruction, question, context, and a final instruction. | Fair. Only one result was generated. |
| 2 | Instruction, context, and question. | Good. More comprehensive results, but lacked a specified output format. |
| 3 | Instruction with examples, context, and question. | Best. Generated a clean and structured summary. |
| Item | Extracted Information | Paragraph in Document | Correctness |
| 1 | The annual total energy reduction reached 280 GWh, and the cumulative total reached 810 GWh. | … obtained an average grade of B-, exceeding the initial target of C. TSMC requires and assists suppliers to improve their sustainability performance. In 2023, the annual total energy reduction reached 280 GWh, and the cumulative total reached 810 GWh. The annual total water reduction reached 13.5 million metric tons, and the cumulative total reached 42.58 million metric tons. Additionally, the waste production among major … | ✓ |
| 2 | The company implemented 822 energy-conservation programs, resulting in a total reduction of 800 GWh in electricity consumption. | … Made significant strides in climate change mitigation, achieving net-zero emissions in scope 1 and scope 2 at TSMC overseas operations; expanded its onshore wind farm power supply, increasing the proportion of renewable energy usage from 40% to 60% by 2030, and proposed 822 energy-conservation programs, resulting in a total reduction of 800 GWh in electricity consumption. … | ✓ |
| 3 | The company reported a 5% increase in renewable energy use, reaching 20% of total energy consumption. | (No related information in the ESG report.) | ✗ |
| 4 | The total energy consumption for electricity alone was 500 GW. | (No related information in the ESG report.) | ✗ |
| 5 | The company planned and carried out 822 energy-saving measures across eight major categories, saving an additional 830 GWh. | … Planned and carried out 822 energy-saving measures across eight major categories, saving an additional 830 GWh. See Increase Energy Efficiency for more information. | ✓ |
| 6 | The company missed the annual target for the energy efficiency of 5nm volume production. | … In 2023, TSMC consumed a total of 24,700 GWh in energy, which resulted in a 0.1% shortfall from its 5nm production efficiency target. This was mainly due to global supply chain disruptions. The failure to achieve this target prompted TSMC to invest further in energy-saving measures and implement additional guidelines. | ✓ |
| Category | Extracted Information | Tone | Value |
| emissions_1 | Scope 1 (gross emissions) for fiscal year 2021 was 55,200 metric tons CO2e. | Neutral | 55,200 |
| emissions_1 | Scope 2 (market-based) emissions for fiscal year 2021 were 2,780 metric tons CO2e. | Neutral | 2,780 |
| emissions_1 | Scope 3 (gross emissions) for fiscal year 2021 were 23,130,000 metric tons CO2e. | Neutral | 23,130,000 |
| emissions_2 | The company targets a 30% reduction in carbon emissions by 2025. | Positive | 30% |
| emissions_3 | Manufacturing emissions account for approximately 70% of the company’s gross carbon footprint. | Positive | 70% |
| emissions_4 | Manufacturing emissions account for approximately 70% of the company’s gross carbon footprint. | Negative | — |
| Category | Summary | Tone | Value | Page |
| emissions_1 | Scope 1 (gross emissions) for fiscal year 2021 was 55,200 metric tons CO2e. | Neutral | 55,200 | 78 |
| emissions_1 | Scope 2 (market-based) emissions for fiscal year 2021 were 2,780 metric tons CO2e. | Neutral | 2,780 | 78 |
| emissions_1 | Scope 3 (gross emissions) for fiscal year 2021 were 23,130,000 metric tons CO2e. | Neutral | 23,130,000 | 78 |
| emissions_4 | Manufacturing emissions account for approximately 70% of the company’s gross carbon footprint. | Negative | — | 14 |
| emissions_4 | Several components require manufacturing processes using fluorinated gases with high global warming potential. | Negative | — | 16 |
| resource_1 | Total energy consumption and proportion from renewable sources (2021): 18,100,000 MWh (100% renewable); (2020): 11,400,000 MWh (100% renewable); (2019): 5,700,000 MWh (100% renewable); (2018): 4,100,000 MWh (99% renewable); (2017): 1,900,000 MWh (97% renewable). | Neutral | — | 16 |
| Category | Summary | Tone | Value | Page |
| emissions_1 | Compared to the previous year, overall Scope 3 emissions decreased by approximately 25%, driven by reduced production volume in 2022, increased renewable energy usage, and updated EPA emissions factors. | Positive | — | 25 |
| emissions_2 | The company targets a 55% reduction in Scope 3 emissions per million USD of value added by 2030. | Positive | — | 10 |
| emissions_3 | The company aims to reduce emissions by approximately 50% by 2030 and achieve net-zero emissions thereafter. | Positive | — | 10 |
| emissions_4 | The company targets a 30% reduction in carbon emissions by 2025. | Positive | 30% | 3 |
| resource_1 | The company aims to increase the share of onsite generation and externally supplied clean electricity. | Positive | — | 19 |
| resource_2 | The company targets a 30% reduction in carbon emissions by 2025. | Positive | 30% | 3 |
| Category | Questions |
| emissions_1 | What are the greenhouse gas emissions for Scope 1, Scope 2, and Scope 3? |
| emissions_2 | What is the carbon intensity (emissions per unit of product or revenue)? |
| emissions_3 | What are the carbon reduction targets, and what progress has been made? |
| emissions_4 | How are air pollutants, such as nitrogen oxides and sulfur oxides, managed? |
| resource_1 | What is the total energy consumption, and what proportion derives from renewable sources? |
| resource_2 | How is water used, including total consumption and recycling rate? |
Document Information Extraction
Document Information Extraction turns text, tables, forms, and images into structured, searchable data.
See all 290 papers