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

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

Up ↑

%d bloggers like this: