KR20030064700A - Web Log Analysis Method using Customer ID and Session ID matching - Google Patents

Abstract

PURPOSE: A method for analyzing a web log by matching a member ID with a session ID is provided to check activities of a customer on a site before a log-in state beside the information generated after the log-in state by adding the member ID and the session ID when generating a web log file. CONSTITUTION: A member ID and a session ID are added to a web log file by adding a source for extracting the member ID and the session ID into a source code(101,103). The member information in a database and the web log file stored in a web server are read, and converted into a subdivided file while storing or refining a file. The file is stored(106,107,108). After combining and analyzing the web log file and the member information(109), the e-mail is forwarded to customers.

Description

Web Log Analysis Method using Customer ID and Session ID matching}

The present invention relates to customer relationship management and belongs to a method for managing and marketing customers online using web data and customer information.

Customer Relationship Management (CRM) is a new paradigm of internet marketing that aims to create a stable market base by establishing relationships with various customers, including one-to-one marketing.

In other words, customer relationship management (CRM) is a scientific analysis of how to understand customers who use their company, and is the basis for important functions such as forecasting customer tendency and setting direction of customer service.

In addition, for the purpose of customer relationship management (CRM), it is a system that ultimately improves customer loyalty, increases profits, and supports corporate strategy in terms of business processes. Industry, telecommunications, and distribution are leading the way, and market demand continues to rise.

There are various ways to accumulate customer information for customer relationship management on the Internet. Among them, customer information is managed in a three-dimensional manner by integrating and managing information such as the behavior of customers moving on the website and records of purchases and transactions on the website. It is necessary to build a processor that understands the information and organizes the information in real time, and technology bases such as web analytics and data mining have evolved to meet these demands.

Among them, Weblog refers to information data about a user accessing a specific web site through a web server, and is a record of all operations performed by the user through the web server. Accesses the various files associated with the page, and all the work performed by the user's request remains as data in a predetermined location on the web server.

In general, in the web log analysis method, Figure 1 is a diagram of a log file storage method for a conventional ID (ID) matching method. In FIG. 1, users 100 using the Internet access a specific web site through a web server 101, and records of all operations of the user 100, that is, a log file 102, are stored in the user's member ( The customer is saved with the addition of an ID.

The above-described conventional method is described in detail as follows. That is, the following format is a log file 102 created by adding a member (customer) ID and has the following format.

① 2002-10-05 08:22:28 203.241.197.155-W3SVC1 YO 203.241.197.159 80 GET /Default.asp-200 0 0 244 50 HTTP / 1.1 203.241.197.159 Mozilla / 4.0 + (compatible; + MSIE + 6.0; + Windows + 98)

② 2002-10-05 08:22:38 203.241.197.155-W3SVC1 YO 203.241.197.159 80 GET /dataroom/dataroom.asp-200 0 0 354 3695 HTTP / 1.1 203.241.197.159 Mozilla / 4.0 + (compatible; + MSIE + 6.0; + Windows + 98)

③ 2002-10-05 08:22:54 203.241.197.155-W3SVC1 YO 203.241.197.159 80 GET /dataroom/dataroom.asp-200 0 0 354 1562 HTTP / 1.1 203.241.197.159 Mozilla / 4.0 + (compatible; + MSIE + 6.0; + Windows + 98)

Junsergy 2002-10-05 08:25:19 203.241.197.155-W3SVC1 YO 203.241.197.159 80 GET /Default.asp-200 0 0 244 50 HTTP / 1.1 203.241.197.159 Mozilla / 4.0 + (compatible; + MSIE + 6.0 ; + Windows + 98)

Junsergy 2002-10-05 08:25:31 203.241.197.155-W3SVC1 YO 203.241.197.159 80 GET /dataroom/dataroom.asp-200 0 0 354 3695 HTTP / 1.1 203.241.197.159 Mozilla / 4.0 + (compatible; + MSIE +6.0; + Windows + 98)

In the above ①, ②, ③, ④, and ⑤, log file formats ①, ②, and ③ are log file formats indicating the state before login, and ④ and ⑤ are log file formats indicating the state after login.

Therefore, when the web log file is generated in the log file 102 format as described above, it is impossible to obtain information indicating the state prior to the login of the customer. .

In addition, storing web log files in the database has the disadvantage of limiting the repeated capacity expansion and temporal and spatial processing capacity of the database according to the demands and increasing behaviors of customers in the transmission and analysis. have.

The present invention is a method for solving the above problems, by adding a member (Customer ID) and Session ID (Session ID) when creating a web log file before the login before the customer is logged in addition to the information generated To identify actions on the site of the state,

It also aims to store the generated log files and customer information as files instead of storing them in a database to eliminate storage costs, and to provide e-mail and telemarketing data to relevant customers after analysis of web logs. .

1 is a diagram showing a log file storage form using a conventional ID matching technique.

2 is a view showing a log file storage method using a member (customer) ID and session ID matching method in the present invention;

3 is a diagram illustrating a detailed file format of analysis data.

Figure 4 is a file storage form and overall system configuration proposed in the present invention

<Description of the symbols for the main parts of the drawings>

100: user

101: web server

102: Conventional log file format

103: Log file format proposed in the present invention

104: database storing member (customer) information

105: Customer Information

106: Member (Customer) Information File that stores member (customer) ID and session ID

107: File Purification

108a: Time dimension data file

108b: Reference Dimension Data File

108c: Customer dimension data file

108d: Page view dimension data file

108e: Agent Dimension Data File

109: Dimensional data file analysis

