CN109376192A - A kind of user retains analysis method, device, electronic equipment and storage medium - Google Patents
A kind of user retains analysis method, device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN109376192A CN109376192A CN201811102107.1A CN201811102107A CN109376192A CN 109376192 A CN109376192 A CN 109376192A CN 201811102107 A CN201811102107 A CN 201811102107A CN 109376192 A CN109376192 A CN 109376192A
- Authority
- CN
- China
- Prior art keywords
- access
- data
- user
- information
- tables
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/31—Programming languages or programming paradigms
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computing Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention provides a kind of users to retain analysis method, device, electronic equipment and storage medium, which comprises obtains the access data information of access target platform in preset time period；According to the access data information of acquisition, using the function processing mode of database, the user for obtaining the target platform retains situation.User provided by the invention retains analysis method, and the user for solving daily middle-size and small-size data using database low threshold retains problem analysis, and entire analytic process is simple and convenient easy to maintain.
Description
Technical field
The present invention relates to field of computer technology, and in particular to a kind of user retain analysis method, device, electronic equipment and
Storage medium.
Background technique
User's retention ratio, which refers to, registers the probability that the user of certain platform retains in the platform.It is soft for game, social activity
Part provides the business platforms such as service APP, and analysis user retains situation, is formulating product sale and publicity strategy for policymaker
Aspect can be provided and accurately and effectively be supported.
Currently, there are mainly two types of the calculation methods of user's retention ratio.One is utilize python, java or any one
Language does intersection using program data aggregate attribute and calculates realization.The shortcomings that this kind of processing mode is that there are memory spillings
A possibility that.Another kind is transported in the way of big data hadoop currently popular or spark borrow mapreduce
It calculates.The shortcomings that this kind of processing mode is to need to provide relevant big data platform basic environment, and threshold is relatively high.
Summary of the invention
For the problems of the prior art, the present invention provides a kind of user and retains analysis method, device, electronic equipment and deposit
Storage media.
Specifically, the present invention the following technical schemes are provided:
In a first aspect, the present invention provides a kind of users to retain analysis method, comprising:
Obtain the access data information of access target platform in preset time period；
The use of the target platform is obtained using the function processing mode of database according to the access data information of acquisition
Retain situation in family.
Further, the access data information for obtaining access target platform in preset time period, specifically includes:
Obtain the access user id information of access target platform in preset time period, access time information and access user
Sources information.
Further, the access data information according to acquisition, using the function processing mode of database, described in acquisition
The user of target platform retains situation, specifically includes:
According to access user id information, access time information and the visit of access target platform in the preset time period of acquisition
It asks user sources channel information, using the function processing mode of database, obtains the access user from separate sources channel and exist
The different retention ratios retained in number of days.
Further, the access user id information of access target platform, access in the preset time period according to acquisition
Temporal information and the sources information for accessing user obtain using the function processing mode of database and come from separate sources
The access user of channel specifically includes in the different retention ratios retained in number of days:
According to access user id information, access time information and the visit of access target platform in the preset time period of acquisition
The sources information for asking user, daily independently access user's re-scheduling；
The first tables of data is established according to the data after re-scheduling；Wherein, including at least in the first tables of data has access User ID
Field, access time field and access user sources channel field；
The second tables of data is established according to presupposition analysis demand；Wherein, it is included at least in the second tables of data with good grounds described pre-
If the retention analysis time field that the demand of analysis determines, access user sources channel field and true according to the presupposition analysis demand
Several fixed differences retain day digital section, wherein right under corresponding retention number of days for being stored under each retention day digital section
The retention number answered；
According to the data in first tables of data, using the function processing mode of database, to second tables of data
It is updated, is stayed so that the access user from separate sources channel can be embodied in updated second tables of data in different
Deposit the retention number in number of days；
According to the access user from separate sources channel stored in updated second tables of data in different retentions
Retention number in number of days calculates the access user from separate sources channel in the different retention ratios retained in number of days.
Further, the data according in first tables of data, using the function processing mode of database, to institute
It states the second tables of data to be updated, be used so that the access from separate sources channel can be embodied in updated second tables of data
Family is specifically included in the different retention numbers retained in number of days:
Delete the related data that the analysis same day is retained in the second tables of data；
According to the data in first tables of data, the data initialization that the retention analysis same day is needed to second number
According in table；
For the different retention number of days set in second tables of data, using data base querying function to first number
Condition query operation is carried out according to table, obtains the access user from separate sources channel in the different retention people retained in number of days
Number；
Using database update function, by the staying in different retention number of days of the access user from separate sources channel
The number of depositing is updated in second tables of data.
Second aspect, the present invention also provides a kind of users to retain analytical equipment, comprising:
Module is obtained, for obtaining the access data information of access target platform in preset time period；
Analysis module is retained, is obtained for the access data information according to acquisition using the function processing mode of database
The user of the target platform retains situation.
Further, the acquisition module, is specifically used for:
Obtain the access user id information of access target platform in preset time period, access time information and access user
Sources information.
Further, the retention analysis module, is specifically used for:
According to access user id information, access time information and the visit of access target platform in the preset time period of acquisition
It asks user sources channel information, using the function processing mode of database, obtains the access user from separate sources channel and exist
The different retention ratios retained in number of days.
The third aspect, the present invention also provides a kind of electronic equipment, including memory, processor and storage are on a memory
And the computer program that can be run on a processor, the processor realize user as described in relation to the first aspect when executing described program
The step of retaining analysis method.
Fourth aspect, the present invention also provides a kind of computer readable storage mediums, are stored thereon with computer program, should
The step of user retains analysis method as described in relation to the first aspect is realized when computer program is executed by processor.
By prior art scheme it is found that user provided by the invention retains analysis method, firstly, obtaining in preset time period
The access data information of access target platform utilizes the function processing side of database then according to the access data information of acquisition
Formula, the user for obtaining the target platform retain situation.User provided by the invention retains analysis method, utilizes database and number
According to the function processing mode in library, the user for solving to low threshold daily middle-size and small-size data retains problem analysis, and entire analysis
Process is simple and convenient easy to maintain.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is the present invention
Some embodiments for those of ordinary skill in the art without creative efforts, can also basis
These attached drawings obtain other attached drawings.
Fig. 1 is the flow chart that the user that one embodiment of the invention provides retains analysis method；
Fig. 2 is the schematic diagram for the first tables of data that one embodiment of the invention provides；
Fig. 3 is the schematic diagram for the second tables of data that one embodiment of the invention provides；
Fig. 4 is the treatment process schematic illustration that the user that one embodiment of the invention provides retains analysis method；
Fig. 5 be another embodiment of the present invention provides user retain analytical equipment structural schematic diagram；
Fig. 6 is the structural schematic diagram for the electronic equipment that further embodiment of this invention provides.
Specific embodiment
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention
In attached drawing, the technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is
A part of the embodiment of the present invention, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art
Every other embodiment obtained without creative efforts, shall fall within the protection scope of the present invention.
One embodiment of the invention provides a kind of user's retention analysis method, and referring to Fig. 1, this method comprises the following steps:
Step 101: obtaining the access data information of access target platform in preset time period.
In this step, the access data information of access target platform in preset time period is obtained, for example, obtaining nearest two
The access data information of access target platform in a month, wherein access data information includes at least the User ID letter of access user
Breath, access time information and access user sources channel information.
Here, the target platform can for certain gaming platform or certain social platform (such as wechat, QQ, microblogging,
Know), can also be certain service providing platform (such as Taobao, Dong Dong, only product meeting, drop are dripped).
Step 102: the target is obtained using the function processing mode of database according to the access data information of acquisition
The user of platform retains situation.
In this step, the mesh is obtained using the function processing mode of database according to the access data information of acquisition
The user for marking platform retains situation.For example, the access data information that will acquire by way of establishing database and tables of data into
Then row storage utilizes the condition query function of database, insertion function, the deletion databases letter such as function and/or renewal function
Number, handles the tables of data for being stored with user accesses data information, will meet the default user for retaining analysis condition and retains
Data are taken out and are written into another new data table, thus the user of the target platform according to the data acquisition in new data table
Retain situation.As it can be seen that the processing mode can be realized dexterously by means of the own mechanism of database using database script
User retains analysis, and entire analytic process it is simple, efficiently, dynamic, maintainability it is strong, be particularly suitable for daily middle-size and small-size data
User retains analysis
As seen from the above description, user provided in this embodiment retains analysis method, visits in acquisition preset time period first
Ask the access data information of target platform, then according to the access data information of acquisition, using the function processing mode of database,
The user for obtaining the target platform retains situation.As it can be seen that user provided in this embodiment retains analysis method, dexterously utilize
The function processing mode of database and database, the user for solving to low threshold daily middle-size and small-size data retain problem analysis,
And entirely analytic process is simple and convenient easy to maintain.
In order to which aid decision making person selects the higher user sources channel of quality, also in order to the matter of determining user sources channel
Amount, the retention ratio height for analyzing the user to come in from different sources becomes a kind of effective means, therefore, in a kind of preferred reality
Apply in mode, above-mentioned steps 101 in the acquisition of a preset period of time the access data information of access target platform when, at least need to obtain
Take access user id information, access time information and the access user sources channel letter of access target platform in preset time period
Breath.
Correspondingly, it is based on above content, obtains the access user from separate sources channel in different retention number of days
Retention ratio, which is then judged according to retention ratio of the access user from separate sources channel in different retention number of days
User sources channel is the user sources channel of high quality, and therefore, in a preferred embodiment, above-mentioned steps 102 are specific
It is accomplished in that
According to access user id information, access time information and the visit of access target platform in the preset time period of acquisition
It asks user sources channel information, using the function processing mode of database, obtains the access user from separate sources channel and exist
The different retention ratios retained in number of days.
Based on above content, in a preferred embodiment, access target in the above-mentioned preset time period according to acquisition
Access user's id information, access time information and the sources information for accessing user of platform, utilize the function of database
Processing mode obtains the access user from separate sources channel in the different retention ratios retained in number of days, especially by such as
Lower process a~e is realized:
A, according to the access user id information of access target platform in the preset time period of acquisition, access time information and
The sources information of user is accessed, daily independently access user's re-scheduling.
B, the first tables of data is established (as shown in Fig. 2, Fig. 2 is the data intercepted from database according to the data after re-scheduling
It indicates to be intended to)；Wherein, including at least in the first tables of data has access user's id field (user_id), access time field
(atime) and user sources channel field (platform_id) is accessed.
C, the second tables of data is established (as shown in figure 3, Fig. 3 is the data intercepted from database according to presupposition analysis demand
It indicates to be intended to)；Wherein, the retention analysis time word that the with good grounds presupposition analysis demand determines is included at least in the second tables of data
Section (atime), access user sources channel field (platform_id) and several determined according to the presupposition analysis demand
Difference retains day digital section (di), wherein for being stored in corresponding under corresponding retention number of days stay under each retention day digital section
Deposit number, namely it is different retain for storing retention number of the d0 at i-th day in day digital section (di), such as the d1 in Fig. 3,
D2 ..., d13, wherein for storing retention number of the d0 at first day under d1 field, be used to store d0 second under d2 field
It retention number, for storing retention number of the d0 at the 12nd day under d12 field, and so on.It should be noted that d0
The analysis same day corresponding number of persons logging is retained for storing under field.
D, according to the data in first tables of data, using the function processing mode of database, to second data
Table is updated, so that can embody the access user from separate sources channel in updated second tables of data different
Retain the retention number in number of days.
E, it is stayed according to the access user from separate sources channel stored in updated second tables of data in different
The retention number in number of days is deposited, calculates the access user from separate sources channel in the different retention ratios retained in number of days.
Based on above content, in a preferred embodiment, above-mentioned steps d is real especially by following subprocess d1~d4
It is existing:
D1, the related data that the analysis same day is retained in the second tables of data are deleted.
D2, according to the data in first tables of data, data initialization that the analysis same day needs will be retained to described the
In two tables of data.
D3, for set in second tables of data it is different retain number of days, using data base querying function to described the
One tables of data carries out condition query operation, obtains the staying in different retention number of days of the access user from separate sources channel
Deposit number.
D4, using database update function, by the access user from separate sources channel in different retention number of days
Retention number be updated in second tables of data.
One piece of data library script is given below to be illustrated to above process d1~d4.
As be analyzed above and Fig. 4 shown in content it is found that the present embodiment by establishing the first tables of data T1 and the second data
Table T2, using database processing function, database script need to only be utilized by realizing user's retention analysis namely the present embodiment
Realize that user retains analysis.In addition, database sql scripting language can be controlled 10 it can be seen from examples provided above
Within row, realize that process is simple and convenient easy to maintain.It should be noted that the present embodiment is without writing relational language code for example
Java, python etc., without big data (such as hadoop) platform base environment is provided, the present embodiment is dexterously by database
Own mechanism, realize to high-efficiency dynamic user retain analysis.Further, since user provided in this embodiment retains analysis side
Method realizes that entire analytic process is simple and convenient easy to maintain, therefore can be with low threshold using database and database processing function
Ground solves user and retains problem analysis, and the user for being particularly suitable for daily middle-size and small-size data retains analysis.
It should be noted that multiple preferred embodiments given by the present embodiment, do not conflict mutually in logic or structure
Under the premise of, it can be freely combined, which is not limited by the present invention.
Based on identical inventive concept, another embodiment of the present invention provides a kind of users to retain analytical equipment, referring to figure
5, which includes: to obtain module 21 and retention analysis module 22；Wherein:
Module 21 is obtained, for obtaining the access data information of access target platform in preset time period；
Analysis module 22 is retained, is obtained for the access data information according to acquisition using the function processing mode of database
The user of the target platform is taken to retain situation.
In a preferred embodiment, the acquisition module 21, is specifically used for:
Obtain the access user id information of access target platform in preset time period, access time information and access user
Sources information.
In a preferred embodiment, the retention analysis module 22, is specifically used for:
According to access user id information, access time information and the visit of access target platform in the preset time period of acquisition
It asks user sources channel information, using the function processing mode of database, obtains the access user from separate sources channel and exist
The different retention ratios retained in number of days.
In a preferred embodiment, the retention analysis module 22, is specifically used for:
According to access user id information, access time information and the visit of access target platform in the preset time period of acquisition
The sources information for asking user, daily independently access user's re-scheduling；
The first tables of data is established according to the data after re-scheduling；Wherein, including at least in the first tables of data has access User ID
Field, access time field and access user sources channel field；
The second tables of data is established according to presupposition analysis demand；Wherein, it is included at least in the second tables of data with good grounds described pre-
If the retention analysis time field that the demand of analysis determines, access user sources channel field and true according to the presupposition analysis demand
Several fixed differences retain day digital section, wherein right under corresponding retention number of days for being stored under each retention day digital section
The retention number answered；
According to the data in first tables of data, using the function processing mode of database, to second tables of data
It is updated, is stayed so that the access user from separate sources channel can be embodied in updated second tables of data in different
Deposit the retention number in number of days；
According to the access user from separate sources channel stored in updated second tables of data in different retentions
Retention number in number of days calculates the access user from separate sources channel in the different retention ratios retained in number of days.
In a preferred embodiment, the retention analysis module 22, according to the data in first tables of data,
Using the function processing mode of database, second tables of data is updated, so that energy in updated second tables of data
Enough access users embodied from separate sources channel are specifically used in the different retention numbers retained in number of days:
Delete the related data that the analysis same day is retained in the second tables of data；
According to the data in first tables of data, the data initialization that the retention analysis same day is needed to second number
According in table；
For the different retention number of days set in second tables of data, using data base querying function to first number
Condition query operation is carried out according to table, obtains the access user from separate sources channel in the different retention people retained in number of days
Number；
Using database update function, by the staying in different retention number of days of the access user from separate sources channel
The number of depositing is updated in second tables of data.
It can be used for executing described in above-described embodiment it should be noted that user provided in this embodiment retains analytical equipment
User retain analysis method, working principle is similar with technical effect, and for details, reference can be made to the descriptions of above-described embodiment, herein not
It is described in detail again.
Based on identical inventive concept, further embodiment of this invention provides a kind of electronic equipment, referring to Fig. 6, the electricity
Sub- equipment specifically includes following content: processor 701, memory 702, communication interface 703 and bus 704；
Wherein, the processor 701, memory 702, communication interface 703 complete mutual lead to by the bus 704
Letter；The communication interface 703 is for realizing the information between the relevant devices such as each modeling software and intelligent manufacturing equipment module library
Transmission；
The processor 701 is used to call the computer program in the memory 702, and the processor executes the meter
The Overall Steps in above-described embodiment one are realized when calculation machine program, for example, reality when the processor executes the computer program
Existing following step:
Step 101: obtaining the access data information of access target platform in preset time period.
Step 102: the target is obtained using the function processing mode of database according to the access data information of acquisition
The user of platform retains situation.
Based on identical inventive concept, further embodiment of this invention provides a kind of computer readable storage medium, the meter
It is stored with computer program on calculation machine readable storage medium storing program for executing, which realizes above-described embodiment one when being executed by processor
Overall Steps, for example, the processor execute the computer program when realize following step:
Step 101: obtaining the access data information of access target platform in preset time period.
Step 102: the target is obtained using the function processing mode of database according to the access data information of acquisition
The user of platform retains situation.
It should be noted that, in this document, relational terms such as first and second and the like are used merely to a reality
Body or operation are distinguished with another entity or operation, are deposited without necessarily requiring or implying between these entities or operation
In any actual relationship or order or sequence.Moreover, the terms "include", "comprise" or its any other variant are intended to
Non-exclusive inclusion, so that the process, method, article or equipment including a series of elements is not only wanted including those
Element, but also including other elements that are not explicitly listed, or further include for this process, method, article or equipment
Intrinsic element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that
There is also other identical elements in process, method, article or equipment including the element.
The above examples are only used to illustrate the technical scheme of the present invention, rather than its limitations；Although with reference to the foregoing embodiments
Invention is explained in detail, those skilled in the art should understand that: it still can be to aforementioned each implementation
Technical solution documented by example is modified or equivalent replacement of some of the technical features；And these are modified or replace
It changes, the spirit and scope for technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution.
Claims (10)
1. a kind of user retains analysis method characterized by comprising
Obtain the access data information of access target platform in preset time period；
According to the access data information of acquisition, using the function processing mode of database, the user for obtaining the target platform is stayed
Deposit situation.
2. the method according to claim 1, wherein the visit for obtaining access target platform in preset time period
It asks data information, specifically includes:
Obtain the access user id information of access target platform in preset time period, access time information and access user sources
Channel information.
3. according to the method described in claim 2, it is characterized in that, the access data information according to acquisition, utilizes data
The function processing mode in library, the user for obtaining the target platform retain situation, specifically include:
It is used according to the access user id information of access target platform, access time information and access in the preset time period of acquisition
Family sources information obtains the access user from separate sources channel in difference using the function processing mode of database
Retain number of days in retention ratio.
4. according to the method described in claim 3, it is characterized in that, access target is flat in the preset time period according to acquisition
Access user's id information, access time information and the sources information for accessing user of platform, at the function of database
Reason mode obtains the access user from separate sources channel in the different retention ratios retained in number of days, specifically includes:
It is used according to the access user id information of access target platform, access time information and access in the preset time period of acquisition
The sources information at family, daily independently access user's re-scheduling；
The first tables of data is established according to the data after re-scheduling；Wherein, in the first tables of data include at least have access user's id field,
Access time field and access user sources channel field；
The second tables of data is established according to presupposition analysis demand；Wherein, with good grounds described default point is included at least in the second tables of data
The determination of analysis demand retains analysis time field, access user sources channel field and according to presupposition analysis demand determination
Several differences retain day digital section, wherein corresponding under corresponding retention number of days for being stored under each retention day digital section
Retention number；
Second tables of data is carried out using the function processing mode of database according to the data in first tables of data
It updates, so that the access user from separate sources channel can be embodied in updated second tables of data in different retention days
Retention number in number；
According to the access user from separate sources channel stored in updated second tables of data in different retention number of days
In retention number, calculate the access user from separate sources channel in the different retention ratios retained in number of days.
5. according to the method described in claim 4, it is characterized in that, the data according in first tables of data, utilize
The function processing mode of database is updated second tables of data, so that being capable of body in updated second tables of data
Now the access user from separate sources channel specifically includes in the different retention numbers retained in number of days:
Delete the related data that the analysis same day is retained in the second tables of data；
According to the data in first tables of data, the data initialization that the retention analysis same day is needed to second tables of data
In；
For the different retention number of days set in second tables of data, using data base querying function to first tables of data
Condition query operation is carried out, obtains the access user from separate sources channel in the different retention numbers retained in number of days；
Using database update function, by the access user from separate sources channel in the different retention people retained in number of days
Number is updated in second tables of data.
6. a kind of user retains analytical equipment characterized by comprising
Module is obtained, for obtaining the access data information of access target platform in preset time period；
Analysis module is retained, for the access data information according to acquisition, using the function processing mode of database, described in acquisition
The user of target platform retains situation.
7. device according to claim 6, which is characterized in that the acquisition module is specifically used for:
Obtain the access user id information of access target platform in preset time period, access time information and access user sources
Channel information.
8. device according to claim 7, which is characterized in that the retention analysis module is specifically used for:
It is used according to the access user id information of access target platform, access time information and access in the preset time period of acquisition
Family sources information obtains the access user from separate sources channel in difference using the function processing mode of database
Retain number of days in retention ratio.
9. a kind of electronic equipment including memory, processor and stores the calculating that can be run on a memory and on a processor
Machine program, which is characterized in that realize that the user as described in any one of claim 1 to 5 stays when the processor executes described program
The step of depositing analysis method.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program quilt
The step of user retains analysis method as described in any one of claim 1 to 5 is realized when processor executes.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811102107.1A CN109376192A (en) | 2018-09-20 | 2018-09-20 | A kind of user retains analysis method, device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811102107.1A CN109376192A (en) | 2018-09-20 | 2018-09-20 | A kind of user retains analysis method, device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109376192A true CN109376192A (en) | 2019-02-22 |
Family
ID=65402157
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811102107.1A Pending CN109376192A (en) | 2018-09-20 | 2018-09-20 | A kind of user retains analysis method, device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109376192A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111709784A (en) * | 2020-06-18 | 2020-09-25 | 北京字节跳动网络技术有限公司 | Method, apparatus, device and medium for generating user retention time |
| CN112036957A (en) * | 2020-09-08 | 2020-12-04 | 广州图普网络科技有限公司 | Visitor persistence number determining method and device, electronic equipment and storage medium |
| CN113821530A (en) * | 2021-09-26 | 2021-12-21 | 北京慧博科技有限公司 | Method for automatically analyzing customer retention rate by using sql |
| CN113821515A (en) * | 2021-09-26 | 2021-12-21 | 北京慧博科技有限公司 | Method for inquiring and analyzing linkage rate based on MySql |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050131966A1 (en) * | 2003-12-15 | 2005-06-16 | Sbc Knowledge Ventures, L.P. | Architecture of database application with robust online recoverability |
| CN106528778A (en) * | 2016-11-04 | 2017-03-22 | 广州华多网络科技有限公司 | Method and device for obtaining user retention data |
| CN106682125A (en) * | 2016-12-13 | 2017-05-17 | 四川长虹电器股份有限公司 | Method for analyzing user retention rate of smart television |
| CN107508917A (en) * | 2017-09-29 | 2017-12-22 | 济南浚达信息技术有限公司 | A kind of web site user activity statistical method and system based on bitmap |
| CN107766454A (en) * | 2017-09-26 | 2018-03-06 | 深圳市金立通信设备有限公司 | A kind of data processing method, server and computer-readable recording medium |
| CN108335132A (en) * | 2018-01-22 | 2018-07-27 | 中国平安人寿保险股份有限公司 | Analysis method, device, storage medium and the terminal of application program |
-
2018
- 2018-09-20 CN CN201811102107.1A patent/CN109376192A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050131966A1 (en) * | 2003-12-15 | 2005-06-16 | Sbc Knowledge Ventures, L.P. | Architecture of database application with robust online recoverability |
| CN106528778A (en) * | 2016-11-04 | 2017-03-22 | 广州华多网络科技有限公司 | Method and device for obtaining user retention data |
| CN106682125A (en) * | 2016-12-13 | 2017-05-17 | 四川长虹电器股份有限公司 | Method for analyzing user retention rate of smart television |
| CN107766454A (en) * | 2017-09-26 | 2018-03-06 | 深圳市金立通信设备有限公司 | A kind of data processing method, server and computer-readable recording medium |
| CN107508917A (en) * | 2017-09-29 | 2017-12-22 | 济南浚达信息技术有限公司 | A kind of web site user activity statistical method and system based on bitmap |
| CN108335132A (en) * | 2018-01-22 | 2018-07-27 | 中国平安人寿保险股份有限公司 | Analysis method, device, storage medium and the terminal of application program |
Non-Patent Citations (1)
| Title |
|---|
| BJLF_1989: ""计算app用户的留存率"", 《HTTPS://BLOG.CSDN.NET/BJLF_1989/ARTICLE/DETAILS/50673357》 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111709784A (en) * | 2020-06-18 | 2020-09-25 | 北京字节跳动网络技术有限公司 | Method, apparatus, device and medium for generating user retention time |
| CN112036957A (en) * | 2020-09-08 | 2020-12-04 | 广州图普网络科技有限公司 | Visitor persistence number determining method and device, electronic equipment and storage medium |
| CN112036957B (en) * | 2020-09-08 | 2023-11-28 | 广州图普网络科技有限公司 | Visitor retention number determining method and device, electronic equipment and storage medium |
| CN113821530A (en) * | 2021-09-26 | 2021-12-21 | 北京慧博科技有限公司 | Method for automatically analyzing customer retention rate by using sql |
| CN113821515A (en) * | 2021-09-26 | 2021-12-21 | 北京慧博科技有限公司 | Method for inquiring and analyzing linkage rate based on MySql |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109376192A (en) | A kind of user retains analysis method, device, electronic equipment and storage medium | |
| CN102316166B (en) | Website recommending method and system and network server | |
| CN104281701B (en) | Multiscale Distributed Spatial data query method and system | |
| CN103049556B (en) | A kind of fast statistical query method of magnanimity medical data | |
| US11277498B2 (en) | Method, apparatus and system for processing data | |
| CN106547766A (en) | A kind of data access method and device | |
| CN104537000B (en) | A kind of method and apparatus for pushed information | |
| CN105493085B (en) | Create method, system and the computer readable storage medium of the sample of database table | |
| CN105869097A (en) | O2O medical information system based on cloud platform | |
| CN107229718A (en) | The method and apparatus for handling report data | |
| CN106055908B (en) | Personal medical information recommended method and system based on cloud computing | |
| CN107908794A (en) | A kind of method of data mining, system, equipment and computer-readable recording medium | |
| CN108319641A (en) | Dish information input method and device | |
| CN103713852B (en) | A kind of information processing method, service platform and electronic equipment | |
| EP3030976A1 (en) | Method for processing and displaying real-time social data on map | |
| CN109614270A (en) | Data read-write method, device, equipment and storage medium based on Hbase | |
| Germain et al. | Changes in the functional diversity of modern bird species over the last million years | |
| CN106462591A (en) | Partition filtering using smart index in memory | |
| CN110134511A (en) | A kind of shared storage optimization method of OpenTSDB | |
| CN109241450A (en) | The recommended method and device of screen locking content | |
| CN107704591A (en) | A kind of data processing method of the intelligent wearable device based on cloud computing non-database framework | |
| CN109657950A (en) | Hierarchy Analysis Method, device, equipment and computer readable storage medium | |
| CN110267717B (en) | Method and device for automatically generating automatic scaling call rules according to different independent tenants in multi-tenant environment | |
| CN107493328B (en) | A kind of Cooperative caching method based on Fusion Features | |
| CN110215703A (en) | The selection method of game application, apparatus and system |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190222 |
|
| RJ01 | Rejection of invention patent application after publication |