Archive for December 22nd, 2010

And now for something completely offtopic: Subway in Chicago

Posted by Laura on Wednesday, 22 December, 2010

If you haven’t figured out in my many posts, I’m not Australian; I’m an American. More specifically, I’m an American from the Chicago area with friends and family who live there. Of late, I’ve been interested in Foursquare check in patterns. (What’s the value? What’s the potential ROI? Are there patterns that appear that could be useful for using a campaign on? Is there another way to measure success beyond say coupons on site?) Rather than look at local patterns, or Australian patterns that could possibly be construed as research that might have copyright implications beyond my control, I decided to look at patterns for Chicago at one of my favorite chain restaurants. That was Subway. (Added bonus: Local to home research based on my sport methodology research, that could help me get a job back home [if I want to go back].)

I found a list of about 47 Chicago based Subways. Most of them appear in the loop. In at least one location, there appears to be a duplicate location. A script I had assistance with in developing checks those locations everyday at midnight US CST. It then records the total checkins and total people at the location for that day, compares the difference from the previous day and gives me the total checkins and total people for the past 24 hours. This process, once started, relatively easy. (If you have some business in the US Central Time, I could start getting that data for you tomorrow.) Every day, I get an e-mail with the total daily checkins in csv format. I put that data into an Excel file so I can process it. Fun stuff.

One of the patterns that has emerged is that there appear to be more weekday checkins to Chicago Subways. In fact, 15 Subways of the 47 have more weekday checks. 6 Subways have more weekday checkins. 25 of those locations are tied for checkins between weekdays and weekends. I believe with one exception, they have zero checkins across the five days looked at. The remaining Subway had a negative checkin and I slotted it into its category. Not sure why/how that happened that led to a negative checkin day.

The fact that these locations are mostly Loop locations probably explains a lot of what is going on with this data set. The Loop is the business district. Office workers would go to Subway during the week. They checkin during those times. Fewer workers in the city on the weekend, fewer checkins.

These patterns likely would be different for other businesses in Chicago (probably not as much in the loop) and elsewhere depending on that location and business type. More data on more businesses would be interesting. The holidays coming up will skew things for a bit because Christmas Eve, Christmas Day, New Years Eve, New Years Day are likely to be non-normal business days. I’d love to look at some of this data beyond my limited sample in order to better grasp how people are using the service and what the business implications are. (Is anyone really looking at total daily checkins for certain classes of businesses? If so, would be something I’d love to read!)

Anyway… on with the data! :)

