A customer group data statistics method, device, electronic device and storage medium
By building business condition expressions and regular expressions, a customer data cube is generated, which solves the problem of low customer data statistics efficiency in the existing technology, realizes automated statistics and analysis, simplifies the process, and improves efficiency.
Patent Information
- Application Number
- CN202211413795.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-11-11
- Publication Date
- 2024-11-01
- Estimated Expiration
- 2042-11-11
AI Technical Summary
The existing customer group data statistics method is inefficient and requires support from IT departments. Changes in screening rules require redevelopment, resulting in low data statistics efficiency.
By determining multiple target tag categories of the target customer group, dividing preset tag groups, building business condition expressions and rule expressions, generating customer group data cubes, and achieving automated data statistics without the intervention of IT technicians.
It improves the efficiency of data statistics for specific customer groups, simplifies the data statistics process, reduces interaction with IT technicians, and realizes automated data processing and analysis.
Smart Images

Figure CN115840772B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing technology, and in particular to a customer data statistics method, device, electronic device and storage medium. Background Art
[0002] In recent years, with the rapid development of big data, people are increasingly aware of the importance of data to enterprises. Customer data analysis is an important part of enterprises' analysis of target users. How to quickly and accurately obtain customer data is crucial for enterprises. Different business scenarios correspond to different applicable customer groups, and specific customer groups need to be screened out from customer data. The existing customer data statistics method is to build screening rules according to business needs, filter out specific customer groups from all customer data through screening rules, and then perform data statistics on the obtained specific customer groups.
[0003] However, the development workload for acquiring specific customer groups is large and requires technical support from the IT department. If the screening rules change, it is necessary to re-communicate with IT technicians and re-develop the entire specific customer group for data statistics, resulting in low data statistics efficiency for specific customer groups. Summary of the invention
[0004] In view of this, the purpose of the present application is to provide a customer group data statistics method, device, electronic device and storage medium to solve the problem of low data statistics efficiency of a specific customer group.
[0005] In a first aspect, an embodiment of the present application provides a method for collecting customer data, including:
[0006] For the target customer group to be counted, determine multiple target label categories corresponding to the target customer group;
[0007] Selecting multiple target preset tags corresponding to the target customer group from multiple candidate preset tags under different target tag categories, and dividing the multiple target preset tags into different preset tag groups;
[0008] Determine the business condition expression corresponding to each target preset tag, form a business condition group expression from at least one business condition expression, and determine the customer group screening rule based on all business condition group expressions;
[0009] Determine the business rule expression corresponding to the customer group screening rule, and use the business rule expression to segment the target data cube corresponding to multiple target preset tags to generate the target customer group data cube;
[0010] Perform statistics on the target customer group data cube to generate statistical results of the target customer group.
[0011] Optionally, multiple target preset tags corresponding to the target customer group are selected from multiple candidate preset tags under different target tag categories, and the multiple target preset tags are divided into different target preset tag groups, including: for each target tag category, determining at least one target preset tag from multiple candidate preset tags under the target tag category; for each target preset tag group, determining an intra-group logical relationship between different target preset tags in the target preset tag group; and according to the intra-group logical relationship, combining at least one target preset tag together to obtain a target preset tag group.
[0012] Optionally, determining the business condition expression corresponding to each target preset tag includes: determining the tag name, business condition and business threshold of the target preset tag for each target preset tag corresponding to the target customer group; and obtaining the business condition expression corresponding to the target preset tag according to the tag name, business condition and business threshold of the target preset tag.
[0013] Optionally, a business condition group expression is formed by at least one business condition expression, and a customer group screening rule is determined based on all business condition group expressions, including: forming a business condition group expression by business condition expressions corresponding to all target preset tags under the same target preset tag group; determining the logical relationship between different business condition group expressions; and combining all business condition group expressions together to form a customer group screening rule according to the logical relationship between different business condition group expressions.
[0014] Optionally, determining a business rule expression corresponding to the customer screening rule includes: for each business condition expression in the customer screening rule, determining a query template corresponding to the business condition expression, combining the query template with the business condition expression to obtain a feature item business rule expression corresponding to the business condition expression; determining an operation expression and a data authority range expression; and merging multiple feature item business rule expressions, operation expressions and data authority range expressions into a business rule expression.
[0015] Optionally, determining an operation expression and a data permission range expression includes: determining an operation expression based on a logical relationship between multiple different business condition group expressions; selecting a target data permission identifier from multiple candidate data permission identifiers; and generating a data permission range expression based on the target data permission identifier, the data permission range expression being an expression corresponding to a structured query statement.
[0016] Optionally, target data cubes corresponding to multiple target preset tags are segmented using business rule expressions to generate target customer group data cubes, including: determining the data cube corresponding to each target preset tag; forming a target data cube from multiple data cubes corresponding to different target preset tags; and executing business rule expressions to segment the target data cube to generate target customer group data cubes.
[0017] In a second aspect, the embodiment of the present application further provides a customer group data statistics device, the device comprising:
[0018] A category determination module is used to determine multiple target label categories corresponding to the target customer group to be counted;
[0019] A label group generation module is used to select multiple target preset labels corresponding to the target customer group from multiple candidate preset labels under different target label categories, and divide the multiple target preset labels into different target preset label groups;
[0020] A screening rule determination module is used to determine the business condition expression corresponding to each target preset tag, wherein at least one business condition expression constitutes a business condition group expression, and a customer group screening rule is determined based on all business condition group expressions;
[0021] A customer group cube generation module is used to determine the business rule expression corresponding to the customer group screening rule, and use the business rule expression to segment the target data cube corresponding to multiple target preset tags to generate the target customer group data cube;
[0022] The data statistics module is used to count the target customer data cube and generate the statistical results of the target customer group.
[0023] In a third aspect, an embodiment of the present application further provides an electronic device, comprising: a processor, a memory and a bus, wherein the memory stores machine-readable instructions executable by the processor, and when the electronic device is running, the processor and the memory communicate via the bus, and when the machine-readable instructions are executed by the processor, the steps of the customer data statistics method as described above are performed.
[0024] In a fourth aspect, an embodiment of the present application further provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the steps of the customer data statistics method as described above are executed.
[0025] The embodiments of the present application bring the following beneficial effects:
[0026] The customer group data statistics method, device, electronic device and storage medium provided in the embodiment of the present application can directly select multiple target preset tags corresponding to the target customer group, obtain customer group screening rules according to the business condition expressions corresponding to the multiple target preset tags, and the customer group screening rules can locate the target customer group, and then convert the customer group screening rules into business rule expressions, and use the business rule expressions to obtain the data statistics results of the target customer group. There is no need for IT technicians to develop codes for the target customer group. Compared with the customer group data statistics method in the prior art, it solves the problem of low data statistics efficiency for a specific customer group. At the same time, after determining the target customer group data cube, customer group portrait analysis can also be performed on the target customer group data cube to generate customer group portraits under different dimensions.
[0027] In order to make the above-mentioned objects, features and advantages of the present application more obvious and easy to understand, preferred embodiments are specifically cited below and described in detail with reference to the attached drawings. BRIEF DESCRIPTION OF THE DRAWINGS
[0028] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the embodiments will be briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.
[0029] Figure 1 A flow chart showing a customer group data statistics method provided in an embodiment of the present application is shown;
[0030] Figure 2 A schematic diagram showing the structure of a customer group data statistics device provided in an embodiment of the present application is shown;
[0031] Figure 3 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application is shown. DETAILED DESCRIPTION
[0032] To make the purpose, technical scheme and advantages of the embodiments of the present application clearer, the technical scheme in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all of the embodiments. The components of the embodiments of the present application usually described and shown in the drawings here can be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of the present application provided in the drawings is not intended to limit the scope of the application claimed for protection, but merely represents the selected embodiments of the present application. Based on the embodiments of the present application, each other embodiment obtained by those skilled in the art without making creative work belongs to the scope of protection of the present application.
[0033] It is worth noting that before the present application was filed, in recent years, with the rapid development of big data, people have become more and more aware of the importance of data to enterprises. Customer data analysis is an important part of an enterprise's analysis of target users. How to quickly and accurately obtain customer data is crucial for enterprises. Different business scenarios correspond to different applicable customer groups, and specific customer groups need to be screened out from the customer data. The existing customer data statistics method is to construct screening rules based on business needs, filter out specific customer groups from all customer data through screening rules, and then perform data statistics on the obtained specific customer groups. However, the development workload of obtaining specific customer groups is large, and technical support is required from the IT department. If the screening rules change, it is necessary to re-connect and communicate with IT technicians and re-develop the entire specific customer group for data statistics, resulting in low efficiency of data statistics for specific customer groups.
[0034] Based on this, an embodiment of the present application provides a customer group data statistics method to improve the data statistics efficiency of a specific customer group.
[0035] See also Figure 1 , Figure 1 This is a flow chart of a customer group data statistics method provided in an embodiment of the present application. Figure 1 As shown, the customer group data statistics method provided in the embodiment of the present application includes:
[0036] Step S101, for the target customer group to be counted, determine a plurality of target tag categories corresponding to the target customer group.
[0037] In this step, the target customer group may refer to the customer group to be counted, and the target customer group is used to represent the customer group that meets the business conditions.
[0038] For example, the target customer group may be the customer group whose employment status is currently employed in the original data, or the customer group whose loan overdue amount exceeds RMB 10,000 in the original data, or the customer group whose employment status is currently employed and whose loan overdue amount exceeds RMB 10,000 in the original data.
[0039] The tag category may refer to a tag classification, and the tag category is used to classify the categories to which multiple candidate preset tags belong.
[0040] For example, the label category can be a system label category or a custom label category. The system label category includes but is not limited to: customer statistics label, customer basic label, customer time label, customer product label, and the custom label category is the category corresponding to the staff's custom label. Under the customer basic label category, there can be labels for gender and employment status, and under the customer statistics label category, there can be labels for expected loan amount and cumulative overdue times.
[0041] In an optional embodiment, before selecting multiple target preset tags corresponding to the target customer group from multiple candidate preset tags under different target tag categories and dividing the multiple target preset tags into different target preset tag groups, it also includes: constructing multiple data cubes of different dimensions for the original data, storing the data corresponding to each data cube in a narrow table structure, each data cube corresponds to at least one candidate preset tag, and each candidate preset tag corresponds to a tag category.
[0042] Here, the data cube may refer to a multidimensional data model, and the data cube is a data model used to represent the corresponding candidate preset tags.
[0043] Specifically, taking the original data including the report date, customer number, personal annual income, gender, age, work unit name, industry described by the unit, employment status, etc. as an example, a data cube can be constructed based on the report date, customer number, tag name, and tag value. For example: the work information data cube can associate the tag name with the following tags: work unit name, industry described by the unit, employment status, etc. In this way, multiple data cubes can be constructed for different dimensions of the original data, each data cube corresponds to at least one candidate preset tag, and multiple candidate preset tags are divided into different tag categories according to the content of the candidate preset tags, which is convenient for tag management. Then, the target customer group can be quickly screened according to the candidate preset tags and the tag categories to which they belong.
[0044] In an embodiment of the present application, in order to determine the target customer group, multiple target preset tags corresponding to the target customer group can be determined. However, different target preset tags may belong to different tag categories. Therefore, it is necessary to first determine the target tag category corresponding to the target customer group, and then select the target preset tag from the target tag category.
[0045] Step S102 , selecting a plurality of target preset tags corresponding to the target customer group from a plurality of candidate preset tags under different target tag categories, and dividing the plurality of target preset tags into different target preset tag groups.
[0046] The candidate preset label may refer to a label obtained after the original data is sorted, processed, and classified. The candidate preset label is used to select the customer group corresponding to the label from the original data.
[0047] Exemplarily, candidate preset tags may be gender, employment status, personal annual income, overdue loan amount, cumulative number of overdue payments, etc.
[0048] The target preset label may refer to a label selected from candidate preset labels for a specific business. Taking the number of people on the job in the original data as an example, the employment status label in the candidate preset labels is selected as the target preset label.
[0049] The target preset label group may refer to a label group consisting of at least one target preset label. Multiple target preset labels in the same target preset label group may be labels under the same label category or labels under different label categories.
[0050] In an embodiment of the present application, the characteristics of the target customer group are first determined according to business needs. Taking the expectation of counting the number of males on the job as an example, on the job and male are characteristics of the target customer group, among which on the job corresponds to the work employment status label, which belongs to a threshold of the work employment status label, and male corresponds to the gender label, which belongs to a threshold of the gender label. Therefore, the work employment status label and the gender label are selected as target preset labels. These two target preset labels can be divided into the same target preset label group, or they can be divided into different target preset label groups.
[0051] In an optional embodiment, multiple target preset tags corresponding to the target customer group are selected from multiple candidate preset tags under different target tag categories, and the multiple target preset tags are divided into different preset tag groups, including: for each target tag category, determining at least one target preset tag from multiple candidate preset tags under the target tag category; for each target preset tag group, determining an intra-group logical relationship between different target preset tags in the target preset tag group; and according to the intra-group logical relationship, combining at least one target preset tag together to obtain a target preset tag group.
[0052] Here, the intra-group logical relationship may refer to the logical relationship between different target preset labels in the same target preset label group, and the logical relationship may refer to the relationship of logical AND or logical OR.
[0053] Specifically, after determining the target tag category where multiple features representing the target customer group are located, the system will automatically display multiple candidate preset tags under the target tag category, and the user can select a target preset tag from these displayed candidate preset tags, so that multiple target preset tags can be selected. At the same time, select whether the relationship between each two target preset tags in the multiple target preset tags is a logical AND or a logical OR relationship, and group these target preset tags into a target preset tag group according to the logical relationship. For example: there are 3 target preset tags, namely a, b, and c, and the relationship between b and c is a logical OR relationship, that is, b||c, and the relationship between a and (b||c) is a logical AND relationship, then the target tag preset group of a&&(b||c) can be obtained.
[0054] It should be noted that within the same target preset tag group, if two target preset tags belong to the same tag category, the relationship between the two target preset tags can be a logical AND relationship or a logical OR relationship. If the two target preset tags belong to different tag categories, the relationship between the two target preset tags can only be a logical AND relationship.
[0055] Step S103, determining a business condition expression corresponding to each target preset tag, forming a business condition group expression from at least one business condition expression, and determining a customer group screening rule based on all business condition group expressions.
[0056] In this step, the business condition expression may refer to an expression for determining a threshold value of a target preset tag, and the business condition expression is used to characterize a single screening condition of a target customer group.
[0057] As an example, if the target preset label is gender, the business condition expression can be gender equals male or gender equals female; if the target preset label is employment status, the business condition expression can be employment status equals employed or employment status equals unemployed; if the target preset label is personal annual income, the business condition expression can be personal annual income (100,000 to 200,000) or personal annual income [100,000 to 200,000].
[0058] The business condition group expression may refer to an expression composed of at least one business condition expression in the same target preset label group. The business condition group expression is used to represent the customer group screening condition under a single target preset label group.
[0059] Customer group screening rules may refer to screening conditions for selecting target customer groups, and customer group screening rules are used to determine the screening scope of customer groups.
[0060] In an embodiment of the present application, after the user selects a target preset tag in the interface, the corresponding business information can be determined for each target preset tag. Taking the work employment status tag as an example, its corresponding business condition expression is that the work employment status is equal to on-the-job, or the work employment status is equal to unemployed. Then, the business condition expressions corresponding to multiple target preset tags under the same target preset tag group are combined together to obtain a business condition group expression, and the customer screening rules are determined by multiple business condition group expressions corresponding to different target preset tag groups.
[0061] In an optional embodiment, determining the business condition expression corresponding to each target preset tag includes: determining the tag name, business condition and business threshold of each target preset tag corresponding to the target customer group; and obtaining the business condition expression corresponding to the target preset tag according to the tag name, business condition and business threshold of the target preset tag.
[0062] Here, the business condition may refer to the operation comparison condition of the business.
[0063] Exemplarily, the business conditions include, but are not limited to: equal to, not equal to, greater than, less than, contain, not contain, greater than or equal to, less than or equal to, interval, with value, no value.
[0064] A service threshold may refer to a threshold condition for a service.
[0065] For example, the business threshold for the employment status label includes but is not limited to: on-the-job, on standby, unemployed, retired, resigned, and sick leave; the business threshold for the gender label can be male or female; the business threshold for the personal annual income label can be a specific amount, for example: 1000, 10000, 150000.
[0066] Specifically, users can determine the corresponding business information for each target preset label in the interface. The business information includes business conditions and business thresholds. After determining the target preset label, all available business conditions are displayed in the business condition option. Taking the work and employment status label as an example, the business conditions can be equal to, not equal to, contain, not contain, have a value, and have no value. Similarly, all available business thresholds will be displayed in the form of a drop-down menu in the business threshold option. For the work and employment status label, the business threshold can be on-the-job or unemployed. If the user selects on-the-job as the business threshold, the business condition expression corresponding to the label is that the work and employment status is equal to on-the-job.
[0067] In an optional embodiment, a business condition group expression is formed by at least one business condition expression, and a customer group screening rule is determined based on all business condition expressions, including: forming a business condition group expression by business condition expressions corresponding to all target preset tags under the same target preset tag group; determining the logical relationship between different business condition group expressions; and combining all business condition group expressions together to form a customer group screening rule according to the logical relationship between different business condition group expressions.
[0068] Assume that there are three business condition group expressions A, B, and C, and the three business condition group expressions A, B, and C are in a logical AND relationship. Each of these three business condition group expressions includes three business condition expressions. Business condition group expression A includes three business condition expressions A1, A2, and A3, business condition group expression B includes three business condition expressions B1, B2, and B3, and business condition group expression C includes three business condition expressions C1, C2, and C3. The three business condition expressions in each business condition group expression are in a logical AND relationship. According to the above logical relationship, the following customer group screening rules can be obtained: (A1&&A2&&A3)&&(B1&&B2&&B3)&&(C1&&C2&&C3).
[0069] Step S104, determining a business rule expression corresponding to the customer group screening rule, and using the business rule expression to segment the target data cube corresponding to multiple target preset tags to generate a target customer group data cube.
[0070] In this step, the business rule expression may refer to a structured query statement for obtaining target customer group data.
[0071] Business rule expressions include feature item business rule expressions, operation expressions, and data authority range expressions.
[0072] The operation expression may refer to a user-defined UDAF function, and the operation expression is used to determine the operation relationship between the data corresponding to the business rule expressions of multiple feature items.
[0073] Exemplarily, the operation expression may be to calculate the intersection of multiple data, or to calculate the union of multiple data, or to calculate different data according to a user-defined function.
[0074] The data permission range expression may refer to an expression that controls the permission of the current user to collect statistical data. The data permission range expression is used to control the statistical data of users with different permissions.
[0075] In an optional embodiment, determining a business rule expression corresponding to a customer group screening rule includes: for each business condition expression in the customer group screening rule, determining a query template corresponding to the business condition expression, combining the query template with the business condition expression to obtain a feature item business rule expression corresponding to the business condition expression; determining an operation expression and a data authority range expression; and merging multiple feature item business rule expressions, operation expressions, and data authority range expressions into a business rule expression.
[0076] Here, the query template may refer to a structured query statement that replaces variable values with symbols, and the query template is used to obtain statistical results.
[0077] Exemplarily, the query template may be a SQL structured query statement, and the query template is used to obtain data corresponding to a target preset tag.
[0078] Each target preset label corresponds to a query template.
[0079] The characteristic item business rule expression may refer to a structured query statement. The characteristic item business rule expression is a structured query statement corresponding to a single business condition expression. The characteristic item business rule expression is used as an executable SQL statement corresponding to a single screening condition.
[0080] In the embodiment of the present application, after determining the customer group screening rule, the customer group screening rule is parsed to obtain multiple business condition expressions, and the target preset label corresponding to each business condition expression is determined, and the query template corresponding to the target preset label is used as the query template corresponding to the business condition expression. Among them, each candidate preset label corresponds to a data cube, and this data cube corresponds to a query template, which is an SQL statement for querying data in the data cube, and it is an SQL statement with the SELECT keyword.
[0081] After determining the query template corresponding to the business condition expression, the query template is combined with the corresponding business condition expression to obtain the corresponding feature item business rule expression, thereby completing the conversion from the business condition expression to the feature item business rule expression.
[0082] Specifically, the business condition expression is first parsed to obtain the label name, business condition and business threshold of the business condition expression; the query template is combined with the label name, business condition and business threshold of the business condition expression according to the logical relationship within the group to obtain the characteristic item business rule expression corresponding to the business condition expression.
[0083] The SQL statement corresponding to the query template includes a label logic expression and a threshold logic expression. The label logic expression is a template for determining the label to be filtered, and the threshold logic expression is a template for determining the threshold to be filtered. Taking the target preset label A as an example, the label names of the target preset label A are stored in the LBL_NM field, then the label logic expression can be A.LBL_NM=${LBL_NM}, and the thresholds corresponding to different labels are stored in the LBL_CD field, then the threshold logic expression can be A.LBL_CD=${LBL_CD}, where ${LBL_NM} and ${LBL_CD} are replacement symbols, and the label name and business threshold in the business condition expression can be used to replace ${LBL_NM} and ${LBL_CD} to obtain the feature item business rule expression. Of course, the "=" symbol in the threshold logic expression also needs to be replaced according to the selected business condition.
[0084] Assuming that the label name, business condition and business threshold of the business condition expression are personal annual income, greater than, and 100000 respectively, then substitute the label name, business condition and business threshold into the query template to obtain the label rule expression and threshold rule expression corresponding to the business condition expression, which are A.LBL_NM = "personal annual income" and A.LBL_CD>100000 respectively.
[0085] In addition, the query template includes a table name, which is used to represent the name of the data table that stores the data corresponding to each data cube under the tag category. The query template can also include a report date logical expression and a customer number logical expression, which are used to filter the data date and customer number respectively. The customer number can be a unique identifier of an individual or corporate customer of a banking institution.
[0086] In an embodiment of the present application, after determining multiple feature item business rule expressions, operation expressions and data authority range expressions, the multiple feature item business rule expressions, operation expressions and data authority range expressions are combined together to obtain a business rule expression, which is also an SQL statement that can be executed to obtain data query results.
[0087] In an optional embodiment, a target data cube corresponding to multiple target preset tags is segmented using a business rule expression to generate a target customer group data cube, including: determining a data cube corresponding to each target preset tag; forming a target data cube from multiple data cubes corresponding to different target preset tags; and executing the business rule expression to segment the target data cube to generate a target customer group data cube.
[0088] Since each target preset label in the customer group statistics system corresponds to a data cube, and the data cube is used to represent the data corresponding to the target preset label, multiple target preset labels correspond to multiple data cubes, and the data corresponding to these data cubes constitute the target data cube. After determining the target data cube, the business data indicated in the business rule expression can be queried by executing the business rule expression to generate the target customer group data cube.
[0089] The calculation process of the business rule expression is: according to the data permission range expression, the data in the target data cube that meets the permission requirements is used as the data to be queried, and then multiple feature item business rule expressions are used to calculate these data to be queried to obtain multiple calculation results, and the multiple calculation results are calculated through the operation expression to generate the target customer group data cube.
[0090] In an optional embodiment, determining an operation expression and a data permission range expression includes: determining an operation expression based on a logical relationship between multiple different business condition group expressions; selecting a target data permission identifier from multiple candidate data permission identifiers; and generating a data permission range expression based on the target data permission identifier, the data permission range expression being an expression corresponding to a structured query statement.
[0091] The candidate data permission identifier may refer to an identifier of a selectable data permission, and the target data permission identifier is used to determine the data to be counted.
[0092] Exemplarily, the candidate data authority identifiers may be institution names corresponding to different banking institutions, or may be region names of different administrative regions.
[0093] Specifically, if the expressions of different business condition groups are in a logical and relationship, the operation expression can be a custom UDAF function for the union operation. When determining the data permission range expression, the user can select the target data permission identifier corresponding to the statistical data in the interface. For example, for banking business, the target data permission identifier can be a branch of AAA bank. For regions, the target data permission identifier can be the name of the region of BBB. After determining the target data permission identifier, a data permission range expression can be formed for this data permission identifier. The data permission range expression can be an SQL statement with in as the keyword, indicating which range of data is selected.
[0094] Step S105, performing statistics on the target customer group data cube to generate statistical results of the target customer group.
[0095] In this step, the data corresponding to the target customer group data cube is substituted into the statistical interface of the system to count the number of target customers. Taking the statistics of the number of customers of a specific customer group of a banking institution as an example, assuming that this specific customer group is a male customer group who is on the job, then the employment status and gender are the labels for the selected customer group. Therefore, the user can select the two labels of employment status and gender from the candidate preset labels as the target preset labels, and select the screening conditions of employment status equal to on the job and gender equal to male for these two labels. The customer group statistics system will automatically determine the business condition expressions corresponding to the two target preset labels. The two business condition expressions are employment status equal to on the job and gender equal to male. Then, the customer group screening rules are obtained from these two business condition expressions.
[0096] The customer statistics system can determine the query template corresponding to the business condition expression, and combine the query template with the business condition expression to obtain the characteristic item business rule expression, and then combine the characteristic item business rule expression with the data authority range expression and the operation expression to obtain the business rule expression. The business rule expression is used to segment the target data cube to obtain the target customer data cube, and the customer population statistics of the target customer data cube are performed through the statistical interface.
[0097] It can be seen that the entire target customer group counting process does not require technical support from IT technicians. The staff can complete the target customer group counting by simply selecting target preset labels, business conditions, and business thresholds.
[0098] Compared with the customer data statistics method in the prior art, the present application can directly select multiple target preset tags corresponding to the target customer group, and obtain the customer group screening rules according to the business condition expressions corresponding to the multiple target preset tags. The customer group screening rules can locate the target customer group, and then convert the customer group screening rules into business rule expressions, and use the business rule expressions to obtain the data statistics results of the target customer group. There is no need for IT technicians to develop codes for the target customer group, which solves the problem of low data statistics efficiency for specific customer groups. At the same time, after determining the target customer group data cube, customer group portrait analysis can also be performed on the target customer group data cube to generate customer group portraits under different dimensions.
[0099] Based on the same inventive concept, a customer data statistics device corresponding to the customer data statistics method is also provided in the embodiment of the present application. Since the principle of solving the problem by the device in the embodiment of the present application is similar to the above-mentioned customer data statistics method in the embodiment of the present application, the implementation of the device can refer to the implementation of the method, and the repeated parts will not be repeated.
[0100] See also Figure 2 , Figure 2 This is a schematic diagram of the structure of a customer group data statistics device provided in an embodiment of the present application. Figure 2 As shown in , the customer group data statistics device 200 includes:
[0101] The category determination module 201 is used to determine a plurality of target label categories corresponding to the target customer group to be counted;
[0102] The tag group generation module 202 is used to select multiple target preset tags corresponding to the target customer group from multiple candidate preset tags under different target tag categories, and divide the multiple target preset tags into different target preset tag groups;
[0103] A screening rule determination module 203 is used to determine a business condition expression corresponding to each target preset tag, wherein at least one business condition expression constitutes a business condition group expression, and a customer group screening rule is determined based on all business condition group expressions;
[0104] The customer group cube generation module 204 is used to determine the business rule expression corresponding to the customer group screening rule, and use the business rule expression to segment the target data cube corresponding to multiple target preset tags to generate the target customer group data cube;
[0105] The data statistics module 205 is used to perform statistics on the target customer group data cube and generate statistical results of the target customer group.
[0106] See also Figure 3 , Figure 3This is a schematic diagram of the structure of an electronic device provided in an embodiment of the present application. Figure 3 As shown in , the electronic device 300 includes a processor 310 , a memory 320 and a bus 330 .
[0107] The memory 320 stores machine-readable instructions executable by the processor 310. When the electronic device 300 is running, the processor 310 communicates with the memory 320 via the bus 330. When the machine-readable instructions are executed by the processor 310, the above-mentioned Figure 1 The specific implementation of the steps of the customer group data statistics method in the method embodiment shown can be found in the method embodiment, and will not be repeated here.
[0108] The present application also provides a computer-readable storage medium on which a computer program is stored. When the computer program is executed by a processor, the computer program can execute the above-mentioned Figure 1 The specific implementation of the steps of the customer group data statistics method in the method embodiment shown can be found in the method embodiment, and will not be repeated here.
[0109] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.
[0110] In the several embodiments provided in the present application, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. The device embodiments described above are merely schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some communication interfaces, and the indirect coupling or communication connection of devices or units can be electrical, mechanical or other forms.
[0111] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0112] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.
[0113] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a non-volatile computer-readable storage medium that is executable by a processor. Based on this understanding, the technical solution of the present application can essentially or in other words, the part that contributes to the prior art or the part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: various media that can store program codes, such as a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk.
[0114] Finally, it should be noted that the above-described embodiments are only specific implementation methods of the present application, which are used to illustrate the technical solutions of the present application, rather than to limit them. The protection scope of the present application is not limited thereto. Although the present application is described in detail with reference to the above-mentioned embodiments, ordinary technicians in the field should understand that any technician familiar with the technical field can still modify the technical solutions recorded in the above-mentioned embodiments within the technical scope disclosed in the present application, or can easily think of changes, or make equivalent replacements for some of the technical features therein; and these modifications, changes or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present application, and should be included in the protection scope of the present application. Therefore, the protection scope of the present application shall be based on the protection scope of the claims.
Claims
1. A customer group data statistics method, characterized in that: include: For the target customer group to be counted, determining a plurality of target tag categories for selecting the target customer group; Selecting multiple target preset tags corresponding to the characteristics of the target customer group from multiple candidate preset tags under different target tag categories, and dividing the multiple target preset tags into different target preset tag groups; Determine the business condition expression corresponding to each target preset tag, form a business condition group expression from at least one business condition expression, and determine the customer group screening rule based on all business condition group expressions; Determine the business rule expression corresponding to the customer group screening rule according to the query template, operation expression and data authority range expression corresponding to each business condition expression, and use the business rule expression to segment the target data cube corresponding to multiple target preset tags to generate the target customer group data cube; Performing statistics on the target customer group data cube to generate statistical results of the target customer group; The step of using the business rule expression to segment the target data cubes corresponding to the plurality of target preset tags to generate the target customer group data cubes includes: Constructing a data cube corresponding to each target preset label, wherein the data cube is a multidimensional data model constructed based on the original data; A target data cube is composed of multiple data cubes corresponding to different target preset labels; The business rule expression is executed to segment the target data cube to generate data cubes of the target customer group.
2. The method according to claim 1, characterized in that The step of selecting a plurality of target preset tags corresponding to the target customer group from a plurality of candidate preset tags under different target tag categories and dividing the plurality of target preset tags into different target preset tag groups includes: For each target tag category, determining at least one target preset tag from a plurality of candidate preset tags under the target tag category; For each target preset label group, determining the intra-group logical relationship between different target preset labels in the target preset label group; According to the intra-group logical relationship, at least one target preset label is combined together to obtain a target preset label group.
3. The method according to claim 1, characterized in that The determining of the business condition expression corresponding to each target preset tag includes: For each target preset tag corresponding to the target customer group, determine the tag name, business conditions and business threshold of the target preset tag; The business condition expression corresponding to the target preset tag is obtained according to the tag name, business condition and business threshold of the target preset tag.
4. The method according to claim 1, characterized in that: The at least one business condition expression is used to form a business condition group expression, and the customer group screening rule is determined based on all business condition group expressions, including: The business condition group expression is composed of the business condition expressions corresponding to all target preset tags under the same target preset tag group; Determine the logical relationship between different business condition group expressions; According to the logical relationship between different business condition group expressions, all business condition group expressions are combined together to form customer group screening rules.
5. The method according to claim 1, characterized in that The determining of the business rule expression corresponding to the customer group screening rule includes: For each business condition expression in the customer group screening rule, determine a query template corresponding to the business condition expression, combine the query template with the business condition expression, and obtain a feature item business rule expression corresponding to the business condition expression; Determine the operation expression and data permission range expression; A business rule expression is formed by combining multiple feature item business rule expressions, operation expressions and data authority range expressions.
6. The method according to claim 5, characterized in that The determination operation expression and data authority range expression include: Determine the operation expression according to the logical relationship between multiple different business condition group expressions; Select a target data permission identifier from multiple candidate data permission identifiers; A data permission range expression is generated based on the target data permission identifier, and the data permission range expression is an expression corresponding to the structured query statement.
7. A customer group data statistics device, characterized in that: include: A category determination module, used for determining, for a target customer group to be counted, a plurality of target label categories for selecting the target customer group; A label group generating module, used to select a plurality of target preset labels corresponding to the characteristics of the target customer group from a plurality of candidate preset labels under different target label categories, and divide the plurality of target preset labels into different target preset label groups; A screening rule determination module is used to determine the business condition expression corresponding to each target preset tag, wherein at least one business condition expression constitutes a business condition group expression, and a customer group screening rule is determined based on all business condition group expressions; A customer group cube generation module is used to determine the business rule expression corresponding to the customer group screening rule according to the query template, operation expression and data authority range expression corresponding to each business condition expression, and use the business rule expression to segment the target data cube corresponding to multiple target preset tags to generate a target customer group data cube; A data statistics module, used to perform statistics on the target customer group data cube and generate statistical results of the target customer group; The customer group cube generation module is specifically used for: Constructing a data cube corresponding to each target preset label, wherein the data cube is a multidimensional data model constructed based on the original data; A target data cube is composed of multiple data cubes corresponding to different target preset labels; The business rule expression is executed to segment the target data cube to generate data cubes of the target customer group.
8. An electronic device, characterized in that: include: A processor, a storage medium and a bus, wherein the storage medium stores machine-readable instructions executable by the processor. When the electronic device is running, the processor communicates with the storage medium via the bus, and the processor executes the machine-readable instructions to perform the steps of the customer data statistics method as described in any one of claims 1 to 6.
9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the customer group data statistics method according to any one of claims 1 to 6 are executed.
