Pack Leader : Automating Data for Speed and Visual Simplicity

Pack Leader implements an automated data pipeline, utilising BigQuery and DataStudio to turn data into actionable insights for sales reps.
Pack Leader is a group of dedicated people that are trying to make a profoundly positive difference to the lives of every pet we serve. Everyone in our pack, whether they are vets, sales reps, customer care, marketing or accounts and distribution team members live the vision of world-class pet care.


Google Cloud Results

  • Built and automated a data pipeline,
  • Data extraction from inventory system, running it through BigQuery for computational speed
  • DataStudio visual customer report dashboards to support sales reps – up-to-date and accessed anywhere

The challenge

The current reporting tool’s high license fees and manual report generating process was causing bottlenecks and time delays in getting customer reports to the Sales Reps. Pack Leader approached Opennetworks for a solution. Could Data Studio allow the Sales Reps access to reports, using the latest daily data, while on the road visiting their customers with no additional costs?

The solution

Using Apps Script, Drive, Sheets, BigQuery and Data Studio, a data pipeline was built, taking data out of the inventory system straight into customer meetings. The sales team now has access to rich, relevant information delivered on a highly visual platform which adds a new dimension to discussions with customers.
“The speed and visual simplicity of Data Studio’s collaborative reporting technology, and the immediate access to real-time data it allows, helps us to better provide for our customers.”
Grant Walliser, Chief Executive Officer, Pack Leader Pet Products

The result

Using Google tools and services allowed for a 100% reduction in reporting license fees, a 10% increase in productivity in the accounts department and a 90% increase in delivering timeous data to the customer.

Other Articles

Google Workspace

Email Security 101: Protecting Yourself from Scams and Threats using Google Workspace

Email is an indispensable tool for both personal and professional communication, but it’s also a prime target for cybercriminals. With …

Customer Story

The Student Hub – Enabling The Student Hub to expand at scale, across geographies.

Opennetworks undertook the smooth technical deployment, change management, training and ongoing support of Google Workspace for The Student Hub. Services …


Opennetworks ranks #48 in the inaugural FT Africa’s fastest growing companies in 2022

Blog post: From the Opennetworks team Opennetworks is proud to announce its inclusion inside the top 50 fastest growing companies …

Google Workspace

5 Ways to Increase Collaboration in your Team

Written by Katy Ocker, Learning Experience and Training Lead The working world has been on the road to change over …