Share on facebook
Share on twitter
Share on email

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…

One thought on “Geek Corner – Integrating Transaction Data into RunSignUp Analytics

Add yours

Leave a Reply

%d bloggers like this: