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
Sitruna is a specialist Amazon PPC agency 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.
WHY SITRUNA NEEDED SITRICS
The Problem: Sitruna 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. Looker Studio (formerly 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!
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
