D2C Data Help Center Word Compliation

# of SKUs

• Explanation: Total number of SKUs with collected prices from the selected subsidiary
• Data Source: -
• Main Dashboard: Price Positioning Deep Dive

 

# of SKUs (Error Price)

• Explanation: Number of SKUs where the seller-to-OBS price ratio exceeds the defined error threshold (default: 200%)
• Data Source: -
• Main Dashboard: Price Positioning Deep Dive

 

# of SKUs (OBS)

• Explanation: Number of SKUs that include OBS fragrances among the collected SKUs
• Data Source: -
• Main Dashboard: Price Positioning Deep Dive

 

%Adherence (Dashboard: Marketing)

• Explanation: The percentage of campaigns compliant with LGE's naming conventions
• Data Source: -
• Main Dashboard: GMP Naming Convention

 

3P Marketplace

• Explanation: In a third-party (3P) marketplace, brands sell directly to consumers through retailer platforms like COUPANG and Amazon
• Data Source: -
• Main Dashboard: -

 

3PL(Third-Party Logistics) Hub (Dashboard: Fulfillment)

• Explanation: The name of the outsourcing service provider that manages the steps after an order to be delivered to LG customers - large-scale warehouses, inventory shipments, inventory storage and tracking
• Data Source: LMDS
• Main Dashboard: Order Visibility : Fulfillment

 

AC Comp (Common: Division)

• Explanation: Air conditioner Compressor
• Data Source: -
• Main Dashboard: -

 

Ad Hoc (Common)

• Explanation: Ad hoc generally refers to the analysis or presentation of data done temporarily as needed, rather than through predefined queries or analyses based on specific purposes or plans. A dashboard created temporarily due to departmental needs, aside from regular dashboards, is called an ad hoc dashboard
• Data Source: -
• Main Dashboard: -

 

Add on Bundle

• Explanation: Add on Bundle is a function for displaying additional package products in the cart area / A feature allowing customers to purchase related accessories or items together with the main product
• Data Source: -
• Main Dashboard: OBS Factbook

 

Affiliates (Dashboard: GA_Channel)

• Explanation: This is a marketing strategy in which affiliates receive a fee in exchange for promoting a service and inducing sales. Typically, the affiliates are compensated according to a fixed fee or sales ratio
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Always on eCRM (Dashboard: Marketing)

• Explanation: This is a continuously managed CRM campaign
• Data Source: GA
• Main Dashboard: eCRM Mkt. Performance

 

Amazon VC (System)

• Explanation: Amazon VC stands for "Amazon Vendor Central," which is a platform related to Amazon's suppliers. This system allows manufacturers or wholesalers to supply and sell products directly to Amazon. It supports suppliers in registering their products, managing inventory, and processing orders. Through Amazon VC, suppliers can analyze their sales performance on Amazon and use marketing tools to enhance brand visibility
• Data Source: -
• Main Dashboard: -

 

AOV (Average Order Value) (Dashboard: Sales)

• Explanation: This is GMV per order for all transactions that have successfully completed the payment process
• Data Source: Magento
• Main Dashboard: GMV & Traffic Overview
• Calculation: SUM(GMV) / COUNTD(Order ID)

 

API(%) (Dashboard: Marketplace)

