D2C Glossary Version 2

Index	Term	Description	Data Source	Category(큰 카테고리)	Major Dashboard(실제 대시보드)	Calculation & Condition
1	WTD (Week-To-Date)	In the ISO weekly standard, it is calculated from Monday to Sunday based on the present.	-	ALL	ALL	Condition: ISO Week (MON~SUN)
2	MTD (Month-To-Date)	It is calculated from the 1st day of the month to the base date based on the present.	-	ALL	ALL	Condition: First day of each month
3	QTD (Quarter-To-Date)	It is calculated from the base quarter to the base date based on the present.	-	ALL	ALL	Condition: From the first day of the quarter to the base date.
4	YTD (Year-To-Date)	It is calculated from the base year to the base date based on the present.	-	ALL	ALL	Condition: From Janary 1st of each year to the base date.
5	Sales - GMV (Gross Merchandise Value)	This is sales with the discount amount deducted from all transactions for which the payment process was successfully completed.	Magento	SALES_GMV	OBS Business Overview	Condision : (STATUS IN ('preparing for delivery', 'picking for delivery', 'on delivery', 'holded', 'complete', 'RMA-GR', 'RMA-DR', 'return') or (STATUS = 'CANCELED' and PAYMENT_YN = 'Y') Calculation : SUM(TOTAL_AMOUNT_USD_TAX_EXCL_DISCOUNTED)
6	Sales - NMV (Net Merchandise Value)	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.	Magento	SALES_GMV	OBS Business Overview	Condition : STATUS = 'complete' Calculation : SUM(TOTAL_AMOUNT_USD_TAX_EXCL_DISCOUNTED)
7	Units (GMV or NMV)	This is product sales quantity for all transactions where the payment process was successfully completed.	Magento	SALES_GMV	OBS Business Overview	Condition : GMV or NMV Calculation : SUM(Units)
8	Orders (GMV or NMV)	This is order quantity for all transactions that have successfully completed payment.	Magento	SALES_GMV	OBS Business Overview	Condition : GMV or NMV Calculation : COUNTD(Order ID)
9	AOV (Average Order Value)	This is GMV per order for all transactions that have successfully completed the payment process.	Magento	SALES_GMV	OBS Business Overview	Calculation : SUM(GMV) / COUNTD(Order ID)
10	ASP (Average Selling Price)	This is GMV per unit of product sold for all transactions that successfully completed the payment process.	Magento	SALES_GMV	OBS Business Overview	Calculation : SUM(GMV) / SUM(Units)
11	Company Hierarchy	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.	Magento	SALES_GMV	OBS Business Overview
12	GMV to NMV(%)	This is the conversion rate from GMV to NMV.	Magento	On-site Analysis	GMV to NMV Overview	Calculation : SUM(NMV) / SUM(GMV)
13	Cancel (Sales)	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.	Magento	On-site Analysis	GMV to NMV Overview	Condition : STATUS = 'canceled' Calculation : SUM(GMV)
14	Return - Sales	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.	Magento	On-site Analysis	GMV to NMV Overview	Condision : STATUS IN ('RMA-GR', 'RMA-DR', 'return') Calculation : SUM(GMV)
15	In Progress - Sales	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.	Magento	On-site Analysis	GMV to NMV Overview	Condition : STATUS IN ('preparing for delivery', 'picking for delivery', 'on delivery', 'holded') Calculation : SUM(GMV)
16	Cancel(%)	This is the percentage of sales that have been canceled out of GMV.	Magento	On-site Analysis	GMV to NMV Overview	Calculation : SUM(Cancelled Sales) / SUM(GMV)
17	Return(%)	This is the percentage of sales that have been returned out of GMV.	Magento	On-site Analysis	GMV to NMV Overview	Calculation : SUM(Returned Sales) / SUM(GMV)
18	In Progress(%)	This is the percentage of sales in progress of delivery out of GMV.	Magento	On-site Analysis	GMV to NMV Overview	Calculation : SUM(Sales in Progress) / SUM(GMV)
19	Order Return	This refers to the order date on which the return was processed.	Magento	On-site Analysis	Cancel & Return Breakdown
20	Warehouse Return	This refers to the date on which a returned order is reflected in the warehouse.	Magento	On-site Analysis	Cancel & Return Breakdown
21	Strategic (on/off)	This filter is used to specify (on) or not (off) a strategic subsidiary.	Magento	SALES_GMV	OBS Business Overview
22	NPT (New Plantopia Data)	This is sales based on profit and loss.	NPT	SALES_NPT	Weekly Sales Review
23	Net Sales	This is actual sales of OBS, which is the revenue generated from OBS after deducting returns, discounts, allowances, and sales-related costs.	NPT	SALES_NPT	Weekly Sales Review	Calculation : Gross Sales - Sales Deduction + Part/Other Sales + Sales Allowance for Return
24	FP	This is the target sales set by each corporation.	NPT	SALES_NPT	Weekly Sales Review
25	Sales Qty (NPT)	This is the product sales quantity based on NPT.	NPT	FN_Closing	P&L Overveiw
26	Net Price	This is the price after deducting discounts, allowances, and rebate amounts from the original cost of the product.	NPT	FN_Closing	P&L Overveiw
27	Gross Sales	This is the total revenue generated from sales, meaning the total sales volume of OBS.	NPT	FN_Closing	P&L Overveiw
28	Closing	This is sales at the end of the income statement.	NPT	FN_Closing	P&L Overveiw
29	OBS Penetration Rate	This is the percentage of net sales from OBS among LG Electronics' total sales.	NPT	FN_Closing	P&L Overveiw
30	COI(%) (Current Operating Income)	This refers to profit generated from operating activities and is the ratio of operating profit to OBS net sales.	NPT	FN_Closing	P&L Overveiw	Calculation: COI(%) = COI / Net Sales
31	MP(%) (Marginal Profit)	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.	NPT	FN_Closing	P&L Overveiw	Calculation: MP(%) = MP / Met Sales
32	Session	The user interactions that occurred on a website within a given period of time (A session ends after 30 minites of user inactivity)	Google Analytics Traffic	Marketing	Marketing Overview
33	Engaged Session	A session that lasts longer than 10 seconds, has a conversion event, or has at least 2 pageviews or screenviews.	Google Analytics Traffic	Marketing	SEO General
34	Unique Visitor	The number of unduplicated visitors to LG.com website over the course of a specified time period	Google Analytics Traffic	Marketing	Marketing Overview
35	LG.com Visit	The number of traffic sessions or unique visitors on the LG.com website	Google Analytics Traffic	Marketing	Marketing Overview
36	BU Visit	The number of traffic sessions or unique visitors on LG.com website by headquarters	Google Analytics Traffic	Marketing	Marketing Overview
37	PLP (Product List Page)	PLP : Product List Page / The number of traffic sessions or unique visitors with PLP views	Google Analytics Traffic	Marketing	Marketing Overview
38	PDP (Product Detail Page)	PDP : Product Detail Page / The number of traffic sessions or unique visitors with PDP views	Google Analytics Traffic	Marketing	Marketing Overview
39	PBP (Product Buy now Page)	PBP : Product Buy now Page / The page showed when clicking the "Buy now" button on the PDP. The number of traffic sessions or unique visitors with PBP views	Google Analytics Traffic	Marketing	GP1 Marketing Overview
40	ATC (Add to Cart)	The number of traffic sessions or unique visitors with Add to Cart click *ATC(%) : ATC/PDP (%)	Google Analytics Traffic	Marketing	Marketing Overview
41	CHECKOUT	The number of traffic sessions or unique visitors transitioning to the payment page after ATC (CHECKOUT is usually in 3 steps) *CHECKOUT(%) : CHECKOUT / ATC(%)	Google Analytics Traffic	Marketing	Marketing Overview
42	Purchase	Total number of events named purchase *Purchase (%) : Purchase / Previous step session (%)	Google Analytics Traffic	Marketing	SEO General
43	Revenue	The sum of the purchase amount	Google Analytics Traffic	Marketing	SEO General
44	Transactions	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	Google Analytics Traffic	Marketing	Marketing Overview
45	CVR (Conversion Rate)	Conversion rate in LG.COM generally means purchase rate In terms of traffic, we see the percentage of Transactions from LG.COM or from PDP, In terms of purchase, I look at the ratio of Order or PDP to Order from LG.COM *CVR : Transaction / LG.COM or PDP , Order / LG.COM or PDP	Google Analytics Traffic	Marketing	Marketing Overview
46	Paid Channel	Paid channel is the purchase of ad placement on a channel or site to do advertising activities for your brand and reach your target audiences. Paid_Search, Paid_Social,Affiliates, PMAX, Display, Criteo etc. * Paid_Search(source: google,bing,yandex,yahoo,search and medium: cp, ppc, retargeting,paid)	Google Analytics Traffic	Marketing	Marketing Overview
47	Non-Paid Channel	Nonpaid Channel is any marketing tactic where you don’t pay to promote *Direct, Organic_Search.	Google Analytics Traffic	Marketing	Marketing Overview
48	Microsite	A small-scale website separate from the main website, often used for marketing purposes to provide targeted content for specific campaigns or events	Google Analytics Traffic	Marketing	Marketing Overview
49	BOUNCE	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) (%)	Google Analytics Traffic	Marketing	Campaign Performance
50	TIMEONSITE	The total length of time your website was in focus or your app was in the foreground across all sessions	Google Analytics Traffic	Marketing	Campaign Performance
51	AVG SESSION DURATION	(Time on site) / (The total number of active users)	Google Analytics Traffic	Marketing	Campaign Performance
52	LG.com SKU	This is the number of products available for sale on LG.COM.	Magento	SKU Coverage & ISA	Inventory Overview	Condision : MKT_FLAG = 'Y' AND EXCLUSION_FLAG = 'N' AND MODEL_TYPE = 'PDP Calculation : COUNTD(STORE_NAME + SKU)
53	OBS SKU	This is the number of products being sold through OBS.	Magento	SKU Coverage & ISA	Inventory Overview	Condision : OBS_FLAG IN ('ACTIVE', 'SOLD_OUT', 'Y') AND EXCLUSION_FLAG = 'N' AND MODEL_TYPE = 'PDP' Calculation : COUNTD(STORE_NAME + SKU
54	SKU Coverage(%)	This is the percentage of products being sold through OBS among products available for sale on LG.COM.	Magento	SKU Coverage & ISA	Inventory Overview	Calculation : COUNTD(OBS SKU) / COUNTD(LG.com SKU)
55	ISA(%) (In Stock Availability)	This is the percentage of products x warehouse being sold through OBS to products x warehouse available for sale.	Magento	SKU Coverage & ISA	Inventory Overview	Condition : OBS_FLAG = 'Y' Calculation : COUNTD(STD_ORG_CODE + SKU with INVENTORY_QUANTITY > 0) / COUNTD(STD_ORG_CODE + SKU)
56	WOA (Week of Availability)	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.	Magento	SKU Coverage & ISA	Inventory Overview	Condition : OBS_FLAG = 'Y' AND STD_ORG_CODE IS NOT NULL Calculation : SUM(INVENTORY_QUANTUTY) / Average Weekly Sales
57	Average Daily Sales	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.	Magento	SKU Coverage & ISA	Inventory overview	Condision : ISO-Week Basis 4-Week Calculation : SUM(Units) / 28
58	Average Weekly Sales	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.	Magento	SKU Coverage & ISA	Inventory overview	Condision : ISO-Week Basis 4-Week Calculation : SUM(Units) / 4
59	EOL (End of Life)	This is a discontinued product that is no longer sold. Not included in SKU coverage and ISA calculations.	Magento	SKU Coverage & ISA	SKU&ISA Daily
60	OMD	This refers to the main product excluding accessories or consumables.	Magento	SKU Coverage & ISA	SKU&ISA Daily
61	OMV	This refers to accessories or consumables. For example, consumables such as air conditioner filters are referred to as OMV.	Magento	SKU Coverage & ISA	SKU&ISA Daily
62	Sales (USD/EUR)	The total value of goods sold through a Amazon platform within a given time period, typically measured in USD and EUR	Amazon	Marketplace	Amazon VC Overview
63	Sales GR(%)	Sales Growth Rate	Amazon	Marketplace	Amazon VC Overview
64	Sales Qty	Quantity	Amazon	Marketplace	Amazon VC Overview
65	Qty GR(%)	Quantity Growth Rate	Amazon	Marketplace	Amazon VC Overview
66	ASP Diff	Average Sales Price Difference	Amazon	Marketplace	Amazon VC Overview
67	Total Members	This is the number of members registered on the LG.com website.	Member	Member	Member Overview
68	New Joined Member	This is the number of new members registered on the LG.com website during a specific period.	Member	Member	Member Overview
69	Login Visitor	This is the number of visitors who logged into the LG.com website during a specific period.	Google Analytics Traffic	Member	Member Overview
70	Opt-in E-mail	The number of visitors who agreed to receive emails	Member	Member	Member Overview
71	ATC - Login	The number of times a logged-in user clicks the 'Add to Cart' button on the LG.com website.	Google Analytics Traffic	Member	Member Overview
72	Buying	The number of customers who have completed the payment process by purchasing products as a logged-in user.	Magento	Member	Member Overview	Condition: COUNTD(Customer ID), login Y
73	Frequency	The average number of purchases by logged-in users who have completed a purchase.	Magento	Member	Member Overview	Condition: COUNTD(Customer ID), login Y Calculation : COUNTD(Order ID / Customer ID)
74	LMDS (Last Mile Delivery Service)	This is a system where you can see the delivery process after a customer's order.	LMDS	Fulfillment	Last Mile Delivery Service
75	3PL(Third-Party Logistics) Hub	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.	LMDS	Fulfillment	Last Mile Delivery Service
76	Installation Flag	This is a flag that distinguishes products that can be installed.	LMDS	Fulfillment	Last Mile Delivery Service	Condition: STATUS = 'Y'/'N'
77	LMSP Name	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.	LMDS	Fulfillment	Last Mile Delivery Service
78	Reschedule PIC	This is the reason for changing the delivery date.	LMDS (US)	Fulfillment	Last Mile Delivery Service (US)	Condition: RXO, LG, Customer, Weather
79	Coupon Orders Ratio(%)	This is the proportion of orders that include a coupon among all orders. (Except for the welcome coupon)	Magento	Member	Coupon Usage	Calculation: Orders Used Coupon (Except Welcome Coupon) / COUNTD(ORDER ID)
80	Orders Used Coupon	This is the number of orders that include a coupon among all orders. (Except for the welcome coupon)	Magento	Member	Coupon Usage
81	Discount Amount	The amount of money for reductions of the regular price of a product or service to obtain or increase sales	Magento	Member	Coupon Usage
82	UPT (Units per Transaction)	A metric that retail stores use to determine the average number of items a customer purchases for each customer transaction	Magento	Up/Cross-Selling	Package Deal	Calculation: SUM([C_QTY]) / [C_ORDERS]
83	Impressions	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	Flixmedia / GSC	Retail Channel	Global Retail Traffic	Calculation:: SUM(Intereactions)
84	Clicks	The number of traffic sessions or unique visitors with Ad Clicks	GSC	Marketing	SEO General
85	CTR	Sum of Clicks over sum of Impressions *CTR (%) : SUM(Clicks) / SUM(Impression) (%)	GSC	Marketing	SEO General
86	Avg . Position	A relative ranking of the position of lg.com link on Google Search Result Page	GSC	Marketing	SEO General
87	Reviews	Online opinions from current and potential customers who have used LG product or service	Sprinklr	Retail Channel	Customer Awareness
88	Positive/Negative Mentions	Number of mentions having a AI identified positive/negative sentiment	Sprinklr	Retail Channel	Customer Awareness
89	Social Channel Mentions	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	Sprinklr	Retail Channel	Customer Awareness
90	Total Online Mentions	A brand or a company is mentioned online in various forms of social media such as website blogs, news, videos, or other pieces of content	Sprinklr	Retail Channel	Customer Awareness
91	Product of Level 3	The third most detailed level of the 4-level Product Level in the LG product information system, which is divided by Division.	Magento	ALL	ALL
92	SVC	It refers to service sales cases such as A/S.	Magento	Sales_NPT	OBS Subsidiary Overview
93	BU	A term referring to the three headquarters of LG Electronics, an abbreviation for Business Unit, also referred to as Company.	Magento	ALL	ALL
94	CY	An abbreviation for Current Year, meaning the current year.	ALL	ALL	ALL
95	SEO	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 to make the website more searchable in search engines.	GA	Marketing	SEO General
96	OBS SKU with Warehouse	It 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 Warehouse is 50 X 2 = 100.	Magento	SKU Coverage & ISA	SKU&ISA Summary
97	Salable SKU with Warehouse	It is the number of Salable SKUs each warehouse has. If Corporation A has two warehouses in operation, and there are 20 in Warehouse 1 and 30 in Warehouse 2, the total Salable SKU with Warehouse for Corporation A is 50.	Magento	SKU Coverage & ISA	SKU&ISA Summary	Calculation: COUNTD(Salable SKU with Warehouse > 0) / COUNTD(OBS SKU with warehouse)
98	WH	In the shipping-related dashboard, WH stands for Warehouse.	LMDS / TMS	Fulfillment	Last Mile Delivery Service
99	APPT	In the shipping-related dashboard, APPT stands for Appointment.	LMDS / TMS	Fulfillment	Last Mile Delivery Service
100	OBS Sales For GFK	It refers to the OBS performance obtained from a market research institute called GFK.	GFK	Marketplace	OBS Sales for GFK
101	P&L Summary	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.	NPT	FN_Closing	P&L Overview
102	PTO Bundle	It is a set model name that bundles two or more models for sale as a bundle.	Magento	-	-
103	OSM (Online Store Management)	Monitoring of digital shelf items of our company and competitors in major global distribution channels (banners, reviews, ratings, prices, search rankings, inventory, etc.)	OSM	Retail Channel	Online Store Management
104	Salable Stock	This refers to the quantity of product available for sale.	Magento	SKU Coverage & ISA	Inventory Overview	Condition : OBS_FLAG = 'Y' Calculation : SUM(INVENTORY_QUANTUTY)
105	WTB (Where to Buy)	The number of traffic sessions or unique visitors with Where to Buy	Google Analytics Traffic	-	-
106	Checkout1	CHECKOUT1: Ccustomer Information	Google Analytics Traffic	On-site Analysis	Checkout Deep Dive
107	Checkout2	CHECKOUT2: Sipping Information	Google Analytics Traffic	On-site Analysis	Checkout Deep Dive
108	Checkout3	CHECKOUT3: Payment Method	Google Analytics Traffic	On-site Analysis	Checkout Deep Dive
109	Impression	Total number of times an ad is shown	GSC	Marketing	Campaign Ads Performance
110	CPC (Costs Per Click)	CPC = Cost per Click	GSC	Marketing	Campaign Ads Performance
111	ROAS (Return On Ad Spend)	ROAS = (Revenue from ads) / (Ad cost) *100	GSC	Marketing	Campaign Ads Performance
112	ROI (Return on investment)	ROI = (Net Income) / (Total Cost) *100	GSC	Marketing	Campaign Ads Performance
113	Store Type	B2C, B2B2C, B2E, B2B, etc.	-	ALL	ALL
114	Store Name	The name of Subsidiary	-	ALL	ALL
115	Store ID	The code of Subsidiary	-	ALL	ALL
116	Model Code	The code of model	-	ALL	ALL
117	Division	Category *REF,W/M,MNT,OLED,UHD,Air care etc	-	ALL	ALL
118	Timezone	Magento: UTC GA: Each country's timezone (GMT + @) Sprinklr: GMT	-	ALL	ALL
119	Search Terms (Keywords)	The keywords searched when entering the site	Google Analytics Traffic	Marketing	Product Funnel
120	Proceed to Checkout	It means Checkout1	Google Analytics Traffic	Marketing	Product Funnel
121	Next	It means Checkout2	Google Analytics Traffic	Marketing	Product Funnel
122	Proceed Payment	It means Checkout3	Google Analytics Traffic	Marketing	Product Funnel
123	G2N	GMV to NMV refers to actual orders excluding cancel, reject cases.	Magento	ALL	ALL
124	Banner SOV	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.	GA	Retail Channel	Digital Channel Management
125	Interaction Rate(%)	A metric that social media advertisers use to measure how often users interact with their ads	Flixmedia	Retail Channel	Global Retail Traffic	Calculation : SUM(Iinteractions)/Sum(Impressions)
126	Interactions	likes, comments, shares, etc. related to social media	Flixmedia	Retail Channel	Global Retail Traffic