A national Australian retailer needing unified reporting across NetSuite, eCommerce, stores, and marketing
Building a Single Source of Truth Across ERP, Commerce, and Marketing
Single source of truth across 5 data sources
The Challenge
Sales reporting required manually pulling from NetSuite, the eCommerce platform, and POS, then reconciling in spreadsheets. Different teams reported different revenue numbers. Inventory data was fragmented. Customer data was split across eCommerce, NetSuite, and the ESP with no unified view. NPS data lived in a separate tool with no link to purchase behaviour. Month-end took the finance team 5+ days.
Our Approach
Data Governance Framework — Defined which system owns which data. NetSuite masters financial transactions, inventory, and customer records. eCommerce masters session/conversion data. POS masters in-store detail. Marketing platforms master campaign performance. No overrides across boundaries.
Integration Layer — Extended Celigo architecture to ensure all transaction data flows to NetSuite in near-real-time with consistent classification (channel, location, customer, product hierarchy).
SuiteQL Reporting — Built a library of SuiteQL queries handling NetSuite's data model complexity. Sales by channel, by location, by class, budget vs actual, stock on hand, customer LTV - all queryable directly.
NPS Integration — Connected survey platform to NetSuite via Celigo. Satisfaction scores linked to customer records for analysis alongside purchase data.
Key Metrics
Month-end reporting
Before
5+ days
After
Under 2 days
Data sources reconciled
Before
Manual (5 sources)
After
Automated at source
Revenue discrepancies
Before
Regular
After
Single source of truth
NPS linked to transactions
Before
No
After
Yes
The Outcome
Month-end reduced from 5+ days to under 2 days. Finance reports from a single source with confidence. Operational teams have self-service SuiteQL reports. The governance framework means new integrations are built with data ownership defined upfront.
“We used to spend the first week of every month arguing about which revenue number was right. Now there's one number and everyone trusts it.”
— CFO