• Explanation: API(%) stands for Average Price Index, which represents the percentage of OBS sales price to the overall seller average price. The API is only for each model, and when we want the API for a set of models such as Company or Division, we use the arithmetic average of the API for the models included in the set
• Data Source: -
• Main Dashboard: Price Positioning Deep Dive
• Condition: [A model's OBS sales price] / [A model's average price for all Seller's A model]

 

Approved product

• Explanation: Products approved and cleared for advertising
• Data Source: -
• Main Dashboard: GMC Deep Dive

 

APPT (Dashboard: Fulfillment)

• Explanation: This stands for Appointment in the shipping-related dashboard. Data source is LMDS and TMS
• Data Source: LMDS / TMS
• Main Dashboard: Order Visibility : Fulfillment

 

ASP (Average Selling Price) (Dashboard: Sales)

• Explanation: This is GMV per unit of product sold for all transactions that successfully completed the payment process
• Data Source: Magento
• Main Dashboard: GMV & Traffic Overview
• Calculation: SUM(GMV) / SUM(Units)

 

ASP Diff (Dashboard: Marketplace)

• Explanation: It refers to the difference in average selling price(ASP) of a product or service between two period
• Data Source: Amazon
• Main Dashboard: Amazon VC Deep Dive

 

ATC - Login (Dashboard: Member)

• Explanation: The number of times a logged-in user clicks the 'Add to Cart' button on the LG.com website
• Data Source: GA
• Main Dashboard: Member Overview
• Condition & Calculation: Is Login = Y & ATC click / Unique Visitor

 

ATC (Add to Cart) (Dashboard: GA)

• Explanation: The number of traffic sessions or unique visitors with Add to Cart click. *ATC(%): ATC/PDP (%)
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Available SKU (Dashboard: Fulfillment)

• Explanation: The total volume or quantity of inventory held across all locations
• Data Source: GERP
• Main Dashboard: Inventory Overview
• Calculation: Salable SKU + SKUs where Salable Units = 0 but Available Units > 0

 

Available SKU With Warehouse (Dashboard: Fulfillment)

• Explanation: The inventory quantity physically secured within a specific warehouse facility
• Data Source: GERP
• Main Dashboard: Inventory Overview
• Calculation: Counting the number of unique SKU + Inventory

 

Average Daily Sales (Dashboard: Inventory)

• Explanation: This is the daily sales volume calculated using the sales history of the last 4 weeks. This is an indicator that can be used to measure efficiency compared to previous sales due to various factors such as promotions
• Data Source: Magento
• Main Dashboard: Inventory Overview
• Condition & Calculation: ISO-Week Basis 4-Week / SUM(Units) / 28

 

Average Weekly Sales (Dashboard: Inventory)

• Explanation: This is the weekly sales volume calculated using the sales history of the last 4 weeks. This metric is used to predict sales for that item
• Data Source: Magento
• Main Dashboard: Inventory Overview
• Condition & Calculation: ISO-Week Basis 4-Week / SUM(Units) / 4

 

Avg. Position (Dashboard: Marketing)

• Explanation: A relative ranking of the position of lg.com link on Google Search Result Page
• Data Source: GSC
• Main Dashboard: SEO Traffic Deep Dive

 

AVG SESSION DURATION (Dashboard: GA)

• Explanation: (Time on site) / (The total number of active users)
• Data Source: GA
• Main Dashboard: Campaign Performance

 

B2B2C

• Explanation: Business To Business To Customer
• Data Source: -
• Main Dashboard: OBS Performance Trend

 

Banner SOV (Dashboard: Marketing)

• Explanation: SOV (Share Of Voice) is the proportion of the advertising market occupied by a specific brand or product in its field. Banner SOV represents the market share of a specific brand or product in web banner advertising
• Data Source: GA
• Main Dashboard: Not used

 

Basic Goal (Common: FP)

• Explanation: The minimum objective that must be achieved. This core target is easily attainable with current resources, and failure to meet it would incur significant negative impacts
• Data Source: -
• Main Dashboard: Monthly Sales Review

 

Bazaarvoice (System)

• Explanation: Bazaarvoice is a platform for managing and distributing consumer reviews and user-generated content. This platform helps brands and retailers collect and utilize customer opinions and feedback to improve the quality of their products and services, while also building consumer trust
• Data Source: -
• Main Dashboard: -

 

BOUNCE (Dashboard: GA)

• Explanation: If a user visits your website, reviews content on LG.COM for less than 10 seconds, and then leaves without triggering any events or visiting any other pages or screens, then the session will count as a bounce. *Antonym: Engaged Session (lasts longer than 10 seconds, has a conversion event, or has at least 2 pageviews or screenviews) *Bounce(%): SUM(BOUNCE) / SUM(Unique Visitors) (%)
• Data Source: GA
• Main Dashboard: Campaign Performance

 

Brand Recognition (Mentions) (Dashboard: Marketplace)

• Explanation: The total mention count measuring the level of brand awareness
• Data Source: -
• Main Dashboard: Market Competitiveness

 

Brightcove (System)

• Explanation: BRIGHTCOVE is a company that provides video platforms and solutions. BRIGHTCOVE offers a variety of features, including on-demand video streaming, live streaming, video players, and video marketing tools
• Data Source: -
• Main Dashboard: -

 

BS Acc (Common: Division)

• Explanation: BS Accessary
• Data Source: -
• Main Dashboard: -

 

BU (Common: BU)

• Explanation: A term referring to the three headquarters of LG Electronics, an abbreviation for Business Unit, also referred to as Company
• Data Source: -
• Main Dashboard: -

 

BU Visit (Dashboard: GA)

• Explanation: The number of traffic sessions or unique visitors on LG.com website by headquarters
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Business Structure

• Explanation: Hybrid A: SoR by Agency, Shipping by subsidiary / Hybrid B: SoR & Shipping by Agency / Full in house: SoR handled by subsidiary
• Data Source: -
• Main Dashboard: -

 

Buying (Dashboard: Member)

• Explanation: This is number of customers who have completed the payment process by purchasing products as a logged-in user
• Data Source: Magento
• Main Dashboard: Member Overview
• Condition & Calculation: Is Login = Y / COUNTD(Customer ID)

 

CAC (Common: Division)

• Explanation: Customer Acquisition Cost. The total average expense spent on marketing and sales to acquire one new customer
• Data Source: -
• Main Dashboard: Multiple Purchase Review

 

CAGR

• Explanation: 3-year Compound Annual Growth Rate
• Data Source: -
• Main Dashboard: Market Performance

 

Cancel (Sales) (Dashboard: Sales)

• Explanation: This is the sales amount for which the discount amount for canceled orders has been deducted among transactions for which the payment process has been successfully completed
• Data Source: Magento
• Main Dashboard: GMV to NMV Overview
• Condition & Calculation: Status = canceled / SUM(GMV)

 

Cancel(%) (Dashboard: Sales)

• Explanation: This is the percentage of sales that have been canceled out of GMV
• Data Source: Magento
• Main Dashboard: GMV to NMV Overview
• Calculation: SUM(Cancelled Sales) / SUM(GMV)

 

Canonical Status (Dashboard: Marketing)

• Explanation: Canonical Tags play a vital role in mitigating duplicate content concerns. To ensure best practices, all pages should have a canonical tag. Pass/Error Criteria - Pass: A canonical tag is present on the page - Error: A canonical tag is missing on the page - Opportunity: A canonical tag is present on the page, but it is not self-referencing
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

Canonical Tags

• Explanation: An HTML tag designating the preferred, authoritative URL for a group of similar or identical pages
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

Category Rank

• Explanation: Number of Total Exposed Products within Top 20 Rank of Product Category Page
• Data Source: -
• Main Dashboard: EU OSM Monitoring Report

 

CDP Portal (System)

• Explanation: CDP stands for Customer Data Platform, which refers to a portal that collects, integrates, and refines LG customer data for the purpose of targeted marketing. It supports the creation of customer profiles and the utilization of customer management data
• Data Source: -
• Main Dashboard: -

 

CHECKOUT (Dashboard: GA)

• Explanation: The number of traffic sessions or unique visitors transitioning to the payment page after ATC (CHECKOUT is usually in 3 steps). *CHECKOUT(%): CHECKOUT / ATC(%)
• Data Source: GA
• Main Dashboard: OBS Traffic Overview
• Calculation: CHECKOUT(%) = CHECKOUT / ATC(%)

 

Checkout1 (Dashboard: GA)

• Explanation: This is the step where customer information is entered during the payment stage (begin_checkout)
• Data Source: GA
• Main Dashboard: Checkout Deep Dive

 

Checkout2 (Dashboard: GA)

• Explanation: This is the step where shipping information is entered during the payment stage (add_shipping_info)
• Data Source: GA
• Main Dashboard: Checkout Deep Dive

 

Checkout3 (Dashboard: GA)

• Explanation: This is the step where payment method is entered during the payment stage (add_payment_info)
• Data Source: GA
• Main Dashboard: Checkout Deep Dive

 

Clicks (Dashboard: Marketing)

• Explanation: The number of traffic sessions or unique visitors with Ad Clicks
• Data Source: GSC
• Main Dashboard: SEO Traffic Deep Dive

 

Clicked product

• Explanation: Products users clicked on to navigate to the detail page
• Data Source: -
• Main Dashboard: GMC Deep Dive

 

Closing (Dashboard: Sales_NPT)

• Explanation: This is sales at the end of the income statement
• Data Source: NPT
• Main Dashboard: P&L Closing Overview

 

CM360 (System)

• Explanation: CM360 is an abbreviation for Campaign Manager 360, which is a tool for managing and measuring advertising campaigns. It provides features for tracking ad performance and generating reports
• Data Source: -
• Main Dashboard: -

 

CMS(Content Management System) (System)

• Explanation: A software platform that helps easily create, manage, modify, and distribute content for websites or applications. In version 5.0, TeamSite provided by OpenText is used, while GP1 uses AEM Site offered by Adobe
• Data Source: -
• Main Dashboard: -

 

COI(%) (Current Operating Income) (Dashboard: Sales_NPT)

• Explanation: This refers to profit generated from operating activities and is the ratio of operating profit to OBS net sales
• Data Source: NPT
• Main Dashboard: P&L Closing Overview
• Calculation: COI / Net Sales

 

Commercial TV (Common: Division)

• Explanation: TVs used in hotels or businesses
• Data Source: -
• Main Dashboard: -

 

Commission (Dashboard: Marketing)

• Explanation: The cost payable to the affiliate partner for marketing efforts and performance
• Data Source: -
• Main Dashboard: Affiliate Marketing

 

COMPANY

• Explanation: COMPANY
• Data Source: MAGENTO_SM
• Main Dashboard: Order Visibility

 

Company Hierarchy (Common)

• Explanation: This filter is used to check performance by business division. The default value for this filter is 'On', but if you click 'Off' on this filter, you can view measured values without the division filter
• Data Source: Magento
• Main Dashboard: GMV & Traffic Overview

 

Contents Counts

• Explanation: Number of total Images and Videos in PDP
• Data Source: -
• Main Dashboard: EU OSM Monitoring Report

 

Cooking (Common: Division)

• Explanation: Including Gas stove, Microwave, etc
• Data Source: -
• Main Dashboard: -

 

Corrected (Dashboard: Marketing)

• Explanation: Campaigns identified as compliant with LGE's naming conventions
• Data Source: -
• Main Dashboard: GMP Naming Convention

 

Coupon Orders Ratio(%) (Dashboard: Coupon)

• Explanation: This is the proportion of orders that include a coupon among all orders (Except for the welcome coupon)
• Data Source: Magento
• Main Dashboard: Coupon Usage
• Calculation: Orders Used Coupon (Except Welcome Coupon) / COUNTD(ORDER ID)

 

CPC (Costs Per Click) (Dashboard: Marketing)

• Explanation: Cost per Click. It is a common advertising metric used in online advertising, particularly in pay-per-click(PPC) campaign
• Data Source: GSC
• Main Dashboard: Campaign Ads Performance

 

CPM (Cost per Mile) (Dashboard: Marketing)

• Explanation: This is the cost per thousand impressions
• Data Source: GSC
• Main Dashboard: Campaign Ads Performance

 

CPS

• Explanation: Cost Per Sale (CPS), the total expense incurred through a retailer to complete a single customer transaction
• Data Source: -
• Main Dashboard: Retail OBS Overview

 

Criteo (Dashboard: GA_Channel)

• Explanation: This is Retargeting advertising that provides personalized advertising based on users' web browsing and purchasing behavior. It aims to optimize advertising performance and improve ROI by utilizing the Criteo algorithm
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

CTC

• Explanation: CTC stands for Contribution To Change. How much it contributed to the GAP (change) compared to the previous year or month. The percentage of the individual GAP in the total GAP
• Data Source: -
• Main Dashboard: -

 

CTR (Dashboard: Marketing)

• Explanation: This is sum of Clicks over sum of Impressions
• Data Source: GSC
• Main Dashboard: SEO Traffic Deep Dive
• Calculation: SUM(Clicks) / SUM(Impression) (%)

 

Customer Group (Common: Customer group)

• Explanation: This refers to the transaction type. Transaction types include D2C, D2B2C, D2B, and D2E
• Data Source: -
• Main Dashboard: -

 

CVR (Conversion Rate) (Dashboard: GA)

• Explanation: Conversion rate in LG.COM generally means purchase rate. In terms of traffic, the percentage of Transactions from LG.COM or from PDP. In terms of purchase, the percentage of Order from LG.COM or from PDP. *CVR: Transaction / LG.COM or PDP, Order / LG.COM or PDP
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

CY (Common)

• Explanation: An abbreviation for Current Year, meaning the current year
• Data Source: -
• Main Dashboard: -

 

D2B, D2X, 3P, 1P, SMB, SocialCommerce (Common: Customer group)

• Explanation: D2C: Direct to Consumer / D2B2C: Direct to Business to Consumer / D2B: Direct to Business / D2E: Employee Sales (For In-House Employees). D = LG Direct / B = Company, Organization, etc. / C = Customer / E = Employee
• Data Source: -
• Main Dashboard: -

 

D2B2C (Common: Customer group)

• Explanation: Direct to Business to Consumer. It is a term that distinguishes OBS sales from those sold through closed channels to customers belonging to organizations such as companies
• Data Source: -
• Main Dashboard: -

 

D2C (Common: Customer group)

• Explanation: Direct to Consumer
• Data Source: -
• Main Dashboard: -

 

DAM (System)

• Explanation: DAM stands for Data Asset Management, referring to the systems or processes used to effectively manage and utilize data within an organization. It involves building and managing digital assets such as banner images and product images needed for lg.com
• Data Source: -
• Main Dashboard: -

 

Delivery (Dashboard: Marketing)

• Explanation: Sent emails successfully delivered to the recipient's server
• Data Source: -
• Main Dashboard: eCRM Mkt. Performance

 

Delivery Cost Ratio

• Explanation: Delivery Cost Ratio
• Data Source: -
• Main Dashboard: Fulfillment Performance Review
• Calculation: (OBS Delivery Cost / OBS Net Sales)

 

Delivery Itinerary (Dashboard: Fulfillment)

• Explanation: Order Create > Inventory and Hold Status > Pick Released > Load Create > Appointment > WH Released > Ship Confirm > MMD > Delivery Complete > (If Return Order Occur) Return Create > Return Complete
• Data Source: GERP, LMDS, US TMS
• Main Dashboard: Order Visibility : Fulfillment

 

Direct (Dashboard: GA_Channel)

• Explanation: This means searching the URL directly and entering it into the site
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Direct to C/O (Dashboard: GA)

• Explanation: This is the number of traffic sessions or unique visitors from PBP to Checkout. Direct to Checkout occurs as a product_checkout_click event when the CHECKOUT button is clicked on the PBP page, and the add_to_cart event is automatically created at this time
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Discount Amount (Dashboard: Coupon)

• Explanation: The amount of money for reductions of the regular price of a product or service to obtain or increase sales
• Data Source: Magento
• Main Dashboard: Coupon Usage

 

Display (Dashboard: GA_Channel)

• Explanation: This is an advertisement used to promote a product, service, or brand using the online display advertising space. It is displayed in various forms such as banner advertisements and video advertisements on digital content such as websites, social media platforms, and apps
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Div Mention (Dashboard: Marketplace)

• Explanation: Mentions classified according to the product category
• Data Source: -
• Main Dashboard: Market Competitiveness

 

Division (Common: Division)

• Explanation: Product category (REF, W/M, MNT, OLED, UHD, Air care etc)
• Data Source: -
• Main Dashboard: -

 

DIVISION

• Explanation: DIVISION
• Data Source: MAGENTO_SM
• Main Dashboard: Order Visibility

 

DV360 (System)

• Explanation: DV360 stands for Display & Video 360, which is a tool for managing display and video ads in an integrated manner. It provides features for planning and executing advertising campaigns, as well as analyzing their performance
• Data Source: -
• Main Dashboard: -

 

Dynamic Pricing

• Explanation: If prices change in comparison to competing e-commerce websites. Please indicate names of e-commerces websites referred and update cycle
• Data Source: -
• Main Dashboard: -

 

Employee Sales (Common: Customer group)

• Explanation: LG Employee purchase
• Data Source: -
• Main Dashboard: -

 

Energy Label

• Explanation: The energy efficiency information displayed on the product detail page
• Data Source: -
• Main Dashboard: OBS Factbook
  
   

Engaged Session (Dashboard: GA)

• Explanation: A session that lasts longer than 10 seconds, has a conversion event, or has at least 2 pageviews or screenviews
• Data Source: GA
• Main Dashboard: SEO Traffic Deep Dive

 

EOL (End of Life) (Dashboard: Inventory)

• Explanation: This is a discontinued product that is no longer sold. Not included in SKU coverage and ISA calculations. (EOL code: 0-normal model, 1-discontinued model)
• Data Source: Magento
• Main Dashboard: SKU & ISA Deep Dive

 

ESS BD (Common: Division)

• Explanation: Energy Storage System Business Division
• Data Source: -
• Main Dashboard: -

 

ETA

• Explanation: Estimated Time of Arrival
• Data Source: -
• Main Dashboard: Order Visibility

 

Extended Warranty

• Explanation: Extended Warranty is the product for extending free-guarantee period and customer can buy EW product with OMD Product (ADD-ON) or customer can buy EW product individually (Stand-alone). The types of Warranty: 1) Basic Warranty: applied on LGE Product basically 2) Extended Warranty: 2 types of EW (ADD-ON / Stand-alone), by additional payment, extend basic warranty period 3) Promotional Warranty: in specific cases, on specific products, for enhancing sales volume
• Data Source: -
• Main Dashboard: Extended Warranty Overview

 

