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

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)

Skills: Excel, Web Scraping, Data Entry, Data Mining, Web Search

See more: freelance scrape small business data, scrape search engine data, public domain data, scrape web page data daily, php screen scrape example extract data, scrape amazon movie data xml, scrape poker sites data mine, scrape scraping job data, scrape ajax html data, python scrape html generated data, sec data extraction, sec data, scrape financial index data, india world private public email data base, data flow diagram project advertising, perl scrape code extract data web page, scrape public facebook data

About the Employer:
( 0 reviews ) New York, United States

Project ID: #22289408

10 freelancers are bidding on average $97 for this job


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 More

$72 USD in 2 days
(480 Reviews)

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 More

$150 USD in 2 days
(154 Reviews)

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 More

$61 USD in 1 day
(31 Reviews)

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 More

$100 USD in 5 days
(34 Reviews)

Hi I did more than 300+ scraping project, please view my profile page here then you will know I will get you all the required data from whichever source you need. Please b More

$140 USD in 5 days
(0 Reviews)

Hello, I'm David, I can provide you perfect work as you looking for . we can discuss more in chat . I will be waiting for your response . I have very great experience about your project , if you want discuss more plea More

$140 USD in 7 days
(0 Reviews)

Hello I have Excellent skill & over 4 years Experience in Up-Work.I have Most Experience- Virtual Assistant, Data Entry, Web Scraping, Web Research, Data Processing, Data Collection Excel/Word,Leads Listing (Peopl More

$30 USD in 7 days
(0 Reviews)

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 in 3 days
(0 Reviews)

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 More

$30 USD in 3 days
(0 Reviews)

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 More

$140 USD in 7 days
(0 Reviews)