Data Legends

Input Data

Portfolio Data

Data field

Expected value

Explanation

Optional / required

comment

company_name

Text

Name of the company in your portfolio

Required

Used for output purposes only

company_id

Text

Identifier for the company in your portfolio, used to map target and fundamental data to the company

Required

You can use any unique company identifier, but must use the same identifier in all three input data files/tabs.

company_isin

Text

Identifier for the company in your portfolio, used to identify the company e.g. for SBTi status

Required, for portfolio coverage and temperature score.

The column is needed in the file even if data is missing

company_lei

Text

Legal Entity Identifier for the company in your portfolio, used identify the company e.g. for SBTi status

Required, for portfolio coverage and temperature score.

The column is needed in the file even if data is missing

Investment_value

Monetary value

The monetary value invested in the company. Used for aggregation

Required

Make sure all values are in the same currency.

engagement_target

TRUE, FALSE or empty

Used for engagement analysis. When set to TRUE for a company it is possible to analyze what it would do for your portfolio temperature score if this company would set a well below 2 degree Celsius (C) or a 2C target.

Optional

Additional_field

Text

It is possible to add additional fields to your portfolio data. These fields can be used to group companies by other categories than sectors, industries, regions and countries, e.g. market cap bucket, investment strategy, asset class, etc.

Optional

Fundamental Data

Data field

Expected value

Explanation

Optional / required

comment

company_name

Text

Name of the company in your portfolio

Optional

company_id

Text

Identifier for the company in your portfolio, used to map target and fundamental data to the company

Required

You can use any unique company identifier, but must use the same identifier in all three input data files/tabs.

isic

Text