FP (Dashboard: Sales_NPT)

• Explanation: This is the target sales set by each corporation
• Data Source: NPT
• Main Dashboard: NPT Performance Review

 

Frequency (Dashboard: Member)

• Explanation: The average number of purchases by logged-in users who have completed a purchase
• Data Source: Magento
• Main Dashboard: Member Overview
• Condition & Calculation: Is Login = Y / COUNTD(Order ID) / COUNTD(Customer ID)

 

Funnel

• Explanation: An analytical model that likens the customer journey from initial awareness to achieving a final goal (e.g., purchase) to the shape of a funnel
• Data Source: -
• Main Dashboard: -

 

G2N (Dashboard: Sales)

• Explanation: This is the abbreviation for GMV to NMV, which is the percentage of transactions that have completed delivery out of those that have successfully completed the payment process. Canceled or returned transactions do not count towards completion of delivery
• Data Source: -
• Main Dashboard: -
• Calculation: SUM(NMV) / SUM(GMV)

 

GA (Google Analytics) (System)

• Explanation: GA stands for "Google Analytics," which is a tool for analyzing traffic and user behavior on websites and apps. By using GA, you can collect and analyze various data such as the number of visitors, page views, user acquisition paths, and conversion rates. GA4 is the latest version of Google Analytics, using an event-based data model for more sophisticated analysis
• Data Source: -
• Main Dashboard: -

 

Glance view

• Explanation: The total count of times a customer views a Product Detail Page (PDP)
• Data Source: -
• Main Dashboard: Amazon VC Deep Dive

 

GMC Status

• Explanation: Disapproved: Issue that prevents your product from serving until the error is fixed / Unaffected: Issue that does not prevent your product from serving / Demoted: Issue does not prevent your product from serving, but may limit their visibility
• Data Source: -
• Main Dashboard: GMC Deep Dive

 

GMV to NMV(%) (Dashboard: Sales)

• Explanation: This is the conversion rate from GMV to NMV. In other words, it is the percentage of transactions that have completed delivery out of those that have successfully completed the payment process. Canceled or returned transactions do not count towards completion of delivery
• Data Source: Magento
• Main Dashboard: GMV to NMV Overview
• Calculation: SUM(NMV) / SUM(GMV)

 

GMV (Gross Merchandise Value) (Dashboard: Sales)

• Explanation: This is sales with the discount amount deducted from all transactions for which the payment process was successfully completed
• Data Source: Magento
• Main Dashboard: GMV & Traffic Overview
• Condition & Calculation: Status = preparing for delivery, picking for delivery, on delivery, holded, complete, RMA-GR, RMA-DR, return | Status = cancel and Payment = Y / SUM(Total amount usd tax excl discounted)

 

GP1 (Global Platform One) (System)

• Explanation: GP1 stands for Global Platform One. It aims to establish a global governance framework for improving the customer experience based on digital transformation (DX). The renewal from LG.com 5.0 to the GP1 platform began in the UK on June 6, 2023
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Gross Sales (Dashboard: Sales_NPT)

• Explanation: This is the total revenue generated from sales, meaning the total sales volume of OBS
• Data Source: NPT
• Main Dashboard: P&L Closing Overview

 

Growth competitiveness (Dashboard: Marketplace)

• Explanation: A metric measuring the ability to expand market share against competitors
• Data Source: -
• Main Dashboard: Market Competitiveness

 

GSC

• Explanation: The number of times users saw the free link to lg.com on Google search results pages
• Data Source: -
• Main Dashboard: SEO Traffic Deep Dive

 

H&A (Common: BU)

• Explanation: Home Appliance & Air Solution: Washing machine, Dryer, Vacuum cleaner, Refrigerator, Cooking appliance, Water purifier, Beer maker (homebrew), Plant cultivator, Home beauty device, Air conditioner, Air purifier, Built-in kitchen appliance, Compressor/motor parts for home appliances, etc
• Data Source: -
• Main Dashboard: -

 

H&A Acc (Common: Division)

• Explanation: H&A Accessary
• Data Source: -
• Main Dashboard: -

 

H1 Status (Dashboard: Marketing)

• Explanation: H1 outlines the primary focus of your content for search engines, playing a crucial role in a website's visibility. Pass/Error Criteria - Pass: H1 is present on the page / Error: H1 is missing on the page / Opportunity: More than one H1 is present on the page. To meet SEO best practices, each page should only have one H1
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

H1 Tags

• Explanation: The primary HTML heading tag denoting the most crucial title and informing the search engine of the page's topic
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

HE (Common: BU)

