Raw Data Information

Magento: Magento is a system that collects/loads/provides LG Electronics’ sales data. In the D2C dashboard project, Model (model management data), Order (order-related data), Sales (sales data), Inventory (stock data), LMDS (logistics-related data), Cancel & Return (shipping and return processing) are processed in EDL twice daily. ), Coupon (coupon data / Order) is collected.

GA (Google Analytics):

GA (Google Analytics) is a system that collects/loads/provides LG Electronics' LG.com user web behavior data.

In the D2C dashboard project, we use the BigQuery Export function to collect GA4 events (D-1) and intra_day (D-Day real-time) web behavior RAW data.

EMP:

EMP is a system that collects/loads/provides integrated member data of LG Electronics' EMP customers.

The D2C dashboard project collects customer information data.

eCRM: eCRM is a system that manages LG Electronics' Salesforce log collection data.

The D2C dashboard project uses Google Storage Cloud and Google Cloud Function to collect log data such as delivery/delivery failure/open/click/cancel subscription, ContactKey target information profile, and a master table that connects each log and GA indicators.

Amazon VC:

Amazon VC (Amazon Vendor Central) is a system that collects/loads/provides LG Electronics' Amazon channel purchase order status and report data.

In the D2C dashboard project, SP-API is called daily to collect RAW data of Purchase Order State and Report.

Meta:

Meta is a system that manages campaigns, ad sets, and advertising data in LG Electronics' AD Account and Insight Account.

The D2C dashboard project calls the Meta graph API daily to collect Facebook campaigns, ad sets, and advertising data.

CJ: CJ is a system that collects/loads/provides LG Electronics' CJ campaign information data.

In the D2C dashboard project, CJ API is called daily to collect campaign information RAW data.

Awin: Awin is a system that collects/loads/provides LG Electronics' Awin campaign information data.

In the D2C dashboard project, the Awin API is called daily to collect RAW data of campaign information by publisher, campaign, advertising concept, and URL.

Bazaarvoice:

Bazaarvoice is a system that collects/loads/provides product information data by LG Electronics' standard product identification number.

In the D2C dashboard project, daily SFTP is used to collect Bazaarvoice standard product identification number-specific product information source data as XML file data.

Criteo:

Criteo is a system that collects/loads/provides data related to LG Electronics' advertising sets.

The D2C dashboard project calls the Criteo API daily to collect RAW data related to ad sets.

SEO Tech: SEO Tech is a system that collects/loads/provides LG Electronics' search engine optimization data.

In the D2C dashboard project, Daily uses SFTP to collect market-specific search engine optimization and URL information data into TSV files.

Bing: Bing is a system that collects/loads/provides data on keywords (search terms), page exposure information, and number of clicks during a specific period to LG Electronics' Bing search engine.

The D2C dashboard project uses Bing.Webmaster.API on a daily basis to collect data on keywords (search terms), page exposure information, and click count information entered into the Bing search engine during a specific period in a CSV file.

Brightcove: Brightcove is a system that collects/loads users' videos, activity information on video channels, and content information data with analysis data on LG Electronics' Analytics API Video Cloud account provided by Brightcove.

In the D2C dashboard project, we call the API with Daily to view the video (name, length, average view rate per view, number of views recorded at a specific point), video channel (name, length, number of times the player is loaded and ready for interaction, total play time, views). average viewership rate per page) to collect information data.

Google Search Console:

Google Search Console is LG Electronics' data provided by Google. It is a system that collects/loads keywords that users search for before entering each LG.com site on Google, LG.com page exposure in search results, and click information data. .

The D2C dashboard project calls the API daily to collect LG.com incoming search keywords, page exposures, clicks, and location information.

Sprinklr: Sprinklr is a system that collects/loads/provides information on users' activities on SNS channels, number of content postings, likes, and follow information using LG Electronics' data provided by Sprinklr.

In the D2C dashboard project, we use Sprinklr Daily to collect data such as users' core SNS participation/number of contents, number of messages posted on platforms/channels, reach-based organic/paid/YouTube engagement data, emotions by product, and number of mansions.

Edge: Edge is a system that collects/loads/provides LG Electronics' product data provided by Edge.

In the D2C dashboard project, daily API calls are made to collect product and product classification data.

Adobe Analytics: Adobe Analytics is a system that collects/loads/provides the number of visitors to LG Electronics' LG.com site, average time spent on page, bounce rate, WTB conversion rate, and product details view traffic data.

In the D2C dashboard project, we collect web behavior data such as LG.com's traffic (number of clicks, number of visitors, etc.) and key-values (events, plug-ins, search engines, etc.) from Adobe Analytics on a daily basis.

Concentrix: Concentrix is a system that collects/loads LG Electronics data provided by Concentrix. Data has not been collected since 2022-07-04 due to inactivity.

The D2C dashboard project collects RAW data from registered FLAGs related to https://wwwstg.lg.com in each country.

Flixmedia: Flixmedia is a system that collects/loads/provides LG Electronics' Global Retail Traffic data.

In the D2C dashboard project, daily SFTP is used to collect view and click count data by country/retailer as a CSV file.

Newplantopia: Newplantopia is a system that collects/loads/provides LG Electronics' Net Sales & COI data.

In the D2C dashboard project, sales data (Net Sales & COI) for each corporation is collected through EDL twice daily, and the previous month's closing data is loaded into CSV in the second week of each month.

Epopcon: Epopcon is a system that collects/loads/provides LG Electronics' Epopcon dynamic pricing data.

The D2C dashboard project uses Daily API calls and Google Cloud Storage to collect Epopcon dynamic pricing (daily price change details crawled by SKU from OnlineStore) data and CSV data from HSAD OSM.

NPS: NPS is a system that collects/loads LG Electronics' Net Promoter Score data. After 2023-04-11, NPS data will not be collected due to deprecation.

The D2C dashboard project collects two types of Net Promoter Score data: non-purchase and purchase.

Google Ads: Google Ads is a system that collects/loads/provides LG Electronics' Google Ads advertising data.

In the D2C dashboard project, RAW data related to campaigns/budget/Placement is collected daily through BigQuery Data Transfer.

Google Merchant Center: Google Merchant Center is a system that collects/loads/provides LG Electronics' Google Merchant Center data.

The D2C dashboard project collects TopBrand, TopProduct, local inventory, price analysis, and product-related data.

CM360: CM360 is a system that collects/loads/provides LG Electronics' advertising data.

In the D2C dashboard project, we use the BigQuery Export function on a daily basis to collect CM360 Offline Report data such as activity, transaction, click, cost, and video play.

SA360: SA360 is a system that collects/loads/provides LG Electronics' Google Search Engine data.

In the D2C dashboard project, RAW data such as advertisements, campaigns, and keywords are collected through BigQuery Data Transfer to Daily.

DV360: DV360 is a system that collects/loads/provides LG Electronics' video advertising data.

The D2C dashboard project uses the BigQuery Export function on a daily basis to collect DV360 Offline Report data such as advertising campaign-related information, I.O information including a series of line items, and Ad format information.