Back when I was an internal Web Developer at Royal Media, our Marketing Team decided to purchase a CDP application called Blueconic. This would be a way for them to easily keep track of new Subscribers on our News sites. They assigned me with the task of connecting those news sites (built in WordPress) to the software. Blueconic had the ability to import Subscriber data from a CSV file if placed on an external server. So, I knew that if I had such a file I could connect it to Blueconic, but needed to have a way to update the data every day automatically. However, there was no existing solution for this.

So, I ended up digging into the code for MemberPress (the plugin we used for Subscriptions on all of our news sites), and finding where the code was for a button MemberPress had that would export Subscriber information as a CSV. I then created a cronjob that would call upon this code to export a CSV to the root folder on the server every day at 12am. Then, in Blueconic, I set the app to import that file everyday at 1am and therefore always have up-to-date information.

I was very proud at finding a solution to this, and think it is a great example of how throughout my career I have been assigned tasks to figure out solutions for problems that have no guidance to be found online or elsewhere. In these situations, I had to rely completely on my own abilities.