• Explanation: Home Entertainment. It includes OLED TV, QNED TV, Lifestyle Screen, Bluetooth Earphones (Tone Free), Wireless Speaker, Sound Bar, etc
• Data Source: -
• Main Dashboard: -

 

HE Acc (Common: Division)

• Explanation: HE Accessary
• Data Source: -
• Main Dashboard: -

 

ID (Common: BU)

• Explanation: Belonging MS(Media Entertainment). Including Monitor Signage, Commercial TV
• Data Source: -
• Main Dashboard: -

 

Impressed product

• Explanation: Items displayed on the user's screen via ads
• Data Source: -
• Main Dashboard: GMC Deep Dive

 

Impressions (Dashboard: Retail)

• Explanation: Flixmedia: The times the ad is seen / GSC: The number of times users see a non-paid link to lg.com on Google Search Result Page
• Data Source: -
• Main Dashboard: -

 

In Progress (Sales) (Dashboard: Sales)

• Explanation: This is the sales amount with the discount amount deducted from transactions in progress of delivery among transactions for which the payment process has been successfully completed
• Data Source: Magento
• Main Dashboard: GMV to NMV Overview
• Condition & Calculation: Status = preparing for delivery, picking for delivery, on delivery, holded / SUM(GMV)

 

In Progress(%) (Dashboard: Sales)

• Explanation: This is the percentage of sales in progress of delivery out of GMV
• Data Source: Magento
• Main Dashboard: GMV to NMV Overview
• Calculation: SUM(Sales in Progress) / SUM(GMV)

 

Incorrect (Dashboard: Marketing)

• Explanation: Campaigns identified as non-compliant with LGE's naming conventions
• Data Source: -
• Main Dashboard: GMP Naming Convention

 

Installation Flag (Dashboard: Fulfillment)

• Explanation: This is a flag that distinguishes products that can be installed
• Data Source: LMDS
• Main Dashboard: Order Visibility : Fulfillment

 

Interaction Rate(%) (Dashboard: Retail)

• Explanation: A metric that social media advertisers use to measure how often users interact with their ads
• Data Source: Flixmedia
• Main Dashboard: Not open
• Calculation: SUM(Interactions) / SUM(Impressions)

 

Interactions (Dashboard: Retail)

• Explanation: This is likes, comments, shares, etc. related to social media
• Data Source: Flixmedia
• Main Dashboard: Not open

 

INVENTORY RESERVED

• Explanation: INVENTORY RESERVED
• Data Source: LMDS/TMS
• Main Dashboard: Order Visibility

 

ISA (In Stock Availability) (Dashboard: Inventory)

• Explanation: This is the percentage of products x warehouse being sold through OBS to products x warehouse available for sale
• Data Source: Magento
• Main Dashboard: Inventory Overview
• Condition & Calculation: OBS flag = Y / COUNTD(STD_ORG_CODE + SKU with INVENTORY_QUANTITY > 0) / COUNTD(STD_ORG_CODE + SKU)

 

IT (Common: BU)

• Explanation: Belonging MS(Media Entertainment). Including Monitor, PC, Laptop, Projector, etc
• Data Source: -
• Main Dashboard: -

 

LCP

• Explanation: Largest Contentful Paint. The time from page start until the biggest item on the screen is fully visible, showing the user's perceived load speed
• Data Source: -
• Main Dashboard: Key Index Details

 

Leadtime (Days)

• Explanation: Delivery time (Days)
• Data Source: -
• Main Dashboard: Fulfillment Performance Review
• Calculation: (Pick Release - Actual Arrival)

 

LG.com SKU (Dashboard: Inventory)

• Explanation: This is the number of products available for sale on LG.COM
• Data Source: Magento
• Main Dashboard: Inventory Overview
• Condition & Calculation: MKT flag = Y & exclusion flag = N & INV_TYPE IN ('NONUS','US_SKU') / COUNTD(Store name + SKU)

 

LG.com Visit (Dashboard: GA)

• Explanation: The number of traffic sessions or unique visitors on the LG.com website
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Limited Offer

• Explanation: A time- or quantity-restricted promotion provided only for a specific period or limited stock
• Data Source: -
• Main Dashboard: OBS Factbook

 

LINE NO

• Explanation: LINE NUMBER
• Data Source: GERP
• Main Dashboard: Order Visibility

 

LMDS(Last Mile Delivery Service) (Dashboard: Fulfillment)

• Explanation: This is a system where you can see the delivery process after a customer's order
• Data Source: LMDS
• Main Dashboard: Order Visibility : Fulfillment

 

LMSP CODE

• Explanation: LMSP CODE
• Data Source: LMDS/TMS
• Main Dashboard: Order Visibility

 

LMSP Name (Dashboard: Fulfillment)

• Explanation: This is the name of the outsourcing service provider that manages the steps after an order to be delivered to LG customers - large-scale warehouses, inventory shipments, inventory storage and tracking. This can be found in Last Mile Delivery Service. Data source is LMDS (=3PL)
• Data Source: LMDS
• Main Dashboard: Not used

 

Local Campaign (Dashboard: Marketing)

• Explanation: A campaign conducted to promote and sell a particular product or service within a particular city, region, or country
• Data Source: GA
• Main Dashboard: eCRM Mkt. Performance

 

Login Visitor (Dashboard: Member)

• Explanation: This is the number of visitors who logged into the LG.com website during a specific period
• Data Source: GA
• Main Dashboard: Member Overview
• Condition & Calculation: Is Login = Y / Unique Visitor

 

Loyalty Program

• Explanation: A membership scheme offering benefits to repeat customers to encourage repurchases, such as Exclusive Offers or VIP tiers
• Data Source: -
• Main Dashboard: OBS Factbook

 

LTV, Air Care, Dishwasher, PC, D/W, Projector, Air, Audio, Home Beauty, VAC, Water Care, Tones (Common: Division)

• Explanation: Other division items
• Data Source: -
• Main Dashboard: -

 

M.Progress

• Explanation: MTD compared to the monthly total target
• Data Source: -
• Main Dashboard: D2C KPI DASHBOARD
• Calculation: NPT(MTD) / Total Target

 

Market Sales, Qty

• Explanation: The total monetary revenue generated from the sales of a specific product, The total volume or quantity of a specific product sold
• Data Source: -
• Main Dashboard: Key Index Dashboard

 

Market Share

• Explanation: The percentage of total sales or revenue in a specific market that is captured by a company or brand
• Data Source: -
• Main Dashboard: Market Share Overview

 

Max Price($)

• Explanation: Highest Price on Platform in Period
• Data Source: -
• Main Dashboard: Price Positioning Deep Dive

 

Max Seller

• Explanation: The highest-priced Seller on the Source
• Data Source: -
• Main Dashboard: Price Positioning Deep Dive

 

Mega Campaign (Dashboard: Marketing)

• Explanation: This is a campaign that uses various media and strategies
• Data Source: GA
• Main Dashboard: eCRM Mkt. Performance

 

Mention (Dashboard: Marketplace)

• Explanation: The total count of brand or product references across online channels
• Data Source: -
• Main Dashboard: Market Competitiveness

 

META (System)

• Explanation: META is a company that includes social media platforms such as Facebook, Instagram, and WhatsApp. META serves as one of the important channels for digital marketing and advertising, providing businesses with a platform to communicate with customers and promote their products or services
• Data Source: -
• Main Dashboard: -

 

Meta Description Status (Dashboard: Marketing)

• Explanation: Meta descriptions serve as CTAs to boost your page's CTR, each page should have a non-empty meta description tag as a basic requirement. Pass/Error Criteria - Pass: Meta Description is present, with a minimum length of 20 characters / Error: Meta Description is missing or too short
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

Meta Descriptions

• Explanation: A brief summary description of the page visible on the search engine results page (SERP)
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

MGT (Common: Division)

• Explanation: Margin Target
• Data Source: -
• Main Dashboard: Accessories & Parts Deep Dive

 

Microsite (etc.)

• Explanation: This is a small-scale website separate from the main website, often used for marketing purposes to provide targeted content for specific campaigns or events
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Mileage

• Explanation: Reward points or benefits accumulated based on the purchase amount in OBS
• Data Source: -
• Main Dashboard: OBS Factbook

 

Min Price($)

• Explanation: Lowest Price on Platform in Period
• Data Source: -
• Main Dashboard: Price Positioning Deep Dive

 

Min Seller

• Explanation: The lowest-priced Seller on the Source
• Data Source: -
• Main Dashboard: Price Positioning Deep Dive

 

MNT (Common: Division)

• Explanation: Monitor
• Data Source: -
• Main Dashboard: -

 

MNT Signage (Common: Division)

• Explanation: Monitor for digital information outdoor display advertising
• Data Source: -
• Main Dashboard: -

 

Model Code (Common)

• Explanation: The code of model
• Data Source: -
• Main Dashboard: -

 

MP(%) (Marginal Profit) (Dashboard: Sales_NPT)

• Explanation: This refers to the additional profit earned by producing and selling one more unit of the product, and is the ratio of marginal profit to OBS net sales
• Data Source: NPT
• Main Dashboard: P&L Closing Overview
• Calculation: MP / Net Sales

 

MTD (Month-To-Date) (Common: Date)

• Explanation: This refers to the monthly cumulative value. This indicator is used when you want to aggregate data from the beginning of the month to a selected date and compare it with the same period last year or the previous month
• Data Source: -
• Main Dashboard: -
• Condition: First day of each month

 

MTD vs Target

• Explanation: MTD compared to target value during set period
• Data Source: -
• Main Dashboard: D2C KPI DASHBOARD
• Calculation: NPT(MTD) / Target(MTD)

 

Multiple Product (Dashboard: Sales)

• Explanation: Multiple Product means the purchase of more than two different products at the same order case
• Data Source: Magento
• Main Dashboard: Multiple Purchase Review

 

Multi-shop

• Explanation: Offering the special price per various customer type (e.g. Student)
• Data Source: -
• Main Dashboard: -

 

Net Price (Dashboard: Sales_NPT)

• Explanation: This is the price after deducting discounts, allowances, and rebate amounts from the original cost of the product
• Data Source: NPT
• Main Dashboard: P&L Closing Overview

 

Net Sales (Dashboard: Sales_NPT)

• Explanation: This is actual sales of OBS, which is the revenue generated from OBS after deducting returns, discounts, allowances, and sales-related costs
• Data Source: NPT
• Main Dashboard: NPT Performance Review
• Calculation: Gross Sales - Sales Deduction + Part/Other Sales + Sales Allowance for Return

 

New (Dashboard: Marketing)

• Explanation: Recently created campaigns yet to be validated for naming compliance
• Data Source: -
• Main Dashboard: GMP Naming Convention

 

New Joined Member (Dashboard: Member)

• Explanation: This is the number of new members registered on the LG.com website during a specific period
• Data Source: Member
• Main Dashboard: Member Overview
• Condition & Calculation: Creation Date Lgcom is between the selected dates / COUNTD(Entity ID)

 

New Plantopia(NPT) (System)

• Explanation: The New Plantopia System is a cost accounting management system that manages operational metrics such as finance, production, sales, and purchasing for LG Electronics, also known as NPT. This system allows for the extraction of data such as Weekly Progress, Net Sales, and COI
• Data Source: -
• Main Dashboard: -

 

Next (Dashboard: GA)

• Explanation: This is called CHECKOUT2, and is the step where shipping information is entered during the payment stage
• Data Source: GA
• Main Dashboard: Traffic Funnel Deep Dive

 

NMV - units (Dashboard: Sales)

• Explanation: The number of products sold for a transaction after deducting the discount amount for transactions in which the payment process was successfully completed and shipping was completed
• Data Source: Magento
• Main Dashboard: GMV & Traffic Overview
• Calculation: SUM(Units)

 

NMV (Net Merchandise Value) (Dashboard: Sales)

• Explanation: This is sales with discount amount deducted from transactions for which delivery has been completed among transactions that have successfully completed the payment process. Sales from canceled or returned transactions are not included
• Data Source: Magento
• Main Dashboard: GMV & Traffic Overview
• Condition & Calculation: Status = complete / SUM(Total amount usd tax excl discounted)

 

Non-Paid Channel (Dashboard: GA_Channel)

• Explanation: This is any marketing tactic where you don't pay to promote. Including Organic_Search, Organic_Social, Organic_SMS, Direct, Referral, Organic_Email
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

NPT (New Plantopia Data) (Dashboard: Sales)

• Explanation: This is sales based on profit and loss
• Data Source: NPT
• Main Dashboard: NPT Performance Review

 

OBS Penetration Rate(OBS%) (Dashboard: Sales_NPT)

• Explanation: This is the percentage of net sales from OBS among LG Electronics' total sales
• Data Source: NPT
• Main Dashboard: P&L Closing Overview

 

OBS Sales For GFK (Dashboard: Marketplace)

• Explanation: This refers to the OBS performance obtained from a market research institute called GFK
• Data Source: GFK
• Main Dashboard: Not exist

 

OBS SKU (Dashboard: Inventory)

• Explanation: This is the number of products being sold through OBS
• Data Source: Magento
• Main Dashboard: Inventory Overview
• Condition & Calculation: OBS_FLAG IN ('ACTIVE', 'SOLD_OUT', 'Y') AND EXCLUSION_FLAG = 'N' AND INV_TYPE IN ('NONUS','US_SKU') / COUNTD(Store name + SKU)

 

OBS SKU with Inventory (Dashboard: Inventory)

• Explanation: This is the total number of OBS SKUs in operation by a corporation multiplied by the number of warehouses in operation for OBS by the corporation. If Corporation A has 50 total OBS SKUs in operation and two warehouses for OBS, Corporation A's OBS SKU with Inventory is 50 X 2 = 100
• Data Source: Magento
• Main Dashboard: SKU & ISA Snapshot

 

OBS(Online Business System) (System)

• Explanation: OBS is a system that includes various functions such as order flow, price and inventory management, product management, coupons, and dynamic pricing, and is used as a concept that includes strategies and processes related to D2C (Direct to Consumer) business growth. OBS consists of OMS and CMS. OMS (Order Management System) refers to processing customer orders, and CMS (Content Management System) refers to controlling the UI/UX of LG.com. Global LG.com's OMS is built on an e-Commerce Solution called 'Magento'
• Data Source: -
• Main Dashboard: -

 

OMD(Order management Domestics) (Common)

• Explanation: This refers to the main product excluding accessories or consumables
• Data Source: Magento
• Main Dashboard: SKU & ISA Deep Dive

 

OMV

• Explanation: Consumables and accessories offered for sale
• Data Source: -
• Main Dashboard: OBS Factbook

 

OMV(Order Management serVices) (Common)

• Explanation: This refers to accessories or consumables. For example, consumables such as air conditioner filters are referred to as OMV
• Data Source: Magento
• Main Dashboard: SKU & ISA Deep Dive

 

OneData (System)

• Explanation: It refers to a service that allows you to view the data held by the D2C group in one place: CDP, revenue, traffic, shipping, marketing performance, KPI
• Data Source: -
• Main Dashboard: -

 

Onetrust (System)

• Explanation: OneTrust is a privacy management software that helps organizations comply with privacy laws and regulations. When a customer visits the website, OneTrust triggers a pop-up asking for cookie consent. Based on the customer's response, OneTrust informs Google Tag Manager of the availability of cookie usage. If customers visiting OBS do not consent to OneTrust, data collection will be restricted
• Data Source: GA
• Main Dashboard: -

 

Open Graph

• Explanation: A meta tag protocol controlling the image, title, and description displayed when the page is shared on social media
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

Open Graph Status (Dashboard: Marketing)

• Explanation: Open Graph tags play a crucial role in enhancing content sharing on social media platforms, ensuring that shared links appear rich, informative, and visually appealing. Each page should have properly configured Open Graph tags as part of its metadata. Pass/Error Criteria - Pass: All three elements (Open Graph Title, Description, and Image) are present and match the metadata / Error: One or more elements are missing, misaligned, or incomplete / Opportunity: An Open Graph title or description is present on the page, but it differs from the meta title or meta description
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

Optimization (etc.)

• Explanation: optimization are used to make the website more searchable in search engines
• Data Source: GA
• Main Dashboard: -

 

Opt-in (Dashboard: Member)

• Explanation: Status of explicit consent for receiving marketing communications
• Data Source: -
• Main Dashboard: Member Overview

 

Opt-in E-mail (Dashboard: Member)

• Explanation: This is number of visitors who agreed to receive emails
• Data Source: GA / Member data
• Main Dashboard: Member Overview
• Condition & Calculation: Svc Code = svc611 / COUNTD(Entity ID)

 

Order Return (Dashboard: Sales)

• Explanation: This refers to the order date on which the return was processed
• Data Source: Magento
• Main Dashboard: Cancel & Return Breakdown

 

Orders (GMV or NMV) (Dashboard: Sales)

• Explanation: This is order quantity for all transactions that have successfully completed payment
• Data Source: Magento
• Main Dashboard: GMV & Traffic Overview
• Condition & Calculation: GMV or NMV / COUNTD(Order ID)

 

Orders Used Coupon (Dashboard: Coupon)

• Explanation: This is the number of orders that include a coupon among all orders (Except for the welcome coupon)
• Data Source: Magento
• Main Dashboard: Coupon Usage

 

Org Code (Dashboard: Fulfillment)

• Explanation: Code identifying the organizational unit
• Data Source: -
• Main Dashboard: Inventory Overview

 

Organic_Email (Dashboard: GA_Channel)

• Explanation: This does not use paid advertisements or promotions, but is used to provide new product or service information, event news, discounts, etc. to existing customers
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Organic_Search (Dashboard: GA_Channel)

