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

RJMetrics Round-Up (01/31/2013)

It’s been a busy new year at RJMetrics!  Here’s some of what’s been happening behind the scenes:

  • Our co-founders Jake and Bob just returned from a trip to San Francisco, where they attended an investor’s CEO conference and visited with several of our wonderful clients.
  • Our staff is growing! Our new Director of Marketing starts Monday, a new developer has just signed on, and we’ve accepted two Drexel co-ops for the summer session.
  • Our CEO Bob had another popular guest post in TechCrunch last week, which you can read here.
  • Bob is also featured in the new book “Hacking PR” by Sean Blanda. You can learn more about the book here (and use code RJMETRICS for 20% off).
  • Our new microsites Cohort Analysis, Churn Rate, Test Significance, and Query Mongo are educating legions of visitors about key topics related to data and analytics.

Stay tuned to this blog for more product announcements, team news, and original research from RJMetrics.

 

RJMetrics Round-Up (11/28/2012)

The hits keep coming at RJMetrics!  Here’s some of the recent progress we’ve made:

Product Updates:

  • Our new chart builder made its public debut. All users can now participate in beta testing this tool. Read more about it in our documentation.
  • We changed the font throughout our dashboard. Say hello to Proxima Nova.
  • We have expanded our time zone support. Charts with a time frame relative to “right now” will be calculated against your time zone, which administrative users can change in the settings page.
  • Email summaries now include a warning if they contain stale data – that is, data for a time period that RJMetrics has not finished calculating. These email summaries are automatically resent once that data is current.
  • Our “Cohort Analysis 101″ guide is now live at www.cohortanalysis.com.
  • We have increased the parallelization of many of our calculations, resulting in significant speed boosts.
  • We have updated our integration to support many of the improvements to the Google Analytics API recently – specifically allowing the visitors trend to be grouped across many more dimensions.
  • There are now fewer constraints on restriction sets for repeat event probability charts.
  • We’ve sped up the dashboard-wide “change all dates” tool.
  • We’ve sped up the auto-complete drop downs in the chart builder.
  • We made major improvements to file uploader, including auto-detection of the file structure for new uploads.
  • We have begun beta testing a data mapping tool that uses zipcode information as an input – stay tuned for more on this.
  • We finished production of the promotional video that was created at our last hackathon – it can be viewed at https://www.rjmetrics.com/index2

Company News:

  • Our CEO Robert J. Moore has been busy getting the word out:
  • We’re currently interviewing candidates from Drexel University’s Co-Op program for participating in next year’s RJMetrics co-op.

Business Intelligence vs. Business Analytics

When I was first hired at RJMetrics, I was a recent college grad, and the concepts of “business intelligence” and “business analytics” were still a bit new to me. I started reading up on the these fields and quickly learned that even practitioners who have been working with business data for decades can’t agree on concrete definitions.

As I waded through countless websites, forums and flame wars looking for the answers, I decided to help other people like me by condensing my findings into one convenient space. If you’re wondering about “ba vs bi” or “business analytics vs business intelligence,” hopefully this post saves you some time.

BA vs BI

When you’re talking about data and what it can do for your company, a lot of terms get thrown around. Business analytics (BA) and business intelligence (BI) are two terms heavily used, but rarely given the same definition by any two sources. Some take the stance that they’re interchangeable, and others staunchly defend their position as to the meaning of each, and what would fall under those respective umbrellas. Ultimately, I came to realize that these are two complementary concepts that have grown with, and out of, each other.

On a basic level, BI is the ability to take information resources and convert them into knowledge that is helpful in decision making. The traditional method of doing this involves cataloging and examining data from past decisions and actions, and using this as a way of setting metrics benchmarks for the future. In method, BA is an offshoot of BI. BA focuses on using data to net new insights, whereas traditional BI used a consistent, repeating set of metrics to steer future business strategies based on this historical data. If BI is the way to catalog the past, then BA could be called the way to deal with the present and predict the future.

Hosted business intelligence solutions like RJMetrics offer a combination of BI and BA by providing a data warehousing and reporting solution alongside a flexible interface for ad-hoc analysis and data discovery that can point you toward smarter decisions.

The Evolution of Business Intelligence vs Business Analytics

In the past, BI has been used to talk about the people, processes and applications used to access and extrapolate meaning from data, for the sake of improving decisions and understanding the effectiveness of targeted decisions. But this is where BI as a baseline failed; something that runs entirely off of static, historic data severely limits a user’s ability to make predictive decisions and forecast for the future market. When an emergent situation arises on a Friday afternoon, the user doesn’t greatly benefit from looking at metrics collected prior to the introduction of that situation.

The rapid growth and demand for BA comes from this failing, and is in a way the evolved form of BI solutions. In a business world whose speed is ever-increasing, the user needs to be able to interact with information at the speed of business, not looking back over his or her shoulder at what happened in the past. BI setups alone do not support the occurrence of users asking and answering questions in the face of marketplace events as they happen. A company that is data-driven sees their data as a resource, and uses it to hedge out competition. The more current the data the user has, the better jump he or she has on the competitor, who may or may not have become a threat in a time so recent that traditional BI data reporting wouldn’t even take them into consideration.

