Trackur
0 views
Skip to first unread message
Linda Ly
Jul 3, 2013, 11:12:36 PM7/3/13
to <wth-hmba-2014@googlegroups.com>
Man it took over an hour to get the csv file to download. I'm cleaning it up a bit and will send it to you guys when I finish up. I think we can get by just using "magna carta" as our search term. I couldn't find much more data when I used different terms and it seemed like all the results that did come up had magna carta in it somewhere.
Thought you guys would get a laugh out of this tweet I just saw in the data:
Magna Carta Holy Grail sounds like something that Paris Hilton's gynaecologist would say after assessing the source of her fame & talent.
Linda Ly
Jul 4, 2013, 12:08:59 AM7/4/13
to <wth-hmba-2014@googlegroups.com>
Here's the file. The first tab is the original data. The second is the one I scrubbed. I added a date column but that is the extent of my data mining skills. Then I deleted everything before 6/16/2013 as none of it applied to the Jay Z album. Then I kind of skimmed the rest and deleted ones that did not relate to Jay Z. The yellow highlight is in another language but looks like it is for Jay Z (idk how useful this will be for us since I'm sure sentistrength does not know other languages). The red highlight is a negative comment that stood out to me. The green highlight is a positive comment that stood out to me.
So it seems to me the commercial during the NBA game started the hype. Then slowly other things came along like a scavenger hunt to find out the songs on the album and then some lyrics were released which kept the hype steady. It also seems like since Samsung bought 1 million copies, on the release date the album will automatically start off as platinum and there were lots of comments on how this can change the music industry and RIAA standards. Also, almost half of the data was posted in the past few days. After skimming all those posts, I am hyped up about it. Great marketing by Jay Z!
I'll pull another one in the AM before I get on my flight so we can see what happened overnight. I think there is going to be a ton of stuff that happens overnight and tomorrow!!
Trey Watkins
Jul 4, 2013, 7:56:17 AM7/4/13
to wth-hm...@googlegroups.com
Great work, Linda! I read the other day that those million albums won't count towards platinum status so we'll get to the bottom of that, but the reaction regardless is what we're looking at I guess.
--
You received this message because you are subscribed to the Google Groups "WTH HMBA 2014" group.
To unsubscribe from this group and stop receiving emails from it, send an email to wth-hmba-201...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
<LL-magna carta-results-07032013.csv.xls.xlsx>
Linda Ly
Jul 4, 2013, 8:13:43 AM7/4/13
to wth-hm...@googlegroups.com
Attached is the one I pulled as of 6AM this morning and only has data for 7/3/13 and up until 6AM 7/4/13. I must be a retard because I can't figure out how to sync it back up with yesterday's data so we don't have data that overlaps. Maybe trackur doesn't pull the data down in any order other than date. Anyways I left all the 7/3/13 data in. Over 600 posts from midnight to 6AM. Sasha can pull data for the next few days. I'll pull some more on Sunday when I get back from DC.
If you want to hear the album, there's a bunch of streaming leaks. I was listening this morning here: http://www.gigwise.com/news/82711/full-stream-of-jay-zs-magna-carta-holy-grail-appears-online
Lavan Reddy
Jul 4, 2013, 12:40:03 PM7/4/13
to wth-hm...@googlegroups.com
Good work Linda. Enjoy the short break.
Sent from Lavan Reddy's iPhone
Sent from Lavan Reddy's iPhone
Attached is the one I pulled as of 6AM this morning and only has data for 7/3/13 and up until 6AM 7/4/13. I must be a retard because I can't figure out how to sync it back up with yesterday's data so we don't have data that overlaps. Maybe trackur doesn't pull the data down in any order other than date. Anyways I left all the 7/3/13 data in. Over 600 posts from midnight to 6AM. Sasha can pull data for the next few days. I'll pull some more on Sunday when I get back from DC.If you want to hear the album, there's a bunch of streaming leaks. I was listening this morning here: http://www.gigwise.com/news/82711/full-stream-of-jay-zs-magna-carta-holy-grail-appears-online
<LL-magna carta-results-07032013&07042013 6AM.csv.xls.xlsx>
Alexander Petrovic
Jul 7, 2013, 10:59:12 AM7/7/13
to WTH MBA Group
See data set for the 4th - 7th
Linda...let connect later today to discuss because I have a few questions about how you scrubbed the data.
Lavan Reddy
Jul 7, 2013, 10:16:26 PM7/7/13
to wth-hm...@googlegroups.com
Guys,
Is the data ready for me to run sentistrength analysis? I don't see anything on dropbox, i.e. the filtered results.
Lavan.
Tony Nguyen
Jul 7, 2013, 10:24:18 PM7/7/13
to wth-hm...@googlegroups.com
I am going through Sasha's files now which is already formatted into the columns. For some reason Linda's data was not broken out the same way. How did you get the data to show up clean in excel Sasha?
Tony Nguyen
Jul 7, 2013, 11:20:51 PM7/7/13
to wth-hm...@googlegroups.com
I did a search for Samsung, Galaxy, S3 and S4 in the "Description" column for all files and came up with 856 hits (most of the files had duplicates so I started with the 7/7/13 files and did vlookups on the files going back to 7/4/13 that Sasha provided). Our data spans from 6/23/13 to 7/7/13. Let me know if you guys have any questions with this. Lavan - hopefully this is good to run the sentistrength analysis on.
0 new messages