327
edits
Changes
Jump to navigation
Jump to search
#*'''STATUS''': Complete
#*'''Previously Collected''': YES/NO - Recorded 2/1/0 to represent activity level, but not same as we are
#*'''Published on Mechanical Turk''': Yes
#*'''AUDITED''': Yes
#**'''Audit Results''': Comparing to 30 that manually done, for '''twitter handle,''' all 3 turkers agreed with our results 81% of the time, but at least 2 turkers agreed with our results 98% (the exception was a company that had several twitter handles based on location). Results were 52% and 89% respectively.
#*'''UPDATES''':
#**'''UPDATE (7/14)''': Updated turk to reflect our desired formats
#**'''UPDATE (7/12)''': Audited
#**'''UPDATE (7/11)''': uploaded and published on amazon's mechanical turk site. Given the time cost to either record number of tweets in a month or look up more than 10 tweets, we decided to record the date of the last 10th tweet. Using a sample of ~10 companies, We noticed minimal differences in data observations among using 10,20, and 30 tweets.''
#*'''CODE''' (7/14)
#*#Copy the text in the Search Text into a search engine.
#*#Click on result from twitter.com with the company name. If the link does not appear on the first 3 pages, record DNE for both outputs
#*#Record the company's Twitter Handle into Twitter Handle
#*#Record the date (MM/DD/YY) of that tweet for Twitter Activity. If there are less than 10 tweets, record DNE.
#*'''STATUS''': In Progress#*'''Previously Collected''': YES#*'''Published on Mechanical Turk''': NO/No Need (Veeral)#*'''AUDITED''': NO#**'''Audit Results''': TBD#*'''UPDATES''':#**'''UPDATE (7/22)''': Veeral has code to do this procedure #**'''UPDATE (7/18)''': Code written, expected time for each assignment is <15 seconds - pay ratesearch company, therefore, recommended $.04 #*'''CODE'''#*#Copy the text in the Search Text into a search engine.#*#Record the URL of the first result city in the following format ___.__/ (e.g. if url is example.us/other, record example.us/google)
#*'''STATUS''': In Progress
#*'''Previously Collected''': YES
#*'''Published on Mechanical Turk''': NO
#*'''AUDITED''': NO
#**'''Audit Results''': TBD
#*'''UPDATES''':
#*#Click on first result. If addresses exist, record in ADDRESS, STATE, and ZIP.
#*#If not, go to company's URL. If addresses exist, record in ADDRESS, STATE, and ZIP.
#*#If address exists, but ZIP does not, plug in address into search engine and record ZIP.
#*#Otherwise, record DNE.
#*'''STATUS''': In Progress
#*'''Previously Collected''': YES
#*'''Published on Mechanical Turk''': NO
#*'''AUDITED''': NO
#**'''Audit Results''': TBD
#*'''UPDATES''':
#*'''STATUS''': In Progress
#*'''Previously Collected''': YES/NO, based on LinkedIn identifier
#*'''Published on Mechanical Turk''': NO
#*'''AUDITED''': NO
#**'''Audit Results''': TBD
#*'''UPDATES''':
#*'''CODE'''
#*#NONE
#*'''STATUS''': In Progress
#*'''Previously Collected''': NO
#*'''Published on Mechanical Turk''': NO
#*'''AUDITED''': NO
#**'''Audit Results''': TBD
#**'''REQUIRES ADDITIONAL STEPS''': YES (need to double check results)
#*'''UPDATES''':
#**'''UPDATE (7/19)''': Code written, code 2 of 2 is believed to be more accurate and efficient. Expected time to complete is 15 seconds - pay rate, therefore, recommended $.04
#*'''CODE 1 of 2'''
#*#Go to Company's URL.
#*#Go to links (sometimes will be sections of the URL page) that describe the company, usually they are labelled: 'About', 'Our Story,' 'Mission'.
#*#If none of these exist, record DNE for PAGES
#*#Look for the word 'profit'/'nonprofit'/'non-profit'/'not-for-profit' (with or without -)
#*#If any of the key words exist is identified, record as 1, otherwise 0 for EXISTS (1/0).
#*#If it is marked as 1, record all sentences that the word is found in under SENTENCES.
#*#If the links do exist, record the name of the link under PAGES
#*#Repeat steps 4, 5, and 6 on the pages that were linked.
#*'''CODE 2 of 2'''
#*#Record all Organization Names that appear
#*#If no results appear, record DNE
#*'''STATUS''': In Progress
#*'''Previously Collected''': NO
#*'''Published on Mechanical Turk''': NO
#*'''AUDITED''': NO
#**'''Audit Results''': TBD
#*'''UPDATES''':
#*#Record all Partners from Search Text 2 into PARTNERS. If there does not exist a list or the link was for only 1 partner, record DNE.
#*#If any Partners from Search Text 2 include a University or College (will be listed in name), record them into UNIVERSITY PARTNERS
→Group 1
===Group 1===
#Twitter Activity
#**'''UPDATE (7/20)''': Gunny has created a tool to do this process
#URL
#Address
#**'''UPDATE (7/22)''': Code written. Difficulties occur with very large companies (e.g. Impact Hub). Will require Veeral's program, expected time for each assignment is 10-20 seconds - pay rate, therefore, recommended $.05
#*'''CODE'''
#*#Using Veeral's code, crossproduct allintext: (Group A) and site: (Group B), where '''Group A'''=Contact (high coverage), About Us, Find Us, Locations, Address, '''Group B'''= Company URLs.
#Mission Statement
#**'''UPDATE (7/18)''': Code written, expected time for each assignment is 20-30 seconds - pay rate, therefore, recommended $.08
#*'''CODE'''
#*#If no text exists, record "DNE"
#Specific Industry
#**'''UPDATE (7/21)''': Given that most companies include their specialty in mission statement and difficulty to turk, we will manually check each mission statement and mark it accordingly.
#Nonprofit
#*#Copy the text from Search Text into the search bar at http://www.guidestar.org/.
#Sponsors/Partners
#**'''UPDATE (7/21)''': Code written, but may require additional manual work. Expected time to complete is 45 seconds due to a potential list of a lot of sponsors/partners - pay rate, therefore, recommended $.12.
#*'''CODE'''
#*#Record all Sponsors from Search Text 1 into SPONSORS. If there does not exist a list or the link was for only 1 sponsor, record DNE.
#*#If any Sponsors from Search Text 1 include a University or College (will be listed in name), record them into UNIVERSITY SPONSORS
#Price for a space + office
#*'''STATUS''': Not Started
