I would like to request additions to the Agrifood-GR report, in the tab “ESG Reports”. You have already received the data for this request
The user flow that leads to the report is the following:
Browse topics for Climate > GR > select category "Agrifood" > Overview
Charts:
Chart Group 1: ESG Reporting
Chart 1:
Title: Companies with ESG Reports by Turnover
Description: This chart ranks companies by turnover based on their published ESG reports. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Datasource: Company Websites, Orbis.
Type: Bar Chart (ordered by turnover)
Indicator: I42, SV00
xAxisName: company
yAxisName: turnover
xColumnField: key
yColumnField: value
GroupByField:
Chart Group 2: ESG Metric Reporting Breadth
Chart 1:
Title: Top Companies by Number of ESG Metrics Reported
Description: This chart displays companies ranked by the number of ESG metrics reported in their filings. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis.
Type: Bar Chart (ordered by number of metrics)
Indicator: I42B, SV06
xAxisName: company
yAxisName: # metrics
xColumnField: key
yColumnField: value
GroupByField:
Chart 2:
Title: Number of Metrics Reported by ESG Scope
Description: This chart shows the number of metrics reported, categorized by ESG scope. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis.
Type: Radial Polar Chart
Indicator: I42B, SV17
xAxisName: ESG scope
yAxisName: # metrics
xColumnField: key
yColumnField: value
GroupByField:
Chart Group 3: ESG Metric Coverage Insights
Chart 1:
Title: Most Reported Metrics: Top 10 Metrics by Coverage
Description: This chart illustrates the top 10 most reported ESG metrics, based on coverage percentage. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis.
Type: Horizontal Bar Chart
Indicator: I42C, SV18
xAxisName: metric
yAxisName: coverage percentage
xColumnField: key
yColumnField: value
GroupByField:
Chart 2:
Title: Least Reported Metrics: Bottom 10 Metrics by Coverage
Description: This chart highlights the bottom 10 least reported ESG metrics by coverage percentage. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis.
Type: Horizontal Bar Chart
Indicator: Ι42D, SV18
xAxisName: metric
yAxisName: coverage percentage
xColumnField: key
yColumnField: value
GroupByField: metric
Chart Group 4: ESG Reporting Trends
Chart 1:
Title: Average Share of Non-null Metrics per Report by ESG Scope and Year
Description: This chart presents the average share of non-null metrics in ESG reports, segmented by ESG scope and year. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis.
Type: Line Chart
Indicator: I42E, SV21
xAxisName: Year
yAxisName: Average Share (%)
xColumnField: key
yColumnField: value
GroupByField: ESG Scope
Chart Group 5: ESG Performance
Chart 1:
Title: Average ESG Score per Company by Scope and Year
Description: This chart illustrates the average ESG score per company, segmented by ESG scope and year. To calculate the ESG Score per Company and Year, the actual values of each ESG metric was ranked for each year, meaning that better performance on a metric will conclude to higher ranking. After that, the weight of each metric is calculated based on the coverage of the metric in the dataset. The higher the coverage of the metric, the higher its weight and all the weights sum up to 1. Finally, the weight is multiplied with the ranking and the final Score for each metric per Company and Year is calculated. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis.
Type: Stacked Bar Chart
Indicator: I43, SV21
xAxisName: year
yAxisName: ESG score
xColumnField: key
yColumnField: value
GroupByField: scope
Chart 2:
Title: Average ESG Score per Company by Metric and Year
Description: This chart presents the average ESG score per company, broken down by specific metrics and year. To calculate the ESG Score per Company and Year, the actual values of each ESG metric was ranked for each year, meaning that better performance on a metric will conclude to higher ranking. After that, the weight of each metric is calculated based on the coverage of the metric in the dataset. The higher the coverage of the metric, the higher its weight and all the weights sum up to 1. Finally, the weight is multiplied with the ranking and the final Score for each metric per Company and Year is calculated. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis.
Type: Stacked Bar Chart
Indicator: I43, SV18.01
xAxisName: year
yAxisName: ESG score
xColumnField: key
yColumnField: value
GroupByField: metric
dtziotzios
commented
1 year ago
I would like to request additions to the Agrifood-GR report, in the tab “ESG Reports”. You have already received the data for this request The user flow that leads to the report is the following: Browse topics for Climate > GR > select category "Agrifood" > Overview
Charts:
Chart Group 1: ESG Reporting
Chart 1: Title: Companies with ESG Reports by Turnover Description: This chart ranks companies by turnover based on their published ESG reports. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Datasource: Company Websites, Orbis. Type: Bar Chart (ordered by turnover) Indicator: I42, SV00 xAxisName: company yAxisName: turnover xColumnField: key yColumnField: value GroupByField:
Chart Group 2: ESG Metric Reporting Breadth
Chart 1: Title: Top Companies by Number of ESG Metrics Reported Description: This chart displays companies ranked by the number of ESG metrics reported in their filings. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis. Type: Bar Chart (ordered by number of metrics) Indicator: I42B, SV06 xAxisName: company yAxisName: # metrics xColumnField: key yColumnField: value GroupByField:
Chart 2: Title: Number of Metrics Reported by ESG Scope Description: This chart shows the number of metrics reported, categorized by ESG scope. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis. Type: Radial Polar Chart Indicator: I42B, SV17 xAxisName: ESG scope yAxisName: # metrics xColumnField: key yColumnField: value GroupByField:
Chart Group 3: ESG Metric Coverage Insights
Chart 1: Title: Most Reported Metrics: Top 10 Metrics by Coverage Description: This chart illustrates the top 10 most reported ESG metrics, based on coverage percentage. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis. Type: Horizontal Bar Chart Indicator: I42C, SV18 xAxisName: metric yAxisName: coverage percentage xColumnField: key yColumnField: value GroupByField:
Chart 2: Title: Least Reported Metrics: Bottom 10 Metrics by Coverage Description: This chart highlights the bottom 10 least reported ESG metrics by coverage percentage. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis. Type: Horizontal Bar Chart Indicator: Ι42D, SV18 xAxisName: metric yAxisName: coverage percentage xColumnField: key yColumnField: value GroupByField: metric
Chart Group 4: ESG Reporting Trends
Chart 1: Title: Average Share of Non-null Metrics per Report by ESG Scope and Year Description: This chart presents the average share of non-null metrics in ESG reports, segmented by ESG scope and year. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis. Type: Line Chart Indicator: I42E, SV21 xAxisName: Year yAxisName: Average Share (%) xColumnField: key yColumnField: value GroupByField: ESG Scope
Chart Group 5: ESG Performance
Chart 1: Title: Average ESG Score per Company by Scope and Year Description: This chart illustrates the average ESG score per company, segmented by ESG scope and year. To calculate the ESG Score per Company and Year, the actual values of each ESG metric was ranked for each year, meaning that better performance on a metric will conclude to higher ranking. After that, the weight of each metric is calculated based on the coverage of the metric in the dataset. The higher the coverage of the metric, the higher its weight and all the weights sum up to 1. Finally, the weight is multiplied with the ranking and the final Score for each metric per Company and Year is calculated. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis. Type: Stacked Bar Chart Indicator: I43, SV21 xAxisName: year yAxisName: ESG score xColumnField: key yColumnField: value GroupByField: scope
Chart 2: Title: Average ESG Score per Company by Metric and Year Description: This chart presents the average ESG score per company, broken down by specific metrics and year. To calculate the ESG Score per Company and Year, the actual values of each ESG metric was ranked for each year, meaning that better performance on a metric will conclude to higher ranking. After that, the weight of each metric is calculated based on the coverage of the metric in the dataset. The higher the coverage of the metric, the higher its weight and all the weights sum up to 1. Finally, the weight is multiplied with the ranking and the final Score for each metric per Company and Year is calculated. A December 2022 crawl of company websites, verified against Orbis data, identified ESG/Sustainability Reports through PDF analysis, extracting document names and paths. The process provided a dataset from 2020 to 2021, and 2 companies. Data Source: Company Websites, Orbis. Type: Stacked Bar Chart Indicator: I43, SV18.01 xAxisName: year yAxisName: ESG score xColumnField: key yColumnField: value GroupByField: metric