CASE STUDY

SITRICS

Sitruna had connected all of their Amazon data to a BigQuery data warehouse, but was struggling to enable their team to use it easily and often to unlock the type of analysis they needed. So we built them a Google Sheets add-on that lets anyone query any data without writing a single line of SQL.

Unlocking the power of data, for everyone.

Paid media developers custom solution

450

Queries/week

Data that would otherwise have never been used

5

Hours saved

For a single account manager's weekly reporting

20K

Rows

Of additional, external data used to enrich their reports

WHY SITRUNA NEEDED

SITRICS

The Problem: Sitruna specializes in Amazon - and they wanted to make their extensive data (on everything from listings to ads) useful even for non-technical account managers. But reporting and analysis was a challenge because data was stored in Google BigQuery and very few account managers knew SQL. Data Studio reports were easy, but for the advanced use cases they had in mind they needed to be able to pull reports easily into Google Sheets. As things stood, pulling any custom reports for data manipulation took hours. For just one of their clients, pulling reports amounted to 5 hours of boring, repetitive work per week! 
 

The Solution: We created a Google Sheets add-on that allows anyone at Sitruna to easily pull reports from BigQuery in minutes. With a few simple dropdowns, it lets you choose what report you want, what columns you need, and any filters. In the backend, it takes the user inputs and turns them into an SQL query, which it then pulls from BigQuery and returns in a Google Sheet. 

 

With this done, we realized we could make any data - even outside of their Amazon data - easily accessible. By simply connecting to APIs and storing the data in BigQuery, any user can now easily access all kinds of valuable data. Now, almost any data Sitruna is interested in can be easily queried by anyone in their team.

stephen.jpeg

"It has been fantastic working with Julian and Acuto, the quality of their work is fantastic and we're really excited to be using the new tools"

Stephen Harris, Founder of Sitruna

Data engineers PPC

RESULTS

Accessibility: huge increase in data available to non-technical users. The team now processes 300 queries/week to fuel various reports

Visibility: ability to query datasets from different sources with one simple front-end 

Performance: massive reduction in time spent pulling reports 

Flexibility: ability to easily add new datasets and tables to BigQuery

Security: table-level user authentication

Speedy service: delivered on time within 4 days

Book a meeting to discuss analytics