Explanation based on partner company cases
AI Collaboration

Querying Marketing Metrics Through a Semantic Layer

How a semantic layer connects order, fulfillment and customer service data with metric definitions and access controls for natural-language queries.

Illustration for Querying Marketing Metrics Through a Semantic Layer
This is an explanatory image to help you understand the topic. It does not represent actual product screens or quantitative performance.
i

Information on partner company disclosure cases and technology application methods. Roles and quantitative performance for each project are guided based on performance data.

Semantic layer-based marketing queries first define business indicators such as sales and cancellation rates, and then link natural language questions to approved indicators and data ranges. The focus is on reducing the problem of the same term having different meanings in different systems.

What data do you connect?

data areaDescriptionIndicators to Link
ecommerce · Order · PaymentInflow into our own mall, order and payment informationOrder amount, order conversion and campaign inflow
OSM · Order FulfillmentOrder processing information, including shipment, delivery, installation, cancellation, and returnFulfillment status, cancellation/return reflected sales
CTI · Customer consultationConsultation classification and inquiries/inconveniencesCustomer response regarding delivery inquiries and campaigns

Name and ledger scope are the distinctions used in this case description. The data structure and calculation standards of the actual system are determined for each implementation environment.

Through what process are questions answered?

  • Interpret the period, target, and indicator in the question and check again for ambiguous terms.
  • Check calculation formulas, join relationships, and permission scopes in the semantic layer.
  • Aggregates with the accepted data and returns the baseline and metric definition.

Sample question: “Please show us sales and delivery inquiries reflecting cancellations and returns from last week’s special exhibition.” This is a descriptive question and does not represent actual customer data or performance figures.

How do you verify accuracy and authority?

We compare the results with the correct questions and calculation formulas agreed upon at work, and test methods for accessing data outside of authority, exposing personal information, and handling ambiguous questions. It is important to indicate when the data is updated and when the results are based to account for differences in aggregation.

How are the roles of GLT and partners divided?

areaRole in collaboration
GLT KoreaDefinition of business rules and indicators between order, logistics fulfillment, and consultation, domain schema/linkage requirements, and review of result consistency
AI technology partnersDesign and implementation of AI model, agent, and platform, and model evaluation and operation technology
Customer company/operating organizationData use rights, business review, application approval and operating policy

The table above divides the areas of collaboration, and the actual scope of performance and output for each project is confirmed according to the contract and division of work.

Disclosure and scope of explanation

Introduction to Serendex Public ProjectIntroduces a case of natural language marketing index inquiry that connects ecommerce, OSM, and CTI data of a global home appliance manufacturer with the Cube semantic layer.

This article explains the application structure based on the published examples and the domain perspective of GLT. Each customer's contract period, inspection results, and quantitative performance are provided separately from the technical description on this page.

YOUR OPERATIONS / NEXT STEP

Where should we begin to review our company's logistics challenges?

Please let us know how you currently operate and what you would like to change. From business analysis to data, system, and field application scope, we organize them together.

Please choose a situation that is close to our company.

Having these materials will be helpful in your review.

  • Current work flow
  • Situation you want to improve
  • Systems in use and data readiness

Even if you don't have any data yet, you can tell us about your current situation. Information that is difficult to disclose may be reviewed as a sample with identifying information masked.

In consultation, the scope is set as follows.

  1. Check current work and improvement goals
  2. Summary of data/constraints and comparative verification scope
  3. Link to existing systems and discuss scope of construction
Consult on our company’s assignments Apply without registering and select system/size input
REFERENCESView Source / References ↗

Please check the guidance in the text for the scope covered by the material. The date of publication of the original text and the actual performance period are distinguished.

STAY CONNECTED

Stay up to date with logistics.

Cases, product news and implementation guides for your interests. Subscribe with email verification and your consent.

Subscribe to GLT →
LET’S SOLVE IT TOGETHER

What logistics challenge
are you facing?

Talk to GLT ↗