• Explanation: This means that the user directly enters the search word in the search engine to obtain the search result
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Organic_Shopping (Dashboard: GA_Channel)

• Explanation: This is a channel where users reach your site/app through a link rather than an ad on a shopping site like Amazon or eBay
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Organic_SMS (Dashboard: GA_Channel)

• Explanation: This does not use paid advertising or promotions, but rather uses personalized messages to elicit responses to consumer behavior or to provide information such as event notifications, transaction checks, service updates, etc
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Organic_Social (Dashboard: GA_Channel)

• Explanation: This means organically posting content without advertising on social media platforms, resulting in natural social media activities
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

OSM (Online Store Management) (Dashboard: Retail)

• Explanation: Monitoring of digital shelf items of our company and competitors in major global distribution channels (banners, reviews, ratings, prices, search rankings, inventory, etc.)
• Data Source: OSM
• Main Dashboard: OSM Key Indicator Deep Dive

 

OTA (%)

• Explanation: On Time Arrive Ratio
• Data Source: -
• Main Dashboard: Fulfillment Performance Review
• Calculation: (On time Delivery Count / All Delivery Count)

 

Out of Stock Rate

• Explanation: Proportion of Daily Product Shortage (7 Days = 100%)
• Data Source: -
• Main Dashboard: EU OSM Monitoring Report

 

P&L (Dashboard: Sales_NPT)

• Explanation: P&L is an abbreviation for Profit & Loss, which is the LG Electronics consolidated closing performance and the company-wide performance. We mainly look at Net Sales and Operating Income
• Data Source: NPT
• Main Dashboard: P&L Closing Overview

 

Package Deal (Dashboard: Sales)

• Explanation: Package Deal represents a strategy where customers receive price reductions when assembling a package of selected products. The selling of multiple products or services bundled together as a single, integrated offering
• Data Source: Magento
• Main Dashboard: Package-deal Review / OBS Factbook

 

Page Title (Dashboard: Marketing)

• Explanation: Page titles play a vital SEO role and each page should have a non-empty title tag as a basic requirement. Pass/Error Criteria - Pass: Page Title is present, with a minimum length of 10 characters / Error: Page Title is missing or too short
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

Page Title

• Explanation: The page's title displayed in search engine results and the browser tab
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

Paid Channel (Dashboard: GA_Channel)

• Explanation: This is the purchase of ad placement on a channel or site to do advertising activities for your brand and reach your target audiences. Including Paid_Search, Paid_Social, Affiliates, Paid_SMS, Paid_Shopping, PMAX, Display, Paid_Email, Paid_Other, Criteo
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Paid_Email (Dashboard: GA_Channel)

• Explanation: This is a marketing strategy that publishes advertisements through email marketing and rewards users who receive them
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Paid_Other (Dashboard: GA_Channel)

• Explanation: This is not specific types of pay advertisements, not specific types of pay advertisements, including other types of pay advertisements
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Paid_Search (Dashboard: GA_Channel)

• Explanation: This is a type of paid advertisement that pays for an advertisement platform to display advertisements on the search engine results page (SERP). It is mainly used by search engines such as Google and Yahoo
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Paid_Shopping (Dashboard: GA_Channel)

• Explanation: This aims to expose product advertisements and sell products on the platform, such as Google Shopping, and Amazon advertising
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Paid_SMS (Dashboard: GA_Channel)

• Explanation: This is a marketing strategy that sends advertisements through SMS and rewards users who receive SMS
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Paid_Social (Dashboard: GA_Channel)

• Explanation: This refers to the form of advertisement paid by advertisers to run advertisements on social media platforms. Typical social media platforms include Facebook, Instagram Twitter, and LinkedIn
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

PBP (Product Buy now Page) (Dashboard: GA)

• Explanation: This refers to the product buy now page that lands when you click the "Buy now" button on the product detail page (PDP). Only GP1 countries can count visitors (sessions, unique visitors) to this page
• Data Source: GA
• Main Dashboard: GP1 Traffic Deep Dive

 

PDP (Product Detail Page) (Dashboard: GA)

• Explanation: This refers to the product detail page, and the number of visitors (session, unique visitor) to this page can be calculated
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

PDP Rating

• Explanation: Product Rating per SKU in Category
• Data Source: -
• Main Dashboard: EU OSM Monitoring Report

 

PDPPBP (Dashboard: GA)

• Explanation: PDPPBP means that visited either PDP or PBP, and the number of visitors (session, unique visitor) to this page can be calculated. PDPPBP is less than or equal to the sum of PDP and PBP
• Data Source: -
• Main Dashboard: -

 

PLP (Product List Page) (Dashboard: GA)

• Explanation: This refers to the product list page, and the number of visitors (session, unique visitor) to this page can be calculated
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

PMAX (Dashboard: GA_Channel)

• Explanation: This is a type of Google ad campaign that focuses on maximizing the performance of a particular product or service. It is a paid advertisement that can be displayed on various display and search networks
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Positive Review (Dashboard: Marketplace)

• Explanation: The count of positive feedback instances left by customers
• Data Source: -
• Main Dashboard: Market Competitiveness

 

Positive/Negative Mention (Dashboard: Marketplace)

• Explanation: The count of mentions categorized by positive or negative sentiment
• Data Source: -
• Main Dashboard: Market Competitiveness

 

Positive/Negative Mentions (Dashboard: Retail)

• Explanation: This is number of mentions having a AI identified positive/negative sentiment
• Data Source: Sprinklr
• Main Dashboard: Not used

 

Pre-Order

• Explanation: A feature allowing advance purchase or reservation of a product before its official release
• Data Source: -
• Main Dashboard: OBS Factbook

 

Proceed Payment (Dashboard: GA)

• Explanation: This is called CHECKOUT3, and is the step where payment method is entered during the payment stage
• Data Source: GA
• Main Dashboard: Traffic Funnel Deep Dive

 

Proceed to Checkout (Dashboard: GA)

• Explanation: This is called CHECKOUT1, and is the step where customer information is entered during the payment stage
• Data Source: GA
• Main Dashboard: Traffic Funnel Deep Dive

 

Product In Stock

• Explanation: Goods physically in stock and ready for immediate sale
• Data Source: -
• Main Dashboard: GMC Deep Dive

 

Product of Level 3 (Common)

• Explanation: The third most detailed level of the 4-level Product Level in the LG product information system, which is divided by Division
• Data Source: -
• Main Dashboard: -

 

PSI

• Explanation: Production-Sales-Inventory, a data analysis framework used to establish future production and supply chain plans based on sales (demand) and inventory status
• Data Source: -
• Main Dashboard: Retail OBS Overview

 

PTO (Pick-To-Order) (Dashboard: Sales)

• Explanation: PTO is a model created by selecting flagship products, and it is a set product that combines two or more models
• Data Source: Magento
• Main Dashboard: Multiple Purchase Review

 

Purchase (Dashboard: GA)

• Explanation: Total number of events named purchase
• Data Source: GA
• Main Dashboard: SEO Traffic Deep Dive
• Calculation: Purchase (%) = Purchase / Checkout (%)

 

QTD (Quarter-To-Date) (Common: Date)

• Explanation: This refers to the cumulative quarterly value. This indicator is used when you want to aggregate data from the beginning of the quarter to a selected date and compare it with the same period last year
• Data Source: -
• Main Dashboard: -
• Condition: From the first day of the quarter to the base date

 

Qty GR(%) (Dashboard: Marketplace)

• Explanation: Quantity Growth Rate, This is the percentage of quantity growth by specified period
• Data Source: Amazon
• Main Dashboard: Amazon VC Deep Dive
• Calculation: Past Orders (specified period) / Current Orders -1

 

RAC (Common: Division)

• Explanation: Air Conditioner
• Data Source: -
• Main Dashboard: -

 

RAC BD (Common: Division)

• Explanation: Air Conditioner
• Data Source: -
• Main Dashboard: -

 

REF (Common: Division)

• Explanation: Refrigerator
• Data Source: -
• Main Dashboard: -

 

Referral (Dashboard: GA_Channel)

• Explanation: This refers to a marketing strategy in which consumers recommend products or services to attract new customers
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Report Count (Send) (Dashboard: Marketing)

• Explanation: Emails attempted to be sent from the eCRM platform
• Data Source: -
• Main Dashboard: eCRM Mkt. Performance

 

Reschedule PIC (Dashboard: Fulfillment)

• Explanation: This is the reason for changing the delivery date
• Data Source: LMDS (US)
• Main Dashboard: US LMDS
• Condition: RXO, LG, Customer, Weather

 

Reserved Stock (Dashboard: Fulfillment)

• Explanation: The portion of Available SKUs reserved or allocated specifically for OBS sales fulfillment
• Data Source: GERP
• Main Dashboard: Stock Check Report

 

Return (Sales) (Dashboard: Sales)