Many companies are commonly implementing advanced analytics on top of their data warehouses, to bridge the gap between BI and current day needs. Perhaps this is the origin of the confusion between terms, as organizations pick and choose from different combinations of services and have no real understanding of what to call these mashups.

Equally relevant is the fact that more and more people are being asked to interpret data in roles that are not strictly analytical. Product managers, marketers and researchers are moving towards data as a way to formulate strategies, and traditional BI platforms make it difficult to push data into real-time situations and what-if scenarios.  With the importance of data-driven decisions increasingly becoming a realization for less tech-savvy branches of company teams, the need for more user-friendly and faster producing platforms also grows. Moreover, delivering the data that supports these decisions to a broader company team demands a more visual form of modeling tool, to improve understanding across all departments. Charts and graphs showing BA findings are quicker and more impacting than written out statistics and excel sheets full of data.

Data interpretation and the manipulation method of choice change as the market demands. While having a set of established methods is important to the effectiveness of a company’s strategy, it’s understanding the need for flexibility in the face of these changes that can be a company’s most valuable asset.

If you’re looking for a robust business intelligence tool that empowers the use of business analytics within your organization, sign up today for a free trial of RJMetrics.

RJMetrics Round-Up (10/02/2012)

September was a busy month for us here in the RJMetrics office. Take a look at what we’ve been up to:

Product Updates:

  • Work on the beta chart editor continues, including a new trend-selection screen during chart creation, better restriction sequence validation and many UI enhancements.
  • We’ve added support for up to 20 Google Analytics goals.
  • The current period can now be optionally included or excluded in a cohort chart via step 2 in the chart builder.
  • We fixed a bug that caused subscription trends from displaying properly in our trend editor.

Company News:

  •  We gave www.rjmetrics.com a facelift – check out some new pictures of our office and staff on the about us page.
  • Watch Bob speak in this interview from Start Up Philadelphia.
  • Our trip to Denver for the Shop.org exhibition was a great success. We loved meeting so many of our customers in person.

    Jake and Shaun, talking data.

    Shaun and Xiao set up the booth.

What’s Next:

  • We’re happy to announce the first ever RJMetrics internal Hackathon, which will take place Friday October 12 and Saturday October 13 as an all night event.

Nomorerack.com Makes Smarter Decisions with RJMetrics

The post below was submitted to us by nomorerack, a fast-growing online shopping destination with an avid team of RJMetrics users.  To see what RJMetrics can do for you, get started with our 30 day free trial today.

At nomorerack.com, our goal is to be the go-to online shopping destination for those who want quality brand name apparel and accessories for up to 90% off retail. A key to achieving that goal is having a deep understanding of our customers’ behavior.

In this post, we outline our methods for maintaining a consistent, deep understanding of our customer base that evolves with our data.

Quest for Customer Insights

Our long-term success is strongly dependent on client satisfaction. We’re focused on making sure that our customers keep coming back, refer their friends and help our community grow.

To better understand our customer base, we wanted to use important metrics like revenue per user (RPU), time between purchases, and cohort analysis. It was critical to us that we be able to access these metrics on-the-fly as our data changed and segment them by things like acquisition source. Understanding the returns we see from different channels is critical because it tells us which avenues are most effective and where we should be directing our resources.

To address these needs, we went looking for an analytical tool that allows non-technical team members to pull frequently updated reports and run queries via a simple user interface. It was also important that we get up and running as quickly as possible. We looked to the cloud.

Cloud Business Intelligence

A quick search led us to RJMetrics, which provides hosted data analytics software. We reached out to them and signed up for a free 30 day trial in which we asked to measure those key metrics like RPU, lifetime revenue (LTV) and repeat purchase patterns.

Vishal Agarwal, our Director of Business Development, signed up for RJMetrics on a Friday and was running these critical reports by Tuesday of the following week. By Thursday, our whole team was trained on RJMetrics’ system. Within a week of signing up, we were already saving many hours that were previously spent on report generation and data exploration.

Another unexpected plus came as a result of RJMetrics’ experience in working with e-commerce companies like ours. RJMetrics has developed a suite of best-practices metrics that are readily available out-of-the-box. Through cohort analysis, we are able to group customers by their registration dates and analyze their subsequent purchases over time on a single chart. This exercise was brand new to our team and would have taken us hours to build in Excel.

We knew this subjectively but the cohort chart confirmed that we had an amazingly loyal customer base. Customers acquired in November 2010 have continued to spend the same amount with us month on month, right till date. This was extremely encouraging evidence that our customers love our products and are far more valuable than just the amount of their first purchases.

While we were very focused on acquiring new subscribers, what was very surprising that 70% of our revenue always came from existing customers.

RJMetrics also helped us optimize marketing dollars. Their “repeat purchase probability” and “average time between purchases” metrics helped us in planning email triggers and targeting specific audiences within our user base. We also learned that only 5% any given day’s sales came from users who registered on the same day, which encouraged us to place increased focus on converting new users.

