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.

Fashion & Apparel

2011

Victoria, Australia

engold.com.au

furniture

2018

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.

How Airboxr helps En Gold automatically prepare sales vs. marketing reports.

The En Gold team uses Airboxr to quickly prepare reports comparing spend across Ad channels to actualised sales in seconds giving them more time to focus on decision making.

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.

2.5+ hrs

Saved/week

$10k

Saved/year

Create your free account

Create your free account

Create your free account

Start maximizing your ad spend today

14-day free trial

14-day free trial

70+ automated reports

70+ automated reports