Scrape public SEC data (10-ks, 10-qs, 990s) for Advertising/Marketing costs/spend
$30-250 USD
Closed
Posted over 4 years ago
$30-250 USD
Paid on delivery
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)
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 to 7
We will deliver you the final file by tomorrow evening.
Thanks
Vishal
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 with you in chat.
Thanks!
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 output, so we can able to start for live samples.
Thanks
Harsha
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 quality expectations. Looking forward to work on your project. Thank you.
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 you anytime in your timezone.
I will wait for your reply.
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. Thank you