. . Friday Friday Saturday Saturday Sunday Sunday Monday Monday Tuesday Tuesday Weekend totals Weekend totals Weekday totals Weekday totals
Name Link 17-Dec Check ins 17-Dec People 18-Dec Check ins 18-Dec People 19-Dec Check ins 19-Dec People 20-Dec Check ins 20-Dec People 21-Dec Check ins 21-Dec People Total checkins Total people Total checkins Total people
Subway – Monroe St http://foursquare.com/venue/218131 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway http://foursquare.com/venue/1871131 3 2 0 0 0 0 0 0 0 0 0 0 3 2
Subway – Marquette Building http://foursquare.com/venue/3867325 0 0 0 0 0 0 0 0 0 0 0 0 0 0
subway 230 state street http://foursquare.com/venue/600218 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway – State st. http://foursquare.com/venue/6022060 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway – Dearborn http://foursquare.com/venue/606383 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway Sandwiches http://foursquare.com/venue/3930325 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway Sandwiches http://foursquare.com/venue/2803757 0 0 0 0 0 0 0 0 1 1 0 0 1 1
Subway http://foursquare.com/venue/3479285 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway http://foursquare.com/venue/4163087 0 0 0 0 0 0 0 0 0 0 0 0 0 0
subway jackson http://foursquare.com/venue/947380 0 0 11 1 0 0 0 0 0 0 11 1 0 0
Subway Subs http://foursquare.com/venue/1420119 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway http://foursquare.com/venue/3478434 2 2 0 0 0 0 0 0 0 0 0 0 2 2
Subway http://foursquare.com/venue/218085 1 0 0 0 0 0 0 0 0 0 0 0 1 0
Subway – South Michigan http://foursquare.com/venue/104278 4 2 0 0 0 0 1 0 0 0 0 0 5 2
Subway http://foursquare.com/venue/4462238 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway Illinois Center http://foursquare.com/venue/427573 0 0 0 0 3 1 0 0 0 0 3 1 0 0
Subway – E Washington http://foursquare.com/venue/1547234 2 0 0 0 0 0 0 0 0 0 0 0 2 0
Subway (at Franklin and Van Buren) http://foursquare.com/venue/6060471 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway – Orleans http://foursquare.com/venue/524674 9 2 0 0 0 0 0 0 0 0 0 0 9 2
Subway – East Washington http://foursquare.com/venue/1593751 1 1 0 0 0 0 0 0 0 0 0 0 1 1
Subway 166 W. Washington http://foursquare.com/venue/8156985 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway Madison http://foursquare.com/venue/3193683 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway at Millennium Station http://foursquare.com/venue/2163336 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway http://foursquare.com/venue/2054758 2 0 0 0 0 0 0 0 0 0 0 0 2 0
Subway http://foursquare.com/venue/420861 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway Millenium Station http://foursquare.com/venue/1404266 2 2 0 0 0 0 0 0 0 0 0 0 2 2
Subway http://foursquare.com/venue/595329 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway http://foursquare.com/venue/2742373 0 0 1 1 0 0 0 0 0 0 1 1 0 0
Subway – 118 S. Clinton http://foursquare.com/venue/4276355 1 0 0 0 0 0 0 0 0 0 0 0 1 0
Subway Wabash http://foursquare.com/venue/1798065 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway – LaSalle http://foursquare.com/venue/1057618 10 2 0 0 0 0 0 0 0 0 0 0 10 2
Subway (315 N Dearborn St) http://foursquare.com/venue/5994406 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway (Marina Towers) http://foursquare.com/venue/4678684 0 0 2 0 0 0 0 0 0 0 2 0 0 0
Subway (at HCSC) http://foursquare.com/venue/1172420 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway (#7773) – Jefferson & Lake http://foursquare.com/venue/162168 -1 -1 0 0 0 0 0 0 1 0 0 0 0 -1
Subway (#7760) – Citigroup Center http://foursquare.com/venue/197902 1 0 0 0 0 0 0 0 0 0 0 0 1 0
Subway http://foursquare.com/venue/4196223 0 0 1 1 0 0 0 0 0 0 1 1 0 0
Subway http://foursquare.com/venue/3685931 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway – South Loop http://foursquare.com/venue/306309 2 0 0 0 0 0 0 0 1 0 0 0 3 0
Subway http://foursquare.com/venue/46801 1 0 0 0 0 0 0 0 0 0 0 0 1 0
Subway http://foursquare.com/venue/9305120 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway http://foursquare.com/venue/564627 0 0 1 1 0 0 1 0 0 0 1 1 1 0
Subway (535 N. Michigan Ave.) http://foursquare.com/venue/94209 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway on Ohio http://foursquare.com/venue/2986286 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subway Sandwich http://foursquare.com/venue/8498439 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Related Posts:

St. Kilda Saints Alexa Rank in response to Riewoldt/Dawson/Dal Santo controversy

Posted by Laura on Wednesday, 22 December, 2010

I’ve got a lot of data and there are a variety of ways to look at this controversy. My focus tends to be on how these controversies impact the team and their fanbase. One way to look at that for this involves looking at traffic data for saints.com.au. That data can be found in the page below. Alexa rank falling suggests less traffic in response to the controversy. (Alexa doesn’t appear to be updating these numbers daily and I’m checking every day at the same time.) I’m just not sure I really believe the numbers here. I think circumstances like the holidays are changing people’s web checking habits… but I could be wrong. I would have almost assumed that the numbers would have improved. Babbling. I’m just not sure what is going on here.  This is something to think more about later.

saints.com.au Alexa rank

Related Posts:

36 hour change for Nick Riewoldt fan community on Facebook

Posted by Laura on Wednesday, 22 December, 2010

My stats have been updated so I’m posting this. (It just makes it easier when I start posting to have this compiled already.) While no losses were seen on the first day, there are now groups that have seen a decline in numbers. The decline is much smaller than the increase. I can’t see that pattern of increases outnumbering declines changing.

Name Type Url 20-Dec-10 21-Dec-10 22-Dec-10 Difference
Nick Riewoldt is simply Amazing! Page https://www.facebook.com/pages/Nick-Riewoldt-is-simply-Amazing/110966212265330 523 915 927 404
Nick riewoldt fans! Sports & Recreation https://www.facebook.com/group.php?gid=5620869225 805 1,000 1,000 195
Nick Riewoldt Page https://www.facebook.com/pages/Nick-Riewoldt/103945999643012 3,573 3,613 3,766 193
I can kick a goal from 1 metre out lol jks im Nick Riewoldt Page https://www.facebook.com/pages/I-can-kick-a-goal-from-1-metre-out-lol-jks-im-Nick-Riewoldt/163824743629586 29,758 29,770 29,841 83
Nick Riewoldt Page https://www.facebook.com/pages/Nick-Riewoldt/123958534299699 541 546 583 42
I never cry. lol jk I’m Nick Riewoldt. Page https://www.facebook.com/pages/I-never-cry-lol-jk-Im-Nick-Riewoldt/119726158061175 6,542 6,546 6,575 33
Heath Shaw’s smother on Nick Riewoldt Page https://www.facebook.com/pages/Heath-Shaws-smother-on-Nick-Riewoldt/131565573559507 7,367 7,370 7,399 32
Big Girls Don’t Cry JK I’m Nick Riewoldt Page https://www.facebook.com/pages/Big-Girls-Dont-Cry-JK-Im-Nick-Riewoldt/131327673586736 918 923 946 28
Whats red, white and black and crys like a little girl?? NICK RIEWOLDT Page https://www.facebook.com/pages/Whats-red-white-and-black-and-crys-like-a-little-girl-NICK-RIEWOLDT/128066117223617 1,219 1,221 1,245 26
Dear Nick Riewoldt, you are actually amazing, the end. Page https://www.facebook.com/pages/Dear-Nick-Riewoldt-you-are-actually-amazing-the-end/135359693176938 87 88 111 24
I don’t miss half a metre in front of goals LOL jk i’m Nick Riewoldt Page https://www.facebook.com/pages/I-dont-miss-half-a-metre-in-front-of-goals-LOL-jk-im-Nick-Riewoldt/164407696908377 3,360 3,360 3,378 18
Nick Riewoldt Page https://www.facebook.com/pages/Nick-Riewoldt/172278138719 704 705 722 18
So you hate Nick Riewoldt and Saint Kilda? Well, WE DON’T CARE!! Page https://www.facebook.com/pages/So-you-hate-Nick-Riewoldt-and-Saint-Kilda-Well-WE-DONT-CARE/276967613558 910 915 927 17
I dont cry for no reason. LOL JK im nick riewoldt Page https://www.facebook.com/pages/I-dont-cry-for-no-reason-LOL-JK-im-nick-riewoldt/153337298030869 403 402 414 11
Jack Riewoldt. . . . . better than Nick Page https://www.facebook.com/pages/Jack-Riewoldt-better-than-Nick/129371470419320 325 325 336 11
I am tough as LOL jks, I am Nick Riewoldt Page https://www.facebook.com/pages/I-am-tough-as-LOL-jks-I-am-Nick-Riewoldt/103435546369288 2,234 2,230 2,244 10
nick riewoldt Page https://www.facebook.com/pages/nick-riewoldt/136304513062911 129 130 139 10
I dont get my kick smothered in the goal square, LOL jks im Nick Riewoldt Page https://www.facebook.com/pages/I-dont-get-my-kick-smothered-in-the-goal-square-LOL-jks-im-Nick-Riewoldt/138768859503252 2,324 2,326 2,333 9
I can kick a goal from 2 metres out LOL jk, I’m Nick Riewoldt Page https://www.facebook.com/pages/I-can-kick-a-goal-from-2-metres-out-LOL-jk-Im-Nick-Riewoldt/156229274400084 4,397 4,397 4,403 6
Nick Riewoldt Page https://www.facebook.com/pages/Nick-Riewoldt/120375574683675 75 76 81 6
Watching Nick Riewoldt Cry after St.Kilda lose another Grand Final Page https://www.facebook.com/pages/Watching-Nick-Riewoldt-Cry-after-StKilda-lose-another-Grand-Final/162269510453692 456 453 461 5
Nick Riewoldt is the most overated footballer EVER Sports & Recreation https://www.facebook.com/group.php?gid=26438816758 213 213 217 4
I’m the best Riewoldt in the afl LOL JKS I’m Nick Riewoldt Page https://www.facebook.com/pages/Im-the-best-Riewoldt-in-the-afl-LOL-JKS-Im-Nick-Riewoldt/108273145887702 594 595 598 4
I witnessed the day Nick Riewoldt cried and Collingwood choked Page https://www.facebook.com/pages/I-witnessed-the-day-Nick-Riewoldt-cried-and-Collingwood-choked/149372788433568 159 159 163 4
Nick Riewoldt looks like Stef from The Goonies Page https://www.facebook.com/pages/Nick-Riewoldt-looks-like-Stef-from-The-Goonies/158151820869248 80 80 84 4
I am so tough…LOL jks im Nick Riewoldt Page https://www.facebook.com/pages/I-am-so-toughLOL-jks-im-Nick-Riewoldt/126708587340052 648 650 651 3
Nick Riewoldt Page https://www.facebook.com/pages/Nick-Riewoldt/153384208017734 19 19 22 3
the awkward moment when nick riewoldt kicks air.. Sports & Recreation https://www.facebook.com/group.php?gid=112931602100261 142 143 144 2
No Nick Riewoldt=NO SAINTS Sports & Recreation https://www.facebook.com/group.php?gid=126384667372393 206 206 208 2
Nick Riewoldt Is A True Saint Sports & Recreation https://www.facebook.com/group.php?gid=264005001242 79 80 81 2
i love nick riewoldt!!!!!!! Page https://www.facebook.com/pages/i-love-nick-riewoldt/372337761123 236 236 238 2
I was shocked when i realised St. Kilda spelt backwards is Nick Riewoldt! Page https://www.facebook.com/pages/I-was-shocked-when-i-realised-St-Kilda-spelt-backwards-is-Nick-Riewoldt/110557032321674 226 226 228 2
Nick Riewoldt is a gun Page https://www.facebook.com/pages/Nick-Riewoldt-is-a-gun/113783921973632 352 352 354 2
The Nick Riewoldt Fan Club Page https://www.facebook.com/pages/The-Nick-Riewoldt-Fan-Club/106669252729912 182 183 184 2
You think period pains are bad? Try winning a game without Nick Riewoldt. Page https://www.facebook.com/pages/You-think-period-pains-are-bad-Try-winning-a-game-without-Nick-Riewoldt/121744834517251 101 102 103 2
Don’t you hate it when the wind blows and Nick Riewoldt gets a free kick! Just for Fun https://www.facebook.com/group.php?gid=104171049618962 1,984 1,984 1,985 1
Nick Riewoldt Is A Cry Baby Just for Fun https://www.facebook.com/group.php?gid=107851489249042 114 115 115 1
Nick Riewoldt <3 Just for Fun https://www.facebook.com/group.php?gid=115379428487302 139 139 140 1
why bag nick riewoldt when hes one of the best in the afl. :) Sports & Recreation https://www.facebook.com/group.php?gid=116883778331692 126 126 127 1
Why are u crying nick riewoldt got sand in your vagina?? – Dale Gibbs Common Interest https://www.facebook.com/group.php?gid=122936137759488 9 9 10 1
Nick Riewoldt Sports & Recreation https://www.facebook.com/group.php?gid=136505203508 144 144 145 1
Dont you reckon Nick Riewoldt and Justin Koschitzke are GAY Page https://www.facebook.com/pages/Dont-you-reckon-Nick-Riewoldt-and-Justin-Koschitzke-are-GAY/104237202974255 25 25 26 1
Heath Shaw’s smother on Nick Riewoldt in the 2010 AFL Grand Final replay Page https://www.facebook.com/pages/Heath-Shaws-smother-on-Nick-Riewoldt-in-the-2010-AFL-Grand-Final-replay/163638773647933 172 172 173 1
Hi im Nick Riewoldt and my kick gets smothered while im running into goal. Page https://www.facebook.com/pages/Hi-im-Nick-Riewoldt-and-my-kick-gets-smothered-while-im-running-into-goal/113141802079373 278 278 279 1
I can kick a goal from 1 m out lol jk im Nick Riewoldt Page https://www.facebook.com/pages/I-can-kick-a-goal-from-1-m-out-lol-jk-im-Nick-Riewoldt/134709133242795 41 41 42 1
I Can Kick A Goal From 1m Out! LOL jks I’m Nick Riewoldt Page https://www.facebook.com/pages/I-Can-Kick-A-Goal-From-1m-Out-LOL-jks-Im-Nick-Riewoldt/165180320163486 33 33 34 1
Nick Riewoldt Page https://www.facebook.com/pages/Nick-Riewoldt/105386749503114 23 23 24 1
Nick Riewoldt https://www.facebook.com/pages/Nick-Riewoldt/111945055500651 26 27 1
Nick Riewoldt Page https://www.facebook.com/pages/Nick-Riewoldt/118546268163713 22 22 23 1
Nick Riewoldt Page https://www.facebook.com/pages/Nick-Riewoldt/128678427184935 14 14 15 1
Nick Riewoldt Page https://www.facebook.com/pages/Nick-Riewoldt/403514642227 31 31 32 1
Nick Riewoldt could take on all of richmond ! Page https://www.facebook.com/pages/Nick-Riewoldt-could-take-on-all-of-richmond-/111208798892678 258 258 259 1
Nick Riewoldt’s Hamstring Page https://www.facebook.com/pages/Nick-Riewoldts-Hamstring/109495019089743 372 372 373 1
Nick Riewoldt should be in the kitchen Page https://www.facebook.com/pages/Nick-Riewoldt-should-be-in-the-kitchen/117506378274284 77 77 78 1
the st kilda football club is the best because they have nick riewoldt Page https://www.facebook.com/pages/the-st-kilda-football-club-is-the-best-because-they-have-nick-riewoldt/105091402866398 43 44 44 1
‘the st kilda footyball club is the best because they have nick riewoldt Page https://www.facebook.com/pages/the-st-kilda-footyball-club-is-the-best-because-they-have-nick-riewoldt/114240778593981 11 11 12 1
Wayne Carey shits on Jono Brown and Nick Riewoldt !! NO COMPARISION !! Page https://www.facebook.com/pages/Wayne-Carey-shits-on-Jono-Brown-and-Nick-Riewoldt-NO-COMPARISION-/106440596062428 76 77 77 1
Nick Riewoldt & Justin Koschitzke are so sexy!! Common Interest https://www.facebook.com/group.php?gid=101433326561970 19 19 19 0
Jack Riewoldt, the best Riewoldt. Sports & Recreation https://www.facebook.com/group.php?gid=101728483210880 73 73 73 0
Jonathan Brown is better than Nick Riewoldt Sports & Recreation https://www.facebook.com/group.php?gid=103342149709740 10 10 10 0
LOVE IT when the wind blows and Nick Riewoldt gets a free kick!! Just for Fun https://www.facebook.com/group.php?gid=106257232741062 20 20 20 0
NICK RIEWOLDT IS OVERATED Sports & Recreation https://www.facebook.com/group.php?gid=107240525980414 7 7 7 0
I did my knee……. LOL jks im Nick Riewoldt Just for Fun https://www.facebook.com/group.php?gid=109984042379818 2 2 2 0
Is Nick Riewoldt’s head to small for his body? Just for Fun https://www.facebook.com/group.php?gid=110369099576 40 40 40 0
I Hate Nick Riewoldt Common Interest https://www.facebook.com/group.php?gid=110469732316943 21 21 21 0
Nick Riewoldt is the most overrated player in the AFL. Sports & Recreation https://www.facebook.com/group.php?gid=110691538949948 217 217 217 0
Would Hump Nick Riewoldt Common Interest https://www.facebook.com/group.php?gid=110828893614 52 52 52 0
Nick Riewoldt Sucks Sports & Recreation https://www.facebook.com/group.php?gid=112243132146834 92 92 92 0
Nick Riewoldt should be sponsored by Kleenex Common Interest https://www.facebook.com/group.php?gid=112409628791145 43 43 43 0

Related Posts: