Scrape public SEC data (10-ks, 10-qs, 990s) for Advertising/Marketing costs/spend

종료 등록 시간: 4년 전 착불
종료 착불

Essentially trying to find out how much each company spends on advertising and marketing, specifically digital (though most companies don't specify), and how much that amount has changed from last year and from last quarter. Also want to see how many third-party services they employ.

1. Pull data from quarterly and annual reports for all publicly traded companies in the US and set up feed that refreshes daily to pull from new filings that:

2. Extracts any instance of SG&A, 'selling, general, and administration', advertising, marketing, third-party, third parties, and the surrounding context (which will be either a financial table or a full section of text within an item) (case insensitive please)

3. Export into a csv or some other readable excel file

4. Should have columns for company name, sector, industry, market cap, and each cell for each company should have the extracted instance with full context

5. For SG&A or advertising costs or marketing costs, calculate the difference from the last year and this year in one cell and have another cell for this quarter minus last quarter

6. Bonus if you can add a column for the type of corporation (specifically interested in Benefit corps being tagged as such)

7. Do the same for public non-profits from Form 990 (text less necessary, more interested in Advertising/Marketing expenses and difference in spend between this year and last year which should be located in Part IX, Item 12)

엑셀 웹 스크랩핑 데이터 입력 데이터 마이닝 웹 검색

프로젝트 ID: #22289408

프로젝트 소개

8 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 4년 전

이 일자리에 대한 프리랜서 8 명의 평균 입찰가: $87

Dhruvika111

Greetings! Dear Buyer! We will complete the job as you require "Scrape public SEC data (10-ks, 10-qs, 990s) for Advertising/Marketing costs/spend" We will collect all the details as you mention and require. Point 1 기타

$72 USD (2일 이내)
(527 리뷰)
8.3
mananraja

hi, I have read you project description in detail and have some question to ask from you. I have experience in WEB SCRAPING and AUTOMATIC DATA MINING on freelancer with good reviews. I would love to talk more details 기타

$150 USD (2일 이내)
(164 리뷰)
6.5
TTSL

Hello! Dear Hiring Buyer! We will collect the data as you require from the US of "all publicly traded companies in the US" with all the required points. Can you please suggest the format you require in the final out 기타

$61 USD (1일 이내)
(46 리뷰)
5.7
zeke

I have done many similar projects related to web scraping information from different websites. Very interested to work on this project. I am absolutely confident I can finish this work on time and on budget to highest 기타

$100 USD (5일 이내)
(37 리뷰)
5.7
sonupd

I have read your work and understood nicely and ready to do your work. I will complete your work within the given time period without any delay

$111 USD (3일 이내)
(0 리뷰)
0.0
Logerbang

Hello! I am a web developer. I've read your job description with great interest. I've fully understood what you want and if you hire me, you would get the best result. I can start work immediately and can chat with yo 기타

$30 USD (3일 이내)
(0 리뷰)
0.0
gttem

Hello, dear Customer. I am interested in your project and feel confident after reading your project description. Please contact me so that we can discuss it in more detail. Looking forward to hearing from you soon. Tha 기타

$140 USD (7일 이내)
(0 리뷰)
0.0