CN111131393B - User activity data statistical method, electronic device and storage medium - Google Patents
User activity data statistical method, electronic device and storage medium Download PDFInfo
- Publication number
- CN111131393B CN111131393B CN201911180242.2A CN201911180242A CN111131393B CN 111131393 B CN111131393 B CN 111131393B CN 201911180242 A CN201911180242 A CN 201911180242A CN 111131393 B CN111131393 B CN 111131393B
- Authority
- CN
- China
- Prior art keywords
- user
- system platform
- data
- matrix table
- preset
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/50—Network services
- H04L67/535—Tracking the activity of the user
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L43/00—Arrangements for monitoring or testing data switching networks
- H04L43/06—Generation of reports
- H04L43/067—Generation of reports using time frame reporting
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Computer Hardware Design (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention relates to the technical field of Internet, and provides a user activity data statistical method, an electronic device and a computer storage medium, wherein the method comprises the following steps: receiving the operation of a user accessing a system platform through a terminal, generating user information comprising operation time, a user IP and a user code, accumulating the times of accessing the system platform by the user according to the operation time in the user information and preset time granularity, recording accumulated data and a user area into a preset matrix table, then carrying out normalization operation on the data in the preset matrix table by using a normalization function, mapping the matrix table after the operation to a data table of the system platform for data statistics, and generating a data analysis report to show the activity of the user accessing the system platform. According to the method and the system, the time granularity access data of the user in different areas are counted by recording the areas accessed by the user and refining the time period, so that the timeliness of pushing the service information is improved by the auxiliary system platform.
Description
Technical Field
The invention relates to the technical field of internet, in particular to a user activity data statistical method, an electronic device and a computer readable storage medium.
Background
With the development of internet technology, the activity statistics of the user is helpful for better understanding the behavior of the user using the application system and pushing the service information.
The traditional method for calculating the activity of the user is to estimate the activity of the user by counting the transaction number of user orders every day, however, the traditional method for counting the activity of the user has a long time period, is difficult to judge the activity of the user in a specific time period, does not consider the regional distribution of the user, is difficult to determine the behavior data accessed by the user in different regions in a certain time period, causes that an application system cannot accurately push service information to the user in a specified region in the specific time period, and causes poor timeliness of pushing the service information.
Disclosure of Invention
In view of the above, the present invention provides a user activity data statistics method, an electronic device, and a computer-readable storage medium, and a main object of the invention is to count time granularity access data of a user in different areas by recording areas accessed by the user and refining time periods, thereby assisting a system platform to improve timeliness of service information push.
In order to achieve the above object, the present invention provides a statistical method for user activity data, applied to an electronic device, the method comprising:
a receiving step: receiving the operation of a user accessing a system platform through a terminal, and generating user information comprising operation time, a user IP and a user code, wherein the user IP is associated with an area where the user is located;
a polymerization step: accumulating the times of accessing the system platform by the user according to the operation time in the user information and preset time granularity, and recording the accumulated data and the area where the user is located into a preset matrix table, wherein the preset matrix table consists of the user code, the area where the user is located and the preset time granularity;
a calculation step: carrying out normalization operation on the data in the preset matrix table by using a normalization function to obtain a matrix table subjected to normalization processing; and
a statistical step: and mapping the matrix table after the normalization processing to a data table of the system platform for data statistics, and generating a data analysis report to show the activity of a user accessing the system platform.
Preferably, the terminal comprises a mobile phone terminal and a computer terminal;
when receiving the operation that a user accesses a system platform through a mobile phone terminal, analyzing the area of the current mobile phone terminal to determine the IP of the user; and
and when receiving the operation that the user accesses the system platform through the computer terminal, determining the user IP according to the IP address of the network signal connected with the computer terminal.
Preferably, the normalization function is:
wherein N is n Representing a user code;
T n representing a preset time granularity;
f(N n ，T n ) Represents N n User is at T n Presetting a time granularity to accumulate a numerical value for accessing a system platform;
n is a positive integer;
f is 0 or 1, wherein the value 1 is an integer after F operation.
Preferably, the mapping of the matrix table to the data table of the system platform for data statistics includes:
counting the user access amount of each time granularity;
counting the user access amount of each time granularity in different areas; and
and counting the user access amount of each area.
Preferably, after the step of counting, the method further comprises:
a pushing step: and determining the user access amount of each region and time granularity of the system platform according to the generated data analysis report, and pushing preset service information to a target region and a terminal of the time granularity in a preset time period.
In addition, to achieve the above object, the present invention further provides an electronic device, which includes a memory and a processor, wherein the memory stores a data processing program operable on the processor, and the data processing program, when executed by the processor, implements the following steps:
a receiving step: receiving the operation of a user accessing a system platform through a terminal, and generating user information comprising operation time, a user IP and a user code, wherein the user IP is associated with an area where the user is located;
a polymerization step: accumulating the times of accessing the system platform by the user according to the operation time in the user information and preset time granularity, and recording the accumulated data and the area where the user is located into a preset matrix table, wherein the preset matrix table consists of the user code, the area where the user is located and the preset time granularity;
a calculation step: carrying out normalization operation on the data in the preset matrix table by using a normalization function to obtain a matrix table subjected to normalization processing; and
a statistical step: and mapping the matrix table after the normalization processing to a data table of the system platform for data statistics, and generating a data analysis report to show the activity of a user accessing the system platform.
Preferably, the terminal comprises a mobile phone terminal and a computer terminal;
when receiving the operation that a user accesses a system platform through a mobile phone terminal, analyzing the area of the current mobile phone terminal to determine the IP of the user; and
and when receiving the operation that the user accesses the system platform through the computer terminal, determining the user IP according to the IP address of the network signal connected with the computer terminal.
Preferably, the normalization function is:
wherein N is n Representing a user code;
T n representing a preset time granularity;
f(N n ，T n ) Represents N n User is at T n Accumulating the numerical value of the access system platform by preset time granularity;
n is a positive integer;
f is 0 or 1, wherein the value 1 is an integer after F operation.
Preferably, the mapping of the matrix table to the data table of the system platform for data statistics includes:
counting the user access amount of each time granularity;
counting the user access amount of each time granularity in different areas; and
and counting the user access amount of each area.
In addition, to achieve the above object, the present invention further provides a computer-readable storage medium, which includes a data processing program, and when the data processing program is executed by a processor, the computer-readable storage medium can implement any one of the steps of the user activity data statistical method described above.
The invention provides a user activity data statistical method, an electronic device and a computer readable storage medium, which generate user information comprising operation time, a user IP and a user code by receiving operation of a user accessing a system platform through a terminal, accumulate times of the user accessing the system platform according to the operation time in the user information and preset time granularity, record accumulated data and an area where the user is located into a preset matrix table, then perform normalization operation on the data in the preset matrix table by using a normalization function, map the obtained matrix table subjected to normalization processing to a data table of the system platform for data statistics, and generate a data analysis report to show the activity of the user accessing the system platform. According to the method and the system, the time granularity access data of the user in different areas are counted by recording the areas accessed by the user and refining the time period, so that the timeliness of pushing the service information is improved by the auxiliary system platform.
Drawings
FIG. 1 is a diagram of an electronic device according to a preferred embodiment of the present invention;
FIG. 2 is a block diagram of a preferred embodiment of the data processing program of FIG. 1;
FIG. 3 is a block diagram of another embodiment of the data processing program of FIG. 1;
FIG. 4 is a flowchart illustrating a user activity data statistics method according to a preferred embodiment of the present invention;
FIG. 5 is a flowchart illustrating a user activity data statistics method according to another preferred embodiment of the present invention;
the implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the description relating to "first", "second", etc. in the present invention is for descriptive purposes only and is not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In addition, technical solutions between various embodiments may be combined with each other, but must be realized by a person skilled in the art, and when the technical solutions are contradictory or cannot be realized, such a combination should not be considered to exist, and is not within the protection scope of the present invention.
Referring to fig. 1, a schematic diagram of an electronic device according to a preferred embodiment of the invention is shown. The electronic apparatus 1 is a device capable of automatically performing numerical calculation and/or information processing in accordance with a command set or stored in advance. The electronic device 1 may be a computer, or may be a single network server, a server group composed of a plurality of network servers, or a cloud composed of a large number of hosts or network servers based on cloud computing, where cloud computing is one of distributed computing and is a super virtual computer composed of a group of loosely coupled computers.
In the present embodiment, the electronic device 1 may include, but is not limited to, a memory 11, a processor 12, and a display 13, which are communicatively connected to each other through a system bus, and the memory 11 stores a data processing program 10 that is executable on the processor 12. It is noted that fig. 1 only shows the electronic device 1 with components 11-13, but it is to be understood that not all shown components are required to be implemented, and that more or less components may alternatively be implemented.
The storage 11 includes a memory and at least one type of readable storage medium. The memory provides cache for the operation of the electronic device 1; the readable storage medium may be a non-volatile storage medium such as flash memory, a hard disk, a multimedia card, a card type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a Read Only Memory (ROM), an Electrically Erasable Programmable Read Only Memory (EEPROM), a Programmable Read Only Memory (PROM), a magnetic memory, a magnetic disk, an optical disk, etc. In some embodiments, the readable storage medium may be an internal storage unit of the electronic apparatus 1, such as a hard disk of the electronic apparatus 1; in other embodiments, the non-volatile storage medium may also be an external storage device of the electronic apparatus 1, such as a plug-in hard disk provided on the electronic apparatus 1, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like. In this embodiment, the readable storage medium of the memory 11 is generally used for storing an operating system and various types of application software installed in the electronic device 1, for example, storing the data processing program 10 in an embodiment of the present invention. Further, the memory 11 may also be used to temporarily store various types of data that have been output or are to be output.
The processor 12 may be a Central Processing Unit (CPU), controller, microcontroller, microprocessor, or other data Processing chip in some embodiments. The processor 12 is generally used for controlling the overall operation of the electronic apparatus 1, such as performing control and processing related to data interaction or communication with the other devices. In this embodiment, the processor 12 is configured to run the program code stored in the memory 11 or process data, for example, run the data processing program 10.
The data processing program 10 is stored in the memory 11 and includes computer readable instructions stored in the memory 11 that are executable by the processor 12 to implement the methods of the embodiments of the present application.
In an embodiment, the data processing program 10 implements the following steps when executed by the processor 12:
a receiving step: receiving the operation of a user accessing the system platform through a terminal, and generating user information comprising operation time, a user IP and a user code, wherein the user IP is associated with the area where the user is located.
In one embodiment, a user logs in a system platform (e.g., an automobile transaction system) to operate through a terminal (e.g., a mobile phone terminal or a computer terminal), the system platform determines a user IP according to a region where the user logs in, and correspondingly associates the user IP with the region where the user is located (e.g., beijing, shanghai, guangzhou, etc.), the system platform records the current operation time of the user according to the user operation, and meanwhile, the system platform generates a user code for each accessed user according to a preset number so as to better arrange and arrange user information.
Further, the terminal comprises a mobile phone terminal and a computer terminal;
when receiving the operation that a user accesses a system platform through a mobile phone terminal, analyzing the area of the current mobile phone terminal to determine the IP of the user; and
and when receiving the operation that the user accesses the system platform through the computer terminal, determining the user IP according to the IP address of the network signal connected with the computer terminal.
A polymerization step: and accumulating the times of accessing the system platform by the user according to the operation time in the user information and the preset time granularity, and recording the accumulated data and the area where the user is located into a preset matrix table, wherein the preset matrix table consists of the user code, the area where the user is located and the preset time granularity.
In this embodiment, in order to fully know the specific time when the user uses the system platform, the preset time granularity is divided into 96 equal parts according to a period of 15 minutes for refinement (that is, the preset time granularity is divided into 96 equal parts every 24 hours), so that the behavior habits of logging and operation of the user on the system platform are enhanced and monitored, the system platform is facilitated to better manage and accurately push information, and the timeliness of pushing service information at fixed points and at fixed times is improved.
The preset matrix table is composed of user codes, areas where the users are located and preset time granularity. And representing the corresponding user by the column where the user code is positioned, representing the corresponding user IP by the column where the area where the user is positioned, arranging the preset time granularity in a horizontal row sequence according to 96 equal parts, and establishing a preset matrix table of the time granularity of the area where the user is positioned.
For example, with N n Representing user code, T n Representing the preset time granularity, and P representing the area where the user is located, and constructing the following initial matrix table:
in one embodiment, the user accesses the partial data of the system flat record as the following matrix table:
| P | T 1 | T 2 | T 3 | T 3 | … | T n | |
| N 1 | beijing | 3 | 0 | 1 | 5 | 0 | |
| N 2 | Shanghai province | 1 | 2 | 3 | 4 | 0 | |
| N 3 | Guangzhou province | 5 | 0 | 2 | 3 | 0 | |
| … | … | … | |||||
| N n | 0 | 0 | 0 | 0 | 0 |
A calculation step: and carrying out normalization operation on the data in the preset matrix table by using a normalization function to obtain a matrix table subjected to normalization processing.
In this embodiment, the cumulative value corresponding to each time granularity recorded in the preset matrix table is subjected to normalization operation to obtain whether a value of O or 1 represents that a user has access to the system platform (for example, an automobile transaction platform) at the corresponding time granularity, and when the value obtained by the operation is 0, it represents that the user does not access the system platform at the corresponding time granularity; and when the value obtained by the operation is 1, the user accesses the system platform at the corresponding time granularity, and the calculated value is updated to the preset matrix table.
For example, part of the data of the matrix table after the normalization process is as follows:
| P | T 1 | T 2 | T 3 | T 3 | … | T n | |
| N 1 | beijing | 1 | 0 | 1 | 1 | 0 | |
| N 2 | Shanghai province | 1 | 1 | 1 | 1 | 0 | |
| N 3 | Guangzhou province | 1 | 0 | 1 | 1 | 0 | |
| … | … | … | |||||
| N n | 0 | 0 | 0 | 0 | 0 |
Further, the normalization function is:
wherein N is n Representing a user code;
T n representing a preset time granularity;
f(N n ，T n ) Represents N n User is at T n Accumulating the numerical value of the access system platform by preset time granularity;
n is a positive integer;
and F is 0 or 1, wherein the value 1 is an integer after F operation.
The rounding-up operation of the normalization function is called the CEILING function and is expressed by a gamma. And taking an integer for the operated value, for example, the operated value is 0.6, and the rounding results in 1, which indicates that the user has access to the system platform at the corresponding time granularity.
A statistical step: and mapping the matrix table after the normalization processing to a data table of the system platform for data statistics, and generating a data analysis report to show the activity of a user accessing the system platform.
Because the matrix table after normalization processing records the access conditions of the users at each time granularity every day, the data are relatively dispersed, and the user data generated by the behavior habits of the users accessing the system platform every day need to be integrated and connected in series. Therefore, in this embodiment, the data recorded and normalized in the matrix table every day is mapped to the data table, the user data including year, month, day, hour, and quarter hour is generated, and the data is stored in the database.
In this embodiment, the data analysis report includes analysis results of counting the activity of the user in multiple ways. By utilizing the data table of the system platform, the number of users accessing the system platform in each area at each moment can be more accurately counted, and the specific users in each area at each moment are in an active state. The analysis report may be visually presented as a bar chart, line chart, pie chart, or the like.
In one embodiment, the statistical results are reported as a data analysis: user N 1 The system platform is accessed more than 10 times per day on average in january, with the maximum probability of 10 points per day accessing the system platform. And as user N 3 The concentration is T within 20 days 1 Accessing the system platform at a moment (e.g., 10 am. one quarter) to determine the userN 3 Is used to at T 1 Using the system platform for business operation at a moment (e.g. 10 am. one quarter), or user N 3 At T 1 The probability of using the system platform at a moment in time (e.g., 10 am. a quarter of a hour) is high.
Further, the mapping of the matrix table to the data table of the system platform for data statistics includes:
counting the user access amount of each time granularity;
counting the user access amount of each time granularity in different areas; and
and counting the user access amount of each area.
In this embodiment, the preset time granularity is refined to one quarter, and the condition that each quarter user accesses the system platform is counted, including the areas that the user accesses and the user access amount of each time granularity of different areas, and the like. The statistics also include the operating time for each month the user centrally accesses the system platform.
Referring to FIG. 2, a block diagram of a preferred embodiment of the data processing program 10 of FIG. 1 is shown.
In one embodiment, the data processing program 10 includes: the device comprises a receiving module 101, an aggregation module 102, a calculation module 103 and a statistic module 104. The functions or operation steps implemented by the modules 101 and 104 are similar to the following user activity data statistics method, which is not detailed here, for example, among them:
a receiving module 101, configured to receive an operation of a user accessing a system platform through a terminal, and generate user information including operation time, a user IP, and a user code, where the user IP is associated with an area where the user is located;
the aggregation module 102 is configured to accumulate, according to the operation time in the user information, the number of times that the user accesses the system platform according to a preset time granularity, and record accumulated data and an area where the user is located in a preset matrix table, where the matrix table is composed of the user code, the area where the user is located, and the preset time granularity;
the calculation module 103 is configured to perform normalization operation on the data in the matrix table by using a normalization function to obtain a matrix table subjected to normalization processing; and
and the statistical module 104 is configured to map the matrix table after the normalization processing to a data table of the system platform for data statistics, and generate a data analysis report to show the activity of the user accessing the system platform.
Further, referring to fig. 3, a block diagram of another preferred embodiment of the data processing program 10 of fig. 1 is shown. After the statistics module 104, the corpus processing program 10 further includes a pushing module 105, which exemplarily:
the pushing module 105 is configured to determine user access amounts of each region and time granularity of the system platform according to the generated data analysis report, and push preset service information to a target region and a terminal of the time granularity in a preset time period.
Referring to fig. 4, a flow chart of a user activity data statistical method according to a preferred embodiment of the present invention is shown. The invention discloses a user activity data statistical method, which is applied to the electronic device and comprises the following steps:
step S210, receiving the operation of the user accessing the system platform through the terminal, and generating the user information including the operation time, the user IP and the user code, wherein the user IP is associated with the area where the user is located.
In one embodiment, a user logs in a system platform (e.g., an automobile transaction system) to operate through a terminal (e.g., a mobile phone terminal or a computer terminal), the system platform determines a user IP according to a region where the user logs in, and correspondingly associates the user IP with the region where the user is located (e.g., beijing, shanghai, guangzhou, etc.), the system platform records the current operation time of the user according to the user operation, and meanwhile, the system platform generates a user code for each accessed user according to a preset number so as to better arrange and arrange user information.
Further, the terminal comprises a mobile phone terminal and a computer terminal;
when receiving the operation that a user accesses a system platform through a mobile phone terminal, analyzing the area of the current mobile phone terminal and determining the IP of the user; and
and when receiving the operation that the user accesses the system platform through the computer terminal, determining the user IP according to the IP address of the network signal connected with the computer terminal.
Step S220, accumulating the times of accessing the system platform by the user according to the operation time in the user information and the preset time granularity, and recording the accumulated data and the area where the user is located into a preset matrix table, wherein the preset matrix table is composed of the user code, the area where the user is located and the preset time granularity.
In this embodiment, in order to fully know the specific time when the user uses the system platform, the preset time granularity is divided into 96 equal parts according to a period of 15 minutes for refinement (that is, the preset time granularity is divided into 96 equal parts every 24 hours), so that the behavior habits of logging and operation of the user on the system platform are enhanced and monitored, the system platform is facilitated to better manage and accurately push information, and the timeliness of pushing service information at fixed points and at fixed times is improved.
The preset matrix table is composed of user codes, areas where the users are located and preset time granularity. And representing the corresponding user by the column where the user code is positioned, representing the corresponding user IP by the column where the area where the user is positioned, arranging the preset time granularity in a horizontal row sequence according to 96 equal parts, and establishing a preset matrix table of the time granularity of the area where the user is positioned.
For example, with N n Representing user code, T n Representing the preset time granularity, and P representing the area where the user is located, and constructing the following initial matrix table:
| P | T 1 | T 2 | T 3 | T 3 | … | T n | |
| N 1 | beijing | 0 | 0 | 0 | 0 | 0 | |
| N 2 | Shanghai province | 0 | 0 | 0 | 0 | 0 | |
| N 3 | Guangzhou province | 0 | 0 | 0 | 0 | 0 | |
| … | … | … | |||||
| N n | 0 | 0 | 0 | 0 | 0 |
In one embodiment, the user accesses the partial data of the system flat record as the following matrix table:
| P | T 1 | T 2 | T 3 | T 3 | … | T n | |
| N 1 | beijing | 3 | 0 | 1 | 5 | 0 | |
| N 2 | Shanghai province | 1 | 2 | 3 | 4 | 0 | |
| N 3 | Guangzhou province | 5 | 0 | 2 | 3 | 0 | |
| … | … | … | |||||
| N n | 0 | 0 | 0 | 0 | 0 |
Step S230, performing normalization operation on the data in the preset matrix table by using a normalization function to obtain a matrix table subjected to normalization processing.
In this embodiment, the cumulative value corresponding to each time granularity recorded in the preset matrix table is subjected to normalization operation to obtain a value of 0 or 1 to represent whether the user accesses the system platform (for example, an automobile transaction platform) at the corresponding time granularity, and when the value obtained by the operation is 0, the user does not access the system platform at the corresponding time granularity; and when the value obtained by the operation is 1, the user accesses the system platform at the corresponding time granularity, and the matrix table is updated by the operated numerical value.
For example, part of the data of the matrix table after the normalization process is as follows:
| P | T 1 | T 2 | T 3 | T 3 | … | T n | |
| N 1 | beijing | 1 | 0 | 1 | 1 | 0 | |
| N 2 | Shanghai province | 1 | 1 | 1 | 1 | 0 | |
| N 3 | Guangzhou province | 1 | 0 | 1 | 1 | 0 | |
| … | … | … | |||||
| N n | 0 | 0 | 0 | 0 | 0 |
Further, the normalization function is:
wherein N is n Representing a user code;
T n representing a preset time granularity;
f(N n ，T n ) Represents N n User is at T n Accumulating the numerical value of the access system platform by preset time granularity;
n is a positive integer;
f is 0 or 1, wherein the value 1 is an integer after F operation.
The rounding-up operation of the normalization function is called the CEILING function and is expressed by a gamma. And taking an integer for the operated value, for example, the operated value is 0.6, and the rounding results in 1, which indicates that the user has access to the system platform at the corresponding time granularity.
And S240, mapping the matrix table after the normalization processing to a data table of the system platform for data statistics, and generating a data analysis report to show the activity of the user accessing the system platform.
Because the matrix table after normalization processing records the access conditions of the users at each time granularity every day, the data are relatively dispersed, and the user data generated by the behavior habit of accessing the system platform every day by the users needs to be integrated and connected in series. Therefore, in this embodiment, the data recorded and normalized in the matrix table every day is mapped to the data table, the user data including year, month, day, hour, and quarter hour is generated, and the data is stored in the database.
In this embodiment, the data analysis report includes analysis results of counting the activity of the user in multiple ways. By utilizing the data table of the system platform, the number of users accessing the system platform in each area at each moment can be more accurately counted, and the specific users in each area at each moment are in an active state. The analysis report may be visually presented as a bar chart, line chart, pie chart, or the like.
In one embodiment, the statistical results are reported as a data analysis: user N 1 The system platform is accessed more than 10 times per day on average in january, with the maximum probability of 10 points per day accessing the system platform. And as user N 3 The concentration of T is within 20 days 1 The system platform is accessed at the moment (for example, 10 o' clock in the morning) to judge the user N 3 Is used to at T 1 Using the system platform for business operation at a moment (e.g. 10 am. one quarter), or user N 3 At T 1 The probability of using the system platform at a moment in time (e.g., 10 am. a.quarter of a hour) is high.
Further, mapping the matrix table to the data table of the system platform for data statistics comprises:
counting the user access amount of each time granularity;
counting the user access amount of each time granularity in different areas; and
and counting the user access amount of each area.
In this embodiment, the preset time granularity is refined to one quarter, and the condition that each quarter user accesses the system platform is counted, including the areas that the user accesses and the user access amount of each time granularity of different areas, and the like. Statistics also include the operating time of the user to access the system platform centrally per month.
Further, referring to fig. 5, a flow chart of another preferred embodiment of the statistical method for user activity data according to the present invention is shown. After the step S240, the method further includes:
step S250, according to the generated data analysis report, determining user access amount of each region and time granularity of the system platform, and pushing preset service information to a target region and a terminal of the time granularity in a preset time period.
In one embodiment, according to the generated data analysis report, the activity of the users of the system platform in different areas and different time granularities is shown, the user access amount of each area and time granularity is visually shown through a chart (e.g. a histogram, a pie chart), and the like. The user access amount inquired according to the service requirement can be further used for determining when and where to push the service message (such as advertisement, information or notification and the like) to the user, and further the system platform is assisted to improve timeliness of service message pushing.
Furthermore, the present invention also provides a computer-readable storage medium, which includes a data processing program, and when the data processing program is executed by a processor, the data processing program can implement the following operations:
a receiving step: receiving the operation of a user accessing a system platform through a terminal, and generating user information comprising operation time, a user IP and a user code, wherein the user IP is associated with an area where the user is located;
a polymerization step: accumulating the times of accessing the system platform by the user according to the operation time in the user information and preset time granularity, and recording the accumulated data and the area where the user is located into a preset matrix table, wherein the preset matrix table consists of the user code, the area where the user is located and the preset time granularity;
a calculation step: carrying out normalization operation on the data in the preset matrix table by using a normalization function to obtain a matrix table subjected to normalization processing; and
a statistical step: and mapping the matrix table after the normalization processing to a data table of the system platform for data statistics, and generating a data analysis report to show the activity of a user accessing the system platform.
The embodiment of the computer-readable storage medium of the present invention is substantially the same as the embodiments of the user activity data statistics method and the electronic device, and will not be described herein again.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, apparatus, article, or method that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, apparatus, article, or method. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, apparatus, article, or method that includes the element.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. A statistical method for user activity data is applied to an electronic device, and is characterized in that the method comprises the following steps:
a receiving step: receiving the operation of a user accessing a system platform through a terminal, and generating user information comprising operation time, a user IP and a user code, wherein the user IP is associated with an area where the user is located;
a polymerization step: accumulating the times of accessing the system platform by the user according to the operation time in the user information and preset time granularity, and recording the accumulated data and the area where the user is located into a preset matrix table, wherein the preset matrix table consists of the user code, the area where the user is located and the preset time granularity;
and (3) calculating: carrying out normalization operation on the data in the preset matrix table by using a normalization function to obtain a matrix table subjected to normalization processing; and
a statistical step: and mapping the matrix table after the normalization processing to a data table of the system platform for data statistics, and generating a data analysis report to show the activity of a user accessing the system platform.
2. The method according to claim 1, wherein the terminals include a mobile phone terminal and a computer terminal;
when receiving the operation that a user accesses a system platform through a mobile phone terminal, analyzing the area of the current mobile phone terminal to determine the IP of the user; and
and when receiving the operation that the user accesses the system platform through the computer terminal, determining the user IP according to the IP address of the network signal connected with the computer terminal.
3. The user activity data statistics method of claim 1, characterized in that the normalization function is:
wherein, N n Representing a user code;
T n representing a preset time granularity;
f(N n ,T n ) Represents N n User granularity T at preset time n Accumulating the times of accessing the system platform;
n is a positive integer;
f is 0 or 1, wherein the value 1 is an integer after F operation.
4. The method for counting user activity data as claimed in claim 1, wherein the mapping of the matrix table to the data table of the system platform for data counting comprises:
counting the user access amount of each time granularity;
counting the user access amount of each time granularity in different areas; and
and counting the user access amount of each area.
5. The method of user activity data statistics of any of claims 1-4, wherein after the step of counting, the method further comprises:
a pushing step: and determining the user access amount of each region and time granularity of the system platform according to the generated data analysis report, and pushing preset service information to a target region and a terminal of the time granularity in a preset time period.
6. An electronic device, comprising a memory and a processor, wherein the memory stores a data processing program operable on the processor, and the data processing program, when executed by the processor, performs the steps of:
a receiving step: receiving the operation of a user accessing a system platform through a terminal, and generating user information comprising operation time, a user IP and a user code, wherein the user IP is associated with an area where the user is located;
a polymerization step: accumulating the times of accessing the system platform by the user according to the operation time in the user information and preset time granularity, and recording the accumulated data and the area where the user is located into a preset matrix table, wherein the preset matrix table consists of the user code, the area where the user is located and the preset time granularity;
a calculation step: carrying out normalization operation on the data in the preset matrix table by using a normalization function to obtain a matrix table subjected to normalization processing; and
a statistical step: and mapping the matrix table after the normalization processing to a data table of the system platform for data statistics, and generating a data analysis report to show the activity of a user accessing the system platform.
7. The electronic device of claim 6, wherein the terminal comprises a mobile phone terminal and a computer terminal;
when receiving the operation that a user accesses a system platform through a mobile phone terminal, analyzing the area of the current mobile phone terminal to determine the IP of the user; and
and when receiving the operation that the user accesses the system platform through the computer terminal, determining the user IP according to the IP address of the network signal connected with the computer terminal.
8. The electronic device of claim 6, wherein the normalization function is:
wherein N is n Representing a user code;
T n representing a preset time granularity;
f(N n ,T n ) Represents N n User granularity T at preset time n Accumulating the times of accessing the system platform;
n is a positive integer;
f is 0 or 1, wherein the value 1 is an integer after F operation.
9. The electronic device of claim 6, wherein the mapping of the matrix table to the data table of the system platform for data statistics comprises:
counting the user access amount of each time granularity;
counting the user access amount of each time granularity in different areas; and
and counting the user access amount of each area.
10. A computer-readable storage medium, comprising a data processing program, which when executed by a processor, implements the steps of the user activity data statistical method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911180242.2A CN111131393B (en) | 2019-11-25 | 2019-11-25 | User activity data statistical method, electronic device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911180242.2A CN111131393B (en) | 2019-11-25 | 2019-11-25 | User activity data statistical method, electronic device and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111131393A CN111131393A (en) | 2020-05-08 |
| CN111131393B true CN111131393B (en) | 2022-08-16 |
Family
ID=70496806
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911180242.2A Active CN111131393B (en) | 2019-11-25 | 2019-11-25 | User activity data statistical method, electronic device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111131393B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103544212A (en) * | 2013-09-09 | 2014-01-29 | Tcl集团股份有限公司 | Content recommending method and system |
| CN106161553A (en) * | 2015-04-16 | 2016-11-23 | 腾讯科技（深圳）有限公司 | Community application information-pushing method and system |
| CN108259421A (en) * | 2016-12-29 | 2018-07-06 | 沈阳美行科技有限公司 | The statistical method and system of a kind of user activity |
| CN108306936A (en) * | 2017-12-28 | 2018-07-20 | 深圳市创梦天地科技股份有限公司 | User's indicator-specific statistics method and server |
| CN108470050A (en) * | 2018-03-09 | 2018-08-31 | 吉林农业大学 | A kind of space-time of facing agricultural internet web resource recommends method and system |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103812961B (en) * | 2013-11-01 | 2016-08-17 | 北京奇虎科技有限公司 | Identify and specify the method and apparatus of classification IP address, defence method and system |
| CN105824840B (en) * | 2015-01-07 | 2019-07-16 | 阿里巴巴集团控股有限公司 | A kind of method and device for area label management |
-
2019
- 2019-11-25 CN CN201911180242.2A patent/CN111131393B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103544212A (en) * | 2013-09-09 | 2014-01-29 | Tcl集团股份有限公司 | Content recommending method and system |
| CN106161553A (en) * | 2015-04-16 | 2016-11-23 | 腾讯科技（深圳）有限公司 | Community application information-pushing method and system |
| CN108259421A (en) * | 2016-12-29 | 2018-07-06 | 沈阳美行科技有限公司 | The statistical method and system of a kind of user activity |
| CN108306936A (en) * | 2017-12-28 | 2018-07-20 | 深圳市创梦天地科技股份有限公司 | User's indicator-specific statistics method and server |
| CN108470050A (en) * | 2018-03-09 | 2018-08-31 | 吉林农业大学 | A kind of space-time of facing agricultural internet web resource recommends method and system |
Non-Patent Citations (1)
| Title |
|---|
| Web服务器区域访问流量预测模型设计;周咏梅等;《计算机工程与应用》;20040301(第03期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111131393A (en) | 2020-05-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110008257B (en) | Data processing method, device, system, computer equipment and storage medium | |
| CN108615119B (en) | Abnormal user identification method and equipment | |
| CN108415952B (en) | User data storage method, label calculation method and calculation equipment | |
| CN105827706B (en) | Message pushing device and method | |
| CN110781372B (en) | Method and device for optimizing website, computer equipment and storage medium | |
| CN107807967B (en) | Real-time recommendation method, electronic device and computer-readable storage medium | |
| CN112860737B (en) | Data query method and device, electronic equipment and readable storage medium | |
| CN111159183B (en) | Report generation method, electronic device and computer readable storage medium | |
| CN112416972A (en) | Real-time data stream processing method, device, equipment and readable storage medium | |
| CN110162540B (en) | Block chain account book data query method, electronic device and storage medium | |
| CN110851758B (en) | Webpage visitor quantity counting method and device | |
| CN112860808A (en) | User portrait analysis method, device, medium and equipment based on data tag | |
| CN111131393B (en) | User activity data statistical method, electronic device and storage medium | |
| CN112463799A (en) | Data extraction method, device, equipment and storage medium | |
| CN111881252A (en) | Work report processing method and device, computer equipment and storage medium | |
| CN111459987A (en) | Cache updating method and device | |
| CN113342822B (en) | Data query method and device based on multi-type database, electronic equipment and medium | |
| CN111339105B (en) | Data storage method, device and server | |
| CN114791914A (en) | User behavior statistical method, device, equipment and medium based on Bitmap | |
| US10558647B1 (en) | High performance data aggregations | |
| CN116382924B (en) | Recommendation method and device for resource allocation, electronic equipment and storage medium | |
| CN112860755B (en) | Service identifier generation method, device, computer equipment and medium | |
| CN110753260B (en) | Advertisement data monitoring method and device, computer equipment and storage medium | |
| CN111737281B (en) | Database query method, device, electronic equipment and readable storage medium | |
| CN111881091A (en) | Data storage method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |