Skip to main content

Emergency Analytics Support

Steven Elliott2 April 20203 min read
Emergency Analytics Support

It can be tricky judging how to pitch a new offer in times of crisis. There’s a fine line between being genuinely helpful and appearing exploitative.

Sometimes you have to just jump in and try things, knowing they may be misinterpreted by the minority. In business, indecision can be crippling. While people’s lives are undoubtedly the most precious thing, livelihoods are worth saving too.

A number of our clients - particularly those in the retail sector - have been hit hard by recent events. As a consequence, our business has suffered too. It feels like every email and phone call carries the threat of a pause or cancellation. Like many other companies, we’ve been compelled to reexamine our business model and consider steps we may not have taken otherwise.

Historically we’ve only ever worked on a retained basis, on the grounds that long-term engagements give us not only the most financial security, but the best chance of delivering value. We firmly believe analytics is an ongoing endeavour, not a one-time fix. The tenure of most clients, and the proportion of our business that comes from referrals, suggests our judgement has been sound.

These aren’t normal times though, and business is anything but usual.

I’m pretty sure there’s a number of companies out there with digital marketing and analytics teams depleted for one reason or another. It could be that key staff are unwell, or have their hands full caring for dependants. We’re starting to hear of entire teams being furloughed, and many companies have put in place a headcount freeze for the foreseeable future.

And yet the demand for up-to-date information and insight is greater than ever. When physical stores close, there’s even more attention focused on digital properties. These same companies desperately need to understand new behaviours and establish new baselines. They need to automate daily reports in case the people aren’t there to produce them and accurately predict demand so the moment they see an uptick, they’re ready to ramp ad spends, reorder stock or get production lines producing.

We need to do what we can to keep businesses moving. Closer to home, we need to keep people busy and productive. That’s why we’ve taken the decision to offer free 20-minute remote consultations to UK-based companies to provide support on the core Google tools that we have expertise in: Google Analytics, Google Tag Manager, Google Data Studio and Google BigQuery.

Book a session and our certified experts will do their best to answer your questions or solve your problem on the spot. It could be setting up a custom report in Google Analytics, debugging a tag in GTM, checking a connection in Data Studio or doing a quick code review for BigQuery. If we can’t fix it there and then, we’ll quote for completing the work as soon as we can divert time away from our retained clients.

There’s no catch. The consultation is genuinely free and any estimate given comes with no obligation. However we naturally hope at least one or two paid projects result from the time we invest in helping people. If not straight away, then maybe down the line when times are better and budgets are replenished.

Let’s all hope those times come sooner rather than later. Keep calm and carry on measuring!

Need help with your data platform?

We build intelligence platforms on BigQuery, Dataform and Google Cloud - from setup to ongoing optimisation.

How ready is your data?

Take our short assessment to find out where your data stack stands and what to prioritise next.


Suggested content

BigQuery Tips: When your query is technically correct but BigQuery won't run it

There is a particular kind of frustration that comes from staring at a query you know is correct and watching it fail. No syntax error. No logic problem. Just a wall. We hit two of them on the same project. What we were building The job was to migrate ga4_daily_snapshot for a large enterprise client from a BigQuery scheduled query into a proper Dataform pipeline. The scheduled query had been added to over time until it was too large to maintain with any confidence. Moving it to Dataform w

Katie Kaczmarek17 Aug 2026

BigQuery Tips: The subquery in your WHERE clause that's scanning your entire table

There is a pattern that appears in a lot of BigQuery pipelines and looks completely reasonable. You have a control table that stores the latest processed date. Rather than hardcoding a date into your query, you pull it dynamically: SELECT * FROM `project.dataset.events` WHERE event_date = ( SELECT latest FROM `project.dataset.control_table` ); The query returns the right results. The logic is clean. And if your events table is large and date-partitioned, you might be scanning the entire

Katie Kaczmarek13 Aug 2026

BigQuery Tips: Arrays in BigQuery - what they are and how to get data out of them

If you have ever opened a GA4 export in BigQuery for the first time and found yourself looking at a column called event_params that seemed to contain an entire table inside each row, this post is for you. Arrays are not trying to make your life harder. Once you understand why they exist and what to do with them, they stop being intimidating. Why BigQuery uses arrays GA4 tracks events. Each event can have many parameters. A purchase event might have a transaction ID, a value, a currency an

Katie Kaczmarek10 Aug 2026