I need a bot, compiled into a .exe file, that does the following:
1. Pull URL from a database
2. Plug URL into [login to view URL]
3. Determine if the URL is "Quantified" or not
4. Scrape information from "Quantified" sites into one database
5. Scrape information from not "Quantified" sites into a second database
This project will include many thousand URLs and I will need the raw files to repeat the process at some point in the future. The attached Excel sheet shows what I am looking for. The first worksheet is an example of the database you will receive with the URLs. The second and third worksheets are examples of what information you need to pull for both Quantified and non-Quantified sites. The Visits, People, and Page View data must be scraped from the "Traffic" tab of each URL, NOT from the "Summary" tab.