PitchBook in WRDS

Penn researchers have access to PitchBook, a popular private capital markets resource, via its native interface. However, Individual users are subject to download limits of 10 daily/25 monthly rows of company, deal, or fund data, as well as 10 daily/25 monthly rows of people data. For researchers needing more downloads, Wharton Research Data Services, or WRDS, offers PitchBook private equity, venture capital, and additional private placements data.

image of PitchBook landing page on the Wharton Research Data Services (WRDS) platform

PitchBook data available in WRDS covers all aspects of private capital raising, featuring more than 1.6 million deals, 3 million companies including more than 660,000 private companies, 31,000 funds, and 300,000 investors. Deals provide a transaction-level view, fund data focuses on each fund held by an investment firm, and the company and investor data is presented at the business entity level. Though much of the data in PitchBook reflects only the most recent update available, also referred to as “header” data, more comprehensive data begins in the late 1990s/early 2000s, with 1% of historical coverage prior to 1992 increasing to 5% by 2000 and 10% by 2004. WRDS is developing snapshot integration that will begin to create a “history” of PitchBook header data.

Datasets from PitchBook are organized on the WRDS platform as follows: Venture Capital North America, Venture Capital Rest of World, Private Equity North America, Private Equity Rest of World, Other Data North America, and Other Data Rest of World. Within each dataset, the following queries are available: Company, Deal, Fund, and Investor. Company variables include ticker and Central Index Key (CIK) identifiers, industry descriptions and codes, and financing details. Deal variables include dates of deal announcement and completion, amount of capital invested, deal status, percentage of stake acquired, transaction categorization, detailed transaction summary, and valuation measures. If applicable, IPO details are available. CEO biographies and education summaries are also retrieved through a Deal query.

Variables in the Fund query include fund preferences, a breakout table of the fund’s direct investments, and whether the fund received investment capital from a Small Business Investment Company, a privately owned and managed investment fund licensed and regulated by the U.S. Small Business Administration. Investor query variables include investor and summary-level fund details, investment activity, and aspects of investor targets.

In addition to the four primary queries, there are 15 “relation” queries, each focusing on two categories of variables. Researchers interested in a list of a particular company’s competitors will be interested in the Company Competitor Relation query, while those examining deals entered into by certain investors will find the Deal Investor Relation query useful. There are even relation queries for deals and their tranches and deals and their beneficiaries.

From a query page, use the Data Preview tab to view the first ten rows of data for selected variables and conditional statements from the chosen data table. From the Data Preview page, the first 1,000 rows of data can be downloaded directly in xslx, api, or json format. Alternatively, click the Access All Data button on the Data Preview page to open SAS/Studio at WRDS, a web-based version of SAS, to access all data.

PitchBook documentation includes a spec file containing variable definitions, comments, and sample data. The WRDS Overview of Pitchbook page features a visual representation of PitchBook dataset organization, database usage notes, and guidance for linking PitchBook data to other datasets.  

Whether you want to track company growth, explore company financing or deals, or investigate investors, consider using PitchBook in WRDS. Contact Lippincott Library for assistance.

Unpacking Consumer Packaged Goods with Mintel’s Global New Products Database

The Mintel Global New Products Database (GNPD) is a new Lippincott Library resource for researching the consumer packaged goods (CPG) marketplace. GNPD focuses on new products in the food, drink, beauty and personal care, home care, health and hygiene, and pet markets in 86 countries. Mintel has been monitoring products since the 1990s and adds more than 30,000 product launches to GNPD each month. In addition to new products, GNPD includes relaunched, reformulated, and repackaged products and new varieties or extended ranges of existing products. Helpful tip: if a product is purchased by another company, Mintel categorizes this as a “relaunch” and creates a separate GNPD record reflecting the new company’s ownership.

Mintel users may have encountered GNPD content during general searches on the Mintel platform. GNPD data and information appears in Mintel Country and Global reports, under Content Type: Innovative Products, and when using the Product Features filter. Now, users also have the option to search within GNPD exclusively.

To access GNPD from the Mintel platform, navigate to the Analytics menu at the top of the page and scroll over Products. From there, you can perform a basic keyword search, access the Advanced Search tool, research ingredients, and explore CPG trends.

Mintel Global New Products Database landing page