Sector classification code for the company based on the International Standard Industrial Classification (https://siccode.com/page/what-is-an-isic-code). Used to map targets to the correct regression model. Should include at least the first two levels: Section and Division.

Required

country

Text

Country where the company has its headquarter. Used for analysis purposes only.

Optional

region

Text

Region where the company has its headquarter. Used for analysis purposes only. Can be continental or more granular.

Optional

industry_level_1-4

Text

Level 1 through 4 of the industry classification of the company. Used for analysis purposes only. Can be based on any industry classification system.

Optional

sector

Text

Sector of the company. Used for analysis purposes only. Can be based on any classification system.

Optional

ghg_s1s2

tCO2e

Total GHG emissions for scope 1 + 2 for the company. Used to combine temperature scores for scope 1 + 2 and scope 3 to temperature score for scope 1 + 2 + 3. Required together with ghg_s3 when using all aggregation methods (except WATS)

Optional

ghg_s3

tCO2e

Total GHG emissions for scope 3 for the company. Used to combine temperature scores for scope 1 + 2 and scope 3 to temperature score for scope 1 + 2 + 3. Required together with ghg_s1s2 in all aggregation methods (except WATS)

Optional

company_revenue

Monetary value

In single dollars / euros / …. (can be any currency you choose). Revenue of the company in the most recent year.

Required only if using aggregation method ROTS.

All values must be in the same currency.

company_market_cap

Monetary value

Market capitalization of the company in single dollars / euros / ….

Required only if using aggregation method MOTS.

All values must be in the same currency.

company_enterprise_value

Monetary value

Enterprise value of the company in single dollars / euros / ….

Required only if using aggregation method EOTS or ECOTS.

All values must be in the same currency.

company_total_assets

Monetary value

Total assets of the company in single dollars / euros / ….

Required only if using aggregation method AOTS.

All values must be in the same currency.

company_cash_equivalents

Monetary value

Cash equivalents of the company in single dollars / euros / … .

Required only if using aggregation method ECOTS.

All values must be in the same currency.

Target data

Data field

Expected value

Explanation

Optional / required

comment

company_name

Text

Name of the company in your portfolio

Optional

company_id

Text

Identifier for the company in your portfolio, used to map target and fundamental data to the company

Required

You can use any unique company identifier, but must use the same identifier in all three input data files/tabs.

target_type

Absolute, Intensity or Other

Type of target. Can be absolute or intensity based GHG emission reduction target. All targets that are not GHG emissions reduction targets can be mapped to Other. Used in the target validation protocol and to map the target to the relevant regression model in the temperature score module.

Required

If target_type is left empty the target will not be valid. If no other target is available for that time-frame and scope combination the company will be given a default score.

intensity_metric

Revenue, Product, Cement, Oil, Steel, Aluminum, Power Generation or Other

The metric the intensity based GHG emission reduction target is based on. All intensity metrics must be mapped to these 8 categories. Used in target validation protocol and to map the target to the relevant regression model in the temperature score module.

Required for targets with target type “Intensity”. Can be left empty for other targets.

scope

S1, S2, S1+S2, S1+S2+S3, S3

The scope(s) covered by the target. All scope 3 targets, whether covering downstream, upstream or both must be mapped to S3.

Required

Targets without scope are not valid. If no target is available for a time-frame and scope combination the company will be given a default score.

coverage_s1

Number in decimals, between 0 and 1, e.g. 70% is denoted 0.7.

The part of emissions covered in scope 1 for the target. Used to determine the temperature score.

For targets covering scope 1 and 2 specify the same coverage percentage in coverage_s1 and coverage_s2

Required for a target that covers scope 1

coverage_s2

Number in decimals, between 0 and 1, e.g. 70% is denoted 0.7.

The part of emissions covered in scope 2 for the target. Used to determine the temperature score.

For targets covering scope 1 and 2 specify the same coverage percentage in coverage_s1 and coverage_s2.

Required for a target that covers scope 2

coverage_s3

Number in decimals, between 0 and 1, e.g. 70% is denoted 0.7.

The part of emissions covered in scope 3 for the target. Used to determine the temperature score.

Note: this should be the coverage compare to the whole scope 3 emissions, so not just the part that is covered by the target.

Required for a target that covers scope 3

reduction_ambition

Number in decimals, between 0 and 1, e.g. 70% is denoted 0.7.

The emission reduction that is set as ambition in the target. Used to determine the temperature score.

Required

base_year

Year

Base year of the target. Used in the target validation protocol and to determine the time frame of the target.

Required

end_year

Year

End year of the target. Used in the target validation protocol and to determine the time frame of the target.

Required

start_year

Year

Year the target was announced. Used in the target validation protocol. If not specified, it will be assumed the start year is equal to the base year.

Optional

base_year_ghg_s1

tCO2e

Total reported GHG emissions for scope 1 for the company at the base year of the target. Used to convert targets covering only scope 1 or scope 2 to scope 1 + scope 2 targets.

Required for targets that only cover scope 1 or scope 2

base_year_ghg_s2

tCO2e

Total reported GHG emissions for scope 2 for the company at the base year of the target. Used to convert targets covering only scope 1 or scope 2 to scope 1 + scope 2 targets.

Required for targets that only cover scope 1 or scope 2

base_year_ghg_s3

tCO2e

Total reported GHG emissions for scope 3 for the company at the base year of the target.

Optional

achieved_reduction

Number between 0 and 1

Part of the reduction ambition of the target that is already achieved by the company. Used in the target validation protocol. Targets with achieved reduction of 1 are invalidated.

Optional. If not specified, assumed below 1

target_ids

An optional identifier for the target

An identifier that allows the user to see what targets are used as input to a specific temperture score. Is provided by some data providers.

Optional. If not specified, assumed empty

Output data

Data field

Expected value

Explanation

From

achieved_reduction

Number between 0 and 1

Part of the reduction ambition of the target that is already achieved by the company. Used in the target validation protocol. Targets with achieved reduction of 1 are invalidated.

Target data

base_year

Year

Base year of the target. Used in the target validation protocol and to determine the time frame of the target.

Target data

base_year_ghg_s1

In tCO2e

Total GHG emissions for scope 1 for the company at the base year of the target.

Target data

base_year_ghg_s2

In tCO2e

Total GHG emissions for scope 2 for the company at the base year of the target.

Target data

base_year_ghg_s3

In tCO2e

Total GHG emissions for scope 3 for the company at the base year of the target.

Target data

company_id

text

Identifier for the company in your portfolio, used to map target and fundamental data to the company

Portfolio data

company_isin

text

Identifier for the company in your portfolio, used to get the SBTi status of the company (i.e. whether or not the company has a target approved by the SBTi)

Portfolio data

company_name

text

Name of the company in your portfolio

Portfolio data

coverage_s1

Number in decimals, between 0 and 1

The part of emissions covered in scope 1 for the target. Used to determine the temperature score.

Target data

coverage_s2

Number in decimals, between 0 and 1

The part of emissions covered in scope 2 for the target. Used to determine the temperature score.

Target data

coverage_s3

Number in decimals, between 0 and 1

The part of emissions covered in scope 3 for the target. Used to determine the temperature score.

Target data

end_year

Year

End year of the target. Used in the target validation protocol and to determine the time frame of the target.

Target data

Intensity_metric

Revenue, Product, Cement, Oil, Steel, Aluminum, Power Generation or Other

The metric the intensity based GHG emission reduction target is based on. All intensity metrics must be mapped to the eight categories in the column on the left. Used in target validation protocol and to map the target to the relevant regression model in the temperature score module.

Target data

Reduction_ambition

Number in decimals, between 0 and 1

The emission reduction that is set as ambition in the target. Used to determine the temperature score.

Target data

start_year

Year

Year the target was announced. Used in the target validation protocol. If not specified, it is assumed the start year is equal to the base year.

Target data

Target_type

Absolute, Intensity or Other

Type of target. Can be absolute or intensity based GHG emission reduction target. All targets that are not GHG emissions reduction targets can be mapped to Other. Used in the target validation protocol and to map the target to the relevant regression model in the temperature score module.

Target data

Time_frame

SHORT, MID or LONG

The targets are sorted by time frame.

Determined in tool

SHORT: targets shorter than 5 years

MID: targets between 5 and 15 years

LONG: targets between 15 and 30 years.

target_ids

list of target ids

A list showing the IDs of the targets that have been used in calculating this temperature score. If IDs are not used the field will return empty.

Target data

ghg_s1s2

tCO2e

Total GHG emissions for scope 1 + 2 for the company. Used to combine temperature scores for scope 1 + 2 and scope 3 to temperature score for scope 1 + 2 + 3. Also used in combination with ghg_s3 in most aggregation methods (except WATS)

Fundamental data

ghg_s3

tCO2e

Total GHG emissions for scope 3 for the company. Used to combine temperature scores for scope 1 + 2 and scope 3 to temperature score for scope 1 + 2 + 3. Also used in combination with ghg_s3 in all aggregation methods, except WATS.

Fundamental data

sbti_validated

FALSE or TRUE

Returns true if the company has a SBTi-approved target.

SBTi data or fundamental data

Investment_value

Monetary value

The monetary value invested in the company.

Portfolio data

engagement_target

TRUE, FALSE or empty

Used for engagement analysis. When set to TRUE for a company it is possible to analyze what it would do for your portfolio temperature score if this company would set a (well below) 2 degrees target.

Portfolio data

sr15

text

The regression model used. This is determined based on the target type, ISIC, intensity_metric and scope. See [link to methodology doc, updated mapping section] for more detail

Output from the tool

Annual_reduction

Number in decimals, between 0 and 1

The annual reduction based on the reduction_ambition and the length of the target. Calculated as

Output from the tool

slope

Slope5, slope15, slope30

Used in determining the regression model to use to calculate the temperature score for a specific target based on its time frame.

Output from the tool

Short-term targets: slope5

Mid-term targets: slope15

Long-term targets: slope30

samplesize

Number

The sample size used in the regression model. For model 4 this is 128. Not used in calculations. See https://github.com/CDPworldwide/TROPICS-regression/ for more detail about the regressions.

Regression model

model

Integer

The regression model used. This is model 4 by default. See https://github.com/CDPworldwide/TROPICS-regression/ for more detail about the regressions.

Regression model

variable

text

The regression scenario used to determine the temperature score of a target, for example

Regression model

Emissions|Kyoto Gases

param

Number in decimals, between 0 and 1

The temperature score (TS) is calculated using linear regressions.

Regression model

intercept

Number in decimals, between 0 and 1

The temperature score (TS) is calculated using linear regressions.

Regression model

r2

Number in decimals, between 0 and 1

r2 represents the fit of the regression model on the data used to create the regressions. Not used in calculations.

Regression model

temperature_score

Number

The temperature score calculated for the combination of company, scope and time frame

Output from tool

temperature_results

Number in decimals, between 0 and 1

Represents the part of the score that is calculated using a valid target as defined by the target validation protocol vs. the part using the default score. For more detail, see [link to Chapter 2 of Methodology document]