Geek Corner – Integrating Transaction Data into RunSignUp Analytics

You may have seen a new piece of data on your Dashboard Overview page – Transactions! As of Nov. 2, the data still shows $0:

Image-1

While it will be cool to see the real data in another day or so, for geeks, the interesting part is how we are going to show the data!

If you have been following along, we have built our own equivalent of Google Analytics for races. It tracks each click on your website and matches that up against things like Registrations and $ Transactions. It is a separate system built on the latest technology using a web service API Gateway, Lambdas to process, and a replicated, scalable AWS Aurora database.

We are adding features incrementally, and we are now adding Transaction data. To do this, we have a PHP script running in the background on the main RunSignUp servers to capture the transaction data from each and every transaction back to the spring of 2010. Yes, millions and millions of transactions are being analyzed and the data exported to the Analytics database via the API Gateway and Lambdas and stored in the Aurora database. This process has been running since Oct. 25 – yes, over 7 days to capture all of the data.

Once the data is over in the Analytics database, we will clear the caches, and transaction data will magically appear!

The next step is to align source information (email, Facebook Mobile, etc.) with the registration and transaction data. Once we have that working, we will do a similar data export of all the Registration $ and Donation $ so you will be able to see which channels are producing the most donations and which are producing the most registration dollars.

And this is happening many times per second.  Geeky cool…

Author: RunSignUp

RunSignUp is the leading innovator of online tools for race registration, race day solutions, and running clubs. Services include RunSignUp for registration, RunSignUp Go for Race Day, RunSignUp RD Go for Timers, RunSignUp Clubs to enable membership management, and RaceJoy for mobile experiences. More than 10,000 race directors, timers, running club officers and running stores use these services today, including leading organizations like the Boilermaker Road Race, Crim Festival of Races, Pittsburgh Three Rivers Marathon, Inc., Fifth Third River Bank Run, Blacklight Run, Bubble Run, Night Nation, Mercedes Marathon, Kentucky Derby Festival, Leone Timing, KC Running Company, Compuscore Timing, Knoxville Track Club, Pikes Peak Road Runners, Gulf Coast Runners, Columbus Running Company, Playmakers Running Store and many more. In 2015, over 10,000 races used the system to register more than 2.7 million participants. In 2016 over 14,000 races will use the system to process over 4.3 million paid registrations. Services are free except for processing fees when conducting monetary transactions such as race registration or club membership renewal. RunSignUp is founded by runners for runners, using technical capabilities to bring the power of cloud computing to benefit the running community. For more information, visit www.RunSignUp.com.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s