Start with data on the biggest B2C advertisers

marcdotson / earnings-calls

Exploration of relationships between marketing and valence term use and quarterly firm performance.

MIT License

0 stars 0 forks source link

Start with data on the biggest B2C advertisers #1

Closed marcdotson closed 2 years ago

marcdotson commented 2 years ago

To test a proof-of-concept, let's start with the biggest B2C advertisers only (e.g., McDonald’s, PepsiCo, Coca Cola, Nike, Apple, Walmart). None of the data will be pushed, but we need an initial script searching for and wrangling these earnings calls specifically.

Note that there is information included in each .txt file that we'll want included as part of the analysis.

marcdotson commented 2 years ago

The name of each file includes:

GVKEY a unique six-digit number key assigned to each company (issue, currency, index) in the Capital IQ Compustat database (i.e., the company ID)
Date of the earnings call, which may not match exactly with the supplementary data

marcdotson commented 2 years ago

The Compustat Fundamentals Quarterly includes:

revtq revenue total quarterly.

marcdotson commented 2 years ago

Starting with just this group is fine, but we can handle all of the data after import.