Basic keyword searching provides quick access to new products. Every field in GNPD is keyword-searchable. Search suggestions allow you to drill down by product name, company name, flavor, fragrance, ingredients, and more.

Mintel GNPD search suggestions for  keyword search for "ice cream"

Use the filters on the search results page to focus results on region, product claim, ingredients, company, and more. The “Refine search” free text box allows for keyword searching within results.

Mintel Global New Products Database search results page for "ice cream"

Advanced Search allows you to limit a search by multiple filters, many at a detailed level, enabling a refined list of results:

Mintel Global New Products Database Advanced Search page

The example below reflects an Advanced Search for the key phrase “ice cream” in the product description, limiting to products containing the ingredient almond milk, and limiting geography to Latin America:

Mintel Global New Products Database Advanced Search for "ice cream" with results limited to those containing the ingredient almond milk and within the geography Latin America

Results can be sorted in several ways, including by geographic Market:

Mintel Global New Products Database search results page with option to sort results by Market outlined

Drilling into a product record yields Product Details including package size, product positioning claims, as well as Company & Source Details including manufacturer, retail store where the product was purchased, and the product price:

Mintel Global New Products Database product record reflecting information on Product Details tab
Mintel Global New Products Database product record reflecting information on Company and Source Details tab

Product records also include nutrition facts, packaging information, product variants (when available), and links to GNPD records for similar products:

Mintel Global New Products Database product record reflecting nutrition facts and packaging information
Mintel Global New Products Database product record reflecting product variants and links to Global New Products Database records for similar products

The Advanced Search function is also accessible from the basic search results page by clicking the “Edit with advanced search” link.

Product records can be downloaded into Microsoft Word, Excel/CSV, PowerPoint, or HTML. Customizable templates are available for Excel and CSV downloads. Product images can be downloaded as JPG files.

GNPD search results can be visualized, charted, and tabulated for trend analysis. Search results may also be shared through a direct link. To save GNPD searches, create a free Mintel personal profile using your Wharton or Penn email address. From a search results page, click “Save search,” name the search, and save it. You can also create email alerts for new products meeting your search criteria.

The GNPD Hopper is similar to the basket feature in Mintel reports. From a search results page, click “Add to Hopper,” then “Create new Hopper.” Name the Hopper, add records to it, and save it. You can also add Hopper comments and share Hoppers. Saved Searches and saved Hoppers are accessible from the Products page under the Analytics menu.

This is merely a brief highlight of how GNPD can streamline research in the CPG sector. To learn more about GNPD’s many tools and features, the Help & Training section accessible from the top right side of the Mintel database includes a Glossary, User Guide, and forthcoming training videos covering basic and advanced searching within GNPD.

This video from Mintel demonstrates popular GNPD features mentioned above:

For additional assistance with Mintel GNPD, please contact a Lippincott Librarian.

GNPD covers June 1996 to present. For CPG data and information prior to 1996, search GNPD’s PDF Archive, which dates back to 1973.

At last, Pitchbook has come along…

Lippincott Library is proud to announce the addition of Pitchbook to our list of business resources. Covering a vast array of data related to private capital markets, Pitchbook can provide the Wharton community with research information on private equity and venture capital. You will need to create an account, based on your Penn email address. There are download limitations:  Each individual has 25 downloads per month and can use up to 10 in a day.  Unlimited access using the API function in excel is available for public companies.

Continue reading

Corporate Affiliations and ReferenceUSA’s “Way Back” Machines

Web-based company directories have many advantages over their print counterparts, but in one area they frequently fall short; they rarely include historical information. Financial databases of public companies such as Bloomberg, Thomson One, and S&P COMPUSTAT will include extensive historical financial data, but if you are looking for a private company’s address, product line, or executive names as of 1995, you would do better with a 20 year run of a printed directory than with its current online counterpart.  This pattern is changing as information vendors become aware of the market for historical company data. Two examples of corporate directory archives are the historical research sections of Corporate Affiliations and ReferenceUSA.

Corporate Affiliations shows the corporate structure of more than 1 million public and private companies world-wide with subsidiary listings and corporate linkage.  For more information please see:  Private Company Research Part 2:  Corporate Affiliations. The Historical Research module of the database gives company addresses, products, SIC numbers, names of executives and directors, and key financial data for every year from 1993 to date. As the menu below indicates, you can search by company name, or screen by one or more variables. A company (ENRON, for example) does not have to be in business currently to be included in the historical file. To reach the Historical Search menu, follow this path from the main Corporate Affiliations’ menu:

