How En Gold connects all marketing data sources to centralize reporting.
En Gold, a home-and-furniture store, combines data from multiple sources together to design its single source of truth with Airboxr.
Victoria, Australia
engold.com.au
What is En Gold?
Founded in 2018, En Gold supports the slow interiors philosophy—producing in limited quantities to ensure minimal waste and promote conscious consumption.
The Problem
Too much time spent on manual reporting.
The En Gold marketing team creates daily, weekly, and monthly reports comparing ad spend across platforms to sales via multiple channels: their Shopify store and their gallery sales. They present their reports to management using Google Looker Studio.
Dispersed data
Unreliable data
Manual daily reporting was taking 2.5 hours out of their week; weekly and monthly reports took another 5 hours every month. In total, they spent two working days a month just making reports. This was highly inefficient use of their time, as the brand was growing rapidly and needed all hands on deck to work on more important business priorities.
The Solution
Connect all marketing data sources to Google Sheets using Airboxr and schedule them to run automatically.
The team used Airboxr automations (”Hops”) to automatically pull the data from Shopify and various ad channels, standardize the data, and deliver the final output to their spreadsheets. These reports then ran on a daily schedule.These spreadsheets were then connected to Google Looker Studio, which was used to create dashboards and custom visualizations.
Airboxr acts as the connection between their various data sources and their visualization tool. They do not need to manually key in data from these different platforms, or look for expensive connectors that fail to fulfill their e-commerce-specific needs. The team used multiple reports such as the following to create a centralized Looker template.
A daily digital marketing report
Weekly and monthly sales reports
Monthly budget planning
Sales by product and category
Multi-source data import through APIs.
Airboxr imported data from Shopify, ad channels, and email platforms.
Data transformation and analysis.
Airboxr analyzes the imported data and prepares it for delivery.
Automatic delivery on spreadsheets.
Airboxr delivers the data into the spreadsheet the team already uses.
Before Airboxr, I was manually putting in data from different platforms into this spreadsheet, but now all I need to do is open the spreadsheet and see the data. Airboxr helps me focus on the high level view, and avoid getting distracted. This saves me a lot of time, which I can now use to work on other priorities.
Marketing Manager
En Gold, Australia
The Impact
Faster insights. Better decisions.
Be centralizing all their marketing, sales, and product data, Airboxr helped the En Gold team get a clear picture of their business and focus on more strategic decision-making.
