About CSRHub | Company Information | CSRHub Dashboard | Data Sources
More Info/Reports | My Account | Profiles | Ratings | Search for Information
What is CSRHub?
CSRHub is a web based tool that provides access to employee, environmental, community and governance ratings on most major companies in North America, Europe and Asia. We are the first company to combine data from nine of the premier socially responsible investment (SRI) analysis firms (also known as Environment, Social, Governance - ESG), and over 265 nongovernmental organizations (NGOs), government agencies, news feeds, social networking groups, smaller for-profit organizations, and publishers. Our proprietary tools combine more than 118 million pieces of data on sustainability and CSR performance into a consistent set of ratings. We then allow users to personalize these ratings, share them, and add their own views on companies. Our site enables users to learn about and compare company sustainability and CSR behavior. We provide some ratings information for free and additional information to fee-paying subscribers. We also sell custom reports from most of our licensed ESG sources.
Who started CSRHub?
Our three co-founders are Cynthia Figge, Bahar Gidwani, and Stephen Filler. We have worked for more than seven years on this project. Cynthia Figge, President and COO, cofounded one of the first consultancies integrating sustainability and corporate strategy in 1996, and brings many years of experience tracking corporate responsibility. Previously Cynthia developed new services for McCaw Cellular/LIN Broadcasting. Bahar Gidwani, CEO, has built and run Web-based and technology-based businesses. Bahar worked on Wall Street with Kidder, Peabody, and with McKinsey & Co. Bahar has consulted to a number of major companies and currently serves on the board of several software and Web companies. Co-founder and Advisor Stephen Filler is an attorney who specializes in intellectual property and business law, and is currently Director of Business Development for a solar energy company. Cynthia and Bahar both hold Harvard MBAs and Bahar is also a CFA.
What is CSRHub’s goal and purpose?
There has been no easy way for consumers and businesses to discover how companies perform and compare on sustainability and CSR issues. This makes it hard for people to make socially responsible decisions about what to buy, where to work, whom to do business with, and which companies to support or not support. CSRHub brings leading information about corporate social performance into one place so business managers, professionals, researchers, academics, NGOs, online publications, social networking sites, and individuals can use CSRHub’s information to understand, share, discuss, and track the CSR and sustainability performance of companies.
Why did you choose the name CSRHub and spell it as one word, rather than as CSR Hub?
We considered many names for our site—in fact we spent a year and a half under a different name—EkoHub. From the beginning, we liked the word “Hub” as we felt it reflected our desire to be at the center of the CSR and sustainability area. We also understood that a hub held the wheel together, but that it didn’t actually meet the road! So, we would be a tool for those who were doing the hard work in this area, rather than a tool for doing the work, itself. Our first prefix of “Eko” is related to both economy and ecology. However, many people tried to spell it “eco” and got confused. We considered ESG (Environment, Social, Governance) and several other similar terms from the reporting space. In the end, we decided that CSR (Corporate Social Responsibility) was the best umbrella to cover the many different aspects of social behavior that we wanted to cover. We considered separating our name into two parts, but we wanted to indicate that we were taking an integrative and holistic approach. We considered either having the first part, the second part, or the last two letters in lower case. But, we felt that all parts of what we do—and all the communities we serve—were equal. We decided to change our capitalization to CSRHub, so that people don’t think our name rhymes with “shrub!” We may also launch other products with related names such as ESGHUB or CitizenHub.
Back to top
Why are some companies missing from CSRHub?
As we continue to expand our 525+ data sources, we plan to continue to expand our coverage of publicly-traded, private companies, government organizations, and not-for-profits. Each company must meet certain criteria to be included in our database. We drop companies when we do not have enough information. We currently do not rate about 90,000 companies for whom we do not have enough information. See more on our Ratings methodology page
How does CSRHub handle multi-nationals?
Which country are they considered to belong to? In general, we try to assign multi-nationals to the country in which their headquarter is located. Some companies maintain two or more head offices in different countries. In these cases, we try to use the office location that was first established.
How does CSRHub handle companies that use flag of convenience countries as their domicile?
Certain countries have tax and other regulations that make them attractive headquarter locations. In general, we assign companies to their official legal location.
Do parent corporations get credit for subsidiaries ratings on CSRHub?
We generally do not “credit”a parent corporation with the sustainability-related activities of its subsidiaries. The parent-subsidiary issue is an important one in sustainability policy and practice. Subsidiaries often have dramatically different positions and performance on social issues from their parent company. In some cases, these differences are driven by history (an acquired company may seek to maintain its old management style), local customs (different countries have different CSR requirements), or by a corporate “laissez faire”approach to social standards. Further, some organizations may only allow a parent to join or to submit information, or may require that a company’s be headquartered in a certain geography.
What info is available about the year a company first introduced corporate CSR initiatives? (of any kind) at corporate level?
The best source for learning the exact dates that companies issued social responsibility reports is Corporate Register. They are one of our sources, but all we receive from them is an indication of how many times each company has reported. (As a subscriber, you can see this number for companies that are in Corporate Register’s system.) Since companies sometimes report more than once per year or skip years, this number is not an accurate way of estimating how long they have reported.
Do the organizations I belong to support CSRHub?
A large number of organizations plan to support CSRHub. Do a profile search for your organization’s name, and see if it appears on the search results list. If it does not, please ask the head of your organization to contact us at https://esg.csrhub.com/partnership-request
. We will respond with details on our partnership program. An organization that does not want to join us as a partner can still create a “group profile”for its members. However, it will not have the ability to establish and maintain a forum for its members.
Are the sources listed on a company page generic or specific to the company?
The sources listed on a company page (the detailed page shown with all the ratings after a search) are for the specific company at a specific time. As a pro subscriber, you may "rollback" ratings to see the ratings and sources change over time for the specific company. See more under Ratings on this page
Back to top
The CSRHub Official Name comes up as NA, but I’m sure you must rate this company.
Sometimes variations in the names of companies or ticker symbols creates ambiguities that our name lookup can’t resolve. As a human being, you are smarter than our program. So, you can use our lookup tool to find the company you seek. Click on the cell in column B that contains the company name we are not understanding. Go to the top menu bar on Excel and look for the CSRHub menu item. Click on it and use the leftmost button—the one called “Company.” You will see a pop up box that has a search field at the top. Type in the first few letters of the company name you are looking for. Our system will search through all of the names in our system and find you a list of the ones that match. When you see what you want, click on it and then hit the “Paste into the current cell” button. We’ll paste in a name that should give you the ratings information you want.
Why does it take so long to recalculate my sheet?
Excel is pulling data from the CSRHub database and putting it into your Dashboard sheets. The more data you request, the more times your program has to call the database. This is one reason we have limited the number of companies in our templates. If you want to dig into just one aspect of sustainability, you should build a custom sheet of your own that looks at just the factors you want. You may also find that Dashboards calculate much faster after the first pass. So you should be able to make a change and have almost instant recalculations. This I because our code tries to only recalculate the cells that have changed.
My Dashboard doesn’t want to recalculate.
Excel sometimes doesn’t understand that you want to refresh your entire sheet. If this happens, try pressing the Ctrl, Alt, and F9 keys (on a Windows machine) or XX and YY (on a Mac). This forces Excel to recalculate all of the cells of a spreadsheet.
Back to top
What types of data sources does CSRHub use?
We use data from Socially Responsible Investing (SRI) - also known as Environment, Social, Governance (ESG) analysis firms, Non-Governmental Organizations (NGOs) such as foundations, associations, union groups, and activist groups, government databases, publications and research reports, and input from individual CSRHub users. You can see a full list of our sources on our Data Sources page here
. You can click through to learn more about each source from this page, or click on the source icon on any company page that you visit.
Who are CSRHub major SRI/ESG data sources?
Our major ESG sources include ASSET4 (Thomson Reuters), Carbon Disclosure Project (CDP), EIRIS, Governance Metrics International (merged with Corporate Library), IW Financial, MSCI (ESG Intangible Value Assessment and ESG Impact Monitor), RepRisk, Trucost and Vigeo.
What can I do with CSRHub’s data?
Should I use CSRHub data for making investment decisions?
We built CSRHub to give access to sustainability data to corporate managers, researchers, activists, and those involved in non-governmental organizations. Investors have other, better options for obtaining the data they need. Note that CSRHub ratings are not "real time"- we update our information about once per month. Most investors need real time data. Further, we aggregate information to give a high-level view of social performance. Most investors want details they can tie to specific trends, investment themes, or client needs. While we allow our users to create lists of companies, we do not support upload of portfolios and we do not provide any share prices, return tracking, or investment performance analysis. A good investment decision should be based also on the past and expected future financial performance of a company. There are also considerations of risk and diversification involved in an investment decision that are not covered by our data. See our blog post " Use CSRHub for Stock Picks?
"with more on this topic including examples.
How reliable is the data CSRHub uses?
We find that our sources do not always agree with one another. However, in general, a company that ranks poorly on a certain aspect of social performance with one source will also rank poorly with other sources. Thanks to the large number of sources we use and the proprietary methods we use to process and adjust our data, we believe we capture most of the information our sources provide. As a result, our ratings are at least representative of the general state of knowledge about the social performance of the companies in our database and may represent the best-available information. Even so, we suggest that you contact a company or do your own additional research, before you take any social action against a company based on our ratings.
What is a flag?
Flags are data sources that mention the company but do not add to its rating. If you place your cursor over a flag, you will see the popup: “The icons in this area link to sources that mention this company but do not offer an evaluation of its social performance.”There are several reasons these sources do not contribute to ratings. Sometimes the flag is a membership organization like CSRwire, Fortune 1000 list, BSR, etc. Sometimes the flag is an aged data source (Newsweek Green List 2009). Sometimes a flag is a source that does not allow us to use their actual rating (DJSI Global and Europe).
Back to top
More Info, Reports
Can I get more information on a company I am interested in?
You can get more information by subscribing to CSRHub. If you want even more information than is available to subscribers, you may want to consider buying a special report on a company from one of our data sources. See our Buy Reports page
for a current list of available reports and how to receive them.
Back to top
What are the benefits of a Demo?
As part of the demo process, we will give you a brief guided tour of the most recent updates to CSRHub, including seeing the CSRHub Dashboard in action. Request a demo today
What are the benefits of subscribing?
Subscribers get to see more in-depth information on each of the 17,267 companies in our database. In particular, they can see twelve subcategory ratings (in addition to the four category ratings). This allows our subscribers to compare the performance of companies they are interested in and benchmark all companies in an industry or particular geography. Subscribers can see ratings information over time. They can see the underlying detailed information from hundreds of data sources. Subscribers also have access to the CSRHub Dashboard, an excel based tool that dynamically pulls the CSR metrics you need from our 118 million data point database into a spreadsheet template or your own customizable report. If you have questions about the value of a subscription, please contact us at https://esg.csrhub.com/support-request
. Also, review our subscription page
How do I Renew my subscription?
To renew your subscription, first login to the site. Go to My CSRHub from the menu, select My orders and subscriptions and look for Active subscriptions. Find your latest subscription and select Renew to the right.
What is CSRHub's auto-renew policy?
All subscriptions (annual and monthly) are on a secure, automatic renewal plan. CSRHub offers a 100% satisfaction guarantee. You may cancel at any time.
How do I Cancel my subscription?
To cancel your subscription, first login to the site. Click on the link at the top left under your user name (or go to http://www.csrhub.com/user
). On this page you will see a My orders tab. You should be able to find your most recent order on this list. Select the Cancel button to the right.
Back to top
How are the default profiles calculated?
CSRHub regularly studies the profiles of all of its registered users and subscribers. We periodically calculate the average of all of our user profiles. This average is used to establish our CSRHub user average profile. We have also identified three more groups of profiles: Environment focused
users set a high importance on Environment ratings and fairly similar importance for the other three rating categories; Governance focused
users put Governance as most important with a small secondary emphasis on Employee issues;and Community-Employee focused
users split emphasis between the Community and Employee categories. About 65% of the profiles established to date could be associated with one of these four groups—there are many other smaller sub groups, some of which are growing fairly rapidly. You can read more about our profile research here: www.csrhub.com/blog/2012/01/moving-beyond-green-the-rainbow-within-csr.html
Why should I create my own profile?
Your profile reflects your view of the world. When you review company ratings using your own profile, you are seeing the relative social performance of companies from your own perspective. Once you have a profile, you can share it with your friends. They can then better understand your view of the world and (if they are CSRHub members) understand why your view of company social performance is different from theirs.
How do I create my own profile?
How does my profile affect my scores?
When you make one of the four categories of environment, employees, community and governance more important, you increase the effect of that category’s scores on the overall scores you see. The base category scores remain the same, but your personal overall score for each company increases or decreases. Setting special issues will also affect your scores. (See below.) You can read more about our schema
on this page. Watch a brief video on this topic
How can I see what other people’s profiles look like?
If someone sends you their profile, you can click on the profile link and see their profile settings. You can also search for profiles. When you find one you are interested in, click on the link and see the settings. You can also accept/use a profile and see the settings in the top left profile status box that is on every page of the site.
Why can I only lock two of my profile categories?
The four primary categories comprise one hundred percent of a company’s rating, so the total of your choices cannot exceed the maximum value of 12. You can set the value for the two categories that are most important to you, lock them, and then adjust the remaining two values within the pre-set limit.
If I change my profile emphasis from 3 to 4, does it have the same effect as if I change it from 4 to 5?
No. Profile changes are non-linear. Changes in the middle of the score range (between 2 and 4) have less effect on your overall scores than changes at the ends. The curves used to make these adjustments are based on our analysis of how much company scores vary for each category and how far our users tend to push their preference settings. We give more effect to profile changes when there is more variation in the behavior of companies in a particular area or when our users tend to be less extreme in their views.
Back to top
What is the CSRHub schema?
CSRHub overall ratings are based on four categories: Environment, Employees, Community, and Governance categories. Each category has three subcategories. Environment –Environmental Policy and Reporting, Energy and Climate Change, Resource Management;Employees: Diversity and Labor Rights, Compensation and Benefits, Training Health and Safety;Community –Community Development and Philanthropy, Human Rights and Supply Chain, Product;Governance –Leadership Ethics, Board, Transparency and Reporting. Review Our data schema
for more information.
What is the rating scale?
CSRHub takes information from its data sources and transforms it into a 0 to 100 scale. The higher the rating the better, with 100 as the best rating. These ratings are currently clustered around 50. If you want to see the curve for all companies, go to the edit profile page by clicking "Edit"in the Profile Tool in the left sidebar, click "Edit"to the right of a profile name, go to the bottom of the page and click on a grey button that says, “See results.”
Are ratings evenly distributed?
No. The average company rating is typically about 50. That is because in general, companies have a ways to go to become sustainable and socially responsible. You can read more about how we calculate ratings on our Ratings Methodology
How do I roll back data to see category/subcategory scores of a previous month (history of a company's rating)?
Only professional level subscribers can take advantage of this feature and see the history of a company's rating. Pro subscribers need to first create a personal profile and then adjust the data set date within the profile box. Please see this page for a full description of how our date rollback system works
Is the overall score an average of the four category scores?
The overall score is based on a weighted average of the category scores. The weights used come from each user’s profile settings. There is a non-linear translation of weight from the profile settings and the scale for each category weight is different. So, a “3.0”setting for Environment is not necessarily 2X as much weight as a “1.5”setting and the difference between 3.0 and 1.5 for Governance could be different from that for Environment. The scales we employ have been derived from study of the profile settings of our 10,000 users. We know how many users set profiles at each level, so we know how rare (and therefore how heavily or lightly weighted) each setting should be.
You can read more about our profile research here: www.csrhub.com/blog/2012/01/moving-beyond-green-the-rainbow-within-csr.html
If we have two companies, A &B that both support the community in different ways, how is CSRHub breaking down those ratings to make sure that we have an "apples to apples"comparison? Focusing on community for example sake, what are the input factors into the community metric and how are they weighted? Focusing on community for example sake, what are the input factors into the community metric and how are they weighted?
Our goal is to provide consistent ratings of sustainability performance across a large number of companies. We do not want to be trapped into rating only public companies (e.g., by relying primarily on public filings). We also do not want to interpret and impose ratings directly ourselves (e.g., using our own team of analysts). We want our sources to be transparent (and they are). We expect our ratings to reflect the general perception of a company’s performance, rather than a company’s true performance.
We face several methodological issues, when we approach our rating task:
A. Each source has its own perspective and reporting schema. We currently have more than 8,000 different ratings elements in our system. Within the area of “Board performance,”we may have sources who report that a company’s board is “good,”“C+,”or “2.3;”that a board is “diverse;”that “X% of the board members are women;”that a board meets “Y times per year;”that “the board is (or is not) involved in the sustainability process;”etc. To make sense of this mess, we have to map each element we ingest into one of the 12 parts of our schema. To make the system “fair,”we try to pull in roughly equal numbers of elements and data items for each of the 12 parts.
B. No source covers all companies. We already cover 17,267 companies in 133 countries. Our goal is to cover hundreds of thousands of companies in every country in the world. We will never have a single standard set of data against which we could scale and adjust everything else.
C. Sources tend to be biased or to have discontinuous ratings distributions. Once we have mapped a source, we can compare the ratings it gives for a company against all of the other ratings we have for that company. We can quickly determine if a source is biased positively or negatively. Some sources have only one value (e.g., “Yes, the company does have a policy”). We adjust each source’s results to fit the overall distribution for each subcategory and then adjust the overall distribution to reflect the input of the sources.
D. Some sources are more accurate than others. We see this again through a comparison with our other sources. When a source has poor accuracy, we reduce its weight in our system.
The above processes involve massive amounts of computation—we are following a “Big Data”approach. It would be impossible to explain to an outside user exactly why ten sources gave a score of 46 for one company and two of those source plus six others gave a score of 53 for another one. Not only would the conversions appear arbitrary without the support of our analysis (we currently have 118 million data points in our system), but the conversions carry relatively little information. The most valuable information is the data we input from the sources (which we share) and our inventory of which sources track each company (which we also share).
We feel our industry and country averages also contain value. Due to the nature of our approach, all of our ratings are accurate to within less than 1.8 points. (In other words, if one company has a score of 51 and another has one of 49, we are 95% confident that the two scores are different.)
Why are some companies missing information on one of the four categories?
Although we have more than 525 data sources and more than 118 million pieces of data, we don’t have every piece of data on every company. We report the information we have. Where we are missing details, we leave the information blank. This can sometimes distort the rating for a company.
How does CSRHub give ratings when it has only a few sources?
Our sources overlap with each other in thousands of places. This allows us to gauge the relative attitude of each source and adjust for their biases. As a result, when we have only a few sources available for a particular company, we can adjust those sources—based on all of our experience—and create ratings that are consistent and, we hope, fair. If the amount of data we have falls below a certain level, we do not publish a rating. There are approximately another 90,000 companies for whom we have partial information—but not enough to provide a rating. For more information on how we calculate ratings, please review the information on this page.
What are partially rated companies on CSRHub?
We have received data from about 525 sources on more than 100,000 companies and organizations. Eventually, we hope our system will allow us to publish ratings on all of these companies—and many hundreds of thousands of publicly-held companies, privately-held companies, not for profits, and government organizations. We have enough sources and data to provide full ratings across the four categories of data we track (Community, Employees, Environment, and Governance) for over 17,267 companies. For the rest of the companies in our system, we often have only one source of data on a company or information on only a few areas of a company’s sustainability performance. In several thousand cases, we believe this data is sufficient for us to publish partial ratings—data on one or more of our twelve subcategories. These partial ratings generally allow us to also provide at least one category rating for these partially rated companies. See the steps we take to determine which ratings to publish on our partial ratings page
What are Not rated companies on CSRHub?
Some companies are listed on CSRHub but are shown as ‘Not rated.’ We have some sustainability ratings data on these companies, but not enough yet to give them reliable ratings. In some cases, we may indicate our best current guess of a subcategory or category rating. Please recognize that these are tentative scores only and that they are not included in the overall averages for the site.
Does CSRHub pull and evaluate each individual company's reports as we produce a rating?
We do not ingest any data directly from companies. Instead, we use the ratings and opinions formed by our 525 sources as the input to our system. Our system’s goal is provide our users with the best possible estimate of how each company is viewed by its stakeholders. We do not need to collect every available fact about sustainability. Instead, we want to collect all of the opinions about a company’s performance and synthesize them into a broad, consistent, and comparable estimate of perceived performance.
There are many reasons we took this approach:
A. The available facts are not truly comparable between companies. For instance, one company may include supplier contributions in its carbon use. Another may include employee travel. A third could include the effect of its mix of power sources. A fourth might not include its subsidiaries. A normal user who sees these four sets of numbers cannot draw a conclusion from them about which company has better carbon efficiency. In contrast, our expert sources can draw conclusions based on this type of data. By combining the input of several expert sources (after removing any biases we detect in their methodologies) we get a clear signal about which company appears to have better carbon management policies.
B. Each stakeholder group has a different focus and interest. A governance source may approve of a CEO who carefully supervises all of her or his operations. An employee source may dislike the same CEO, because she/he is a micromanager who interferes in day to day operations. A labor source will care less about management style and more about whether or not the CEO allows unions to recruit members and participate in workforce management. Those who try to collect and report facts miss these nuances and obscure the fact that sustainability performance must be measured using a context of personal and moral values.
C. Some of our sources charge large amounts for the use of their data. They are willing to allow us to ingest it into our system, but would be out of business if we passed through all the detailed data they have labored to collect.
If a company improves its policies and puts more emphasis on sustainability, its score in our system should eventually rise. However, the speed with which this happens may depend upon how well the company communicates the changes it has made. It may also depend on how each of the various stakeholder groups views these changes.
Our tool does not tell you how a company is doing. It tells you how everyone else who shares your view of the world (as described in your profile) would think it was doing, if they had access to all 525 of our sources. Our tool is designed to help sustainability practitioners get feedback from the “opinion marketplace”on their company’s perceived performance.
Is it possible to be included in our database "by choice"? What steps, if any, would a company take in order for their ratings to show up on CSRHub?
No, since we do not attempt to collect data directly from the companies we cover (see above). If a company used the Global Reporting Initiative (GRI) framework for its CSR report, committed to the UN Global Compact, joined the Sustainable Packaging Coalition, became a member of the American Sustainable Business Council, etc., they might already be rated (at least partially) by CSRHub. As a company expands the scope of their sustainability work, they will be noticed by our sources and we will start to learn about your activities. This organic approach is the easiest way to join the sustainability metrics world.
You can use our system to discover competitors who rank well and then do your own analysis of how they have attracted attention and praise for their work. As an alternative, CSRHub could introduce you to one of the sustainability consulting firms with whom we have partnered. Our partners could review your internal systems and programs, benchmark your performance against that of your competitors, and then advise you of the best ways to disclose and promote your sustainability achievements.
What are special issues?
Some issues don’t fall into our four category structure. For instance, whether or not a company tests its products on animals, does business in Burma, or is a good place for women to work may not be directly covered by ratings on a company’s governance, labor relations, etc. Special issues are things you feel especially strongly about. You can choose to make their presence in a company a positive thing (e.g., you could upgrade companies that support unions), a negative thing (e.g., you could downgrade the ratings of companies that are against the NRA), or drop the ratings entirely for those companies who are involved in an area you feel strongly about. If you choose “exclude”for a special issue, a company that has this issue will show no rating. It will also be taken out of the ratings for its geography and industry. This reflects the fact that some of our users feel so strongly about special issues that they are uncomfortable with seeing any rating for these companies. Watch a brief video on setting special issues
Back to top
Search for Information
How do I search a company?
Simply start entering a company name or ticker in the top right text box where it says "Look for a company" in the top banner throughout our site. Choose a name from the list, if more than one company shows. Or, enter the entire company name and click the Search button. You may also choose Search from the top menu to go to the Advanced Search area. Watch a brief video on this topic
How do I use the logic function in advanced search (or, how do I search for more than one thing at a time)?
The logic function enables users to specify their preferences. To search for companies with an exact score only (e.g. 65), use “=”. If you’d like to find companies with a specific or higher rating, use “>=”(e.g. 65 and up) and for a specific rating or lower “<=”(e.g. 65 and lower). “<”and “>”will exclude the value you enter and only give you lower and higher values (e.g. 64 and lower or 66 and higher). You can use 525+ sources to conduct unlimited advanced logic searches for industry, data source, geography, name, score and special issue or category rating. e.g. Find the top 5 USA companies in the Alternate Energy industry, who reported to GRI and have Environmental scores >50 based on a specific profile. Watch a brief video on this topic
Back to top
What is a Saved Screen?
A saved screen saves your search logic (the various terms you searched at one time) and results.
How do I save a Screen?
After you have applied your search logic, you may “Save or Load a Search Screen”. Watch a brief video on this topic
Does a Saved Screen retain my search list results?
Saving a screen saves the logic of the search. If the data base changes, the results will change, but the saved search process stays the same. You can set up whatever you want to see and then run the same query consistently, each time.
How can I change how the search results are displayed?
From the Search page, choose one of the default layouts to the right of "Select your list layout from these choices"below the Companies found section. You can also click in the top title of the column to sort the information based on that column, toggling between ascending or descending order. For example, if you click on Overall or one of the category names, the companies will sort in order based on the Overall score (or category score) in ascending or descending order. To toggle between ascending and descending order, simply click on the grey triangle below the column title. So, you could see the best and worst companies' Governance scores in our database, based on a specified profile.
How do I change List Layout to customize how search results show?
Full Access subscribers can customize list layout to varying degrees (see them listed in How to Export below). Watch a brief video on this topic
How do I Export my search results?
Full Access subscribers have full access to customize list layout and export the following:
company name, overall, category AND 12 subcategory scores, ticker, industry, special issues, country, state/province, city, zip, website, CSR site, region, industry group, secondary industry and tertiary industry (CSRHub tracks as many as 3 industries per company).
You may export using the grey “ Export ”button that is just under the “ Companies found :”text on the search results page. Many users seem able to “slice and dice”the company list down to show the set of companies you need, using the “Add logic”pulldown and multiple layers of search (See Search for information section), and then copy data from the search area.
However, if you have a specific list of companies you want to review, you can instead build a “saved list”of companies. You can then export the saved list data using the second Export button that is down near the bottom of the search results page, near the grey bar that says “Saved list.”Basically, you find the companies you want and put them into your list, save the list and then it will be ready to export.
All exports contain the columns you see in your search results. You can change from the default to one of the alternate default layouts, using the pull down that is just under the first export button (the one in the green section) and that is to the right of this text: “Select your list layout from these choices.”.
If you don’t like any of the layouts we offer as defaults, you can make your own list layout by going to the list layout section of the My CSRHub area ( http://www.csrhub.com/list_layout). Watch a brief video on Changing List Layout.
How do I convert the exported data to a sortable format in Excel?
A. Highlight the left column on your spreadsheet (the one that holds the data).
B. Go to the “Data”menu in Excel and pick “Text to columns”conversion.
C. In the menu for conversion, tell the wizard to use “semicolons”as a “delimiter.”
The reason we use semicolons as a delimiter is because many company names contain commas and other special characters. Fortunately, to date, none contain semicolons! This should result in a nicely formatted table with headings and each item in a sortable format.
Back to top