RJMetrics Spring 2013 Hackathon Results

Spring is here, and with it another RJMetrics hackathon. Our third hackathon saw more outstanding projects, more pizza, and more bleary eyes.

The Projects

  • An inside look at what we eat in the company kitchen using RJMetrics dashboards to track snack and beverage metrics.
  • An automated gong-ringer that will sound every time a new client signs up.
    gong

    Rohan and Ben test their project.

  • A new RJMetrics data connector, deployed on our Data Import API. It sucks down data from our marketing automation platform, Pardot, and updates RJMetrics dashboards on an hourly basis.
  • A dashboard that updates in real time. Hackathon_Shot1
  • A wiki search function for our newly upgraded company wiki on Github
  • A hack of our Keurig machine, which now refills on its own.
    Hackathon_Shot3

    Jake and Shaun are blown away by the endless coffee.

  • A prototype of a pivot tables, bringing all the wonders of Excel pivot tables to your RJMetrics data.
  • An A/B testing tool for sales conversations.
  • A new UI which allows us to enable or disable features for different users

The Results

Congrats to Bob Moore, Connor McArthur, and Cathy Lennon who took home first place for their real-time dashboard project! Second place went to Matt Monihan, Nate Vecchiarelli, and Buck Ryan for their pivot tables prototype. And third place went to Shaun McAvinney and Jake Stein for their A/B testing tool.

Turns out hackathons are a lot of fun. Maybe quarterly isn’t enough…!

Hackathon_Shot2

4 Lean Startup Tactics that Worked

At RJMetrics, we pride ourselves on being a lean start-up focused on ecommerce analytics.  As a result, we’re always bringing new team members up to speed on what it means to be lean. My favorite way to educate them is through real-world examples.

Here are four of my favorite examples (from our team and others) of lean startups in action.

1. Faking A Move

To me, being lean is all about minimizing the ratio of resources consumed to insights gained. At RJMetrics, we did this to great effect when we were hiring our first employees. At that time, our company was based in Camden, NJ, and new applicants were few and far between. We suspected that our location was the reason for the talent shortage, but we had no way to prove that without making a really expensive bet and moving the business to nearby Philadelphia.

Just then, my co-founder Jake had a great idea: let’s just say we moved. We published an identical job posting but changed our address to a location in Downtown Philadelphia. The applicants started pouring in. We simultaneously started interviewing candidates and looking for new office space. We made our move literally one day before our first new employee started work.

Our Awesome Philly Office

Our Awesome Philly Office

I love this story for two reasons. First, had job applicants not increased we would have saved ourselves the trouble of moving with effectively zero downside. We then could have searched for more fundamental reasons that we weren’t getting applicants. Second, it saved us tons of time. By getting the answer to our question up-front, we were able to move and recruit in parallel rather than in sequence. I have no doubt that this accelerated our growth trajectory by months.

 

2. Actually Talking to Users

In the age of cookies, cheap storage, and abundant APIs, many companies have developed a strong bias against actually talking to their users.  Instead, they attempt to infer intent and sentiment from user actions.

While data can do a great job of telling us what is happening, it can often fall short on why it is happening.  Relying solely on data can also mask client frustrations.  Instead, from time to time companies should rely on a more time-honored tactic: asking what customers think.

Customer interviews are inexpensive, fast, and remove a lot of the interpretation risk associated with data-only strategies.  No matter how many numbers we crunch, we always learn something new when we ask our customers about their most and least favorite parts of our product.

 

3. Naming a Book

Tim Ferriss has a huge bag of tricks, but there is one that always sticks with me. When Ferriss was writing his book “The Four Hour Work Week,” he and his publishers were considering a number of potential titles. Rather than go with his gut, Ferriss devised a simple and brilliant strategy: buy Google Ads for each of the different potential titles, have them display when people were searching for content related to the book, and see what got people to click the most.

Users who clicked the ads would land on a blank page or “under construction” page.  All Tim needed to know was what moved people to click.

This inexpensive experiment allowed Ferriss to create an ad-hoc focus group consisting of thousands of ad viewers and learn which titles piqued their interest the most. Based on sales of The Four Hour Work Week, it’s quite clear that he made the right choice.   Ferriss shares this story in the video below.

 

