Discuss a project

DL-048 · Case study

Unified commercial data layer for Shopee, Lazada and TikTok Shop

A fast-growing beauty brand needed comparable commercial reporting across Southeast Asian marketplaces.

Client
Name withheld
Location
Thailand
Industry
Beauty and personal care
Capabilities
03Build
01

Challenge

  • Marketplace dashboards used different sales, refund and promotion definitions.
  • Finance and marketing teams could not reconcile reported sales with actual settlements.
02

Environment

  • Shopee, Lazada, TikTok Shop and Shopify.
  • BigQuery, Looker Studio and internal product cost records.
03

Intervention

  • Created separate source adapters and a canonical order and settlement data model.
  • Normalized product IDs, marketplace fees, discounts and refunds.
  • Built contribution-margin views combining transaction data with internal product costs.
04

Outcome

  • A consistent commercial reporting layer across marketplaces.
  • Teams can analyze profitability using comparable transaction definitions.
Four channels feeding normalized transactions, settlement models and contribution-margin reporting.SHOPEE / LAZADAOrdersTIKTOK / SHOPIFYOrdersCANONICAL MODELOrders / feesBIGQUERYSettlementsMARGIN VIEWSLooker Studio
  1. 01SHOPEE / LAZADAOrdersTIKTOK / SHOPIFYOrders
  2. 02TIKTOK / SHOPIFYOrdersCANONICAL MODELOrders / fees
  3. 03CANONICAL MODELOrders / feesBIGQUERYSettlements
  4. 04BIGQUERYSettlementsMARGIN VIEWSLooker Studio
Fig. 01Southeast Asia commerce data layerFour channels feeding normalized transactions, settlement models and contribution-margin reporting.Scale NTS

Stack and services.

Stack06

  • Shopify
  • Shopee
  • Lazada
  • TikTok Shop
  • BigQuery
  • Looker Studio

Services used01

Tell us what has to work.

A senior engineer reads every brief. Describe the system, what it runs on today and what happens when it fails.

Discuss a project