Subscriber Tools => Historical Search

Corp Affiliations History First Menu

 

 

 

 

The record for Motorola Solutions, Inc. shows how the data is presented for a single company.  Clicking on the date tabs (‘1993’ etc.) will include the data for that year in the output.

Corp Affiliations Historical 1

 

The historical treatment of changes in SICs and product descriptions will include as many as 14 SIC numbers and descriptions for each company.

Corrp Ailliations Historical 2

 

 

 

 

 

The company record for all years and all variables can be downloaded as a text .CSV format which EXCEL will read.

Here is the result of a screen for companies in Philadelphia in 1993.

Corp affiliation Phila

 

The WEB display of the results is only a small fraction of the EXCEL record, which will give details for all variables (SIC, executive name, financial data, etc.). If the entire date range is requested, the downloaded record will list the companies alphabetically and then give variable details for each year.

However, there is a display limit of 1,000 records per search.  For example, a search for all companies in France with data for all years will produce a set of more than 1,000 records, but only 1,000 records from the set will be displayed.

ReferenceUSA’s current company directory contains 24 million U.S. company records plus records for an additional 1.5 million Canadian companies. The database’s historical businesses  module contains 151 million U.S. company records from 2003 through 2013.

To see the menu below:

U.S. Historical Business Database => Custom Search

REfUSA Main Menu

 

 

 

 

 

 

REFUSA beer list 2003

For example, a screen for breweries (Primary NAICS 312120)  in Pennsylvania in 2003 will produce this display:

 

Clicking on an individual company name will display a record giving the 2003 address, phone, sales volume, employee size, SIC/NAICS codes, as well as graphs of sales volume and number of employees for all available years between 2003 and 2013.

Downloading the records in  EXCEL and requesting “detail” will display all the variables available for the company for the given year. However, there is a limit of 250 records per download.  Requesting all records for a company for the range of years (2003 – 2013) will give a line of data for each year. In this way, you can determine if a company changes its name during the ten year period. For example, the company listed as “Pittsburgh Brewing”  from 2003-2008 is listed as “Iron City Brewing” between 2009 and 2012 and then as “Pittsburgh Brewing” again in 2013.

Companies can be mapped by number of locations, employee or sales size and displayed as “heat maps”. For example, the heat maps below show the doubling of  the number of breweries in Pennsylvania  between 2003 and 2013 (from 27 locations to 69).

CombinedHeat

The  availability of  the “back files” of ReferenceUSA and Corporate Affiliations are an important step in filling the gap in digital historical directory information.

For additional information on company histories see this posting: Don’t Know Much About “Corporate” History.

Also see our Research Guides:  Company Information and Business History Resources.

 

Check-in on Foursquare

The Lippincott Library has been physically located in the Van Pelt Dietrich Library Center since the late 1960s, but its virtual Foursquare presence was minimal until June 2012 when it became an official location on the social media website.

LippincottFoursquare

Check-in at the Lippincott Library’s Foursquare Location and keep your eye out for upcoming check-in specials. We will be offering a number of specials during the semester to promote our Foursquare location. Specials will include a limited number of coupons for a free cup of coffee at Mark’s Cafe and a raffle for a copy of an interview prep book like Case in Point or Crack the Case.  Help us build our page by leaving tips like a database you’ve found useful or a service you’ve found helpful.

Take the Data and Run: The Sports Business Research Network

Sports Business Research Network (SBRNet) bills itself as “The Source of Knowledge for the Sport Industry”.  This is a “must have” database for academic libraries documenting the business of sports. Covering more than 50 sports —  from Archery to Yoga – SBRNet provides extremely detailed data on market size, demographics, sports participation, licensing, financial and retail trends, as well as international marketing and professional sports trends.

It includes buyTRACK, which tracks the sales of sporting goods purchased on the Internet. In addition, SBRNet covers stories related to sports business in 80 or so magazines and journals, ranging from general sources such as Business Week, to the sport specific, e.g. Baseball Business Journal.

The table excerpt below will give you a sense of the granularity of the market data available from SBRNet. Continue reading