Psand Blog

Populating Google Sheets with Analytics Reporting API v4

Posted on Jan 22, 2021 by Dave Gough

Google Analytics through API v4 to Google Sheets

Get your Google Analytics data into a Google Sheet to allow easy analysis using the latest version of the Analytics Reporting API, version 4.

Dave walks through a step by step guide with an example Google Sheet and script to get you kickstarted...

Read more

2020 is the year to upgrade to HTTPS

Posted on May 27, 2020 by Archie Kennedy

Padlocks on a fance in front of a red wall

HTTPS is the secure version of HTTP, the protocol used to send data between browsers and websites.

Enabling HTTPS on your website keeps the data entered by your users safe from prying eyes. Providing the security...

Read more

How to stay motivated and focused whilst working from home

Posted on April 1, 2020 by Jasmine Parsons

Photo of woman in orange shirt using iphone and laptop

For some people, working from home is perfectly normal and can be a preferable way to work. For others, it’s unusual and may feel lonely and full of distractions.

Technology is making working from home, also known as remote working, easier...

Read more

Servers: Dedicated or Virtual - What are they?

Posted on November 21, 2019 by Archie Kennedy

Server racks with locked cabinets to prevent physical tampering

Millions of people access the internet each day, without really knowing the complicated processes that are happening in the background as they scroll through cute pictures of puppies or book their next holiday.

Well, all of those web pages have one thing in common: servers.

Read more

MeasureCamp Cardiff 2017 sponsorship

Posted on February 2, 2017 by Dave Gough

People around a conference table attending a measure camp

Big data!!

There, I’ve done it, I’ve sworn – at least according to the MeasureCamp swear jar instigated by it’s founder Peter O’Neill.

On the welcome podium at the 6th London MeasureCamp, Peter waved the charity donation pot and explained “Don’t use buzz words or jargon, say what you mean. Don’t say big data, others may not know what you mean, maybe say _more data than will fit in a spreadsheet._”

Read more

Content is king, long live the king

Posted on April 17, 2015 by Iain Kennedy

Close up of playing cards showing the king of spades and king of diamonds

Now don’t get me wrong, I like a handsome website and I’m not such a philistine that I don’t cringe when I see a terrible colour scheme, or a squished or pixelated graphic, but it’s very easy to get distracted by the aesthetics of websites. Nothing wows your boss/client/mum more than a giant projection of your shiny new web pages writ large on a wall. Bold statements, compelling graphs, scrumptious pie charts – infographics that crystallize complicated concepts.

But there’s a problem...

Read more