CN112036957A - Visitor persistence number determining method and device, electronic equipment and storage medium - Google Patents
Visitor persistence number determining method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN112036957A CN112036957A CN202010938142.8A CN202010938142A CN112036957A CN 112036957 A CN112036957 A CN 112036957A CN 202010938142 A CN202010938142 A CN 202010938142A CN 112036957 A CN112036957 A CN 112036957A
- Authority
- CN
- China
- Prior art keywords
- visitor
- visitor number
- total
- visitors
- duplication
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 57
- 230000002688 persistence Effects 0.000 title description 2
- 230000014759 maintenance of location Effects 0.000 claims description 42
- 238000003379 elimination reaction Methods 0.000 claims description 26
- 230000008030 elimination Effects 0.000 claims description 25
- 238000004590 computer program Methods 0.000 claims description 13
- 238000012545 processing Methods 0.000 claims description 9
- 238000004364 calculation method Methods 0.000 claims description 7
- 230000000717 retained effect Effects 0.000 description 15
- 238000004891 communication Methods 0.000 description 5
- 230000009471 action Effects 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 230000001815 facial effect Effects 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000013461 design Methods 0.000 description 2
- 238000000605 extraction Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000006872 improvement Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0201—Market modelling; Market analysis; Collecting market data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/58—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
- G06F16/583—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using metadata automatically derived from the content
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/58—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
- G06F16/5866—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using information manually generated, e.g. tags, keywords, comments, manually generated location and time information
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Data Mining & Analysis (AREA)
- Strategic Management (AREA)
- Accounting & Taxation (AREA)
- Physics & Mathematics (AREA)
- Library & Information Science (AREA)
- General Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Game Theory and Decision Science (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application provides a visitor reserved number determining method, a visitor reserved number determining device, electronic equipment and a storage medium, wherein the visitor reserved number determining method comprises the following steps: the method comprises the steps of obtaining a query request, wherein the query request is used for querying the target number of reserved visitors of each time pair in at least one time pair in a preset time range, each time pair comprises a starting time period and an ending time period, and the reserved visitors have preset face characteristics and reserved records; inquiring the newly added visitor number with preset face characteristics in the initial time period and the second visitor number with a reserved record in the ending time period in a database; determining the total visitor number of the time pair corresponding to the newly added visitor number and the second visitor number according to the newly added visitor number and the second visitor number; removing the duplicate of the same visitor in the total visitor number to obtain the number of the visitors after the duplicate removal; and subtracting the number of the visitors after the duplication removal from the total visitor number to obtain the number of the newly added visitors and the target number of the reserved visitors corresponding to the second visitor number.
Description
Technical Field
The application relates to the technical field of retention statistics, in particular to a visitor retention number determining method, a visitor retention number determining device, electronic equipment and a storage medium.
Background
In the internet industry, merchants are more and more concerned about retention users and retention rates, wherein the retention users refer to users who start using applications within a certain period of time and continue using the applications after a certain period of time, and such users are regarded as retention users.
The current method for determining the visitor reservation number generally judges whether each user accesses for the first time in each time period, searches whether each user accesses again within a certain specific time range later, and then calculates the visitor reservation number in a certain time period, so that the processing efficiency is low under the condition of huge user amount data.
Disclosure of Invention
An object of the embodiments of the present application is to provide a visitor reservation number determining method, an apparatus, an electronic device, and a storage medium, so as to solve the problem that the processing efficiency is low when determining the visitor reservation number of a certain time period by determining whether each user accesses each time period for the first time, searching whether each user accesses each time period again within a certain specific time range, and then calculating the visitor reservation number of the certain time period again.
In a first aspect, an embodiment of the present invention provides a visitor reservation number determining method, where the method includes: the method comprises the steps of obtaining a query request, wherein the query request is used for querying the target number of reserved visitors of each time pair in at least one time pair in a preset time range, each time pair comprises a starting time period and an ending time period, and the reserved visitors have preset face characteristics and reserved records; querying a database for the number of newly added visitors with the preset face characteristics in the starting time period and the number of second visitors with retention records in the ending time period; acquiring the total visitor number of time pairs corresponding to the newly added visitor number and the second visitor number determined according to the newly added visitor number and the second visitor number, and the number of the duplication-eliminated visitors obtained by eliminating the duplication of the same visitor in the total visitor number; and obtaining the target number of the reserved visitor by subtracting the visitor number after the duplication removal from the total visitor number, wherein the target number of the reserved visitor is the corresponding time pair of the newly increased visitor number and the second visitor number.
In the designed visitor remaining number determining method, the newly added visitor number with the preset face feature in the initial time period is searched in the database through the initial time period of the time pair in the query request and the preset face feature, the second visitor number with the reserved record in the end time period is searched in the database through the end time period of the time pair in the query request and the reserved record, the total visitor number and the number of the deduplicated visitor obtained by deduplicating the total visitor number are determined through the newly added visitor number and the second visitor number, and as the deduplicated visitor number represents the visitor who is simultaneously present in the newly added visitor number and the second visitor number, the number of the visitor who is deduplicated is subtracted from the total visitor number can finally obtain the target number of the corresponding reserved visitor, so that the problem that whether the current visitor remaining number determining method is the first visit of each time period for each user is solved, and whether each user accesses again in a certain specific time range later is searched, and then the problem of low processing efficiency existing in the visitor retention number in a certain time period is calculated, so that the efficiency of determining the visitor retention number is improved.
In an optional implementation manner of the first aspect, the obtaining of the total visitor number determined according to the newly added visitor number and the second visitor number and the duplication-removed visitor number obtained by performing duplication removal on the same visitor in the total visitor number includes: and calculating the sum of the times of the newly added visitors and the second visitors to obtain the total times of the newly added visitors and the second visitors corresponding to the time pairs, and carrying out duplication elimination on the same visitors in the total times of the visitors to obtain the number of the visitors after duplication elimination.
In the embodiment designed above, when the duration of the starting time period and the ending time period is short, the duplication removal for the newly added visitor number and the second visitor number is not needed, and further the calculation time is saved.
In an optional implementation manner of the first aspect, the obtaining of the total visitor number determined according to the newly added visitor number and the second visitor number and the duplication-removed visitor number obtained by performing duplication removal on the same visitor in the total visitor number includes: removing the duplication of the same visitor in the newly added visitor number to obtain the newly added visitor number after the duplication is removed; removing the duplicate of the same visitor in the second visitor number to obtain the second visitor number after the duplicate removal; calculating the sum of the number of newly added visitors after the duplication removal and the number of second visitors after the duplication removal to obtain the total visitor number; and the number of the visitors after duplication elimination is obtained by duplication elimination of the same visitors in the total visitor number.
In an optional implementation manner of the first aspect, the obtaining of the total visitor number determined according to the newly added visitor number and the second visitor number and the duplication-removed visitor number obtained by performing duplication removal on the same visitor in the total visitor number includes: constructing a newly added visitor number query statement by taking the starting time period and the preset face features as limiting conditions, and constructing a second visitor number query statement by taking the ending time period and the reserved records as limiting conditions; constructing a first total visitor number query statement according to the newly added visitor number query statement and a second visitor number query statement, and setting the same visitor identification in the first total visitor number query statement as a duplication removal condition to construct a first duplication removal total visitor number query statement; and acquiring the total visitor number obtained by the query of the first total visitor number query statement returned by the database and the number of the visitors after the duplication removal obtained by the query of the first duplication removal total visitor number query statement.
In an optional implementation manner of the first aspect, the obtaining of the total visitor number determined according to the newly added visitor number and the second visitor number and the duplication-removed visitor number obtained by performing duplication removal on the same visitor in the total visitor number includes: constructing a repeated visitor number query statement by taking the starting time period and the preset human face characteristics as limiting conditions and setting the same visitor identification as a duplication removing condition; establishing a duplication-removing second visitor number query statement by taking the ending time period and the reserved record as limiting conditions and setting the same visitor identification as a duplication-removing condition; constructing a second total visitor number query statement according to the duplicate removal and increase visitor number query statement and the duplicate removal second visitor number query statement, and setting the same visitor identification in the second total visitor number query statement as a duplicate removal condition to construct a second duplicate removal total visitor number query statement; and acquiring the total visitor number obtained by the query of the second total visitor number query statement returned by the database and the number of the deduplicated visitors obtained by the query of the second deduplication total visitor number query statement.
In the two implementation modes of the design, the total visitor number and the number of the visitors after duplication are obtained by directly querying in the database through constructing the query statement, so that calculation is not needed, and the calculation time is saved.
In an optional implementation manner of the first aspect, after the obtaining the query request, the method further includes: extracting a query statement in a preset format carried in the query request; and checking a preset format query statement carried in the visitor reservation number query request through a preset semantic constraint model to obtain a plurality of query conditions, wherein the plurality of query conditions comprise at least one time pair, preset face characteristics of the reserved visitor and a reserved record.
In an optional implementation manner of the first aspect, before the obtaining the query request, the method further includes: acquiring a plurality of image data of a plurality of time ranges; identifying the face in each image data to obtain the face feature corresponding to each visitor and associating the face feature corresponding to each visitor in each image data with the time of the current image data; clustering according to the face features corresponding to the same visitor at preset time intervals to determine the face features corresponding to each visitor, visitor identification, first visit time and last visit time; and storing the face characteristics corresponding to each visitor, the visitor identification, the time of the first visit and the time of the last visit in the database.
In a second aspect, an embodiment of the present invention provides an apparatus for determining a visitor reservation number, where the apparatus includes: the system comprises an acquisition module, a storage module and a processing module, wherein the acquisition module is used for acquiring an inquiry request, the inquiry request is used for inquiring the target number of the reserved visitor in each time pair in at least one time pair in a preset time range, each time pair comprises a starting time period and an ending time period, and the reserved visitor has preset face characteristics and reserved records; the query module is used for querying a database for the number of newly added visitors with the preset face characteristics in the starting time period and the number of second visitors with retention records in the ending time period; the acquisition module is further used for acquiring the total visitor number of the time pairs corresponding to the newly increased visitor number and the second visitor number determined according to the newly increased visitor number and the second visitor number, and the number of the visitors after duplication elimination, which is obtained by eliminating the duplication of the same visitor in the total visitor number; and the calculation module is used for obtaining the number of the visitors after the duplication removal is subtracted from the total visitor number, and the target number of the reserved visitors is obtained by the corresponding time pairs of the newly added visitor number and the second visitor number.
In the visitor remaining number determination apparatus designed above, the newly added visitor number having the preset face feature in the initial period is searched in the database by the initial period of the time pair in the inquiry request and the preset face feature, and the second visitor number having the remaining record in the end period is searched in the database by the end period of the time pair in the inquiry request and the remaining record, and then the total visitor number and the deduplicated visitor number obtained by deduplicating the total visitor number are determined by the newly added visitor number and the second visitor number, since the deduplicated visitor number represents the visitor who is present in the newly added visitor number and the second visitor number at the same time, the target visitor number of the time pair corresponding to the time pair can be obtained finally based on the visitor number obtained by subtracting the deduplicating from the total visitor number, and the problem that the current method for determining the visitor remaining number determines whether each user is the first visit in each period is solved, and whether each user accesses again in a certain specific time range later is searched, and then the problem of low processing efficiency existing in the visitor retention number in a certain time period is calculated, so that the efficiency of determining the visitor retention number is improved.
In an optional implementation manner of the second aspect, the obtaining module is specifically configured to calculate a sum of the times of the newly added visitor and the second visitor to obtain a total visitor number of the newly added visitor and the second visitor to which the time corresponds, and to obtain the number of the visitors after the duplication removal by the same visitor in the total visitor number.
In an optional implementation manner of the second aspect, the obtaining module is further specifically configured to construct a new visitor number query statement with the start time period and the preset face features as limiting conditions, and construct a second visitor number query statement with the end time period and the reserved record as limiting conditions; constructing a first total visitor number query statement according to the newly added visitor number query statement and a second visitor number query statement, and setting the same visitor identification in the first total visitor number query statement as a duplication removal condition to construct a first duplication removal total visitor number query statement; and acquiring the total visitor number obtained by the query of the first total visitor number query statement returned by the database and the number of the visitors after the duplication removal obtained by the query of the first duplication removal total visitor number query statement.
In an optional implementation manner of the second aspect, the obtaining module is further specifically configured to perform deduplication on the same number of visitors in the newly added visitor number, so as to obtain the number of newly added visitors after deduplication; removing the duplicate of the same visitor in the second visitor number to obtain the second visitor number after the duplicate removal; calculating the sum of the number of newly added visitors after the duplication removal and the number of second visitors after the duplication removal to obtain the total visitor number; and the number of the visitors after duplication elimination is obtained by duplication elimination of the same visitors in the total visitor number.
In an optional implementation manner of the second aspect, the obtaining module is further specifically configured to construct a visitor-duplication-removal-condition-based query statement by using the starting time period and the preset face features as limiting conditions and setting the same visitor identifier as a duplication removal condition; establishing a duplication-removing second visitor number query statement by taking the ending time period and the reserved record as limiting conditions and setting the same visitor identification as a duplication-removing condition; constructing a second total visitor number query statement according to the duplicate removal and increase visitor number query statement and the duplicate removal second visitor number query statement, and setting the same visitor identification in the second total visitor number query statement as a duplicate removal condition to construct a second duplicate removal total visitor number query statement; and acquiring the total visitor number obtained by the query of the second total visitor number query statement returned by the database and the number of the deduplicated visitors obtained by the query of the second deduplication total visitor number query statement.
In an optional implementation manner of the second aspect, the apparatus further includes an extracting module, configured to extract a query statement in a preset format carried in the query request; and the checking module is used for checking a preset format query statement carried in the visitor reservation number query request through a preset semantic constraint model so as to obtain a plurality of query conditions, wherein the plurality of query conditions comprise at least one time pair, preset human face characteristics of the reserved visitor and a reserved record.
In an optional implementation manner of the second aspect, the acquiring module is further configured to acquire a plurality of image data of a plurality of time ranges; the identification association module is used for identifying the face in each image data to obtain the face feature corresponding to each visitor and associating the face feature corresponding to each visitor in each image data with the time of the current image data; the determining module is used for clustering according to the face features corresponding to the same visitor at preset time intervals to determine the face features corresponding to each visitor, visitor identification, first visit time and last visit time; and the storage module is used for storing the face characteristics, the visitor identification, the first visit time and the last visit time corresponding to each visitor in the database.
In a third aspect, an embodiment provides an electronic device, including a memory and a processor, where the memory stores a computer program, and the processor executes the computer program to perform the method in the first aspect or any optional implementation manner of the first aspect.
In a fourth aspect, embodiments provide a non-transitory readable storage medium having stored thereon a computer program which, when executed by a processor, performs the method of the first aspect, any optional implementation manner of the first aspect.
In a fifth aspect, embodiments provide a computer program product, which when run on a computer, causes the computer to execute the method of the first aspect or any optional implementation manner of the first aspect.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are required to be used in the embodiments of the present application will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and that those skilled in the art can also obtain other related drawings based on the drawings without inventive efforts.
Fig. 1 is a first flowchart of a visitor reservation number determination method according to an embodiment of the present disclosure;
fig. 2 is a second flowchart of a visitor reservation number determination method according to an embodiment of the present application;
fig. 3 is a third flowchart of a visitor reservation number determination method according to an embodiment of the present application;
fig. 4 is a fourth flowchart of a visitor reservation number determination method according to an embodiment of the present disclosure;
fig. 5 is a fifth flowchart of a visitor reservation number determination method according to an embodiment of the present disclosure;
fig. 6 is a sixth flowchart of a visitor reservation number determination method according to an embodiment of the present application;
fig. 7 is a seventh flowchart of a visitor reservation number determination method according to an embodiment of the present application;
fig. 8 is a schematic structural diagram of a visitor reservation number determining apparatus according to an embodiment of the present application;
fig. 9 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Icon: 200-an obtaining module; 202-a query module; 204-a calculation module; 206-an extraction module; 208-a verification module; 210-identify an association module; 212-a determination module; 214-a storage module; 3-an electronic device; 301-a processor; 302-a memory; 303-communication bus.
Detailed Description
The technical solutions in the embodiments of the present application will be described below with reference to the drawings in the embodiments of the present application.
First embodiment
As shown in fig. 1, an embodiment of the present application provides a visitor remaining number determining method, where the method is used to determine a remaining number of visitors, and may be applied to a device such as a server, and the method specifically includes the following steps:
step S100: the method comprises the steps of obtaining a query request, wherein the query request is used for querying the target number of reserved visitors of each time pair in at least one time pair in a preset time range, each time pair comprises a starting time period and an ending time period, and the reserved visitors have preset face characteristics and reserved records.
Step S102: and inquiring the newly added visitor number with the preset face characteristics in the initial time period and the second visitor number with the retention record in the ending time period in the database.
Step S104: and acquiring the total visitor number determined according to the newly-increased visitor number and the second visitor number corresponding to the time pair of the newly-increased visitor number and the second visitor number and the number of the visitors after duplication elimination obtained by duplication elimination of the same visitor in the total visitor number.
Step S106: and subtracting the number of the visitors after the duplication removal from the total visitor number to obtain the number of the newly added visitors and the target number of the reserved visitors corresponding to the second visitor number.
In step S100, a query request may be initiated by a user using a client or a server, where the query request is used to query a target number of retained visitors in each time pair in at least one time pair in a preset time range, for example, the preset time range includes two time pairs, and then the query result is the target number of retained visitors in each time pair in the two time pairs, where each time pair includes a start time period and an end time period, the retained visitor has a preset face feature and a retained record, and the time pair, the preset face feature and the retained record may be query conditions of retained data that needs to be queried and set by the user.
The query condition may be directly included in the query request, or may be obtained by performing one-step processing on the query request, as shown in fig. 2, which specifically includes the following steps:
step S1010: and extracting the query statement in the preset format carried in the query request.
Step S1012: and checking a preset format query statement carried in the visitor retention number query request through a preset semantic constraint model to obtain a plurality of query conditions, wherein the plurality of query conditions comprise at least one time pair, preset face features of the retained visitor and a retention record.
In step S1010, the query request includes a query statement in a preset format, and the query statement in the query request is identified and extracted, for example, the query statement extracted from the query request is a "customer whose age is 25 to 30 years and whose statistics is new and increased in 5 months and 1 day and is retained in 5 months and 20 days"; the preset format represents that the customers with preset face characteristics newly added on the xx date and retained on the xx date are counted, wherein the dates and the face characteristics can be set by the customers when the customers send query requests. In addition, in addition to the aforementioned query conditions, a place and a retention type may be set, for example, after the place and the retention type are added, the query statement is "count customers who are new in 5/1/5, and have their orders committed and retained in 5/20/25 th day, and have their ages between 25 and 30 years", where the order committed represents the retention type and the Guangzhou shop represents the query place; in addition to the setting location and the retention type, a time range and a time interval may be set, and a plurality of time pairs may be obtained, for example, "count is newly increased in 5/1/day, and retention in 5/20/day" is changed to "count retention of an order of a customer aged from 25 to 30 years after 1 day" by a woman in a department store in Guangzhou, so that a plurality of time pairs, such as "newly increased in 5/1/day, retained in 5/2/day", "newly increased in 5/2/day, newly increased in 5/3/day", and the like, may be obtained by the time range "from 5/1/day to 5/20/day" and the time interval "1/day".
After the query sentence is extracted, step S1012 checks the query sentence in the preset format through a preset semantic constraint model, where the preset semantic constraint model is a model that needs to be followed and is constrained by rules, and a plurality of query conditions can be obtained according to the query sentence in the preset format, for example, through the aforementioned example, the sentence "statistics is new in 5 month 1 day, 5 month 20 day orders are committed and retained by women in Guangzhou department and customers with ages between 25 and 30", the time pair can be obtained through the semantic constraint model as "5 month 1 day and 5 month 20 day", where 5 month 1 day is a start time, 5 month 20 day is an end time, and the preset face feature is "women and ages between 25 and 30"; the inquiry place is Guangzhou shop, and the reserved type is order bargaining; by the above example statement "count the retention of the order of a customer between 25 and 30 years old who is female in Guangzhou department and between 5 and 20 months in 1 day after the order deal" in the period from 5/month 1 to 5/month 20, the time range of "5/month 1 to 5/month 20" and the time interval of "1 day" can be identified; if the query statement can directly identify the time pair, step S102 may be executed, and if the time range and the time interval are identified, a plurality of time pairs need to be determined according to the time range and the time interval, which is specifically performed by: splitting the time range according to days, then taking the time period from the beginning of the time range, such as 5 months and 1 day, as the starting time, and then adding the starting time and the time interval 1 day as the ending time of the time pair, such as 5 months and 2 days, so that a time pair of ' 5 months and 1 day ', 5 months and 2 days ' is formed; then, the next day of the time range at the beginning, for example, 5 months and 1 days, is taken as the starting time of the next time pair, that is, the newly added time, for example, "5 months and 2 days", then the starting time of the next time pair is added with the time interval to obtain the ending time "5 months and 3 days" of the next time pair, and so on, and a plurality of time pairs can be obtained.
Through the above process, at least one time pair, preset face features and retention records can be obtained, and then step S102 is executed.
Before describing step S102, a database of the present solution is first described, in which visitor data of each visitor is stored in advance, where the visitor data includes a face feature of the visitor, a visitor identifier, a time of the visitor 'S first visit and a time of the visitor' S last visit.
As shown in fig. 3, the process of storing the database specifically includes the following steps:
step S90: a plurality of image data for a plurality of time ranges is acquired.
Step S91: and identifying the face in each image data to obtain the face feature corresponding to each visitor, and associating the face feature corresponding to each visitor in each image data with the time of the current image data.
Step S92: and clustering according to the face features corresponding to the same visitor at preset time intervals to determine the face features corresponding to each visitor, the visitor identification, the time of the first visit and the time of the last visit.
Step S93: and storing the face characteristics corresponding to each visitor, the visitor identification, the first visit time and the last visit time in a database.
The steps S90 to S93 are specifically to provide a video stream or an image through a camera, detect the image to find out a face frame, perform feature extraction on the face frame, then compare face features in a feature library to find out a similar face ID, if a certain threshold condition is exceeded, give the face frame the face ID, and perform face feature recognition on the face frame to obtain face features corresponding to the face ID; finding out recognition results of all the face IDs according to the face IDs by daily clustering for analysis and calculation, and finally obtaining visitor data, wherein the visitor data comprises the face IDs of visitors, visitor identification, face characteristics, time point of first visit, time point of last appearance and the like, then associating the visitor data with time by manually adding data such as retention records and the like, and finally storing the visitor data of each visitor in a database. In addition, if the present scheme designs a plurality of places or stores, the above steps are performed for each store or place, and the places or stores are stored in the visitor data of the corresponding visitor.
On the basis that the visitor data is stored in the database, the step S102 is executed to combine the initial time period and the preset human face characteristic to inquire the number of newly added visitors with the preset human face characteristic in the initial time period in the database, specifically, a newly added visitor number inquiry statement is constructed by using the initial time period and the preset human face characteristic as the limiting condition, and then the newly added visitor number with the preset human face characteristic in the initial time period is inquired in the database.
After the newly added visitor number is obtained, step S102 is executed to combine the two conditions of the end time period and the retention record to query the second visitor number with the retention record in the end time period in the database, specifically, as mentioned above, a second visitor number query statement may be constructed by using the end time period and the retention record as the limiting conditions, and then query is performed in the database, because the retention record and the corresponding time of each visitor are stored in the database during query, the database may further query the second visitor number with the retention record in the end time period according to the second visitor number query statement, and then the database may return the second visitor number to the execution end.
After the number of newly added visitors with preset human face characteristics in the initial time period and the number of second visitors with reserved records in the end time period are obtained in the step S102, the step S104 can be executed to obtain the total number of visitors obtained by the duplication elimination of the same visitors in the total number of visitors according to the time pairs corresponding to the newly added visitor number and the second visitor number determined by the newly added visitor number and the second visitor number, wherein the mode of determining the total number of visitors can be automatically calculated and determined through the newly added visitor number and the second visitor number returned by the database; this can also be done by setting up a query statement.
In addition, the total number of visitors determined in step S104 has two cases:
first, if the time lengths of the starting time period and the ending time period are not long, for example, 1 day, and as mentioned above, the starting time period is 5 months and 1 day, and the ending time period is 5 months and 20 days, in such a case, the visitor is likely to appear only once a day, then the number of new visitors and the number of second visitors default to no repeated visitors, and at this time, the total number of visitors can be obtained by directly adding the number of new visitors to the number of second visitors, as shown in fig. 4, that is, the following steps are performed:
step S1040: and calculating the sum of the number of the newly added visitors and the number of the second visitors to obtain the total number of visitors of the newly added visitors and the corresponding time pairs of the number of the second visitors, and removing the same visitors in the total number of visitors to obtain the number of the visitors after the removal of the weight.
In addition to the total visitor number of the corresponding time pair obtained by calculating the sum of the newly added visitor number and the second visitor number by the execution end itself, as described above, the data returned by the database query may be directly obtained by constructing a query statement, specifically, step S104 is completed by constructing a query statement, as shown in fig. 5, and specifically, the following steps may be included:
step S1041: and constructing a newly added visitor number query statement by taking the initial time period and the preset face characteristics as limiting conditions, and constructing a second visitor number query statement by taking the ending time period and the reserved record as limiting conditions.
Step S1042: and constructing a first total visitor number query statement according to the newly added visitor number query statement and the second visitor number query statement, and setting the same visitor identification in the first total visitor number query statement as a duplication removal condition to construct a first duplication removal total visitor number query statement.
Step S1043: and acquiring the total visitor number obtained by the query of the first total visitor number query statement returned by the database and the number of the visitors after the duplication removal obtained by the query of the first duplication removal total visitor number query statement.
In the above steps S1041 to S1043, a first total visitor number query statement is constructed according to the newly added visitor number query statement and the second visitor number query statement, a same visitor identifier is set in the total visitor number query statement as a deduplication condition to construct a first deduplication total visitor number query statement, and then a total visitor number obtained through query of the first total visitor number query statement and a number of the deduplicated visitors obtained through query of the first deduplication total visitor number query statement returned by the database are received.
Secondly, if the time lengths of the starting time period and the ending time period are relatively long, for example, 1 week or 1 month, there are many times of visitors in a week or a month, in such a case, the obtained new visitor number and the second visitor number may have the same visitor repetition, as shown in fig. 6, at this time, the total visitor number may be specifically obtained through the following steps:
step S1044: and removing the duplication of the same visitor in the newly added visitor number to obtain the newly added visitor number after the duplication is removed.
Step S1045: and removing the duplicate of the same visitor in the number of the second visitors to obtain the number of the second visitors after the duplicate removal.
Step S1046: and calculating the sum of the number of newly added visitors after the duplication removal and the number of second visitors after the duplication removal to obtain the total visitor number.
The steps are respectively duplication-removing carried out on the obtained newly-increased visitor number and the obtained second visitor number, and then the newly-increased visitor number after duplication-removing and the second visitor number after duplication-removing are added to obtain the total visitor number.
In addition to the above-mentioned total number of visitors corresponding to the time pair obtained by calculating the sum of the number of newly added visitors after the duplication removal and the number of second visitors after the duplication removal through the execution end itself, as mentioned above, a manner of directly obtaining data returned by the database by constructing an inquiry statement may also be adopted, specifically, as shown in fig. 7, the method includes the following steps:
step S1047: and constructing a repeated visitor number query statement by taking the starting time period and the preset human face characteristics as limiting conditions and setting the same visitor identification as a duplication removing condition.
Step S1048: and constructing a duplicate removal second visitor number query statement by taking the ending time period and the reserved record as limiting conditions and setting the same visitor identification as a duplicate removal condition.
Step S1049: and constructing a second total visitor number query statement according to the duplicate removal and increase visitor number query statement and the duplicate removal second visitor number query statement, and setting the same visitor identification in the second total visitor number query statement as a duplicate removal condition to construct a second duplicate removal total visitor number query statement.
Step S10410: and acquiring the total visitor number obtained by the query of the second total visitor number query statement returned by the database and the number of the visitors after the duplication elimination obtained by the query of the second duplication-elimination total visitor number query statement.
In the above step S1047 to step S10410: constructing a visitor-frequency query sentence for re-increasing visitors by taking the initial time period and preset human face characteristics as limiting conditions and setting the same visitor identification as a duplication-removing condition; and finally, constructing a second total visitor number query statement according to the re-visitor number query statement and the re-duplication-removing second visitor number query statement, and acquiring the total visitor number obtained by querying through the second total visitor number query statement and the number of the re-duplicated visitors obtained by querying through the second total visitor number query statement returned by the database.
On the basis of obtaining the total visitor number in the above manner, step S106 can be executed to duplicate the same visitor in the total visitor number to obtain the visitor number after duplication elimination, and similarly, except that the execution end executes duplication elimination, the same visitor identification can be set again in the query sentence of the total visitor number as a duplication elimination condition so as to obtain the visitor number after duplication elimination for the visitor with the same visitor identification in the total visitor number through the database and then return to the execution end.
And after the number of the visitors after the duplication is removed is obtained in the step S106, the step S108 can be executed to obtain the target number of the reserved visitors by subtracting the number of the visitors after the duplication from the total visitor number to obtain the new visitor number and the second visitor number corresponding time pair.
Since the total visitor count is determined to have two cases, there are two cases for the target number of the remaining visitors: first, in the case where the total visitor number is obtained by directly adding the new visitor number and the second visitor number, since the visitor having the retention record in the second visitor number is not necessarily the newly added visitor in the initial time period, the second visitor number cannot be taken as the target number of the retained visitor, and in the case where the total visitor number is obtained by adding the new visitor number and the second visitor number, since the length of the initial time period is short, the newly added visitor is not a duplicated visitor in the default visitor number, since the length of the end time period is short, the second visitor number is not a duplicated visitor in the default visitor number, and if the sum of the newly added visitor number and the second visitor number has duplicated, the duplicated visitor is the newly added visitor in both the initial visitor number and the second visitor number, the visitor is the newly added in the initial time period, and the visitor reserved in the ending time period can obtain the target number of the reserved visitor corresponding to the time pair by subtracting the sum of the newly increased visitor number and the second visitor number (the total visitor number) after the duplication removal from the sum of the newly increased visitor number and the second visitor number (the visitor number after the duplication removal).
Second, when the lengths of the initial time period and the ending time period are both longer, the total visitor number is obtained by adding the newly added visitor number after the duplication removal to the second visitor number after the duplication removal, similarly, since the visitor with the retention record in the second visitor number after the duplication removal is not necessarily the newly added visitor in the initial time period, the second visitor number after the duplication removal cannot be used as the target number of the retained visitor, and when the newly added visitor number and the second visitor number are both duplicated, if the sum of the newly added visitor number after the duplication removal and the second visitor number after the duplication removal still has the duplicated visitor, the duplicated visitor is the newly added visitor number both in the newly added visitor number after the duplication removal and the second visitor number after the duplication removal, it is stated that the visitor is the newly added visitor in the initial time period, and the visitor in the ending time period can pass the sum of the newly added visitor number after the duplication removal and the second visitor number after the duplication removal (the total visitor number is the total visitor number) ) The number of people who have removed the weight of the total visitor number (the number of the visitor who has removed the weight) at the moment is subtracted to obtain the target number of the corresponding reserved visitor at the time.
In addition, after the target number of the reserved visitors is obtained, the corresponding reservation rate of the time pair can be obtained by removing the newly added number after the duplication is removed by the target number of the reserved visitors.
The visitor remaining number determining method searches for a newly added visitor number with the preset face feature in the initial time period through the initial time period of the time pair in the query request and the preset face feature in the database, searches for a second visitor number with the reserved record in the end time period through the end time period of the time pair in the query request and the reserved record in the database, determines a total visitor number through the newly added visitor number and the second visitor number, and performs deduplication on the total visitor number to obtain the visitor number after the deduplication, because the deduplication person represents visitors simultaneously appearing in the newly added visitor number and the second visitor number, the target visitor number of the corresponding reserved visitor can be obtained through subtracting the visitor number after the deduplication from the total visitor number finally, and the problem that whether the current visitor remaining number determining method is the first visit of each user in each time period is solved, and whether each user accesses again in a certain specific time range later is searched, and then the problem of low processing efficiency existing in the visitor retention number in a certain time period is calculated, so that the efficiency of determining the visitor retention number is improved.
Second embodiment
Fig. 8 shows a schematic block diagram of the visitor deposit number determination apparatus provided in the present application, and it should be understood that the apparatus corresponds to the method embodiments executed in fig. 1 to 7, and can execute the steps involved in the method executed by the server in the first embodiment, and the specific functions of the apparatus can be referred to the above description, and the detailed description is appropriately omitted here to avoid repetition. The device includes at least one software function that can be stored in memory in the form of software or firmware (firmware) or solidified in the Operating System (OS) of the device. Specifically, the apparatus includes: the system comprises an obtaining module 200, a judging module and a display module, wherein the obtaining module 200 is used for obtaining a query request, the query request is used for querying the target number of the reserved visitors of each time pair in at least one time pair in a preset time range, each time pair comprises a starting time period and an ending time period, and the reserved visitors have preset face characteristics and reserved records; the query module 202 is configured to query, in a database, a newly added visitor number having a preset face feature in an initial time period and a second visitor number having a retention record in an end time period; an obtaining module 200, configured to obtain a total visitor number of time pairs corresponding to the newly added visitor number and the second visitor number determined according to the newly added visitor number and the second visitor number, and a number of the deduplicated visitors obtained by performing deduplication on the same visitor in the total visitor number; and the calculating module 204 is used for subtracting the number of the visitors after the duplication removal from the total visitor number to obtain the target number of the reserved visitors, wherein the target number is the newly added visitor number and the second visitor number corresponding time pair.
In the visitor remaining number determination apparatus designed above, the newly added visitor number having the preset face feature in the initial period is searched in the database by the initial period of the time pair in the inquiry request and the preset face feature, and the second visitor number having the remaining record in the end period is searched in the database by the end period of the time pair in the inquiry request and the remaining record, and then the total visitor number and the deduplicated visitor number obtained by deduplicating the total visitor number are determined by the newly added visitor number and the second visitor number, since the deduplicated visitor number represents the visitor who is present in the newly added visitor number and the second visitor number at the same time, the target visitor number of the time pair corresponding to the time pair can be obtained finally based on the visitor number obtained by subtracting the deduplicating from the total visitor number, and the problem that the current method for determining the visitor remaining number determines whether each user is the first visit in each period is solved, and whether each user accesses again in a certain specific time range later is searched, and then the problem of low processing efficiency existing in the visitor retention number in a certain time period is calculated, so that the efficiency of determining the visitor retention number is improved.
In an optional implementation manner of this embodiment, the obtaining module 200 is specifically configured to calculate a total visitor number obtained by comparing the sum of the newly added visitor number and the second visitor number to the newly added visitor number and the second visitor number, and perform deduplication on the same visitor in the total visitor number to obtain the deduplicated visitor number.
In an optional implementation manner of this embodiment, the obtaining module 200 is further specifically configured to construct a new visitor number query statement with the start time period and the preset face features as the limiting conditions, and construct a second visitor number query statement with the end time period and the retention record as the limiting conditions; constructing a first total visitor number query statement according to the newly added visitor number query statement and the second visitor number query statement, and setting the same visitor identification in the first total visitor number query statement as a duplication removal condition to construct a first duplication removal total visitor number query statement; and acquiring the total visitor number obtained by inquiring in the database through the first total visitor number inquiry statement and the number of the visitors after the duplication removal obtained by inquiring through the first duplication removal total visitor number inquiry statement.
In an optional implementation manner of this embodiment, the obtaining module 200 is further specifically configured to perform deduplication on the same number of visitors in the newly added visitor number, so as to obtain the number of newly added visitors after deduplication; removing the duplicate of the same visitor in the second visitor number to obtain the second visitor number after the duplicate removal; calculating the sum of the number of newly added visitors after the duplication removal and the number of second visitors after the duplication removal to obtain the total number of visitors; and the number of the visitors after duplication elimination is obtained by duplication elimination of the same visitors in the total visitor number.
In an optional implementation manner of this embodiment, the obtaining module 200 is further specifically configured to construct a secondary query statement for adding a new visitor based on the starting time period and the preset face features as the limiting conditions and setting the same visitor identifier as the duplication elimination condition; constructing a duplicate removal second visitor number query statement by taking the ending time period and the reserved record as limiting conditions and setting the same visitor identification as a duplicate removal condition; constructing a second total visitor number query statement according to the duplicate removal and increase visitor number query statement and the duplicate removal second visitor number query statement, and setting the same visitor identification in the second total visitor number query statement as a duplicate removal condition to construct a second duplicate removal total visitor number query statement; and acquiring the total visitor number obtained by inquiring in the database through the second total visitor number inquiry statement and the number of the visitors after duplication elimination obtained by inquiring through the second duplication elimination total visitor number inquiry statement.
In an optional implementation manner of this embodiment, the apparatus further includes an extracting module 206, configured to extract a query statement in a preset format carried in the query request; the checking module 208 is configured to check a preset format query statement carried in the visitor retention number query request through a preset semantic constraint model to obtain a plurality of query conditions, where the plurality of query conditions include at least one time pair, preset face features of a retained visitor, and a retention record.
In an optional implementation manner of this embodiment, the obtaining module 200 is further configured to obtain a plurality of image data in a plurality of time ranges; an identification association module 210, configured to identify a face in each image data to obtain a face feature corresponding to each visitor, and associate the face feature corresponding to each visitor in each image data with a time of current image data; the determining module 212 is further configured to perform clustering according to the facial features corresponding to the same visitor at preset time intervals to determine the facial features, the visitor identifiers, the time of the first visit, and the time of the last visit corresponding to each visitor; and the storage module 214 is configured to store the facial features, the visitor identification, the time of the first access, and the time of the last access corresponding to each visitor in a database.
Third embodiment
As shown in fig. 9, the present application provides an electronic device 3 including: a processor 301 and a memory 302, the processor 301 and the memory 302 being interconnected and communicating with each other via a communication bus 303 and/or other form of connection mechanism (not shown), the memory 302 storing a computer program executable by the processor 301, the processor 301 executing the computer program when the computing device is running to perform the method of the first embodiment, any alternative implementation of the first embodiment, such as steps S100 to S108: the method comprises the steps of obtaining an inquiry request, wherein the inquiry request is used for inquiring the target number of reserved visitors in each time pair in at least one time pair in a preset time range, each time pair comprises a starting time period and an ending time period, and the reserved visitors have preset face characteristics and reserved records; inquiring the newly added visitor number with preset face characteristics in the initial time period and the second visitor number with a reserved record in the ending time period in a database; determining the total visitor number of the time pair corresponding to the newly added visitor number and the second visitor number according to the newly added visitor number and the second visitor number; removing the duplicate of the same visitor in the total visitor number to obtain the number of the visitors after the duplicate removal; and subtracting the number of the visitors after the duplication removal from the total visitor number to obtain the number of the newly added visitors and the target number of the reserved visitors corresponding to the second visitor number.
The present application provides a storage medium having a computer program stored thereon, where the computer program is executed by a processor to perform the method of the first embodiment or any alternative implementation manner of the first embodiment.
The storage medium may be implemented by any type of volatile or nonvolatile storage device or combination thereof, such as a Static Random Access Memory (SRAM), an Electrically Erasable Programmable Read-Only Memory (EEPROM), an Erasable Programmable Read-Only Memory (EPROM), a Programmable Read-Only Memory (PROM), a Read-Only Memory (ROM), a magnetic Memory, a flash Memory, a magnetic disk, or an optical disk.
The present application provides a computer program product which, when run on a computer, causes the computer to perform the method of the first embodiment, any of its alternative implementations.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one logical division, and there may be other divisions when actually implemented, and for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of devices or units through some communication interfaces, and may be in an electrical, mechanical or other form.
In addition, units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
Furthermore, the functional modules in the embodiments of the present application may be integrated together to form an independent part, or each module may exist separately, or two or more modules may be integrated to form an independent part.
It should be noted that the functions, if implemented in the form of software functional modules and sold or used as independent products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application or portions thereof that substantially contribute to the prior art may be embodied in the form of a software product stored in a storage medium and including instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
In this document, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions.
The above description is only an example of the present application and is not intended to limit the scope of the present application, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application shall be included in the protection scope of the present application.
Claims (10)
1. A visitor reservation number determination method, the method comprising:
the method comprises the steps of obtaining a query request, wherein the query request is used for querying the target number of reserved visitors of each time pair in at least one time pair in a preset time range, each time pair comprises a starting time period and an ending time period, and the reserved visitors have preset face characteristics and reserved records;
querying a database for the number of newly added visitors with the preset face characteristics in the starting time period and the number of second visitors with retention records in the ending time period;
acquiring the total visitor number of time pairs corresponding to the newly added visitor number and the second visitor number determined according to the newly added visitor number and the second visitor number, and the number of the duplication-eliminated visitors obtained by eliminating the duplication of the same visitor in the total visitor number;
and obtaining the target number of the reserved visitor by subtracting the visitor number after the duplication removal from the total visitor number, wherein the target number of the reserved visitor is the corresponding time pair of the newly increased visitor number and the second visitor number.
2. The method of claim 1, wherein the obtaining of the total visitor number of the newly added visitor number and the second visitor number corresponding to the time pair determined according to the newly added visitor number and the second visitor number and the duplication removed visitor number obtained by duplication removal for the same visitor in the total visitor number comprises:
and calculating the sum of the times of the newly added visitors and the second visitors to obtain the total times of the newly added visitors and the second visitors corresponding to the time pairs, and carrying out duplication elimination on the same visitors in the total times of the visitors to obtain the number of the visitors after duplication elimination.
3. The method of claim 1, wherein the obtaining of the total visitor number of the newly added visitor number and the second visitor number corresponding to the time pair determined according to the newly added visitor number and the second visitor number and the duplication removed visitor number obtained by duplication removal for the same visitor in the total visitor number comprises:
constructing a newly added visitor number query statement by taking the starting time period and the preset face features as limiting conditions, and constructing a second visitor number query statement by taking the ending time period and the reserved records as limiting conditions;
constructing a first total visitor number query statement according to the newly added visitor number query statement and a second visitor number query statement, and setting the same visitor identification in the first total visitor number query statement as a duplication removal condition to construct a first duplication removal total visitor number query statement;
and acquiring the total visitor number obtained by the query of the first total visitor number query statement returned by the database and the number of the visitors after the duplication removal obtained by the query of the first duplication removal total visitor number query statement.
4. The method of claim 1, wherein the obtaining of the total visitor number of the newly added visitor number and the second visitor number corresponding to the time pair determined according to the newly added visitor number and the second visitor number and the duplication removed visitor number obtained by duplication removal for the same visitor in the total visitor number comprises:
removing the duplication of the same visitor in the newly added visitor number to obtain the newly added visitor number after the duplication is removed;
removing the duplicate of the same visitor in the second visitor number to obtain the second visitor number after the duplicate removal;
calculating the sum of the number of newly added visitors after the duplication removal and the number of second visitors after the duplication removal to obtain the total visitor number;
and the number of the visitors after duplication elimination is obtained by duplication elimination of the same visitors in the total visitor number.
5. The method of claim 1, wherein the obtaining of the total visitor number of the newly added visitor number and the second visitor number corresponding to the time pair determined according to the newly added visitor number and the second visitor number and the duplication removed visitor number obtained by duplication removal for the same visitor in the total visitor number comprises:
constructing a repeated visitor number query statement by taking the starting time period and the preset human face characteristics as limiting conditions and setting the same visitor identification as a duplication removing condition;
establishing a duplication-removing second visitor number query statement by taking the ending time period and the reserved record as limiting conditions and setting the same visitor identification as a duplication-removing condition;
constructing a second total visitor number query statement according to the duplicate removal and increase visitor number query statement and the duplicate removal second visitor number query statement, and setting the same visitor identification in the second total visitor number query statement as a duplicate removal condition to construct a second duplicate removal total visitor number query statement;
and acquiring the total visitor number obtained by the query of the second total visitor number query statement returned by the database and the number of the deduplicated visitors obtained by the query of the second deduplication total visitor number query statement.
6. The method of claim 1, wherein after the obtaining the query request, the method further comprises:
extracting a query statement in a preset format carried in the query request;
and checking a preset format query statement carried in the query request through a preset semantic constraint model to obtain a plurality of query conditions, wherein the plurality of query conditions comprise the at least one time pair, preset face features of the reserved visitor and reserved records.
7. The method of claim 1, wherein prior to the obtaining the query request, the method further comprises:
acquiring a plurality of image data of a plurality of time ranges;
identifying the face in each image data to obtain the face feature corresponding to each visitor and associating the face feature corresponding to each visitor in each image data with the time of the current image data;
clustering according to the face features corresponding to the same visitor at preset time intervals to determine the face features corresponding to each visitor, visitor identification, first visit time and last visit time;
and storing the face characteristics corresponding to each visitor, the visitor identification, the time of the first visit and the time of the last visit in the database.
8. An apparatus for visitor reservation number determination, the apparatus comprising:
the system comprises an acquisition module, a storage module and a processing module, wherein the acquisition module is used for acquiring an inquiry request, the inquiry request is used for inquiring the target number of the reserved visitor in each time pair in at least one time pair in a preset time range, each time pair comprises a starting time period and an ending time period, and the reserved visitor has preset face characteristics and reserved records;
the query module is used for querying a database for the number of newly added visitors with the preset face characteristics in the starting time period and the number of second visitors with retention records in the ending time period;
the acquisition module is further used for acquiring the total visitor number of the time pairs corresponding to the newly increased visitor number and the second visitor number determined according to the newly increased visitor number and the second visitor number, and the number of the visitors after duplication elimination, which is obtained by eliminating the duplication of the same visitor in the total visitor number;
and the calculation module is used for obtaining the number of the visitors after the duplication removal is subtracted from the total visitor number, and the target number of the reserved visitors is obtained by the corresponding time pairs of the newly added visitor number and the second visitor number.
9. An electronic device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the method of any one of claims 1 to 7 when executing the computer program.
10. A storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the method of any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010938142.8A CN112036957B (en) | 2020-09-08 | 2020-09-08 | Visitor retention number determining method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010938142.8A CN112036957B (en) | 2020-09-08 | 2020-09-08 | Visitor retention number determining method and device, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112036957A true CN112036957A (en) | 2020-12-04 |
| CN112036957B CN112036957B (en) | 2023-11-28 |
Family
ID=73584327
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010938142.8A Active CN112036957B (en) | 2020-09-08 | 2020-09-08 | Visitor retention number determining method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112036957B (en) |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2001266433A1 (en) * | 2000-07-03 | 2002-04-11 | Dyno Nobel Asia Pacific Pty Limited | Method and apparatus for providing a primer with a detonator in a borehole |
| CN104504084A (en) * | 2014-12-24 | 2015-04-08 | 小米科技有限责任公司 | Method and device for determining user retention rate |
| WO2015074486A1 (en) * | 2013-11-20 | 2015-05-28 | 北京国双科技有限公司 | Method and apparatus for calculating user retention ratio |
| CN106528778A (en) * | 2016-11-04 | 2017-03-22 | 广州华多网络科技有限公司 | Method and device for obtaining user retention data |
| WO2017107845A1 (en) * | 2015-12-23 | 2017-06-29 | 北京金山安全软件有限公司 | Method, device, and electronic apparatus for optimizing application retention rate |
| WO2019015684A1 (en) * | 2017-07-21 | 2019-01-24 | 北京市商汤科技开发有限公司 | Facial image reduplication removing method and apparatus, electronic device, storage medium, and program |
| CN109376192A (en) * | 2018-09-20 | 2019-02-22 | 北京空中信使信息技术有限公司 | A kind of user retains analysis method, device, electronic equipment and storage medium |
| CN109559142A (en) * | 2017-09-27 | 2019-04-02 | 北京国双科技有限公司 | The calculation method and device of user's retention ratio |
| CN109993572A (en) * | 2019-02-15 | 2019-07-09 | 生迪智慧科技有限公司 | Retention ratio statistical method, device, equipment and storage medium |
| CN110580322A (en) * | 2019-09-18 | 2019-12-17 | 北京百度网讯科技有限公司 | Independent visitor information processing method and device, electronic equipment and storage medium |
| WO2020056915A1 (en) * | 2018-09-18 | 2020-03-26 | 图普科技（广州）有限公司 | Customer visit analysis method and apparatus, and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| NO314914B1 (en) * | 2000-07-03 | 2003-06-10 | Dyno Nobel Asa | Apparatus and method for placing primer with teeth in a borehole |
-
2020
- 2020-09-08 CN CN202010938142.8A patent/CN112036957B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2001266433A1 (en) * | 2000-07-03 | 2002-04-11 | Dyno Nobel Asia Pacific Pty Limited | Method and apparatus for providing a primer with a detonator in a borehole |
| WO2015074486A1 (en) * | 2013-11-20 | 2015-05-28 | 北京国双科技有限公司 | Method and apparatus for calculating user retention ratio |
| CN104504084A (en) * | 2014-12-24 | 2015-04-08 | 小米科技有限责任公司 | Method and device for determining user retention rate |
| WO2017107845A1 (en) * | 2015-12-23 | 2017-06-29 | 北京金山安全软件有限公司 | Method, device, and electronic apparatus for optimizing application retention rate |
| CN106528778A (en) * | 2016-11-04 | 2017-03-22 | 广州华多网络科技有限公司 | Method and device for obtaining user retention data |
| WO2019015684A1 (en) * | 2017-07-21 | 2019-01-24 | 北京市商汤科技开发有限公司 | Facial image reduplication removing method and apparatus, electronic device, storage medium, and program |
| CN109559142A (en) * | 2017-09-27 | 2019-04-02 | 北京国双科技有限公司 | The calculation method and device of user's retention ratio |
| WO2020056915A1 (en) * | 2018-09-18 | 2020-03-26 | 图普科技（广州）有限公司 | Customer visit analysis method and apparatus, and storage medium |
| CN109376192A (en) * | 2018-09-20 | 2019-02-22 | 北京空中信使信息技术有限公司 | A kind of user retains analysis method, device, electronic equipment and storage medium |
| CN109993572A (en) * | 2019-02-15 | 2019-07-09 | 生迪智慧科技有限公司 | Retention ratio statistical method, device, equipment and storage medium |
| CN110580322A (en) * | 2019-09-18 | 2019-12-17 | 北京百度网讯科技有限公司 | Independent visitor information processing method and device, electronic equipment and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| CCLLCAOCHON1: "Kylin 精准去重案例", Retrieved from the Internet <URL:httpsblog.csdn.netccllcaochong1articledetails95885086> * |
| 萧萧: "七日留存率-SQL实现", Retrieved from the Internet <URL:httpszhuanlan.zhihu.comp143494489> * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112036957B (en) | 2023-11-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108615119B (en) | Abnormal user identification method and equipment | |
| WO2021184729A1 (en) | Drug classification method and apparatus, storage medium, and intelligent device | |
| US20140317756A1 (en) | Anonymization apparatus, anonymization method, and computer program | |
| CN106850335B (en) | Method for counting software utilization rate and adjusting trial period | |
| CN105654201B (en) | Advertisement traffic prediction method and device | |
| WO2020134213A1 (en) | Method and system for querying abnormal financial data on basis of knowledge map | |
| CN112307297B (en) | User identification unification method and system based on priority rule | |
| CN110853715A (en) | Medical data visualization processing method and system, storage medium and electronic device | |
| CN109088788B (en) | Data processing method, device, equipment and computer readable storage medium | |
| CN110046196A (en) | Identify correlating method and device, electronic equipment | |
| CN110442791B (en) | Data pushing method and system | |
| CN110490750B (en) | Data identification method, system, electronic equipment and computer storage medium | |
| CN109448811B (en) | Prescription auditing improvement method and device, electronic equipment and storage medium | |
| US20220215129A1 (en) | Information processing apparatus, information processing method and program | |
| CN105376223A (en) | Network identity relationship reliability calculation method | |
| JP2003016094A (en) | Method for profile management used for information filtering and program therefor | |
| CN107103065B (en) | Information recommendation method and device based on user behaviors | |
| CN112488845A (en) | Method and device for screening insurance clients, electronic equipment and storage medium | |
| CN114462885A (en) | Data ranking method and device based on service information, medium and equipment | |
| CN110705297A (en) | Enterprise name-identifying method, system, medium and equipment | |
| CN108711109B (en) | Method, device, storage medium and apparatus for updating preparation gold computing system | |
| CN112036957A (en) | Visitor persistence number determining method and device, electronic equipment and storage medium | |
| CN113901037A (en) | Data management method, device and storage medium | |
| CN112215566A (en) | Card making data processing method, system, equipment and storage medium of bank card | |
| JPWO2014050837A1 (en) | Determination apparatus, determination method, and program |
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 |