4. Interactive Mock-Ups

Philadelphia entrepreneur Chris Cera recently turned me onto a really neat tool he uses called Axure. With Axure, you can to mock up interactive user interfaces without any backend coding. In other words, as long as testers follow pre-determined steps, they can get the impression that they’re interacting with a fully-built product.

Anyone who has done user experience work can appreciate why this is a brilliant and valuable tactic. An interactive mock UI/UX can answer huge up-front questions about how and when potential users would derive value from a product (or experience frustrations). With these questions answered, the development of the backend can be much more focused and deliberate, and there is far less risk associated with the final product’s release.

 

 

RJMetrics Winter 2013 Hackathon Results

After the last RJMetrics hackathon, I didn’t think our team could possibly cram more innovation into a 24-hour period.  They just did.

The Projects

Team members unveiled some amazing projects, including:

Spotlight search in our new dashboard UI to provide users with fast access to charts, dashboards, and trends.

Customizations to Zendesk to make our customer support exchanges more streamlined.

customized sales video generator to provide a personal touch to our sales prospects.

Shaun Presents His Video Generator

Shaun Presents His Video Generator

BallerBoard, a TV display engine that automatically shows stats from RJMetrics, Twitter, and other services in a format that’s easy on the eyes.

BallerBoard

An End-User Query Browser to allow advanced users to query their data warehouses directly using SQL syntax.

A deployment system for MySQL stored procedures, which will greatly increase the number of analyses we can run natively in MySQL.  Last Hackathon’s Median/Percentile feature will be deployed using this system.

A trend-line overlay system that will allow users to fit regression lines to their data and forecast future data points based on these models.

TrendLine

A system for self-auditing and approving RJMetrics Trend/Metric definitions through our UI.

A new concept and 3D rendering of a new RJMetrics conference booth.

Conf

An improved RJMetrics deployment system.  This is an extension of our new AWESOM-O deployment system and its client application Butters.

Drastic improvements to our physical office environment, including a new reception area and accent walls throughout the office.

Working Capybara integration tests to monitor our UI.

 

The Results

Francis “Buck” Ryan took the crown this time around for his work on trend-line overlays.    This was a suggestion that came directly from our feature request page.  Existing users can keep an eye out for it in the beta tests of our new dashboard UI.

Buck will enjoy the grand prize: $500 cash to be spent all in one night.

I can’t wait for Spring.

 

 

Return of the RJMetrics Hackathon

This Thursday at Noon, we will kick off our second seasonal RJMetrics Hackathon.

Our previous hackathon was an enormous success. It caused major disruption in our development pipeline. Many of that hackathon’s projects are currently being beta tested and will hit our production codebase soon.

It also spawned such live features as:

  • QueryMongo.com, which topped Hacker News and helps dozens of coders (including our team members and customers) every day.
  • A snazzy new sales video, which is being A/B tested on our homepage.
  • And much, much more.

Most importantly, everyone had a great time and couldn’t wait for the next one.

The Prize

Last time, our winners enjoyed a lavish dinner at Del Frisco’s Double Eagle Steakhouse. This time, we’ve upped the ante.

This Hackathon’s prize is inspired by the classic film Brewster’s Millions.

The winning team will be given $500, with the caveat that they must SPEND IT ALL IN ONE NIGHT. You can pick any night you want and spend it however you want, but that money has to be gone by the time the sun comes up. Winners are encouraged to document their shenanigans.

Taking Suggestions

Got a suggestion for something our team should take on at the Hackathon? Let us know by emailing support@rjmetrics.com with your suggestions. They will be passed on to our entire team.

Check back next week for results!

MySQL to MongoDB Query Translator

A few weeks ago, the first-ever RJMetrics hackathon took place at our Philadelphia headquarters. I decided to throw my hat into the ring with a project I’d been thinking about for a while: a MySQL to MongoDB query translator.

