日本と海外をつなぐクラウドソーシング

Object: Identify and extract commercial comments in tweet posts.

Requirements:
The task does not require any specific analytical skills, but requires basic Excel skills.
The task requires you to read through the tweets posted by athletes and take memos when you find corporate/ product names in their tweet texts.

Data volume: 119,324 tweets
Method: See the example sheet attached
Identify commercial comments (including corporate name, product, champaign, university name) in the list of tweet posts (text colum) and extract commercial elements in the right columns.

Categories of the commercial elements:
I. Corporate
Example post: " Just joined the @Killerspin family! So excited :D"
Commercial element: "Killerspin" (table tennis equipment company)
Operation: Put "Killerspin" in the "corporate" column

II.product
Example post: "RT @TheSliceTweets: Hanging out at Duane Reade with @Bryanbros @Bryanbrothers and the @NestleNesquik Bunny! http://t.co/DkhUtrk0"
Commercial element: "NestleNesquik"
Operation: Put "Nesquik" in the "product" column

III.university(affiliation)
Example post: "A pic with the @Reds Rosie Red. She is now my 2nd favorite mascot behind of course Stanford's The Tree. http://t.co/Wynld4u8"
Commercial element: "Stanford"
Operation: Put "Stanford" in the "university" column

IV.champaign
Example post: "Yesterday we stopped by the USA House to see the @CitiEveryStep Footprint Wall. What a honor to be on there. http://t.co/oTetsolC"
Commercial element: "CitiEveryStep"
Operation: Put "CitiEveryStep" in the "campaign" column

V. Other
Other posts including commercial intention

*note: if there are several commercial elements in a post, extract all elements and put them into appropriate columns
Example post: "Nestle If all goes wrong at the Open at least we'll leave as the Nesquik ping pong champs. http://t.co/kMLQpTS0"
Operation: "Nestle" to "corporate" column, "Nesquik" to "product" column

if there are several commercial elements but in the same category in a post, extract all elements and put them into same category colums
Example post: "RT @asiance: @topspinmovie @ArielHsing hahah yeah! We're working on them!! Killerspin"
Operation: corporate："asiance"（new line）"Killerspin" to the "corporate" column