Early Settler
Blending online & offline data to grow both ecom and brick and mortar sales.
64%
Increase of measured store revenue.
Challenge
Early Settler is a large Australian furniture business that drove the majority of all revenue in store with the remaining being eCommerce. This presented the problem that only direct eCommerce revenue was trackable back to media, and the remaining impact of in store was not accounted for.
What we did
Built a data warehouse that pulled in all store sales across every furniture category at the store level.
Blended in all media data broken out by geographic ‘market cell’ to determine how much was being invested per category per store.
Built a model on top of this dataset to determine how much media was contributing to in-store sales by store.
Resulting in a live dashboard that reported on both online and in-store sales driven by all media.
