James Bachini

Lessons learned from writing a bespoke tracking platform

For a recent project I wanted to develop a tracking platform which was specifically designed to suit my needs. It needed to be simple to use, capable of handling seven figure audiences daily and built on technology I understand so it can be customised on the go.

I decided to build it arround php / mysql giving each days data a new table. I also found that alot of the information stored in traditional tracking systems wasn’t needed so I stripped it down to just the basic data I needed to optimise, some c1-4 variables and a few other bits and pieces.

I found that by using separate tables for each days data it stops alot of the problems with slow servers and having to delete data on a daily basis. Don’t get me wrong if I want to run off a report for a weeks worth of data it is still slow, so slow in fact I had to adjust the settings at which php timeouts, but I don’t think there is any way around that when analysing large volumes of information.

Dayparting can be done on a country basis or accumulated so you can see data across multiple countries, adjusted with local timezones.

Trying to keep the code as simple as possible helped avoid duplicate lines in the source. Probably a takeaway for any coding project.

The benefit of this is I now have a tracking platform which is designed to cope with high volume campaigns, which stores only the data I need and which I fully understand so if I want to analyse the data in a new way I can quickly add a new script to do that.

All in all I’m pretty happy with my new toys and would recommend it as a project for anyone in the online marketing game with a decent knowledge of php/mysql.

Get The Blockchain Sector Newsletter, binge the YouTube channel and connect with me on Twitter

The Blockchain Sector newsletter goes out a few times a month when there is breaking news or interesting developments to discuss. All the content I produce is free, if you’d like to help please share this content on social media.

Thank you.

James Bachini

Disclaimer: Not a financial advisor, not financial advice. The content I create is to document my journey and for educational and entertainment purposes only. It is not under any circumstances investment advice. I am not an investment or trading professional and am learning myself while still making plenty of mistakes along the way. Any code published is experimental and not production ready to be used for financial transactions. Do your own research and do not play with funds you do not want to lose.