110: analysis results displayed on the screen

111: e-mail sending and telemarketing materials

The present invention adds the member (customer) ID and the session ID to the web log file by adding a source for extracting the member (customer) ID and the session ID proposed in the present invention into source codes such as web sites ASP, PHP and JSP. (100, 101, 103); Read the member (customer) information (104, 105) in the database and the web log file in the web server 101, the file storage 106 and purification step 107 is converted into a valid subdivided file and stored (106, 107, 108); After the analysis (109) by combining the web log file and the member (customer) information, it comprises a step (110, 111) of sending e-mail and telemarketing to the customers belonging to the analysis.

In the present invention, Figure 2 is a diagram of a log file storage method using a member (customer) ID and session ID matching technique. As shown in FIG. 2, the log file 103 in which the session ID is added in addition to the member (customer) ID may be used as useful information up to the behaviors before the login of the customer.

2, the log file 103 generated by the present invention is in the format.

①-34121 2002-10-05 09:11:58 203.241.197.155-W3SVC1 YO 203.241.197.159 80 GET /Default.asp-200 0 0 244 50 HTTP / 1.1 203.241.197.159 Mozilla / 4.0 + (compatible; + MSIE + 6.0; + Windows + 98)

② junsergy 34121 2002-10-05 09:12:18 203.241.197.155-W3SVC1 YO 203.241.197.159 80 GET /dataroom/dataroom.asp-200 0 0 354 3695 HTTP / 1.1 203.241.197.159 Mozilla / 4.0 + (compatible; + MSIE + 6.0; + Windows + 98)

③ junsergy 34121 2002-10-05 09:12:54 203.241.197.155-W3SVC1 YO 203.241.197.159 80 GET /dataroom/listroom.asp-200 0 0 354 1562 HTTP / 1.1 203.241.197.159 Mozilla / 4.0 + (compatible; + MSIE + 6.0; + Windows + 98)

④-34121 2002-10-05 09:13:22 203.241.197.155-W3SVC1 YO 203.241.197.159 80 GET /dataroom/logout.asp-200 0 0 354 1562 HTTP / 1.1 203.241.197.159 Mozilla / 4.0 + (compatible; + MSIE + 6.0; + Windows + 98)

① in the above log file format adds only the session ID before login. The "-" in front of the session ID is not logged in, so the member (customer) ID value is displayed as "-". In addition, ② and ③ are the form in which the member ID's "junsergy" value is added at the same time as the existing session ID after the member (customer) login.

In this case, the member (customer) who logged in logs out, and the member (customer) ID is displayed as "-" again, and the session ID value is still displayed the same.

In addition, the generated log file 103 and the member (customer) information in the existing database 104 is read through FTP and then divided into valid files and stored.

In the present invention, Figure 3 is a view showing a detailed file format of the analysis data, Figure 4 is a file storage form and the overall system configuration proposed in the present invention.

3, the time dimension 108a, the reference dimension 108b, the customer dimension 108c, the page while reading the web log file and the web log file when the customer information is stored. A page view dimension 108d, an agent dimension 108e, and the like are stored as respective dimension data files.

In FIG. 4, the generated log file 103 and the customer information 105 are also stored as a file, and the web log file and the customer information are stored in the file 106 and the tablet 107 to the database 104. This can reduce the cost of storing them.

As described above with reference to FIGS. 3 and 4, when storing the weblog file 103 and the customer information 105, the weblog file 106 is read while the time dimension 108a and reference are used. The dimension 108b, the customer dimension 108c, the page view dimension 108d, the agent dimension 108e, etc. are stored as respective dimension data files for web analysis and customer analysis. Eliminate the annoyance of analysis when saving to file.

In addition, as shown in FIG. 4, after the web log analysis, that is, the dimensional data analysis 109, the information used for the e-mail sending 111 and the telemarketing is provided to the customer corresponding to each analysis result 110. .

As described above, the existing mail delivery package is difficult to extract the customer. However, the present invention enables segmented marketing to the customer corresponding to the analysis result.

Adding the member (customer) ID and session ID to the web log file by adding a source for extracting the member (customer) ID and session ID according to the present invention as described above; Reading the member (customer) information (104, 105) in the database and the web log file in the web server (101) and converting the data into a storage form proposed by the present invention; Analyze the web log file and the member (customer) information (109), and then remove the anonymity of the customer from the web log file by sending email and telemarketing to the customers belonging to the analysis. The advantage is that it can cut costs and do customer segment marketing.

In addition, it is possible to analyze not only the post-login status but also the pre-login status of the customer behavior, so that the customer's past, present, and future preference patterns can be analyzed in terms of customer relationship management.

Claims (3)

In the web log data analysis and customer data analysis method, In order to enable the customer to grasp the information on the site before the login in addition to the information generated after the login, the web log file is added to the member (customer) ID and the session ID and generated as a log file 103. Web log data analysis and customer data analysis method characterized in that The method of claim 1, After reading the generated log file 103 and the customer information 105 in the database 104 via FTP, the file dimension 106, the refinement 107, and then the time dimension 108a, reference dimension 108b. Web log data analysis and customer data characterized in that the method (106, 107, 108, 109) of storing as a granular dimension data file such as customer dimension (108c), page view dimension (108d), agent dimension (108e), etc. Analysis method The method of claim 2, After analyzing the data stored through the above-mentioned method, the method of storing the data corresponding to each analysis method 109 of the web log file 109 to the customers can be e-mailed and telemarketed to a file (110, 111). Web log data analysis and customer data analysis method