Intrinio is proud to announce that executive contacts and compensation data will now be available in the Financial Data Marketplace. This dataset from Greensight is broken into two data feeds, one for the United States and one for international executives. Both feeds include direct email and direct phone numbers for key leaders at major corporations as well as 4+ years of compensation data. This article explains what is included in these new feeds and the cost to subscribe, how to access the data in Excel, and how to use the Executive Contacts API.
What is included and what does it cost?
The executive compensation data is split into two data feeds. The US Executive Contacts and Compensation data feed is the smaller of the two datasets, covering 4,604 companies in North America with 52,804 contacts. The International Executive Contacts and Compensation data feed covers 15,684 companies around the world with 87,175 contacts. Both feeds include similar data points for the individuals that run the world’s businesses:
- 1,300+ new contacts each month
- Direct emails for 75% of contacts, direct phone for 27%
- Data for CEO, CFO, Corporate Secretary, General Counsel, Treasurer, Investor Relations Officer, Corporate Development/Strategy, Board Members
- Compensation data including 4 years of history, salary, bonus, options
The most obvious use of this data is for getting in touch with decision makers, but another use case is for investors who want to systematically track changes in management. The compensation data is another indicator of company performance to consider when analyzing an investment in a firm. Collecting this data manually is time consuming and expensive and can delay decision making.
Both data feeds are available in the developer sandbox, so users can test the data. Startup plans offer discounts to companies that meet revenue and funding requirements and need to redistribute data through their application to their own end users. If you need a custom plan because you don’t qualify as a startup or need more daily data, just shoot us a message.
How do I access Executive Contacts API Data In Excel?
If you are unfamiliar with Intrinio’s Excel add-in, this tutorial will walk you through the install. This free tool will enable you to pull data into Excel and have that data update whenever the data in Intrinio’s database updates. This makes it easy to build lists of contacts with emails and phone numbers as well as compensation data for analyses in Excel.
Start by subscribing to a plan for either the US data feed or the international data feed. The trial will update your access keys so you can sample the data and a paid plan will give you a set amount of daily data. Once you have a subscription and have installed the Excel add in, you can use the datapoint function to pull the most recent data for an executive:
Pulling the Total Compensation for Elon Musk into Excel
You can also use the historicaldata function to pull in up to 4 years of compensation history:
The full documentation for pulling executive compensation data into Excel is available here. You can look up the different tag options, items like Cash Paid and Option Awards, in the Data Tag Directory. If you want to make life really easy, use the API Explorer. This free tool will build the Excel syntax for you so you can just copy and paste it into your spreadsheet.
How do I access Executive Contacts Data Via API ?
The full documentation for the Executive Contacts API is available here. It’s important to remember that in many cases there are many pages of data – this article gives examples of how to get started with Intrinio’s API and how to use the pager. If you want to pull a list of all executives, start with this call:
This call will return the identifier and name as well as the location of the individual (US/Non-US). You can pass a company symbol to subset the data based on your company of interest:
Using these identifiers, you can begin systematically pulling contact and compensation data for these executives:
The documentation provides many more examples, but it’s easy to see how an executive contacts API would make it easier to systematically track contacts and their compensation and even sort by company. The API Explorer is a great tool that will make the syntax easier. Just scroll down through the data types and select the Executive Compensation data types you are interested in:
Why Use This Feed?
Intrinio works to partner with companies that want to make financial data affordable and accessible. That’s our mission, and it’s a mission that Greensight shares. Making their executive compensation and contact data available in Excel and via API through Intrinio offers exciting possibilities.
Use the data for your marketing and sales efforts, as well as to pick up alpha in your quant models. Tracking changes and compensation systematically is a creative way to gain insight into the value of a company. Send us your ideas, your questions, and your dreams – we can’t wait to see what you build with this new data set.