This was a unique challenge because MongoDB and MySQL are very different technologies that store data in very different ways. To some, translating between them might seem like a non-sequitur. However, I knew there was a use case because of my personal experience learning MongoDB. I would often think about queries in terms of SQL syntax, and a translator like this would have greatly softened the learning curve.

The final product is available at our Query Mongo site, and I encourage you to give it a try. It’s not perfect, but we hope it will be a helpful learning tool for the many people who have SQL experience and are getting started with MongoDB.

In this blog post, I’ll provide some insights into how this tool works.

Continue reading

Surprising Hacker News Data Analysis

Obligatory Plug (let’s get this out of the way): I’m the co-founder of a company called RJMetrics. We develop hosted software that helps online businesses make smarter decisions using their data. I used RJMetrics to do all of this analysis and only scraped the surface of what our tool can do. If you’d like to see what RJMetrics can do for your business, sign up for a free 30 day trial. OK, onto the good stuff…

A few days ago, I was lamenting to my co-founder Jake about a frustrating problem: my blog content had stopped making it to the front page of Hacker News. While my posts are admittedly formulaic (I usually get my hands on some never-before-seen data and analyze it in RJMetrics), they always seemed to work their way to the top.

But lately I’ve been coming up dry. My TechCrunch guest post on how start-ups approach patents? Nah. My piece on never-before-seen Pinterest data? Fail. How about new data on the behind-the-scenes world of VC deal sharing? Another bomb.

I had some self-serving theories: Hacker News had devolved, succumbed to voter rings, or maybe just become too mainstream. Jake, as he often does, offered up alternative theory: my content sucks.

Jake proposed that the content landscape has become more competitive as HN has grown and that my content hasn’t improved fast enough to keep up.

As with most of our arguments, we decided to let the data decide. I used ThriftDB’s HNSearch API to pull down a complete history of Hacker News submissions, comments, and scores. I then plugged the data into an RJMetrics Dashboard and went to work answering some questions about the evolution of community, content, and competition on Hacker News.

Read on to see the data behind findings like these:

  • On Hacker News, the rate of new user registrations grew explosively in 2010, was flat in 2011, and is down in 2012.
  • The total number of active users continues to grow because a high percentage of historical users continue to participate on HN even years after their initial registrations.
  • Despite growth in the user population, the number of submissions made to Hacker News each week has held steady since 2011.
  • If you want upvotes, use profanity and talk about hot startups. Steer away from big companies and sensationalist headlines.

Continue reading

RJMetrics Featured in The Entrepreneurial Instinct

We’re in a book! Grab a copy of The Entrepreneurial Instinct.

Monica Mehta, reporter for BusinessWeek and frequent contributor to Fox News, MSNBC, and ABC news, just published a new book titled The Entrepreneurial Instinct. The book features interviews with successful entrepreneurs and discusses the circumstances and the thought processes that drove them to start their companies.

Beyond the stories, Mehta also dives into the psychology and neurochemistry of entrepreneurship and risk taking. She analyzes the personality traits that correlate with and enable entrepreneurship. Mehta examines the crucial role of the brain chemical dopamine, and she explains how its interacts with different parts of the brain during the risk taking decision process.

Finally, she goes into detail on practical exercises and personal finance tactics that can help people get comfortable with the risk, uncertainty, and anxiety that come along with the plunge into a new venture.

Bob and I were interviewed for this book, and we’re thrilled to be a part of it. You can read about us in chapter 10, “Finding Inspiration,” on page 124. Get your copy of The Entrepreneurial Instinct today, I highly recommend it.

Intern News: Our Philadelphia Scavenger Hunt

This summer, we were thrilled to have five college interns join the dev team at our Philadelphia headquarters. There was just one problem: none of them were from Philly. Before sending them back to school, we wanted to give them a proper introduction to our fine city.

The solution: a day-long scavenger hunt that would send them all over town. We split the crew into two teams and provided a checklist of 65 things uniquely Philly. Each team was given a budget of $10 per person and a one day SEPTA pass that provided unlimited rides on public transit.

The Checklist

Each team completed over 40 items during the seven-hour experience, and we’ve included some highlights below.

