OSM data can be found in the Online Store Management dashboard.
➢ How to access OSM Dashboard : D2C Data Portal Home > In-depth Analysis > Retail Channel > Online Store Management
➢ How to download raw data : Online Store Management > “Raw Data Download” button at the top of each tab
The OSM data is provided in weekly basis and constructed base on Key Indicator which affects purchases in online store.
Four main pages represents OSM trends in different perspectives, certain graphs provides SKU filtering options to help users to check detailed data in 1 page view.
Key Indicator : Overview
This menu summarizes the Key Indicator data values for LG products in the form of 7 graphs.
- # of SKUs : Total number of distinct LG SKUs exposed in latest week with selected condition. Sourced from PDP Contents (rpc)
- # of SKUs in Top 20 SERP : Number of distinct LG SKUs in latest week exposed in search rank between 1 and 20
- Avg. Rank in Top 20 SERP : Avg. Rank of LG SKUs in latest week exposed in search rank between 1 and 20
- # of Review : Total number of distinct LG SKU reviews in latest day of selected week
- Avg. Ratings : Avg. Ratings of LG SKU exposed in latest week
- Stock Availability : In-Stock availability of LG SKUs exposed in latest day of selected week. (Void excluded from parameter)
Proportion of In-stock of the total inventory. # of In stock / (# of In Stock + # of OoS ) - Avg. Selling Price : Avg. Selling Price of LG SKU exposed in latest day of selected week.
Discount price / Local currency
The Visibility / Conversion table at the bottom of the page allows you to check the data for the current week and compare it with the previous week’s values.
➢ Summary of Key Indicator which affects purchase in online store, provided in actual data for intuitive view for LG Performance within latest 8 weeks in each store.
- Check the trend compared to the previous week and the level of superiority against the competitor, and intuitively check the factors that need to take action.
- Check data by retailer, category, and brand to identify changes compared to the previous week and to find conversion factors requires improvement (Stock Status, Price etc.)
Key Indicator : Visibility
This menu shows key data analyses based on the top 20 in the search results.
Graphs and a table show the status of top products (both LG and competitors) within OSM. This page also shows the share of brands in the Banner, Product List (Menu) area within OSM.
- # of Products within Top 20 SERP Weekly Trend (by Brand)
: Number of SKUs for LG, SS and selected brand by week.
# of Days per SKU in latest week, exposed search rank between 1 and 20 - # Avg. Rank within Top 20 SERP Weekly Trend (by Brand)
: Average ranking of LG, SS and selected brand by week.
Avg. Rank per SKU in latest week, exposed search rank between 1 and 20
(It counts only average ranking within Top 20) - SERP Top Ranked SKU within 20 in latest week
: You can refer the product information in ascending order by averaging the product. exposure rankings according to the selected duplicate/single search keywords.
(Only the average for product rankings within Rank<21 is calculated) - Share by brand in Top 20 SERP (# of Brand Count)
: Share of brand count within the top 20 search result page. Number of brand count in latest week exposed in search rank between 1 and 20 - (Ref) SOV Comparison_Banner
: Share of brand count in Banner. Number of brand count in latest week exposed in banner data - (Ref) SOV Comparison_Product List (Rank within TOP 20)
: Share of brand count within the top 20 rank of category page. Number of brand count in latest week exposed in product list rank between 1 and 20
➢ Summary of Key Indicator which affects purchase in online store, provided in actual data for intuitive view for LG Performance within latest 8 weeks in each store.
- Provides the number of products in the top 20 exposure in selected retailers and the average rank within top 20 exposed brand. (LG and competitors).
- Base on the selected End Week and filtered criteria, the table provides the most top rated products with conversion details (Price etc.) in ascending order.
➢ View the latest eight-week exposure rankings and product count trends within each retailers’ banner, search keyword, and category page
- Check the trend of SOV (Share of visibility) in the top 20 SKUs in search keywords, banners, and category pages in weekly basis.
Key Indicator : Conversion
This menu visualizes key information in the OSM PDP (Product Detail Page).
Graphs and tables intuitively show information such as the number of reviews, average ratings, the status of positive / negative reviews, and current inventory.
- # of Reviews Weekly Trend (Average Review Count) : Number of distinct SKUs per Brand exposed in latest week with selected condition. Sourced from PDP Contents (rpc)
- # of New Reviews by Day of the Week (vs. Week Before) : Number of distinct SKUs per Brand exposed in each weekday (Mon-Sun)
- Total SKU Showcased (Latest Day) : Total number of SKUs by brand compared to last week. Number of distinct SKUs per Brand exposed in latest day of selected week
- Total / Newest Review Numbers (Latest Day) : Compare current total reviews and review growth compared to the competitor. Calculated Incremental of reviews compares with latest day of week ago (This weeks’ review – Last weeks’ review)
- Share of Negative Review SKUs : Ratio of 0 rated, Negative or Positive LG/SS SKUs in latest day of selected week. (Negative Review Rating over 0 and under 3.0)
- # Avg. Rating Weekly Trend
- LG Product List by Lowest # of Reviews : Rank 20 among LG products in order of least number of reviews. (excluding parameters if there is no review)
- LG Product List by Lowest # of Ratings : Rank 20 among LG products in order of lowest rating
(If the rating is 0, consider that there is no review and exclude it from the parameter) - # Stock Available Trend (Weekly) : The inventory graph shows 'In Stock' & 'Out of Stock' as 100%.
(Void excluded from parameter) - # Stock Available Trend by Brands
- Out of Stock SKU Tracking (LG, Latest Week) : Number of days collected as OoS per SKU in latest week
➢ Track key information such as reviews, ratings, and inventory within the PDP (Product Detail Page) to provide LG products OSM trends for the latest 8 weeks
Provides efficient management indicators: Increase in reviews compared to the previous week, ratio of negative reviews compared to competitors, weekly inventory status, etc
Price Trends
This menu shows a graph of daily price changes.
The graph at the bottom shows the price fluctuations by retailer of each category or specific SKU, which allows you to understand the market flow.
- Price Daily Trend by Brand (Week Avg.) : Avg. Price per Day*Country*Brand Level (giving out latest 28days data). List Price / Local Currency
- SKU Price Daily Trend by Retailer (Week Avg.) : Avg. Price per Day*Country*Retailers available to scope down into selected SKU(mpc). List Price / Local Currency
➢ Track the price fluctuation trend by brand in country level, and compare the brand’s price level in each store in recent 28 Days (4 weeks based on selected week.)
- Check the price trend of each Brand in overall market. Users can easily compare the average price position of each brand and category products.
- Check the price trend of SKU in different online stores. It could be easily drilled down using [product model code] filters placed upper right of the chart.
(ref) Scoring Overview
➢ The displayed bar and line charts display historical trends and changes over a period of time that you would like to see and compare.
Check whether the overall OSM competitive index and confirm if it is increasing or decreasing.
(ref.) Score Custom
➢ The displayed bar and line charts display historical trends and changes over a period of time that you would like to see and compare.
Check whether the overall OSM competitive index and confirm if it is increasing or decreasing.
(ref.) Score Details Competitive
➢ Ratio data(Score) compared with competitor brands are provided for all OSM management index.
Check which factor is relatively lower and needs urgent improvement?
(ref.) Details Data Avg
➢ The output value of the data for LG and competitor brand calculated according to the defined formula is displayed.
Check which factor is relatively lower and needs urgent improvement?
Raw Data Download
➢ Raw data used for all the charts and graphs on different menus are all provided and could be used to get deeper insights through the use of detailed data not indicated in charts.