To share these metrics internally, we leveraged the “syndicated dashboards” feature in RJMetrics. This feature allows us to share common dashboards such as “sales,” “supplier” and “marketing,” with different teams internally. This way, management can clearly communicate with key teams through one set of metrics. No more exchanging multiple emails with messy excel spreadsheets and end of the day reports.

 New Insights Every Day

Once we started digging into our data using RJMetrics, we realized that its scope is much wider than just calculating cohorts or LTVs. RJMetrics became a one stop shop for all of our data needs – from basic revenue reporting to the more complex analysis of ancillary data sets.

The beauty of RJMetrics is that it can incorporate any data that lives in our backend database. Every time we start tracking a new data field, RJMetrics can incorporate it into our hosted data warehouse, and we are able to start charting it in a matter of hours. For example, we just started analyzing customer surveys and not only are we able to analyze customer satisfaction and chances of repeat purchase, but we are also linking this data to its respective products and vendors. This allows us to measure company performance through suppliers, products and deal campaigns. In other words, our customers are now actively defining what we sell.

Conclusion

We chose to rely on a third-party service to enable the analysis of our backend data and we are thrilled with the results. Rather than re-invent the wheel, we left it to the experts at RJMetrics and have been able to reap the benefits extremely quickly.

RJMetrics Round-Up (9/04/2012)

Lots of new changes are on their way for us in September. Take a look at what we’re doing:

Product Updates:

  • We now support stacked bar charts for MultiSeries data.
  • We’ve released better handling of non-date category names on our charts.
  • We’ve increased internationalization support via continued UTF-8 compatibility efforts.
  • Standard implementations now include e-mail summaries and a new executive dashboard.
  • We are testing a guided video tour for new users, to help you better get to know our product and what it can do for your team.
Company News:

What’s Next:

  • Don’t forget to come say hi to us at shop.org in Denver, Colorado next week. More information about the summit can be found here. We’ll be at booth 561.

RJMetrics Round-Up (8/20/2012)

Summer is winding down in Philly, but here in the office we’re just getting started with lots of exciting news and developments.

Product Updates:

  • We now support multi-series charts and tables as inputs to composite charts.
  • Cohort charts can now include the current period as a cohort.
  • We’ve rolled out a new backup system that will shave hours off of some update cycles and provide improved disaster recovery speed.
  • We’ve released better chart label organization to display more data in the available chart area.

Company News:

  • We’re excited to be participating in the Drexel Co-Op program for the first time this fall. Drexel Dragon Ryan Lurch will join us for the fall quarter as a Software Developer. He starts on September 24th.
  • We were recently featured in the Wall Street Journal’s blog.
  • Our summer internship program wrapped up with a farewell party and the internal release of an exciting set of experimental new features. More news on that coming soon.
  • We’re heading to Denver for the Shop.org conference in September.

Check back in the coming weeks to hear more about our newest updates and happenings.

RJMetrics Round-Up (6/11/2012)

Here’s a look at what we’ve been up to at RJMetrics headquarters.

Product Updates:

  • We’re now offering completely free 30 day trials, no credit card required. Simply sign up on our website and you can connect a data source or upload your data right away.
  • Our new notifications system enables users to better manage the RJMetrics system. For now, users can expect to see system notifications here like billing warnings and permissions changes. You can look forward to additional features based on notifications in the future.
  • We’re introducing a new “NOT IN” restriction clause, which allows you to restrict against large groups of items with a single restriction.

Company News:

  • Our interns have officially arrived, and are busily working on a group project.
  • We exhibited at the Internet Retailer Conference and Expo last week in Chicago, as seen below. It was great to catch up with our many customers at the show, where we also met so many new and exciting online retailers.

What’s Next:

  • Bob is speaking at the YIP Progressive Thinkers Luncheon next Wednesday.

Check back in two weeks for all the latest RJMetrics news.

RJMetrics Round-Up (5/29/2012)

To wrap up May, here’s a quick run-down of what’s been going on in our office:

Product Updates:

  • We’re in the middle of rolling out the new charting library
    on a client-by-client basis. Roughly 40% of our clients have received these updates, and we’re upgrading more clients every day.

Company News:

  • We were featured in this past Sunday’s issue of the New York Times. Read all about it here.
  • Last Monday, Bob presented at a Business Data Tech Meetup in NYC. Coverage of the event can be found here.
  • We’re happy to welcome new engineer Rohan Shah, and designer Zach Kozak, who both start the first week of June. New analyst Sharon pan will become a part of our team in July, as will engineer Nate Vecchiarelli.

What’s Next:

  • Our five undergrad interns arrive next Monday, to begin a long and productive summer internship.
  • If you’ll be in Chicago, come out and see Jake, Shaun, Xiao and Ted at the IRCE on June 5-7. Info on the conference can be found here.
  • Jake is giving an insparq webinar on wednesday.

Check back in two weeks for more RJMetrics news and updates.