An Australian retailer needing unified reporting across NetSuite, eCommerce, stores and marketing
Building a Single Source of Truth Across ERP, Commerce and Marketing
One source of truth across five data sources
The Challenge
Sales reporting meant pulling from NetSuite, the eCommerce platform and POS, then reconciling the three in spreadsheets. Different teams reported different revenue. Inventory data was fragmented. Customer data was split across eCommerce, NetSuite and the email platform with no unified view. NPS lived in a separate tool with no link to purchase behaviour. Month-end took the finance team more than five days.
Our Approach
Data governance framework. We defined which system owns which data. NetSuite masters financial transactions, inventory and customer records. eCommerce masters session and conversion data. POS masters in-store detail. Marketing platforms master campaign performance. Nothing overrides across a boundary.
Integration layer. We extended the Celigo architecture so all transaction data reaches NetSuite in near real-time, classified consistently by channel, location, customer and product hierarchy.
SuiteQL reporting. We built a query library that absorbs the awkward parts of the NetSuite data model. Sales by channel, by location and by class, budget against actual, stock on hand and customer lifetime value, all queryable directly.
NPS integration. We connected the survey platform to NetSuite through Celigo, so satisfaction scores sit against customer records and can be read alongside purchase history.
Key Metrics
Month-end reporting
Before
More than 5 days
After
Under 2 days
Data sources reconciled
Before
Manually, across 5 systems
After
Automated at source
Revenue discrepancies
Before
Routine
After
One agreed number
NPS linked to transactions
Before
No
After
Yes
The Outcome
Month-end dropped from more than five days to under two. Finance reports from one source. Operational teams run their own SuiteQL reports without queueing behind anyone. The governance framework means every new integration starts with data ownership already settled.