• Explanation: This is the sales amount for which the discount amount for returned transactions has been deducted among transactions for which the payment process has been successfully completed
• Data Source: Magento
• Main Dashboard: GMV to NMV Overview
• Condition & Calculation: Status = RMA-GR, RMA-DR, return / SUM(GMV)

 

Return(%) (Dashboard: Sales)

• Explanation: This is the percentage of sales that have been returned out of GMV
• Data Source: Magento
• Main Dashboard: GMV to NMV Overview
• Calculation: SUM(Returned Sales) / SUM(GMV)

 

Revenue (Dashboard: GA)

• Explanation: This is the total purchase amount measured in GA. However, since GA only shows data (sales) from users who have consented to cookies, you should check GMV or NMV to confirm the total sales
• Data Source: GA
• Main Dashboard: SEO Traffic Deep Dive

 

Review Counts

• Explanation: Total Number of Review of all listed Products
• Data Source: -
• Main Dashboard: EU OSM Monitoring Report

 

Reviews (Dashboard: Retail)

• Explanation: Online opinions from current and potential customers who have used LG product or service
• Data Source: Sprinklr
• Main Dashboard: Not used

 

ROAS (Return On Ad Spend) (Dashboard: Marketing)

• Explanation: This measures the revenue generated for every unit of currency spent on advertising
• Data Source: GSC
• Main Dashboard: Campaign Ads Performance
• Calculation: ROAS = (Revenue from ads) / (Ad cost) *100

 

ROI (Return on investment) (Dashboard: Marketing)

• Explanation: This is a financial metric used it evaluate the profitability or efficiency of an investment. ROI = (Net Income) / (Total Cost) *100
• Data Source: GSC
• Main Dashboard: Campaign Ads Performance
• Calculation: ROI = (Net Income) / (Total Cost) *100

 

SA360 (System)

• Explanation: SA360 stands for Search Ads 360, which is a platform for managing search advertising campaigns. It helps efficiently operate and optimize ads across various search engines
• Data Source: -
• Main Dashboard: -

 

SAC (Common: Division)

• Explanation: System Air Conditioner
• Data Source: -
• Main Dashboard: -

 

Salable SKU (Dashboard: Fulfillment)

• Explanation: The quantity of stock within the total inventory that is salable through OBS channels
• Data Source: GERP
• Main Dashboard: Inventory Overview
• Condition: OBS SKU and Salable Units > 0

 

Salable SKU with Inventory (Dashboard: Inventory)

• Explanation: This is the number of Salable SKUs each warehouse has. If Corporation A has 50 total OBS SKUs in operation and two warehouses for OBS, and there are 20 in Warehouse 1 and 30 in Warehouse 2, the total Salable SKU with Warehouse for Corporation A is 50
• Data Source: Magento
• Main Dashboard: SKU & ISA Snapshot
• Calculation: COUNTD(Salable SKU with Inventory > 0) / COUNTD(OBS SKU with Inventory)

 

Salable Stock (Dashboard: Inventory)

• Explanation: This refers to the quantity of product available for sale
• Data Source: Magento
• Main Dashboard: Inventory Overview
• Condition & Calculation: OBS flag = Y / SUM(INVENTORY_QUANTITY)

 

Sales (USD/EUR) (Dashboard: Marketplace)

• Explanation: The total value of goods sold through a Amazon platform within a given time period, typically measured in USD and EUR
• Data Source: Amazon
• Main Dashboard: Amazon VC Deep Dive

 

Sales GR(%) (Dashboard: Marketplace)

• Explanation: Sales Growth Rate, This is the percentage of sales growth by some period
• Data Source: Amazon
• Main Dashboard: Amazon VC Deep Dive
• Calculation: Past Sales (specified period) / Current Sales -1

 

Sales Qty (Dashboard: Sales)

• Explanation: The number of units or products sold within a specified period
• Data Source: -
• Main Dashboard: -

 

Sales Qty (NPT) (Dashboard: Sales_NPT)

• Explanation: This is the product sales quantity based on NPT
• Data Source: NPT
• Main Dashboard: P&L Closing Overview

 

Sales Units

• Explanation: Sales in term of number of units sold
• Data Source: -
• Main Dashboard: Market Share Overview

 

Sales USD

• Explanation: Sales in USD
• Data Source: -
• Main Dashboard: Market Share Overview

 

Schema Status (Dashboard: Marketing)

• Explanation: Structured Data. This dashboard displays URLs with structured data issues, helping you identify and resolve gaps in your metadata. Pass/Error/Opportunity Criteria - Pass: At least one Schema Markup is present and matching its relevant page type / Error: Schema Markup is non-existent / Opportunity: Schema Markup is present but does not match its relevant page type
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

Search Rank

• Explanation: Number of Total Exposed Products within Top 20 Rank of Search Result Page
• Data Source: -
• Main Dashboard: EU OSM Monitoring Report

 

Search Terms (Keywords) (Dashboard: GA)

• Explanation: In SEO, this refers to keywords searched upon entering a site. In the Search Keywords dashboard, this refers to internal search terms on a lg.com
• Data Source: -
• Main Dashboard: -

 

Select Shop

• Explanation: A curated section or storefront featuring a hand-picked selection of products based on a specific theme
• Data Source: -
• Main Dashboard: OBS Factbook

 

Seller

• Explanation: Online merchants whose product prices were collected, possibly multiple sellers per platform (e.g., Amazon)
• Data Source: -
• Main Dashboard: Price Positioning Deep Dive

 

SEM (Dashboard: GA_Channel)

• Explanation: Search Engine Marketing (SEM), a digital strategy focused on increasing website visibility on Search Engine Results Pages (SERP) primarily through paid advertising
• Data Source: -
• Main Dashboard: Campaign Performance

 

Sentiment (Dashboard: Marketplace)

• Explanation: The directional tone (positive, negative, neutral, etc.) embedded in customer feedback
• Data Source: -
• Main Dashboard: Market Competitiveness

 

SEO (System)

• Explanation: SEO is an abbreviation for Search Engine Optimization, which aims to improve the search engine ranking of a website to attract more traffic. Various techniques such as keyword research, backlink building, and meta tag optimization are used
• Data Source: GA
• Main Dashboard: SEO Traffic Deep Dive

 

SERP

• Explanation: Google Search Engine Results Pages
• Data Source: -
• Main Dashboard: OSM Key Indicator Deep Dive - Visibility Tab

 

SERVICE TYPE

• Explanation: SERVICE TYPE
• Data Source: LMDS/TMS
• Main Dashboard: Order Visibility

 

Session (Dashboard: GA)

• Explanation: This is a user identification code given when a user accesses LG.com. The identification code expires after 30 minutes of inactivity on LG.com. That is, when a user accesses LG.com and is inactive for more than 30 minutes, a new session code is given when the user logs in again
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Ship Confirm Delays (Dashboard: Fulfillment)

• Explanation: Ship Confirm Delay shows orders that take more than the time written on the threshold from Pick Released to Ship Confirm
• Data Source: GERP, LMDS, US TMS
• Main Dashboard: Order Visibility : Fulfillment

 

Sign up (Dashboard: Member)

• Explanation: The process of registering for service membership
• Data Source: -
• Main Dashboard: Member Overview

 

SKU (Common)

• Explanation: SKU stands for Stock Keeping Unit, which is the number of products available for sale stock keeping unit. As the name suggests, it's a number (usually eight alphanumeric digits) that retailers assign to products to track inventory levels internally
• Data Source: -
• Main Dashboard: -

 

SKU Coverage(%) (Dashboard: Inventory)

• Explanation: This is the percentage of products being sold through OBS among products available for sale on LG.COM
• Data Source: Magento
• Main Dashboard: Inventory Overview
• Calculation: COUNTD(OBS SKU) / COUNTD(LG.com SKU)

 

Social Channel Mentions (Dashboard: Retail)

• Explanation: This is a measure of how many times your brand name has been mentioned on social media channels by calculating the volume of mentions of your brand on social media channels over a given period
• Data Source: Sprinklr
• Main Dashboard: Not used

 

Social engagement (Dashboard: Retail)

• Explanation: "Social engagement" refers to the degree to which users interact with content on social media platforms. This concept primarily includes activities such as likes, comments, shares, and follows
• Data Source: -
• Main Dashboard: -

 

Source

• Explanation: List of online platforms where product prices were collected for the selected subsidiary
• Data Source: -
• Main Dashboard: Price Positioning Deep Dive

 

Sprinklr (System)

• Explanation: Sprinklr is an internet monitoring solution. This solution helps businesses monitor and analyze consumer opinions and feedback on social media and other online platforms. By using SPRINKLR, companies can track consumer reviews, comments, tweets, and more in real-time, gaining insights into their products and services
• Data Source: -
• Main Dashboard: -

 

Status Code (Dashboard: Marketing)

• Explanation: HTTP Status Codes. While it's common to encounter 3xx redirects, spotting 4xx and 5xx URLs points to problems like broken links, missing pages, or server glitches. It's a good practice to aim for fewer of these URLs to ensure a smoother website experience
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

