Skip to main content

Posts

Showing posts from May, 2018

Revitalising your Data

It's a brave new world, where data is king. Sometimes, this data can live in platforms which does not let you use it as effectively as you should .  Today, I'm going to take you on a way that you can programmatically extract and transfer to a much richer set of analysis tools. The Task I was handed a project to move all of the data from Campaign Monitor to Google Data Studio .  No surprise, this reporting platform had a massive list of data connectors, and after a little bit of research, I decided to go with Google Cloud Storage - it just seemed to be the most flexible. The Extraction I wouldn't be able to go in to great detail on how I've made my Campaign Monitor class, being that its Intellectual Property, but I can go in to where you can find the relavant documentation.  I was asked to focus on just 3 streams of data; Opens , Clicks and Unsubscribes . Be sure to follow the Getting Started guide, using the most appropriate level of authentication.  Not be