Skip to main content

Posts

Showing posts with the label Google Storage

Back in to Dashboard Reports

Carrying on from my last post , a while back, I blogged about how I took data from Campaign Monitor and posted to Google's Data Studio for the sake of creating a better, compiled dashboard.  Well the request popped up again for me, but this time to take some more generic data, so I decided to write a better class for it. This is going to be short and sweet, like the previous post, we're going to need a simple addition to our composer.json: The construct object is going to look very similar as well: And now we'll just make a simple upload function to use to store in Google's storage buckets: From there - you can go nuts in the Data Studio.  Folder and file naming conventions are very important, with spreadsheets for instance, you can keep uploading date stamped files which will merge nicely and you can see your increments over time. Hope you'll all be able to make some cool integrations with this! J.

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...