Skip to Main Content
Analyze Clicks and Bounce Rates from Online Couponers
Challenge Type: computer science
top 10
95 months ago
Small pic clicks

Linked below is 1 hour of web access logs from Answer the following questions using a programming language of your choice among C#, Java, Python, Ruby or PHP. Extra credit for answering each question in a different language and for not using 3rd party libraries.

The purpose of this challenge is to code the solution using only basic data structures. You should not simply load the data into a database or use LINQ.

Provide all code in a ZIP file with relevant release notes and comments to best demonstrate your ability and thought process while solving these problems.


Http Access Log Sample from

1. Clicks out from to a merchant are important to us. They can be found in the logs by looking for GET requests to /out/{couponId}. Provide descriptive statistics about the number of clicks we see per minute. Specifically, calculate the minimum, maximum, mean, median and standard deviation of clicks out per minute. For minimum and maximum, also compute the minute when the value occurred. Generate a csv file of the that contains this statistics.

2. Much of our traffic is a GET request to a store page. Store pages are denoted in the log by a GET request to /view*/{store domain} where * is either empty or any integer value. Examples of this path pattern are /view14/ and /view/ Calculate the Bounce Rate for each store page. You can assume visitors are uniquely identified by their IP. You can consider the 1 hour of weblogs as a single session, i.e. any user who visited a single page in the logs should be considered a bounce.

See: "A bounce occurs when a web site visitor only views a single page on a website, that is, the visitor leaves a site without visiting any other pages before a specified session ­timeout occurs. There is no industry standard minimum or maximum time by which a visitor must leave in order for a bounce to occur. Rather, this is determined by the session timeout of the analytics tracking software.

Rb = Tv / Te


Rb = Bounce rate

Tv = Total number of visitors viewing one page only

Te = Total entries to page

    Submissions will be graded on the following criteria:
  • Meets Deliverables
  • Creativity
  • Clarity
Reward Tiers
5 Winners
will receive $150 each
5 Honorable Mentions
will receive $50 each
$150.00 A alexander_bok Brown University
$150.00 S sbarratt University of California at Berkeley
$150.00 Square pic 60 og David Ogutu Massachusetts Institute of Technology
$150.00 J Jonathan Magasin University of California, Santa Cruz
$150.00 Square pic 60 20150809 evan s portrait 01 sq 600x600 Evan Chow Princeton University
$50.00 Square pic 60 mehackduke Michael Lai Duke University
$50.00 L Luyao Xu University of California, Los Angeles
$50.00 Square pic 60 iraj 4 Iraj Hedayati Concordia University
$50.00 C Cameron Cecil Park University
$50.00 S Spurthi Amba Hombaiah Georgia Institute of Technology
Submission questions

0 characters Average: 1715 characters
Your solution must be at least 200 characters long
Enter your info to sign in
or sign in with