Both teams scored dozens of points by visiting Philadelphia must-see sites like the Liberty Bell, Rittenhouse Square, Independence Hall, Chinatown, LOVE park, and the Rocky Statue.

Our office is next door to a Holiday Inn Express, and somehow both teams managed to talk their way into accomplishing a 15 point task: take a photo of our office from inside the hotel.

Austin and Ed scored 20 points for snapping a picture of the clock on Independence Hall reading exactly 3:34PM and a picture of the clock on City Hall reading exactly 4:02 PM.

Kyle, Mike, and Rodrigo climbed to the top of historic City Hall tower and snapped a photo of the skyline for 15 points.

Correctly completing a Metro crossword puzzle landed another 15 points for Ed and Austin.

Neither team had the guts to earn 500 points by getting an RJMetrics tattoo.

Both teams earned 5 points for having a team member wade in an active fountain.

Spotting a “Ride the Ducks” boat scored both teams 5 points.

Both teams found five unique murals across the city to score 5 points.

Food played a big role, as each team got points for eating Tastykakes and sampling the goods at Reading Terminal Market.

The Results are In

By a margin of just 25 points, Austin and Ed defeated Kyle, Mike and Rodrigo. The victorious team enjoyed a steak lunch and bragging rights for the rest of the summer.

If you think you’ve got what it takes to join the RJMetrics team, check out our jobs page to apply!


Stand Up for RJMetrics

This post began as an explanation of character set encodings and some of the UTF-8 problems that I have recently encountered, but as I struggled to find the right words and salient examples, I found myself nervously pacing around my living room and wishing I had the same “standing desk” at home that I do at the office, so that I could work off some nervous energy while still focusing on getting my thoughts on the screen.

After managing to prop my laptop on a cookbook on top of a high counter, my focus has transitioned to workplace environments and workspace setup, topics that have been discussed in depth recently, including numerous articles on the hazards of sitting at a desk all day and a New York Times article this Saturday on workplace noise.

One of the major draws of working at RJMetrics was the opportunity to design my ideal workspace, including my desired chair, desk, and computer. I had been considering a standing desk for a while and was excited to see that this was already a common feature in the office. Most developers here have a GeekDesk, which is a motorized desk that you can sit or stand at. Each person has a different balance of sitting and standing, but everyone appreciates this somewhat unusual office perk.



These desks are not just a novelty- recent research has shown that being sedentary for long periods of time increases a person’s risk of obesity, diabetes, and heart disease even if he or she exercises regularly.

For me the draw of a standing desk was more practical. I prefer standing, stretching, and pacing while I’m working and I find it hard to sit and focus when I have a lot of pent up energy. I also find sitting for extended periods to be uncomfortable, and have gone through many desk chairs in the past trying to find one that doesn’t bother me. I’ve found instead that the best way around this for me is to take frequent standing breaks. It also helps keep my energy up in the afternoons when I find myself getting groggy.

Plus, having a standing desk fosters collaboration. It’s easy for me to share a workspace with another developer while standing and looking at some code than it is it cram a bunch of swivel chairs at a workstation. Stand up!

Why You Shouldn’t Start The Next Instagram

So, as you’ve heard, Facebook has acquired Instagram for $1 Billion worth of cash, stock and PBR. That’s more than the New York Times is worth.

Since the announcement, the general conversation is this:

  • Instagram isn’t worth $1 Billion since it has no revenue.
  • Instagram is worth $1 Billion because it’s so much better than Facebook at photo sharing. See Robert Scoble’s arguments.
  • I should start a company that Facebook would want to buy.

Let’s focus on that last one. I’ve ranted about this before, but to put it frankly, we’ve got bigger fish to fry. I mean that as a society.

I think it’s relatively safe to say that the photo-sharing problem has been solved. There’s 1001 real problems on this planet that have no solution.

So, I’m proposing something different. Before starting a business or joining a startup, ask yourself if that startup is solving a problem. And I don’t mean a “this photo could use more filters” problem. I mean a real, “this will actually make people’s lives better” problem.

Start the next Dollar Shave Club, not the next Instagram.

I’ll be at Startup Weekend Philadelphia on April 20th. I’ll help you start something real.