Std Org Code (Dashboard: Fulfillment)

• Explanation: Standardized code for organizational grouping
• Data Source: -
• Main Dashboard: Inventory Overview

 

Store ID (Common)

• Explanation: The code of Subsidiary
• Data Source: -
• Main Dashboard: -

 

Store Name (Common)

• Explanation: The name of Subsidiary
• Data Source: -
• Main Dashboard: -

 

Strategic (on/off)

• Explanation: This filter is used to specify (on) or not (off) a strategic subsidiary
• Data Source: Magento
• Main Dashboard: GMV & Traffic Overview

 

Stretch Goal (Common: FP)

• Explanation: A stretch goal is an ambitious target set beyond the standard objectives, often used to push teams to achieve more than the usual expectations. It is typically more challenging to achieve than regular goals and is designed to encourage higher performance and innovation
• Data Source: -
• Main Dashboard: Monthly Sales Review

 

Structured Data

• Explanation: Markup providing information in a specific format to help search engines easily comprehend the content
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

SUBSIDIARY

• Explanation: SUBSIDIARY
• Data Source: GERP
• Main Dashboard: Order Visibility

 

Support - Announcement

• Explanation: A page type category for pages within the support section providing announcements, alerts, and important information
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

Support - GNB Support

• Explanation: A page type category covering all customer support pages accessible via the Global Navigation Bar (GNB)
• Data Source: -
• Main Dashboard: SEO Technical Deep Dive

 

SVC

• Explanation: This refers to service sales cases such as A/S
• Data Source: -
• Main Dashboard: -

 

TCA

• Explanation: Traffic + CVR + AOV
• Data Source: -
• Main Dashboard: NPT Performance Progress

 

TIMEONSITE (Dashboard: Marketing)

• Explanation: This is the total length of time your website was in focus or your app was in the foreground across all sessions
• Data Source: GA
• Main Dashboard: Campaign Performance

 

Timezone

• Explanation: It means standard time. Magento: UTC / GA: Each country's timezone (GMT + @) / Sprinklr: GMT
• Data Source: -
• Main Dashboard: -

 

TO CITY

• Explanation: Delivery Area City
• Data Source: LMDS/TMS
• Main Dashboard: Order Visibility

 

TO STATE

• Explanation: Delivery Region State
• Data Source: LMDS/TMS
• Main Dashboard: Order Visibility

 

TO STTS CITY

• Explanation: TO STTS CITY
• Data Source: LMDS/TMS
• Main Dashboard: Order Visibility

 

Total Bounces (Dashboard: Marketing)

• Explanation: The total number of emails returned due to delivery failure
• Data Source: -
• Main Dashboard: eCRM Mkt. Performance

 

Total Clicks (Dashboard: Marketing)

• Explanation: The total count of link clicks within the email body
• Data Source: -
• Main Dashboard: eCRM Mkt. Performance

 

Total Listing

• Explanation: Number of Total Listed Products on the Retailer site
• Data Source: -
• Main Dashboard: EU OSM Monitoring Report

 

Total Members (Dashboard: Member)

• Explanation: This is the number of members registered on the LG.com website
• Data Source: Member
• Main Dashboard: Member Overview

 

Total Online Mentions (Dashboard: Retail)

• Explanation: This means that a brand or company is mentioned online in various forms of social media, such as website blogs, news, videos or other content
• Data Source: Sprinklr
• Main Dashboard: Not used

 

Total Opens (Dashboard: Marketing)

• Explanation: The total count of times the email was opened by all recipients
• Data Source: -
• Main Dashboard: eCRM Mkt. Performance

 

Transactions (Dashboard: GA)

• Explanation: This is the number of traffic sessions or unique visitors Traffic Session arrived on the Purchase Completion Page. *Even if a customer made a purchase, the item will not be counted unless the purchase completion page is checked
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Transportation Delays (Dashboard: Fulfillment)

• Explanation: Transportation Delay with Appointment shows orders that delivered later than the Appointment Date. To establish a criteria of Transportation Delay without Appointment, it finds the distribution(avg, std) of time from Ship Confirm to Delivery Complete for orders that have been delivered in the last 90 days by division and service type
• Data Source: GERP, LMDS, US TMS
• Main Dashboard: Order Visibility : Fulfillment

 

TTFB

• Explanation: Time To First Byte. The time from a user's click until the browser receives the very first piece of data from the server, showing server responsiveness
• Data Source: -
• Main Dashboard: Key Index Details

 

Ultimate Goal (Common: FP)

• Explanation: The long-term vision or final destination that an organization aspires to reach. It represents the most ideal and comprehensive objective for the future
• Data Source: -
• Main Dashboard: Monthly Sales Review

 

Unique Clicks (Dashboard: Marketing)

• Explanation: The number of unique recipients who clicked on an email link
• Data Source: -
• Main Dashboard: eCRM Mkt. Performance

 

Unique Opens (Dashboard: Marketing)

• Explanation: The number of unique recipients who opened the email
• Data Source: -
• Main Dashboard: eCRM Mkt. Performance

 

Unique Visitor (Dashboard: GA)

• Explanation: This is the number of non-duplicated visitors to LG.com website over the course of a specified time period
• Data Source: GA
• Main Dashboard: OBS Traffic Overview

 

Units (GMV or NMV) (Dashboard: Sales)

• Explanation: This is product sales quantity for all transactions where the payment process was successfully completed
• Data Source: Magento
• Main Dashboard: GMV & Traffic Overview
• Condition & Calculation: GMV or NMV / SUM(Units)

 

Unsubscribe (Dashboard: Marketing)

• Explanation: Recipients who explicitly opted out of receiving future marketing emails
• Data Source: -
• Main Dashboard: eCRM Mkt. Performance

 

UPT (Units per Transaction) (Dashboard: Sales)

• Explanation: This is a metric that retail stores use to determine the average number of items a customer purchases for each customer transaction
• Data Source: Magento
• Main Dashboard: Package-deal Review
• Calculation: SUM(Units) / COUNTD(Order ID)

 

VCC (Common: Division)

• Explanation: Vacuum Cleaner / Cordless Stick Vacuum
• Data Source: -
• Main Dashboard: -

 

VCC BD (Common: Division)

• Explanation: Vacuum Cleaner
• Data Source: -
• Main Dashboard: -

 

Virtual Showroom

• Explanation: A digital exhibition space enabling customers to virtually experience products online
• Data Source: -
• Main Dashboard: OBS Factbook

 

VPM

• Explanation: Value Proposition Map. A strategic analytical tool that segments the market based on product attributes like price and size, and analyzes the positioning of a brand's product against competitors
• Data Source: -
• Main Dashboard: VPM

 

W/M (Common: Division)

• Explanation: Washing Machine
• Data Source: -
• Main Dashboard: -

 

Warehouse Return (Dashboard: Sales)

• Explanation: This refers to the date on which a returned order is reflected in the warehouse
• Data Source: Magento
• Main Dashboard: Cancel & Return Breakdown

 

WH (Dashboard: Fulfillment)

• Explanation: In the shipping-related dashboard, WH stands for Warehouse
• Data Source: LMDS / TMS
• Main Dashboard: Order Visibility : Fulfillment

 

Withdrawal (Dashboard: Member)

• Explanation: The action of formally withdrawing from membership
• Data Source: -
• Main Dashboard: Member Overview

 

WMS

• Explanation: Warehouse Management System
• Data Source: -
• Main Dashboard: US LMDS

 

WOA (Week of Availability) (Dashboard: Inventory)

• Explanation: This refers to the number of weeks available for sale based on the quantity in stock. If the WOA of a specific division or product is 2, it means that there is enough inventory to sell for two weeks
• Data Source: Magento
• Main Dashboard: Inventory Overview
• Condition & Calculation: OBS flag = Y & STD_ORG_CODE is not null / SUM(INVENTORY_QUANTITY) / Average Weekly Sales

 

WTB (Where to Buy) (Dashboard: GA)

• Explanation: The number of traffic sessions or unique visitors with Where to Buy
• Data Source: GA
• Main Dashboard: -

 

WTD (Week-To-Date) (Common: Date)

• Explanation: This refers to the weekly cumulative value based on ISO (defining Monday as the start of the week). This indicator is used when you want to aggregate data from the beginning of the week (Monday) to a selected date and compare it to the same period last year or last week
• Data Source: -
• Main Dashboard: -
• Condition: ISO Week (MON~SUN)

 

WTD vs Target

• Explanation: WTD compared to target value during set period
• Data Source: -
• Main Dashboard: D2C KPI DASHBOARD
• Calculation: NPT(WTD) / Target(WTD)

 

YTD (Year-To-Date) (Common: Date)

• Explanation: This refers to the annual cumulative value. This indicator is used when you want to aggregate data from the beginning of the year to a selected date and compare it with last year's cumulative value
• Data Source: -
• Main Dashboard: -
• Condition: From January 1st of each year to the base date